SELECT

symbol,

COUNT(DISTINCT digest) AS total_trades,

SUM(CASE WHEN is_taker = FALSE THEN amount_usd ELSE 0 END) AS total_volume,

COUNT(DISTINCT trader) AS total_traders

FROM

arbitrum.vertex.ez_perp_trades

WHERE

trader != '0x0000000000000000000000000000000000000000'

AND subaccount != '0x0000000000000000000000000000000000000000000000000000000000000001'

GROUP BY

symbol

),

market_rankings AS (

SELECT

symbol,

total_trades,

total_volume,

total_traders,

RANK() OVER (ORDER BY total_trades DESC) AS trade_rank,

RANK() OVER (ORDER BY total_volume DESC) AS volume_rank,

RANK() OVER (ORDER BY total_traders DESC) AS trader_rank

FROM

market_data

SELECT

symbol,

total_trades,

total_volume,

total_traders,

trade_rank,

volume_rank,

trader_rank

FROM