Metiocre
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.
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
🍣Sushiswap: Top Kashi Pairs (II)
May 18, 2022 - Q80. Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment? Hints: Adding asset for loan generates a “LogAddAsset” event Removing capital from kashi generates a “LogRemoveAsset” event
Stablecoin Popularity for Swaps
Apr 7, 2022 - Q45. Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022. Tips: USDC(31566704) USDT(312769) STBL (465865291)
52 Pickup ( LUNA new floor price)
Feb 27, 2022 - In this dashboard we are going to talk about the LUNA sale at 52$ and if it's going to in fact be the new floor for it or not.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Terra Scavenger Hunt (Farsi)
Feb 10, 2022 - ما در این داشبورد کوئری و دیتایی که نشان میدهد ما در ترا لونا استیک کرده ایم.
MakerDAO: DAI on the Market (May 13)
May 18, 2022 - Q3. 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.