ChiefFFF Offers
    Updated 2023-02-16
    e-- it looks like this is an accepted loan offer, it possible this tx is about creating a loan offer -- tx_id = 5aFizkZjM9h2x4uFab7JMnSoYaAPHCEtWN6P8BFdPPEFUo8nHqxfNprZyJBB1Urf9KusJKajKsAyQMVRBrm1oPgq, it has initializeImmutableOwner create, transfer as oppsed to this tx_id = 3997r2BauQwcuUxtxWhE7P8jpXszTaAFYXbYf3EYbuX1d1WF1rPMJeaG2wD7dDg9Wb6kAj5WwonBTjXzxfx4Dyaw, which has transfer, thaw_account, revoke
    SELECT
    e.tx_id,
    parse_json(inner_instruction):instructions[3]:parsed:type as type,
    parse_json(inner_instruction):instructions[0]:parsed:type as init_loan,
    split(log_messages[1], ':')[2] as loanType,
    inner_instruction,
    tx_from,
    tx_to,
    mint,
    amount
    FROM
    solana.core.fact_events e
    JOIN
    solana.core.fact_transfers t ON e.tx_id = t.tx_id
    JOIN
    solana.core.fact_transactions as tx
    ON e.tx_id = tx.tx_id
    WHERE
    e.index = 1
    AND
    e.succeeded = True
    AND program_id = 'JCFRaPv7852ESRwJJGRy2mysUMydXZgVVhrMLmExvmVp'

    Run a query to Download Data