uniswap_v1_ethereum

Tables

Exchange_AddLiquidity_event

Liquidity addition events from Uniswap V1 exchanges on Ethereum, recording ETH and token amounts deposited by liquidity providers. Used for analyzing liquidity provision patterns, pool growth, and market maker participation across individual token 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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_eth_amount`	`STRING`	Amount of ETH (in wei) deposited by the liquidity provider during this add liquidity event. Values are string-encoded integers representing the smallest ETH unit (1 ETH = 10^18 wei).
`in_token_amount`	`STRING`	Amount of liquidity pool tokens involved in the operation. String-encoded integer in smallest token denomination (wei).

Sample Data

address	removed	log_index	in_provider	block_number	in_eth_amount	block_timestamp	in_token_amount	transaction_hash
0x09cabec1ead1c0ba254b09efb3ee13841712be14	false	183	0x6fd5b7668e0850f2f6c734c9a59c3fabb06a039c	8725650	250000000000000000	2019-10-12T08:28:17.000Z	45564078965114143536	0xf640b1ae02b5f8cab44166a63eb53d5e4ed7856d1859f84f4061bd670de5362b
0x09cabec1ead1c0ba254b09efb3ee13841712be14	false	194	0xb6c9e6a2415ab8d26335498beac8eebed4bb2259	8728146	384848681183503810	2019-10-12T17:48:41.000Z	69999999999999998611	0x734eb62de9099f0977863004653d4c3f922c1b99527209e9205b1a8cb6b5ea44
0x09cabec1ead1c0ba254b09efb3ee13841712be14	false	130	0x3750f08dca108db0e9a65a1040500fc5d8dacd5c	8728607	560660738094242700	2019-10-12T19:36:56.000Z	100090479968250020827	0x101e9d2b0a00680535442c623093a62acab1cabef3d5bc1a3e32708d4ab85e76

Example Query

Query with partition filter

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

Exchange_EthPurchase_event

Token-to-ETH swap events from Uniswap V1 exchange contracts on Ethereum. Records purchases of ETH by selling ERC-20 tokens, including amounts exchanged, buyer addresses, and exchange contract identifiers for analyzing V1 liquidity pool trading activity.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens_sold`	`STRING`	Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token.
`in_eth_bought`	`STRING`	Amount of ETH purchased by the buyer in the swap, denominated in wei (10^-18 ETH). This field represents the ETH output when a user sells tokens for ETH on a Uniswap V1 pool.

Sample Data

address	removed	in_buyer	log_index	block_number	in_eth_bought	in_tokens_sold	block_timestamp	transaction_hash
0x122327fd43b2c66dd9e4b6c91c8f071e217558ef	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	105	15869981	11493991891198283	105927103	2022-10-31T18:58:35.000Z	0x85ecfdb5c07fb7560e94c7df6b65e36cfed445a27b86b9a2428ad47b69a5e630
0x1c6c712b1f4a7c263b1dbd8f97fb447c945d3b9a	false	0x24902aa0cf0000a08c0ea0b003b0c0bf600000e0	88	15864970	52932855400548845	67791310586	2022-10-31T02:11:23.000Z	0xdd7ef5938f15f1435c4f93fa3048b4ff1e35308749f24954f83602d9271c3004
0x22d8432cc7aa4f8712a655fc4cdfb1baec29fca9	false	0x00a25c455636cc01bffcb717db900a6d4c767a8a	1	15870457	19196063497755741384	1000000000000000000	2022-10-31T20:34:11.000Z	0xafb7d1bfdf12fd93e468af794910bee69b20e04d778361b43f793514bb8a7140

Example Query

Query with partition filter

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

Exchange_RemoveLiquidity_event

Liquidity removal events from Uniswap V1 exchange contracts on Ethereum, recording ETH and token amounts withdrawn by liquidity providers. Used for analyzing liquidity provider behavior and pool activity across different token 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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_eth_amount`	`STRING`	Amount of ETH withdrawn from the liquidity pool, denominated in wei (10^-18 ETH). Value is stored as a string to preserve precision for large integers.
`in_token_amount`	`STRING`	Amount of liquidity pool tokens involved in the operation. String-encoded integer in smallest token denomination (wei).

Sample Data

address	removed	log_index	in_provider	block_number	in_eth_amount	block_timestamp	in_token_amount	transaction_hash
0x6c3942b383bc3d0efd3f36efa1cbe7c8e12c8a2b	false	207	0xd0c838486120cda746ca514f76c70938bf708b90	17045463	648648464592031792	2023-04-14T12:38:59.000Z	1258851482348788258652	0x5c476f8dc983e2519a416f828fde3e7d13d99569a1c5c62d60516f5e77d900dc
0x2a1530c4c41db0b0b2bb646cb5eb1a67b7158667	false	99	0x1001ed634ff8b495479783a0620fdd71a6151b6c	10600774	7287192690058474	2020-08-05T16:24:11.000Z	2852412209386171218	0x7a2b402f5b5d958aa92c9072ffa48d0e3663af2dd03b828dec301a50f49dc28b
0x2c4bd064b998838076fa341a83d007fc2fa50957	false	234	0x11b1785d9ac81480c03210e89f1508c8c115888e	10600430	455982242805738505	2020-08-05T15:08:51.000Z	303081431428459434	0xab9dca9924bfd9dfb51a29c4add45147744b44a9e79c314bf47b2a1765e3820f

Example Query

Query with partition filter

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

Exchange_TokenPurchase_event

Token purchase events from Uniswap V1 exchanges on Ethereum, recording ETH-to-token swaps with buyer address, amounts sold and bought, and exchange contract address. Useful for analyzing trading volumes, price discovery, and liquidity utilization across individual V1 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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_eth_sold`	`STRING`	Amount of ETH sold by the buyer in the token purchase transaction, denominated in wei (1e18 wei = 1 ETH). Values range from small amounts like 0.03 ETH to larger swaps exceeding 0.2 ETH.
`in_tokens_bought`	`STRING`	Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token.

Sample Data

address	removed	in_buyer	log_index	in_eth_sold	block_number	block_timestamp	in_tokens_bought	transaction_hash
0x2a1530c4c41db0b0b2bb646cb5eb1a67b7158667	false	0x0000000000000eb4ec62758aae93400b3e5f7f18	418	300000000000000000	12760543	2021-07-04T10:33:59.000Z	696010428053511205137	0x5f574ad8c8d9e5d7abee1b8f77fe3a44619489ef5b33417fa86c747c537865f9
0x2a1530c4c41db0b0b2bb646cb5eb1a67b7158667	false	0x0000000000000eb4ec62758aae93400b3e5f7f18	80	30000000000000000	12760320	2021-07-04T09:42:47.000Z	69487213881756639953	0x03e919e22b5ff1bf895818b00ea23b3ad2e9b1084c0565f24b64708677b33d8d
0x2a1530c4c41db0b0b2bb646cb5eb1a67b7158667	false	0x0000000000000eb4ec62758aae93400b3e5f7f18	179	40000000000000000	12760340	2021-07-04T09:45:51.000Z	92606171088167719919	0x54d4398e8a951638855cfdc0d3f756ff47b65e16593b4e02ea1836dfea97306b

Example Query

Query with partition filter

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

Exchange_Transfer_event

ERC-20 liquidity token transfer events from Uniswap V1 exchange contracts on Ethereum. Tracks minting (to zero address), burning (from zero address), and user transfers of pool shares for analyzing liquidity provision activity.

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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

in__to	address	removed	in__from	in__value	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x9bf7805f5deb58dbb881e05b1af09819f8e90eaa	false	0xbc23e50c2287f481288f29fecd5ca6ff00c72083	603026397705998504	41	10665232	2020-08-15T14:35:32.000Z	0xfc02fc1ea1a41e366a752943a19ced680771b2e968f2c8b4144123a18a737c6f
0x7c4401ae98f12ef6de39ae24cf9fc51f80eba16b	0x0b5ce6f7cbe0627aa8ad2e7e69ed554c0fe79162	false	0xb2e19dd996848818d972dd3a60a1b7faffb82330	700000000000000000	196	10664885	2020-08-15T13:23:36.000Z	0xdc34545b963f6d7710029152e4450688e62932af2963dd1656c7b752d90579ef
0x473d13919ebd47e73be21b0a3b4982ce09961f78	0x700e7869fa8ffd3117200e248979fef2b78f4a1c	false	0xe653659b4eecfe41b5afebbb2e55f3bd82032b37	125460000000000000	223	10663902	2020-08-15T09:38:28.000Z	0x32d9253d82e7fd2a247c3d0c8548c0f34ffdcec669a9fd02345a70aed1d915fe

Example Query

Query with partition filter

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

Factory_NewExchange_event

Event logs of new exchange pair deployments from Uniswap V1 factory contract on Ethereum, recording token addresses and their corresponding exchange contract addresses. Used for tracking liquidity pool creation history and analyzing protocol growth during the V1 era (2018-2019).

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_exchange`	`STRING`	Contract address of the newly created Uniswap V1 exchange pair deployed by the factory. This address represents the exchange contract that facilitates swaps between ETH and the corresponding `in_token`.

Sample Data

address	removed	in_token	log_index	in_exchange	block_number	block_timestamp	transaction_hash
0xc0a47dfe034b400b47bdad5fecda2621de6c4d95	false	0x43e5f59247b235449e16ec84c46ba43991ef6093	88	0xe316a7fe8bf258e48040e55ab7b49950e123e8e7	8488604	2019-09-05T06:59:58.000Z	0xa5a56fbbaf56e840d130714f2421b28ef41b55f9e3f9be2c826832bd37ad492e
0xc0a47dfe034b400b47bdad5fecda2621de6c4d95	false	0x970b9bb2c0444f5e81e9d0efb84c8ccdcdcaf84d	115	0xf9a204774ac595216c3c4e4249b7624e34ee52d5	8488465	2019-09-05T06:31:44.000Z	0x681c2fa12e3f369d698f5ebbee186b2352d21ef92a1702b604768addbd306f8a
0xc0a47dfe034b400b47bdad5fecda2621de6c4d95	false	0x89d3563724c6f0c1a18ddf6427ec43a35ed22e3f	144	0x3a127c50dc472abc627a3ca59ee8cdc4596e6465	8491175	2019-09-05T16:39:41.000Z	0x47bb36af094808187bf03ee3829bbcdc71f952616891297202f0b31db2ce0807

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Exchange_AddLiquidity_event

Exchange_EthPurchase_event

Exchange_RemoveLiquidity_event

Exchange_TokenPurchase_event

Exchange_Transfer_event

Factory_NewExchange_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Exchange_AddLiquidity_event

​Exchange_EthPurchase_event

​Exchange_RemoveLiquidity_event

​Exchange_TokenPurchase_event

​Exchange_Transfer_event

​Factory_NewExchange_event

Tables

Exchange_AddLiquidity_event

Exchange_EthPurchase_event

Exchange_RemoveLiquidity_event

Exchange_TokenPurchase_event

Exchange_Transfer_event

Factory_NewExchange_event