alleria[Solana] Vote! Main
Updated 2022-02-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH
votes as (
SELECT
a.block_id,
a.block_timestamp,
date_trunc('hour', a.block_timestamp) as hourly,
tx_count,
num_votes,
num_votes / tx_count as ratio
FROM solana.blocks a
INNER JOIN solana.votes_block_agg b ON (a.block_id = b.block_id)
WHERE a.block_timestamp >= '2022-02-01'
ORDER BY a.block_id DESC
)
SELECT
'Vote Transactions' as category,
sum(num_votes) as total_votes
FROM votes
UNION ALL
SELECT
'Non-votes Transactions' as category,
sum(tx_count) - sum(num_votes) as total_non_votes
FROM votes
Run a query to Download Data