Query editor
-- 全链"跟单信号"原始数据 · 按资金流重建成交(2026-10-07,v5)-- 为什么不用 dex_evm.trades / dex.trades:它们只收录解析过的 DEX 池子 Swap(如 Uniswap V4),-- 不收录 pons_v2 等发射平台的内盘(联合曲线)买卖。实测 10/04 有约三分之一的信号因此缺失,-- 而且缺的大多是死在内盘的币(输家),会让数据偏向"毕业了的币"。-- 这里改为:对每笔交易,看发起人这一笔里各资产的净流入流出(tokens.transfers 含 ERC20 和原生 ETH,含合约内部转给钱包的 ETH):-- 收到某个币、同时付出 ETH/WETH/USDG(或股票代币)→ 买入,金额 = 付出的美元价值;反过来 → 卖出。-- 一笔交易里有两个及以上的币同时变动(批量买卖)的,无法拆分,跳过(另行统计)。-- 一行 = 一个钱包在一个币上的"信号"(窗口内第一笔 ≥ min_buy_usd 的买入)及之后的卖出、加仓、币的最新成交价、下 1~2 块他人买入价。-- 参数同 wallet-signals-window.sql:start_date / end_date / lookback_hours / min_buy_usd / min_signals / blockchainWITH params AS (SELECTCASEWHEN LOWER(TRIM('{{blockchain}}')) IN ('', 'value', 'default value') THEN 'robinhood'ELSE LOWER(TRIM('{{blockchain}}'))END AS blockchain,CAST(CAST('{{start_date}}' AS DATE) AS TIMESTAMP) AS start_ts,CAST(CAST('{{end_date}}' AS DATE) AS TIMESTAMP) AS end_ts,COALESCE(TRY_CAST('{{lookback_hours}}' AS INTEGER), 72) AS lookback_hours,COALESCE(TRY_CAST('{{min_buy_usd}}' AS DOUBLE), 80e0) AS min_buy_usd,COALESCE(TRY_CAST('{{min_signals}}' AS INTEGER), 3) AS min_signals),scan AS (SELECT p.*, DATE_ADD('hour', -p.lookback_hours, p.start_ts) AS scan_fromFROM params p),-- 计价资产:它们的流出/流入算作"付的钱/收的钱",不作为代币统计quote_assets (asset, is_usd_stable) AS (VALUES(0x0bd7d308f8e1639fab988df18a8011f41eacad73, false), -- WETH(0x5fc5360d0400a0fd4f2af552add042d716f1d168, true), -- USDG(按 1 美元计)(0xd0601ce157db5bdc3162bbac2a2c8af5320d9eec, false), -- NVDA(0x4a0e65a3eccec6dbe60ae065f2e7bb85fae35eea, false), -- SPCX(0xc0d6457c16cc70d6790dd43521c899c87ce02f35, false), -- META(0x117cc2133c37b721f49de2a7a74833232b3b4c0c, false), -- SPY(0x1937cad42b17d43bb2b347ce16d5288887c46c33, false), -- ANTHROPICx1L(0xfe09fb328be1c286b4f597ed34764b7472ae72c5, false), -- OPENAIx1L(0x1b0e319c6a659f002271b69db8a7df2f911c153e, false), -- GME(0x2e0847e8910a9732eb3fb1bb4b70a580adad4fe3, false), -- GOOGL(0xf51fb54de60f6e16252e852a5ed0e60b8307606a, false), -- NVDAx3L(0x1d11f0496982706c5e14a514d4e79f2e6bde4516, false) -- DJT),-- 成功交易的发起人txs_raw AS (SELECT t.hash AS tx_hash, t.block_number, t.block_time, t."from" AS traderFROM robinhood.transactions tCROSS JOIN scan cWHERE t.block_date >= CAST(c.scan_from AS DATE)AND t.block_time >= c.scan_fromAND t.success),-- 每笔交易里,发起人每种资产的净流入(正 = 收到,负 = 付出)flows AS (SELECTx.tx_hash,x.trader,MIN(x.block_time) AS block_time,