Query editor
-- Dune query name: tokenized_stocks_xstocks_solana_aum_daily_v1-- Description: xStocks Solana daily AUM in USD, buccaneers-owned.-- Uses Backed's own per-deployment circulatingSupply as the-- float measure (from the materialized helper q8327395).-- Rationale:-- - On Solana, Backed mints tokens to issuer wallets first-- and later transfers them out; a mint/burn-only issuer-- exclusion would cancel 100% of supply.-- - A transfer-through exclusion (as in xstocks-team-- q5664941) has an edge-case double-count risk when-- tokens cycle through issuer wallets or move issuer--- to-issuer - see escalation-solana-aum-methodology--- 2026-08-14.md.-- - A balance-based exclusion using only the two named-- issuer wallets S7vYFF and HmMxm overcounts by ~3x-- ($1.4B vs $406M) because Backed uses additional-- custody/treasury/MM wallets that are not publicly-- enumerated. Discovering the full set from on-chain-- balance data alone is unreliable (heuristics based-- on wallet diversity give $115M-$284M, still off).-- - Backed's circulatingSupply is authoritative: they-- know their own wallet set. We trust that number and-- derive AUM as circulating * collateral.price.-- Historical days apply today's Backed circulating and-- today's Backed price flat -> supply-driven trajectory-- bounded by today's float. A proper daily-price + daily--- circulating history would require materializing Backed-- snapshots into a time-series (followup work).-- NO fallback for symbols Backed does not yet mark - we-- emit $0 for those (26 tokens as of 2026-08-14 including-- CMCSAx, CRWDx, HOODx, IWMx, JPMx, MAx, MRVLx, ORCLx, QQQx,-- VTIx, VTx). A previous fallback path multiplying on-chain-- mint-burn supply by oclsanti per-share stock prices-- produced a $313M overcount because on-chain supply-- includes issuer/custody wallet balances that Backed-- excludes but which we cannot enumerate.-- Materialize as dune.buccaneers.result_tokenized_stocks_xstocks_solana_aum_daily_v1-- Reference in tokenized_stocks_xstocks_chain_aum_daily_base_v1 (query 6998488).WITH backed_snapshot AS (SELECT token_mint_address, symbol, underlying_ticker,backed_price_usd, backed_circulating_supplyFROM query_8327395),xstocks_solana_tokens AS (SELECT DISTINCT token_mint_address, symbol, underlying_tickerFROM backed_snapshot),-- On-chain mint-burn supply (used ONLY for tokens Backed doesn't mark, and to-- derive the historical supply-growth shape).xstocks_solana_meta AS (SELECTtoken_mint_address,COALESCE(TRY_CAST(MAX(decimals) AS INTEGER), 8) AS decimalsFROM tokens_solana.fungibleWHERE token_mint_address IN (SELECT token_mint_address FROM xstocks_solana_tokens)GROUP BY 1),xstocks_solana_supply_deltas AS (SELECT