How did I make this Dashboard? (Hint: SQL & Dune Analytics)
Blockchain technology promises accessibility and transparency. Given its open-source nature, anyone should be able to access and analyze public blockchain data to determine a myriad of events and transactions taking place in the ecosystem. However, many popular data analytics platforms such Nansen charge thousands of dollars per month for access to the most basic dashboards and features.
Dune, a free data analytics platform that lets anyone publish and access crypto dashboards driven by blockchain data, looks set to deliver on the promise of blockchain technology. Dune decodes blockchain data before adding it to their database, meaning that you don't have to figure out bytecode communication on your own. Instead, you use Dune's dataset explorer to browse datasets, specific smart contracts, events, or calls and structure queries using SQL.
Of the bat, Dune has plenty of popular dashboards tracking everything from as trending yield farms on Ethereum to non-fungible token (NFT) collections bought by top OpenSea traders. Dune also gives users the ability to see the underlying queries that produced these dashboards and modify them to address the user's specific analytical needs.
To test Dune, I built my own NFT and Wallet dashboard analyzing:
- Top 10 NFT collections by Volume, Sales, and Changes in the Floor Price for user-specified time frames and NFT marketplaces (e.g. OpenSea).
- Top Wallets purchasing these "blue-chip" collections including their balance (both NFTs and Crypto) and past history of success such as Realized and Unrealized PnL, Most Profitable NFT Sale, and Least Profitable NFT Sale.
Note that all embedded dashboard items currently use a period length of 1 day and query data across all available platforms. If you want to play around with these values, please visit the full dashboard here.
You can also click on the icons in the dashboard (📶 ⛵ 🟢) to track the Wallet or NFT Collection on Etherscan, OpenSea, and LooksRare.
Without further ado - let's jump into the dashboard!
Top 10 NFT Collections
Top 10 NFT Collections By Volume
This dashboard is helpful for determining which are the most popular high-value collections in circulation over the specified time-frame. This can be helpful in determining the popularity of "blue-chip" NFT collections.
Top 10 NFT Collections By Sales
This dashboard is useful for figuring out the most popular NFT collections by the number of items sold. Since this is not price dependent, it provides an opportunity to explore collections that have yet to appreciate in price fully.
Top 10 NFT Collections By Increase in Floor Price
The Floor Price refers to the lowest price for an item in the given NFT Collection. This dashboard is helpful for understanding which NFT Collections have appreciated the most in value over your selected timeframe. At the time of writing, the value of the least expensive NFT in the Bored Ape Yacht Club collection had increased by over $10,000. Barring other relevant information, an increase in Floor Price can be a good sell signal or, alternately a sign that money is flowing back into the NFT market.
Top 10 NFT Collections By Decrease in Floor Price
The Floor Price refers to the lowest price for an item in the given NFT Collection. This dashboard is helpful for understanding which NFT Collections have depreciated the most in value over your selected timeframe. At the time of writing, the Floor Price for a VeeFriends NFT has gone down by almost $8,000 since the prior day. Barring other relevant information, a decrease in Floor Price can be a good opportunity to buy a "blue-chip" NFT Collection.
Top NFT Wallets & Owners
Top 10 Wallets That Bought The Most Expensive Item in a High-Volume Collection
The dashboards below analyze the wallets that paid the highest price for an item in a Top 10 NFT Collection (by Volume). These wallets are interesting to analyze since they either overpaid for the NFT they purchased or the NFT itself had unique characteristics that justify the purchase price. The wallet labeled straybits is a great example of such an account worth following. Straybits has a Total PNL over $700,00 and netting over $533,000 from the sale of a V1 CrypoPunk. Note the tables below may have updated since the time of writing.
The relevant metrics for dissecting the wallet are:
- The Number of NFTs the Wallet Owns
- The Value of the NFTs in the Wallet
- The Value of Tokens (e.g. ETH) in the Wallet
- The Total PnL of the Wallet broken down by the Realized PnL (from Sales of NFTs) and Unrealized PnL (from NFTs still in the Wallet)
- The Maximum Gain and Loss from an NFT sale by the Wallet and the corresponding NFT Collection
Top 10 Wallets That Bought The Least Expensive Item in a High-Volume Collection
The dashboards below analyze the wallets that paid the highest price for an item in a Top 10 NFT Collection (by Volume). These wallets are interesting to analyze since they purchased an item in a high-volume NFT collection for the lowest price in the specified time frame. This could suggest that the wallet's owner may be able to identify NFTs that have the potential for significant short-term appreciation. The metrics displayed are the same as those above. The wallet labeled chefpierre is a fantastic example of such an account with a Total PnL exceeding $2 million. Not only has chefpierre flipped a CryptoPunks collection for $136,000, but has also never experienced a loss selling an NFT. In fact, the wallet's lowest ever profit was from the sale of a Jadu Hoverboard NFT, which netted $2,261. Note the tables below may have updated since the time of writing.