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

ProjectProtocolFarm Type
kaminokfarmvault
meteorameteora-dlmmdlmm-farm

Table Columns

Column NameDescriptionTypeExample
projectThe farm projectvarcharmeteora
protocolThe protocol used by the farm projectvarcharmeteora-dlmm
farm_typeType of farm. current values are: dlmm-farm, vaultvarchardlmm-farm
farmThe farm identifier. For a dlmm-farm, it is the lb_pair, for a kamino vault, it is the farm statevarcharBrMYU1XWCqMAtBURD8yp3d9gni3uHxomoj5JG9LWr7Mj
strategyThe strategy of the vault. applicable for vaultsvarchar
claimerThe receiver of the claimed rewardsvarchar8XgvAmUGbyWFb6XLjbUHuWaFhmyu2chLaxrKZe67HMXs
claimer_token_accThe token account receving the rewardsvarcharGHhzSHZuvvBBNfZk8CEexFxgyVk9o7tS2yS9nPyJTB2d
mintThe mint being claimedvarcharDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
symbolThe symbol of the mint being claimedvarcharBonk
decimalsThe decimals of the mint being claimednumber5
raw_amountThe raw amount claimedvarchar141766905
amountThe normalized amount claimedfloat1417.66905
usd_amountThe usd amount of the claimfloat0.017516826765651538
usd_exchange_rateThe usd exchange rate of the token claimedfloat1.2356076166071698e-050.017516826765651538z
signerThe signer of the claim txnvarchar8XgvAmUGbyWFb6XLjbUHuWaFhmyu2chLaxrKZe67HMXs
block_slotBlock slot of the txnnumber247955288
block_heightBlock height of the txnnumber228675693
block_timestampBlock timestamp of the txntimestamp_ntz2024-02-13 17:51:40+00:00
block_hashBlock hash of the txnvarchar9DdC9kUykhEMkX2BPvpXgSn2DKWJ9zGbcZGspsCqmapB
txn_idTxn id of the txnvarchar5vubqj1XgXLCJxHoL4VviLtyeqNjPxzA3DnXNq18R8mFgQaGhg11oWLibG4fRvqxw87zhug41J1B1UEivJmPjqhB
txn_indexTxn index of the txnnumber221
instruction_indexInstruction index of the instructionnumber1
inner_instruction_indexInner instruction index of the instruction, within its parent instructionnumber0
unique_idUnique id of the recordvarchartxn_id-5vubqj1XgXLCJxHoL4VviLtyeqNjPxzA3DnXNq18R8mFgQaGhg11oWLibG4fRvqxw87zhug41J1B1UEivJmPjqhB_i_index-1_ii_index-null