Alexayusers %
Updated 2022-08-31Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with eth_table as ( select distinct from_address from ethereum.core.fact_transactions union all
select distinct from_address from avalanche.core.fact_transactions union all
select distinct from_address from arbitrum.core.fact_transactions union all
select distinct from_address from gnosis.core.fact_transactions union all
select distinct from_address from optimism.core.fact_transactions union all
select distinct from_address from bsc.core.fact_transactions union all
select distinct from_address from polygon.core.fact_transactions),
eth_user as ( select count (distinct from_address) as eth_users from eth_table),
snap_user as ( select count (distinct voter) as snap_users from ethereum.core.ez_snapshot),
sol_user as ( select count (distinct signers[0]) as sol_users from solana.core.fact_transactions),
realms_user as ( select count (distinct voter) as realms_users from solana.core.fact_proposal_votes
where governance_platform = 'realms')
select 'Snapshot' as platform, 100*(snap_users/eth_users) from snap_user, eth_user
UNION
select 'Realms' as platform, 100*(realms_users/sol_users) from realms_user, sol_user
Run a query to Download Data