headitmanagerCopy13city
Updated 2022-11-15
99
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
›
⌄
with transaction_per_minute_near as (select (count(distinct tx_hash)/1440) as per_minute,block_timestamp::date , 'Near' as L1
from near.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_solana as (select (count(distinct tx_id)/1440) as per_minute,block_timestamp::date , 'Solana' as L1
from solana.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_ethereum as (select (count(distinct tx_hash)/1440) as per_minute,block_timestamp::date , 'Ethereum' as L1
from ethereum.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_polygon as (select (count(distinct tx_hash)/1440) as per_minute,block_timestamp::date , 'Polygon' as L1
from polygon.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_algorand as (select (count(distinct tx_id)/1440) as per_minute,block_timestamp::date , 'ALgorand' as L1
from algorand.core.fact_transaction
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_osmosis as (select (count(distinct tx_id)/1440) as per_minute,block_timestamp::date , 'Osmosis' as L1
from osmosis.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
,transaction_per_minute_flow as (select (count(distinct tx_id)/1440) as per_minute,block_timestamp::date , 'Flow' as L1
from flow.core.fact_transactions
where block_timestamp::date >='2022-11-01' and block_timestamp::date <='2022-11-07'
group by block_timestamp::date)
select min(per_minute) , max(per_minute) , avg(per_minute) , median(per_minute) from transaction_per_minute_osmosis
Run a query to Download Data