zakkisyed#4 Nouns: Voting activity
    Updated 2022-07-04
    select t1.timeperiod,t1.tokenid, t2.proposal_id
    from
    (
    select date_trunc(day,block_timestamp) as timeperiod, tokenid
    from ethereum.core.ez_nft_mints
    where nft_address = lower('0x9C8fF314C9Bc7F6e59A9d9225Fb22946427eDC03')
    ) as t1
    INNER JOIN (

    select date_trunc(day,block_timestamp) as timeperiod,
    event_inputs:proposalId::number as proposal_id
    from ethereum.core.fact_event_logs
    where contract_address=lower('0x6f3E6272A167e8AcCb32072d08E0957F9c79223d')
    and event_name = 'VoteCast'
    group by 2,1
    order by 1 asc
    ) as t2
    ON t1.timeperiod=t2.timeperiod

    order by 3

    Run a query to Download Data