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