DATE_TRUNC('week', block_timestamp) AS week,

AVG(token_price) AS average_price,

SUM(amount_usd) AS total_volume,

COUNT(DISTINCT tx_hash) AS weekly_transactions

optimism.core.ez_token_transfers

contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97')

GROUP BY

DATE_TRUNC('week', block_timestamp)

ORDER BY

week;