WITH market_impact AS (
SELECT
SYMBOL AS market,
AVG(PRICE_AMOUNT) AS avg_price,
SUM(AMOUNT_USD) AS total_volume_usd,
SUM(ABS(FEE_AMOUNT)) AS total_fees
FROM
arbitrum.vertex.ez_perp_trades
GROUP BY
market
ORDER BY
total_volume_usd DESC
)
SELECT
market,
avg_price,
total_volume_usd,
total_fees
FROM
market_impact
LIMIT
10;