LTirrell2023-04-10 06:29 PM
Updated 2023-04-10
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
27
28
›
⌄
select
count(DISTINCT tx_id) as num_tx,
sum(fee) as total_fees,
case
when fee = 5000 then '01. normal'
when fee = 10000 then '02. 2x sig'
when fee = 15000 then '03. 3x sig'
when fee = 20000 then '04. 4x sig'
when fee = 25000 then '05. 5x sig'
when fee = 30000 then '06. 6x sig'
when fee = 35000 then '07. 7x sig'
when fee = 40000 then '08. 8x sig'
when fee = 45000 then '09. 9x sig'
when fee = 50000 then '10. 10x sig'
when fee = 55000 then '11. 11x sig'
when fee = 60000 then '12. 12x sig'
when fee = 65000 then '13. 13x sig'
when fee = 70000 then '14. 14x sig'
when fee = 75000 then '15. 15x sig'
else '16. priority fee'
end as fee_type
from
solana.core.fact_transactions
where
block_timestamp :: date between current_date - 8
and current_date - 1
group by
fee_type
Run a query to Download Data