| 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 |
