Query editor
WITH top_wallets AS (SELECT walletFROM dune.dykdo0101.result_usdc_top_200_whales),daily_whale_flows AS (SELECTDATE_TRUNC('day', t.evt_block_time) AS day,SUM(CAST(t.value AS DOUBLE) / POWER(10, 6)) AS amountFROM erc20_ethereum.evt_Transfer tINNER JOIN top_wallets w ON t."from" = w.walletWHERE t.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND t.evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1UNION ALLSELECTDATE_TRUNC('day', t.evt_block_time) AS day,-SUM(CAST(t.value AS DOUBLE) / POWER(10, 6)) AS amountFROM erc20_ethereum.evt_Transfer tINNER JOIN top_wallets w ON t."to" = w.walletWHERE t.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND t.evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1),whale_outflow_days AS (SELECTday,SUM(amount) AS net_outflowFROM daily_whale_flowsGROUP BY 1HAVING SUM(amount) > 0ORDER BY net_outflow DESCLIMIT 3),matched_swaps AS (SELECTdt.tx_hash,dt.evt_index,dt.token_bought_symbol,dt.amount_usdFROM dex.trades dtINNER JOIN whale_outflow_days odON dt.block_time >= od.dayAND dt.block_time < od.day + INTERVAL '48' HOURWHERE dt.blockchain = 'ethereum'AND dt.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '30' DAY)AND dt.block_time >= CURRENT_DATE - INTERVAL '30' DAYAND dt.token_sold_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND (dt.tx_from IN (SELECT wallet FROM top_wallets)OR dt.taker IN (SELECT wallet FROM top_wallets)OR dt.maker IN (SELECT wallet FROM top_wallets))AND dt.amount_usd IS NOT NULLAND dt.token_bought_symbol IS NOT NULLGROUP BY 1, 2, 3, 4)SELECTtoken_bought_symbol AS destination_token,