datavortextransaction fees by platform
    Updated 2024-09-18
    WITH recent_swaps AS (
    SELECT
    block_timestamp AS swap_time,
    tx_hash AS transaction_id,
    platform AS trading_platform
    FROM optimism.defi.ez_dex_swaps
    WHERE block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '1 DAY'
    ),

    transaction AS (
    SELECT
    r.trading_platform,
    t.tx_fee_precise AS transaction_fee
    FROM recent_swaps r
    JOIN optimism.core.fact_transactions t
    ON r.transaction_id = t.tx_hash
    )

    SELECT
    trading_platform,
    SUM(transaction_fee) AS total_tx_fee_precise
    FROM transaction
    GROUP BY trading_platform
    ORDER BY total_tx_fee_precise DESC;

    QueryRunArchived: QueryRun has been archived