Data FAQ

Frequently asked questions about our historical batch data.

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 

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.

Last updated