Comment on page
Wallet Balance Tables
Goerli Wallet Balance tables available to query via SQL
Links
Table Name | Description |
---|---|
A block-level view of all changes to any account's Ether balance | |
goerli.recent_wallet_balances | Balances changed in 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:/* Show the columns available */
DESCRIBE goerli.wallet_balances;
DESCRIBE goerli.recent_wallet_balances;
Query performance can be significantly improved by adding
WHERE
clauses to your query on specific indexed columns.Table Name | Indexed Columns |
---|---|
goerli.wallet_balances | block_number block_timestamp address |
goerli.recent_wallet_balances | block_number block_timestamp address |
x
Last modified 4mo ago