SELECT

BLOCK_TIMESTAMP,

TX_ID,

INSTRUCTION:accounts [9] as WALLET,

INSTRUCTION:accounts [15] as MINT,

VALUE:parsed:info:lamports as SOL_AMOUNT

FROM

solana.core.fact_events,

LATERAL FLATTEN(INPUT => INNER_INSTRUCTION:instructions)

WHERE

BLOCK_TIMESTAMP >= '2023-11-01'

AND PROGRAM_ID = 'LendY9EXmeiJLHipx1giNrpRVpqo68oWvzTjVYrKxQe' -- AND TX_ID = '2Ts2yxEAftCEjQEgzun4aC5MyXkpGqfX6ZTQPGxrfMyYeWsD2jedxZDCHfo5zkMLeVKhqvPAr74HwqYWpFPVXcXX'

AND INSTRUCTION:data = 'N'

AND VALUE:parsed:type = 'transfer'

AND VALUE:parsed:info:destination != 'APJnFnA7dBC88HF1atgFXYYCS3hmDwfeNPJ6uZAeqYp9'

),

NFT_BORROWS AS (

SELECT

BLOCK_TIMESTAMP,

TX_ID,

WALLET,

MINT,

MAX(SOL_AMOUNT) / POW(10, 9) AS SOL_AMOUNT

FROM

NFT_BORROWS_RAW

GROUP BY

BLOCK_TIMESTAMP,

TX_ID,

WALLET,

MINT

) -- SELECT