supply AS (

SELECT

dc.symbol as symbol,sum(supplied_usd) AS volume_supplied

FROM ethereum.aave.ez_deposits d JOIN ethereum.core.dim_contracts dc ON d.aave_market=dc.address

where depositor_address like '{{user_address}}'

GROUP BY 1

),

borrow as (

SELECT

dc.symbol, sum(borrowed_usd) AS volume_borrowed

FROM ethereum.aave.ez_borrows b JOIN ethereum.core.dim_contracts dc ON b.aave_market=dc.address

where borrower_address='{{user_address}}'

GROUP BY 1

),

loans as (

SELECT

symbol,

SUM(FLASHLOAN_AMOUNT_USD) as volume_loaned

FROM ethereum.aave.ez_flashloans

where INITIATOR_ADDRESS like '{{user_address}}'

GROUP BY 1

),

repayment AS (

select

symbol,

SUM(repayed_usd) as volume_repayed

FROM ethereum.aave.ez_repayments

where borrower like '{{user_address}}'

GROUP BY 1

),

liquidations as (

select

DEBT_TOKEN_SYMBOL as symbol,

SUM(LIQUIDATED_AMOUNT_USD) as VOLUME_liquidated

FROM ethereum.aave.ez_liquidations