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,

sum(fee_amount) as total_protocol_fee

FROM

arbitrum.vertex.ez_perp_trades

WHERE

is_taker = true and

block_timestamp::date >= '2024-01-01'