Comment on page

Getting Started: Web App

Here we'll show you how to get started with Nansen Query in less than 5 mins. Please note that Nansen Query is a paid feature, and requires action to be taken prior to use. If you're interested in a trial, please don't hesitate to contact us.
  • Visit and log in with your account, you'll land on the home page.
    Nansen Query Web App Home Page
  • Click on the "New Query" Icon on the upper right to start writing SQL in the Web IDE
    Web App IDE
  • The IDE has three major functionalities:
    • A Schema Browser: For finding the relevant dataset to run queries against
    • The SQL Editor: To write and execute specific SQL commands
    • A Data Visualization section: To display results in tabular or graphical format
  • In the SQL Editor, type in the sample code below and click on the Execute button at the bottom of the SQL Editor. This query will return the top 50 addresses by their ETH balance on Ethereum
SUM(CAST(balance / 1e18 AS FLOAT64)) AS eth_balance,
FROM `nansen-query.raw_ethereum.balances`
GROUP BY address
ORDER BY eth_balance DESC
  • Once the query is completed, the result will appear in the Data Visualization section
    Successful Query Results
  • To create a visualization for the query results, click on the "Add Visualization" button at the top of the Data Visualization section. This will lead you to the Visualization Editor
  • Nansen Query supports multiple chart types. In this example, we will select: "Pie" as the Chart Type "address" as the X Column "eth_balance" as the Y Column A preview of the chart should appear in the editor, click "Save" to exit the Visualization Editor
    Nansen Query Visualization Editor
  • The chart will be saved and will now appear in the Data Visualization section
    A Saved Visualization
  • For each visualization (table or chart), clicking on the vertical ellipsis [⋮] icon on the lower left section will bring up additional functionalities such as adding the visualization to a Dashboard or downloading the result as a CSV, TSV, or Excel file
    Additional Functionalities For Each Chart
The above are the major functionalities of the Web Editor. For more detailed documentaiton, please visit the detailed documentation guide for each major functionality.