DATE_TRUNC('day', BLOCK_TIMESTAMP) AS trade_date,

COUNT(TX_HASH) AS trade_count,

SUM(AMOUNT_USD) AS total_volume_usd

FROM

arbitrum.vertex.ez_perp_trades

WHERE block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP)

AND TRADER != '0x0000000000000000000000000000000000000000'

GROUP BY

trade_date

ORDER BY

trade_date DESC;