MeirStakeDAO Snapshot
    Updated 2024-04-17
    SELECT
    PROPOSAL_ID,
    PROPOSAL_START_TIME,
    PROPOSAL_END_TIME,
    PROPOSAL_TITLE,
    PROPOSAL_AUTHOR,
    VOTE_OPTION,
    VOTING_POWER,
    VOTE_TIMESTAMP,
    QUORUM,
    CHOICES,
    VOTING_PERIOD,
    NETWORK,
    SPACE_ID,
    VOTER,
    ADDRESS_NAME,
    LABEL_TYPE,
    LABEL_SUBTYPE,
    LABEL
    FROM external.snapshot.ez_snapshot as SNAPSHOT
    LEFT JOIN ethereum.core.dim_labels LABELS
    ON SNAPSHOT.VOTER = LABELS.ADDRESS
    WHERE SPACE_ID = 'sdcrv.eth'
    -- AND PROPOSAL_TITLE LIKE 'Gauge Weight%'
    AND VOTE_TIMESTAMP > '2022-12-20 00:00:00.000'
    LIMIT 10000
    QueryRunArchived: QueryRun has been archived