AI powered copilot for crypto analyst
- 5 minsOnchain data analysis is an activity that plays an extremely important role in the decision making of any crypto investor or trader. There are many data analysis products and tools on the market today to serve a variety of needs. These tools allow onchain data to be displayed in charts and dashboards so that users can easily read and research them. They can be divided into the following two main groups:
Specialized analysis tools: These are analysis tools designed for one or more specific purposes. Typical products in this group include:
- DefiLlama: Providing comprehensive dashboards for DeFi
- Nansen:Smart Money Cash Flow Analysis Tool\
- RWA: Analytics Dashboard for Real World Assets\
- Chainplay: NFT analysis tool for GameFi\
- Arkham: Behavioral analysis tool of onchain objects and entities.
The advantages of products in this group are simplicity and ease of use. However, the disadvantage is that each tool can only meet one or a few specific needs, so users need to use many tools at the same time and also need to understand many different products to be able to use them effectively.
General analysis tools: These are data analytics products that allow users to build their own custom analytics based on the platform’s data using programming or query tools like SQL. Some notable products in this group include:
- Dune Analytics: SQL Data Analytics Platform
- Footprint Analytics: Web3 Data Analytics Platform
The advantage of products in this group is to provide a general solution for users, which can solve any problem or need. However, the disadvantage is that it is difficult to use, requiring users to have programming skills, query data with SQL…
We are researching and developing a new product that can balance the pros and cons of both of these product groups. By combining a general data platform with a specially trained AI Chatbot, we have created:
- Sonar - an AI powered copilot for crypto analysis.
Contents
I am currently consulting, designing and implementing data analysis infrastructure, Data Warehouse, Lakehouse for individuals and organizations in need. You can see and try a system I have built here. Please contact me via email: lakechain.nguyen@gmail.com. Thank you!
Overview
Sonar is a crypto Chatbot, used to answer questions about blockchain data analysis, with some form of data provided as shown below:
Sonar can answer a number of questions from simple ones such as looking up and summarizing information on a data table to complex queries that require combining multiple tables. Here are some examples from simple to complex for your reference:
Simple questions
1. Questions about price
How much is btc?
What is the price of eth?
Price of eth in btc
Top 10 coins with the highest percentage increase yesterday
2. Questions about trading volume
What is the btc trading volume today?
Top 10 coins with the largest total trading volume today
Max price and total volume of bnb by hour in the last 48 hours
3. Questions about balances
link balance of wallet 0x8652fb672253607c0061677bdcafb77a324de081
top 10 biggest holders of link
4. Questions about token transfer
Top 10 wallets that received the most btc in the last 48 hours
5. Questions about Centralized Exchange (CEX)
List of 10 wallets of okx exchange
List of 10 deposit wallets of binance exchange
Top 10 exchanges with the most wallets
Top 10 exchanges with the most deposit wallets
6. Questions about Decentralized Exchange (DEX)
Top 10 biggest btc trades on dex today
Complex questions
Complex questions are questions that require combining multiple pieces of data together. Because it has not been trained, Sonar will not be able to answer or will answer incorrectly. At this point, you will need to add definitions and hints to help Sonar understand what needs to be done. For example:
Top 10 wallets that bought the most btc on dex today.
In the data that Sonar knows, there is no data that shows information about the wallet that purchased the token on the DEX, so for Sonar to answer this question, we will need to add the following definition and instructions:
Definition: Wallets that buy tokens on DEX are wallets that receive tokens in token purchases on DEX. Request: Get the top 10 wallets that bought the most btc on DEX today. Hint: Get the btc purchases on DEX today and join it with the BTC transfer table today according to transaction hash. Then group by the wallet that receives btc, then calculate the total btc received by each wallet and return the list of receiving wallets in descending order of btc
You can continue asking about other tokens’ DEX wallets in this conversation to take advantage of the established context.
Some other complex questions that I have trained Sonar to answer directly without further guidance:
Top 10 wallets selling the most btc on dex today
Top 10 wallets with the most BTC deposits on binance today
Top 10 wallets withdraw the most eth from coinbase today.
Lake Nguyen
Founder of Chainslake