RamaharLilNouns Voters Trend
    Updated 2022-06-18
    with T1 as (select
    m.block_timestamp,
    m.tx_hash,
    m.event_type,
    m.nft_address,
    m.tokenid,
    m.nft_count,
    n.from_address as minters
    from ethereum.core.ez_nft_mints m
    left join ethereum.core.fact_transactions n ON m.tx_hash = n.tx_hash
    where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b' ),

    votingdetails as (select
    DATE(block_timestamp) as dayz,
    event_inputs:proposalId::float as proposal,
    event_inputs:voter::string as voters,
    event_inputs:votes::float as vote_counts
    from ethereum.core.fact_event_logs
    where
    contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    and event_name = 'VoteCast'
    and tx_status = 'SUCCESS'),

    T2 as (select
    minters,
    sum(nft_count) as LilNounsAmount --wallets minted Lil Nouns amount
    from T1
    group by 1
    order by 2 DESC ),

    T3 as (select
    minters,
    LilNounsAmount,
    proposal,
    vote_counts
    from T2
    Run a query to Download Data