moonshot21Average Fee per Day in USD
    Updated 1 day ago
    SELECT
    DATE(BLOCK_TIMESTAMP_HOUR) AS transaction_date,
    SUM(TOTAL_FEES_USD) / SUM(TRANSACTION_COUNT) AS average_fee_per_transaction,
    SUM(TOTAL_FEES_USD) AS total_fees,
    SUM(TRANSACTION_COUNT) AS total_transactions
    FROM base.stats.ez_core_metrics_hourly
    GROUP BY DATE(BLOCK_TIMESTAMP_HOUR)
    ORDER BY transaction_date DESC;
    Last run: 1 day ago
    TRANSACTION_DATE
    AVERAGE_FEE_PER_TRANSACTION
    TOTAL_FEES
    TOTAL_TRANSACTIONS
    1
    2025-03-01 00:00:00.0000.02168310983123223.145682909
    2
    2025-02-28 00:00:00.0000.0638809025476901.67465480
    3
    2025-02-27 00:00:00.0000.035157943231337.056579937
    4
    2025-02-26 00:00:00.0000.06006796318390635.66503227
    5
    2025-02-25 00:00:00.0000.07673875752532477.736938837
    6
    2025-02-24 00:00:00.0000.07515021944550994.427331907
    7
    2025-02-23 00:00:00.0000.0238656497164390.76888172
    8
    2025-02-22 00:00:00.0000.0266579709186063.046979640
    9
    2025-02-21 00:00:00.0000.06738853596515409.027648319
    10
    2025-02-20 00:00:00.0000.03368171568263317.227817809
    11
    2025-02-19 00:00:00.0000.03096133285216283.276985593
    12
    2025-02-18 00:00:00.0000.04525852352319280.787054600
    13
    2025-02-17 00:00:00.0000.03153651511220187.986982001
    14
    2025-02-16 00:00:00.0000.01775165427126996.247154051
    15
    2025-02-15 00:00:00.0000.01627365686107518.576606909
    16
    2025-02-14 00:00:00.0000.03263204762239586.067342048
    17
    2025-02-13 00:00:00.0000.03754458684301596.838033031
    18
    2025-02-12 00:00:00.0000.04477413653342646.937652787
    19
    2025-02-11 00:00:00.0000.04707249999342137.247268304
    20
    2025-02-10 00:00:00.0000.03334760657250832.967521768
    ...
    626
    36KB
    2s