hessHourly Success
Updated 2022-10-16
9
1
2
3
4
5
6
7
8
9
›
⌄
select 'Success' as type, trunc(block_timestamp,'hour') as hourly , count(DISTINCT(tx_hash)) as total_tx
from gnosis.core.fact_transactions
where STATUS = 'SUCCESS' and block_timestamp::date between '2022-10-04' and '2022-10-08'
group by 1,2
UNION
select 'FAILED' as type, trunc(block_timestamp,'hour') as hourly , count(DISTINCT(tx_hash)) as total_tx
from gnosis.core.fact_transactions
where STATUS = 'FAIL' and block_timestamp::date between '2022-10-04' and '2022-10-08'
group by 1,2
Run a query to Download Data