SELECT DATE_DAY AS DATE

FROM ethereum.core.dim_dates

WHERE

date::date >= '2022-03-20'

AND date <= CURRENT_DATE

),

t1 AS (

SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) AS dt1, SUM(AMOUNT) AS Deposit

FROM ethereum.core.ez_eth_transfers

WHERE ETH_TO_ADDRESS = LOWER('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')

GROUP BY 1),

t2 AS (

SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) AS dt2, SUM(AMOUNT) AS withdraw

FROM ethereum.core.ez_eth_transfers

WHERE ETH_FROM_ADDRESS = LOWER('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')

GROUP BY 1),

t3 AS (

SELECT Date, zeroifnull(deposit) AS Deposit_to_starknet, zeroifnull(withdraw)*(-1) AS withdraw_from_starknet

FROM t0

LEFT JOIN t1 ON t0.date=t1.dt1

LEFT JOIN t2 ON t0.date=t2.dt2 )

SELECT Date, Deposit_to_starknet, withdraw_from_starknet,

SUM(Deposit_to_starknet+withdraw_from_starknet) OVER (ORDER BY DATE) AS Starknet_ETH_Balance

FROM t3