Tulip Protocol

Tulip Protocol is the first yield aggregation platform built on Solana with auto-compounding vault strategies.

tulip.txns

This table has similar schema as of Solana transactions table

tulip.vault

The table contains the parsed instructions data for Tulip V2 Vault. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	string	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Data Type
authority	string
management	string
vault	string
vaultPda	string
vaultStakerAccount	string
farmAccount	string
farmStakeTokenAccount	string
cropAccount	string
cropRewardTokenAccount	string
vaultHarvesterAccount	string
vaultRewardTokenAccount	string
underlyingCompoundQueue	string
feeCollectorTokenAccount	string
sharesMint	string
atrixFarmProgram	string
tokenProgram	string
clock	string

tulip.farming

The table contains the parsed instructions data for Tulip Farming. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Field	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

input accounts

Field	Data Type
ammAuthority	string
ammId	string
ammOpenOrders	string
ammQuantitiesOrTargetOrders	string
aquaFarmProgram	string
authority	string
authorityTokenAccount	string
authorityTulipTokenAccount	string
baseTokenAccount	string
borrowAuthorizer	string
clock	string
coinDepositReserveAccount	string
coinDestinationTokenAccount	string
coinReserveLiquidityFeeReceiver	string
coinReserveLiquidityOracle	string
coinSourceReserveLiquidityTokenAccount	string
coinSourceTokenAccount	string
coinWallet	string
convertAuthority	string
convertAuthorityDd	string
derivedLendingMarketAuthority	string
dexProgram	string
farmDdTokenMint	string
farmTokenMint	string
fundingTokenAccount	string
global	string
globalBaseDdTokenVault	string
globalBaseTokenVault	string
globalFarm	string
globalFarmDd	string
globalRewardDdTokenVault	string
globalRewardTokenVault	string
lendingMarket	string
lendingMarketAccount	string
lendingProgram	string
levFarmCoinTokenAccount	string
levFarmPcTokenAccount	string
leveragedFarm	string
leveragedUserFarm	string
liquidatorBaseAccount	string
liquidatorLpAccount	string
liquidatorQuoteAccount	string
liquidityProgramId	string
lpMintAddress	string
lpPythPriceAccount	string
lpTokenAccount	string
market	string
obligationLiquidity	string
obligationVaultAddress	string
orcaUserFarm	string
pcDepositReserveAccount	string
pcDestinationTokenAccount	string
pcReserveLiquidityFeeReceiver	string
pcReserveLiquidityOracle	string
pcSourceReserveLiquidityTokenAccount	string
pcSourceTokenAccount	string
pcWallet	string
poolAuthority	string
poolCoinTokenAccount	string
poolId	string
poolLpTokenAccount	string
poolPcTokenAccount	string
poolRewardATokenAccount	string
poolRewardBTokenAccount	string
pythPriceAccount	string
quoteTokenAccount	string
raySwap	string
receivingTokenAccount	string
removeLiquidity	string
rent	string
reserveLiquidityFeeReceiver	string
serumAsks	string
serumBids	string
serumCoinVaultAccount	string
serumEventQueue	string
serumMarket	string
serumPcVaultAccount	string
serumProgramId	string
serumVaultSigner	string
solfarmVaultProgram	string
sourceReserveLiquidityTokenAccount	string
stakeProgramId	string
swapOrLiquidityProgramId	string
systemProgram	string
tokenProgram	string
tokenProgramId	string
userBalanceAccount	string
userBalanceMetadata	string
userBaseTokenAccount	string
userFarm	string
userFarmDd	string
userFarmDdTokenAccount	string
userFarmObligation	string
userFarmOwner	string
userFarmTokenAccount	string
userInfoAccount	string
userLpTokenAccount	string
userObligationLiquidation	string
userRewardATokenAccount	string
userRewardBTokenAccount	string
userRewardDdTokenAccount	string
userRewardTokenAccount	string
userTransferAuthority	string
userTulipRewardMetadata	string
userTulipTokenAccount	string
vault	string
vaultAccount	string
vaultPda	string
vaultPdaAccount	string
vaultProgram	string
vaultSigner	string
vaultTulipTokenAccount	string
vaultUserAccount	string
withdrawFarm	string

args

Field	Data Type
borrowAmount	double
borrowToken	double
coinAmount	double
coinBorrowAmount	double
depositArgs	STRUCT
farmProgramId	string
harvestArgs	STRUCT
metaNonce	int
nonce	int
obligationIndex	int
order	int
pcAmount	double
pcBorrowAmount	double
queueAuthority	string
reserves	array<string>

depositArgs

Field	Data Type
accountNonce	int
metaNonce	int
nonce	int

harvestArgs

Field	Data Type
metaNonce	int
nonce	int
rewardNonce	int

tulip.lending

The table contains the parsed instructions data for Tulip Lending. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Data Type
authority	string
derivedLendingMarketAuthority	string
destinationCollateralTokenAccount	string
destinationLiquidityTokenAccount	string
lendingMarketAccount	string
reserveAccount	string
reserveCollateralSPLTokenMint	string
reserveLiquidityOracleAccount	string
reserveLiquiditySupplySPLTokenAccount	string
reserveLiquiditySupplySPLTokenAccount.	string
sourceCollateralTokenAccount	string
sourceLiquidityTokenAccount	string
sysvar	string
tokenProgramId	string

args

Field	Data Type
collateral_amount	double
liquidity_amount	double

tulip.staking

The table contains the parsed instructions data for Tulip Staking. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Data Type
rent	string
sTokenFrom	string
sTokenFromAuthority	string
sTokenMint	string
sTokenTo	string
stakingAccount	string
systemProgram	string
tokenFrom	string
tokenFromAuthority	string
tokenLockVault	string
tokenMint	string
tokenProgram	string
tokenTo	string
tokenToAuthority	string
tokenVault	string
userStakingAccount	string
userTulipTokenAccount	string

args

Field	Data Type
amount	double
index	int
nonceLockVault	int
nonceStaking	int
nonceUserStaking	int
nonceVault	int

tulip.info

The table contains the info data for Tulip Lending. Data related to loan_to_value_ratio, liquidation_threshold, liquidity_supply_token_mint, collateral_token_mint, etc. is available here.

Column Name	Data Type
name	string
account	string
liquidity_supply_token_mint	string
liquidity_supply_token_account	string
liquidity_fee_receiver	string
collateral_token_mint	string
collateral_token_supply	string
destination_collateral_token_account	string
quote_token_mint	string
platform_fees	bigint
config	STRUCT

config

Field	Data Type
degen_borrow_rate	bigint
degen_utilization_rate	bigint
fees	STRUCT
liquidation_bonus	bigint
liquidation_threshold	bigint
loan_to_value_ratio	bigint
max_borrow_rate	bigint
min_borrow_rate	bigint
optimal_borrow_rate	bigint
optimal_utilization_rate	bigint

fees

Field	Data Type
borrow_fee_wad	bigint
flash_loan_fee_wad	bigint
host_fee_percentage	bigint