Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x47d8490Be37ADC7Af053322d6d779153689E13C1 THEN '3'WHEN "to" = 0xbE0D3c8801206CC9f35A6626f90ef9F4f2983A3D THEN '54'WHEN "to" = 0xfbD3CCCb196Ce900BE5E2D008A6C2fDE90760408 THEN '52'WHEN "to" = 0x016C306e103FbF48EC24810D078C65aD13c5f11B THEN '25'WHEN "to" = 0x24F7692af5231d559219d07c65276Ad8C8ceE9A3 THEN '40'WHEN "to" = 0xE75B0B3d24B988Ada7136F6b8D491b727c36c27F THEN '41'WHEN "to" = 0xC92E96acb616476Ed117f263Fa68Ce21F6D554D3 THEN '51'WHEN "to" = 0x418d3FDfa4b79E485A9c0f16127959A67abD0877 THEN '106'WHEN "to" = 0x112380065A2cb73A5A429d9Ba7368cc5e8434595 THEN '22'WHEN "to" = 0x45A5a6F63448f23E8E67cd5fc6221fBC5eF6105f THEN '140'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_sonic.transfersWHERE contract_address = 0x039e2fB66102314Ce7b64Ce5Ce3E5183bc94aD38 -- wSAND "from" = 0xDED4aC8645619334186f28B8798e07ca354CFa0e -- Varlamore SAND "to" IN (0x47d8490Be37ADC7Af053322d6d779153689E13C1 -- 3, 0xbE0D3c8801206CC9f35A6626f90ef9F4f2983A3D -- 54, 0xfbD3CCCb196Ce900BE5E2D008A6C2fDE90760408 -- 52, 0x016C306e103FbF48EC24810D078C65aD13c5f11B -- 25, 0x24F7692af5231d559219d07c65276Ad8C8ceE9A3 -- 40, 0xE75B0B3d24B988Ada7136F6b8D491b727c36c27F -- 41, 0xC92E96acb616476Ed117f263Fa68Ce21F6D554D3 -- 51, 0x418d3FDfa4b79E485A9c0f16127959A67abD0877 -- 106, 0x112380065A2cb73A5A429d9Ba7368cc5e8434595 -- 22, 0x45A5a6F63448f23E8E67cd5fc6221fBC5eF6105f -- 140)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x47d8490Be37ADC7Af053322d6d779153689E13C1 THEN '3'WHEN "from" = 0xbE0D3c8801206CC9f35A6626f90ef9F4f2983A3D THEN '54'WHEN "from" = 0xfbD3CCCb196Ce900BE5E2D008A6C2fDE90760408 THEN '52'WHEN "from" = 0x016C306e103FbF48EC24810D078C65aD13c5f11B THEN '25'WHEN "from" = 0x24F7692af5231d559219d07c65276Ad8C8ceE9A3 THEN '40'WHEN "from" = 0xE75B0B3d24B988Ada7136F6b8D491b727c36c27F THEN '41'WHEN "from" = 0xC92E96acb616476Ed117f263Fa68Ce21F6D554D3 THEN '51'WHEN "from" = 0x418d3FDfa4b79E485A9c0f16127959A67abD0877 THEN '106'WHEN "from" = 0x112380065A2cb73A5A429d9Ba7368cc5e8434595 THEN '22'WHEN "from" = 0x45A5a6F63448f23E8E67cd5fc6221fBC5eF6105f THEN '140'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_sonic.transfersWHERE contract_address = 0x039e2fB66102314Ce7b64Ce5Ce3E5183bc94aD38 -- wSAND "to" = 0xDED4aC8645619334186f28B8798e07ca354CFa0e -- Varlamore SAND "from" IN (0x47d8490Be37ADC7Af053322d6d779153689E13C1 -- 3, 0xbE0D3c8801206CC9f35A6626f90ef9F4f2983A3D -- 54, 0xfbD3CCCb196Ce900BE5E2D008A6C2fDE90760408 -- 52