DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

SUM(AMOUNT) AS Volume,

SUM(SUM(AMOUNT)) OVER (ORDER BY DATE_TRUNC('day', BLOCK_TIMESTAMP)) AS Volume_OT

FROM blast.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = '0x4300000000000000000000000000000000000003'

AND (TO_ADDRESS = '0xa247cff2a50de0328a0a5bdd0c563bd44b1a8af9'

OR FROM_ADDRESS = '0xa247cff2a50de0328a0a5bdd0c563bd44b1a8af9')

GROUP BY 1

ORDER BY 1 DESC