Query editor
-- OKX EVM 10-digit order_id performance-- Window: one UTC calendar day selected by text parameter dt (for example, '2026-08-12').-- Based on query 6258999; volume filter aligns with query 6970514 EVM path.-- Inline EVM transaction-identification logic derived from query 6258999.-- The airdrop-hunter CTEs are intentionally omitted because this query only-- measures order_id volume, traders, and transactions.WITH ethereum_logs AS (SELECTl.contract_address,l.tx_hash,l.block_date,l.topic0,l.topic1,l.topic2,l.topic3,l.data,tx_from,varbinary_to_uint256(varbinary_substring(tx.data,LENGTH(tx.data)-25, 6 )) as fee_charged,'ethereum' AS blockchainFROM ethereum.logs lLEFT JOIN ethereum.transactions tx ON l.tx_hash = tx.hash and l.block_number = tx.block_number and l.block_date = tx.block_dateWHERE l.contract_address IN (0x28b1Dc1a5E3699A428BC51d234DFab7C9CB2a183, -- 2026-04-23 Added0x2E1Dee213BA8d7af0934C49a23187BabEACa8764,0xF6801D319497789f934ec7F83E142a9536312B08,0x5E1f62Dac767b0491e3CE72469C217365D5B48cC)AND l.topic0 IN (0x1bb43f2da90e35f7b0cf38521ca95a49e68eb42fac49924930a5bd73cdf7576c,0x7724394874fdd8ad13292ec739b441f85c6559f10dc4141b8d4c0fa4cbf55bdb)AND l.block_date = DATE('{{dt}}')),bnb_logs AS (SELECTl.contract_address, l.tx_hash, l.block_date, l.topic0, l.topic1, l.topic2, l.topic3, l.data, tx_from,varbinary_to_uint256(varbinary_substring(tx.data,LENGTH(tx.data)-25, 6 )) as fee_charged,'bnb' AS blockchainFROM bnb.logs lLEFT JOIN bnb.transactions tx ON l.tx_hash = tx.hash and l.block_number = tx.block_number and l.block_date = tx.block_dateWHERE l.contract_address IN (0x62cceF0b4545166f721cAa9fEe13c1d3767E27dc, -- 2026-04-23 added0x9b9efa5Efa731EA9Bbb0369E91fA17Abf249CFD4,0xd547Eafde2410e63300Fc5308CceA0b356E7b5d8,0x3156020dfF8D99af1dDC523ebDfb1ad2018554a0)AND l.topic0 IN (0x1bb43f2da90e35f7b0cf38521ca95a49e68eb42fac49924930a5bd73cdf7576c,0x7724394874fdd8ad13292ec739b441f85c6559f10dc4141b8d4c0fa4cbf55bdb)and l.block_number > 59430791 and tx.block_number > 59430791AND l.block_date = DATE('{{dt}}')),arb_logs AS (SELECTl.contract_address, l.tx_hash, l.block_date, l.topic0, l.topic1, l.topic2, l.topic3, l.data, tx_from,