🖥️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 query.nansen.ai and log in with your Nansen.ai 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

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

• 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.