from ethereum.aave.ez_borrows

where BLOCK_TIMESTAMP>=date'2023-01-01'

select BLOCK_TIMESTAMP, DEPOSITOR_ADDRESS

from ethereum.aave.ez_deposits

where BLOCK_TIMESTAMP>=date'2023-01-01'

union

select BLOCK_TIMESTAMP, INITIATOR_ADDRESS

from ethereum.aave.ez_flashloans

where BLOCK_TIMESTAMP>=date'2023-01-01'

union

select BLOCK_TIMESTAMP, BORROWER

from ethereum.aave.ez_liquidations

where BLOCK_TIMESTAMP>=date'2023-01-01'

union

select BLOCK_TIMESTAMP, PROPOSER

from ethereum.aave.ez_proposals

where BLOCK_TIMESTAMP>=date'2023-01-01'

union

select BLOCK_TIMESTAMP, BORROWER

from ethereum.aave.ez_repayments

where BLOCK_TIMESTAMP>=date'2023-01-01'

union

select BLOCK_TIMESTAMP, DEPOSITOR_ADDRESS

from ethereum.aave.ez_withdraws

where BLOCK_TIMESTAMP>=date'2023-01-01')

select

date (BLOCK_TIMESTAMP) day, COUNT(distinct BORROWER_ADDRESS ) user

from all_data

group by 1