Eman-RazDaily Average for Transactions per Minute
Updated 2022-12-13
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
31
32
33
34
35
36
›
⌄
with table1 as (with flow as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_id)/(1440)) as "Daily TPM", 'flow' as blockchain
from flow.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
algorand as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_group_id)/(1440)) as "Daily TPM", 'algorand' as blockchain
from algorand.core.fact_transaction
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
avalanche as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_hash)/(1440)) as "Daily TPM", 'avalanche' as blockchain
from avalanche.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
bsc as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_hash)/(1440)) as "Daily TPM", 'bsc' as blockchain
from bsc.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
cosmos as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_id)/(1440)) as "Daily TPM", 'cosmos' as blockchain
from cosmos.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
ethereum as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_hash)/(1440)) as "Daily TPM", 'ethereum' as blockchain
from ethereum.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
order by 1),
gnosis as (select date_trunc('day',block_timestamp) as date, round(count(distinct tx_hash)/(1440)) as "Daily TPM", 'gnosis' as blockchain
from gnosis.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1
Run a query to Download Data