headitmanagersolana_vote-block-1
    Updated 2022-02-13
    select solana.blocks.block_id as block_id ,solana.blocks.tx_count as number_of_transactions,
    solana.votes_block_agg.num_votes as number_of_vote,
    solana.blocks.tx_count-solana.votes_block_agg.num_votes as non_vote
    from solana.blocks inner join solana.votes_block_agg
    on solana.blocks.block_id=solana.votes_block_agg.block_id
    where date(solana.blocks.block_timestamp) >='2022-02-01'
    order by block_id
    limit 1000


    Run a query to Download Data