WITH proposals AS (
SELECT
*
FROM
external.snapshot.fact_proposals
WHERE
space_id = 'stgdao.eth'
)
SELECT
vote_timestamp::date AS day,
COUNT(*) AS votes,
COUNT(DISTINCT voter) AS voters,
SUM(voting_power) AS voting_power
FROM
external.snapshot.fact_votes v
INNER JOIN proposals p ON p.proposal_id = v.proposal_id
GROUP BY 1