Comment on page
Uniswap V2 Tables
Ethereum Uniswap V2 tables available to query via SQL
Name | Description |
---|---|
Top 1000 Uniswap-V2 Pools | |
Pool stats (reserves, etc) for each block | |
Join between pools and pool_stats | |
Uniswap-V2 mint events | |
Uniswap-V2 burn events | |
Uniswap-V2 swap events | |
Uniswap-V2 sync events | |
Uniswap-V2 mint events from the last 30 minutes, ~128 blocks | |
Uniswap-V2 burn events from the last 30 minutes, ~128 blocks | |
Uniswap-V2 swap events from the last 30 minutes, ~128 blocks | |
Uniswap-V2 sync 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_v2.pools
DESCRIBE eth.uniswap_v2.pool_stats
DESCRIBE eth.uniswap_v2.pool_stats_detailed
DESCRIBE eth.uniswap_v2.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_v2.pool_stats | block_number pool_address |
eth.uniswap_v2.pool_stats_detailed | block_number pool_address |
eth.uniswap_v2.event_[mints/burns/swaps/syncs] | block_number block_timestamp address |
Last modified 4mo ago