Popex404Daily Metrics 3612
    Updated 2023-01-26
    select
    date_trunc('d',block_timestamp) as "Date",
    count(distinct tx_id) as "Votes",
    count(DISTINCT VOTER) as "Voters",
    sum("Votes") over (order by "Date") as "Cumulative Votes",
    sum("Voters") over (order by "Date") as "Cumulative Voters"
    from terra.core.fact_governance_votes
    where proposal_id = 3612
    group by 1
    Run a query to Download Data