As a blockchain compatible with the Ethereum Virtual Machine (EVM) standard, the Polygon tables are very similar to the Ethereum tables in structure.
Block headers from the last 30 minutes, ~900 blocks
Block transactions from the last 30 minutes, ~900 blocks
Transaction event logs
Transaction event logs from the last 30 minutes, ~900 blocks
A listing of all contracts
All call frames executed during a transaction, also known as internal transactions
The table list is also available as a SQL query using
show tables. For example:
SHOW TABLES IN polygon
The columns and their schema available for each table can be viewed with the
describe <table>command. For example:
/* Show the columns available */
Query performance can be significantly improved by adding
WHEREclauses to your query on specific indexed columns.