Sushiswap Tables

Ethereum Sushiswap tables available to query via SQL

Tables available to query

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