proposal_id,

min(vote_timestamp) as vt_time,

count(DISTINCT voter) as num_voters

FROM ethereum.core.ez_snapshot

WHERE space_id = 'aave.eth'

GROUP BY proposal_id

UNION

SELECT

proposal_id :: STRING AS proposal_id,

min(block_timestamp) as vt_time,

count(DISTINCT voter) as num_voters

FROM ethereum.aave.ez_votes

GROUP BY proposal_id

ORDER BY vt_time ASC