with snapshot as ( select VOTE_TIMESTAMP::date date, count (distinct id) as Votes, count (distinct voter) as "voters & users", count (distinct space_id) as DAOs,

count (distinct proposal_id) as Proposals

from ethereum.core.ez_snapshot group by 1),

realms as ( select BLOCK_TIMESTAMP::date date, count (distinct tx_id) as Votes, count (distinct voter) as "voters & users", 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 name , *

from snapshot Union ALL select 'Realms' as name, * from realms