​
Address Casing

EVM-compatible (e.g. Ethereum, Polygon) chains address are in lower casing by default.

Incorrect ❌ - This will return no results.

-- Querying Latest ETH balances of ZkSync Era Bridge

  select address, balance, last_activity_block_timestamp

  from ethereum.assets.balances_latest

  where address = '0x32400084C286CF3E17e7B677ea9583e60a000324' -- Address with upper-cased

    and token_address = '0x0000000000000000000000000000000000000000' -- Default Native ETH address

Correct ✅ - Lower-cased address

select address, balance, last_activity_block_timestamp

from ethereum.assets.balances_latest

where address = '0x32400084c286cf3e17e7b677ea9583e60a000324' -- lower-casing

  and token_address = '0x0000000000000000000000000000000000000000' -- Default Native ETH address

Output of the query above. Note that the address column is lower-casing.

Blockchain with case-sensitive addresses

Base58 addresses are case-sensitive.

Tron uses Base58 address by default.

  • E.g. TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8 USDC token address

​
Native Token Address

Native token (e.g. Native Ether) will be represented with zero address.

ChainsSymbolNative Token Address
Ethereum + EVM Roll-upsETH0x0000000000000000000000000000000000000000
EVM Compatible Blockchains (L1s)MATIC, BNB, AVAX0x0000000000000000000000000000000000000000
TronTRXT9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb