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.
Last modified 8mo ago