Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x396922EF30Cf012973343f7174db850c7D265278 THEN '3'WHEN "to" = 0xF03c5b0CCbC4840AA2A0c896DC56ca79E75D1879 THEN '28'WHEN "to" = 0xd90545B06e7a6f9D2194d8f26E72c9B0D4e00D60 THEN '36'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_sonic.transfersWHERE contract_address = 0xE5DA20F15420aD15DE0fa650600aFc998bbE3955 -- stSAND "from" = 0xf136C06d23492Ff143afD9f5DC4E886224bA7050 -- Re7 stSAND "to" IN (0x396922EF30Cf012973343f7174db850c7D265278 -- 3, 0xF03c5b0CCbC4840AA2A0c896DC56ca79E75D1879 -- 28, 0xd90545B06e7a6f9D2194d8f26E72c9B0D4e00D60 -- 36)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x396922EF30Cf012973343f7174db850c7D265278 THEN '3'WHEN "from" = 0xF03c5b0CCbC4840AA2A0c896DC56ca79E75D1879 THEN '28'WHEN "from" = 0xd90545B06e7a6f9D2194d8f26E72c9B0D4e00D60 THEN '36'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_sonic.transfersWHERE contract_address = 0xE5DA20F15420aD15DE0fa650600aFc998bbE3955 -- stSAND "to" = 0xf136C06d23492Ff143afD9f5DC4E886224bA7050 -- Re7 stSAND "from" IN (0x396922EF30Cf012973343f7174db850c7D265278 -- 3, 0xF03c5b0CCbC4840AA2A0c896DC56ca79E75D1879 -- 28, 0xd90545B06e7a6f9D2194d8f26E72c9B0D4e00D60 -- 36)),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