📂Getting Started: Database

Currently, the easiest way to use Nansen Query via a commercial database is via Google BigQuery. We're in the process of evaluating additional cloud vendors to facilitate additional access.

Google BigQuery Setup

Before you can access Nansen Query via BigQuery, you will have to take the following steps in order to setup BigQuery. All the information can be found on Google BigQuery Guide.

    SUM(CAST(balance / 1e18 AS FLOAT64)) AS eth_balance,
FROM `nansen-query.raw_ethereum.balances`
GROUP BY address
ORDER BY eth_balance DESC

Last updated