uniswap_v2_bsc

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
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	1	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	101	36111192	2024-02-13T22:14:45.000Z	0xf1429dc6723b90560e5565f08a8a7d5e087d4c9557d079bc753c8b25ab33418e
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0xc6c5047405bce6d583feb2a91c504346d0ea60ca	false	3	0x55d398326f99059ff775485246999027b3197955	0x9400aa8eb5126d20cde45c7822836bfb70f19878	157	36320298	2024-02-21T04:50:20.000Z	0x174be71695d2ce4c0edad9bf91b4fa689633178dfdb07e45b56e2e057a0f8606
0x8909dc15e40173ff4699343b6eb8132c65e18ec6	0xf15fa3d7b9aa58382cd458b97f4dc0749183995e	false	4	0x50fd6f86c7537ffede56171a50aa8b6045b241dc	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	191	36320779	2024-02-21T05:14:23.000Z	0x45fcd705c16f6ec07469af3ac6b011ae6cdc82007bc43c25f2b9a32d9c40f559

Example Query

Query with partition filter

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

Factory_setFeeTo_function

Uniswap V2 Factory setFeeTo function call records for updating the protocol fee recipient address. Captures administrative transactions that configure the address receiving protocol trading fees.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__feeTo`	`STRING`	Address designated to receive protocol fees from Uniswap V2 factory operations. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_bsc.Factory_setFeeTo_function`
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
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0xc2768122cdddb7124672fa98590625a4b9287643	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	58	201988407110811626870294544	31594653020685583	40501607	2024-07-15T18:34:59.000Z	0x63048605de74f02640ca8c3117e3f93f0f27ce16f3cdc2919ed1d5b514c30ef2
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0xce4fafac517abfb1f550a8c6713421f2505a259b	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	412	218826105050159028	24591585237815936274	40488836	2024-07-15T07:54:16.000Z	0x1cd1a3be0c2a77d5663ef940569b2aca777b7433089a7c5d8cd566c8ca880243
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0xe28e2fe5dc4cd68e29adc75c564ca6e488f91ae9	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	109	9999999999999996837722	999999999999999	39086809	2024-05-27T11:08:17.000Z	0x9bef01e52d85c00c61538a566bd84e65ea3cbecb0d9004863d86554e96575167

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	109	48561179834901162615	150000000000000000	36111192	2024-02-13T22:14:45.000Z	0xf1429dc6723b90560e5565f08a8a7d5e087d4c9557d079bc753c8b25ab33418e
0x72901e5628c92486397369100a14550103e2cef6	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	15	10000000	3550000000000000000	36321104	2024-02-21T05:30:46.000Z	0xbd7232f36899ca6effa5c537ae7f2c5a8304909f7a7900f7421b274651293017
0xf15fa3d7b9aa58382cd458b97f4dc0749183995e	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	199	10000000	10000000000000000	36320779	2024-02-21T05:14:23.000Z	0x45fcd705c16f6ec07469af3ac6b011ae6cdc82007bc43c25f2b9a32d9c40f559

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x000000000d73c899c2234737da01d5fe620fd603	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	0x000000000d73c899c2234737da01d5fe620fd603	682	36158495	1805429104217339764	0	0	5361309141395431	2024-02-15T13:43:02.000Z	0xa84c1154fbfad7eeb404a5c2e4489565971fc97aed83d5706761659d4e0a0a50
0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	434	36337366	0	5216779716941263	1969036323858013403	0	2024-02-21T19:05:25.000Z	0x5b1adff9e2688de01bbb440ac01fbd13f94d50d5fad51fe89fcc2da89e0d4634
0x4c0583a3b1b1b240297839f1efe7af3d09bd9fcc	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	0x4dae2f939acf50408e13d58534ff8c2776d45265	599	36330635	0	1325430035133751	500000000000000308	0	2024-02-21T13:27:40.000Z	0x1d69e47f79640ed2a6831198e4c356989258d48eb85aafe102d16c744557d73f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	681	50366608939118502379	144638690858604569	36158495	2024-02-15T13:43:02.000Z	0xa84c1154fbfad7eeb404a5c2e4489565971fc97aed83d5706761659d4e0a0a50
0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	108	48561179834901162615	150000000000000000	36111192	2024-02-13T22:14:45.000Z	0xf1429dc6723b90560e5565f08a8a7d5e087d4c9557d079bc753c8b25ab33418e
0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	false	264	51848657282750728631	140555147159625320	36334931	2024-02-21T17:03:12.000Z	0xf493ca3628529d36a58573a4972c1ec64b19c8e876a979a4f9948e20ab803725

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x4423b0d6955af39b48cf215577a79ce574299d3f	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	0x0000000000000000000000000000000000000000	false	2698921446658862836	107	36111192	2024-02-13T22:14:45.000Z	0xf1429dc6723b90560e5565f08a8a7d5e087d4c9557d079bc753c8b25ab33418e
0x0000000000000000000000000000000000000000	0x57c68f0e9e6be81fb4d9a46e1910c5daa9c4cfeb	0x0000000000000000000000000000000000000000	false	1000	106	36111192	2024-02-13T22:14:45.000Z	0xf1429dc6723b90560e5565f08a8a7d5e087d4c9557d079bc753c8b25ab33418e
0x9885d61bdedf7343706385c33e9a1456b25b2962	0x72901e5628c92486397369100a14550103e2cef6	0x0000000000000000000000000000000000000000	false	5958187642906	13	36321104	2024-02-21T05:30:46.000Z	0xbd7232f36899ca6effa5c537ae7f2c5a8304909f7a7900f7421b274651293017

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Factory_setFeeTo_function

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event