bababaoyu38
Standardized TVL over time (all pools)
Apr 17, 2022 - Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
NFDomains
Jun 23, 2022 - Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold
Getting Your Feet Wet, Part 2
Mar 5, 2022 - Question 161: Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis
CowSwap DEX Activity
Apr 19, 2022 - Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
UST Competitive Advantages
May 1, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
AlgoFi's AlgoVault Governance Period 3
Apr 18, 2022 - AlgoVault allows you to commit to Algorand Governance via the AlgoFi protocol. Let’s look at what users placed their ALGOs in the AlgoVault and Committed to Governance
Weighted-Average LP Duration
May 8, 2022 - Q70. What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Getting Your Feet Wet, Part 1
Mar 5, 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)
1M New Algorand Wallets In May
May 17, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
Top TOKE Holders
Jun 21, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
New DEX Users
Mar 29, 2022 - Q40. Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
The Typical Minter
Jun 9, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior? Submissions will be accepted until mint closes (48 hours), but to be eligible - tweet it out whenever you complete it. The top 15 submissions will receive .11ETH
HODL or Sell?
Jun 14, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Voting Activity
Jun 20, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant. Hint: Sample query to look at a Lil Noun vote select * from ethereum.core.fact_event_logs where block_number = 14887882 and tx_hash = '0x783d64b2146de10f7545e1053a6fa58d2846ee78fb5dc30ed635182ac5313e9b'
Market Module
Apr 3, 2022 - Q176. Explain in your own words what Terra’s “market module” is, and how it functions. Define at least two key metrics for the market module, and demonstrate how it’s performing in its stated goals based on these metrics.
SOL OpenSea vs Magic Eden
Apr 9, 2022 - Q53. OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time? Hint: you will need to use fact_events for OpenSea sales because the logic is not yet in the NFT table. Hint: OpenSea programId = hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk
Distinct Wallets (zkSync)
Jun 17, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day?
Hot Contracts on Osmosis
Jul 12, 2022 - Q20. A lot of new contracts are being deployed on Osmosis lately. Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
Pros of SOL
May 25, 2022 - Q78. Why should developers build on Solana compared to other L1 chains? What features for developers does Solana offer that make it appealing? Compare Solana in terms of transaction speed/throughput, user growth and activity, cost/fees per user, growth in defi and growth in nfts to at least two other chains. How are popular projects on Solana able to scale compared to top projects on other chains (for example a gaming app like StepN or a popular dex like Orca). How do you envision user growth of apps on Solana over time? What types of products seem to be positioned particularly well on Solana?
Fuse Pool Analysis
May 24, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Velodrome Health
Aug 16, 2022 - Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Head to Head
Mar 27, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
ETH Staked
Jun 14, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Gain or Lose
Jun 15, 2022 - aQ10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Magic Eden Whales
Apr 9, 2022 - Q50. Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like? Note that this question previously included 'NFT selling' as well. This part is now optional. Hint: Use fact_nft_sales
The Law Offices of NEAR
Aug 3, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
Daily Transactions and Unique Addresses
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Validator Pageant
Mar 14, 2022 - Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.
How Relevant is Justin Sun?
May 1, 2022 - Justin Sun has recently announced an algorithmic stablecoin, USDD, with 30% yield. Sun has announced plans to backstop USDD with $10B of crypto as collateral, matching the Luna Foundation Guard (LFG). Do a deep dive, conduct research, and provide a well-researched conclusion to the burning questions: is Justin Sun for real? Is USDD likely to accrue significant backing? How will its 30% offering fare over time?
Swaps to $THOR
May 27, 2022 - Q100. On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. Did we see a spike of swaps to $THOR around that time? Has there been any noticeable change in $THOR swapping since that event?
Cosmic Champs Token Launch
Apr 28, 2022 - Algorand based NFT Game Cosmic Champs have launched their project token $COSG. Let’s look at what users are doing with it. 1) Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends. 2) There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). Show how many stake actions a day are occurring. 3) Plot the staking amounts(the amount of $COGS staked) by day over time on a scatter plot. What types of trends do you see?
Tinyman Farming Pool Incentives
May 19, 2022 - Q71. Tinyman is currently offering incentivized LP farming on USDt/ALGO USDC/ALGO and USDC/USDt pairs(https://app.tinyman.org/#/staking) Show how these rewards impact the number of mints and burns of these pools compared to some of the other large pools on Tinyman. Also show how these rewards impact the number of mints and burns of these pools(before rewards and during).