Updated 2024-12-27
    SELECT
    DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS DATE,
    COUNT(DISTINCT TX_HASH) AS tnx,
    COUNT(CASE WHEN STATUS = 'SUCCESS' THEN 1 ELSE NULL END) * 1.0 / COUNT(*) AS SUCCESS_RATE,
    COUNT(DISTINCT FROM_ADDRESS) AS ACTIVE_USER,
    SUM(GAS_USED) / 1E6 AS GAS_USED
    FROM
    avalanche.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP > CURRENT_DATE - 365
    GROUP BY 1;

    Last run: about 2 months ago
    DATE
    TNX
    SUCCESS_RATE
    ACTIVE_USER
    GAS_USED
    1
    2024-11-01 00:00:00.00075405240.9022955475611291218.763066
    2
    2024-09-01 00:00:00.00045394110.950697370630777914.277291
    3
    2024-05-01 00:00:00.00053896950.947863605447776159.692324
    4
    2024-07-01 00:00:00.00051070180.953388650718826946.888608
    5
    2024-10-01 00:00:00.00054795850.953581440522901118.108652
    6
    2024-08-01 00:00:00.00050873770.935147493296820859.990288
    7
    2024-06-01 00:00:00.00048874600.956553709080652736.800595
    8
    2024-01-01 00:00:00.000143919320.9558238460871411420.475022
    9
    2024-02-01 00:00:00.000159396760.9743057852461276051.288177
    10
    2024-12-01 00:00:00.00074891460.8935375373781425775.028929
    11
    2024-03-01 00:00:00.000124377710.90336811339441839835.280732
    12
    2023-12-01 00:00:00.00060867930.978571185212299876.604097
    13
    2024-04-01 00:00:00.00080587630.9254038915051211663.536859
    13
    869B
    7s