Query editor
WITH top_wallets AS (SELECT walletFROM dune.dykdo0101.result_usdc_top_200_whales),flows AS (SELECT 'USDC' AS asset, SUM(CAST(t.value AS DOUBLE) / POWER(10, 6)) AS net_flow, COUNT(*) AS transfer_rowsFROM erc20_ethereum.evt_Transfer tJOIN top_wallets w ON t."to" = w.walletWHERE t.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND t.evt_block_date BETWEEN DATE '2025-09-10' AND DATE '2025-09-24'UNION ALLSELECT 'USDC' AS asset, -SUM(CAST(t.value AS DOUBLE) / POWER(10, 6)) AS net_flow, COUNT(*) AS transfer_rowsFROM erc20_ethereum.evt_Transfer tJOIN top_wallets w ON t."from" = w.walletWHERE t.contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND t.evt_block_date BETWEEN DATE '2025-09-10' AND DATE '2025-09-24'UNION ALLSELECT 'WETH' AS asset, SUM(CAST(t.value AS DOUBLE) / POWER(10, 18)) AS net_flow, COUNT(*) AS transfer_rowsFROM erc20_ethereum.evt_Transfer tJOIN top_wallets w ON t."to" = w.walletWHERE t.contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND t.evt_block_date BETWEEN DATE '2025-09-10' AND DATE '2025-09-24'UNION ALLSELECT 'WETH' AS asset, -SUM(CAST(t.value AS DOUBLE) / POWER(10, 18)) AS net_flow, COUNT(*) AS transfer_rowsFROM erc20_ethereum.evt_Transfer tJOIN top_wallets w ON t."from" = w.walletWHERE t.contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND t.evt_block_date BETWEEN DATE '2025-09-10' AND DATE '2025-09-24')SELECTasset,SUM(net_flow) AS net_flow_15d,SUM(transfer_rows) AS transfer_rowsFROM flowsGROUP BY 1ORDER BY 1