Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x68E95f16383685331Aae1d4940A24fE25c57C6aa THEN '136'WHEN "to" = 0xef3234a3580be76ccCDaE29958490Ca57923796E THEN '137'WHEN "to" = 0xD2e5dd2C5DE9f6229f4Ca1ec2a5614b0CDc2Ec84 THEN '143'WHEN "to" = 0xDC1Ab820C92735E7a5e48f10fa3d8424Ec47A93E THEN '145'WHEN "to" = 0xa9a4BD976DbcFC2b89f554467ac85e2C758e2618 THEN '149'WHEN "to" = 0x1dC45c4451A99882FdA13C98De8C940961875A92 THEN '151'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_arbitrum.transfersWHERE contract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831 -- USDCAND "from" = 0x2514A2Ce842705EAD703d02fABFd8250BfCfb8bd -- OptimaAND "to" IN (0x68E95f16383685331Aae1d4940A24fE25c57C6aa -- 136, 0xef3234a3580be76ccCDaE29958490Ca57923796E -- 137, 0xD2e5dd2C5DE9f6229f4Ca1ec2a5614b0CDc2Ec84 -- 143, 0xDC1Ab820C92735E7a5e48f10fa3d8424Ec47A93E -- 145, 0xa9a4BD976DbcFC2b89f554467ac85e2C758e2618 -- 149, 0x1dC45c4451A99882FdA13C98De8C940961875A92 -- 151)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x68E95f16383685331Aae1d4940A24fE25c57C6aa THEN '136'WHEN "from" = 0xef3234a3580be76ccCDaE29958490Ca57923796E THEN '137'WHEN "from" = 0xD2e5dd2C5DE9f6229f4Ca1ec2a5614b0CDc2Ec84 THEN '143'WHEN "from" = 0xDC1Ab820C92735E7a5e48f10fa3d8424Ec47A93E THEN '145'WHEN "from" = 0xa9a4BD976DbcFC2b89f554467ac85e2C758e2618 THEN '149'WHEN "from" = 0x1dC45c4451A99882FdA13C98De8C940961875A92 THEN '151'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_arbitrum.transfersWHERE contract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831 -- USDCAND "to" = 0x2514A2Ce842705EAD703d02fABFd8250BfCfb8bd -- OptimaAND "from" IN (0x68E95f16383685331Aae1d4940A24fE25c57C6aa -- 136, 0xef3234a3580be76ccCDaE29958490Ca57923796E -- 137, 0xD2e5dd2C5DE9f6229f4Ca1ec2a5614b0CDc2Ec84 -- 143, 0xDC1Ab820C92735E7a5e48f10fa3d8424Ec47A93E -- 145, 0xa9a4BD976DbcFC2b89f554467ac85e2C758e2618 -- 149, 0x1dC45c4451A99882FdA13C98De8C940961875A92 -- 151)),data1 AS (SELECT*