COUNT(DISTINCT tx_hash) AS total_transaction_count,

COUNT(DISTINCT trader) AS unique_trader_count,

COUNT(DISTINCT symbol) AS unique_token_count,

SUM(amount_usd) AS total_transaction_volume,

total_transaction_count / unique_trader_count AS average_transactions_per_user,

total_transaction_volume / unique_trader_count AS average_volume_per_user,

total_transaction_volume / total_transaction_count AS average_volume_per_transaction

FROM

arbitrum.vertex.ez_perp_trades

WHERE

is_taker = true and

symbol = '{{token_name}}'