Dune Dashboard
Last updated
Was this helpful?
Last updated
Was this helpful?
Dune Analytics is a powerful blockchain data platform that allows users to access and analyze on-chain activity using pre-built dashboards and SQL queries. Dune offers a way to track top performing wallets, analyze trading strategies, and evaluate market conditions without manually sifting through raw blockchain data.
Many useful queries already exist in public Dune dashboards, making it easy for traders to leverage valuable insights without writing SQL themselves.
This example query analyzes a given token contract address and returns an overview of the trading activity related to that token. The key information provided includes:
Total SOL Spent & Earned: Displays the total SOL used for purchasing the token versus the SOL received from sales, offering insight into liquidity flow and trading volume.
Net Profit or Loss: Summarizes the overall profitability of wallets that have traded the token.
ROI Percentage: Presents the return on investment, helping to identify wallets that have performed well.
Each wallet listed in this query includes a link that leads to a more detailed analysis in the Wallet Analyzer and Solscan.
After using the Token Analyzer to identify wallets of interest, we can use queries that offer a detailed look at the trading performance of individual wallets.
Although the analysis takes approximately 2-4 minutes to complete, it provides comprehensive details that are crucial for making informed copy-trading decisions.
Token Metrics: Information such as the token_symbol, current_token_balance, and burned_tokens helps understand the token balance and dynamics within the wallet.
Profitability Indicators: Metrics like real_pnl (Realized Profit and Loss), realized_unrealized_combined, roi (Return on Investment), and unrealized_profit provide a complete picture of the wallet’s profitability.
Trading Activity: The query tracks the volume of trades with data on total_buys & total_sells, triggered_buys & triggered_sells, and total_tokens_bought & total_tokens_sold. A comparison metric (t_sold > t_bought) is also included to highlight potential selling pressure.
Trade Timing: Key timestamps such as first_swap, first_sell, and last_swap along with the buy_sell_time_difference help analyze the trading pattern and activity of the wallet.
Provides a breakdown of ROI across various ranges:
(-100%) - (-50%)
(-50%) - 0%
0% - 50%
50% - 100%
100% - 150%
150% - 200%
200% - 300%
300% - 500%
500% - 2000%
2000%
This detailed analysis helps to understand the complete trading history and performance profile of individual wallets. Sometimes, a wallet with a high ROI and win rate may seem ideal for copy-trading at first glance, however a deeper analysis might reveal trading patterns or irregularities that make it less favorable for copying. The insights provided by the Wallet Analyzer help you to distinguish between superficially attractive metrics and truly sustainable, strategic performance.
Initial Screening with the Token Analyzer: Use aggregated metrics such as total SOL spent/earned, net profit or loss, and ROI to quickly identify wallets that are actively trading a specific token. This step helps you shortlist potential traders based on their overall token performance.
Detailed Insight with the Wallet Analyzer: Once promising wallets are identified, dive deeper with the Wallet Analyzer. By examining profitability indicators, trading activity, trade timing, and performance distribution bands, you can assess the risk and consistency of a wallet’s trading behavior. This detailed analysis is essential, as it may reveal that a wallet with high ROI or win rate has a trading pattern that doesn’t align with your risk tolerance or strategic objectives.
By using these two Dune Analytics queries together, users can obtain both a broad overview of token trading activity and a detailed evaluation of individual wallets. This two-step process provides the necessary insights to help inform copy-trading decisions, ensuring that you follow traders whose performance is aligned with your goals.
