Uniswap V3 Tables
Ethereum Uniswap V3 tables available to query via SQL
Last updated
Ethereum Uniswap V3 tables available to query via SQL
Last updated
Name | Description |
---|---|
The columns and their schema available for each table can be viewed with the describe <table>
command. For example:
Query performance can be significantly improved by adding WHERE
clauses to your query on specific indexed columns.
Table Name | Indexed Columns |
---|---|
Top 1000 Uniswap-V3 Pools
Pool stats (reserves, etc) for each block
Uniswap-V3 burn events
Uniswap-V3 mint events
Uniswap-V3 swap events
Uniswap-V3 set fee protocol events
Uniswap-V3 collect events
Uniswap-V3 collect protocol events
Uniswap-V3 flash events
Uniswap-V3 increase observation cardinality next events
Uniswap-V3 initialize events
Uniswap-V3 burn events from the last 30 minutes, ~128 blocks
Uniswap-V3 mint events from the last 30 minutes, ~128 blocks
Uniswap-V3 swap events from the last 30 minutes, ~128 blocks
Uniswap-V3 set fee protocol events from the last 30 minutes, ~128 blocks
Uniswap-V3 collect events from the last 30 minutes, ~128 blocks
Uniswap-V3 collect protocol events from the last 30 minutes, ~128 blocks
Uniswap-V3 flash events from the last 30 minutes, ~128 blocks
Uniswap-V3 increase observation cardinality next events from the last 30 minutes, ~128 blocks
Uniswap-V3 initialize events from the last 30 minutes, ~128 blocks
eth.uniswap_v3.pool_stats
block_number
pool_address
eth.uniswap_v3.event_[mints/burns/swaps/etc]
block_number
block_timestamp
address