gokcinUntitled Query
Updated 2022-09-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with snapshot as (select date_trunc(month,vote_timestamp::date) as MONTH,
count (distinct id) as votes,
count (distinct voter) as voters,
count (distinct space_id) as DAOs,count (distinct proposal_id) as proposals
from ethereum.core.ez_snapshot
group by 1),
realms as (
select date_trunc(month,block_timestamp::date) as MONTH,
count (distinct tx_id) as votes,
count (distinct voter) as voters,
count (distinct realms_id) as DAOs,
count (distinct proposal) as Proposals
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
group by 1)
select 'Snapshot' as type, * from snapshot
Union ALL
select 'Realms' as type, * from realms
order by MONTH
Run a query to Download Data