SELECT TX_ID,

INSTRUCTIONS,

INSTRUCTIONS[1]['accounts'][0] as loan_id,

INSTRUCTIONS[1]['accounts'][5] as nft,

date_trunc('DAY', BLOCK_TIMESTAMP) as day

FROM solana.core.fact_transactions

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

AND LEFT(INSTRUCTIONS[1]['data'], 10) = 'CRZUQQ51dK'

AND SUCCEEDED = 'true'

),

defaults_collection as (

SELECT TX_ID,

loan_id,

nft,

day as default_day,

md.project_name

FROM defaults d

JOIN solana.core.dim_nft_metadata md

ON d.nft = md.mint

),

principals as (

SELECT

o.INSTRUCTIONS[0]['accounts'][6] as ob_pubkey,

o.INSTRUCTIONS[0]['accounts'][3] as loan_id,

t.amount as principal

FROM solana.core.fact_transactions o

JOIN solana.core.fact_transfers t

ON o.TX_ID = t.TX_ID

WHERE date(o.BLOCK_TIMESTAMP) > current_date() - INTERVAL '38 DAYS'

AND LEFT(o.INSTRUCTIONS[0]['data'], 14) = '2pxy3Z56gzjxyV'

AND o.SUCCEEDED = 'true'

),