Add Polygon zkEVM GIV information to dune dashboard - starting Sept 23

[laurenluz]

Add for Polygon zkEVM-specific:

• GIV Circulating Supply
• Unique GIV Holders and Stakers
• Liquidity in DEXs
• GIVpower from OP Mainnet
• Unique GIV Stakers

Need to update cumulative pieces:

• GIV Circulating Supply
• Giveth DAO GIV Holdings
• Locked in GIVstream
• % of Circulating Supply Held by the DAO
• Unique GIV Holders and Stakers (All Chains)
• GIVpower (All Chains)
• Percentage of staked GIV that is locked
• % of GIV Circulating Supply that is staked
• % of GIV Circulating Supply that is Locked
• % of GIV Circulating Supply that is locked for at least 6 more months
• History of locked GIV
• GIV Locked Now
• GIV Unlock Times
• USD Value of Locked GIV

[laurenluz]

cc @mohammadranjbarz @wmb81321

[laurenluz]

Hey @aminlatifi just a quick check in on this - do you know when you'll be able to do it?

[aminlatifi]

@laurenluz Do you know what's dao addresses on polygon?

[aminlatifi]

@laurenluz Do you know what's dao addresses on polygon?

Once we figured it out, must update https://dune.com/queries/4120081 and rerun the Giveth DAO GIV Holdings

[wmb81321]

@aminlatifi maybe this notion helps: https://www.notion.so/giveth/641e512e33124a249177f67ba4762044?v=86ba47af2a9a4927a68cf0a8fcbe5c7d

[aminlatifi]

@aminlatifi maybe this notion helps: https://www.notion.so/giveth/641e512e33124a249177f67ba4762044?v=86ba47af2a9a4927a68cf0a8fcbe5c7d

Developers mostly fill that doc, and the only address that can be related to DAO is multisig which has only about 3K GIV balance. @laurenluz do you confirm that's the DAO address on polygon zkevm?

[laurenluz]

@aminlatifi

1. Giveth main on zkevm: https://app.safe.global/home?safe=zkevm:0xaF4D68B8084b01D2c8120120497511035A2ea3a1
2. matching pool multisig on zkevm (though I think this still should count as "circulating): https://app.safe.global/settings/setup?safe=zkevm:0x92A0b50682F70Db0EB43D1b96a8bbC65fdeC22fE
3. liquidity multisig (holding DAO-owned liquidity on zkevm): https://app.safe.global/home?safe=zkevm:0xa1769a425EA1197f32d8C3e0fbE3F92EaDACC21A

[wmb81321]

Thank you @aminlatifi.

@laurenluz the Dune Dashboard query for Polygon ZKEVM non Circulating Supply (https://dune.com/queries/4117779) was updated and have following addreses:

Token Distro 0x4fB9B10ECDe1b048DBC79aBEAB3793edc93a0d54
Giveth Multisign 0xaF4D68B8084b01D2c8120120497511035A2ea3a1
Multisig Liquidity 0xa1769a425EA1197f32d8C3e0fbE3F92EaDACC21A
Matching Pool Multisig 0x92A0b50682F70Db0EB43D1b96a8bbC65fdeC22fE

@laurenluz form the last comment, im understanding that the matching pool Multisig is circulating supply, rigth? If yes, we should remove it from the query.