Defi
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 | 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 |