Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x160287E2D3fdCDE9E91317982fc1Cc01C1f94085 THEN '105'WHEN "to" = 0x5ef340C8129fd7f6B7c8900dF7c6558E164Ef052 THEN '104'WHEN "to" = 0xC3066427579820629d970FA1C0D40B6D1eB65b2b THEN '152'WHEN "to" = 0xea22B0e15BC1532d788865df99d40a60B9EeA93E THEN '153'WHEN "to" = 0x02AE6A64a0DC17ffFDC5722Ad8270a7B32Be44db THEN '162'WHEN "to" = 0x9064a590751373440C8804F4F34AA6456ecF9cB4 THEN '163'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_ethereum.transfersWHERE contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- ETHAND "from" = 0x0D2BbA9593b9477aA7171de303Fb48b2BCd36d29 -- Apostro ETH CoreAND "to" IN (0x160287E2D3fdCDE9E91317982fc1Cc01C1f94085 -- 105, 0x5ef340C8129fd7f6B7c8900dF7c6558E164Ef052 -- 104, 0xC3066427579820629d970FA1C0D40B6D1eB65b2b -- 152, 0xea22B0e15BC1532d788865df99d40a60B9EeA93E -- 153, 0x02AE6A64a0DC17ffFDC5722Ad8270a7B32Be44db -- 162, 0x9064a590751373440C8804F4F34AA6456ecF9cB4 -- 163)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x160287E2D3fdCDE9E91317982fc1Cc01C1f94085 THEN '105'WHEN "from" = 0x5ef340C8129fd7f6B7c8900dF7c6558E164Ef052 THEN '104'WHEN "from" = 0xC3066427579820629d970FA1C0D40B6D1eB65b2b THEN '152'WHEN "from" = 0xea22B0e15BC1532d788865df99d40a60B9EeA93E THEN '153'WHEN "from" = 0x02AE6A64a0DC17ffFDC5722Ad8270a7B32Be44db THEN '162'WHEN "from" = 0x9064a590751373440C8804F4F34AA6456ecF9cB4 THEN '163'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_ethereum.transfersWHERE contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- ETHAND "to" = 0x0D2BbA9593b9477aA7171de303Fb48b2BCd36d29 -- Apostro ETH CoreAND "from" IN (0x160287E2D3fdCDE9E91317982fc1Cc01C1f94085 -- 105, 0x5ef340C8129fd7f6B7c8900dF7c6558E164Ef052 -- 104, 0xC3066427579820629d970FA1C0D40B6D1eB65b2b -- 152, 0xea22B0e15BC1532d788865df99d40a60B9EeA93E -- 153, 0x02AE6A64a0DC17ffFDC5722Ad8270a7B32Be44db -- 162, 0x9064a590751373440C8804F4F34AA6456ecF9cB4 -- 163)),data1 AS (SELECT*, ROW_NUMBER() OVER (PARTITION BY Silo, Date ORDER BY Grp DESC) AS rnFROM (