select

date(block_timestamp) as date,

median(gwei) as median_gwei

from

(

select

block_timestamp,

gas_price / pow(10, 9) as gwei

from

ethereum.transactions

)

group by

1

),

aave_borrows as (

select

date(block_timestamp) as date,

avg(borrowed_usd) as avg_borrow,

count(tx_id) as no_borrows

from

aave.borrows

group by

1

),

aave_deposits as (

select

date(block_timestamp) as date,

avg(supplied_usd) as avg_deposit,

count(tx_id) as no_deposits

from

aave.deposits

group by

1

)

select