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,026
0
本页面内容由第三方提供。除非另有说明，欧易不是所引用文章的作者，也不对此类材料主张任何版权。该内容仅供参考，并不代表欧易观点，不作为任何形式的认可，也不应被视为投资建议或购买或出售数字资产的招揽。在使用生成式人工智能提供摘要或其他信息的情况下，此类人工智能生成的内容可能不准确或不一致。请阅读链接文章，了解更多详情和信息。欧易不对第三方网站上的内容负责。包含稳定币、NFTs 等在内的数字资产涉及较高程度的风险，其价值可能会产生较大波动。请根据自身财务状况，仔细考虑交易或持有数字资产是否适合您。