mucrypto2023-07-19 07:51 PM
    Updated 2023-07-19
    select
    date_trunc('month', proposal_start_time) as month,
    count(voter) as votes,
    -- sum(voter) as s_votes,
    sum(votes) over (order by month asc) as c_votes
    from ethereum.core.ez_snapshot
    where space_id = 'gal.eth'
    or space_id = 'project-galaxy.eth'
    group by 1

    -- select *
    -- -- distinct proposal_title,
    -- -- proposal_start_time
    -- from ethereum.core.ez_snapshot
    -- -- where space_id = 'gal.eth'
    -- -- or space_id = 'project-galaxy.eth'
    -- where proposal_title = '[Test] Project Galaxy Plugin'
    -- or proposal_title = '[Test]: Project Galaxy Plugin'
    Run a query to Download Data