Query editor
WITHparam AS (SELECTCASEWHEN lower(coalesce('{{chain}}','all')) IN ('all','*','') THEN 'all'WHEN lower('{{chain}}') IN ('arbitrum','arb') THEN 'arb'ELSE lower('{{chain}}')END AS norm_chain,try(CAST(NULLIF('{{start}}','') AS timestamp)) AS start_in,try(CAST(NULLIF('{{end}}','') AS timestamp)) AS end_in,CASE-- 🛠️ 修改点 #1:将默认回滚时间从 30天 改为 6个月WHEN try(CAST(NULLIF('{{start}}','') AS timestamp)) IS NULLTHEN date_trunc('day', current_date) - INTERVAL '6' monthWHEN try(CAST(NULLIF('{{end}}','') AS timestamp)) IS NULLTHEN try(CAST(NULLIF('{{start}}','') AS timestamp))ELSE LEAST(try(CAST(NULLIF('{{start}}','') AS timestamp)),try(CAST(NULLIF('{{end}}','') AS timestamp)))END AS start_ts,CASEWHEN try(CAST(NULLIF('{{end}}','') AS timestamp)) IS NULLTHEN current_timestampWHEN try(CAST(NULLIF('{{start}}','') AS timestamp)) IS NULLTHEN try(CAST(NULLIF('{{end}}','') AS timestamp))ELSE GREATEST(try(CAST(NULLIF('{{start}}','') AS timestamp)),try(CAST(NULLIF('{{end}}','') AS timestamp)))END AS end_ts),wooswap_src AS (SELECT evt_block_time, evt_tx_hash, 'arb' AS chain, swapVol FROM woofi_arbitrum.wooppv2_evt_wooswapUNION ALLSELECT evt_block_time, evt_tx_hash, 'base' AS chain, swapVol FROM woofi_base.wooppv2_evt_wooswapUNION ALLSELECT evt_block_time, evt_tx_hash, chain, swapVol FROM woofi_multichain.wooppv2_evt_wooswap),wooswap_in_window AS (SELECT w.*FROM wooswap_src wCROSS JOIN param pWHERE (p.norm_chain = 'all' OR w.chain = p.norm_chain)AND w.evt_block_time >= p.start_tsAND w.evt_block_time < p.end_ts),target_hashes AS (SELECT DISTINCT chain, evt_tx_hash AS tx_hashFROM wooswap_in_window),builders_tx AS (SELECT 'arb' AS chain, t.tx_hash, to_hex(t.input) AS hex_inputFROM arbitrum.traces tJOIN target_hashes h ON h.chain = 'arb' AND h.tx_hash = t.tx_hashCROSS JOIN param p