with removed_eth as(
SELECT
'ETH removed' as symbol,
block_timestamp::date as date,
sum(WITHDRAWN_TOKENS) as daily_removed
from ethereum.aave.ez_withdraws
where symbol in ('WETH','ETH') and date>=CURRENT_DATE-90
GROUP BY 1,2
UNION ALL
SELECT
'ETH removed' as symbol,
block_timestamp::date as date,
sum(BORROWED_TOKENS) as daily_removed
from ethereum.aave.ez_borrows
where symbol in ('WETH','ETH') and date>=CURRENT_DATE-90
GROUP BY 1,2),
deposited_eth as(
SELECT
'Deposit ETH' as symbol,
block_timestamp::date as date,
sum(REPAYED_TOKENS) as daily_deposited
from ethereum.aave.ez_repayments
where symbol in ('WETH','ETH') and date>=CURRENT_DATE-90
GROUP BY 1,2
UNION ALL
SELECT
'Deposit ETH' as symbol,
block_timestamp::date as date,
sum(ISSUED_TOKENS) as daily_deposited
from ethereum.aave.ez_deposits
where symbol in ('WETH','ETH') and date>=CURRENT_DATE-90
GROUP BY 1,2
)
SELECT
r.date,
case