Links
Comment on page

Wallet Balance Tables

Goerli Wallet Balance tables available to query via SQL
Links

Wallet Balances specific tables

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;

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
goerli.wallet_balances
block_number block_timestamp address
goerli.recent_wallet_balances
block_number block_timestamp address
x
Last modified 4mo ago