snowmanUntitled Query
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc("DAY", block_timestamp::date) as day
, count(tx_id) as tx_counts
, count_if(succeeded = 'TRUE') as success
, count_if(succeeded = 'FALSE') as failure
, success / tx_counts as success_rate
, failure / tx_counts as failure_rate
from solana.core.fact_transactions
where block_timestamp::date > '2022-05-01'
and block_timestamp::date < '2022-06-01'
group by 1
order by 1 asc
Run a query to Download Data