Fees Claimed

This table contains fee claiming transactions. Currently, it only contains fees claimed from the meteora dlmm pools

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

Project	Protocol	Farm Type
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	varchar	dlmm-farm
farm	The farm identifier. For a dlmm-farm, it is the lb_pair	varchar	BrMYU1XWCqMAtBURD8yp3d9gni3uHxomoj5JG9LWr7Mj
strategy	The strategy of the vault. applicable for vaults Currently not used. Will be used in future as coverage increases	varchar	-
claimer	The receiver of the claimed rewards	varchar	8XgvAmUGbyWFb6XLjbUHuWaFhmyu2chLaxrKZe67HMXs
claimer_token_acc_x/y	The token account receving the fee	varchar	GHhzSHZuvvBBNfZk8CEexFxgyVk9o7tS2yS9nPyJTB2d
mint_x/y	The mint being claimed.	varchar	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
symbol_x/y	The symbol of the mint being claimed	varchar	Bonk
decimals_x/y	The decimals of the mint being claimed	number	5
raw_amount_x/y	The raw amount claimed	varchar	141766905
amount_x/y	The normalized amount claimed	float	1417.66905
usd_amount_x/y	The usd amount of the claim	float	0.017516826765651538
usd_exchange_rate_x/y	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