superflyUntitled Query
Updated 2022-09-23
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
26
27
›
⌄
with all_DAOs_snapshot as (
select
date_trunc('week', vote_timestamp) as date,
count(DISTINCT SPACE_ID) as snapshot_DAOs
from
ethereum.core.ez_snapshot
group by
date
),
all_DAOs_realms as (
select
date_trunc('week', block_timestamp) as date0,
count(DISTINCT REALMS_ID) as realms_DAOs
from
solana.core.fact_proposal_votes
where
GOVERNANCE_PLATFORM ilike 'realms'
group by
date0
)
select
date,
snapshot_DAOs,
realms_DAOs
from
all_DAOs_snapshot
join all_DAOs_realms on date = date0
Run a query to Download Data