Updated 2022-03-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tbl as ( select count(*)/(24*60*60) as TPS, block_timestamp::date as date
from solana.events
where succeeded = TRUE and
block_timestamp::date >='2022-02-01'
and block_timestamp::date != CURRENT_DATE
AND tx_id not in (select tx_id
from solana.events
where succeeded = TRUE and
block_timestamp::date >='2022-02-01'
and block_timestamp::date != CURRENT_DATE
AND INSTRUCTION:program ='vote')
Group by date
order by date)
Run a query to Download Data