Query editor
WITH trades AS (SELECTblock_time,trader_id,amount_usd,token_bought_mint_address,token_sold_mint_addressFROM dex_solana.tradesWHERE (token_bought_mint_address = 'FH6jc68WzeAUXKp6uDg9QPciTeU75o32xFDzKLzmbonk'OR token_sold_mint_address = 'FH6jc68WzeAUXKp6uDg9QPciTeU75o32xFDzKLzmbonk')AND block_time > now() - interval '14' DAY),transfers AS (SELECTblock_time,from_owner AS source,to_owner AS destination,amountFROM tokens_solana.transfersWHERE token_mint_address = 'FH6jc68WzeAUXKp6uDg9QPciTeU75o32xFDzKLzmbonk'AND block_time > now() - interval '14' DAY),holders AS (SELECTto_owner AS owner,SUM(amount) AS balanceFROM tokens_solana.transfersWHERE token_mint_address = 'FH6jc68WzeAUXKp6uDg9QPciTeU75o32xFDzKLzmbonk'AND block_time > now() - interval '14' DAYGROUP BY to_owner),early_buyers AS (SELECTtrader_id AS wallet,MIN(block_time) AS first_buy_timeFROM tradesWHERE token_bought_mint_address = 'FH6jc68WzeAUXKp6uDg9QPciTeU75o32xFDzKLzmbonk'GROUP BY trader_id),whale_moves AS (SELECT *FROM transfersWHERE amount > 100000)-- Final MetricsSELECTMIN(trades.block_time) AS token_launch_time,COUNT(DISTINCT trader_id) AS total_traders,SUM(amount_usd) FILTER (WHERE trades.block_time > now() - interval '1' DAY) AS volume_24h_usd,(SELECT COUNT(*) FROM whale_moves) AS whale_transfers,(SELECT COUNT(*) FROM holders) AS total_holders,(SELECT MIN(first_buy_time) FROM early_buyers) AS earliest_first_buyer,(SELECT MAX(first_buy_time) FROM early_buyers) AS latest_first_buyerFROM trades;