Updated 2025-03-26
    SELECT
    COUNT(DISTINCT tx_hash) AS total_tx_hashes,
    COUNT(DISTINCT decoded_log:"maker") AS total_makers,
    COUNT(DISTINCT decoded_log:"taker") AS total_takers,
    SUM(decoded_log:"takerAmountFilled") / 1e6 AS total_taker_amount_filled,
    (SELECT COUNT(DISTINCT decoded_log:"proxy")
    FROM ronin.core.ez_decoded_event_logs
    WHERE origin_to_address = '0x02f376fe3e11634a866d2087f01427b09a235599') AS traders
    FROM ronin.core.ez_decoded_event_logs
    WHERE event_name = 'OrderFilled'
    AND decoded_log:"taker" <> '0x520fe655590e6fee13656590f1be3edf31fe099c'
    AND origin_from_address = '0x8962cde7ac43de7d55e8b61c80ee8d148fc7a201'
    AND origin_to_address = '0x520fe655590e6fee13656590f1be3edf31fe099c';


    Last run: about 2 months ago
    TOTAL_TX_HASHES
    TOTAL_MAKERS
    TOTAL_TAKERS
    TOTAL_TAKER_AMOUNT_FILLED
    TRADERS
    1
    7231379439689321.19338819831
    1
    36B
    12s