Query editor
/*Solana Token Dashboard (Ultra-Robust Version)Engine: Dune SQL (Trino)Strategy: Using ONLY dex_solana.trades to ensure compatibility.Calculates "Net Accumulation" (Buys - Sells) as a proxy for balance.*/WITHparams AS (SELECT'61V8vBaqAGMpgDQi4JcAwo1dmBGHsyhzodcPqnEVpump' as token_addr,1000 as min_usd),-- Get all activity for this token in one passtoken_activity AS (SELECTtrader_id,block_time,amount_usd,CASE WHEN token_bought_mint_address = (SELECT token_addr FROM params) THEN token_bought_amount / 1e6 ELSE 0 END as tokens_bought,CASE WHEN token_sold_mint_address = (SELECT token_addr FROM params) THEN token_sold_amount / 1e6 ELSE 0 END as tokens_soldFROM dex_solana.tradesWHERE token_bought_mint_address = (SELECT token_addr FROM params)OR token_sold_mint_address = (SELECT token_addr FROM params)),launch_stats AS (SELECT MIN(block_time) as launch_time FROM token_activity),-- Calculate Current Net Accumulation (Proxy for Balance)wallet_balances AS (SELECTtrader_id as owner,SUM(tokens_bought) - SUM(tokens_sold) as current_balance,SUM(tokens_bought) as total_bought_everFROM token_activityGROUP BY 1HAVING (SUM(tokens_bought) - SUM(tokens_sold)) > 0),-- Smart Money: Check 30d performance of these specific traders on other tokensrecent_traders_list AS (SELECT DISTINCT trader_idFROM token_activityWHERE block_time > NOW() - INTERVAL '24' HOUR),historical_pnl AS (SELECTt.trader_id,t.token_bought_mint_address as other_token,SUM(CASE WHEN t.token_bought_mint_address <> (SELECT token_addr FROM params) THEN t.amount_usd ELSE 0 END) as spent,SUM(CASE WHEN t.token_sold_mint_address <> (SELECT token_addr FROM params) THEN t.amount_usd ELSE 0 END) as earnedFROM dex_solana.trades tWHERE t.trader_id IN (SELECT trader_id FROM recent_traders_list)AND t.block_time > NOW() - INTERVAL '30' DAYGROUP BY 1, 2),