(

select

case

when contract_address = lower('0x628ff693426583D9a7FB391E54366292F509D457') then 'Base ETH'

-- when contract_address = lower('0xEdc817A28E8B93B03976FBd4a3dDBc9f7D176c22') then 'Base USDC'

-- when contract_address = lower('0xb682c840B5F4FC58B20769E691A6fa1305A501a2') then 'Base EURC'

-- when contract_address = lower('0x3bf93770f2d4a794c3d9EBEfBAeBAE2a8f09A5E5') then 'Base cbETH'

-- when contract_address = lower('0xF877ACaFA28c19b96727966690b2f44d35aD5976') then 'Base cbBTC'

-- when contract_address = lower('0x73902f619CEB9B31FD8EFecf435CbDf89E369Ba6') then 'Base AERO'

-- when contract_address = lower('0x627Fe393Bc6EdDA28e99AE648fD6fF362514304b') then 'Base wstETH'

-- when contract_address = lower('0xcb1dacd30638ae38f2b94ea64f066045b7d45f44') then 'Base rETH'

-- when contract_address = lower('0xb8051464C8c92209C92F3a4CD9C73746C4c3CFb3') then 'Base weETH'

-- when contract_address = lower('0xfC41B49d064Ac646015b459C522820DB9472F4B5') then 'Base wrsETH'

end as pool,

date_trunc('day', block_timestamp) as day,

sum(amount) as deposits_daily,

sum(deposits_daily) over (partition by pool order by day asc) as deposits_cumulative

from base.defi.ez_lending_deposits

where contract_address in

(

lower('0x628ff693426583D9a7FB391E54366292F509D457')

-- lower('0xEdc817A28E8B93B03976FBd4a3dDBc9f7D176c22'),

-- lower('0xb682c840B5F4FC58B20769E691A6fa1305A501a2'),

-- lower('0x3bf93770f2d4a794c3d9EBEfBAeBAE2a8f09A5E5'),

-- lower('0xF877ACaFA28c19b96727966690b2f44d35aD5976'),

-- lower('0x73902f619CEB9B31FD8EFecf435CbDf89E369Ba6'),

-- lower('0x627Fe393Bc6EdDA28e99AE648fD6fF362514304b')

-- lower('0xcb1dacd30638ae38f2b94ea64f066045b7d45f44'),

-- lower('0xb8051464C8c92209C92F3a4CD9C73746C4c3CFb3'),

-- lower('0xfC41B49d064Ac646015b459C522820DB9472F4B5')

)

and event_name = 'Mint'

group by pool, day

),

base_withdraws as