solana.defi.farms currently includes the following farms/protocols

ProjectProtocolFarm Type
kaminokfarmvault
meteorameteora-dlmmdlmm-farm

Table columns

Column NameDescriptionTypeExample
projectThe farm projectvarcharkamino
protocolThe protocol used by the farm projectvarcharkfarm
farm_typeType of farm. current values are: dlmm-farm, vaultvarcharvault
farmThe farm identifier. For a dlmm-farm, it is the lb_pair, for a kamino vault, it is the farm statevarchar8DLa1qFJf6u5mhxKtaP6dSRNaDQytc1G5xUcLWaSkgYW
strategyThe strategy of the vault. applicable for vaultsvarchar4dPX2rrJgSEeB7sLrM9SdTE9PWzfeMe8Ky5YCfqQCwMD
underlying_dex_poolUnderlying dex pool of used by the farm.varchar2QrWsSWrGvoAqkDC5XSGqjS752RWLaopqAaGrbugSxBL
underlying_dex_tokensAn array of mint addresses of the constituent tokens in the underlying dex poolvariant[ “JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN”, “J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn” ]
underlying_dex_token_symbolsAn array of symbols of the constituent tokens in the underlying dex poolvariant[ “JUP”, “JitoSOL” ]
deposit_mint_0Mint of 1st deposit token, if applicable. for a vault, this is the vault lp receipt (e.g. kaminoLP).varchar2nsveNLZqybj7rb92JeT7LMT2EkpwBF5mw6NeoTVpYKM
deposit_mint_symbol_0Symbol of 1st deposit token, if applicablevarchar
deposit_mint_1Mint of 2nd deposit token, if applicablevarchar
deposit_mint_symbol_1Symbol of 2nd deposit token, if applicablevarchar
reward_mint_0Mint of 1st reward token, if applicablevarcharjtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL
reward_mint_symbol_0Symbol of 1st reward token, if applicablevarcharJTO
reward_mint_1Mint of 2nd reward token, if applicablevarchar
reward_mint_symbol_1Symbol of 2nd reward token, if applicablevarchar
reward_mint_2Mint of 3rd reward token, if applicablevarchar
reward_mint_symbol_2Symbol of 3rd reward token, if applicablevarchar
emission_rps_0Emission per second of 1st reward token (normalized)number
emission_rps_1Emission per second of 2nd reward token (normalized)number
emission_rps_2Emission per second of 3rd reward token (normalized)number
reward_total_funded_0Total funded amount of 1st reward token (normalized)float
reward_total_funded_1Total funded amount of 2nd reward token (normalized)float
reward_total_funded_2Total funded amount of 3rd reward token (normalized)float
farm_config_updated_block_timestampLast updated block_timestamp for farm configurations in this recordtimestamp_ntz2024-01-30 22:57:40+00:00
farm_config_updated_block_slotLast updated block_slot for farm configurations in this recordnumber245148486