SELECT TX_ID,

INSTRUCTION['accounts'][6] as ob_pubkey,

INSTRUCTION['accounts'][3] as loan_id

FROM solana.core.fact_events

WHERE date(BLOCK_TIMESTAMP) > current_date() - INTERVAL '23 DAYS'

AND LEFT(INSTRUCTION['data'], 6) = '2pxy3Z'

AND SUCCEEDED = 'true'

),

defaults as (

SELECT --TX_ID,

INSTRUCTION['accounts'][0] as loan_id,

--INSTRUCTION['accounts'][3] as nft,

BLOCK_TIMESTAMP,

1 as default

FROM solana.core.fact_events

WHERE date(BLOCK_TIMESTAMP) > current_date() - INTERVAL '7 DAYS'

AND LEFT(INSTRUCTION['data'], 4) = 'PsML'

AND SUCCEEDED = 'true'

),

repays as(

SELECT

--TX_ID,

INSTRUCTION['accounts'][0] as loan_id,

1 as repay

FROM solana.core.fact_events

WHERE date(BLOCK_TIMESTAMP) > current_date() - INTERVAL '7 DAYS'

AND LEFT(INSTRUCTION['data'], 4) = 'HJhK'

AND SUCCEEDED = 'true'

),

extends as (

SELECT

--TX_ID