SELECT

block_timestamp,

tx_hash,

origin_from_address,

amount_in_usd,

token_in

FROM optimism.defi.ez_dex_swaps

WHERE block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '1 DAY'

COUNT(DISTINCT tx_hash) AS total_swaps,

COUNT(DISTINCT origin_from_address) AS total_swappers,

SUM(amount_in_usd) AS total_swap_volume,

COUNT(DISTINCT token_in) AS total_tokens,

ROUND(AVG(amount_in_usd), 2) AS average_swap_volume

FROM recent_data;