⚡Quick Start

Some things to note before querying our enriched data on Snowflake.

Tldr:

  • SQL: Our batch data on uses Snowflake SQL.

  • Timestamps: All timestamps are in Coordinated Universal Time (UTC).

  • Prices: All prices-related data are in USD denomination, unless otherwise stated

  • Address Casing: All EVM address are in lowercasing.

  • Native token: Native (gas tokens) address uses burn address. E.g. for Ethereum:0x0000000000000000000000000000000000000000

SQL Flavor

Our enriched batch data uses Snowflake SQL https://docs.snowflake.com/en/sql-reference-commands

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. EVM and HEX equivalent address will be specified with a their respective suffix.

  • E.g. TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8 USDC token address

Native Token Address

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

ChainsSymbolNative Token Address

Ethereum + EVM Roll-ups

ETH

0x0000000000000000000000000000000000000000

Polygon

MATIC

0x0000000000000000000000000000000000000000

Avalanche

AVAX

0x0000000000000000000000000000000000000000

Tron

TRX

T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb

Last updated