Do you really know how to use Dune Analytics? ｜Project introduction
Written by: 0x26
As we all know, on Ethereum, all information is public of. But it is difficult for users to find the valuable information they need. If you want to know how many users a certain project/protocol has, or what is the daily trading volume of a certain DEX, you may need to write a separate script to traverse all blocks, parse information, sort and extract data correctly. Not only does this require specialized knowledge, it is also time-consuming. Such a script might extract information for a particular project, but would require extensive modification if it were to be applied to other projects. Also, traversing all the data is a lengthy process in itself, requiring either a full node or many separate queries using external services.
At this point, you need to try Dune Analytics.
Dune Analytics is a powerful blockchain analysis platform that can be used to query, extract, and Ethereum data for visualization. It is a web-based platform that queries Ethereum data from a pre-populated database by using simple SQL queries (avoiding each script traversing the data individually, redundant transactions). Instead of writing a dedicated script, users can simply query the database and extract almost any information on the blockchain.
This article will introduce how to use, search, write basic information, and visualize it. Even if you have never used SQL before, the basic examples in the article will help you understand, and you can also write your own scripts by reading this article and related official documents. It is expected that users can create more meaningful datasets.
Weekly DEX volume Go Centralized exchange weekly trading volume
How Dune Analytics works
Dune Analytics essentially collects all unprocessed blockchain data into an SQL database, allowing all users to easily query. For example, all transfers of Ethereum can be easily queried in the database, and these data have been well sorted according to items such as sending address, receiving address, and quantity.
Ethereum's latest 5 transfers, source
This information is free, just create an account, you can use:
Data search query
Write new query requirements
Create visualizations and statistics
If users need to create privatized charts, hide watermarks and other functions, they need to pay to the Pro level, which will not be discussed here.
Start with Dune Analytics
After registration, click Browse on the home page to enter the data browsing interface.
What you see is a summary of some popular datasets from other users, including various Different items or data classifications, such as the transaction volume statistics summary of DeFi projects, GAS fees, NFT platform Rarible data summary, etc.
ETH gas fee related data, source
The chart can be enlarged, full screen, or selected at any part. Select Fork to copy the entire data set into your own workspace, where you can operate, modify, create new charts and save them. And Query allows you to see the implementation code of this part of the data set.
Median Gas Price, Last 24 hours (within 24 hours, the median gas fee)
Users can also search for the project information they need on the right, and can sort by popularity, favorites, and release date.
It can be found in time order that many new users test their own data sets on the platform.
Start to learn to write your own data set
A netizen is looking for paid data collection services on Discord
First of all, users can use Fork to copy other people’s writing A successful data set can be copied and its code modified. Perhaps with a little adjustment, you can get the code you need (Rhythm Note, Dune Analytics also provides detailed Docs documents for users to learn).
1. Click Create, select Query to create a new query page;
2. Edit related SQL code instructions.
This article introduces some related commands with high usage:
ethereum.transactions: All transfers on Ethereum.
ethereum.logs: logs when sending tokens.
erc20.ERC20_evt_Transfer: All events when sending tokens.
prices.layer1_usd: Display the usd price of the L1 layer (public chain) every minute.
Take the last 5 ETH transfers as an example:
First select ethereum.transactions to find all the data on the ETH chain, and you can see the relevant subsets, including hash, GAS fee, block height and so on. The * character represents all content in the subset, and desc represents flashbacks.
After processing the main command, we get the following complete command:
select * from ethereum."transactions" order by block_time desc limit 5
Click "Execute" to output the result.
Get the result, and then click SAVE to save, the above has completed a simple query function.
In the Query option, you can see your completed works in chronological order
Don’t forget, Dune Analytics also supports data visualization, you can integrate your own set instructions into visualization tools, and use The Dashboard is displayed.
Graph display of ETH value on the chain in the past 10 days, Source
Limitations
Although Dune is a super powerful tool, it still has some bugs and limitations. Currently, only things like on-chain transfers and migrations can be queried. The state of an address on a particular block cannot be determined. For example, if you want to know what is the balance of a specific address in a specific block, you need to create a Query that summarizes all transfers to and from that address. Answering the question of "the current total amount of Ethereum" is still a bit tricky for Dune.
Free users can only perform 3 queries at a time, if you want to update a data set with multiple charts, this limit It is necessary to pay attention.
Although the platform will automatically help debug incorrect Query instructions most of the time, sometimes Query will be suspended until timeout (up to 40 minutes). If something is taking a significant amount of time and still not responding, you may want to try saving it and reloading the page. This part of the problem will be resolved later.
Summary
Tools are only It is a tool, but the most important thing is the user behind it. As a data platform full of possibilities, Dune Analytics still has a lot to explore and discover, including various emerging DeFi projects or data, requiring users to build relevant data sets themselves. In view of the fact that 96% of the DeFi transaction volume in the third quarter of 2020 comes from ETH's situation< /a>, mainly focusing on Ethereum data, allows users to query, extract and display data simply and quickly. Dune Analytics can be said to be a super powerful research and exploration tool.
Datasets of DUNE Analytics-related platforms
Note: Rhythm previously reported that on September 23, DUNE Analytics won 200 Ten thousand US dollars in seed round financing, led by Dragonfly Capital, Multicoin Capital, Coinbase Ventures, Alameda Research, Coingecko and other institutions, and angel investors such as AAVE founder Stani Kulechov and Uniswap's Matteo Leibowitz followed up.
Reference materials:
Dune Analytics introduction tutorial (with examples)
Dune Analytics Official Website
Welcome to join the official BlockBeats community:
Telegram Subscription Group: https://t.me/theblockbeats
Telegram Discussion Group: https://t.me/BlockBeats_App
Official Twitter Account: https://twitter.com/BlockBeatsAsia
Related Articles
