MLDZMNSol6
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with seconds_tps as (
SELECT
date_trunc('second',block_timestamp) seconds,
count(tx_id) tps
from Solana.fact_transactions
where block_timestamp >= CURRENT_DATE-60
group by 1)
select
'Solana' as Blockchain,
date_trunc('day', seconds) "day",
max(tps) max_tps
from seconds_tps
group by 1,2
Run a query to Download Data