📂Database Overview

Nansen Query provides on-chain data for multiple blockchains via our SQL database.

The data contain raw block data, aggregated category data (dex, lending/borrowing, stablecoins, etc), and events from individual smart contracts. The data is hosted on Google Cloud BigQuery for easy access.

For example, users can create a table within Nansen Query that has all the deposits and withdraw events for certain smart contracts. This data can then be joined with other data (such as the number of Twitter mentions by hour) to create a comprehensive dataset for analysis.

Access

Currently, Nansen Query is hosted on Google Cloud. We're actively considering supporting new data vendors. Please provide feedback to us here on what database provider or technology you're using and we'll evaluate it promptly.

Access to Nansen Query via Good Cloud requires a Google Cloud account. After that account is granted access, the data be accessed via the BigQuery console, the BigQuery CLI, or the BigQuery API.

• For more information about using the console, refer to Google's guide here: https://cloud.google.com/bigquery/docs/bigquery-web-ui

• For information about using the BigQuery API, refer to Google documentation here: https://cloud.google.com/bigquery/docs/reference/rest

• For how to access BigQuery from the command line from Python, see Google's documentation here: https://cloud.google.com/bigquery/docs/bq-command-line-tool