Query editor
-- Query to show ALL xStocks tokens with their AUMWITH excluded_addr AS (SELECT CAST('S7vYFFWH6BjJyEsdrPQpqpYTqLTrPRK6KW3VwsJuRaS' AS VARCHAR) AS addr),-- Get all token contract addresses from the xStocks reference tabletoken_contract_addresses AS (SELECT DISTINCTCAST(address AS VARCHAR) AS address,CAST(pyth_id AS VARCHAR) AS pyth_idFROM query_5381782),-- Get ALL xStocks with their names (no filtering)all_xstocks AS (SELECTtc.address,tc.pyth_id,COALESCE(l.symbol, l.name, 'Unknown') AS symbol,COALESCE(l.name, 'Unknown') AS full_name,l.decimalsFROM token_contract_addresses tcLEFT JOIN tokens_solana.fungible l ON l.token_mint_address = tc.address),-- Calculate supply for all tokenssupply AS (SELECTlb.token_mint_address AS address,SUM(lb.token_balance) AS supplyFROM solana_utils.latest_balances lbLEFT JOIN excluded_addr ea ON lb.token_balance_owner = ea.addrWHERE ea.addr IS NULLAND lb.token_balance <> 0AND lb.token_mint_address IN (SELECT address FROM all_xstocks)GROUP BY lb.token_mint_address),-- Get latest prices from DEXlatest_price AS (SELECT *FROM (SELECTph.contract_address AS address,CASE WHEN ph.price = INFINITY() THEN NULL ELSE ph.price END AS price,ROW_NUMBER() OVER (PARTITION BY ph.contract_address ORDER BY ph.hour DESC) AS rnFROM dex_solana.price_hour phWHERE ph.contract_address IN (SELECT address FROM all_xstocks)) tWHERE rn = 1),-- Get Pyth prices for all tokensall_ids AS (SELECT DISTINCT pyth_idFROM all_xstocksWHERE pyth_id IS NOT NULL AND pyth_id <> ''),price_url AS (SELECT'https://hermes.pyth.network/v2/updates/price/latest?ids[]=' ||array_join(array_agg(replace(pyth_id,'0x','')), '&ids[]=') AS urlFROM all_ids),backup_price_raw AS (