select date_trunc (month,vote_timestamp) monthly,

count (distinct voter) num_voters,

sum (num_voters) over (order by monthly) cum_voters,

count (distinct id) num_votes,

sum (num_votes) over (order by monthly) cum_votes,

count (distinct proposal_id) num_proposals,

sum (num_proposals) over (order by monthly) cum_proposals,

count (distinct space_id) num_DAO,

sum (num_DAO) over (order by monthly) cum_DAO

from ethereum.core.ez_snapshot

group by 1

),

realm as (

select date_trunc (month,block_timestamp) monthly,

count (distinct voter) num_voters,

sum (num_voters) over (order by monthly) cum_voters,

count (distinct tx_id) num_votes,

sum (num_votes) over (order by monthly) cum_votes,

count (distinct proposal) as num_proposals,

sum (num_proposals) over (order by monthly) cum_proposals,

count (distinct realms_id) as num_DAO,

sum (num_DAO) over (order by monthly) cum_DAO

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by 1),

all_ as (

select 'Snapshot' type , monthly , num_voters,cum_voters , num_votes , cum_votes , num_proposals , cum_proposals , num_DAO , cum_DAO from SnapShot

UNION

select 'Realms' type , monthly , num_voters,cum_voters , num_votes , cum_votes , num_proposals , cum_proposals , num_DAO , cum_DAO from realm

select * from all_