hessAvg/median Fee daily
    Updated 2025-03-16
    with price as ( select RECORDED_HOUR::date as date,
    avg(price) as avg_price
    from osmosis.price.ez_prices
    where symbol = 'AXL'
    group by 1)
    ,
    fee as ( select block_timestamp::date as date,
    fee/pow(10,6) as fees,
    fees*avg_price as fee_usd
    from axelar.core.fact_transactions a join price b on a.block_timestamp::date = b.date
    where tx_succeeded = 'TRUE'
    )

    select trunc(date,'week') as weekly,
    avg(fee_usd) as "Avg Fee (USD)",
    median(fee_usd) as "Median Fee (USD)",
    max(fee_usd) as "Max Fee (USD)",
    min(fee_usd) as "Min Fee (USD)"
    from fee
    group by 1
    order by 1 asc


    Last run: about 1 month ago
    WEEKLY
    Avg Fee (USD)
    Median Fee (USD)
    Max Fee (USD)
    Min Fee (USD)
    1
    2022-09-26 00:00:00.0000.009040887530.0076362886060.35957041720.000002599298824
    2
    2022-10-03 00:00:00.0000.01271666420.0097435395190.053616335330.000003251999061
    3
    2022-10-10 00:00:00.0000.014300926110.010623812180.17031863710.000003633464258
    4
    2022-10-17 00:00:00.0000.013185682130.0099709210030.25149354070.000003592764867
    5
    2022-10-24 00:00:00.0000.011397709640.009231865280.23944029250.000004105959101
    6
    2022-10-31 00:00:00.0000.01104023950.0084324450160.280148620.000002953223891
    7
    2022-11-07 00:00:00.0000.0090986252160.0074191705890.26335478470.000003662368689
    8
    2022-11-14 00:00:00.0000.0092569414430.0070509842720.039365701610.00006446210389
    9
    2022-11-21 00:00:00.0000.0091301765050.0066918310770.82895205660.00005921086119
    10
    2022-11-28 00:00:00.0000.0075293702850.0057126780380.55801842770.0002367243889
    11
    2022-12-05 00:00:00.0000.007100486090.005254850940.15735778820.00004687802081
    12
    2022-12-12 00:00:00.0000.0082158510420.0055958772810.12597973280.00004406091239
    13
    2022-12-19 00:00:00.0000.0077065099390.005349907320.096878654930.000005055967403
    14
    2022-12-26 00:00:00.0000.013177591030.0072092429870.19448674680.000005556764194
    15
    2023-01-02 00:00:00.0000.011358489980.006575555920.18583040410.000005309440118
    16
    2023-01-09 00:00:00.0000.010398488720.0066358402120.10071504740.0000552662643
    17
    2023-01-16 00:00:00.0000.011721349710.0067348836240.79542731160.00005593248331
    18
    2023-01-23 00:00:00.0000.013213537950.008064911890.06978407450.00006243285903
    19
    2023-01-30 00:00:00.0000.011890075650.0084332792617.538292270.00006559541457
    20
    2023-02-06 00:00:00.0000.015352105130.01073534140.089115273530.00006740841412
    ...
    129
    11KB
    10s