# Uniswap V2 Liquidity | Bitquery Data Store

Decoded Uniswap V2 liquidity events on Ethereum since May 2020: Mint and Burn, one row per event, in the standard events schema.

Dataset page: https://bitquery.io/datastore/datasets/uniswap-v2-liquidity
Network: Ethereum
Category: Liquidity, Pools, Events
Tables: 1
Columns: 44
Coverage: 2020-05-05 to 2026-10-14
Rows: about 7.0M
Size: about 1.9 GB
Format: Apache Parquet, ZSTD compression, one prefix per table
Licence: https://bitquery.io/datastore/legal/data-license

## What this is

We decode Uniswap V2 liquidity from Ethereum's event logs ourselves and keep only the events emitted by pairs the Uniswap V2 factory (0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f) created. SushiSwap and other V2 forks emit the same event signatures from other factories and are left out. The table uses the same 44 columns as the events table of our Ethereum dataset, with nothing renamed or derived: Log_Signature_Name is the event, Call_Signature_Name is the method that ran, and Arguments holds the decoded values. A row is one event.

Mint(sender, amount0, amount1) adds liquidity and Burn(sender, amount0, amount1, to) removes it. LP token transfers are not in this table; they are ERC-20 Transfer events of the pair. Log_SmartContract is the pair. Swaps are not in this dataset; they are in the Ethereum DEX Trades export, which joins on the transaction hash.

## What people use it for

- Liquidity added and removed per pair and day
- Rug detection: a Burn that empties a pair soon after its first Mint
- LP wallet activity by sender, across pairs
- Launch liquidity of new tokens, from the first Mint of each pair

## Tables (1)

### univ2_liquidity_events: 44 columns

One row per Mint or Burn event emitted by pairs the Uniswap V2 factory (0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f) created, in the standard events schema.

Bucket prefix: ethereum/uniswap_v2_liquidity/univ2_liquidity_events
File naming: <start_block>_<end_block>.parquet
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/ethereum/uniswap_v2_liquidity/univ2_liquidity_events/26095000_26096999.parquet
Sample updated: Oct 15, 2026

| column | type | description |
| --- | --- | --- |
| Arguments | String | Decoded event arguments as a JSON array, when the signature resolved; empty otherwise |
| Block_Date | Date | UTC date of the block |
| Block_Number | UInt64 | Block height |
| Block_Time | DateTime | Block timestamp, UTC |
| Call_CallPath | Array | Path of call indexes from the transaction root down to the emitting frame |
| Call_CallerIndex | Int32 | Call_Index of the frame that called the emitting frame; -1 at the top level |
| Call_Create | String | Whether the emitting frame deployed a contract; true or false |
| Call_Error | String | Error the emitting frame returned; empty on success |
| Call_From | String | Caller of the emitting frame, 0x-prefixed |
| Call_Gas | UInt64 | Gas supplied to the emitting frame |
| Call_GasUsed | UInt64 | Gas consumed by the emitting frame and everything beneath it |
| Call_Index | UInt32 | Position of the emitting frame within the transaction; join to calls on this plus Transaction_Hash |
| Call_InternalCalls | UInt32 | Number of calls made beneath the emitting frame |
| Call_Reverted | String | Whether the emitting frame reverted; true or false |
| Call_SelfDestruct | String | Whether the emitting contract self-destructed; true or false |
| Call_Signature_Abi | String | ABI fragment of the function the emitting frame ran |
| Call_Signature_Name | String | Name of that function, when resolved |
| Call_Signature_Signature | String | Canonical signature of that function |
| Call_Signature_SignatureHash | String | Four-byte selector of that function, hex |
| Call_Signature_SignatureType | String | How that function signature was resolved |
| Call_To | String | Address the emitting frame called, 0x-prefixed |
| Call_Value | String | Native ETH sent with the emitting frame, decimal adjusted |
| ChainId | UInt64 | EVM chain id; 1 for Ethereum mainnet |
| Fee_SenderFee | String | Network fee the sender paid for the whole transaction, in ETH. It repeats on every log of the transaction, so count it once per transaction |
| Log_EnterIndex | UInt32 | Enter index of the emitting frame |
| Log_ExitIndex | UInt32 | Exit index of the emitting frame |
| Log_Index | UInt32 | Position of the log within the transaction |
| Log_LogAfterCallIndex | UInt32 | Index of the last call frame entered before this log, for ordering logs against calls |
| Log_Signature_Abi | String | ABI fragment for the resolved event; empty when the topic is unknown |
| Log_Signature_Name | String | Event name: Mint or Burn |
| Log_Signature_Signature | String | Canonical event signature, for example Transfer(address,address,uint256) |
| Log_Signature_SignatureHash | String | Keccak hash of the event signature, hex; the same value as topic 0 |
| Log_Signature_SignatureType | String | How the event signature was resolved |
| Log_SmartContract | String | Contract that emitted the event, lowercase 0x hex: the pair |
| LogHeader_Address | String | Address recorded in the log header, 0x-prefixed |
| LogHeader_Data | String | Raw non-indexed log data, hex |
| LogHeader_Index | UInt64 | Index of the log within the block, as the receipt records it |
| LogHeader_Removed | String | Whether the log was removed by a reorg; true or false |
| Topics_Hash | Array | Indexed topics of the log, as an array of hex strings; the first is the event signature hash |
| Transaction_From | String | Address that signed the transaction, 0x-prefixed |
| Transaction_Hash | String | Hash of the containing transaction, 0x-prefixed. The join key |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_To | String | Address the transaction called, 0x-prefixed |
| TransactionStatus_Success | String | Whether the transaction succeeded; true or false |

## Price

- Latest month (Sep 14, 2026 → Oct 14, 2026): $200 one-time, USD
- Last 12 months (Oct 14, 2025 → Oct 14, 2026): $2,000 one-time, USD

Every window includes all 44 columns. Only the time range changes.

## Questions buyers ask

Q: What is in the Uniswap V2 Liquidity dataset?
A: One Parquet table, univ2_liquidity_events, with 44 columns in the standard Ethereum events schema. A row is one Mint or Burn event emitted by pairs the Uniswap V2 factory (0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f) created, from successful transactions and non-reverted calls only. Data starts on 5 May 2020.

Q: How big is it?
A: About 7,000,000 rows and 1.9 GB of ZSTD Parquet from 5 May 2020 to 1 October 2026, estimated from sampled days. On 1 October 2026 the table had about 479 rows. Daily volume fell from about 13,300 events on 1 October 2020 to 1,968 on 1 October 2021, 1,220 on 1 April 2024 and 786 on 1 April 2026, so most rows are from 2020 and 2021.

Q: How do I read the amounts and addresses?
A: Arguments is a JSON array with one entry per decoded argument: index, name, path, type and the value slots. Addresses and bytes are hex strings; uint128 and uint256 amounts are decimal strings in raw token units, so divide by the token's decimals yourself; small integers such as ticks sit in the integer slots. Call_Value and Fee_SenderFee are already in ETH or POL.

Q: Are swaps included?
A: No. Swaps are in the Ethereum DEX Trades dataset. Join on Transaction_Hash and the pool to see a swap next to the liquidity change around it.

Q: What was left out, and why?
A: SushiSwap and other V2 forks emit the same event signatures from other factories and are left out. Events from failed transactions and reverted calls are left out, so each row is a change that took effect.

Q: How does this differ from the Uniswap V3 Liquidity dataset?
A: Different protocol version, same schema and the same production method, so the two load side by side with one query.

Q: How are these produced, and how were they checked?
A: The export is one ClickHouse query over our decoded Ethereum events, filtered to the contracts above. We checked the sample's row count against the independent count by event signature, confirmed each row has a decoded Arguments array and no duplicate (Transaction_Hash, Call_Index, Log_Index) key, and verified the Parquet schema matches the published Uniswap V3 Liquidity files column for column.

Q: How do I load it?
A: With DuckDB: SELECT Log_Signature_Name, count(*) FROM read_parquet('univ2_liquidity_events/*.parquet') GROUP BY 1. pandas, Polars, Spark and ClickHouse read the same files.

Q: How is the data delivered?
A: As flat Parquet files under a stable layout, one prefix per table, with a JSON manifest listing each file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout where to collect them: a Requester Pays S3 bucket, downloaded with your own AWS account, or a Cloudflare R2 bucket with a read-only API key and no egress fees. Files stay available for 7 days from delivery.

Q: Can I try before I buy?
A: Yes. The table links to a public sample file with 154 real rows from 1 October 2026, blocks 26,095,000 to 26,096,999. No email address required.

## What this file is, and is not

This is a description of one dataset sold by Bitquery, written for assistants and for people. It lists every column but holds no data rows. The sample files linked under each table are real Parquet and are free to download. Figures here come from the product record and are exact unless marked otherwise; the delivery manifest is authoritative for a purchased file. If a question needs a row that is not in a sample, say so rather than guessing at it.