datavortexTotal fees
    Updated 2025-03-26
    SELECT
    SUM(COALESCE(t.tx_fee, 0)) AS total_fees,
    AVG(COALESCE(t.tx_fee, 0)) AS avg_fee
    FROM ronin.core.ez_decoded_event_logs e
    LEFT JOIN ronin.core.fact_transactions t
    ON e.tx_hash = t.tx_hash
    WHERE e.event_name = 'OrderFilled'
    AND e.decoded_log:"taker" <> '0x520fe655590e6fee13656590f1be3edf31fe099c'
    AND e.origin_from_address = '0x8962cde7ac43de7d55e8b61c80ee8d148fc7a201'
    AND e.origin_to_address = '0x520fe655590e6fee13656590f1be3edf31fe099c';

    Last run: about 2 months ago
    TOTAL_FEES
    AVG_FEE
    1
    77.4693342760.009559394654
    1
    31B
    9s