SELECT

voter,

vote_timestamp,

VOTE_OPTION,

proposal_id as pollid

FROM ethereum.core.ez_snapshot

WHERE "SPACE_ID" = 'apecoin.eth'

SELECT

voter,

1 as count,

count(distinct pollid) as polls_voted,

min(date_trunc('month',vote_timestamp)) as month,

min(date(vote_timestamp)) as first_vote,

max(date(vote_timestamp)) as last_vote,

datediff('day', first_vote, getdate()) as age_in_ape,

datediff('day', first_vote, last_vote) as active_days_in_ape,

datediff('day', last_vote, getdate()) as days_since_last_vote,

datediff('day', first_vote, last_vote) as days_first_last

FROM polls

GROUP BY 1

ORDER BY polls_voted DESC