datavortextotal gas fees per token
    Updated 2024-12-22
    WITH usdt_gas_fees AS (
    SELECT
    SUM((t.gas_used * t.gas_unit_price) / 1e8) AS "Total USDT Gas Fees (APT)"
    FROM
    aptos.defi.ez_dex_swaps AS s
    INNER JOIN
    aptos.core.fact_transactions AS t ON s.tx_hash = t.tx_hash
    WHERE
    (s.symbol_in = 'USDT' OR s.symbol_out = 'USDT')
    AND s.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
    ),

    usdc_gas_fees AS (
    SELECT
    SUM((t.gas_used * t.gas_unit_price) / 1e8) AS "Total USDC Gas Fees (APT)"
    FROM
    aptos.defi.ez_dex_swaps AS s
    INNER JOIN
    aptos.core.fact_transactions AS t ON s.tx_hash = t.tx_hash
    WHERE
    (s.symbol_in = 'USDC' OR s.symbol_out = 'USDC')
    AND s.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
    ),

    apt_gas_fees AS (
    SELECT
    SUM((t.gas_used * t.gas_unit_price) / 1e8) AS "Total APT Gas Fees (APT)"
    FROM
    aptos.defi.ez_dex_swaps AS s
    INNER JOIN
    aptos.core.fact_transactions AS t ON s.tx_hash = t.tx_hash
    WHERE
    (s.symbol_in = 'APT' OR s.symbol_out = 'APT')
    AND s.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
    ),

    Last run: about 1 month ago
    Total USDT Gas Fees (APT)
    Total USDC Gas Fees (APT)
    Total APT Gas Fees (APT)
    Total stAPT Gas Fees (APT)
    Total WETH Gas Fees (APT)
    Total amAPT Gas Fees (APT)
    1
    2818.6979017427.27763610927.6443461290.963855833.348845677.798598
    1
    74B
    529s