NETWORK | AVG_TPS | |
|---|---|---|
1 | MAINNET | 25.9608 |
2 | TESTNET | 0.3792 |
Updated 5 days ago
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 mainnet_data AS (
SELECT
TO_TIMESTAMP(t.value:timestamp)::DATE AS day,
t.value:value::NUMERIC AS tps
FROM (
SELECT live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/avgTps?startTimestamp=1726272000&timeInterval=day&pageSize=2160') AS response ),
LATERAL FLATTEN(input => PARSE_JSON(response:data:results)) t
),
daily_mainnet AS (
SELECT
day,
AVG(tps) AS daily_tps
FROM mainnet_data
GROUP BY day
),
testnet_data AS (
SELECT
TO_DATE(data.value[0]::STRING) AS day,
data.value[1]::INTEGER AS daily_transactions FROM TABLE(
FLATTEN( PARSE_JSON(
livequery.live.udf_api(
'GET','https://api.routescan.io/v2/network/mainnet/evm/43419/aggregations/txs',
{'accept': 'application/json'}, NULL )):data )) data),
testnet_avg_tps AS (
SELECT
ROUND(SUM(daily_transactions) / (COUNT(day) * 86400), 4) AS avg_tps
FROM testnet_data
),
mainnet_avg_tps AS (
SELECT
ROUND(AVG(daily_tps), 4) AS avg_tps
FROM daily_mainnet
)
SELECT
'MAINNET' AS network,
avg_tps
Last run: 5 days ago
2
40B
2s