Hadisehpoly 4
Updated 2022-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select 'Ethereum' as blockchain ,
avg(TX_COUNT) as tx_average from ethereum.core.fact_blocks
where block_timestamp::date >= '2022-06-01' group by 1
UNION
select 'Polygon' as blockchain ,
avg(TX_COUNT) as tx_average from polygon.core.fact_blocks
where block_timestamp::date >= '2022-06-01' group by 1
UNION
select 'Solana' as blockchain ,
avg(TX_COUNT) as tx_average from solana.core.fact_blocks
where block_timestamp::date >= '2022-06-01' group by 1
UNION
select 'Arbitrum' as blockchain ,
avg(TX_COUNT) as tx_average from arbitrum.core.fact_blocks
where block_timestamp::date >= '2022-06-01' group by 1
Run a query to Download Data