select

block_timestamp::date as date ,

count(distinct voter) as daily_voters,

count(distinct tx_id) as daily_vote ,

count(distinct PROPOSAL) as daily_proposal ,

(select count(distinct signers[0]) from solana.core.fact_transactions where block_timestamp::date >= '2021-12-01' ) as all_users

--(daily_voters/all_users)*100 as ratio

from solana.core.fact_proposal_votes

where GOVERNANCE_PLATFORM = 'realms'

and block_timestamp::date >= '2021-12-01'

and succeeded = 'TRUE'

group by 1

),

solana_cum as (

select date ,sum(daily_voters) over (order by date)as voters_cumulative ,

sum(daily_vote) over (order by date)as vote_cumulative ,

sum(daily_proposal) over (order by date)as proposal_cumulative

from solana

--group by 1

order by 1

),

ethereum_ss as (

select

vote_timestamp::date as date ,

count (distinct voter) as daily_voters,

count (distinct PROPOSAL_ID) as daily_proposal,

count (distinct id) as daily_vote,

(select count(distinct from_address) from ethereum.core.fact_transactions where block_timestamp::date >= '2015-08-07' ) as all_users

--(daily_voters/all_users)*100 as ratio

from ethereum.core.ez_snapshot

where NETWORK = 'Ethereum Mainnet'

and VOTE_TIMESTAMP::date >= '2015-08-07'