from aave.borrows

where dt >= CURRENT_DATE - 120

group by 1),

depo as (select date(block_timestamp) as dt, avg(supplied_usd) as average_supplied

from aave.deposits

group by 1),

fee as (select date(block_timestamp) as dt, avg(fee_usd) as average_gas_usd

from ethereum.transactions

where success = 'TRUE'

group by 1)

select a.dt, a.average_borrow, b.average_supplied, c.average_gas_usd

from borrow a

join depo b on a.dt = b.dt

join fee c on a.dt = c.dt