Query editor
WITH token_trades AS (SELECTblock_time,trader_id,token_bought_symbol,token_sold_symbol,token_bought_mint_address,token_sold_mint_address,token_bought_amount,token_sold_amount,amount_usdFROMdex_solana.tradesWHEREblockchain = 'solana'AND (token_bought_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump' ORtoken_sold_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump')),buy_sell_summary AS (SELECTtrader_id,MIN(block_time) FILTER (WHERE token_bought_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump') AS first_buy_time,SUM(CASE WHEN token_bought_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump' THEN token_bought_amount ELSE 0 END) AS total_bought,SUM(CASE WHEN token_sold_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump' THEN token_sold_amount ELSE 0 END) AS total_sold,SUM(CASE WHEN token_bought_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump' THEN amount_usd ELSE 0 END) AS usd_spent,SUM(CASE WHEN token_sold_mint_address = 'rCDpCrYepyYffZz7AQhBV1LMJvWo7mps8fWr4Bvpump' THEN amount_usd ELSE 0 END) AS usd_receivedFROMtoken_tradesGROUP BYtrader_id),filtered_holders AS (SELECTtrader_id,first_buy_time,total_bought,total_sold,total_bought - total_sold AS current_balance,usd_spent,usd_received,(total_bought - total_sold) * 0.054 AS current_value_usd, -- 👈 adjust token price((total_bought - total_sold) * 0.054) - usd_spent AS profit_loss_usdFROMbuy_sell_summaryWHERE(total_bought - total_sold) > 0)SELECTtrader_id,first_buy_time,total_bought,total_sold,current_balance,ROUND(usd_spent, 2) AS usd_spent,ROUND(current_value_usd, 2) AS current_value_usd,