Query editor
WITH data0 AS (SELECTblock_time, CASEWHEN "to" = 0x4E216C15697C1392fE59e1014B009505E05810Df THEN '8'WHEN "to" = 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 THEN '20'WHEN "to" = 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De THEN '23'WHEN "to" = 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 THEN '34'WHEN "to" = 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f THEN '36'ELSE NULL END AS Silo--, contract_address AS Token, symbol, amountFROM tokens_sonic.transfersWHERE contract_address = 0x29219dd400f2Bf60E5a23d13Be72B486D4038894 -- USDCAND "from" = 0xF75AE954D30217B4EE70DbFB33f04162aa3Cf260 -- Re7 USDCAND "to" IN (0x4E216C15697C1392fE59e1014B009505E05810Df -- 8, 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 -- 20, 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De -- 23, 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 -- 34, 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f -- 36)UNION ALLSELECTblock_time, CASEWHEN "from" = 0x4E216C15697C1392fE59e1014B009505E05810Df THEN '8'WHEN "from" = 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 THEN '20'WHEN "from" = 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De THEN '23'WHEN "from" = 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 THEN '34'WHEN "from" = 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f THEN '36'ELSE NULL END AS Silo--, contract_address AS Token, symbol, -1 * amount AS amountFROM tokens_sonic.transfersWHERE contract_address = 0x29219dd400f2Bf60E5a23d13Be72B486D4038894 -- USDCAND "to" = 0xF75AE954D30217B4EE70DbFB33f04162aa3Cf260 -- Re7 USDCAND "from" IN (0x4E216C15697C1392fE59e1014B009505E05810Df -- 8, 0x322e1d5384aa4ED66AeCa770B95686271de61dc3 -- 20, 0x5954ce6671d97D24B782920ddCdBB4b1E63aB2De -- 23, 0x6030aD53d90ec2fB67F3805794dBB3Fa5FD6Eb64 -- 34, 0x11Ba70c0EBAB7946Ac84F0E6d79162b0cBb2693f -- 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