Abolfazl_771025total comparing Realms vs Snapshot
Updated 2022-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with realm as (
select
count (distinct voter) as "voters #",
count (distinct tx_id) as "votes #",
count (distinct proposal) as "proposals #",
count (distinct realms_id) as "daos #"
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
),snapshot as (
select
count (distinct voter) as "voters #",
count (distinct id) as "votes #",
count (distinct proposal_id) as "proposals #",
count (distinct space_id) as "daos #"
from ethereum.core.ez_snapshot
)
select
'Realms' as "platform",
*
from realm
union
select
'Snapshot' as "platform",
*
from snapshot
Run a query to Download Data