Query editor
-- COUNTER: Total AUM (Combined Market Cap) of ALL xStocks tokensWITH excluded_addr AS (SELECT CAST('S7vYFFWH6BjJyEsdrPQpqpYTqLTrPRK6KW3VwsJuRaS' AS VARCHAR) AS addr),token_contract_addresses AS (SELECT DISTINCTCAST(address AS VARCHAR) AS address,CAST(pyth_id AS VARCHAR) AS pyth_idFROM query_5381782),all_xstocks AS (SELECTtc.address,tc.pyth_id,COALESCE(l.symbol, l.name, 'Unknown') AS symbolFROM token_contract_addresses tcLEFT JOIN tokens_solana.fungible l ON l.token_mint_address = tc.address),supply 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),latest_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),all_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 (SELECT json_parse(http_get(url)) AS js FROM price_url),backup_price AS (SELECTax.address,CAST(json_extract_scalar(p,'$.price.price') AS DOUBLE) *pow(10, CAST(json_extract_scalar(p,'$.price.expo') AS INT)) AS price