headitmanagersolana_vote-block-1
Updated 2022-02-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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