Rewards Claimed

This table contains reward claiming transactions

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

Project	Protocol	Farm Type
kamino	kfarm	vault
meteora	meteora-dlmm	dlmm-farm

Table Columns

Column Name	Description	Type	Example
project	The farm project	varchar	meteora
protocol	The protocol used by the farm project	varchar	meteora-dlmm
farm_type	Type of farm. current values are: dlmm-farm, vault	varchar	dlmm-farm
farm	The farm identifier. For a dlmm-farm, it is the lb_pair, for a kamino vault, it is the farm state	varchar	BrMYU1XWCqMAtBURD8yp3d9gni3uHxomoj5JG9LWr7Mj
strategy	The strategy of the vault. applicable for vaults	varchar
claimer	The receiver of the claimed rewards	varchar	8XgvAmUGbyWFb6XLjbUHuWaFhmyu2chLaxrKZe67HMXs
claimer_token_acc	The token account receving the rewards	varchar	GHhzSHZuvvBBNfZk8CEexFxgyVk9o7tS2yS9nPyJTB2d
mint	The mint being claimed	varchar	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
symbol	The symbol of the mint being claimed	varchar	Bonk
decimals	The decimals of the mint being claimed	number	5
raw_amount	The raw amount claimed	varchar	141766905
amount	The normalized amount claimed	float	1417.66905
usd_amount	The usd amount of the claim	float	0.017516826765651538
usd_exchange_rate	The usd exchange rate of the token claimed	float	1.2356076166071698e-050.017516826765651538z
signer	The signer of the claim txn	varchar	8XgvAmUGbyWFb6XLjbUHuWaFhmyu2chLaxrKZe67HMXs
block_slot	Block slot of the txn	number	247955288
block_height	Block height of the txn	number	228675693
block_timestamp	Block timestamp of the txn	timestamp_ntz	2024-02-13 17:51:40+00:00
block_hash	Block hash of the txn	varchar	9DdC9kUykhEMkX2BPvpXgSn2DKWJ9zGbcZGspsCqmapB
txn_id	Txn id of the txn	varchar	5vubqj1XgXLCJxHoL4VviLtyeqNjPxzA3DnXNq18R8mFgQaGhg11oWLibG4fRvqxw87zhug41J1B1UEivJmPjqhB
txn_index	Txn index of the txn	number	221
instruction_index	Instruction index of the instruction	number	1
inner_instruction_index	Inner instruction index of the instruction, within its parent instruction	number	0
unique_id	Unique id of the record	varchar	txn_id-5vubqj1XgXLCJxHoL4VviLtyeqNjPxzA3DnXNq18R8mFgQaGhg11oWLibG4fRvqxw87zhug41J1B1UEivJmPjqhB_i_index-1_ii_index-null