In this code block we force the query to only show one of each of the three contract addresses. We do this by using the “group by 1” command, i.e., group the results by unique entries of the first column. Not all figures tie, but from this list we can see that a few addresses, NFTs purchased and total ETH spent figures do tie. This is once again a sync timing issue between Dune and real-time blockchain data and nothing to worry about. Dune Analytics is a very popular tool amongst blockchain analysts.
Dai is held in cryptocurrency wallets or within platforms, and is supported on Ethereum and other popular blockchains. Alkemi is building an on-chain liquidity network with a suite of tools and products that serve as onramps for everyone to participate in decentralized finance. For example, let’s write a query that shows the last five transactions made on-chain. Search for the transactions database, click on it, now you can see transactions database tables, and they’re block_hash, block_number, data, etc. Ethereum stores its data (transactions, address, etc.) in its blockchain. Dune Analytics translates that on-chain data inside the blocks into SQL databases so you can find any information you want using SQL codes.
Compound is an algorithmic, autonomous interest rate protocol built for developers, to unlock a universe of open financial applications. The purpose of BarnBridge is to integrate with other protocols letting hedging the yield risks on those lending and other platforms. RSS3 is an open information syndication protocol that aims to support efficient and decentralized information distribution in Web3. Access to this page has been denied because we believe you are using automation tools to browse the website.
- Nguyen Toan isn’t just an analyst, he’s also an avid STEPN user and his dashboard attempts to capture where STEPN is heading as well as whether it is sustainable or not.
- Frax is open-source, permissionless, and entirely on-chain – currently implemented on Ethereum and other chains.
- Finally, save your query and press “Add to dashboard” once more.
- Here at Tokenized, we want to help you learn as much as possible about the coming NFT revolution.
We are a decentralized exchange meaning that users swap their tokens peer-to-peer through the Ethereum smart contract infrastructure. We provide you with the best prices while allowing you to retain complete custody of your tokens throughout the entire trading process. DYdX is a decentralized trading platform that currently supports margin trading, spot trading, lending, and borrowing.
We currently offer a sector, leverage and yield-generating products via ERC20 tokens that are accessible, secure and simple to use. Fuse is a decentralized blockchain-powered platform and technology stack whose goal is to enable genuine mass adoption of crypto payments and decentralized finance . Curve is an exchange liquidity pool designed for extremely efficient stable-asset trading. Its main goal is to let users and other decentralised protocols exchange stable assets through it with low fees and low slippage. BoringDAO is a decentralized bridge that connects all blockchain assets, we offer users a safe way to maximize their utilization rate of crypto assets. You can find an endless amount of great queries and dashboards on Dune.
Getting Ready to Build Your First Query in Dune
You can get the ABI from Remix or in the artifacts directory of Hardhat. It’s also on Etherscan for contracts that have been verified on there. Tracking A place for articles on tracking with prosper202, google analytics and webmaster tools. Yield Farming Yield farming uses defi protocols to gain a return or revenue from a digital asset or position. You can archive private queries that you no longer need, to increase your existing private queries quota. Archived queries are not accessible by anyone else and you can unarchive them later on if you change your mind.
Upon clicking on any of the displayed metrics, you can view the query code written. The Blockchain Sector newsletter goes out a few times a month when there is breaking news or interesting developments to discuss. All the content I produce is free, if you’d like to help please share this content on social media. Once a contract has been verified we can access the events directly with decoded outputs. We define the event at the top of the contract and then emit it from within functions when needed, similar to Javascript events.
You can search for the name of the protocol, token, or even the username who created the dashboard. Dune Analytics was created with the express purpose of making Web 3.0 data available to all. Dune Analytics allows anyone to publish and gain access to crypto trends in real-time. It is a community-based open-source data provider, and it is freely available, so anyone can access and publish data without registering or paying. Another sifts through blockchain data produced by MakerDAO, the protocol that powers the decentralized U.S. dollar stablecoin, DAI, to trace the flow of the money.
What Is the Crypto Fear and Greed Index?
When you first open the Dune website at Dune.com, you are greeted with below window. Gankthisway is a blockchain data analyst and has chosen to only focus on the BNB Realm. STEPN Realms 1 and 2 run on top of these two blockchains and therefore it’s fairly easy for us to pull data from https://cryptolisting.org/ for STEPN. Infographic explaining how Dune Analytics gets its data.Dune Analytics gathers all of its database running dedicated nodes for various different blockchains. Founded in 2018, Dune Analytics has become one of the most popular tools used by analysts in the blockchain industry. It is possible that free plans will have limited access to the Dune API once it is released.
The data is reusable and mixed to suit any user’s needs, which is why it is sometimes referred to as the GitHub for blockchain data analytics. What makes Dune Analytics unique is that the platform doesn’t offer data sets for specific projects like other companies. Instead, Dune Analytics allows anyone to query complex data, and it offers the tools to do so. Like most crypto protocols, the source of Dune’s power is its community. Popular dashboards created by its users track anything and everything, with queries as diverse as trending yield farms on Ethereum and the non-fungible token collections bought by top OpenSea traders.
Advanced features, as well as projects requiring a large number of requests, will most likely have to purchase a paid plan. Tellor is a permissionless community of token holders, data providers, and validators working together as a decentralized oracle. ERC-20 community tokensWhen someone pays your project, they’ll receive your project’s tokens in return.
So how is Dune able to provide all this data anyway?
As mentioned, it took 3 full years for them to reach unicorn status. But that wasn’t the result of years of steady revenue building. To create a new query, you can do so by clicking on “New Query.” Note that you will need to create a free account on the Dune Analytics platform to enable new query creation. If you wish, you can create your own SQL queries on the Dune Analytics platform. To add text and images to your dashboard, press “Add text widget” in the top right of the dashboard edit screen. Finally, save your query and press “Add to dashboard” once more.
Having said that, I leave this info in your very capable hands. Alternatively, you can choose Dune Engine V2 , which works with Solana raw data, for example. Now that you know the three what is insure network basic types of dashboards, let’s look at dashboards on the individual level. Now that we’re on the subject, let’s take a look at these 3 types of dashboards, and show examples of each.
What Is Dune Analytics And How To Use It?
If you click on any of the tables, you will see a list of columns, just like in with the raw blockchain data. Dune Analytics is a free blockchain data analytics platform that can be used by anyone to determine macro trends on any of the supported blockchains. The platform also offers a paid subscription ($390 per month), which gives users the option to keep their dashboards private and enables them to run up to six queries at the same time. Next you will also notice that columns 1, 3 and 4 each have a CASE WHEN clause embedded. We then group these by the first column, thus returning minted NFTs per pooly smart contract. Within each level of nesting you are also given the option to filter for specific search results you are looking for.
But let’s face it, most of the really useful APIs require some sort of paid plan. Yearn.finance is a decentralized investment aggregator that leverages composability and uses automated strategies to earn high yield on crypto assets. To begin our decentralized borrowing journey, xDollar starts with the Polygon network and will eventually expand into other chains/protocols. XDollar is the first cross-chain decentralized lending platform on multi-chains with DAO governance component and multi-collateral vault system. In recognizing the Liquity protocol thorough designed operating mechanism, xDollar has the features and benefits consistent with the Liquity protocol.
CoinGecko provides a fundamental analysis of the crypto market. In addition to tracking price, volume and market capitalisation, CoinGecko tracks community growth, open-source code development, major events and on-chain metrics. Second, Dune uses blockchain data, which web2 companies do not. As you can probably tell, this type of data is highly and immediately actionable, thus making it extremely valuable in the right hands. Dune’s lively community includes traders, analysts, enthusiasts, and others who share their data analysis with everyone.
Fuse.io on Dune
Screenshot of the Dune Analytics STEPN Shoe Analytics Dashboard.The next Dune Analytics STEPN dashboard was created by @lightsoutjames. Nguyen Toan isn’t just an analyst, he’s also an avid STEPN user and his dashboard attempts to capture where STEPN is heading as well as whether it is sustainable or not. Here’s our list of the 6 best Dune Analytics dashboards that everyone should know right now. We had a closer look at some of the most popular Dune STEPN dashboards and have tried to separate the wheat from the chaff for you. It’s a tool that is particularly popular amongst analysts who don’t necessarily want to spend tons of money on paid software.
However, if we build it from scratch we get to learn how to be a blockchain detective and learn some SQL as well! From the abstractions sub-menu, we can see a list of abstractions with labels that specify whether the abstraction is sector-specific or project specific. There’s been a lot of frustration amongst many STEPN users who simply weren’t prepared for what would happen in a crypto bear market. Screenshot of the Dune Analytics STEPN Overview Dashboard.Our final Dune Analytics STEPN dashboard was created by @Howard_Peng. It’s a much simpler dashboard and effectively only looks at deposits and withdrawals, active users, and minted shoes.
This will require decoding the individual topics with a function such as BYTEA2NUMERIC(). In this example we are going to be working with the dex.trades data set to build out an analysis of 3 different decentralized exchanges. In the code above we are truncating the block_time into weeks . We then set a WHERE filter to ensure that block_time is greater than 180 days ago. This will provide a graph for the last 180 days grouped by weekly data points.
But UI aside, let’s take a look at what makes Dune different. First, it introduces a bottom-up model, with its community of analysts. In other words, Dune doesn’t assume to know what its audience wants. Instead, it incentivizes its community with financial rewards to produce dashboards.
Kishimoto will be a medium for Anime transaction and a monetary system on its own. Its purpose is to overperform all other cryptocurrency and has smart coding benefits for loyal holders with rewards. Transparency & accountabilityChanges to your project’s funding configuration require a community-approved period to take effect, which acts as a safeguard against rug pulls. Your supporters don’t have to trust you — even though they already do. Buying information has traditionally been difficult because you can only judge its quality once you have paid for and received it. This has meant only buying information from trusted sources with a good reputation.
