Uniswap V3 Tables
Name | Description |
|---|---|
eth.uniswap_v3.pools | Top 1000 Uniswap-V3 Pools |
eth.uniswap_v3.pool_stats | Pool stats (reserves, etc) for each block |
eth.uniswap_v3.event_burns | Uniswap-V3 burn events |
eth.uniswap_v3.event_mints | Uniswap-V3 mint events |
eth.uniswap_v3.event_swaps | Uniswap-V3 swap events |
eth.uniswap_v3.event_set_fee_protocols | Uniswap-V3 set fee protocol events |
eth.uniswap_v3.event_collects | Uniswap-V3 collect events |
eth.uniswap_v3.event_collect_protocols | Uniswap-V3 collect protocol events |
eth.uniswap_v3.event_flashes | Uniswap-V3 flash events |
eth.uniswap_v3.event_increase_observation_cardinality_nexts | Uniswap-V3 increase observation cardinality next events |
eth.uniswap_v3.event_initializes | Uniswap-V3 initialize events |
eth.uniswap_v3.recent_event_burns | Uniswap-V3 burn events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_mints | Uniswap-V3 mint events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_swaps | Uniswap-V3 swap events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_set_fee_protocols | Uniswap-V3 set fee protocol events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_collects | Uniswap-V3 collect events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_collect_protocols | Uniswap-V3 collect protocol events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_flashes | Uniswap-V3 flash events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_increase_observation_cardinality_nexts | Uniswap-V3 increase observation cardinality next events from the last 30 minutes, ~128 blocks |
eth.uniswap_v3.recent_event_initializes | Uniswap-V3 initialize events from the last 30 minutes, ~128 blocks |
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:DESCRIBE eth.uniswap_v3.pools
DESCRIBE eth.uniswap_v3.pool_stats
DESCRIBE eth.uniswap_v3.event_mints
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
eth.uniswap_v3.pool_stats | block_number pool_address |
eth.uniswap_v3.event_[mints/burns/swaps/etc] | block_number block_timestamp address |
Last modified 2mo ago