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.
This dashboard lets you identify top performing traders on Solana, tailored precisely through adjustable user inputs, ensuring results match your specific trading goals and risk criteria.
Customize your analysis by adjusting these inputs:
Days to Analyse: Sets the timeframe for analyzing recent trading activity.
Min Total SOL Balance: Filters wallets by their current SOL holdings.
Min/Max Total SOL Spent & Earned: Defines wallet activity by the volume of SOL they trade.
Min/Max Winrate (%): Filters wallets by their percentage of profitable trades.
Min/Max Distinct Tokens Traded: Helps you find traders active across a defined number of tokens.
Remove Investigate Wallets: When enabled, excludes wallets flagged for irregularities, improving the quality of results.
After setting inputs, the dashboard returns detailed insights including:
Wallet Days Old: Shows how old the is the wallet.
SOL Balance: Current total SOL in the wallet.
SOL Spent & Earned: Shows the total amount of SOL a wallet spent buying tokens and the total SOL earned from selling tokens.
Net Profit (PnL) & ROI: Indicates the wallet’s profit and Return on Investment.
Winrate (%): Percentage of successful trades, showcasing consistency.
Total Buys & Sells: Illustrates the trading frequency and volume.
Tokens Bought vs. Tokens Sold: Ensures transparency by checking for discrepancies that may require further investigation.
Distinct Tokens & Wins: Provides insight into trading diversity and overall success rate.
Last Swap Date: Indicates the most recent trading activity, allowing you to select actively engaged traders.
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.
Identifying Overall Top Traders with the Top Traders Dashboard:
Complementing the first two tools, the Top Traders Dashboard provides a broader perspective by highlighting wallets with consistent overall success. Key metrics include net profitability, win rates, total trading volume, and token diversity. These insights help you select traders who consistently demonstrate successful strategies and sustainable trading behaviors.
By combining these three powerful Dune Analytics dashboards, you gain a comprehensive understanding of both individual token performance and broader trader effectiveness. This complete approach ensures your copy-trading decisions align precisely with your investment goals and risk tolerance.
