mohamadreza221166
Waiting for Aurory
Jul 16, 2022 - Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs.
NEAR Performance
Jul 20, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail
Solana Protocol Feature
Jul 13, 2022 - Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it.
Average Solana Portfolio
Jun 26, 2022 - Q91. What does the average Solana user's portfolio look like and how has that changed over time?
Algorand Free Square
Jun 30, 2022 - Q110. Time to get creative and explore! We want you to dig into a topic/project/protocol on Algorand that you find relevant and interesting and create an analysis around it. Bonus points for creativity and uniqueness!
Voting Activity
Jun 17, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Let's look into stablecoin data on Algorand
May 31, 2022 - Chart some metrics on the total supply of stablecoins on Algorand. What is the total monthly transaction volume for stablecoins on Algorand? What are the most popular stablecoins monthly? How much of the total stablecoin supply on Algorand is being lent or borrowed? How has the impact of UST’s depeg affected the flow of funds in and out of various stablecoins on Algorand?
Pricing ASAs
May 10, 2022 - The Algorand protocol supports the creation of on-chain assets that benefit from the same security, compatibility, speed and ease of use as the Algo. The official name for assets on Algorand is Algorand Standard Assets (ASA). Part One: Using the Price Swap table, pick a single day in the last 30 days and find the top 5 most and least expensive ASAs Pick an hour in that day and visualize the distribution of prices across all ASAs for that hour. Part Two: Find the top 10 ASAs by volume in the last 90 days using the VOLUME_USD_IN_HOUR. Which had the highest average volatility? Which was the most swapped?
Solana NFT Project Feature
Jul 16, 2022 - Choose a NFT project and create a dashboard that helps show the "health" of the project.
What Are Users Swapping gALGO3 For?
Apr 29, 2022 - Powered by Flipside Crypto What Are Users Swapping gALGO3 For? In this Presentation i'm want to Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance. Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day? Are there any notable days? If so, what may have caused this? What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. What are the top 10 most popular to swap from to get gALGO3? What are the top 10 most popular to swap to from gALGO3?
NEAR City Stakeholders
Aug 13, 2022 - Q8. A city’s vitality depends greatly on the quality of education it provides to its citizens. The NEAR ecosystem is full of interesting educational platforms, like NEAR crowd and the Learn NEAR Club
Moving to Earn in the Bear Market
Jul 13, 2022 - Q96. Move to Earn projects have been growing in popularity, especially on Solana after the explosion of StepN.
Applications on Algorand
Jun 28, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021?
Swapping goBTC and goETH on DEXs
May 17, 2022 - goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May.
Wildlife Warriors NFT Drop
Jun 20, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
Sushiswap DEX Loyal Users
May 8, 2022 - i refer to "ethereum.dex_swaps" and transactions table to find wallets that used SushiSwap on platrorm "sushiswap". we also find then wallets address label name in table "ethereum.labels". for Use different frequencies for the ranking we parsing the transaction dates to "year" and "month".
Top TOKE Holders
Jun 21, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Swapping for YLDLY on DEXs
May 20, 2022 - In this dashboard we Show the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly?