traderjoe_v1_arbitrum

Tables

APTFarm_Harvest_event

Harvest events from Trader Joe V1 Auto-Pool Token (APT) farms on Arbitrum, recording reward claims by users from specific pool IDs with harvested token amounts. Used for analyzing yield farming behavior and reward distribution patterns across different liquidity pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_unpaidAmount`	`STRING`	Amount of rewards that were accrued but not yet claimed by the user at the time of harvest. Denominated in the smallest token unit (wei) and typically zero when all rewards are successfully claimed.

Sample Data

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
1	0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x58299889b558e385ae65053eb7560b7d1baa3323	false	0	26	210091114	2024-05-11T08:24:17.000Z	0x44e4126e8a03e7c072ddddf72b4f52841dbc03400f247ee176e3fb2d77307f91
2	0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x0d9633942ceaa14918d7481443a4296d61f93cdf	false	0	36	210240961	2024-05-11T18:51:03.000Z	0x1078963f9ebba6f6de9c8464806e0279a2494a6d9354647ebe942d1701400cbf
2	0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x0d9633942ceaa14918d7481443a4296d61f93cdf	false	10443992464371747086	14	210240961	2024-05-11T18:51:03.000Z	0x1078963f9ebba6f6de9c8464806e0279a2494a6d9354647ebe942d1701400cbf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_arbitrum.APTFarm_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

APTFarm_RewardClaimed_event

Reward claim events from Trader Joe V1 APT (Automated Pool Token) farms on Arbitrum, capturing user withdrawals of farming incentives with token amounts, epoch identifiers, and market addresses. Used for analyzing yield farming participation and reward distribution patterns across liquidity pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_released`	`STRING`	Amount of tokens released to the user in the reward claim transaction. String-encoded integer representing token quantity in the smallest denomination.
`in_unreleased`	`STRING`	Amount of tokens not yet released to the user at the time of the reward claim. String-encoded integer representing token quantity in the smallest denomination.

Sample Data

address	in_user	removed	in_epoch	in_token	in_market	log_index	in_released	block_number	block_timestamp	transaction_hash
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x120e32bdc8840b11b13a67691028af51812f21e4	false	10	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xe2b32e6dd706af1ae7e6ea71d0477b5adaf9c9d1	1	850040000000000000000	202691661	2024-04-19T16:47:59.000Z	0x3ae55de58698293e7ccfdcbecce6caf590f2dad896e8789c236031c38f2e3270
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x320849ec0adffcd6fb0212b59a2ec936cdef5fca	false	10	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0x500173f418137090dad96421811147b63b448a0f	11	740000000000000000	202509271	2024-04-19T03:49:50.000Z	0x8cc629d82b3a63686f6036465e975983689ddc8c5fc9316782f095fc85e6bd3c
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x320849ec0adffcd6fb0212b59a2ec936cdef5fca	false	11	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0x500173f418137090dad96421811147b63b448a0f	13	990000000000000000	202509271	2024-04-19T03:49:50.000Z	0x8cc629d82b3a63686f6036465e975983689ddc8c5fc9316782f095fc85e6bd3c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_arbitrum.APTFarm_RewardClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MakerRewarder_RewardClaimed_event

Liquidity provider reward claim events from Trader Joe V1 DEX on Arbitrum, tracking released and unreleased token amounts per epoch and market. Used to analyze market maker incentive distribution and user claim behavior across trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_released`	`STRING`	Amount of tokens released to the user in the reward claim transaction. String-encoded integer representing token quantity in the smallest denomination.
`in_unreleased`	`STRING`	Amount of tokens not yet released to the user at the time of the reward claim. String-encoded integer representing token quantity in the smallest denomination.

Sample Data

address	in_user	removed	in_epoch	in_token	in_market	log_index	in_released	block_number	in_unreleased	block_timestamp	transaction_hash
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x00519b408c037a605b1639358a039e2e789ca7c4	false	1	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xc3bc74dcff9019d064dc269a5266934cd65613e5	1	23139062946428571429	163315918	52004022321428571429	2023-12-24T16:06:50.000Z	0xabf22129cd485aa49cd2390505024268cd969e736d11c81861e82b85f2253264
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x082d7806f79c8fb21987b9e8b82ad85807e99370	false	13	0xcafcd85d8ca7ad1e1c6f82f651fa15e33aefd07b	0xb87495219c432fc85161e4283dff131692a528bd	2	117341728472222222222	163232171	68228271527777777778	2023-12-24T10:13:54.000Z	0x831c744a17ba0139b8ce332bf67dbdeb9c1bf9bfc5801401972c5e5e8f0f4477
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x0e131ffcb723b9f2ea0a62003f8435dd3387a380	false	1	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xc3bc74dcff9019d064dc269a5266934cd65613e5	1	50880937499999994138	163256310	50846139880952375094	2023-12-24T11:55:43.000Z	0x1def63193c28d6a1d1a9da82f6a99f5efb9120ffa53b01960b3077a21ccf5a08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_arbitrum.MakerRewarder_RewardClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

APTFarm_Harvest_event

APTFarm_RewardClaimed_event

MakerRewarder_RewardClaimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​APTFarm_Harvest_event

​APTFarm_RewardClaimed_event

​MakerRewarder_RewardClaimed_event

Tables

APTFarm_Harvest_event

APTFarm_RewardClaimed_event

MakerRewarder_RewardClaimed_event