⚡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 

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

Blockchain with case-sensitive addresses

Base58 addresses are case-sensitive.

Tron

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

Solana

Solana addresses are Base58 encoded.

E.g. EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v USDC token address

Bitcoin*

There are two types of address formats on Bitcoin.

• bech32 encoded address (bc1 adddress) are case-insensitive:

  • bc1p4v7njx233etkwl06y79v8tds3mxj2pa63634mrprjque7n55nf6qg45d2k

• base58 encoded address are case-sensitive:

  • 3Nr2pzPhZaBKfBbnaCjpxuuT8SUdGQYZCc

Native Token Address

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

EVM

Chains	Symbol	Native Token Address
Ethereum + EVM Roll-ups	ETH	0x0000000000000000000000000000000000000000
Polygon	MATIC	0x0000000000000000000000000000000000000000
Avalanche	AVAX	0x0000000000000000000000000000000000000000
Tron	TRX	T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb

Non-EVM Chains

Chain	Symbol	Native Token Address
Solana	SOL	So11111111111111111111111111111111111111112
Bitcoin	BTC	NULL - Null as there is only BTC transacted on the Bitcoin Network