Migrate and Update information from Dune analytics

[divine-comedian]

dune v1 scripts are set to stop working in the next few weeks as part of the upgrade to dune v2 analytics -

found this from a friend in the TEC:

This dashboard has lots of out of date or irrelevant data anyway:
https://dune.com/metacrypto/giveconomy

We'll need to cherry pick the stats we want to keep and then figure out how to migrate or re-capture the data in this new dashboard. We should also consider any new GIVeconomy related data we'll want to find a way to track - but I'll put this in a separate issue.

I know @clara-zi was investigating dune and this dashboard so please contribute to this issue with your observations.

Things I think we'll need to migrate:

General GIV token things

• GIV total supply
• GIV circulating supply (Mainnet & Gnosis Chain separately)
• GIV trading volume on Mainnet & Gnosis Chain separately
• GIV Buy and Sell pressure on Mainnet & Gnosis Chain separately

GIVgarden

• GIV staked in GIVgarden
• GIV staked in GIVgarden growth
• wrapped GIV (gGIV) total supply
• wrapped GIV (gGIV) total support (# of GIV staked on proposals)
• wrapped GIV supporting (% of gGIV staked on proposals vs. total supply of gGIV)

[clara-zi]

v1 to v2 migration means updating query lang. to sparkSQL. This means renaming data tables as they've changed naming conventions, formats.
Some structures will probably be ok but the task will be to go through each line, checking what the differences are in v2 sparksql code.

fyi - it looks like you can get a Dune API if we wanted to display Dune dashboard alongside other offchain info

@Santigs - fyi this was the issue I was talking about.

also tagging @mendesfabio - can you assist upgrading queries to v2 - not all queries will need to updated, as some data in the dashboard is no longer required.

[divine-comedian]

I also suggested it would be awesome if @RamRamez could spend some time learning how dune works. He'll be checking it out when he has time.

[mendesfabio]

First of all, Dune V1 won't stop working in the next few weeks.

I have so much going on that I forgot we migrated some queries to V2 months ago and submitted the contracts for decoding - as you can see on the V2 engine. I also secured the Giveth handler at Dune to move the dashboard from my own account.

I just want to highlight that there's no need to rush on migrating the queries. You're wondering how to perform the migration when should be wondering which charts/data you want to have there.

FWIW regarding the API, I wouldn't count on that because I'm not sure Giveth will pay for it.

[oyealmond]

@divine-comedian can we close this issue as well?