boomer77solana tps
Updated 2022-02-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with raw as (select date_trunc('second', block_timestamp) as dt, count(distinct tx_id) as tps
from solana.transactions
where date(block_timestamp) >= '2022-02-01' and succeeded = 'TRUE'
group by 1)
select date_trunc('hour', dt) as hourly, max(tps) as max_tps, min(tps) as min_tps, avg(tps) avg_tps, sum(tps) as total_tx, (max_tps-min_tps) as tps_volatility
from raw
group by 1
Run a query to Download Data