Query editor
-- Source: official xStocks team query 6084842 ("xStock - total daily AUM")-- Sliced to a single as-of date; max_day_available shows data coverage.WITH daily AS (SELECTsymbol,name,CAST(day AS DATE) AS day,total_aum_usdFROM query_6084842),cov AS (SELECT MAX(day) AS max_day_available FROM daily)SELECTd.symbol,d.name,d.day AS as_of_date,d.total_aum_usd AS aum_usd,SUM(d.total_aum_usd) OVER () AS total_aum_usd,c.max_day_availableFROM daily dCROSS JOIN cov cWHERE d.day = DATE '2026-09-30'ORDER BY d.total_aum_usd DESC