select

proposal_id,

min(vote_timestamp) as date

from ethereum.core.ez_snapshot

group by 1

),

first_activity_r as (

select

proposal,

min(block_timestamp) as date

from solana.core.fact_proposal_votes

where succeeded = 'TRUE' and governance_platform = 'realms'

group by 1

)

select

date_trunc('week', date) as date,

'Snapshot' as type,

count(distinct proposal_id) as proposal_count

from first_activity_s

group by 1

union

select

date_trunc('week', date) as date,

'Realms' as type,

count(distinct proposal) as proposal_count

from first_activity_r

group by 1