yasmintx copy copy
Updated 2025-02-19
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 base_data AS (
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/txCount?startTimestamp=1726272000&endTimestamp=1731369600&timeInterval=day') AS response
UNION ALL
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/txCount?startTimestamp=1731456000&endTimestamp=1733961600&timeInterval=day') AS response
UNION ALL
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/txCount?startTimestamp=1734048000&endTimestamp=1736640000&timeInterval=day') AS response
UNION ALL
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/txCount?startTimestamp=1736726400&endTimestamp=1739145600&timeInterval=day') AS response
UNION ALL
SELECT
live.udf_api('https://metrics.avax.network/v2/chains/49321/metrics/txCount?startTimestamp=1739232000&endTimestamp=1741910400&timeInterval=day') AS response
),
flattened_data AS (
SELECT
to_timestamp(tx.value:timestamp)::date AS date,
tx.value:value::integer AS daily_transactions
FROM
base_data,
LATERAL FLATTEN(input => response:data:results) AS tx
)
SELECT
DATE_TRUNC('day', date) AS truncated_date,
SUM(daily_transactions) AS total_daily_transactions
FROM
flattened_data
GROUP BY
DATE_TRUNC('day', date)
ORDER BY
truncated_date ASC;
QueryRunArchived: QueryRun has been archived