Query editor
-- Full xStocks list with AUM > $1 USD (LIVE, not point-in-time).-- Supply: Backed per-token circulating-supply endpoint (covers every registry token;-- the daily-supply/last-day endpoint omits ~500 low-activity tokens).-- Price: dune.xstocks.result_latest_x_stocks_prices (latest).WITH reg AS (SELECT json_parse(http_get('https://api.backed.fi/rest/tokens')) AS js),tokens AS (SELECT DISTINCTjson_extract_scalar(token, '$.symbol') AS symbol,json_extract_scalar(token, '$.name') AS name,json_extract_scalar(token, '$.isTradingHalted') AS is_haltedFROM reg CROSS JOIN UNNEST(CAST(json_extract(js, '$.nodes') AS ARRAY(JSON))) AS t(token)),supply AS (SELECT symbol, name, is_halted,TRY(CAST(json_extract_scalar(json_parse(http_get('https://api.backed.fi/rest/tokens/' || symbol || '/circulating-supply')), '$.value') AS DOUBLE)) AS supply_unitsFROM tokens),px AS (SELECT symbol, MAX(price) AS price_usd FROM dune.xstocks.result_latest_x_stocks_prices WHERE price > 0 GROUP BY symbol),joined AS (SELECT s.symbol, s.name, s.is_halted, s.supply_units, p.price_usd,CASE WHEN p.price_usd IS NULL THEN 'unpriced' ELSE 'priced' END AS price_status,s.supply_units * p.price_usd AS aum_usdFROM supply s LEFT JOIN px p ON p.symbol = s.symbolWHERE s.supply_units > 0)SELECT symbol, name, is_halted, supply_units, price_usd, price_status, aum_usd,SUM(aum_usd) OVER () AS total_priced_aum_usd,COUNT_IF(price_status = 'priced') OVER () AS n_priced,COUNT_IF(price_status = 'unpriced') OVER () AS n_unpricedFROM joinedWHERE aum_usd > 1 OR price_status = 'unpriced'ORDER BY aum_usd DESC NULLS LAST, supply_units DESC