Query editor
-- 库存抢跑检查(2026-10-14):源码 oft-xchain-arb/docs/dune/inventory-race.sql,说明见文件头。表 2:卖之前 ≥10 秒(快线路取半个到账时间)有源链买入 = 跨链;两边 ≤5 秒同时成交且前面没有能跨过来的买入 = 库存。WITH params AS (SELECT CAST('{{start_time}}' AS TIMESTAMP) AS t0, CAST('{{end_time}}' AS TIMESTAMP) AS t1,CAST({{min_trig_usd}} AS DOUBLE) AS min_trig, CAST({{min_detail_usd}} AS DOUBLE) AS min_detail, CAST({{min_jump_bps}} AS DOUBLE) AS min_jump,0x164f82f6ea2d8b5703968e588f63ae87ee89bfe2 AS us),routes (sym, dir, src_chain, src_token, dst_chain, dst_token, wait_sec) AS (VALUES('EDEL', 'R→B', 'robinhood', 0x88c4c42ed68584ff02f5a00d5d3d985108a3961c, 'base', 0xfb31f85a8367210b2e4ed2360d2da9dc2d2ccc95, 22),('EDEL', 'B→R', 'base', 0xfb31f85a8367210b2e4ed2360d2da9dc2d2ccc95, 'robinhood', 0x88c4c42ed68584ff02f5a00d5d3d985108a3961c, 65),('Surplus', 'R→B', 'robinhood', 0xa8219d665c831ab5caadb14b24de9605383f2119, 'base', 0xc52aedec3374422d7510e294cfaa90799595cba3, 14),('Surplus', 'B→R', 'base', 0xc52aedec3374422d7510e294cfaa90799595cba3, 'robinhood', 0xa8219d665c831ab5caadb14b24de9605383f2119, 43),('MRDN', 'R→B', 'robinhood', 0xbaabcb1800c539a58a46035d3982403a37fd6d5d, 'base', 0xe57e601c06689d3e2bf7db7bebb14b4ff28400c6, 23),('MRDN', 'B→R', 'base', 0xe57e601c06689d3e2bf7db7bebb14b4ff28400c6, 'robinhood', 0xbaabcb1800c539a58a46035d3982403a37fd6d5d, 32),('IMD', 'B→R', 'base', 0xff0c532fdb8cd566ae169c1cb157ff2bdc83e105, 'robinhood', 0x5f7bb59365ce557c26dbcaa4ee9d39a4b95b7127, 34),('IMD', 'R→B', 'robinhood', 0x5f7bb59365ce557c26dbcaa4ee9d39a4b95b7127, 'base', 0xff0c532fdb8cd566ae169c1cb157ff2bdc83e105, 22),('IMD', 'R→E', 'robinhood', 0x5f7bb59365ce557c26dbcaa4ee9d39a4b95b7127, 'ethereum', 0xd34a99bc0f67ae1bbd63c660e6d0b0dd03e263b7, 90),('CREDIT', 'R→E', 'robinhood', 0xe33322da1380e61e5ae5dfb21e7f62924c73004c, 'ethereum', 0xe33322da1380e61e5ae5dfb21e7f62924c73004c, 90),('BNKR', 'B→R', 'base', 0x22af33fe49fd1fa80c7149773dde5890d3c76f3b, 'robinhood', 0x178e54df3d091ee4d0b2534742ef9e3692b76526, 51),('BNKR', 'R→B', 'robinhood', 0x178e54df3d091ee4d0b2534742ef9e3692b76526, 'base', 0x22af33fe49fd1fa80c7149773dde5890d3c76f3b, 22),('DEGEN', 'R→B', 'robinhood', 0x0830a9dd26a04e959657ab6788d45f5725590c32, 'base', 0x4ed4e862860bed51a9570b96d89af5e1b0efefed, 30),('GNS', 'B→ARB', 'base', 0xfb1aaba03c31ea98a3eec7591808acb1947ee7ac, 'arbitrum', 0x18c11fd286c5ec11c3b683caa813b77f5163a122, 28),('GNS', 'ARB→B', 'arbitrum', 0x18c11fd286c5ec11c3b683caa813b77f5163a122, 'base', 0xfb1aaba03c31ea98a3eec7591808acb1947ee7ac, 15)),toks AS (SELECT DISTINCT src_chain AS chain, src_token AS token FROM routesUNIONSELECT DISTINCT dst_chain, dst_token FROM routes),tx AS (SELECT d.blockchain AS chain, k.token, d.tx_hash, d.tx_from,MIN(d.block_time) AS bt, MIN(d.block_number) AS bn, MIN(d.evt_index) AS ei,SUM(IF(d.token_bought_address = k.token, d.token_bought_amount, -d.token_sold_amount)) AS net_q,SUM(IF(d.token_bought_address = k.token, 1e0, -1e0) * COALESCE(d.amount_usd, 0e0)) AS net_usd,SUM(d.amount_usd) / NULLIF(SUM(IF(d.amount_usd IS NULL, 0e0, IF(d.token_bought_address = k.token, d.token_bought_amount, d.token_sold_amount))), 0e0) AS pxFROM dex.trades dCROSS JOIN params pJOIN toks k ON k.chain = d.blockchain AND (k.token = d.token_bought_address OR k.token = d.token_sold_address)WHERE d.blockchain IN ('robinhood', 'base', 'arbitrum', 'ethereum')AND d.block_date BETWEEN CAST(p.t0 - INTERVAL '30' MINUTE AS DATE) AND CAST(p.t1 + INTERVAL '10' MINUTE AS DATE)AND d.block_time >= p.t0 - INTERVAL '30' MINUTE AND d.block_time < p.t1 + INTERVAL '10' MINUTEGROUP BY 1, 2, 3, 4),trig AS (SELECT r.sym, r.dir, r.src_chain, r.src_token, r.dst_chain, r.dst_token, r.wait_sec,IF(x.chain = r.dst_chain, 'a 目标链大买单', 'b 源链大卖单') AS kind,r.sym || r.dir || ':' || x.chain || ':' || TO_HEX(x.tx_hash) AS tid, x.tx_hash, x.tx_from AS trig_from, x.bt, x.bn, x.ei,ABS(x.net_usd) AS trig_usd, x.px AS trig_pxFROM routes rCROSS JOIN params pJOIN tx x ON (x.chain = r.dst_chain AND x.token = r.dst_token AND x.net_usd >= p.min_trig)OR (x.chain = r.src_chain AND x.token = r.src_token AND x.net_usd <= -p.min_trig)WHERE x.bt >= p.t0 AND x.bt < p.t1 AND x.tx_from <> p.us),win AS (SELECT t.*, w.tx_from AS who, w.net_q, w.net_usd, w.px, w.bn * 100000 + w.ei AS k,to_unixtime(w.bt) - to_unixtime(t.bt) AS sec,IF(t.kind LIKE 'a%', w.bn < t.bn OR (w.bn = t.bn AND w.ei < t.ei), w.bt < t.bt) AS is_pre,w.tx_from = p.us AS is_us,w.tx_from = t.trig_from AS is_trig