superflyUntitled Query
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc("DAY", block_timestamp::date) as DATES,
count(tx_id) as tx_counts,
count_if(succeeded = 'TRUE') as success, --Successful transactions
count_if(succeeded = 'FALSE') as failure, --Unsuccessful transactions
success / tx_counts as success_rate, --Amount of fee paid
failure / tx_counts as failure_rate --Amount of fee paid
from solana.core.fact_transactions --Special table for transactions
WHERE block_timestamp::date between '2022-01-01' and '2022-07-13' --Date from the beginning of the year
group by 1
order by 1 asc
Run a query to Download Data