TYPE | ACIVITY_DAYS | TX_COUNT | TPM | TPS | |
|---|---|---|---|---|---|
1 | Flow | 131 | 34145190 | 181.007156488889 | 3.016785941481 |
2 | Ethereum | 131 | 160015930 | 848.260867260417 | 14.137681121007 |
3 | Avalanche | 131 | 42191204 | 223.659902459722 | 3.727665040995 |
4 | Near | 131 | 872294649 | 4624.123457 | 77.068724 |
5 | THORChain | 131 | 42038324 | 222.84947 | 3.714158 |
SalehFLOW Speed (redux)-compare
Updated 2025-05-14
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 lst_flow as (
select
datediff(day,min(block_timestamp),max(block_timestamp)) as acivity_days
,count (distinct tx_id) as tx_count
,tx_count/acivity_days/1440 as TPM
,tx_count/acivity_days/86400 as TPS
from flow.core.fact_transactions
where block_timestamp >= '2025-01-01' and block_timestamp <=current_date-1
and TX_SUCCEEDED=true
)
,lst_ethereum as (
select
datediff(day,min(block_timestamp),max(block_timestamp)) as acivity_days
,count (distinct tx_hash) as tx_count
,tx_count/acivity_days/1440 as TPM
,tx_count/acivity_days/86400 as TPS
from ethereum.core.fact_transactions
where block_timestamp >= '2025-01-01' and block_timestamp <=current_date-1
and STATUS='SUCCESS'
)
,lst_avalanche as (
select
datediff(day,min(block_timestamp),max(block_timestamp)) as acivity_days
,count (distinct tx_hash) as tx_count
,tx_count/acivity_days/1440 as TPM
,tx_count/acivity_days/86400 as TPS
from avalanche.core.fact_transactions
where block_timestamp >= '2025-01-01' and block_timestamp <=current_date-1
and TX_SUCCEEDED
)
,lst_near as (
select
datediff(day,min(block_timestamp),max(block_timestamp)) as acivity_days
,count (distinct tx_hash) as tx_count
,tx_count/(acivity_days*1440) as TPM
,tx_count/(acivity_days*86400) as TPS
Last run: 16 days ago
5
265B
310s