Query editor
WITH components AS (SELECT CAST(day AS DATE) AS day, CAST(symbol AS VARCHAR) AS symbol, CAST(name AS VARCHAR) AS name,CAST(total_nominal_balance AS DOUBLE) AS units, CAST(total_aum_usd AS DOUBLE) AS aum_usdFROM dune.buccaneers.result_tokenized_stocks_xstocks_ecosystem_aum_v1UNION ALLSELECT CAST(day AS DATE), CAST(symbol AS VARCHAR), CAST(name AS VARCHAR),CAST(nominal_balance AS DOUBLE), CAST(aum_usd AS DOUBLE)FROM dune.buccaneers.result_tokenized_stocks_xstocks_ton_aum_daily_v1UNION ALLSELECT CAST(day AS DATE), CAST(symbol AS VARCHAR), CAST(name AS VARCHAR),CAST(nominal_balance AS DOUBLE), CAST(aum_usd AS DOUBLE)FROM dune.buccaneers.result_tokenized_stocks_xstocks_mantle_aum_daily_v1)SELECTsymbol,MAX_BY(name, CASE WHEN name IS NULL OR name = '' THEN 0 ELSE 1 END) AS name,day AS as_of_date,SUM(COALESCE(units, 0)) AS supply_units,SUM(COALESCE(aum_usd, 0)) AS aum_usd,SUM(COALESCE(aum_usd, 0)) / NULLIF(SUM(COALESCE(units, 0)), 0) AS implied_price_usdFROM componentsWHERE day = DATE '2026-09-30'GROUP BY symbol, dayHAVING SUM(COALESCE(aum_usd, 0)) > 0ORDER BY aum_usd DESC