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:
1.8K
0
The content on this page is provided by third parties. Unless otherwise stated, OKX is not the author of the cited article(s) and does not claim any copyright in the materials. The content is provided for informational purposes only and does not represent the views of OKX. It is not intended to be an endorsement of any kind and should not be considered investment advice or a solicitation to buy or sell digital assets. To the extent generative AI is utilized to provide summaries or other information, such AI generated content may be inaccurate or inconsistent. Please read the linked article for more details and information. OKX is not responsible for content hosted on third party sites. Digital asset holdings, including stablecoins and NFTs, involve a high degree of risk and can fluctuate greatly. You should carefully consider whether trading or holding digital assets is suitable for you in light of your financial condition.