Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x4935FaDB17df859667Cc4F7bfE6a8cB24f86F8d0 THEN '55'WHEN "to" = 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 THEN '20'WHEN "to" = 0xb488af9A423eE9012db3b90B213dcca2CD9C4070 THEN '50'WHEN "to" = 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De THEN '23'WHEN "to" = 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 THEN '34'WHEN "to" = 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f THEN '36'WHEN "to" = 0x46d2249Ed33A2CE6603aB1Ce1B33ea2c244B0e86 THEN '53'WHEN "to" = 0xD47031F7B044dffeB9b041c4eCF16209F6a1B0b2 THEN '102'WHEN "to" = 0x8C96c244586E0d8F6889413F7F525DaDE3b4Ab85 THEN '103'WHEN "to" = 0x8A810A8bDceCc5ca467e9Fac5A5a846d36c5Bf7e THEN '104'WHEN "to" = 0x4f55E28D36b30a638C3aA1D5cbF9c4ccB3831506 THEN '105'WHEN "to" = 0xaE79B0D94e1C53cD2E8160899b8d58EC138D341f THEN '111'WHEN "to" = 0x4E216C15697C1392fE59e1014B009505E05810Df THEN '8'--WHEN "to" = 0xEd9777944A2Fb32504a410D23f246463B3f40908 THEN '121'WHEN "to" = 0xA1627a0E1d0ebcA9326D2219B84Df0c600bed4b1 THEN '112'ELSE NULL END AS Silo--, contract_address AS Token--, symbol, amountFROM tokens_sonic.transfersWHERE contract_address = 0x29219dd400f2Bf60E5a23d13Be72B486D4038894 -- USDCAND "from" = 0xF6F87073cF8929C206A77b0694619DC776F89885 -- Varlamore USDC GrowthAND "to" IN (0x4935FaDB17df859667Cc4F7bfE6a8cB24f86F8d0 -- 55, 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 -- 20, 0xb488af9A423eE9012db3b90B213dcca2CD9C4070 -- 50, 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De -- 23, 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 -- 34, 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f -- 36, 0x46d2249Ed33A2CE6603aB1Ce1B33ea2c244B0e86 -- 53, 0xD47031F7B044dffeB9b041c4eCF16209F6a1B0b2 -- 102, 0x8C96c244586E0d8F6889413F7F525DaDE3b4Ab85 -- 103, 0x8A810A8bDceCc5ca467e9Fac5A5a846d36c5Bf7e -- 104, 0x4f55E28D36b30a638C3aA1D5cbF9c4ccB3831506 -- 105, 0xaE79B0D94e1C53cD2E8160899b8d58EC138D341f -- 111, 0x4E216C15697C1392fE59e1014B009505E05810Df -- 8--, 0xEd9777944A2Fb32504a410D23f246463B3f40908 -- 121, 0xA1627a0E1d0ebcA9326D2219B84Df0c600bed4b1 -- 112)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x4935FaDB17df859667Cc4F7bfE6a8cB24f86F8d0 THEN '55'WHEN "from" = 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 THEN '20'WHEN "from" = 0xb488af9A423eE9012db3b90B213dcca2CD9C4070 THEN '50'WHEN "from" = 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De THEN '23'WHEN "from" = 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 THEN '34'WHEN "from" = 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f THEN '36'WHEN "from" = 0x46d2249Ed33A2CE6603aB1Ce1B33ea2c244B0e86 THEN '53'WHEN "from" = 0xD47031F7B044dffeB9b041c4eCF16209F6a1B0b2 THEN '102'WHEN "from" = 0x8C96c244586E0d8F6889413F7F525DaDE3b4Ab85 THEN '103'WHEN "from" = 0x8A810A8bDceCc5ca467e9Fac5A5a846d36c5Bf7e THEN '104'WHEN "from" = 0x4f55E28D36b30a638C3aA1D5cbF9c4ccB3831506 THEN '105'