flipside

    daily vote and voter
    elsinadaily vote and voter
    Updated 2022-11-23
    select
    block_timestamp::date as date,
    count(distinct tx_id) as vote_count,
    count(distinct voter) as unique_voter
    from osmosis.core.fact_governance_votes
    where
    tx_status = 'SUCCEEDED' and
    proposal_id ='362'
    group by 1
    Run a query to Download Data