cryptodatadiveAVAX Native Transactions Over Time
    Updated 2025-05-16
    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
    DAY
    TRANSACTION_COUNT
    1
    2025-04-16 00:00:00.000270961
    2
    2025-04-17 00:00:00.000253746
    3
    2025-04-18 00:00:00.000212855
    4
    2025-04-19 00:00:00.000213648
    5
    2025-04-20 00:00:00.000201173
    6
    2025-04-21 00:00:00.000282643
    7
    2025-04-22 00:00:00.000341073
    8
    2025-04-23 00:00:00.000357204
    9
    2025-04-24 00:00:00.000299347
    10
    2025-04-25 00:00:00.000325383
    11
    2025-04-26 00:00:00.000276807
    12
    2025-04-27 00:00:00.000275356
    13
    2025-04-28 00:00:00.000316407
    14
    2025-04-29 00:00:00.000286032
    15
    2025-04-30 00:00:00.000305529
    16
    2025-05-01 00:00:00.000286777
    17
    2025-05-02 00:00:00.000278353
    18
    2025-05-03 00:00:00.000204507
    19
    2025-05-04 00:00:00.000214862
    20
    2025-05-05 00:00:00.000240043
    31
    1KB
    2s