COUNT(DISTINCT tx_hash) AS tx_count,

COUNT(DISTINCT trader) AS unique_trader_count,

COUNT(DISTINCT symbol) AS unique_token_count,

SUM(amount_usd) AS tx_vol,

tx_count / unique_trader_count AS average_transactions_per_user,

tx_vol / unique_trader_count AS average_volume_per_user,

tx_vol / tx_count AS average_volume_per_transaction,

sum(fee_amount) as protocol_fee

FROM

arbitrum.vertex.ez_perp_trades

is_taker = true and

block_timestamp::date = current_date - interval '1 day'