Kamino Lending historical data as Parquet
Every Kamino Lending instruction and event in Solana history, decoded with an Anchor IDL that we checked against real transactions. Trawl gives you 5 event tables and 66 instruction tables, with a column for each account, argument and field. Calls from other programs (CPI) are in the result too.
Updated
The preset
- Program
- KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD
- Preset
kamino-lending- Tables
- 5 event tables and 66 instruction tables, and
part-*with the raw bytes of each match - Price
- $4 for one recent epoch, $8.68 for one week of chain
The price is the same for every program: you pay for the archive the scan reads, not for the rows. Pricing.
# ask for a price: a 402 with the quote, no payment yet curl -X POST https://trawl.run/scan \ -H 'Content-Type: application/json' \ -d '{"preset":"kamino-lending","start_epoch":1058,"end_epoch":1058}' -- then, in DuckDB, on the files of the job SELECT slot, signature, before FROM 'ev-borrow_order_cancel_event-*.parquet' ORDER BY slot LIMIT 10;
Add "filter": {"accounts": ["<wallet>"]} to keep only the transactions
that touch one wallet. How a filter changes a preset.
Event tables
One table for each event in the IDL. Each row also has log_index and the context columns. An event
that the program writes two ways gives one row.
ev-borrow_order_cancel_eventbefore JSON stringev-borrow_order_full_fill_eventbefore JSON stringev-borrow_order_partial_fill_eventbefore JSON string, after JSON stringev-borrow_order_place_eventafter JSON stringev-borrow_order_update_eventbefore JSON string, after JSON stringInstruction tables
One table for each instruction in the IDL: the named accounts, then the arguments. Each row also has the context
columns: slot, tx_index, signature, success, fee, program_id, ix_index, is_inner, inner_index, stack_height, accounts. What each one
holds.
ix-init_lending_marketlendingMarketOwner, lendingMarket, lendingMarketAuthority, systemProgram, rent, instructionSysvarAccountargs:
quoteCurrency binaryix-update_lending_marketsigner, lendingMarket, instructionSysvarAccountargs:
mode u64, value binaryix-update_lending_market_ownerlendingMarketOwnerCached, lendingMarket, instructionSysvarAccountix-init_reservesigner, lendingMarket, lendingMarketAuthority, reserve, reserveLiquidityMint, reserveLiquiditySupply, feeReceiver, reserveCollateralMint, reserveCollateralSupply, initialLiquiditySource, rent, liquidityTokenProgram, collateralTokenProgram, systemProgram, instructionSysvarAccountix-clone_reserve_configsigner, targetLendingMarket, sourceReserve, targetReserve, instructionSysvarAccountargs:
customizations JSON stringix-init_farms_for_reservelendingMarketOwner, lendingMarket, lendingMarketAuthority, reserve, farmsProgram, farmsGlobalConfig, farmState, farmsVaultAuthority, rent, systemProgram, instructionSysvarAccountargs:
mode u8ix-update_reserve_configsigner, globalConfig, lendingMarket, reserve, instructionSysvarAccountargs:
mode variant name, value binary, skipConfigIntegrityValidation boolix-redeem_feesreserve, reserveLiquidityMint, reserveLiquidityFeeReceiver, reserveSupplyLiquidity, lendingMarket, lendingMarketAuthority, tokenProgramix-withdraw_protocol_feeglobalConfig, lendingMarket, reserve, reserveLiquidityMint, lendingMarketAuthority, feeVault, feeCollectorAta, tokenProgram, instructionSysvarAccountargs:
amount u64ix-seed_deposit_on_init_reservesigner, lendingMarket, reserve, reserveLiquidityMint, reserveLiquiditySupply, initialLiquiditySource, liquidityTokenProgramix-topup_reserve_rewardssigner, lendingMarket, reserve, reserveLiquidityMint, reserveLiquiditySupply, sourceLiquidity, liquidityTokenProgramargs:
amount u64ix-socialize_losslendingMarketOwner, obligation, lendingMarket, reserve, instructionSysvarAccountargs:
liquidityAmount u64ix-socialize_loss_v2socializeLossAccounts_lendingMarketOwner, socializeLossAccounts_obligation, socializeLossAccounts_lendingMarket, socializeLossAccounts_reserve, socializeLossAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, lendingMarketAuthority, farmsProgramargs:
liquidityAmount u64ix-mark_obligation_for_deleveraginglendingMarketOwner, obligation, lendingMarket, instructionSysvarAccountargs:
autodeleverageTargetLtvPct u8ix-refresh_reservereserve, lendingMarket, pythOracle, switchboardPriceOracle, switchboardTwapOracle, scopePricesix-refresh_reserves_batchskipPriceUpdates boolix-calculate_ctoken_exchange_ratereserveix-deposit_reserve_liquidityowner, reserve, lendingMarket, lendingMarketAuthority, reserveLiquidityMint, reserveLiquiditySupply, reserveCollateralMint, userSourceLiquidity, userDestinationCollateral, collateralTokenProgram, liquidityTokenProgram, instructionSysvarAccountargs:
liquidityAmount u64ix-redeem_reserve_collateralowner, lendingMarket, reserve, lendingMarketAuthority, reserveLiquidityMint, reserveCollateralMint, reserveLiquiditySupply, userSourceCollateral, userDestinationLiquidity, collateralTokenProgram, liquidityTokenProgram, instructionSysvarAccountargs:
collateralAmount u64ix-init_obligationobligationOwner, feePayer, obligation, lendingMarket, seed1Account, seed2Account, ownerUserMetadata, rent, systemProgramargs:
args JSON stringix-init_obligation_farms_for_reservepayer, owner, obligation, lendingMarketAuthority, reserve, reserveFarmState, obligationFarm, lendingMarket, farmsProgram, rent, systemProgramargs:
mode u8ix-refresh_obligation_farms_for_reservecrank, baseAccounts_obligation, baseAccounts_lendingMarketAuthority, baseAccounts_reserve, baseAccounts_reserveFarmState, baseAccounts_obligationFarmUserState, baseAccounts_lendingMarket, farmsProgram, rent, systemProgramargs:
mode u8ix-refresh_obligationlendingMarket, obligationix-deposit_obligation_collateralowner, obligation, lendingMarket, depositReserve, reserveDestinationCollateral, userSourceCollateral, tokenProgram, instructionSysvarAccountargs:
collateralAmount u64ix-deposit_obligation_collateral_v2depositAccounts_owner, depositAccounts_obligation, depositAccounts_lendingMarket, depositAccounts_depositReserve, depositAccounts_reserveDestinationCollateral, depositAccounts_userSourceCollateral, depositAccounts_tokenProgram, depositAccounts_instructionSysvarAccount, lendingMarketAuthority, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgramargs:
collateralAmount u64ix-withdraw_obligation_collateralowner, obligation, lendingMarket, lendingMarketAuthority, withdrawReserve, reserveSourceCollateral, userDestinationCollateral, tokenProgram, instructionSysvarAccountargs:
collateralAmount u64ix-withdraw_obligation_collateral_v2withdrawAccounts_owner, withdrawAccounts_obligation, withdrawAccounts_lendingMarket, withdrawAccounts_lendingMarketAuthority, withdrawAccounts_withdrawReserve, withdrawAccounts_reserveSourceCollateral, withdrawAccounts_userDestinationCollateral, withdrawAccounts_tokenProgram, withdrawAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgramargs:
collateralAmount u64ix-borrow_obligation_liquidityowner, obligation, lendingMarket, lendingMarketAuthority, borrowReserve, borrowReserveLiquidityMint, reserveSourceLiquidity, borrowReserveLiquidityFeeReceiver, userDestinationLiquidity, referrerTokenState, tokenProgram, instructionSysvarAccountargs:
liquidityAmount u64ix-borrow_obligation_liquidity_v2borrowAccounts_owner, borrowAccounts_obligation, borrowAccounts_lendingMarket, borrowAccounts_lendingMarketAuthority, borrowAccounts_borrowReserve, borrowAccounts_borrowReserveLiquidityMint, borrowAccounts_reserveSourceLiquidity, borrowAccounts_borrowReserveLiquidityFeeReceiver, borrowAccounts_userDestinationLiquidity, borrowAccounts_referrerTokenState, borrowAccounts_tokenProgram, borrowAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgramargs:
liquidityAmount u64ix-repay_obligation_liquidityowner, obligation, lendingMarket, repayReserve, reserveLiquidityMint, reserveDestinationLiquidity, userSourceLiquidity, tokenProgram, instructionSysvarAccountargs:
liquidityAmount u64ix-repay_obligation_liquidity_v2repayAccounts_owner, repayAccounts_obligation, repayAccounts_lendingMarket, repayAccounts_repayReserve, repayAccounts_reserveLiquidityMint, repayAccounts_reserveDestinationLiquidity, repayAccounts_userSourceLiquidity, repayAccounts_tokenProgram, repayAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, lendingMarketAuthority, farmsProgramargs:
liquidityAmount u64ix-repay_and_withdraw_and_redeemrepayAccounts_owner, repayAccounts_obligation, repayAccounts_lendingMarket, repayAccounts_repayReserve, repayAccounts_reserveLiquidityMint, repayAccounts_reserveDestinationLiquidity, repayAccounts_userSourceLiquidity, repayAccounts_tokenProgram, repayAccounts_instructionSysvarAccount, withdrawAccounts_owner, withdrawAccounts_obligation, withdrawAccounts_lendingMarket, withdrawAccounts_lendingMarketAuthority, withdrawAccounts_withdrawReserve, withdrawAccounts_reserveLiquidityMint, withdrawAccounts_reserveSourceCollateral, withdrawAccounts_reserveCollateralMint, withdrawAccounts_reserveLiquiditySupply, withdrawAccounts_userDestinationLiquidity, withdrawAccounts_placeholderUserDestinationCollateral, withdrawAccounts_collateralTokenProgram, withdrawAccounts_liquidityTokenProgram, withdrawAccounts_instructionSysvarAccount, collateralFarmsAccounts_obligationFarmUserState, collateralFarmsAccounts_reserveFarmState, debtFarmsAccounts_obligationFarmUserState, debtFarmsAccounts_reserveFarmState, farmsProgramargs:
repayAmount u64, withdrawCollateralAmount u64ix-deposit_and_withdrawdepositAccounts_owner, depositAccounts_obligation, depositAccounts_lendingMarket, depositAccounts_lendingMarketAuthority, depositAccounts_reserve, depositAccounts_reserveLiquidityMint, depositAccounts_reserveLiquiditySupply, depositAccounts_reserveCollateralMint, depositAccounts_reserveDestinationDepositCollateral, depositAccounts_userSourceLiquidity, depositAccounts_placeholderUserDestinationCollateral, depositAccounts_collateralTokenProgram, depositAccounts_liquidityTokenProgram, depositAccounts_instructionSysvarAccount, withdrawAccounts_owner, withdrawAccounts_obligation, withdrawAccounts_lendingMarket, withdrawAccounts_lendingMarketAuthority, withdrawAccounts_withdrawReserve, withdrawAccounts_reserveLiquidityMint, withdrawAccounts_reserveSourceCollateral, withdrawAccounts_reserveCollateralMint, withdrawAccounts_reserveLiquiditySupply, withdrawAccounts_userDestinationLiquidity, withdrawAccounts_placeholderUserDestinationCollateral, withdrawAccounts_collateralTokenProgram, withdrawAccounts_liquidityTokenProgram, withdrawAccounts_instructionSysvarAccount, depositFarmsAccounts_obligationFarmUserState, depositFarmsAccounts_reserveFarmState, withdrawFarmsAccounts_obligationFarmUserState, withdrawFarmsAccounts_reserveFarmState, farmsProgramargs:
liquidityAmount u64, withdrawCollateralAmount u64ix-deposit_reserve_liquidity_and_obligation_collateowner, obligation, lendingMarket, lendingMarketAuthority, reserve, reserveLiquidityMint, reserveLiquiditySupply, reserveCollateralMint, reserveDestinationDepositCollateral, userSourceLiquidity, placeholderUserDestinationCollateral, collateralTokenProgram, liquidityTokenProgram, instructionSysvarAccountargs:
liquidityAmount u64ix-deposit_reserve_liquidity_and_obligation_collate_2depositAccounts_owner, depositAccounts_obligation, depositAccounts_lendingMarket, depositAccounts_lendingMarketAuthority, depositAccounts_reserve, depositAccounts_reserveLiquidityMint, depositAccounts_reserveLiquiditySupply, depositAccounts_reserveCollateralMint, depositAccounts_reserveDestinationDepositCollateral, depositAccounts_userSourceLiquidity, depositAccounts_placeholderUserDestinationCollateral, depositAccounts_collateralTokenProgram, depositAccounts_liquidityTokenProgram, depositAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgramargs:
liquidityAmount u64ix-withdraw_obligation_collateral_and_redeem_reservowner, obligation, lendingMarket, lendingMarketAuthority, withdrawReserve, reserveLiquidityMint, reserveSourceCollateral, reserveCollateralMint, reserveLiquiditySupply, userDestinationLiquidity, placeholderUserDestinationCollateral, collateralTokenProgram, liquidityTokenProgram, instructionSysvarAccountargs:
collateralAmount u64ix-withdraw_obligation_collateral_and_redeem_reserv_2withdrawAccounts_owner, withdrawAccounts_obligation, withdrawAccounts_lendingMarket, withdrawAccounts_lendingMarketAuthority, withdrawAccounts_withdrawReserve, withdrawAccounts_reserveLiquidityMint, withdrawAccounts_reserveSourceCollateral, withdrawAccounts_reserveCollateralMint, withdrawAccounts_reserveLiquiditySupply, withdrawAccounts_userDestinationLiquidity, withdrawAccounts_placeholderUserDestinationCollateral, withdrawAccounts_collateralTokenProgram, withdrawAccounts_liquidityTokenProgram, withdrawAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgramargs:
collateralAmount u64ix-liquidate_obligation_and_redeem_reserve_collaterliquidator, obligation, lendingMarket, lendingMarketAuthority, repayReserve, repayReserveLiquidityMint, repayReserveLiquiditySupply, withdrawReserve, withdrawReserveLiquidityMint, withdrawReserveCollateralMint, withdrawReserveCollateralSupply, withdrawReserveLiquiditySupply, withdrawReserveLiquidityFeeReceiver, userSourceLiquidity, userDestinationCollateral, userDestinationLiquidity, collateralTokenProgram, repayLiquidityTokenProgram, withdrawLiquidityTokenProgram, instructionSysvarAccountargs:
liquidityAmount u64, minAcceptableReceivedLiquidityAmount u64, maxAllowedLtvOverridePercent u64ix-liquidate_obligation_and_redeem_reserve_collater_2liquidationAccounts_liquidator, liquidationAccounts_obligation, liquidationAccounts_lendingMarket, liquidationAccounts_lendingMarketAuthority, liquidationAccounts_repayReserve, liquidationAccounts_repayReserveLiquidityMint, liquidationAccounts_repayReserveLiquiditySupply, liquidationAccounts_withdrawReserve, liquidationAccounts_withdrawReserveLiquidityMint, liquidationAccounts_withdrawReserveCollateralMint, liquidationAccounts_withdrawReserveCollateralSupply, liquidationAccounts_withdrawReserveLiquiditySupply, liquidationAccounts_withdrawReserveLiquidityFeeReceiver, liquidationAccounts_userSourceLiquidity, liquidationAccounts_userDestinationCollateral, liquidationAccounts_userDestinationLiquidity, liquidationAccounts_collateralTokenProgram, liquidationAccounts_repayLiquidityTokenProgram, liquidationAccounts_withdrawLiquidityTokenProgram, liquidationAccounts_instructionSysvarAccount, collateralFarmsAccounts_obligationFarmUserState, collateralFarmsAccounts_reserveFarmState, debtFarmsAccounts_obligationFarmUserState, debtFarmsAccounts_reserveFarmState, farmsProgramargs:
liquidityAmount u64, minAcceptableReceivedLiquidityAmount u64, maxAllowedLtvOverridePercent u64ix-flash_repay_reserve_liquidityuserTransferAuthority, lendingMarketAuthority, lendingMarket, reserve, reserveLiquidityMint, reserveDestinationLiquidity, userSourceLiquidity, reserveLiquidityFeeReceiver, referrerTokenState, referrerAccount, sysvarInfo, tokenProgramargs:
liquidityAmount u64, borrowInstructionIndex u8ix-flash_borrow_reserve_liquidityuserTransferAuthority, lendingMarketAuthority, lendingMarket, reserve, reserveLiquidityMint, reserveSourceLiquidity, userDestinationLiquidity, reserveLiquidityFeeReceiver, referrerTokenState, referrerAccount, sysvarInfo, tokenProgramargs:
liquidityAmount u64ix-request_elevation_groupowner, obligation, lendingMarketargs:
elevationGroup u8ix-init_referrer_token_statepayer, lendingMarket, reserve, referrer, referrerTokenState, rent, systemProgramix-init_user_metadataowner, feePayer, userMetadata, referrerUserMetadata, rent, systemProgramargs:
userLookupTable base58 stringix-withdraw_referrer_feesreferrer, referrerTokenState, reserve, reserveLiquidityMint, reserveSupplyLiquidity, referrerTokenAccount, lendingMarket, lendingMarketAuthority, tokenProgramix-init_referrer_state_and_short_urlreferrer, referrerState, referrerShortUrl, referrerUserMetadata, rent, systemProgramargs:
shortUrl stringix-delete_referrer_state_and_short_urlreferrer, referrerState, shortUrl, rent, systemProgramix-set_obligation_orderowner, obligation, lendingMarketargs:
index u8, order JSON stringix-set_borrow_orderowner, obligation, lendingMarket, reserve, filledDebtDestination, debtLiquidityMint, instructionSysvarAccount, eventAuthority, programargs:
orderConfig JSON string, minExpectedCurrentRemainingDebtAmount u64ix-set_borrow_order_v2owner, obligation, lendingMarket, reserve, filledDebtDestination, debtLiquidityMint, instructionSysvarAccount, eventAuthority, programargs:
orderIdx u8, orderConfig JSON string, minExpectedCurrentRemainingDebtAmount u64ix-update_obligation_configowner, obligation, borrowReserve, depositReserve, lendingMarketargs:
mode variant name, value binaryix-rollover_fixed_term_borrowrolloverAccounts_payer, rolloverAccounts_obligation, rolloverAccounts_lendingMarket, rolloverAccounts_lendingMarketAuthority, rolloverAccounts_sourceBorrowReserve, rolloverAccounts_targetBorrowReserve, rolloverAccounts_liquidityMint, rolloverAccounts_sourceBorrowReserveLiquidity, rolloverAccounts_targetBorrowReserveLiquidity, rolloverAccounts_tokenProgram, sourceFarmsAccounts_obligationFarmUserState, sourceFarmsAccounts_reserveFarmState, targetFarmsAccounts_obligationFarmUserState, targetFarmsAccounts_reserveFarmState, farmsProgramix-fill_borrow_orderborrowAccounts_payer, borrowAccounts_obligation, borrowAccounts_lendingMarket, borrowAccounts_lendingMarketAuthority, borrowAccounts_borrowReserve, borrowAccounts_borrowReserveLiquidityMint, borrowAccounts_reserveSourceLiquidity, borrowAccounts_borrowReserveLiquidityFeeReceiver, borrowAccounts_userDestinationLiquidity, borrowAccounts_referrerTokenState, borrowAccounts_tokenProgram, borrowAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgram, eventAuthority, programix-fill_borrow_order_v2borrowAccounts_payer, borrowAccounts_obligation, borrowAccounts_lendingMarket, borrowAccounts_lendingMarketAuthority, borrowAccounts_borrowReserve, borrowAccounts_borrowReserveLiquidityMint, borrowAccounts_reserveSourceLiquidity, borrowAccounts_borrowReserveLiquidityFeeReceiver, borrowAccounts_userDestinationLiquidity, borrowAccounts_referrerTokenState, borrowAccounts_tokenProgram, borrowAccounts_instructionSysvarAccount, farmsAccounts_obligationFarmUserState, farmsAccounts_reserveFarmState, farmsProgram, eventAuthority, programargs:
orderIdx u8ix-initiate_obligation_ownership_transferowner, obligation, instructionSysvarAccountargs:
newOwner base58 stringix-approve_obligation_ownership_transferglobalAdmin, globalConfig, obligation, pendingOwner, instructionSysvarAccountix-accept_obligation_ownershippendingOwner, obligation, instructionSysvarAccountix-abort_obligation_ownership_transferowner, obligation, instructionSysvarAccountix-enqueue_to_withdrawowner, lendingMarket, lendingMarketAuthority, reserve, userSourceCollateralTa, userDestinationLiquidityTa, reserveLiquidityMint, reserveCollateralMint, collateralTokenProgram, withdrawTicket, ownerQueuedCollateralVault, systemProgram, progressCallbackCustomAccount0, progressCallbackCustomAccount1, instructionSysvarAccountargs:
collateralAmount u64, progressCallbackType variant nameix-withdraw_queued_liquiditypayer, lendingMarket, lendingMarketAuthority, reserve, reserveLiquidityMint, reserveCollateralMint, reserveLiquiditySupply, ownerQueuedCollateralVault, userDestinationLiquidity, collateralTokenProgram, liquidityTokenProgram, withdrawTicket, withdrawTicketOwner, associatedTokenProgram, systemProgram, progressCallbackProgram, progressCallbackCustomAccount0, progressCallbackCustomAccount1, instructionSysvarAccountix-recover_invalid_ticket_collateralpayer, lendingMarket, lendingMarketAuthority, reserve, reserveCollateralMint, ownerQueuedCollateralVault, userSourceCollateral, collateralTokenProgram, withdrawTicket, withdrawTicketOwner, instructionSysvarAccountargs:
ticketSequenceNumber u64ix-cancel_withdraw_ticketowner, lendingMarket, lendingMarketAuthority, reserve, reserveCollateralMint, ownerQueuedCollateralVault, userDestinationCollateral, collateralTokenProgram, withdrawTicketargs:
ticketSequenceNumber u64, collateralAmountToCancel u64ix-init_global_configpayer, globalConfig, programData, systemProgram, rent, instructionSysvarAccountix-update_global_configglobalAdmin, globalConfig, instructionSysvarAccountargs:
mode variant name, value binaryix-update_global_config_adminpendingAdmin, globalConfig, instructionSysvarAccountix-idl_missing_typessigner, globalConfig, lendingMarket, reserve, instructionSysvarAccountargs:
reserveFarmKind variant name, feeCalculation variant name, reserveStatus variant name, updateConfigMode variant name, updateLendingMarketConfigValue JSON string, updateLendingMarketConfigMode variant nameFiles are split at 2 GB: ix-<name>-tNN-SSSS.parquet. Large integers stay
exact: u128 is a decimal string. All decoded types.
Get Kamino Lending data for your range.
Select an epoch range and get a firm price. You pay only when you send the job.