traderjoe_v1_avalanche

Tables

APTFarm_Harvest_event

Reward claim events from Trader Joe V1 APT (Auto-Pool Token) farms on Avalanche, recording harvested token amounts by users from specific pool IDs. Used for tracking yield farming reward distributions and user farming behavior 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_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 remain unclaimed or unpaid to the user after this harvest event. Stored as a wei-denominated string, typically zero when users fully claim their available rewards.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x0bff7dc1e080cad0491deeb4af30df129e30af21	false	610541215946673472	4	46650060	2024-06-13T03:13:42.000Z	0x3c9583077f9f7a69c4a5f9e639d52d8f8e0af8ba0858df61117388ee6c59cf3a
0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x0bff7dc1e080cad0491deeb4af30df129e30af21	false	121466901923824	2	46650086	2024-06-13T03:14:34.000Z	0x8de6f98a4d22bb29e737efc71ce62ceb801df861e01da08e82a43d04f6b81091
0x57ff9d1a7cf23fd1a9fd9dc07823f950a22a718c	0x1d87ac54011fbe4472079ac67e7bc3341d0de77e	false	25498159423196525115	3	46650347	2024-06-13T03:23:24.000Z	0xc06c30f08a8853c9f097fbf528ff3e9c9b70cc082243dedc63eddf1e79dbfd09

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_avalanche.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 liquidity mining farms on Avalanche, tracking released and unreleased token incentives by user, market, and epoch. Used for analyzing yield farming reward distributions and user claim behavior across different lending markets.

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_token	in_market	log_index	in_released	block_number	block_timestamp	transaction_hash
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0xf95c27a51f2e340d52e8a3c428cd6e290f51ca00	false	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0x48692b3b38bb7ddfe2b36efabba298f3cd5c49ce	3	116400000000000000000	44522721	2024-04-22T12:14:30.000Z	0xa064b204fe4e442ed52da3ed25aa5534bfb766e4702b1e6f0b6abdac8fdd2550
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0xf6e57e1cdea04b745dfcba85c2b52adf0549b385	false	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0x207004f671e20631673c03a20226c5a123ccad29	20	17163381597222222223	44531171	2024-04-22T17:08:42.000Z	0xbc8e5c8cc9c8b3dc1e58b99d2c1dd04bb3679d2b44adf0d2ceb6856032096c0c
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0xf6e57e1cdea04b745dfcba85c2b52adf0549b385	false	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0x207004f671e20631673c03a20226c5a123ccad29	5	0	44531172	2024-04-22T17:08:44.000Z	0x81cd0ce514a4ca6859c76699862abaeca5b70072d87cc15f0223d9576f2de796

Example Query

Query with partition filter

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

BoostedMasterChefJoe_Harvest_event

Reward harvest events from Trader Joe’s BoostedMasterChef staking contract on Avalanche, capturing when users claim accumulated JOE token rewards from liquidity pool (LP) positions. Used for analyzing yield farming behavior, reward distribution patterns, and staking pool activity across different pool IDs (pid).

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.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x4483f0b6e2f5486d06958c20f8c39a7abe87bf8f	0x5df79ebe609d93b9624f987c32df3f7cb67321b2	false	148501684669922	12	20645533	2022-10-04T18:34:14.000Z	0x79dc86f9569a0a1b9bed20a904c9a1314ac70f5b057bdb7242c6f3cb3508916c
0x4483f0b6e2f5486d06958c20f8c39a7abe87bf8f	0x997b86481ea10a414ac34acbcf1e3030274a618d	false	3668700450644174	12	20649423	2022-10-04T20:48:23.000Z	0x4d59eceeccd2f03d1491c75192d587e2d93858d9832ea1e59ba3686079fd735d
0x4483f0b6e2f5486d06958c20f8c39a7abe87bf8f	0x6b84e2fce033e0a1044120db9d427dae3d9282cb	false	33082008751844052754	12	20629428	2022-10-04T09:19:30.000Z	0x29a3410014c1e1270b3b4213ae3654e9b92026b9ea7245abd02e61998f888de6

Example Query

Query with partition filter

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

MakerRewarder_RewardClaimed_event

Liquidity mining reward claim events from Trader Joe V1 automated market maker (AMM) on Avalanche, tracking released and unreleased token amounts by user, epoch, and market pair. Used for analyzing liquidity provider incentive distributions and claiming patterns across trading 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	in_unreleased	block_timestamp	transaction_hash
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0xf4605fa919825e4a85813752006697bc14cfc0ed	false	2	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0xd446eb1660f766d533beceef890df7a69d26f7d1	10	360244444444444444444	34858617	1639444444444444445	2023-09-06T23:33:31.000Z	0x13f9c4b8fa50fb957c4be17084e7d9849b5d087b9931babe93f23838a5b334ff
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0xcb948151fec839ba0bc3a4829d81b8a32ef3354c	false	2	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0xd446eb1660f766d533beceef890df7a69d26f7d1	10	586617367724867724868	34858592	2753346560846560847	2023-09-06T23:32:41.000Z	0x151268707bc2c99d5f7c6d35769c685a4545856d73f06bc2b2c028afd12f95d7
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x027b4be6ab597f51a0ec6d564051c70c7feac9f2	false	2	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0xd446eb1660f766d533beceef890df7a69d26f7d1	1	1457405476190476190476	34858663	3594523809523809524	2023-09-06T23:35:12.000Z	0x21dbc17e6db3db337eef6231087ab5f90346ac2db65d31e63171b2e494093513

Example Query

Query with partition filter

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

MasterChefJoeV2_Harvest_event

Harvest events from Trader Joe V2 yield farming contracts on Avalanche, recording when users claim JOE token rewards from liquidity mining pools. Contains pool ID, user address, and reward amounts for tracking farm reward distributions and user claiming patterns.

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.

Sample Data

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
55	0xd6a4f121ca35509af06a0be99093d08462f53052	0x01b630e4c8c64c9abfd843c2c7ec3b0fcd1cf609	false	1184609208371072984	256	9050915	2022-01-02T19:17:42.000Z	0x22e22e7a3596b19782dce7a68becd4e4d47d61bf15bf7904a775cc0e030bd78d
66	0xd6a4f121ca35509af06a0be99093d08462f53052	0x188bed1968b795d5c9022f6a0bb5931ac4c18f00	false	23090445859872611464	256	9047398	2022-01-02T17:19:28.000Z	0x860336ee8eea4d6f969cb9f7fb862d232f28ee2052fe4dd5335bf6311a95562c
66	0xd6a4f121ca35509af06a0be99093d08462f53052	0x188bed1968b795d5c9022f6a0bb5931ac4c18f00	false	15393630573248407643	256	9043456	2022-01-02T15:10:40.000Z	0x7d59ad6f803899642ce541e672be1e544f7969376eb2e5310bd1f0afdbd2b766

Example Query

Query with partition filter

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

MasterChefJoeV3_Harvest_event

Reward harvest events from Trader Joe V3 MasterChef staking contract on Avalanche, tracking users claiming earned JOE tokens from liquidity pool positions. Contains pool identifiers (pid), harvest amounts, and user addresses for analyzing yield farming reward distribution.

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.

Sample Data

in_pid	address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
0	0x188bed1968b795d5c9022f6a0bb5931ac4c18f00	0xd784dd3706366d6cf9dd7d379148de9221f67fc3	false	12	20225656	2022-09-24T17:29:24.000Z	0x6c295cdef2ea0cccd4490215c000ed372d80fe1bbad830dabc838f1e7eacbd48
2	0x188bed1968b795d5c9022f6a0bb5931ac4c18f00	0xbfa5e5dc6861a23fd7e64cb435535d1511d59a5c	false	12	20215981	2022-09-24T11:53:57.000Z	0x9b7ebd2da361c1ba3849daf253c3cfc730d5f9ecba5d818b67595b48034cc8b1
21	0x188bed1968b795d5c9022f6a0bb5931ac4c18f00	0xf7067c27e354aa91ddc822692993c30151c0417c	false	12	20211625	2022-09-24T09:21:20.000Z	0x3c18805eaa2490fe15e0f3fe369a207a2ca0f3e49e4a84c148dd5f73f6dd6a81

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x2e676a99e039eb4415168746185b787563146d9e	0x2a8a315e82f85d1f0658c5d66a452bbdd9356783	false	0x2e676a99e039eb4415168746185b787563146d9e	8	6449	6446	28545842	2023-04-10T02:29:05.000Z	0x092410dbeb30a4f208e15b7bb1f97800bfda0dc4a612c6870df746e64aed71b9
0x51f268350a47024cf55a309607e17ba3d19a8b06	0x00cb5b42684da62909665d8151ff80d1567722c3	false	0x60ae616a2155ee3d9a68541ba4544862310933d4	15	9123114576030558557	4824621989620289696	28581969	2023-04-10T22:47:35.000Z	0xced65481fb9c23107ac6be02a8381d12f0a2e32173a564e966cc577acff81793
0xebc9e5b31c4a5ff9f3734cfa215eea0e8114dfe9	0x00cb5b42684da62909665d8151ff80d1567722c3	false	0x60ae616a2155ee3d9a68541ba4544862310933d4	15	10321810460563332046	5478795066476182560	28570003	2023-04-10T16:02:26.000Z	0x5bf2836fc3ce514b4e1df669bb9e5ecf31922458a994f9ebd85166bac5c0a508

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x00979bd14bd5eb5c456c5478d3bf4b6e9212ba7d	false	0x60ae616a2155ee3d9a68541ba4544862310933d4	8	2374650664312668174669	498701508752208983	19575462	2022-09-05T20:47:28.000Z	0x45f4ea4a5e17092edbaa7ec3aee68269da0468737ab5735e1e29db89a746311c
0x00979bd14bd5eb5c456c5478d3bf4b6e9212ba7d	false	0x7a1a50ad50f297f01e354074af384e5b4001090d	36	24276875473728596633933	5140542509800251062	19561910	2022-09-05T11:39:05.000Z	0x8b06ef05e9ff8e82bd06b1536824998e216223bbc45adb6e22fa2f04d590be41
0x00c87ce7188f7652d0c0940274cec5db62f1e825	false	0x60ae616a2155ee3d9a68541ba4544862310933d4	35	2549494419844916459	102976138014578502	19549753	2022-09-05T00:33:33.000Z	0x71d6d0a31e7452c64018fc38a1801363995751a7ef8291b808909a9b855275f6

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x1f078d6daef89141ea10bfb72c116545e2de09ff	0x0016d4cd75fcbf6c33ca95f7b2630aaa4713ee6a	false	0xbb90f0b52ff68c804b635fd25186b042a7d945e2	10	16618226	6236945511126035531	116442417145039592595	2022-06-28T07:08:28.000Z	0x329e7a146939fe6b94b88d46ba580f7acaa8efa46745886cd11f4d7872874cf0
0x4d61e968636711ca148be36dc2c881e4a1529e63	0x0016d4cd75fcbf6c33ca95f7b2630aaa4713ee6a	false	0xe2afe5f7b5a876f48261454f8ee23205d939f665	21	16618225	2822882845065172868	54504661144233421111	2022-06-28T07:08:26.000Z	0x2284345461e33bcff60c4acf5430b3021e642eb8aa1ef124946824439c9a5dd4
0x5df26928f4580b308164d513245759bbb58f9649	0x0016d4cd75fcbf6c33ca95f7b2630aaa4713ee6a	false	0x60ae616a2155ee3d9a68541ba4544862310933d4	40	16640025	9897859569012421	176393453218317231	2022-06-28T19:14:09.000Z	0x080df28a48303a48c9441a3d12f59835a4ef89799fcbad2429bd559e2b755a2a

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x0060de250de943e4513b70b2e8e5d78671f6c335	false	37	1661701973305240128	403199167475870564289044966906906	34078546	2023-08-18T12:37:32.000Z	0x52c52069ede38776ff970ea959dd6c592fb98e75c5f3329b08f434b0f1eb3ba4
0x0060de250de943e4513b70b2e8e5d78671f6c335	false	47	1661787094596390104	403219821500646063208159269591374	34078546	2023-08-18T12:37:32.000Z	0x52c52069ede38776ff970ea959dd6c592fb98e75c5f3329b08f434b0f1eb3ba4
0x0060de250de943e4513b70b2e8e5d78671f6c335	false	51	1661787094596390104	402211771946894448050138871417396	34078546	2023-08-18T12:37:32.000Z	0x52c52069ede38776ff970ea959dd6c592fb98e75c5f3329b08f434b0f1eb3ba4

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x8d59262a4dadcd736428e339e013ca5a10f2f69e	0x00a386afb1524b572de7ea0a3aaad25cdf7e749a	0x92614d3537f0035bddec0ea444c0b1f55c8c9bda	false	0	2	19402240	2022-09-01T13:19:07.000Z	0xfa994cf8432f3cf63eb2d98bf2afd935bf5d5f9f450ed0abda4d456191181e1c
0x92614d3537f0035bddec0ea444c0b1f55c8c9bda	0x00a386afb1524b572de7ea0a3aaad25cdf7e749a	0x0eab5ee60bf26fccfc24992314d029678063bd7e	false	5467549000000000000	1	19392776	2022-09-01T08:01:25.000Z	0x03d7e38b5ad82e42a178322136c09d5058d080bdef5a77b53672a9e3b36144da
0x40c65404d157eae95ce46b510a51ceeeb1c31fc5	0x00a386afb1524b572de7ea0a3aaad25cdf7e749a	0x92614d3537f0035bddec0ea444c0b1f55c8c9bda	false	0	13	19418389	2022-09-01T22:19:04.000Z	0xed0e171e2c99236f4f45bb929c534251e2ae7d4934c03d823328d33893a3a64c

Example Query

Query with partition filter

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

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x9ad6c38be94206ca50bb0d90783181662f0cfa10	0xca00cb0d67ab9e3a038dca28e0872a411f791db1	false	17279	0x34ca0eeb1c7e90bb4ab66c573552709723687588	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0	22796016	2022-11-24T20:21:12.000Z	0x444fce22fc905e35352b7c30c79d3f40bef43b7b6f98ccc93ea1b418afd03ec3
0x9ad6c38be94206ca50bb0d90783181662f0cfa10	0x409cb8505df93196909328fc9b948ddcb4e70c85	false	16623	0x9dd4e962123ac4b69749434a971cae2d4a32e5c4	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	19	17110556	2022-07-09T17:43:27.000Z	0x2b473a67f5c88ed6255eaac2363a2dd9564c033005a85dd951cc24b90fb8d8ac
0x9ad6c38be94206ca50bb0d90783181662f0cfa10	0xb9775b9efefaefa014f159ae43058c954116aa31	false	16621	0x9a8e0217cd870783c3f2317985c57bf570969153	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	6	17080753	2022-07-09T00:58:05.000Z	0xd880962eb55ea55a75c853da252266037c1da92d68f904dc8002d85bb4f3727f

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

APTFarm_Harvest_event

APTFarm_RewardClaimed_event

BoostedMasterChefJoe_Harvest_event

MakerRewarder_RewardClaimed_event

MasterChefJoeV2_Harvest_event

MasterChefJoeV3_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

​Tables

​APTFarm_Harvest_event

​APTFarm_RewardClaimed_event

​BoostedMasterChefJoe_Harvest_event

​MakerRewarder_RewardClaimed_event

​MasterChefJoeV2_Harvest_event

​MasterChefJoeV3_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

Tables

APTFarm_Harvest_event

APTFarm_RewardClaimed_event

BoostedMasterChefJoe_Harvest_event

MakerRewarder_RewardClaimed_event

MasterChefJoeV2_Harvest_event

MasterChefJoeV3_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event