Query editor
/*Table(s): dex_solana.tradesReason: Curated dataset recommendationsTable(s): solana_oms_proxy_solana.solana_oms_proxy_call_swapwhirlpoolReason: Based on contract addresses or possible project names*/WITH memecoin_trades AS (SELECTtrader_id,token_bought_symbol,token_sold_symbol,SUM(amount_usd) AS total_usdFROM dex_solana.tradesWHEREblock_time >= (CURRENT_DATE - INTERVAL '7' day)AND (token_bought_symbol IN ('DOGE', 'SHIB', 'PEPE', 'FLOKI', 'BABYDOGE')OR token_sold_symbol IN ('DOGE', 'SHIB', 'PEPE', 'FLOKI', 'BABYDOGE'))GROUP BYtrader_id,token_bought_symbol,token_sold_symbol), trader_pnl AS (SELECTtrader_id,SUM(CASEWHEN token_bought_symbol IN ('DOGE', 'SHIB', 'PEPE', 'FLOKI', 'BABYDOGE')THEN total_usdELSE -total_usdEND) AS pnlFROM memecoin_tradesGROUP BYtrader_id), top_traders AS (SELECTtrader_id,pnlFROM trader_pnlORDER BYpnl DESCLIMIT 10), top_tokens AS (SELECTtoken_bought_symbol AS token,SUM(total_usd) AS total_usdFROM memecoin_tradesWHEREtrader_id IN (SELECTtrader_idFROM top_traders)