uniswap_v2_avalanche

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
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	1	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	20	41630079	2024-02-13T16:48:43.000Z	0x78cbd6ff0cb39424833e595fd3df8d9e1dc5bd4d98ab945b5704ffdfc339a678
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0x6b60865fabc6c7280fd1dcc125549698a76d5444	false	2	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xc2db4f94ceb108d851743332f7e0cd92861c1f6f	43	41958784	2024-02-21T09:41:10.000Z	0xd82517ff6931dc48fd535c26ad2654ca33a6b02564ca4d253dd908d4dcd87dcc
0x9e5a52f57b3038f1b8eee45f28b3c1967e22799c	0xb315a298f124d3fbe7e49d509973c69290a40476	false	4	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xec3492a2508ddf4fdc0cd76f31f340b30d1793e6	3	42010445	2024-02-22T14:44:31.000Z	0x908d3368b746e06fb604b17d35718c944c8fc4829279c262fadab4e12dd4d10b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_avalanche.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`	`STRING`	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`	`INT64`	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_avalanche.Factory_setFeeTo_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Approval_event

ERC-20 approval events emitted by Uniswap V2 liquidity pool pair contracts, granting spender addresses permission to transfer specified amounts of LP tokens on behalf of owners. Used for tracking liquidity provider token allowances and router authorizations.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. 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

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0x4423b0d6955af39b48cf215577a79ce574299d3f	2497998729983	3	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	41630111	2024-02-13T16:49:50.000Z	0x442dcf9b4344b77a51f8495e176fe63ab3caf818675d5b8881affb4fa67b3ec7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_avalanche.Pair_Approval_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
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	9	374999999962357366	16639993	41630111	2024-02-13T16:49:50.000Z	0x442dcf9b4344b77a51f8495e176fe63ab3caf818675d5b8881affb4fa67b3ec7
0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	0x39517474d6c166b5d4d4a50587d1535b273e9694	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	6	3449020681208108089898240	1416500815576329001	65901769	2025-07-22T17:56:04.000Z	0xedb7a5745c50f67904c00d17ab19f732f4ca3b3d011e17f901c8b3045e95ce8c
0x4fe93ebc4ce6ae4f81601cc7ce7139023919e003	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	9	496718455782153	12655	65932961	2025-07-23T08:38:57.000Z	0x380846744f3edf52a191497283b4bfa64b914df8f8f88e48bc0fd619a4358c27

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	27	1500000000000000000	66559975	41630079	2024-02-13T16:48:43.000Z	0x78cbd6ff0cb39424833e595fd3df8d9e1dc5bd4d98ab945b5704ffdfc339a678
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	28	374999977476481725	16639993	41630119	2024-02-13T16:50:06.000Z	0x48b36dce52204ec5ca0da15cf259f374154781f8e829b59dbd9ecb57c12171e0
0x6b60865fabc6c7280fd1dcc125549698a76d5444	false	0x4752ba5dbc23f44d87826276bf6fd6b1c372ad24	51	3000000000000000000	20247500000000000000000000000000	41958784	2024-02-21T09:41:10.000Z	0xd82517ff6931dc48fd535c26ad2654ca33a6b02564ca4d253dd908d4dcd87dcc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x035d10e2ae3406fdd145d59d63ff2aa57870e189	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0xc02959788edadc5190d8ebf8a724979cf983dfb9	21	41630860	99413383406905376	0	0	4125470	2024-02-13T17:14:59.000Z	0x7c5c2b9c95afab998fb70a903f802cbcc95ca4c8f01417e86795ab3650c43085
0xb7453127e28ee32f97fba7a4e990de6c92c8ac50	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0xb7453127e28ee32f97fba7a4e990de6c92c8ac50	47	41707445	0	3334309	80855165447633974	0	2024-02-15T12:18:08.000Z	0x970538135ace1a86e6cd3af6101f8499ae3a5dd026694e39dcc6d067f881613f
0xc9db1bf41e87df7459e9806bdf14f010f05cddce	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	0xcd243350f78c7526482f54138a791cad9ba8c7b6	10	41891510	88963780000000000	0	0	3629473	2024-02-19T19:48:16.000Z	0xea01e8a5cefb915386a34f218bc477e80d9080477ef901bc2f9d16bfd20c39d3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	9	1607521975473395761	62139341	41891510	2024-02-19T19:48:16.000Z	0xea01e8a5cefb915386a34f218bc477e80d9080477ef901bc2f9d16bfd20c39d3
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	8	1125000000037642634	49919982	41630111	2024-02-13T16:49:50.000Z	0x442dcf9b4344b77a51f8495e176fe63ab3caf818675d5b8881affb4fa67b3ec7
0x6239ae4d661379b71a90c4c79f0a95297342e391	false	20	1599413360921029735	62434505	41630860	2024-02-13T17:14:59.000Z	0x7c5c2b9c95afab998fb70a903f802cbcc95ca4c8f01417e86795ab3650c43085

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_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
0x6239ae4d661379b71a90c4c79f0a95297342e391	0x6239ae4d661379b71a90c4c79f0a95297342e391	0x4423b0d6955af39b48cf215577a79ce574299d3f	false	2497998729983	4	41630111	2024-02-13T16:49:50.000Z	0x442dcf9b4344b77a51f8495e176fe63ab3caf818675d5b8881affb4fa67b3ec7
0x0000000000000000000000000000000000000000	0x6239ae4d661379b71a90c4c79f0a95297342e391	0x6239ae4d661379b71a90c4c79f0a95297342e391	false	2497998729983	5	41630111	2024-02-13T16:49:50.000Z	0x442dcf9b4344b77a51f8495e176fe63ab3caf818675d5b8881affb4fa67b3ec7
0x4423b0d6955af39b48cf215577a79ce574299d3f	0x6239ae4d661379b71a90c4c79f0a95297342e391	0x0000000000000000000000000000000000000000	false	2497998580197	26	41630119	2024-02-13T16:50:06.000Z	0x48b36dce52204ec5ca0da15cf259f374154781f8e829b59dbd9ecb57c12171e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_avalanche.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_Approval_event

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_Approval_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Approval_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event