2844NEAR-The number of TX per Block- avg/min/max
Updated 2023-02-19
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with avax as (
select 'AVAX' as Network,
(BLOCK_NUMBER),
--BLOCK_TIMESTAMP,
count(TX_HASH) as TPB
from avalanche.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2023-02-05'
GROUP by 1,2
order by BLOCK_NUMBER asc
),
NEAR as (
select 'NEAR' as Network ,
(BLOCK_ID),
--BLOCK_TIMESTAMP,
count (TX_HASH) as TPB
from near.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2023-02-05'
GROUP by 1,2
order by BLOCK_ID asc
),
polygon as (
select 'Polygon' as Network,
(BLOCK_NUMBER),
--BLOCK_TIMESTAMP,
count (TX_HASH) as TPB
from polygon.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2023-02-05'
GROUP by 1,2
order by BLOCK_NUMBER asc
),
osmosis as (
Run a query to Download Data