binhachonMonkeDAO Vote - No voters with their buying time
    Updated 2022-04-06
    with voter_data as (
    select
    instructions[0]:accounts[0] as acct_0,
    instructions[0]:data as data,
    'Yes' 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 = 'Yjf5DvKUCfa2bPkYz4AiWs'
    group by 1, 2
    union all
    select
    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
    ),
    NFT_metadata as (
    select
    distinct mint
    from solana.dim_nft_metadata
    where contract_name = 'Solana Monkey Business'
    and mint is not null
    ),
    NFT_market_transaction as (
    select
    Run a query to Download Data