Updated 6 days ago
    SELECT
    PLATFORM,
    AVG(GAS_USED * GAS_UNIT_PRICE)/pow(10,8) AS avg_gas_cost
    FROM
    aptos.defi.ez_dex_swaps eds
    join aptos.core.fact_transactions ft on eds.tx_hash=ft.tx_hash
    WHERE
    eds.BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    GROUP BY
    PLATFORM
    ORDER BY
    avg_gas_cost ASC
    Last run: 6 days ago
    PLATFORM
    AVG_GAS_COST
    1
    cellana0.00009725335698
    2
    batswap0.000136452
    3
    hippo0.0002158133333
    4
    auxexchange0.0002557599841
    5
    liquidswap0.0004425666381
    6
    sushi0.0004539035918
    7
    pancake0.0005749792278
    8
    thala0.000596198904
    9
    cetus0.000641636315
    10
    animeswap0.0006639812032
    10
    277B
    169s