adriaparcerisas
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 23, 2022 - In this dashboard, we will take a look at the collateral debt positions (CDP) users are taking on, by putting ALGOs up as collateral and in turn getting GARD in return.
ENS Claim vs Price
Dec 14, 2021 - Make a scatterplot showing the relationship between ENS price and the number of airdrops claimed.
Pools Run By Whales
Dec 20, 2021 - Define a whale. Find the liquidity pools where more than 90% of the liquidity is made up by whales. How do the returns of these pools compare to the returns of the other pools for your average Joe? What percentage of a pool made up by whales is considered too much?
Tokenflow Trailblazers
Mar 23, 2022 - Q1. Dive into the Tokenflow data and tell us what you find. Conduct a brief analysis on a topic of your choice, with at least 1 data visualization and a succinct paragraph describing your findings. Additionally, share your experience with the data: was anything missing that you expected to find, were there difficulties you encountered, was there documentation you desired, etc? How does this data change the way you think about and analyze Ethereum data? Helpful Resource: https://ath.mirror.xyz/lcZzeBcfpmfQlIHqUBmNAmv5EeVfNBGmr-S7mkWcuyo
Getting Your Feet Wet, Part 1
Mar 8, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
Dodge, Duck, Dip, Dive and $DOGE
Jan 24, 2022 - What % of the swaps made this week involved $DOGE?
Katana wLUNA Pool
Feb 20, 2022 - Katana's primary offering is a suite of accessible vaults that execute automated yield strategies in the background. One of such vaults is its Wormhole LUNA covered call vault, which offers appealing yield opportunities on LUNA especially during times of volatility. Shares represent your ownership of a Katana wallet and are needed in the withdrawal process to then remove funds from the vault. Create a chart showing the amount of Katana WLUNA Covered Call Vault Shares claimed since February 4th and the number of unique wallets that have claimed shares. What is the average size claim? Does it seem that the wLUNA vault is mainly used by "whales"?
Lil Nouns: Secondary Sales Activity
Jun 20, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Initial swap volumes of LUNA and UST
Apr 20, 2022 - Measure and compare the first three days of swap volumes of the following tokens: Doge, LUNA and UST
Friktion SOL vs mSOL Volts
Feb 20, 2022 - Friktion offers an income generating covered call product to users. A covered call option involves holding a long position in a particular asset, for example, SOL, and writing a call option on that same asset with the goal of realizing additional income from the option premium. How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt? How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt? Why do you think one volt has been gaining more adoption than the other?
ORBS monthly swaps
Dec 4, 2021 - Show the total monthly swap volume of Orbs over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
IL Payout vs LP Age
May 10, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
Solana Competitive Advantages
May 4, 2022 - Why would a developer and / or a user choose Solana over Ethereum (and vice versa)?
Wallets activity with ENS registration
Dec 24, 2021 - Is ENS just for cred? Or do people actually use their ENS-addresses? Look at all addresses with an ENS registration in the last 6 months, what percent of those addresses have done transactions?
Weigh Anchor (Users)
Jan 8, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry?
26. [Hard] Network Load
Dec 7, 2021 - What is the highest number of swaps THORChain has handled in a single minute? What is the highest number of swaps in a single minute broken down by each day?
Comparison of active users on Uniswap and Sushiswap
Nov 13, 2021 - In this table, we will compare the number of active users per week on Uniswap and Sushiswap over the past year.
Liquidity stats on THORChain
Nov 8, 2021 - In this dashboard, we will analyze the current depth of each pool based on the number of LP-ers currently providing liquidity.
Gainers and Losers
Jan 11, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 losers for each of the same categories.
Angel has risen
Dec 23, 2021 - How much has been donated to Angel's charity wallet so far this year? Create a visualization of your choice to show the donations either a) over time or b) by top donor. To be eligible for the grand prize, add your own analysis of charitable donations to Angel this year and make suggestions for increasing donations.
Spooky Web3 Tale history
Nov 2, 2021 - Today I am going to tell you my most frightening web3 story, a rough story, with a bitter taste but with a happy ending. My days of panic because my transactions did not appear.
Stader Labs Active Daily Users
Dec 15, 2021 - Show the unique addresses depositing into Stader each day. How do these numbers compare to other protocols on the Terra blockchain? How much are these addresses depositing?
Fuse Pool USDC Allocation
Mar 23, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
ERC20 Tokens (zkSync)
Jun 17, 2022 - This dashboard shows the ERC20 tokens that have been deposited the most (in $ volume and total count) in the last 60 days on zkSync.
Sushiswap user liquidity spread
Dec 26, 2021 - How spread out is your average Sushi liquidity provider in terms of pools where they provide liquidity? Is it optimal to stick to a smaller number of pools or spread your capital across a bunch of different liquidity pools?
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 10, 2022 - What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time?
Lost Anchor Funds
May 4, 2022 - There has been an increase in reports of new Anchor users losing funds to fraud or scam copies. Analyze the following transactions, noting any suspicious user behavior. How did these new users lose their funds? How can this be prevented
Vote!
Feb 12, 2022 - Question 9: Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February (hint, use the block table and the votes_block_agg table). What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
8. [Easy] What are the top 5 most swapped assets on Harmony by volume and number of transactions?
Mar 9, 2022 - What are the top 5 most swapped assets on Harmony by volume and number of transactions?
Synth Mints + Burns
Apr 13, 2022 - Show the minting + burning of synthetic assets over time.
Terra Altcoin Behavior
Feb 7, 2022 - Question 143: Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
When Do Transactions Fail?
May 31, 2022 - 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?
Terrarbitage, Part 2
Dec 14, 2021 - Identify wallets that have taken advantage of the LUNA-bLUNA pool, using it to multiply their LUNA holdings, risk-free. What can you tell us about the wallets/users who are doing this?
Swapping for YLDLY on DEXs
May 22, 2022 - Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642).
stETH Most Common Pools
Apr 27, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Weekly APY for THORChain Loopers
Oct 29, 2021 - In this dashboard we are analyzing the ROI for LP-ers on Thorchain, both by pool and total We can see that the median weekly APY is around 15%, which indicates approximately a 850% of anual APY. During first weeks, the APY was so poor reaching also negative values. However, since June 2021 it turned so green and APY started to jump. Being 20% the median for last weeks. It is to say that for the second week of July, the pools experimented a huge decrease, reaching values like -70%, we will have to analyze better.