Query editor
-- This query maps current OP delegation weights for the Optimism Token House-- On Claim: User chooses delegate 'GovernanceToken_evt_DelegateChanged' from old 00000 to new, and thier voting power gets added to the total 'GovernanceToken_evt_DelegateVotesChanged'-- On Acquisition/Disposal: Voting power gets added/deducted from the delegate's total 'GovernanceToken_evt_DelegateVotesChanged'-- On redelegation: User changed deleate 'GovernanceToken_evt_DelegateChanged' from old to new, and voting power shifts from old to new in 'GovernanceToken_evt_DelegateVotesChanged'-- Delegate weight can change multiple times during a transaction (i.e. multi-hop DEX trade) - so we want to make sure we grab the last log of each transaction as "current"WITH address_names AS (SELECT address,name,ens FROM query_1802295), gs AS (SELECT * FROM (with seq as (SELECTsequence(cast( DATE_TRUNC('{{Time Granularity}}', cast('2022-01-01' as timestamp) ) as timestamp), cast( DATE_TRUNC('{{Time Granularity}}', NOW()) + interval '1' {{Time Granularity}} as timestamp),interval '1' {{Time Granularity}}) as time_pd)SELECTdays.time_pdsFROM seqCROSS JOIN unnest(time_pd) as days(time_pds) --this is just doing explode like in spark sql) gWHERE time_pds >= DATE_TRUNC('{{Time Granularity}}', cast('2022-01-01' as timestamp) ))-- , minted_op AS (-- SELECT-- dt,-- LEAD(dt, 1, DATE_TRUNC('{{Time Granularity}}',NOW()) + interval '1' {{Time Granularity}}) OVER (ORDER BY dt ASC) AS next_update,-- minted_dt, SUM(minted_dt) OVER (ORDER BY dt ASC) AS total_minted-- FROM (-- SELECT-- gs.time_pds AS dt,-- COALESCE( SUM(cast(value as double)/POWER(10,18)) , 0) AS minted_dt-- FROM gs-- LEFT JOIN erc20_optimism.evt_Transfer t-- ON DATE_TRUNC('{{Time Granularity}}',evt_block_time) = gs.time_pds-- WHERE "from" = 0x0000000000000000000000000000000000000000-- AND contract_address = 0x4200000000000000000000000000000000000042-- AND evt_block_time > cast( '2022-01-01' as date)-- GROUP BY 1-- ) a-- )--Delegated vs Undelegated, claimed_op AS (--Approximating how much OP has been distributed via Governance--Assuming: Governance Fund Wallet -> Project Wallet = Not Distributed OP-- Project Wallet -> ? = Distributed OP-- So we first see who the Governance Fund Wallet sent to, then look at when those wallets sent funds out-- WITH gov_recipients AS (-- SELECT to as project_address