Avalanche Active Users
Apr 16, 2023 - Let’s analyze Active Users on the Avalanche network. Create a parameterized dashboard that lets us explore active users across the chain. We'd recommend at least 3 tabs: active users across the chain, active users by contracts, and what dApps have the most active users over the parameterized period of time. The goal of this dashboard is to show where most of the activity is taking place on chain and where the active number of users is growing on chain. Add any additional metrics or charts that will provide users insights into contracts and dApps with growing usage based off average active users, new active users.
Covered Call Strategy in Friktion Volt
Mar 30, 2022 - How stake sol in Marinade Finance and Earn Passive Income with Friktion
Chain Swaps in Axelar
Apr 22, 2023 - Since February 23rd, you have been able to swap into 13 different Cosmos Chains via Squid: https://twitter.com/squidrouter/status/1628796403076964354?s=20 What chain has had the most activity?
Mega Dashboard for Optimism Bears
Nov 9, 2022 - Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. 125, 187.5, USDC, Ethereum
Flow Speed
Jun 4, 2022 - One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute. Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric has fluctuated during that time period. Level: Beginner, Payout: 18.66, Grand Price: 55.97 Flow
Cryptopunk Sales and Traders
Aug 30, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings. 75,225,B,M,Ethereum
Getting Started With Terra Bounties
Mar 24, 2022 - How Much LUNA Did You Delegate on a Validator
bAsset, bLUNA & bETH (LOCKED Collateral in Anchor and WHERE HELD IN)
Mar 21, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
THORChain Protocol Synth Utilization
Apr 11, 2022 - The Synth Utilisation of each Pool and Chart Over Time
Rand Gallery Wallets
May 24, 2022 - Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery? What is the total number of unique wallets that have been purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have been purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchased from rand gallery by ALGOs and the number of NFTs Tips: Check out these analyses for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/algo-rand-gallery-nft-sales-Fdtzb6 and https://app.flipsidecrypto.com/dashboard/rand-gallery-nft-sales-SYCxCf NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Terra Console for accuracy
Mar 8, 2022 - Review the existing Terra console for accuracy in FlipSideCrypto for Terra users. Overview: Terra is a public blockchain protocol deploying a suite of algorithmic decentralized stablecoins which underpin a thriving ecosystem that brings DeFi to the masses.
Let it Burn LUNA to UPGRAE!!
Apr 25, 2022 - The week that the most volume of Luna burning happened. What caused this event? And some effects of this burning on Terra ecosystem
THOR-versary!
Apr 18, 2022 - ComparisonTHORChain in its first 30 days vs the last 30 days: total number of swaps, volume of swaps (in USD), TVL, Number of pools, Number of chains.
What Are Users Swapping gALGO3 For?
Apr 28, 2022 - 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?
More Mints
Apr 18, 2022 - Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs.
Terra, Programmable Money for The Internet
Apr 6, 2022 - Terra’s Market Module, its goals and how it works
Sushiswap DEX Loyal Users
May 11, 2022 - Ranking of loyal users to the Sushiswap platform based on the number of transactions and the number of days of using this DEX
Folks Finance: Minting gALGO3 For Governance
Apr 21, 2022 - Looking at the users who committed their ALGOs to this liquid governance pool and minted gALGO3. How much gALGO3 was minted during the governance commitment period? How much total amount of gALGO3 was minted during the governance commitment period over time? How much total amount of gALGO3 was minted over time by day including outside the governance commitment period. Has a lot of gALGO3 been minted outside the governance commitment period?
Algofi Recursive Borrowing
May 26, 2022 - Q82. Let’s look at AlgoFi Recursive borrowing! This is where you supply the same asset you borrow. How many users are supplying and borrowing the same asset on AlgoFi ? What is the average amount of each asset being supplied for recursive borrowers? How much rewards did they receive in 2022 ? What is the percent of these users of total suppliers & borrowers ? Note any other interesting findings relating to AlgoFi recursive borrowing Tips https://docs.algofi.org/algofi-lending/master/depositing-funds https://docs.algofi.org/algofi-lending/master/borrowing-assets https://docs.algofi.org/algofi-lending/mainnet-contracts Tips: Check out the AlgoFi docs for more detail https://docs.algofi.org/protocol/mainnet-contracts -Each Market Address in the docs is the where a wallet will send and receive their assets when providing liquidity, borrowing, repay borrowing, and withdrawing liquidity. The same is with the corresponding Market App ID. Providing liquidity will be sent to the Market Address(in a axfer or pay transaction depending on the asset) and will share a group transaction with the Market App ID. The application call transaction with the Market App ID will have a transaction message of ‘Market: mt’(i.e. try_base64_decode_string(tx_message:txn:note::string) = ‘Market: mt’) When borrowing liquidity will be transferred to the wallet from the Market Address in an inner transaction. The parent transaction(shares the same tx_id with the inner transaction) will be an Application transaction and have a corresponding Market App ID to the asset. The parent application transaction will also have a transaction message of “Market: b” indicating a borrow(i.e. try_base64_decode_string(tx_message:txn:note::string) = ‘Market: b’) Repaying a borrowed loan will appear similar to a wallet providing liquidity, however, the application call transaction with the Market App ID will have a transaction message of ‘Market: rb’(i.e. try_base64_decode_string(tx_message:txn:note::string) = ‘Market: rb’) Finally withdrawing liquidity from AlgoFi will behave similar to the borrowing liquidity transactions except the parent application transaction will have a transaction message of “Market: rcu” indicating a borrow(i.e. try_base64_decode_string(tx_message:txn:note::string) = ‘Market: rcu’)
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 22, 2022 - In this article: How much GARD has been minted by day? How many wallets mint GARD each day? How much has Gard.Money generated in ALGO fees? What is the total amount of ALGO collateral currently backing the GARD?
DAI on the Market (May 13)
May 17, 2022 - Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
AB2 Gallery Wallets
May 25, 2022 - Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs Tips: Check out this analysis for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/15-ab-2-gallery-nf-ts-77b-ew https://ab2.gallery/ Here is an asset transfer example of an asset being purchased from AB2 Gallery tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w=' -To look at transfer transactions in involving AB2 Gallery use: where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery' NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Bridge Users (Hop Protocol)
Jun 19, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.