with weekly_borrowed as
(select
date_trunc('week', block_timestamp) as week,
avg(amount_usd) as avg_borrowed
from
anchor.borrows
group by
week),
weekly_deposits as
(select
date_trunc('week', block_timestamp) as week,
avg(deposit_amount_usd) as avg_deposits
from
anchor.deposits
group by 1
)
select
weekly_deposits.week as week,
avg_deposits,
avg_borrowed
from weekly_deposits
inner join weekly_borrowed on weekly_deposits.week = weekly_borrowed.week