emferonsKPI - AVAX Tx Fees copy
    Updated 2025-02-14
    -- forked from charliemarketplace / KPI - AVAX Tx Fees @ https://flipsidecrypto.xyz/charliemarketplace/q/7fgdN4nWcakD/kpi---avax-tx-fees

    SELECT
    date_trunc('week', block_timestamp) as week_,
    sum(tx_fee_precise) as avax_fees
    FROM avalanche.core.fact_transactions
    WHERE block_timestamp >= '2024-01-01'
    group by week_
    order by week_ asc;


    Last run: about 1 month ago
    WEEK_
    AVAX_FEES
    1
    2024-01-01 00:00:00.00016575.279656573
    2
    2024-01-08 00:00:00.00011064.980991938
    3
    2024-01-15 00:00:00.0009098.20664197
    4
    2024-01-22 00:00:00.0009211.259375516
    5
    2024-01-29 00:00:00.0008662.779144966
    6
    2024-02-05 00:00:00.0008109.96913057
    7
    2024-02-12 00:00:00.0008792.333279321
    8
    2024-02-19 00:00:00.00030467.233280233
    9
    2024-02-26 00:00:00.00011792.291471529
    10
    2024-03-04 00:00:00.00014758.645344144
    11
    2024-03-11 00:00:00.00022108.258288797
    12
    2024-03-18 00:00:00.00015108.588338976
    13
    2024-03-25 00:00:00.00011046.047347284
    14
    2024-04-01 00:00:00.0009904.16332062
    15
    2024-04-08 00:00:00.00019524.984549714
    16
    2024-04-15 00:00:00.0008974.988241268
    17
    2024-04-22 00:00:00.0008013.212922062
    18
    2024-04-29 00:00:00.0006986.80607664
    19
    2024-05-06 00:00:00.0005764.931157686
    20
    2024-05-13 00:00:00.0005445.725172155
    71
    3KB
    8s