traderjoe_v1_bsc

Tables

APTFarm_Harvest_event

No description available.

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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 APTFarm (Automated Pool Token Farm) liquidity mining contracts on BNB Smart Chain, tracking token rewards distributed to users per market and epoch. Used for analyzing farming yield distribution, user participation patterns, and market-specific reward allocations.

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	0xa58627a29bb59743ce1d781b1072c59bb1dda86d	false	1	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0x3310cbba60ab2e5a73e79c58185aacdf93ab2aaf	221	507657277777777777778	30438842	2023-07-31T08:21:45.000Z	0xa4a955e39cf9c75f27c9368939d6cc3de456014d291b193db68ea61f03d32336
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x7181abec856bcbc77cfcd8ee8c85392ea403a878	false	1	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0x3310cbba60ab2e5a73e79c58185aacdf93ab2aaf	144	300746740740740740741	30429107	2023-07-31T00:13:23.000Z	0x0d85e05682fa5f798faafe3502360a8fb1a45c474d0481b58d4f713193bf7331
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x92ff5ebb3cb32ce771d9095d8efdb39765fb9108	false	1	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0x3310cbba60ab2e5a73e79c58185aacdf93ab2aaf	225	339569777777777777778	30444987	2023-07-31T13:30:25.000Z	0x45936d467877e968e1faeedf17a52b057d5a6d45e55e4191b176a83edbd2b7ee

Example Query

Query with partition filter

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

MakerRewarder_RewardClaimed_event

Reward claim events from Trader Joe V1 market maker incentive program on BNB Smart Chain (BSC), tracking released and unreleased token rewards by user, market, and epoch. Used for analyzing liquidity provider compensation and reward distribution patterns 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_token	in_market	log_index	in_released	block_number	in_unreleased	block_timestamp	transaction_hash
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x9289247f70b1229cba50da40720ee5652b77b82f	false	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xac3e25ea542b471921ecfdfe19d5f23add1c73e7	161	535000000000000000000	30172187	0	2023-07-22T01:29:07.000Z	0xc47a770c6b265444b2d0f8d3171884ce13d7cf772e772f13f0ea560b24604994
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x4867dca57c00641332cdb96a4746b3eb29360618	false	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xdf41c34dc3adcce16e1a9e96af74972a21473799	177	38118983796296296296	30181486	215641453703703703704	2023-07-22T09:14:44.000Z	0x619e11c5ebb1598473082c2a7dfb8b942589ffd0290e1b28a5a151c5832d9c9b
0x624c5b9beb13af6893e715932c26e2b7a59c410a	0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6	false	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0xdf41c34dc3adcce16e1a9e96af74972a21473799	76	531139185185185185185	30188612	930860814814814814815	2023-07-22T15:11:28.000Z	0x7b20d5ba710a0dfe959912e51b7d5e176a797d795b3545316bd236ccd55969fd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.MakerRewarder_RewardClaimed_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
0xa2425918f30af40db42b7ed6197be7f7be43895f	0xc56efe56dfc9b0e7482be4871ef7eac6303451c7	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	52	5134127338178471	621829454684484489	29953998	2023-07-14T11:09:48.000Z	0x3abc68d63dcaa12213cd7965c9129f4c00015b818cb54365c25334bb90f3b7fd
0xa2425918f30af40db42b7ed6197be7f7be43895f	0x36ef351f325652fd1fb4ae3797bd26d20fc83d46	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	306	770074920010956601593	3035087477645575997	29954285	2023-07-14T11:24:10.000Z	0xaa13b798b0df0c8d145d34ef6c4b8da767148eb485907c951604af75556fdc82
0xcd25325a6ef20bc5df9bceac0cc22a48d2e8f6ef	0xb96d73eb161dea692478b8859f0027fe2e4735fe	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	107	736717092640217910060743	2127456121091367816	30537199	2023-08-03T18:36:03.000Z	0x0fa912d363d87e50e4f796c4ec55a9013d27e4fc802e0da7ad80e9d9758b055e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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
0x61d3fe670f2a5878cdab950e4b8d0094f13bc793	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	603	1000000000000000000000	8250000000000000	29178096	2023-06-17T10:37:13.000Z	0xafa702541ac4987581ef6929a664411db670157313ef3b5ff649de243e493322
0x8b566fcf22670a776796fb6de97af7f32cbfe41e	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	183	28876425312453814062	120505000000000000	30879223	2023-08-15T16:33:45.000Z	0x349b57ea22043e3bf46423883ea400f0a63594c4aa872c75d54448f13694034e
0x3e008f9c8d42cf2dc5a7eee63f4e389ac5ead233	false	0x89fa1974120d2a7f83a0cb80df3654721c6a38cd	157	3149997970344114276	3960890000000000	30865479	2023-08-15T05:05:09.000Z	0xe8769956e7c7fbc1bce903fc973f3193a5902768b0127bad597e1efcb5806420

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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
0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	0x7c752e0caf1647d2407a5666a42a858edeaeaa9a	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	128	29183299	999999874889	7229848977042	2023-06-17T14:57:54.000Z	0x44b3c9532b1852448b10687336b48669bf0a176141f2f4a4e46d04005b9bf286
0xbf529076bf8d976c321e21f0cd3c52fbff51008e	0x7c752e0caf1647d2407a5666a42a858edeaeaa9a	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	189	29166520	999999964076	7268820306097	2023-06-17T00:55:34.000Z	0xe8086ca1e620a5d2744183b2aba169395257187b0c2c4fddb724b32184c5f54f
0x023ff63aa03060cfe97018e2854318bea9873fd5	0xb784c80bfc8f8131bf8d10d4af76dffbed0adf87	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	369	29179481	87495648625634	21532969764296142	2023-06-17T11:46:39.000Z	0xd6e2cce4e5b3afda0a8d1f038b50abab1dc9082333c9fa99b1a5066fd88e679a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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
0x17f078c628f1b60b04454341201596d9980c1c8a	false	206	3634227760653806956116909	513929883721274910	29940224	2023-07-13T23:38:28.000Z	0x6ccdffb5d5aa0e53146020ef8c10d84e5929c941e5bf72ce30306040dba72840
0x17f078c628f1b60b04454341201596d9980c1c8a	false	157	3816643949997763287980985	489296277701252643	29940221	2023-07-13T23:38:19.000Z	0xe1b31dc945478a98dcc83ff751e1ba5eff10593d3c35baf338245f6b59e842fd
0x2331be50d2692a4f5e08bec309d710439a3d04b1	false	365	177247857103933937	1749011032157698	29935696	2023-07-13T19:51:52.000Z	0x97202b5d0c552fdab2132f891379d05b4587d0a719c3cf88eacd67d5506ba569

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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
0x0000000000000000000000000000000000000000	0x3e008f9c8d42cf2dc5a7eee63f4e389ac5ead233	0x0000000000000000000000000000000000000000	false	1000	105	26253623	2023-03-07T08:34:45.000Z	0xb0355cc87acb7bc3e7197deaf551963298b5731a6cb85f0c527d295cd79d90f2
0xaa60b4809489acb990a9b7ca7aa58c75781d23a8	0x3e008f9c8d42cf2dc5a7eee63f4e389ac5ead233	0x0000000000000000000000000000000000000000	false	292751191287071305	106	26253623	2023-03-07T08:34:45.000Z	0xb0355cc87acb7bc3e7197deaf551963298b5731a6cb85f0c527d295cd79d90f2
0x0000000000000000000000000000000000000000	0x7d522f3738dec951c177f1e246c85b190d143498	0x0000000000000000000000000000000000000000	false	1000	132	26264819	2023-03-07T18:01:50.000Z	0x1e94440951bb49aa2ec9c1845761c2c756bba29f464f16e1fa7438f033e2e7a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.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
0x4f8bdc85e3eec5b9de67097c3f59b6db025d9986	0x17f078c628f1b60b04454341201596d9980c1c8a	false	14	0xa5522ae272b74b014bc20ef7ef2e2b87af0787d8	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	206	27836914	2023-05-01T18:50:29.000Z	0x2281c62fc772559abeafc39c2569187ce9c68ed9ad9d32f2df9974782025ecd8
0x4f8bdc85e3eec5b9de67097c3f59b6db025d9986	0x8b566fcf22670a776796fb6de97af7f32cbfe41e	false	2	0x55d398326f99059ff775485246999027b3197955	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	112	26142881	2023-03-03T11:27:04.000Z	0x39d07dee2653ad3a230d5fb2786666d53b9d3863ecf78dbc6abe7f3dcdb85998
0x4f8bdc85e3eec5b9de67097c3f59b6db025d9986	0xb784c80bfc8f8131bf8d10d4af76dffbed0adf87	false	1	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xe9e7cea3dedca5984780bafc599bd69add087d56	176	26142878	2023-03-03T11:26:55.000Z	0x112f789e1a9843111d3e4a6c5e2d16edfd1af09d7117e7d52f05564be6c4f3b8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v1_bsc.PairFactory_PairCreated_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

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​APTFarm_Harvest_event

​APTFarm_RewardClaimed_event

​MakerRewarder_RewardClaimed_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

MakerRewarder_RewardClaimed_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event