gokcinUntitled Query
    Updated 2022-09-07
    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