WITH props AS (
-- On Chain
SELECT
distinct voter
FROM ethereum.aave.ez_votes
WHERE block_timestamp :: date >= CURRENT_DATE - 90
UNION
-- Snapshot
SELECT
DISTINCT voter
FROM ethereum.core.ez_snapshot
WHERE space_id = 'aave.eth'
AND vote_timestamp :: date >= CURRENT_DATE - 90
)
SELECT
count(voter) as num_voter
FROM props