t1 as (

SELECT

trunc (block_hour,'day') as date,

symbol,

avg(reserve_price) as price,

avg(supply_rate)*100 as supply_apy,

avg(borrow_rate_stable)*100 as borrow_stable_apy,

avg(borrow_rate_variable)*100 as borrow_variable_apy

FROM ethereum.aave.ez_market_stats x

LEFT JOIN ethereum.core.dim_contracts y on lower(x.aave_market) = y.address

GROUP BY 1,2

),

t2 AS (

SELECT

trunc (block_timestamp,'day') as date,

y.symbol as symbol,

avg(token_price) AS price,

sum(issued_tokens) AS supply_amount,

sum(supplied_usd) AS supply_volume_usd

FROM flipside_prod_db.aave.deposits x

LEFT JOIN ethereum.core.dim_contracts y

ON x.aave_market=y.address

where depositor_address='{{user_address}}'

GROUP BY 1,2

),

t3 AS (

SELECT

trunc (block_timestamp,'day') as date,

y.symbol,

avg(token_price) AS price,

sum(borrowed_tokens) AS borrow_amount,

sum(borrowed_usd) AS borrow_volume_usd

FROM flipside_prod_db.aave.borrows x

LEFT JOIN ethereum.core.dim_contracts y

ON x.aave_market=y.address