banbannard
Stargate Fishes and Whales
Apr 26, 2022 - Define the terms fish and whale in terms of Stargate token ownership (in your opinion). What proportion of users fall into each of the categories you defined (fish and whale).
IL Protection Over Time
May 14, 2022 - With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
Active Wallets on Terra
May 1, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Volume Market Share
Feb 13, 2022 - Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Katana Covered Call Vault Popularity
Mar 30, 2022 - Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?
Fractional.art Top NFT Collections
Apr 27, 2022 - Which 5 NFT collections (for example; BAYC, MAYC, ArtBlocks, etc.) have been deposited into Fractional vaults the most over the past 3 months? Are there any trends with these collections? How does having highly sought after NFTs in the vault impact trading volume?
CowSwap - Market Mover?
Apr 21, 2022 - Has CowSwap shifted the token exchange market? Show the number of swaps that are done on CowSwap compared to other DEXs over the past several months. What DEXs are the users of CowSwap coming from?
Distinct Wallets (zkSync)
Jun 17, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Successful Bids on Kujira
Apr 9, 2022 - Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users are seeing their bids filled?
Secret Scavenger Hunt
May 30, 2022 - I have completed this Secret Scavenger Hunt on May 30th and I enjoyed it!
Active LP-ers
Jan 9, 2022 - Which RUNE wallet addresses are the most active in updating their LP positions? Are they typically chasing the pools with the highest returns or is there something else that seems to be dictating their behavior?
Metamask vs. Other Platforms
Jun 25, 2022 - How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
Sushi Activity on Ethereum
Jun 29, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Average Price Shift for Synth Holders
Apr 11, 2022 - What is the typical price shift experienced by a synth holder? Compare the current price of the asset vs the price when they minted (relative to $RUNE).
Rand Gallery Wallets
May 25, 2022 - How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have 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 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 purchasing from rand gallery by ALGOs and number of NFTs
End of Year CEX Transfers
Jan 17, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.
Gas as a proxy of activity
Jun 7, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
ASA Dex Degens
Mar 24, 2022 - Chart the distribution of the number of swaps wallets have conducted in 2022 (Count the number of swaps a wallet has performed create a distribution of these wallets). Chart the distribution of the number of ASAs a wallet has swapped for (Count the number of assets a wallet swapped for and create a distribution of the number of assets per wallet).
Solport vs. Magic Eden
Apr 2, 2022 - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden? Solport is strongly connected to the NFT collection 'Taiyo Robotics', which incentivizes holders to increase Solport's adoption. Compare Taiyo Robotics sales on each marketplace. Do sellers care more about growing their own marketplace or capitalizing on the access to liquidity?
Average Age of Synth Holders
Apr 9, 2022 - Create a chart displaying how long synth holders keep their synth for. Ideal format is a bar chart of % of users, and # days holding for.
Symmetric vs Asymmetric LPs
May 29, 2022 - On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool?
Top Lido Stakers
Apr 25, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
Profit for AMMs
Apr 12, 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?
Trend of Pools
May 16, 2022 - What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
LBP Analysis
Jan 6, 2022 - Analyze the recent HaloSwap LBP event that concluded on 12/22/21. Provide summary metrics of your choice, as well as your assessment of the LBP as a fundraising mechanism for Angel and how it could improve.
Swap Increase on May 11 + 12
Jun 9, 2022 - On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened? What were users swapping from and to? Were users swapping from ALGO to stables? Was the average swap size bigger than normal? Is this tied to the price of ALGO? Help us understand what took place and why the volume and number swaps increased!
Rune Upgrades
Jan 8, 2022 - How many unique addresses have upgraded their rune in first week of 2022? How does that rate compare with the previous 4 weeks?
Vote!
Feb 13, 2022 - 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?