Links
Comment on page

Sushiswap Tables

Ethereum Sushiswap tables available to query via SQL

Tables available to query

Name
Description
Top 1000 SushiSwap Pools
Pool stats (reserves, etc) for each block
Join between pools and pool_stats
SushiSwap mint events
SushiSwap burn events
SushiSwap swap events
SushiSwap sync events
SushiSwap mint events from the last 30 minutes, ~128 blocks
SushiSwap burn events from the last 30 minutes, ~128 blocks
SushiSwap swap events from the last 30 minutes, ~128 blocks
SushiSwap 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.sushiswap.pools
DESCRIBE eth.sushiswap.pool_stats
DESCRIBE eth.sushiswap.pool_stats_detailed

Improving query performance - indexed columns

Query performance can be significantly improved by adding WHERE clauses to your query on specific indexed columns.
Table Name
Indexed Columns
eth.sushiswap.pool_stats
block_number pool_address
eth.sushiswap.pool_stats_detailed
block_number pool_address
eth.sushiswap.event_[mints/burns/swaps/syncs]
block_number block_timestamp address
Last modified 4mo ago