flipside

    Total Unique Voters
    jkhuhnke11Total Unique Voters
    Updated 2023-05-13
    WITH props AS (
    -- On Chain
    SELECT
    distinct voter
    FROM ethereum.aave.ez_votes

    UNION

    -- Snapshot
    SELECT
    DISTINCT voter
    FROM ethereum.core.ez_snapshot
    WHERE space_id = 'aave.eth'
    )
    SELECT
    count(voter) as num_voter
    FROM props
    Run a query to Download Data