Query editor
SELECTdate_trunc('hour',block_time) as time,COUNT(*) as n_samples,APPROX_PERCENTILE(value,.5) as USDFROM (SELECTamount_usd/token_bought_amount as value,block_timeFROM dex_solana.tradesWHERE block_time >= DATE('2024-01-31')and amount_usd > 1and amount_usd is not nulland token_bought_amount > 0and token_bought_mint_address = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'UNION ALLSELECTamount_usd/token_sold_amount as value,block_timeFROM dex_solana.tradesWHERE block_time >= DATE('2024-01-31')and amount_usd is not nulland token_sold_amount > 0and token_sold_mint_address = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN') fWHERE value < 1000GROUP BY 1ORDER BY 1 DESC