nitsUntitled Query
    Updated 2022-06-06
    with txs as
    (SELECT min, count(*) as total_txs, avg(total_txs ) over (order by min) as avg_txs, 'all' as type from
    (SELECT trunc(block_timestamp, 'minute') as min, * from ethereum.core.fact_transactions
    where date(block_timestamp)>= '2022-05-09')
    GROUP by 1 ),
    success_txs as
    (SELECT min, count(*) as total_txs, avg(total_txs ) over (order by min) as avg_txs, 'success' as type from
    (SELECT trunc(block_timestamp, 'minute') as min, * from ethereum.core.fact_transactions
    where date(block_timestamp)>= '2022-05-09' and status = 'SUCCESS')
    GROUP by 1 )

    SELECT * from txs
    UNION ALL
    SELECT * from success_txs
    -- limit 100
    Run a query to Download Data