ubeswap_v2_celo

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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
0x62d5b84be28a183abb507e125b384122d2c25fae	0x1da8e0f04721133ea65fba2ad48ab762ed5ba604	false	557	0xe685d21b7b0fc7a248a6a8e03b8db22d013aa2ee	0xed6961928066d3238134933ee9cdd510ff157a6e	1	11534133	2022-02-19T05:41:43.000Z	0x2154cd0550c8321af972809838418035467312f36d0af223d790e1117a452773
0x62d5b84be28a183abb507e125b384122d2c25fae	0x5033ca747e1a946ad3cfa8aff28a91548fd45f09	false	556	0x471ece3750da237f93b8e339c536989b8978a438	0xed6961928066d3238134933ee9cdd510ff157a6e	3	11533077	2022-02-19T04:13:43.000Z	0x51a52612ca26d0cd86a6596ddd0db3c42fd7e410115917aa279bf88dce8c451d
0x62d5b84be28a183abb507e125b384122d2c25fae	0x8eb0ea8043c7059af2c20e81348ae0470f14e225	false	555	0x4510104cf2cc3be071f171be7c47b8d6beaba234	0xed6961928066d3238134933ee9cdd510ff157a6e	3	11533056	2022-02-19T04:11:58.000Z	0x0549ec20dc89be3c85075d8603843cb7f539c187f3917ea169d61947ca2d002b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ubeswap_v2_celo.Factory_PairCreated_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
0x9fe89450e91437a092339290f1d300a099a654e6	0xe7b5ad135fa22678f426a381c7748f6a5f2c9e6c	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	5	19679672440368289511	9437057212106048732	6442171	2021-04-30T12:56:20.000Z	0x94f3458d37f31e1b1a0156ad0d88735b383d7b5c113ed7738926d26d8584e602
0x03f740a94eb122cdafeef307949ece62b2876b4a	0x1e593f1fe7b61c53874b54ec0c59fd0d5eb8621e	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	6	921820282061527477	4919656241481908694	6447861	2021-04-30T20:50:30.000Z	0x2bdaeb25598d2c439c399430fdf511fface2e24fc38f3876b340272f9a4a3d23
0x9a5c01715e2041516278eeb46f46103e91b64e5d	0xb715157f6c16dd6523973c944f79ae4173dfebfe	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	6	96251339866664030170	205592338503554442425	6433299	2021-04-30T00:37:00.000Z	0xefb0b5a734b49d402017643a6d0f596e8d3f50e119b176680ebef74768742610

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ubeswap_v2_celo.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
0x65596e0f281b0cbcba0aa261982690e9bcba7247	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	6	34023872779792589110	1097203001381038463	12255880	2022-04-02T00:08:26.000Z	0x7f23fdcdcd47f8daf13d6cb97629e0afa48a4c5957e3ae3d04bc326eb2f08750
0x39ac98447f28612d3583e46e57cb106337fcae3f	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	5	3455602204382553926066	1839808208029252199	12255893	2022-04-02T00:09:31.000Z	0x2782fb4f1c580bcf7e20cb7a4c986c530a13c43e9768dd52834a63262300120a
0x65596e0f281b0cbcba0aa261982690e9bcba7247	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	105	24134001620728252272	778185723637590885	12255955	2022-04-02T00:14:41.000Z	0xe352b587241834dacda196bdd03907d3d2607304c40b8d7eb2359b66c90a031d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ubeswap_v2_celo.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
0x1e593f1fe7b61c53874b54ec0c59fd0d5eb8621e	0x01522c42ca43d7bfd34f373d41ad7d90a95e714c	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	13	22234233	697254398442049927	0	0	57442881178483542971	2023-11-01T11:56:03.000Z	0x12bd38e780f1728bc436169f5aa7bccbf3023250ad0bf759ef115fb3f8dbff72
0x7d28570135a2b1930f331c507f65039d4937f66c	0x01522c42ca43d7bfd34f373d41ad7d90a95e714c	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	35	22238024	1000000000000000000	0	0	82029637205888657411	2023-11-01T17:11:58.000Z	0x00b91badef224ffc6b23170632e54583ab4a62f389a5be64ea06d173372420e6
0x7d28570135a2b1930f331c507f65039d4937f66c	0x01522c42ca43d7bfd34f373d41ad7d90a95e714c	false	0xe3d8bd6aed4f159bc8000a9cd47cffdb95f96121	77	22238718	0	102371059294379971134	1235270690272968934	0	2023-11-01T18:09:48.000Z	0x8eb4f6e6a460e33b4b3b6455d5945715b1e65498c5c1afb6c2d6afa34dd132b1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ubeswap_v2_celo.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
0x11ce57aaae0418d120e4415691b6f174219e4b02	false	4	364720179024252598687	35305575081339452365031	12255779	2022-04-02T00:00:01.000Z	0x7d4ae02955cb3e2d4bbe2760fad96c964e46f75cca059bae5a7ce3c0b4a52594
0x9f437509e61896738ea8cdb6cded618c0e509032	false	5	130341710767941466632034	400465334602542494504805	12255780	2022-04-02T00:00:06.000Z	0xe228fc8af1075c758d76cafb7c605757367094ab82c58d156c561d94f140ae2a
0x11ce57aaae0418d120e4415691b6f174219e4b02	false	35	364717671055281496687	35305818824102686402735	12255783	2022-04-02T00:00:21.000Z	0x16bce85b956ae611c4f31858f82f152cd4a3cf8867808c5881074748164b68bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ubeswap_v2_celo.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
0x4e1561e35db0dd93e48241f9b7413671c37cdbfb	0x5d3be0ef8f83d2df0782a89bdcd28978ed4dd13f	0x0000000000000000000000000000000000000000	false	28219917589589802052	51	16229730	2022-11-19T00:10:53.000Z	0x6dcb701169e3c6bb5b36ca6b313c547d0fe7eaf913de2071791b5b2e1deb822a
0x9598143cad531593ebea31cbf074106a92d3ccb0	0x5d3be0ef8f83d2df0782a89bdcd28978ed4dd13f	0x0000000000000000000000000000000000000000	false	363629715975722483	50	16229730	2022-11-19T00:10:53.000Z	0x6dcb701169e3c6bb5b36ca6b313c547d0fe7eaf913de2071791b5b2e1deb822a
0xf725d0ed5987bd9e7ef725491c584a84e4212708	0x5d3be0ef8f83d2df0782a89bdcd28978ed4dd13f	0x4e1561e35db0dd93e48241f9b7413671c37cdbfb	false	28219917589589802052	8	16229748	2022-11-19T00:12:23.000Z	0x50f8c05402d5d51ea93c2cc945c78d91b216dd9720d2b39c0405b5f33f5b6e6e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event