Metiocre
Quixotic Marketplace Analysis
Aug 3, 2022 - Come with me to explore everything about Quixotic, the biggest nft marketplace on optimism.
🐼 Ethereum 2.0 Validators🐼
Sep 17, 2022 - On September 15, 2022 one of the biggest events in the history of crypto happened. The Eth 2.0 merge. Let's take a look at what that is and how have people and platforms reacted to it.
New year, new LUNA
Jan 11, 2023 - Purpouse of this dashboard is to document significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem.
Godmode: The Typical Minter
Jun 8, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
Terra Whale Voters
Feb 16, 2022 - In this dashboard we are going to find out who the whales of the terra ecosystem are, and how often they vote on governance. we will use the terra.daily_balances, terra.gov_vote tables for this porpuse.
Algorand: Tinyman LP Actions
Mar 3, 2022 - In this dashboard we are going to talk about Tinyman and burn and mint actions and the top pools.
Solana Fees
Feb 5, 2022 - In this dashboard we are going to compare fees on the Solana network and compare it on several timeframes. reading this will answer the following questions: 1- what is the daily volume of transaction fees collected on Solana? 2- are fees on Solana volatile or are they stable? - what is the average fee on Solana regularly? - what is the fee stability like compared to other blockchains? 3- what is the best day of week to do transactions on Solana? 4- what is the best time of day to do transactions on Solana? all of the charts shown in this dashboard are since the beginning of 2022 and onwards.
Pleasure to Burn(LUNA burn vs. UST supply)
Feb 27, 2022 - In this dashboard we are going to see how much LUNA has been burned in the past 30 days and how that has affected the UST supply.
Unique Users on Algorand
Apr 7, 2022 - Q46. Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks? -Chart daily unique wallets by day since February 1st for each major blockchain(Algorand, Solana, Ethereum, Terra) -Does it appear that market conditions are slowing down growth or activity on the networks?
SOL Swaps on Jupiter
Feb 18, 2022 - In this dashboard we are going to talk about Jupiter and how much sol is being daily traded on it. Jupiter: The best swap aggregator on Solana. Built for smart traders who like money.
ASA Asset Transfers
Apr 7, 2022 - Q41. What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular? Create a table using the asset_transfer_transaction table that show the top 10 assets by number of transfers since February 2022. Chart these transfers over time by day as well. Create a table using the asset_transfer_transaction table that show the top 10 assets by number of wallets that initiated a transfer since February 2022. What announcements and events could have led to the popularity of some of these assets?
🍣Sushiswap: Trend of Pools
May 18, 2022 - Q78. What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
Algorand:Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Q50. Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table Create a bar chart visualization of the top 10 ASAs by total ALGO swap volume. (Tip: This means we want to look at swaps where the wallet is sending in ALGOs(asset ID: 0) and receiving another asset in return. The volume would in ALGOs would be the sum of all the ALGOs wallets sent in to receiver the asset). Create a table for the top 10 ASAs found in part 1. In this table, list the ALGO swap volume and the average amount of ALGOs involved in a swap. Create a time series chart to look at the number of swaps (from ALGOs) to each of these 10 ASAs over time by day since the beginning of 2022. Note any trends on the increasing or decreasing popularity of any of the ASAs.
Algorand: Active daily wallets
Mar 3, 2022 - in this dashboard we are going to compare the number of active daily wallets for the month of January 2022 vs January 2021 and December 2021
Sushiswap🍣 : Whale swaps
May 4, 2022 - Question: How many swaps are above x$ and how much total amounts were swapped in such transactions? Default: 150000
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. Let's take a look at the addresses analyze them.
Uniswap-v3 vs Sushiswap gas comparison
Feb 3, 2022 - In this dashboard, we will compare uniswap and sushiswap average and total daily gas fees in the past two months. First of all, let's look at the data table we get by running the query. then we will look at the total and average daily gas_used in two separate charts. as you can see, uniswap has much more volume so it has more total gas_used but sushiswap has lower average gas_used so it might be a better alternative to uniswap..
Solana TPS
Feb 23, 2022 - In this dashboard we are going to see the daily TPS ( Transactions Per Second ) on Solana.
Getting Your Feet Wet, Part 2
Mar 10, 2022 - Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis
bLUNA vs. bETH collateral provided on anchor
Feb 3, 2022 - We will compare the total amount of bLUNA and bETH provided on anchor up to this time in point and also daily amount of bLUNA and bETH provided to anchor protocol. First we will take a look at the Total amount_usd result table and pie chart.
Saber and daoSOL
Feb 18, 2022 - In this dashboard we are going to talk about Saber and the trends of it. Saber is the leading cross-chain stablecoin and wrapped assets exchange on Solana Questions: 1-Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? 2-How many unique wallets have added liquidity to that pool since February 1st?
Terra: User Growth Per Sector
May 1, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others? Share your findings.
Sushi: Market Volatility II
May 25, 2022 - Q83. Analyze the effects of the recent spike in market volatility on the sushi token. What was the supply and demand dynamic for it? What did the liquidity of SUSHI on uniswap and sushiswap look like? How about the staking situation for SUSHI? Did many SUSHI’s get unstaked?
Most Popular Jupiter Swaps
Feb 27, 2022 - In this dashboard we are going to see what are the most popular tokens on Jupiter in terms of them being SwappedAway, SwappedInto and the SwapPairs.
Flow: When Do Transactions Fail?
May 27, 2022 - Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?
Solana Phantom Wallet Growth
Feb 9, 2022 - In this dashboard we will compare the months of January and February in terms of new wallets created. we want to know if the introduction of phantom wallet on phone had any impact on number of daily wallets created. since the Solana tables were running extremely slowly I couldn't get the query to run for 8 hours so I just had to end it with one chart so here it is.
Thorchain: Weighted-Average LP Duration
Apr 29, 2022 - What is the weighted average of LP duration in Thorchain?
Algorand Stablecoin Popularity USDC vs USDT
Feb 10, 2022 - In the following dashboard we are going to answer the following questions. 0-Introduction 1- What’s the number of people who currently hold USDC vs USDT. 2- Number of transactions each day for USDT and USDC. 3- What is the distribution of tokens for USDT and USDC.
Luna, Steady As She Goes
Mar 2, 2022 - In this dashboard we are going to see if LUNA is resistant to market crashes in crypto or not and how it compares to the likes of ETH and SOL.
Algorand: Al Goannas NFT deep dive
May 26, 2022 - Q80. Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection. Show the number of Al Goanna’s each wallet holds. Show the amount of fees Al Goanna sales have generated for the DAO over time. Show Al Goanna sales and ALGO volume over time. -Show the distribution of ALGO balances of Al Goanna holders Note any other insights you find about the Al Goanna sales or holders!
Algorand: What Are Whales Swapping For?
Apr 14, 2022 - Q48. Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table. Describe your methodology of what signifies a whale What percent of whales participate in swaps(use the algorand.swaps table)? Additionally show the distribution of the number of swaps per whale in 2022. What assets are whales swapping from? Display this over time starting at the beginning of 2022. What assets are whales swapping into? Display this over time starting at the beginning of 2022.
ETH + USD in the FWB Treasury
Feb 23, 2022 - In this dashboard we are going to check the Friends With Benefits treasury wallet and the assets it is holding and compare them over time.
Algorand:USDC Transfer Volumes
Apr 14, 2022 - Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022. Chart the daily volume of USDC that is sent between wallets on each blockchain for 2022. Chart the daily # of USDC transactions that are sent between wallets on each blockchain for 2022. Find the average USDC transfer size for each blockchain in 2022. Compare the trends of USDC transfers on each chain and note your findings.
Algorand Unique Users Growth
Feb 7, 2022 - Charting the number of new unique addresses created each day and checking if there is any increase in Governance Commitment Periods. Governance Commitment Period 1: September 20th 2021 - October 14th 2021 Governance Commitment Period 2: Dec 24th 2021 - January 7th 2022
Terra Contractually Obligated
Mar 10, 2022 - Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
Algorand: 2022 Yieldly Staking Pool Analysis
May 21, 2022 - Q75. Let's get a better understanding of the YLDY staking pool usage in 2022. In 2022 what have been the most popular Yieldly staking pools by the amount of YLDY staked, the total number of stakers, and the average amount staked? Additionally, show us how staking pool participating has evolved over time in 2022. Do we see more wallets participating in staking pools now or less? Do we see more wallets participating in staking pools but committing less amounts? Note how behavior has changed around these staking pools. Does the price of ALGO impact the number of users participating and staking pools? Are there any standout wallets that have staked in a lot of these Yieldly staking pools? Note any other interesting findings about the Yieldly staking pools and their usage.
Terra, State of the Art
Mar 10, 2022 - Imagine a super awesome Terra Console 2.0 or an analytics equivalent to Terra Station: a dashboard users can check daily to stay informed and up-to-date on the Terra ecosystem. For Completeness, touch on the two points: What data do Terra users want to see displayed daily - besides price, what do you want to check on a daily or weekly basis, e.g. active users/MAU/WAU, number of protocols? Describe the features that would be important to include. While you can mention non-data features, e.g. “integration with an airdrops calendar” or “links to Terra Bites podcasts”, the majority of your analysis should focus on data features. For Visualization: display at least two existing resources, e.g. this or this, that you think are excellent, or provide your own simple mockup or wireframe of a Terra analytics dashboard.
🍣Sushiswap: Stablecoin Landscape on DEX
Jun 7, 2022 - Q87. Analyse the stablecoin landscape on Sushiswap, identifying the various tokens available and their main metrics (volume, number of swaps, TVL, and other relevant for you). Which one is the most successful? Is it the same at Uniswap?
Acquiring goBTC and goETH
Apr 7, 2022 - Q47. Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find. Tips: When the goBTC and goETH is ""minted"" by a wallet it is distributed from ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4 to the Algorand wallet. When a wallet wants to ""redeem"" their goETH and goBTC for their original asset, they send it back to the wallet it was distributed from. Asset IDs goBTC: 386192725 goETH: 386195940