select

space_id,

min(vote_timestamp) as date

from ethereum.core.ez_snapshot

group by 1

),

first_activity_r as (

select

realms_id,

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 space_id) as dao_count

from first_activity_s

group by 1

union

select

date_trunc('week', date) as date,

'Realms' as type,

count(distinct realms_id) as dao_count

from first_activity_r

group by 1