nitsUntitled Query
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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