Second idea:
Create some bounties for Dune analytics because I think they are awesome tools and I want to see more of them (of the coop and in general)
We would need to think of a few, check with the guys at Dune to see if they are possible, and if they would like use to add others.
Some suggestions:
- Table / chart of weights for each token (Current, user determined date, possibly chart over time)
- LP farm sizes
- LP farm sizes and do they hold or sell the INDEX (current, or fixed date - 1 month after liquidity farming ends)
- Age distribution of DPI holders (how sticky is the DPI- ideally if we account for aDPI, yDPI etc)
- Charts of DPI composition over time ($USD basis)
- Bounty for the best original idea.
I would suggest that we give bounties for INDEX / DPI specific queries based on how hard we think they are, and add additional bounties to make generic versions of them (i.e. allow the user to input a date range and refresh, or add a different address and apply the query to other projects - basically kick start some open source innovation on Dune analytics).
I think we would need to work with the Dune guys to specify the queries, and possibly set some criteria so we don’t award everything to a single person (or is that no bad thing?). And maybe have some criteria for good coding practice / commenting to allow ease of forking.
Note, a lot of these queries would need to be forked and updated as we add tokens
Potential Benefits:
- Marketing awareness as we launch and reward the bounties.
- Help develop a public good for the Ethereum ecosystem (yes, I know Dune are a private company with VC’s, but I think more open source queries on dune helps everyone)
- Coop awareness as people see all the new queries on the coop dashboard.
- More information in include in future coop marketing
- The ability to measure more / new Coop KPI’s.
- Distribute some INDEX to different people
Suggested rewards:
Say we select:
- 8 basic INDEX queries,
- 6 user modifiable Queries (e.g. a fork that allows the user to set a start and end date),
- 4 more that allow the user to examine other wallets etc.
A total of 300 to 500 INDEX awarded with the majority allocated to the 8 Basic queries.
I did this figure in about half a day with No SQL experience, and the vast majority of the code was based on a fork, and about three major major hints from Mats in the Dune team (i.e. I explained what I wanted to do, and he forked and updated my code in seconds, then I scratched my head and looked at the next step…), so I suspect that some of the queries will be trivial to SQL experts.
Obviously it may be easier to just pay the Dune guys to write the queries, but where is the fun in that?
Edit:
A LP profitability chart: basically ((Uniswap income / pool size)/divergence loss) . That would be a really interesting chart to see. User inputs LP pair address and a start and end date.
Likely to cost more INDEX.
btw : @richard any thoughts?