DATE_TRUNC('day', block_timestamp) AS day,

AVG(token_price) AS average_price,

SUM(amount_usd) AS total_volume

optimism.core.ez_token_transfers

contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97')

GROUP BY

DATE_TRUNC('day', block_timestamp)

ORDER BY

day;