TRUNCATED_DATE | Daily Avg TPS | Daily Fee | |
|---|---|---|---|
1 | 2025-03-09 00:00:00.000 | 32 | 28.111022223 |
2 | 2025-03-10 00:00:00.000 | 28 | 25.791261209 |
3 | 2025-03-11 00:00:00.000 | 27 | 25.124545924 |
4 | 2025-03-12 00:00:00.000 | 28 | 25.394810977 |
5 | 2025-03-13 00:00:00.000 | 27 | 25.125149173 |
6 | 2025-03-14 00:00:00.000 | 29 | 27.427165208 |
7 | 2025-03-15 00:00:00.000 | 32 | 29.445882698 |
8 | 2025-03-16 00:00:00.000 | 32 | 29.568660602 |
9 | 2025-03-17 00:00:00.000 | 28 | 25.911886621 |
10 | 2025-03-18 00:00:00.000 | 27 | 25.271488846 |
11 | 2025-03-19 00:00:00.000 | 26 | 24.587988325 |
12 | 2025-03-20 00:00:00.000 | 27 | 24.506162982 |
13 | 2025-03-21 00:00:00.000 | 30 | 27.344939416 |
14 | 2025-03-22 00:00:00.000 | 32 | 29.278517644 |
15 | 2025-03-23 00:00:00.000 | 32 | 29.111222708 |
16 | 2025-03-24 00:00:00.000 | 29 | 26.031424661 |
17 | 2025-03-25 00:00:00.000 | 27 | 25.180955486 |
18 | 2025-03-26 00:00:00.000 | 27 | 24.215162861 |
19 | 2025-03-27 00:00:00.000 | 28 | 26.405088618 |
20 | 2025-03-28 00:00:00.000 | 31 | 28.858223562 |
yasminFEE
Updated 2025-04-08
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 avg_tps AS (
SELECT live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/avgTps?startTimestamp=1726272000&timeInterval=day&pageSize=2160') AS response
),
tps_flattened AS (
SELECT
to_timestamp(tx.value:timestamp)::date AS date,
tx.value:value::float AS daily_tps
FROM
avg_tps,
LATERAL FLATTEN(input => response:data:results) AS tx
),
fees_paid AS (
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/feesPaid?startTimestamp=1726272000&timeInterval=day&pageSize=2160') AS response
),
fees_flattened AS (
SELECT
to_timestamp(tx.value:timestamp)::date AS date,
tx.value:value::float AS daily_fees
FROM fees_paid,
LATERAL FLATTEN(input => response:data:results) AS tx
),
combined_data AS (
SELECT
COALESCE(t.date, f.date) AS date,
t.daily_tps,
f.daily_fees
FROM tps_flattened t
FULL OUTER JOIN
fees_flattened f ON t.date = f.date
)
SELECT
date_trunc('{{Date_Trunc}}', date) AS truncated_date,
AVG(daily_tps) AS "Daily Avg TPS",
SUM(daily_fees) AS "Daily Fee"
FROM
Last run: about 2 months ago
29
1KB
2s