Uniswap v2
The Uniswap v2 LP events table contains swap, sync, mint and burn events of liquidity for projects utilizing Uniswap v2 protocol.
Column Names
| Column Name | Description |
|---|---|
event | Liquidity pool event: mint, burn, swap, sync |
project | Name of the project. |
liquidity_pool_address | Address of the liquidity pool. |
liquidity_pool_factory_address | Address of the liquidity pool factory. |
sender_address | Address of the sender of the LP event, which can be the Router. |
to_address | Address of the recipient of the LP event. |
token0_address | Address of token0 in this LP. |
token0_name | Name of the token0 in this LP. |
token0_symbol | Symbol of token0 in this LP. |
token1_address | Address of token1 in this LP. |
token1_name | Name of the token1 in this LP. |
token1_symbol | Symbol of token1 in this LP. |
token0_amount_raw | How much token0 was required for the minted liquidity, unormalized. |
token0_amount_raw_str | How much token0 was required for the minted liquidity, unormalized & in string. |
token0_amount | How much token0 was required for the minted liquidity, normalized. |
token0_amount_str | How much token0 was required for the minted liquidity, normalized & in string. |
token0_amount_usd | Amount of token0 in USD value. |
token1_amount_raw | How much token1 was required for the minted liquidity, unormalized. |
token1_amount_raw_str | How much token1 was required for the minted liquidity, unormalized & in string. |
token1_amount | How much token1 was required for the minted liquidity, normalized. |
token1_amount_str | How much token1 was required for the minted liquidity, normalized & in string. |
token1_amount_usd | Amount of token1 in USD value. |
usd_amount | Total sum of LP in USD value: token0_amount_usd + token1_amount_usd |
transaction_hash | Transaction hash the LP event. |
log_index | Log index of the LP event transaction. |
block_timestamp | Block timestamp of the LP event. |
block_number | Block number of the LP event. |
block_hash | Block hash of the LP event. |
unique_id | Unique ID of each event. |
| Column Name | Description | Example |
|---|---|---|
event | Liquidity pool event: mint or burn |
|
project | Name of the project. |
|
liquidity_pool_address | Address of the liquidity pool. |
|
liquidity_pool_factory_address | Address of the liquidity pool factory. |
|
sender_address | Address of the sender of the LP event, which can be the Router. |
|
to_address | Address of the recipient of the LP event. |
|
token0_address | Address of token0 in this LP. |
|
token0_name | Name of the token0 in this LP. |
|
token0_symbol | Symbol of token0 in this LP. |
|
token1_address | Address of token1 in this LP. |
|
token1_name | Name of the token1 in this LP. |
|
token1_symbol | Symbol of token1 in this LP. |
|
token0_amount_raw | How much token0 was required for the minted liquidity, unormalized. |
|
token0_amount_raw_str | How much token0 was required for the minted liquidity, unormalized & in string. |
|
token0_amount | How much token0 was required for the minted liquidity, normalized. |
|
token0_amount_str | How much token0 was required for the minted liquidity, normalized & in string. |
|
token0_amount_usd | Amount of token0 in USD value. |
|
token1_amount_raw | How much token1 was required for the minted liquidity, unormalized. |
|
token1_amount_raw_str | How much token1 was required for the minted liquidity, unormalized & in string. |
|
token1_amount | How much token1 was required for the minted liquidity, normalized. |
|
token1_amount_str | How much token1 was required for the minted liquidity, normalized & in string. |
|
token1_amount_usd | Amount of token1 in USD value. |
|
usd_amount | Total sum of LP in USD value: token0_amount_usd + token1_amount_usd |
|
transaction_hash | Transaction hash the LP event. |
|
log_index | Log index of the LP event transaction. |
|
block_timestamp | Block timestamp of the LP event. |
|
block_number | Block number of the LP event. |
|
block_hash | Block hash of the LP event. |
|
unique_id | Unique ID of each event. |
|
Last updated