KaskoazulAverage Vote/Non-vote TX per block per hour
Updated 2022-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
date_trunc('HOUR', v.block_timestamp) as FECHA,
count(v.block_id) as Blocks_per_hour,
sum(v.num_votes) as Total_Vote_tx_per_hour,
sum(b.tx_count) as Total_tx_per_hour,
Total_tx_per_hour-Total_Vote_tx_per_hour as Total_Non_vote_tx_per_hour,
Total_Vote_tx_per_hour/Blocks_per_hour as AVG_vote_tx_per_block,
Total_Non_vote_tx_per_hour/Blocks_per_hour as AVG_non_vote_tx_per_block,
Total_tx_per_hour/Blocks_per_hour as AVG_tx_per_block,
Total_Vote_tx_per_hour/Total_Non_vote_tx_per_hour as Total_ratio_VNV,
Total_Vote_tx_per_hour/Total_tx_per_hour*100 as Percentage_Vote,
100-Percentage_Vote as Percentage_Non_vote
FROM
solana.votes_block_agg v
INNER JOIN solana.blocks b
ON v.block_id=b.block_id
WHERE
v.block_timestamp >= '2022-02-01' AND v.block_timestamp < '2022-02-14'
GROUP BY 1
ORDER BY 1
Run a query to Download Data