get_balance
Table function
Queries eth_getBalance to return the Wei-denominated account balance via the configured transport.
get_balance(TRANSPORT, ADDRESS)
Returns the latest account balance without requiring an explicit block tag.
1
SELECT balance
2
FROM get_balance(
3
$transport, -- transport
4
'0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045'::address -- address
5
);
Notebook ready in readonly mode.
get_balance(TRANSPORT, ADDRESS, BIGINT)
Returns the Wei balance at an explicit block height for reproducible historical state queries.
Result columns
| Name | Type |
|---|---|
| balance | WEI |
1
SELECT balance
2
FROM get_balance(
3
$transport, -- transport
4
'0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045'::address, -- address
5
4200000 -- block_number
6
);
Notebook ready in readonly mode.