raw as (

select

proposal_id,

min(proposal_start_time) as "Proposal creation date"

from ethereum.core.ez_snapshot

group by 1

),

raw2 as(

count (DISTINCT proposal_id)

from raw

),

raw3 as (

SELECT

DISTINCT

proposal,

-- voter,

max(block_timestamp::date) as latest_day,

min(block_timestamp::date) as "Proposal creation date"

--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

),

raw4 as(

count (DISTINCT proposal) as "New proposal per day"