Query editor
-- Prepared from query 6964606 version 12, rechecked unchanged before this edit.-- Robinhood addition only: token map, raw mint/burn events, zero states and address.-- The shared-query candidate has not been executed in Dune.-- Preserves the existing Ondo dated-price/current-price-fallback behavior.WITH params AS (SELECT DATE '2025-07-01' AS start_date, CURRENT_DATE AS end_date),xstocks_components AS (SELECTCAST(q.day AS DATE) AS day,CAST(q.symbol AS VARCHAR) AS symbol,CAST(q.name AS VARCHAR) AS name,CAST(q.total_nominal_balance AS DOUBLE) AS nominal_balance,CAST(q.total_aum_usd AS DOUBLE) AS aum_usdFROM dune.buccaneers.result_tokenized_stocks_xstocks_ecosystem_aum_v1 qCROSS JOIN params pWHERE CAST(q.day AS DATE) BETWEEN p.start_date AND p.end_dateUNION ALLSELECTCAST(q.day AS DATE) AS day,CAST(q.symbol AS VARCHAR) AS symbol,CAST(q.name AS VARCHAR) AS name,CAST(q.nominal_balance AS DOUBLE) AS nominal_balance,CAST(q.aum_usd AS DOUBLE) AS aum_usdFROM dune.buccaneers.result_tokenized_stocks_xstocks_ton_aum_daily_v1 qCROSS JOIN params pWHERE CAST(q.day AS DATE) BETWEEN p.start_date AND p.end_dateUNION ALLSELECTCAST(q.day AS DATE) AS day,CAST(q.symbol AS VARCHAR) AS symbol,CAST(q.name AS VARCHAR) AS name,CAST(q.nominal_balance AS DOUBLE) AS nominal_balance,CAST(q.aum_usd AS DOUBLE) AS aum_usdFROM dune.buccaneers.result_tokenized_stocks_xstocks_mantle_aum_daily_v1 qCROSS JOIN params pWHERE CAST(q.day AS DATE) BETWEEN p.start_date AND p.end_date),xstocks_daily AS (SELECTday,symbol,MAX_BY(name, CASE WHEN name IS NULL OR name = '' THEN 0 ELSE 1 END) AS name,SUM(COALESCE(nominal_balance, CAST(0 AS DOUBLE))) AS total_nominal_balance,SUM(COALESCE(aum_usd, CAST(0 AS DOUBLE))) AS fallback_total_aum_usdFROM xstocks_componentsGROUP BY 1, 2),xstocks_target_solana_tokens AS (SELECT *FROM (VALUES('BMNRx', 'Bitmine xStock', 'XsrBCwaH8c46xiqXBChzobgufRKxQxAWUWbndgBNzFn'),('METAx', 'Meta xStock', 'Xsa62P5mvPszXL1krVUnU5ar38bBSVcWAB6fmPCo5Zu')) AS t(symbol, name, token_mint_address)),