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.
- Nansen Query Web App Home Page
- Click on the "New Query" Icon on the upper right to start writing SQL in the Web IDEWeb 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 sectionSuccessful 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 EditorNansen Query Visualization Editor
- The chart will be saved and will now appear in the Data Visualization sectionA 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 fileAdditional 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