Comment on page
Sushiswap Tables
Ethereum Sushiswap tables available to query via SQL
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
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