eslamis-darkatrate
Updated 2022-09-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
'ethereum' as chain
, date_trunc('hour', block_timestamp) as date
, count(*) as tx_count
, count(CASE WHEN status <> 'SUCCESS' THEN 1 END) as fail_tx_count
FROM ethereum.core.fact_transactions
WHERE block_timestamp::date >= '2022-09-15 06:00:00.000'
AND block_timestamp::date < CURRENT_DATE
GROUP BY date
order by date
Run a query to Download Data