Query editor
with pepe_bought AS(SELECTtaker AS address,SUM(cast(amount_usd AS DOUBLE)) AS usd_amount,SUM(cast(token_bought_amount AS DOUBLE)) AS pepe_boughtFROM dex.tradesWHERE token_bought_address = 0x6982508145454Ce325dDbE47a25d4ec3d2311933GROUP BY 1),pepe_inflow AS(SELECTto AS address,SUM(cast(value AS DOUBLE)/1e18) AS pepe_inflowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x6982508145454Ce325dDbE47a25d4ec3d2311933GROUP BY 1),pepe_outflow AS(SELECT"from" AS address,SUM(cast(value AS DOUBLE)/1e18) AS pepe_outflowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x6982508145454Ce325dDbE47a25d4ec3d2311933GROUP BY 1)SELECTpepe_bought.address,pepe_bought.usd_amount AS cost_basis,0.000000175224*pepe_bought.pepe_bought AS usd_value,(0.000000175224*pepe_bought.pepe_bought)-pepe_bought.usd_amount AS pnl,pepe_bought.pepe_bought,pepe_inflow.pepe_inflow,pepe_outflow.pepe_outflowFROM pepe_boughtLEFT JOIN pepe_inflow ON pepe_bought.address = pepe_inflow.addressLEFT JOIN pepe_outflow ON pepe_bought.address = pepe_outflow.addressWHERE pepe_outflow.pepe_outflow is NULLORDER BY pepe_bought DESC