binhachonMonkeDAO Vote - No voters with their transactions
    Updated 2022-04-06
    with voter_data as (
    select
    block_timestamp,
    instructions[0]:accounts[0] as acct_0,
    instructions[0]:data as data,
    'No' as vote,
    SUM(ARRAY_SIZE(inner_instructions)) AS total_votes
    from solana.fact_transactions
    where block_timestamp <= '2022-03-05'
    and block_timestamp >= '2022-02-15'
    and succeeded = 'True'
    and instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci'
    and data = 'Yjf5DvKUCfa2Rh5YBEg7FM'
    group by 1, 2, 3
    ),
    NFT_metadata as (
    select
    distinct mint
    from solana.dim_nft_metadata
    where contract_name = 'Solana Monkey Business'
    and mint is not null
    )
    select * from solana.nfts
    where mint in (select mint from NFT_metadata)
    and posttokenbalances[0]:owner::string in (select acct_0 from voter_data)
    order by block_timestamp desc
    Run a query to Download Data