Flipside Axelar AnalystsMax/Avg/Median Transfer Fees Over Time
    Updated 7 hours ago
    select
    date_trunc('month', created_at) as "Date",
    round(avg(
    (data:gas:gas_used_amount) *(data:gas_price_rate:source_token.token_price.usd)
    ),2) AS "Avg",
    round(median(
    (data:gas:gas_used_amount) *(data:gas_price_rate:source_token.token_price.usd)
    ),2) AS "Median",
    round(max(
    (data:gas:gas_used_amount) *(data:gas_price_rate:source_token.token_price.usd)
    ),2) AS "Max"
    from
    axelar.axelscan.fact_gmp
    where
    (
    call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
    )
    and data:interchain_transfer:event = 'InterchainTransfer'
    and event = 'ContractCall'
    and status = 'executed'
    and simplified_status = 'received'
    and data:executed:receipt:logs [1] :address is not null
    group by
    1
    order by
    1
    Last run: about 7 hours agoAuto-refreshes every 24 hours
    Date
    Avg
    Median
    Max
    1
    2023-12-01 00:00:00.0002.220.7844.79
    2
    2024-01-01 00:00:00.0002.030.7151.98
    3
    2024-02-01 00:00:00.0001.520.31130.26
    4
    2024-03-01 00:00:00.0001.060.52159.35
    5
    2024-04-01 00:00:00.0003.820.53139.54
    6
    2024-05-01 00:00:00.0000.590.2964.56
    7
    2024-06-01 00:00:00.0000.780.2394.67
    8
    2024-07-01 00:00:00.0000.950.1843.88
    9
    2024-08-01 00:00:00.0000.790.1576.93
    10
    2024-09-01 00:00:00.0001.180.1759.83
    11
    2024-10-01 00:00:00.0002.852.1977.93
    12
    2024-11-01 00:00:00.0003.310.28108
    13
    2024-12-01 00:00:00.0004.60.39174.32
    14
    2025-01-01 00:00:00.0003.010.25129.88
    15
    2025-02-01 00:00:00.0001.040.2697.08
    16
    2025-03-01 00:00:00.0000.530.3950.47
    17
    2025-04-01 00:00:00.0000.460.2643.72
    17
    751B
    15s