Query editor
WITH recent_tokens AS (-- tokens first traded in the past 14 daysSELECTtoken_bought_address AS token,MIN(block_time) AS first_trade_timeFROM dex.tradesWHERE blockchain = 'bnb'GROUP BY 1HAVING MIN(block_time) >= now() - interval '14' day),trades AS (SELECTt.block_time,t.tx_from AS wallet,t.token_bought_address AS token,t.token_bought_symbol AS symbol,t.amount_usd,'buy' AS sideFROM dex.trades tWHERE blockchain = 'bnb'AND t.amount_usd > 0UNION ALLSELECTt.block_time,t.tx_from AS wallet,t.token_sold_address AS token,t.token_sold_symbol AS symbol,-t.amount_usd AS amount_usd,'sell' AS sideFROM dex.trades tWHERE blockchain = 'bnb'AND t.amount_usd > 0),joined AS (SELECTtr.wallet,tr.token,tr.symbol,tr.block_time,tr.amount_usd,r.first_trade_time,date_diff('minute', r.first_trade_time, tr.block_time) AS mins_after_launchFROM trades trJOIN recent_tokens r ON tr.token = r.token),wallet_token_summary AS (SELECTwallet,token,symbol,SUM(CASE WHEN amount_usd > 0 THEN amount_usd ELSE 0 END) AS total_buy_usd,SUM(CASE WHEN amount_usd < 0 THEN -amount_usd ELSE 0 END) AS total_sell_usd,MIN(mins_after_launch) AS first_entry_min_after_launchFROM joinedGROUP BY 1,2,3