Ask or search…
K

Quick Start

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

SQL Flavors

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
Solana
Bitcoin*
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 addresses are Base58 encoded.
E.g. EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v USDC token address
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
Non-EVM Chains
Chains
Symbol
Native Token Address
Ethereum + EVM Roll-ups
ETH
0x0000000000000000000000000000000000000000
Polygon
MATIC
0x0000000000000000000000000000000000000000
Avalanche
AVAX
0x0000000000000000000000000000000000000000
Tron
TRX
T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb
Chain
Symbol
Native Token Address
Solana
SOL
So11111111111111111111111111111111111111112
Bitcoin
BTC
NULL - Null as there is only BTC transacted on the Bitcoin Network
Last modified 15d ago