Updated 2022-09-24
    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