jkhuhnke11New Voters on Osmosis Per Day
    Updated 2023-03-14
    WITH dates AS (
    SELECT
    voter,
    block_timestamp
    FROM osmosis.core.fact_governance_votes
    WHERE block_timestamp :: date >= '2021-06-18'
    qualify(ROW_NUMBER() over(PARTITION BY voter
    ORDER BY
    block_timestamp ASC)) = 1
    )
    SELECT
    block_timestamp :: date as day,
    count(distinct voter) as num_voters
    FROM dates
    GROUP BY day
    Run a query to Download Data