uniswap_v2_ethereum

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
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0xf36bfe9bf213874e83b26ec73af8f2c650ff64d7	false	89941	0x0f2d719407fdbeff09d87557abb7232601fd9f29	0x2385f55672475fb9263c41d44092a761454bca82	184	15374005	2022-08-19T22:50:18.000Z	0xb83dfc1c5365098fd07ed309f27988118e84e7171be84758ae74d6beaec67c43
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0x481fd71eefaf67fde61a6d9129694421ec2cf0e2	false	89831	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x26f7d7509490b292afbb0443a7a371d345b5f684	107	15370325	2022-08-19T08:47:32.000Z	0x6f9765082d8723c7e3fa42fbca02836806f097e231d7a7d7c8c5adcd06d93f7f
0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	0xf848e97469538830b0b147152524184a255b9106	false	89916	0x1bbf25e71ec48b84d773809b4ba55b6f4be946fb	0x97be09f2523b39b835da9ea3857cfa1d3c660cbb	31	15372940	2022-08-19T18:38:06.000Z	0xc9b948ec53a92a3692696ebe588546b7e0b3599da1aeaf3b6ad7253451ff5475

Example Query

Query with partition filter

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

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
100000	false	22613	0xf46901ed	0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	10128636	0x1e52c0887bc0f752368dfb80974ec988ab40aed3	2020-05-24T12:49:52.000Z	0x45deee9c24939739202181ae066afd3247a6373adcffe6a6eea54465eebc7a8b
31000	false	23913	0xf46901ed	0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	14725333	0x11406a7317579bd4527f21f9ac5b5c46745a9706	2022-05-06T19:18:47.000Z	0xf9821757f9978142c1c0cdfb50cf8c235bf858cbac7831a66ce9ba34cdd31623
59987	false	23913	0xf46901ed	0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	22415514	0x946e8359f886a22a43b21cf73a3459b97278fc9a	2025-05-05T05:40:59.000Z	0xe76104cc342e334c3551e3439cbe1ec80000585d8c6dab1478fc99c9d8a670f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.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
0x699c0a0137d6a8cab0c0c7724d76fe14ee4c71fd	0x006ab6865c3a1350d307ce2ba999ce694812da17	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	6	61042034160476803150903369	1642378947090655424	16915594	2023-03-27T01:55:35.000Z	0xc9710ceb4bf40e8abcdd5bc27cd2be77504732750ddbd479f07e04b6759457a8
0x82c47b8b3f260fbc993736141a91e6f3a76760e1	0x014e0b494f846cbf535fac26660a6e8cc1390657	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	206	788133597886225049	1270391995684387573	16921755	2023-03-27T22:41:59.000Z	0x6c754bedaa3e9559c6bff692c426ef9a91673d5847d5203c0bea66e1b1f9ec62
0xcd49eb910256a606c4b21a37e484f3aa7e49ec7c	0x01ec00966c5a7dbb91a4053e79fcd298e98a4cef	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	261	9215848071838623	1064126094438552680	16921608	2023-03-27T22:12:23.000Z	0xa4996d5be4d6efbe40c78826248782664f56c3f879fc748064667748490976f7

Example Query

Query with partition filter

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

Pair_burn_function

Liquidity removal transactions from Uniswap V2 pools on Ethereum, capturing burn function calls that return token amounts (amount0/amount1) to liquidity providers. Used for analyzing LP withdrawal patterns, pool liquidity changes, and calculating effective withdrawal prices.

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`	`NUMERIC`	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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`out_amount0`	`STRING`	Amount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
`out_amount1`	`STRING`	Amount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

gas	in_to	status	gas_used	signature	to_address	out_amount0	out_amount1	block_number	from_address	trace_address	block_timestamp	transaction_hash
151617	0xbaa56be07be167d0efaffdefd08689b77c7524fe	true	95232	0x89afcb44	0x4b8efc2082c223de65ad9c080997e411f6d2177b	88481941363561464	1073892879239649644	17603331	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2	2023-07-02T02:23:11.000Z	0xa2941870b1aa289737b2594e2e4725776728c1361b8d6527ba0663884afb6eab
149564	0xaa611e5c639045e3859b1cd8e65b0365002e35c5	true	103939	0x89afcb44	0x18f772b59f90750a42ac690a951b4a1989ab91a4	1138461812222251999	702972886932448956	17604864	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2	2023-07-02T07:32:23.000Z	0x8f56099a67118c50576d91eeab5588c9c8e8a065634e38833076e7c36d5ac47d
149568	0x431286906eba15125d4ed1441429fd5e83fed8db	true	103939	0x89afcb44	0xbc31f77859128a105b310e60175b6dcfffa45332	724969496138504614	1103818286132811265	17603060	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	2	2023-07-02T01:28:35.000Z	0x6dd5b64b608849efc50b2a1ded286f155f985db75f8621b4fd06c9f3fa2a9466

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.Pair_burn_function`
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
0x004375dff511095cc5a197a54140a24efef3a416	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	171	8097594	3994973885	13812080	2021-12-15T21:10:51.000Z	0xb078dbfb3a459641eab29407f62d12d283b3317ef296b854a82db370da225da7
0x00c599831135e255cbbb4625483f22e8db7ae47d	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	308	43629132687362306	250000000000000000	13810927	2021-12-15T16:57:42.000Z	0x89e010c4804eff7d88e19a1e001cdb111b003c72feae41f2730bbc1eede3cef5
0x00e8e12e6391b123005b104909e46086c2f1fccb	false	0x7a250d5630b4cf539739df2c5dacb4c659f2488d	235	1500000000000000000	500000000000000000000000000000	13811070	2021-12-15T17:28:13.000Z	0x8c23fa9a932aaa0ad9b5efaee8e8ec26a46e2ac0f1863e788e393c2748d07ded

Example Query

Query with partition filter

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

Pair_mint_function

Liquidity provision events on Uniswap V2 Ethereum pairs, recording mint function calls that issue LP (liquidity provider) tokens when users add tokens to pools. Used for analyzing liquidity additions, LP token issuance patterns, and provider behavior 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.
`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`	`NUMERIC`	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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`out_liquidity`	`STRING`	Quantity of Uniswap V2 LP (liquidity provider) tokens minted and returned to the liquidity provider. Represented as an integer string in the smallest unit of the LP token.

Sample Data

gas	in_to	status	gas_used	signature	to_address	block_number	from_address	out_liquidity	trace_address	block_timestamp	transaction_hash
92030	0x11e4857bb9993a50c685a79afad4e6f65d518dda	true	74902	0x6a627842	0xae461ca67b15dc8dc81ce7615e0320da1a9ab8d5	10079861	0xf164fc0ec4e93095b804a4795bbe1e041497b92a	10000499024951	4	2020-05-16T22:45:13.000Z	0x80ca59896aab1e6bda7aeda2aedef27fb6bf3bffee1c7dd2518aacf21d075df4
609187	0xf097bcaa945d1d89d04a63c0b9eb8c01d68871c6	true	58618	0x6a627842	0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc	10074896	0xf164fc0ec4e93095b804a4795bbe1e041497b92a	4136098908683	1,4,0,0,5,4	2020-05-16T04:09:58.000Z	0xa45ab03b1ad389b7ab91cb4254f270d5632ff36764d7b3cb0a02a5df62e89af1
614144	0xf7562a6faf433a96a29dff2e4abcb2e27205ead1	true	55645	0x6a627842	0xa478c2975ab1ea89e8196811f51a7b7ade33eb11	10074020	0xf164fc0ec4e93095b804a4795bbe1e041497b92a	676316500031202098	1,4,0,0,5,4	2020-05-16T00:52:42.000Z	0x0bee8052a6710588cc1087035b572c129504c22ce70fdb8a621aed747a1e1e88

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.Pair_mint_function`
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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0xfd3dfb524b2da40c8a6d703c62be36b5d8540626	0xf6048f2a7e1c44012265fab271c8eb89bb74bd4e	false	0xfd3dfb524b2da40c8a6d703c62be36b5d8540626	127	12801208	690577977004532634	74824152949845524308	2021-07-10T18:16:32.000Z	0xa34ddfff375f23b10dede9706913d2b0268b8a427ecfba8d23ecb3d61a0deca6
0x0000000089341e263b85d84a0eea39f47c37a9d2	0x24b24af104c961da1ba5bccce4410d49aa558477	false	0x0000000089341e263b85d84a0eea39f47c37a9d2	164	12801208	83878540888309776926	716101361005400472	2021-07-10T18:16:32.000Z	0x4ddfb98ff3638ff0fa7ff8a28f6d0608279f27be7793aae5ae40449adea39761
0x66f049111958809841bbe4b81c034da2d953aa0c	0x874376be8231dad99aabf9ef0767b3cc054c60ee	false	0x66f049111958809841bbe4b81c034da2d953aa0c	3	12801208	496392755609304802	488136088161802211	2021-07-10T18:16:32.000Z	0x2b8f1010c72e64668bcd36765e943b7183080ff48303981cab837464e8ea751f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.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
0x004375dff511095cc5a197a54140a24efef3a416	false	93	11301189	1016646842	10150072	2020-05-27T20:47:48.000Z	0x81be50cc0ae46f7863c374d9d078d448f8eb3b7bc60829737f5d14f3c17e870c
0x0078299b35a5c2511abbd2e7213791df44452b77	false	79	1052404	17285945	10150192	2020-05-27T21:12:25.000Z	0xedac4b58503840919d4302b5102fe31f66c442dc552144eb2160ac0ef148cec4
0x0078299b35a5c2511abbd2e7213791df44452b77	false	103	850399	21405109	10150192	2020-05-27T21:12:25.000Z	0x57bbd0fd3189e52d2e2959e023d06417bd07c9696c2278cbdf122df0ad7fd0be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.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
0x000f57e2c69a23dcf9640bb297825d634c612912	0x000f57e2c69a23dcf9640bb297825d634c612912	0x420c710004a1061bdf64e6252cd52f4e39ddcc23	false	47529723505509002452479	94	15371874	2022-08-19T14:43:29.000Z	0x7e1e16f973aa97eb434cc74b32c1dfa0f92ef97bf4871b6f38a1b64e485df953
0x0000000000000000000000000000000000000000	0x000f57e2c69a23dcf9640bb297825d634c612912	0x000f57e2c69a23dcf9640bb297825d634c612912	false	47529723505509002452479	95	15371874	2022-08-19T14:43:29.000Z	0x7e1e16f973aa97eb434cc74b32c1dfa0f92ef97bf4871b6f38a1b64e485df953
0x00c599831135e255cbbb4625483f22e8db7ae47d	0x00c599831135e255cbbb4625483f22e8db7ae47d	0xcec1994418ee352724537249ab49238ca647f3b3	false	87227672046066320693	534	15371802	2022-08-19T14:23:07.000Z	0x3d73ac2ca03099bb82a82563e4b41bd8506622e7676d60d405a24c73587ac888

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xca35e32e7926b96a9988f61d510e038108d8068e	0xc67753c4f3adc4432006d2a4d0eeb6df41b87fb5	false	135598676124499193913	132	12196799	2021-04-08T03:36:47.000Z	0x744ef177ab1d6dcf96a50c1d3765a76b9d4789b798a6a6ca904576b22833b3fe
0x6c3e4cb2e96b01f4b866965a91ed4437839a121a	0xad6587deb68823775798f796921fcdd746a7c839	false	1960695547736010534	173	12532186	2021-05-29T23:16:11.000Z	0xc008d8817013658497a6b3e66ccbacf8badcce1dddc932843349ab33b72dc894
0x7fba4b8dc5e7616e59622806932dbea72537a56b	0x8756b25a98d6ee5096ceff307f3f508002c11dc4	false	1430680907109410830	335	12528734	2021-05-29T10:35:11.000Z	0xf7202a95354c43e276a18ffbff871d9ec1c9094114d0e83e19bc05fcc6b29eee

Example Query

Query with partition filter

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

Univ4MerklRouterOracle_CampaignCreated_event

Campaign creation events from Uniswap V4’s Merkl Router Oracle contract on Ethereum, tracking liquidity mining incentive programs with reward amounts, token details, and duration parameters.

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_campaignId`	`STRING`	Unique identifier for the liquidity mining or incentive campaign on Uniswap v4. Hex-encoded 32-byte hash derived from campaign parameters and creation context.
`in_campaign`	`STRUCT<campaignId STRING, creator STRING, rewardToken STRING, amount STRING, campaignType STRING, startTimestamp STRING, duration STRING, campaignData STRING>`	Structured data containing the complete campaign parameters including reward amount, creator address, duration (in seconds), reward token address, campaign type identifier, start timestamp, and encoded configuration data. This nested record provides all on-chain details needed to track liquidity mining or incentive program terms.

Sample Data

address	removed	log_index	in_campaign	block_number	in_campaignId	block_timestamp	transaction_hash
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	378	{“amount”:“52804000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002648000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001800000000000000000000000000000000000000000000000000000000000000020bb1e92b6f31285d432d9f9462ebc4a003dfe26d9bc47d44543a12d457f1d22f1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0x340bf4cfc9cf477aef9a0a85643679bd8e114ef997860edc628cd73feafa9efb	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	455	{“amount”:“23468000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002648000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001800000000000000000000000000000000000000000000000000000000000000020c36db4be4a3bfded1a98dc1017b01db62f34aa02c92c6febeb277c87a6152ee8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0x56cb96608da2a3075c0944b7ef4183f73ff2cae44efac529ad2f8d51a88813bd	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d
0x45da561ab3431b8fe914c6ee2238fca0d145e0e1	false	422	{“amount”:“87168000000000000000000”,“creator”:“0x2016ef507cb1b055e21e6bf8d29b7fe51b34c6aa”,“duration”:“1209600”,“campaignId”:“0x3030303030303030303030303030303030303030303030303030303030303030”,“rewardToken”:“0x1f9840a85d5af5bf1d1762f925bdaddc4201f984”,“campaignData”:“0x0000000000000000000000000000000000000000000000000000000000000082000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002648000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001800000000000000000000000000000000000000000000000000000000000000020d10d359f50ba8d1e0b6c30974a65bf06895fba4bf2b692b2c75d987d3b6b863d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0c0c0c0”,“campaignType”:“13”,“startTimestamp”:“1744711200”}	22269169	0xa27180d8cb9c4f91b280c3dc0a843cb2cadf99548dcfe944360d9c758a426be5	2025-04-14T18:58:47.000Z	0xa650e450e8758ad880d5124bf66c35a20482fab9b3e2cd8ba4da04aca1fc5c2d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v2_ethereum.Univ4MerklRouterOracle_CampaignCreated_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_burn_function

Pair_Mint_event

Pair_mint_function

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

StakingRewards_RewardPaid_event

Univ4MerklRouterOracle_CampaignCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Factory_setFeeTo_function

​Pair_Burn_event

​Pair_burn_function

​Pair_Mint_event

​Pair_mint_function

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​StakingRewards_RewardPaid_event

​Univ4MerklRouterOracle_CampaignCreated_event

Tables

Factory_PairCreated_event

Factory_setFeeTo_function

Pair_Burn_event

Pair_burn_function

Pair_Mint_event

Pair_mint_function

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

StakingRewards_RewardPaid_event

Univ4MerklRouterOracle_CampaignCreated_event