Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0xe6605932e4a686534D19005BB9dB0FBA1F101272 THEN '46'WHEN "to" = 0x2f5Dc399B1E31f9808D1EF1256917ABD2447c74f THEN '15'WHEN "to" = 0xC3A18f1Efa66234e7D233C8ad00D597F6e585f2b THEN '44'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_sonic.transfersWHERE contract_address = 0xd3DCe716f3eF535C5Ff8d041c1A41C3bd89b97aE -- scUSDAND "from" = 0x592D1e187729C76EfacC6dfFB9355bd7BF47B2a7 -- Re7 scUSDAND "to" IN (0xe6605932e4a686534D19005BB9dB0FBA1F101272 -- 46, 0x2f5Dc399B1E31f9808D1EF1256917ABD2447c74f -- 15, 0xC3A18f1Efa66234e7D233C8ad00D597F6e585f2b -- 44)UNION ALLSELECTblock_time, CASEWHEN "from" = 0xe6605932e4a686534D19005BB9dB0FBA1F101272 THEN '46'WHEN "from" = 0x2f5Dc399B1E31f9808D1EF1256917ABD2447c74f THEN '15'WHEN "from" = 0xC3A18f1Efa66234e7D233C8ad00D597F6e585f2b THEN '44'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_sonic.transfersWHERE contract_address = 0xd3DCe716f3eF535C5Ff8d041c1A41C3bd89b97aE -- scUSDAND "to" = 0x592D1e187729C76EfacC6dfFB9355bd7BF47B2a7 -- Re7 scUSDAND "from" IN (0xe6605932e4a686534D19005BB9dB0FBA1F101272 -- 46, 0x2f5Dc399B1E31f9808D1EF1256917ABD2447c74f -- 15, 0xC3A18f1Efa66234e7D233C8ad00D597F6e585f2b -- 44)),data1 AS (SELECT*, ROW_NUMBER() OVER (PARTITION BY Silo, Date ORDER BY Grp DESC) AS rnFROM (SELECTDATE_TRUNC('day', block_time) AS Date, Silo--, symbol, amount, SUM(amount) OVER (ORDER BY block_time) AS Supply, SUM(amount) OVER (PARTITION BY Silo ORDER BY block_time) AS Silo_Supply, COUNT(amount) OVER (PARTITION BY Silo ORDER BY block_time) AS GrpFROM data0)),data2 AS (SELECTDate