sunshine-julia
Aave - 12. Aave Delegates' Gas Usage
Mar 21, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?
FLOW Usage During the NBA Playoffs
Jul 13, 2022 - Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume. Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?
What makes a Top Shots moment valuable? (Part I)
Jul 26, 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.
MonkeDAO Validator
Feb 20, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
21. Top Pool Analytics
Jan 12, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
Analyze Soul Bound Tokens (SBTs)on NEAR
Jul 26, 2023 - I-AM-HUMAN - Proof of Personhood Protocol on NEAR allows users to scan their face and get a special, non-transferable SBT. Please analyze the following: how many users claimed there SBT if those are existing vs newly created wallets and what these wallets are doing. bonus for tracking their interaction with DAOs in the NEAR ecosystem Any additional finding you think you be interesting for the NEAR Foundation and ecosystem.
Net Swapping Rations
Jan 17, 2022 - Which tokens have the highest and lowest ratio of being swapped from / to? (e.g. if users swapped from a total of 100 $BTC and to a total of 200 $BTC, the ratio would be 1:2) Hint: use thorchain.swaps
Fuse Pool Analysis
May 25, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Uniswap on Polygon: Which Bridge to Where?
Mar 19, 2022 - Over the past 30 days, which bridges are users of Uniswap using the most? Which ones are passing the most value?
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Overtime Markets - Profitable Traders
Aug 26, 2022 - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
Wallet Providers
Jul 13, 2022 - Q19. Some wallet providers, like Blocto, subsidize the FLOW network fees for their users. As such, the payer for all of these transactions, as listed on the scanner and in our tables, is the wallet address 0x55ad22f01ef568a1.
Untitled Board
Dec 30, 2022 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: * The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere) * The most common asset transferred into Osmosis for first transfer Stay or leave: * What do wallets do when they first come to Osmosis? * Join to swap and then transfer that asset out? * Join to stake OSMO? * Join to swap and then LP? * Which assets are most commonly swapped for and transferred out? * Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint
AAVE and stAAVE movements
Aug 8, 2022 - Create visualizations showing the following: 1/ Daily AAVE supplied and withdrawn on Aave protocol. 2/ Daily AAVE staked and unstaked.
Untitled Board
Dec 3, 2022 - Since the $AXL token launch, how have wallets that bought $AXL used it? Are most wallets hodling or trading? What is the average holding period for wallets buying $AXL in the last month? Generally speaking, have users kept $AXL on exchange (in their Osmosis wallet) or have they bridge to other places? Analyze $AXL balances on Osmosis as compared to native on Axelar. How have these balances changed over time?
NEAR Performance
Jul 21, 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.
Uniswap - 20. Power Users
Apr 2, 2022 - Using data from January 2022, what percentage of swappers were also liquidity providers at some point in January? You may answer using data from any blockchain were Uniswap is available.
Polygon Block Performance
Jul 27, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Impact of Adding New Chains/Tokens
Jan 20, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up? Hint: use whatever tables you think shows your point!
Volume Market Share
Feb 14, 2022 - Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Question 166: Outbound traffic
Mar 17, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Profit for AMMs
Apr 14, 2022 - What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
Anchor Dominance
Feb 17, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis? *Select your own definition for “active wallets”; for example, wallets with at least 1 transaction in the last 30 days
40. Common LP Pairs
Jan 12, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?