Capital allocator wishlist

[ccerv1]

• clr.fund (all rounds)
• Giveth
• Ethereum Foundation
• Arbitrum Foundation (additional programs)
• Octant (recent epochs)
• Optimism Gov Grants (additional programs)
• Futarchy experiments

[owocki]

cc @cristinalare

As an administrator of allo.expert, I want to turn allo.expert into a "google trends" for capital allocation.

How:

1. for each of the mechanisms on the site [see here], i would like to have weekly data of how muchn volume they are moving
2. @cristinalare and i to expost an endpoint at api.allo.expert/oso-post which accepts the following params mechanism-slug and encoded_data.
3. the format of endoded data is a hashmap of the last 12 weeks of volume, as measured in usd.

on the frontend, @larecristina, we will have to find a way to display this data. perhaps

1. one chart comiparing the top 5 mechanisms trendlines at the top of landing page
2. with a button for "see more data" that takes you to a data page which shows you the rising/falling mechanisms
3. on each /mechanism/mechanism-slug page we also show the trendline of the data

[ccerv1]

Basically, we want an API version of this type of query:

select
  date_trunc(time, MONTH) as month,
  from_project_id,
  sum(round(amount)) as total_usd
from `oso.int_oss_funding_grants_to_project`
group by 1,2

Separately, we need some mapping of from_project_id to different allocation mechanisms. (Or another field in the event stream that captures this)