Query editor
WITH daily_totals AS (SELECTday,symbol,SUM(market_cap) AS market_capFROM query_6358702WHERE market_cap > 0GROUP BY 1, 2),monthly AS (SELECTdate_trunc('month', day) AS month,symbol,market_cap,ROW_NUMBER() OVER (PARTITION BY date_trunc('month', day), symbol ORDER BY day DESC) AS rnFROM daily_totals)SELECTmonth,SUM(market_cap) AS total_stablecoin_supplyFROM monthlyWHERE rn = 1GROUP BY 1ORDER BY 1