misaghlb
ASA Dex Degens
Mar 20, 2022 - Q38. Let's look at DEX wallet behavior with the algorand.swaps table to get an idea of how many swaps wallets are being conducted and see how many ASAs wallets are trading.
Swaps to $THOR
May 26, 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?
ETH Deposited or Withdrawn
Jun 25, 2022 - Q1. Starknet is a layer 2 chain, like polygon, that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to starknet or vice versa? and by how many depositors?
Lido Rocket Pool Comparison
Apr 20, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool
CLUB Liquidity
Mar 15, 2022 - Question 2: What’s the liquidity of the CLUB token on decentralized exchanges? Analyze the trade volume on Uniswap, what is the largest trade? Did that trade affect the balance of tokens in the pool significantly?
Rand Gallery Wallets
May 22, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior.
Sushi Reward Program for Farmers
May 3, 2022 - list of eligible addresses with their total vested rewards as at Oct 22 2021 at 5:47 PM EDT .The reward program started on Sep 24th 2021
Kujira Scavenger Hunt (April 8)
Apr 8, 2022 - سواپ کردن به kuji - استیک کردن kuji - بید گذاشتن روی bluna
Katana wLUNA Pool
Feb 19, 2022 - Question: 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
Votes, Votes, Votes
Apr 22, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Top LDO Holders
May 31, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Top TOKE Holders
Jun 21, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
SUSHI Noobs II
Jun 19, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Who's That Going Across My Bridge (Redux)
Apr 18, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana).
Whale Swaps
Apr 30, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions?
RocketPool: User Profile - LIDO vs. RocketPool
Apr 23, 2022 - Q19. Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Bridge Volume (Optimism Bridge)
Jun 15, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Voting Activity
Jun 21, 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.