Query editor
SELECTsymbol,MAX(asset_name) AS name,day AS as_of_date,SUM(circulating_supply_units) AS supply_units,MAX(price_usd) AS price_usd,SUM(aum_usd) AS aum_usd,ARRAY_JOIN(ARRAY_SORT(ARRAY_DISTINCT(ARRAY_AGG(pricing_source))), ',') AS pricing_sourcesFROM dune.buccaneers.result_tokenized_stocks_asset_state_daily_v01WHERE provider = 'xstocks'AND day = DATE '2026-09-30'GROUP BY symbol, dayHAVING SUM(aum_usd) > 0ORDER BY aum_usd DESC