MLDZMNLends
    Updated 2023-09-20
    with lend as (select
    tx_id,signers[0] as lender
    from solana.core.fact_transactions s
    join (select distinct block_timestamp, tx_id
    from solana.core.fact_events where succeeded = True
    and program_id = '5D9yi4BKrxF8h65NkVE1raCCWFKUs5ngub2ECxhvfaZe'
    ) events
    using(tx_id, block_timestamp)
    join lateral flatten (input => log_messages) logs
    where BLOCK_TIMESTAMP >= current_date-{{Days_back}}
    and logs.value in('Program log: Instruction: LoanFund','Program log: Instruction: OpenTermLoanFund')
    )


    select
    s.tx_id,
    s.BLOCK_TIMESTAMP as date,
    lender,
    amount,
    'USDC' as token
    from solana.core.fact_transfers s
    left join lend l on s.tx_id=l.tx_id
    where s.tx_id in (select tx_id from lend)
    --and tx_to = '7Vqn5fdwckZadYVoH312aErP8PqNGNUx8WDrvKAHYfMd'
    and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    Run a query to Download Data