Get address ETH balance

This tutorial reads the ETH balance of Ethereum mainnet address 0xd8da6bf26964af9d7eed9e03e53415d37aa96045, then uses the ETH price in price.price.eth to calculate its USD value.

Before you begin

Sign in to the Chaintable console. If you don’t have a Space yet, click New Space on the Spaces page, enter an Id, and click Create space.

New Space dialog with the Id field and Create space button

Open your new or existing Space. This tutorial uses demo; replace it with your Space ID.

1. Create a Function

In Functions, click + in the upper right, enter wallet_eth_value, and click Save and open. Replace the default code with:

def _(address):
    from blockdb import TimeTable
    from leafage import ChainState

    block = ChainState.get_latest_block('eth')
    chain = ChainState('eth', block['id'])
    balance_wei = chain.get_address_balance(address)
    price = TimeTable('price.price.eth').get(
        '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
    )
    balance_eth = balance_wei / 10 ** 18
    return {
        'address': address,
        'block_id': block['id'],
        'balance_wei': str(balance_wei),
        'balance_eth': balance_eth,
        'eth_price_usd': price['value'],
        'price_time': price['time_at'],
        'value_usd': balance_eth * float(price['value']),
    }

ChainState reads the wallet balance at the latest block, and TimeTable reads the ETH price. Divide the balance in wei by 10 ** 18 to get ETH.

2. Set test parameters

Click + in the parameter bar below the editor and add:

Setting	Value
Parameter name	`address`
Parameter Type	`ADDRESS`

Save the parameter and Function. Enter this value in the address input:

0xd8da6bf26964af9d7eed9e03e53415d37aa96045

Press Enter to confirm the input, then click Run.

3. View the result

Return shows the balance, block, price and price timestamp, and calculated USD value.

wallet_eth_value returns ETH balance, price, price timestamp, and USD value

Field	Meaning
`balance_wei`	Raw balance returned as a string to preserve integer precision
`balance_eth`	Balance converted to ETH
`block_id`	Block ID used for the balance query
`eth_price_usd`	ETH price in USD from the current price record
`price_time`	Timestamp of that price record
`value_usd`	ETH amount multiplied by its USD price

The balance in the screenshot is about 5.76818 ETH; your result will vary as the onchain balance changes. The USD value is estimated using the latest price record, whose timestamp is returned as price_time.

Optional: call from an external application

The saved Function ID is demo.wallet_eth_value. To call it from another application, pass the wallet address through OpenAPI. See Example request.

Overview

Quickstart

Guides

Reference