sharing some of my learnings from using Dune Analytics 👨💻
i just built one of my first SQL queries on Dune to track the daily transfer volume of Chainlink ( $LINK ) on Arbitrum network
after writing the query and running it, i visualized the data using a bar chart 🧵
the chart shows that the ATH (all-time high) transfer volume happened on February 19, 2024, hitting around $248M in daily volume
if you’d like to explore my query yourself, you can check it out here:
you can click “Fork” to copy my code
... then just replace the token or blockchain name to any crypto asset you want to analyze!
while working on this, i also learned about the difference between these two SQL operators:
UNION and UNION ALL
both are used to combine results from multiple SELECT queries, but they behave differently!
--
1/
UNION combines multiple query results and removes duplicate rows automatically (like SELECT DISTINCT)
it’s useful when you want unique results only
here’s an example using UNION:
2/
UNION ALL also combines query results... but it keeps all duplicates!
ideally, it's best to use it when you need every row, not just unique ones
here’s an example using UNION ALL:
2,010
0
本頁面內容由第三方提供。除非另有說明，OKX 不是所引用文章的作者，也不對此類材料主張任何版權。該內容僅供參考，並不代表 OKX 觀點，不作為任何形式的認可，也不應被視為投資建議或購買或出售數字資產的招攬。在使用生成式人工智能提供摘要或其他信息的情況下，此類人工智能生成的內容可能不準確或不一致。請閱讀鏈接文章，瞭解更多詳情和信息。OKX 不對第三方網站上的內容負責。包含穩定幣、NFTs 等在內的數字資產涉及較高程度的風險，其價值可能會產生較大波動。請根據自身財務狀況，仔細考慮交易或持有數字資產是否適合您。