Loading

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.

Parameters

Name Type
transport TRANSPORT
address ADDRESS

Returns

Name Type
balance WEI
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.

Parameters

Name Type
transport TRANSPORT
address ADDRESS
block_number BIGINT

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.