SELECT

vote_timestamp as block_time,

voter as address,

array_to_string((vote_option), '') as vote,

case when vote = 1 then 'In-Favor'

when vote = 2 then 'Against' end as choice,

voting_power as "$APE Voted"

FROM ethereum.core.ez_snapshot

WHERE "SPACE_ID" = 'apecoin.eth'

AND proposal_id = '0x2485aa565a28902bd33bbba1f91e9c7b66cf34010bd25c4bef82cd8e341071d8'

ORDER BY vote_timestamp DESC