Get events emitted by Uniswap V3 protocols.
_str
are in string format and will retain precision
unique_id
Column Name | Description | Example |
---|---|---|
event | Event log name. Note that flash event is spearated into flash and flash_paid | swap |
project | Name of the project. | uniswap |
protocol | DEX protocol or project contract which executed the aggregator trade. | uniswap_v3 |
factory_address | The factory address that deployed the liquidity pool. | 0x1f98431c8ad98523631ae4a59f267346ea31f984 |
liquidity_pool_address | The liquidity pool address which emitted the event. | 0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640 |
owner_address | Owner address. | |
sender_address | Address of the sender of the event log, which can be the Router. | 0x03f911aedc25c770e701b8f563e8102cfacd62c0 |
recipient_address | Address of the recipient of the event log, which can be the Router. | 0xf3de3c0d654fda23dad170f0f320a92172509127 |
token0_address | Token0 contract address. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
token0_name | Token0 name. | USD Coin |
token0_symbol | Token0 symbol. | USDC |
token0_decimals | Token0 decimals. | 6 |
token0_amount_raw_str | Token0 amount unnormalized, in string format for precision. | 5036814217 |
token0_amount_raw | Token0 amount unnormalized. | 5036814217 |
token0_amount_str | Token0 amount normalized, in string format for precision. | 5036.814217 |
token0_amount | Token0 amount normalized. | 5036.814217 |
token0_amount_usd | Token0 usd amount. | 5039.836306 |
token0_price_usd | Token0 hourly USD price at the time of the event. | 1.0006 |
token1_address | Token1 contract address. | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 |
token1_name | Token1 name. | Wrapped Ether |
token1_symbol | Token1 symbol. | WETH |
token1_decimals | Token1 decimals. | 18 |
token1_amount_raw_str | Token1 amount unnormalized, in string format for precision. | -1.46499E+18 |
token1_amount_raw | Token1 amount unnormalized. | -1.46E+18 |
token1_amount_str | Token1 amount normalized, in string format for precision. | -1.46498585 |
token1_amount | Token1 amount normalized. | -1.46498585 |
token1_amount_usd | Token1 usd amount. | 5043.667935 |
token1_price_usd | Token1 hourly USD price at the time of the event. | 3442.81 |
usd_amount | USD value of the event. | 5039.836306 |
liquidity | Liquidity field | 4628976692693695648 |
fee | Fee denomination of the pool address. | 500 |
tick_spacing | Tick spacing of the pool address. | 10 |
sqrt_price_x96 | Square root 96 price. | 1351521332041867599613703477231485 |
tick | Price tick. | 194897 |
tick_lower | The lower tick of the position. | |
tick_upper | The upper tick of the position. | |
price_lower_0_1 | Lower bound price of token0 per token1. | |
price_upper_0_1 | Upper bound price of token0 per token1. The tick_lower is used to calculate the price_upper_0_1, where price_upper_0_1 = pow(1.0001, -1 * (tick_lower)) * pow(10,(token1_decimals - token0_decimals)) | |
price_lower_1_0 | Lower bound price of token1 per token0. Where price_lower_1_0 = pow(1.0001, (tick_lower)) * pow(10,(token0_decimals - token1_decimals)) | |
price_upper_1_0 | Upper bound price of token1 per token0. | |
transaction_from_address | The address of the sending party of this transaction. | 0x91e0859484e4e6e9ff7afa6c6db0a636f83924e1 |
transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0xf3de3c0d654fda23dad170f0f320a92172509127 |
transaction_hash | Transaction hash of this trade. | 0xba4e6ad60d4047b64483edb7a60da522ab77c926e42ca3f7faa4acedbf90d438 |
transaction_index | Transaction index of this trade in the block. | 3 |
transaction_fees | Fees paid at the transaction level. | 0.01013343787 |
transaction_fees_usd | Fees paid in USD. | 34.88750123 |
fee_details | Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction. | { "gas": 519926, "gas\_price": 27512591954, "max\_fee\_per\_gas": 38787955200, "max\_priority\_fee\_per\_gas": 13988113, "receipt\_effective\_gas\_price": 27512591954, "receipt\_gas\_used": 368320 } |
selector | Call data selector at the transaction level. | 0xb80c2f09 |
log_index | Log index of this trade. | 34 |
block_timestamp | Block timestamp of this trade. | 2024-03-17 07:17:11 |
block_number | Block number of this trade. | 19453026 |
block_hash | Block hash of this trade. | 0xde8f8cad5c9d3671bcd4f5c8015ccfeb1773840ad80516768ab165e366a28404 |
unique_id | Unique ID of each trade. | event-swap_txn-0xba4e6ad60d4047b64483edb7a60da522ab77c926e42ca3f7faa4acedbf90d438_log_index-34 |
_created_at | Timestamp of the entry creation. | 2024-05-28 05:45:36 |
_updated_at | Timestamp of the entry update. | 2024-05-28 05:45:36 |
_changed_since_full_refresh | Boolean indicator on whether this table was full-refreshed. | TRUE |