Query editor
SELECTtoken_pair,APPROX_PERCENTILE(amount_usd, 0.5) AS median_trade,APPROX_PERCENTILE(amount_usd, 0.9) AS p90_trade,MAX(amount_usd) AS largest_tradeFROM dex.tradesGROUP BY 1ORDER BY largest_trade DESC;
Query editor
1SELECT2token_pair,3APPROX_PERCENTILE(amount_usd, 0.5) AS median_trade,4APPROX_PERCENTILE(amount_usd, 0.9) AS p90_trade,5MAX(amount_usd) AS largest_trade6FROM dex.trades7GROUP BY 18ORDER BY largest_trade DESC;9