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