thena_v1_opbnb

Tables

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
0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	0x8a322bf307aa673424c445f576f2992f381521fb	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	11	311761509098813	206482318332108431	60295399	2025-05-30T17:39:21.000Z	0x1656ad6dd2d6d7c02c9aaf79e22d786761eda82cab934f58050f910a60b029cc
0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	0xb28d061c472bbc2183394c85ae6f41e467f0bbdf	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	11	316579857433563	766692154879936346	73398154	2025-08-14T13:28:58.000Z	0x7406b18d07228adf5e3f7aba29a3f06d2fb90dfd054f20bf1cd12dc433541b6c
0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	0xb28d061c472bbc2183394c85ae6f41e467f0bbdf	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	5	63495438221517438	153793988692731611584	73410878	2025-08-14T15:15:00.000Z	0xbb8e79425cd74f6ef6ee3d8099c21136061a8944d0aeb3e5e1b780be8a0bd939

Example Query

Query with partition filter

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

Pair_Claim_event

Claim events from liquidity pool pair contracts recording amounts of both tokens withdrawn by liquidity providers. Tracks sender address, recipient address, and claimed amounts in smallest token denomination for both token0 and token1.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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	in_recipient	block_timestamp	transaction_hash
0x8a322bf307aa673424c445f576f2992f381521fb	false	0x6ab8af38fcd04bd18059699096b059cdcc623e52	4	25089641	68738621772	78637254	0x6ab8af38fcd04bd18059699096b059cdcc623e52	2025-09-13T21:08:08.000Z	0x952a18e988e2c099755ee6acd80b0a0506198700ca9e0cf7adf2ceeeb1ed5016
0x8a322bf307aa673424c445f576f2992f381521fb	false	0x3a987fb830f36e8dfc1111e72ce4d6983e2966c0	4	5414538	3722740560	78549005	0x3a987fb830f36e8dfc1111e72ce4d6983e2966c0	2025-09-13T08:52:44.000Z	0xc93f56ae9ab1951e2128ef37160d9c2afb7c79fbbe472022332604293cc6dff2
0xb28d061c472bbc2183394c85ae6f41e467f0bbdf	false	0x3b9b1b19eaace67b2b455f931968dd6e6a51e8db	41	13198912659	19718338836132	25757395	0x3b9b1b19eaace67b2b455f931968dd6e6a51e8db	2024-06-04T14:25:18.000Z	0x09f1422bfb5df343357334ef3af5c7b017a4c4354c14e5a8d8023a0229ef3b46

Example Query

Query with partition filter

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

Pair_Fees_event

Trading fee collection events from Automated Market Maker (AMM) liquidity pairs recording fee amounts in both token0 and token1 denominations. Used for tracking protocol revenue and liquidity provider earnings across decentralized exchange 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.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x8a322bf307aa673424c445f576f2992f381521fb	false	0x000000000000c6399510f47ef7691db4db17ae8a	8	0	34371210876851011	33827796	2024-09-06T00:11:59.000Z	0xbed59d0e2bd8665187c380cff3c689143189b712109cf931a8b69b38dfdc6f59
0x66066bf9727dfcde097a60b9711488b6494a766a	false	0x000000000000c6399510f47ef7691db4db17ae8a	5	0	314887622631758	33828578	2024-09-06T00:25:01.000Z	0x5152f9b0a4ba5a6fc81b81fb5293a3dae4ec2ee140514dee5ca3f3546bd68e7a
0x66066bf9727dfcde097a60b9711488b6494a766a	false	0x000000000000c6399510f47ef7691db4db17ae8a	3	76939051135773	0	33828580	2024-09-06T00:25:03.000Z	0x5590aaf4ecdc63d935558fc3f5a62b8ad1b501bfa1944ff1955ac3cd91fa2ce3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v1_opbnb.Pair_Fees_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
0x66066bf9727dfcde097a60b9711488b6494a766a	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	14	172991940190716715	30553195226237170	20519082	2024-04-04T23:20:05.000Z	0x360a372e21f44227fae94cc0af07cc2ee3482d3dc8b9b8ff0ea80a40cbd41b11
0x66066bf9727dfcde097a60b9711488b6494a766a	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	27	131654294310623554	22170237022469463	20435380	2024-04-04T00:05:03.000Z	0xc3edcf8fb38913000196549f6e1c6b16c0dda368b6042c4c9115cb52978c727d
0xb28d061c472bbc2183394c85ae6f41e467f0bbdf	false	0x4e02accd83c09eaf2ff4b8346ed6a33a7a369b47	51	11953421975710133	12291397988595819016	20486216	2024-04-04T14:12:19.000Z	0x38ed3e7edf5ac7178bf91972858ba4a47a8b0ae360fdb0f4db4541b2349f922b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v1_opbnb.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_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x20371b60e72b23878ac384f152977440fa4d5f60	0x12cfff1167cfdf0e51eea93bd8d5f692ee17fa2a	false	0x20371b60e72b23878ac384f152977440fa4d5f60	76	62259416	0	7688670205644	33390934717472	0	2025-06-11T02:26:09.000Z	0xf801bcdf5ed27bf4765d7df228c3adcb410719411ee1131ac61d2bb84640ce68
0x20371b60e72b23878ac384f152977440fa4d5f60	0x49a068661bf7a46de37231d1b1c4dc9c1ff97ad3	false	0x20371b60e72b23878ac384f152977440fa4d5f60	17	62259458	30874591431565110	0	0	11612582357778	2025-06-11T02:26:30.000Z	0xf271874e0c839a5504c17410886e0e667da88e073563f215d6b5b1538f8158c3
0x000000000000c6399510f47ef7691db4db17ae8a	0x66066bf9727dfcde097a60b9711488b6494a766a	false	0x000000000000c6399510f47ef7691db4db17ae8a	7	62331476	0	934966575596465	3908872931932988	0	2025-06-11T12:26:39.000Z	0x7eec15d5eabf8dda0f693465a40a1721d3c3473145ae48eaf60ec67ee043fac0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v1_opbnb.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
0x49a068661bf7a46de37231d1b1c4dc9c1ff97ad3	false	310	906272900252741547	86465798753151	29879052	2024-07-22T07:19:35.000Z	0xe8ff07ec279010c8367f4e684b772246c4cf0bf20a6931f3dbbd2615e87d0d22
0x4d3d931154928a2de34804541a5babd528727ed2	false	94	1569834617697269778	29804980254797610981	29865848	2024-07-22T03:39:31.000Z	0x0eefb97a0b8c2afa780b676052a83ef2efea9d931120e5d23e7e6bfd5c50f1d7
0x4d3d931154928a2de34804541a5babd528727ed2	false	44	1569802336659855294	29805593157237793540	29867270	2024-07-22T04:03:13.000Z	0x509b2d256f49dcca0cae9166be5b8b33445e865ed176d4060c84a29572735b88

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v1_opbnb.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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x7814cf5680722e952d5d8b5db3c103dd318ab921	0x4d3d931154928a2de34804541a5babd528727ed2	0x6075d3266e56e87e4c269de221c9c6884a809c4f	false	3101978591991662	44	38188485	2024-10-26T11:30:08.000Z	0xae89724493671e97331c5660ec258ff5787c6d6ca87a545130af2c79a169a544
0x4d3d931154928a2de34804541a5babd528727ed2	0x4d3d931154928a2de34804541a5babd528727ed2	0x7814cf5680722e952d5d8b5db3c103dd318ab921	false	3101978591991662	38	38188513	2024-10-26T11:30:36.000Z	0xbe1f4214e60a064884479e3c54023e994641f6789ef784a608337f35e8674009
0x0000000000000000000000000000000000000000	0x4d3d931154928a2de34804541a5babd528727ed2	0x4d3d931154928a2de34804541a5babd528727ed2	false	3101978591991662	39	38188513	2024-10-26T11:30:36.000Z	0xbe1f4214e60a064884479e3c54023e994641f6789ef784a608337f35e8674009

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v1_opbnb.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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.

Sample Data

address	in_pair	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xfc1bc666a98703505534477e651a2470508c99a4	0x4268f372aca6077b5e8e38d14bf8e8966ada0318	false	1	false	0x9e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3	0xe7798f023fc62146e8aa1b36da45fb70855a77ea	2	9959274	2023-12-04T18:03:17.000Z	0xd701a05d6af99cbe1317662c29983feaba892dcb0d99ed47f09e218b5ca5e0b1
0xfc1bc666a98703505534477e651a2470508c99a4	0x867d4dada6bf8a74fdddb0f135ea397463c1d072	false	14	false	0x4200000000000000000000000000000000000006	0x7c6b91d9be155a6db01f749217d76ff02a7227f2	32	10795694	2023-12-14T10:23:37.000Z	0xcacc318557ca95c6aa89c2bb88652e3cd44fba56bfcc132b7d6ebc68a57f8682
0xfc1bc666a98703505534477e651a2470508c99a4	0x26b9c56c43fd74585d2734ebc4be4c407c2322cd	false	15	true	0x9d94a7ff461e83f161c8c040e78557e31d8cba72	0x9e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3	1	10823050	2023-12-14T17:59:33.000Z	0x59e61922297c07511043004bd70d009cd9604b947b4a08ab46a19ebb26ba03e1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Pair_Burn_event

​Pair_Claim_event

​Pair_Fees_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

Tables

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event