boomer77sol failed tx
Updated 2023-04-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('hour', block_timestamp) as dt,
case when succeeded = 'false' then 'Failed'
when succeeded = 'true' then 'Successful'
end as status,
avg(fee/1e9) as avg_fees,
sum(fee/1e9) as total_fees,
count(distinct tx_id) as tx
from solana.core.fact_transactions
where date(block_timestamp) >= current_date - 8
group by 1,2
Run a query to Download Data