Query editor
-- Holder Analysis for ALL xStocks tokensWITH excluded_addr AS (SELECT CAST('S7vYFFWH6BjJyEsdrPQpqpYTqLTrPRK6KW3VwsJuRaS' AS VARCHAR) AS addr),token_contract_addresses AS (SELECT DISTINCTCAST(address AS VARCHAR) AS addressFROM query_5381782),all_xstocks AS (SELECTtc.address,COALESCE(l.symbol, l.name, 'Unknown') AS symbol,COALESCE(l.name, 'Unknown') AS full_nameFROM token_contract_addresses tcLEFT JOIN tokens_solana.fungible l ON l.token_mint_address = tc.address),-- Get all holders with balancesholders AS (SELECTlb.token_mint_address AS address,lb.token_balance_owner AS holder,lb.token_balance AS balanceFROM 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)),-- Calculate total supply per tokentoken_supply AS (SELECTaddress,SUM(balance) AS total_supplyFROM holdersGROUP BY address),-- Holder stats per tokenholder_stats AS (SELECTh.address,COUNT(DISTINCT h.holder) AS holder_count,SUM(h.balance) AS total_supply,AVG(h.balance) AS avg_balance,MAX(h.balance) AS max_balance,MIN(h.balance) AS min_balance,APPROX_PERCENTILE(h.balance, 0.5) AS median_balanceFROM holders hGROUP BY h.address),-- Top holder concentration (top 10 holders % of supply)top_holders AS (SELECTaddress,SUM(balance) AS top10_balanceFROM (SELECTaddress,holder,balance,