Query editor
1SELECT2 token_pair,3 COUNT(*) AS trades_per_day,4 STDDEV(amount_usd) AS volatility_proxy5FROM dex.trades6WHERE blockchain = 'mantle'7 AND block_time >= NOW() - INTERVAL '30' day8GROUP BY token_pair9ORDER BY volatility_proxy DESC;10
SELECT
token_pair,
COUNT(*) AS trades_per_day,
STDDEV(amount_usd) AS volatility_proxy
FROM dex.trades
WHERE blockchain = 'mantle'
AND block_time >= NOW() - INTERVAL '30' day
GROUP BY token_pair
ORDER BY volatility_proxy DESC;