with event as (
SELECT ORIGIN_TO_ADDRESS as o_a,
EVENT_NAME,
TX_HASH as t_h
FROM ethereum.core.fact_event_logs
WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - 30
AND ORIGIN_TO_ADDRESS = lower('0xd89a09084555a7d0abe7b111b1f78dfeddd638be')
AND EVENT_NAME = 'Deposit'
)
SELECT
DATE(BLOCK_TIMESTAMP) AS dates,
sum(AMOUNT) AS sum,
sum(sum)over(order by dates) as cumulative
FROM ethereum.core.ez_token_transfers JOIN event ON TO_ADDRESS = o_a AND TX_HASH = t_h
WHERE SYMBOL LIKE 'USDC'
GROUP by 1
ORDER by 1