SELECT

CAST(DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE) AS date,

SUM(AMOUNT) AS eth

FROM ethereum.core.ez_eth_transfers

WHERE ETH_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- Optimism Main Bridge Contract (V1)

AND date > CURRENT_DATE - 5

GROUP BY date