Dune Analytics Review and Best Alternatives

We have a nice table of decoded data to work with because the contract has been verified. So we are grouping these by week and project and then ordering by the week in chronological order. We can then create a nice stacked bar chart to visualise the data. Note that in the table above the trader_a addresses are formatted “\x…” rather than “0x…” this is a common gotcha to be aware of whenever inputting an address into a Dune SQL query.

Ethereum” are more mature than than Dune Engine V2, which only just entered beta. Let’s head to Etherscan and see if we can find a smart contract related to Pooly. Once you open Etherscan.io type “Pooly” to see if the owner of these smart contract registered them with Etherscan. As it stands now, we can’t build the views in the same way as the Pooly website, but we can capture the same amount of data (and more!) to build our dashboard.

Part 3: Cleaning up the Dashboard

A join combines similar data from different tables connecting it at the point set at ON. A union returns the results of two different queries from a data set. Union by default removes duplicate rows, if this is not intended then use UNION ALL. Finally we can add charts to our own custom dashboards and publish these in the Dune Analytics Discover section. Solidity Solidity is the programming language of Ethereum and all EVM compatible blockchains.

Premium users can skip the query queue to run parallel queries. Dashboards and queries are kept private, and data is exported to CSV files. Data is displayed in lists or visualized into graphs and bar charts. In Aug. 2020, the team received $2 million during the seed round. The platform became popular among those who were able to achieve insane percentage yields using experimental finance protocols in 2020. Dune’s co-founders were working at the same company in Norway, and they both decided to quit their jobs to create the data analytics platform.

This excludes the long tail of people around the world who have valuable insights but no way to be believed. Investors retain full ownership over their funds while reaping the rewards of enabling the best managers to trade their capital. Curve is fully decentralized and all decisions about the protocol are taken by CRV holders. The majority of cryptocurrencies sit idle on exchanges and in wallets, without yielding interest.

A joined table however, allows us to call columns from the second table multiple times, thus enabling us to create the outputs we need for the specific rows in the column that we need. Since we only want NFTs that were newly https://cryptolisting.org/ minted by the smart contract, we must specify the “from” address to be the null address. By counting the amount of “tokenId” for each transaction, we can count the total number of NFTs minted for each transaction.

Part 1: Overview of Dune and Functionality

If you click on the circle in the top right and then on “My queries”, you will open the queries list of your account. The community section can be thought of as an extension of the abstraction section, but with data aggregations being supplied by Dune community members. With Dune’s recent announcement of their V2 Engine, which increases performance by 10x, it’s about time you learn how to use Dune. It’s a simple but straightforward dashboard that focuses on daily active user trends on Solana and Binance Chain. Howard used to be a Data Analyst at Binance but has since moved on to new projects. An interesting detail is that newly minted Sneakers do not actually show up in the on-chain data and are only reflected once they are transferred out.

• From there we can go on to build complete dashboards of data visualisations for competitor analysis, key performance indicators and on-chain activity.
• Anyone can use Dune Analytics by creating an account and using any of the popular Dashboards on the Discover tab.
• So we are grouping these by week and project and then ordering by the week in chronological order.
• However, they are not officially supported and only provide limited features.
• In Dune Analytics, you can add pre-written SQL lines and request the data you want.

But first, we need to decide what we want our dashboard to be about. Pooly NFTs by the Pool Together DeFi protocol are a great first step. Once the query is finished running, you’ll see your query results . You may wonder why there is only one entry in the community section (“flashbots”) – well, that’s because Dune Engine V2 was just released! Over time, we can expect to see more and more community-built datasets by trusted community members.

Keep on Dune

It’s where all the best writers, researchers, and community members in the crypto space can come together. Frax is open-source, permissionless, and entirely on-chain – currently implemented on Ethereum and other chains. The end goal of the Frax protocol is to provide a highly scalable, decentralized, algorithmic money in place of fixed-supply digital assets like BTC. Users generate Dai by depositing collateral assets into Maker Vaults within the Maker Protocol. This is how Dai is entered into circulation and how users gain access to liquidity.

Decoded projects are projects that the Dune team took apart, labelled, and put into tables so that users have an easy and standardized reference for certain data. That means everything you build or other people build can be viewed and forked (i.e., copied) by anybody! This severely decreases dashboard creation time and lets you learn from other users’ queries. Dune Analytics currently partners with node providers in order to optimize their procurement of blockchain data.

A simple formalized equation drives unstoppable liquidity for thousands of users and hundreds of applications. Uniswap is a fully decentralized protocol for automated liquidity provision on Ethereum. PEPEMON.finance is a digital collectible card game on Blockchain. Kishimoto Inu wants to give Anime community a platform where everyone can decide about the future of the Anime token. If you are a Restricted Person, you may not purchase or otherwise acquire Index Coop token products. If you are unsure as to your eligibility, read our Terms of Service and list of Tokens Restricted for US Persons, and consult your financial, legal and/or tax advisor.

Kyber Network Crystal (KNC)

The poolysupporter dataset allows us to do more specific and detailed queries, as we can refer to specific contract calls. Instead of using the erc721.”ERC721_evt_Transfer” table, we can also use the poolysupporter.”PoolyNFT_call_mintNFT” decoded table that the Dune team put together. Since we want the from null address filter to be applied to all results of the previous filters, we need to add the parentheses.

Bancor Protected V2.1 Data

Dune has replaced its closed, standard, and costly counterparts with open dashboards. The dashboards provided by Dune Analytics make it easy to understand and visualize complex data with simple-to-understand graphs and charts. CoinDesk is an independent operating subsidiary of Digital Currency Group, which invests in cryptocurrencies and blockchain startups. CoinDesk journalists are not allowed to purchase stock outright in DCG.

Optimism is a fast, stable, and scalable L2 blockchain built by Ethereum developers, for Ethereum developers. Built as a minimal extension to existing Ethereum software, Optimism’s EVM-equivalent architecture scales your Ethereum apps without surprises. If it works on Ethereum, it works on Optimism at a fraction of the cost. V1 of Lyra has been designed to hedge risk via Synthetix, which offers zero slippage, infinite liquidity and a simple means of getting long/short. Future versions of the protocol will be designed to ensure Lyra can be deployed on multiple L2s, so that the protocol can exist wherever the majority of users and liquidity ends up.

Liquity is a decentralized borrowing protocol that allows you to draw 0% interest loans against Ether used as collateral. Loans are paid out in LUSD – a USD pegged stablecoin, and need to maintain a minimum collateral ratio of only what is silkcoin 110%. Programmable spendingCommit portions of your funds to the people or projects you want to support, or the contributors you want to pay. Aave is an open source and non-custodial protocol enabling the creation of money markets.

Dune Analytics is an open-source, Ethereum-based crypto data analytics platform, that offers free on-chain data to anyone. It can run its SQL queries directly on the supported blockchains . What Dune Analytics brings new to the crypto world is the fact that it makes on-chain crypto data available and consumable. Initially, the creators intended to create a tool that allowed anyone with an internet connection to analyze a few dozen smart contracts products. Dune Analytics is a data platform that crypto-asset analysts and investors use to research specific projects such as NFTs, DeFi platforms, or blockchain ecosystems.

Tokens can be redeemed for a portion of your project’s overflow funds; when you win, your community wins with you. Leverage your project’s token to grant governance rights, community access, or other membership perks. $GCR is a social token community with a writers platform and token-gated Discord group.