raw as (

SELECT

DISTINCT

voter,

-- voter,

max(block_timestamp::date) as latest_day,

min(block_timestamp::date) as first_day

--count(distinct proposal) as tx_proposal

FROM solana.core.fact_proposal_votes a

join solana.core.dim_labels b on b.address=a.program_name

WHERE governance_platform='realms'

AND succeeded='TRUE'

group by 1

),

raw2 as(

first_day ,

count(*) as "New voters per day"

from raw

where first_day>='2021-10-01'

group by 1

),

raw3 as (

select

voter,

min(proposal_start_time) as first_day

from ethereum.core.ez_snapshot

group by 1

),