MLDZMNrealms2
    Updated 2022-08-16
    select
    BLOCK_TIMESTAMP::date as day,
    count(distinct REALMS_ID) as DAO_count,
    count(distinct TX_ID) as vote_count,
    count(distinct VOTER) as distinct_voter,
    sum(vote_count) over (order by day) as cum_vote_count
    from solana.core.fact_proposal_votes
    where GOVERNANCE_PLATFORM='realms'
    and SUCCEEDED='TRUE'
    group by 1
    Run a query to Download Data