Query editor
-- Original code sourced from @masroor/ETH to Canto TokensWITH price AS (SELECTDATE_TRUNC('day',minute) AS dt,AVG(price) AS eth_priceFROM prices."usd"WHERE symbol = 'WETH'AND minute > '2022-07-14'GROUP BY 1),txns AS (SELECT"block_time" AS time,DATE_TRUNC('day',"block_time") AS day,"from",CASE WHEN substring(input FROM 17 for 20) = '\xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'THEN bytea2numeric(substring(input FROM 69 for 32)) / 1e6ELSE 0END AS usdc,CASE WHEN substring(input FROM 17 for 20) = '\xdac17f958d2ee523a2206206994597c13d831ec7'THEN bytea2numeric(substring(input FROM 69 for 32)) / 1e6ELSE 0END AS usdt,CASE WHEN substring(input FROM 17 for 20) = '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'THEN bytea2numeric(substring(input FROM 69 for 32)) / 1e18 * eth_priceELSE 0END AS weth_usdFROM ethereum."traces" eLEFT JOIN price p ON DATE_TRUNC('day',e."block_time") = p.dtWHERE substring(input FROM 1 for 4) = '\x0f212357'AND (substring(input FROM 133 for 5)) = '\x63616E746F'AND tx_success = 'true'),sums AS (SELECT*,cum_usdc + cum_usdt + cum_weth_usd AS cum_totalFROM (SELECT*,usdc + usdt + weth_usd AS dayly_total,SUM(usdc) OVER(ORDER BY day) AS cum_usdc,SUM(usdt) OVER(ORDER BY day) AS cum_usdt,SUM(weth_usd) OVER(ORDER BY day) AS cum_weth_usdFROM (SELECTday,SUM(usdc) AS usdc,SUM(usdt) AS usdt,SUM(weth_usd) AS weth_usdFROM txnsGROUP BY 1) sub1) sub2)SELECT *