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 trades_last_week AS (SELECTtrader_id,SUM(amount_usd) AS total_volume,SUM(fee_usd) AS total_feesFROM dex_solana.tradesWHEREblock_time >= (CURRENT_DATE - INTERVAL '7' day)GROUP BYtrader_id), pnl_calculation AS (SELECTtrader_id,total_volume - total_fees AS pnlFROM trades_last_week)SELECTtrader_id,pnlFROM pnl_calculationORDER BYpnl DESCLIMIT 10