Alexayoverall_stats
Updated 2022-08-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with snapshot as ( select 'Snapshot' as platform, 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),
realms as ( select 'Realms' as platform, 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')
select * from snapshot
Union ALL
select * from realms
Run a query to Download Data