borrow as (

select

tx_id, block_timestamp, signers[0] as Borrower

from solana.core.fact_decoded_instructions

where program_id = 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD'

and event_type = 'borrowObligationLiquidity'

and block_timestamp >= current_timestamp - interval '{{days}} days'

group by 1,2,3

),

prices as (

select

date_trunc(day, hour) as date,

TOKEN_ADDRESS,

SYMBOL,

avg(PRICE) as price

from

solana.price.ez_prices_hourly

where

date >= current_timestamp - interval '{{days}} days'

group by

1,

2,

),

Borrow_Volume as (

date_trunc(day, fact_transfers.block_timestamp) as date,

sum(AMOUNT * price) as BorrowVolume

solana.core.fact_transfers

join borrow on fact_transfers.tx_id = borrow.tx_id

and fact_transfers.block_timestamp :: date = borrow.block_timestamp :: date

and fact_transfers.tx_to = borrow.Borrower

join prices on prices.TOKEN_ADDRESS = fact_transfers.MINT

and fact_transfers.block_timestamp :: date = prices.date :: date