DAY | TRANSACTION_COUNT | |
---|---|---|
1 | 2025-04-16 00:00:00.000 | 270961 |
2 | 2025-04-17 00:00:00.000 | 253746 |
3 | 2025-04-18 00:00:00.000 | 212855 |
4 | 2025-04-19 00:00:00.000 | 213648 |
5 | 2025-04-20 00:00:00.000 | 201173 |
6 | 2025-04-21 00:00:00.000 | 282643 |
7 | 2025-04-22 00:00:00.000 | 341073 |
8 | 2025-04-23 00:00:00.000 | 357204 |
9 | 2025-04-24 00:00:00.000 | 299347 |
10 | 2025-04-25 00:00:00.000 | 325383 |
11 | 2025-04-26 00:00:00.000 | 276807 |
12 | 2025-04-27 00:00:00.000 | 275356 |
13 | 2025-04-28 00:00:00.000 | 316407 |
14 | 2025-04-29 00:00:00.000 | 286032 |
15 | 2025-04-30 00:00:00.000 | 305529 |
16 | 2025-05-01 00:00:00.000 | 286777 |
17 | 2025-05-02 00:00:00.000 | 278353 |
18 | 2025-05-03 00:00:00.000 | 204507 |
19 | 2025-05-04 00:00:00.000 | 214862 |
20 | 2025-05-05 00:00:00.000 | 240043 |
cryptodatadiveAVAX Native Transactions Over Time
Updated 2025-05-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH time_window AS (
SELECT
CASE
WHEN '{{time_range}}' = '1d' THEN DATEADD('day', -1, CURRENT_DATE)
WHEN '{{time_range}}' = '7d' THEN DATEADD('day', -7, CURRENT_DATE)
WHEN '{{time_range}}' = '30d' THEN DATEADD('day', -30, CURRENT_DATE)
WHEN '{{time_range}}' = '90d' THEN DATEADD('day', -90, CURRENT_DATE)
ELSE TO_DATE('2021-01-01')
END AS start_date
)
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(*) AS transaction_count
FROM avalanche.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY 1
ORDER BY 1;
Last run: about 2 months ago
31
1KB
2s