anniecrypto
AAVE and stAAVE movements
Aug 8, 2022 - Create visualizations showing the following: * Daily AAVE supplied and withdrawn on Aave protocol. * Daily AAVE staked and unstaked.
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
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/
UNI Market Correlation
Apr 2, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
Uniswap - 24. Marketing Analytics - Monthly New Users
Apr 9, 2022 - Is Uniswap attracting new users? Using the last twelve months of Ethereum data, visualize the number of monthly new users onboarding to Uniswap. Definitions: -New users are addresses that have never used Uniswap before. -Onboarding to Uniswap means making any type of transaction on the protocol.
Head to head
Mar 31, 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?
3. Active Wallet Growth - Annie
Feb 3, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Question 148: Anchor Dominance
Feb 16, 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
9. Claimed Token Distribution
Dec 21, 2021 - The below dashboard will average amount of ENS claimed from the airdrop and visualize the difference in size distribution by a histogram.
Q169: Transaction Failure
Mar 25, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 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. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Bot Swappers
May 3, 2022 - - Define bot swappers. - How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. - What percentage of swaps were executed by bots in the past 30 days? - What pools and what pairs were most popular among bot swappers in the past 30 days.
Monthly Swap Volume
May 12, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing.
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?
Market Value <> Holders Overtime
Apr 16, 2022 - Does the market value of OlympusDAO correlate with the number of OHM holders?
$RUNE Movement from Crypto.com
Jun 20, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends? Hint: use thorchain.transfers (crypto.com = thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6)
10. [Hard] New vs. Existing Holders
Dec 21, 2021 - What has grown more since the airdrop, the number of unique wallets creating a domain for the first time, or the number of wallets adding additional domains? What do you expect to grow more over the next 6 months? Provide at least one visualization to support your thesis.
Overtime Markets - Profitable Traders
Aug 23, 2022 - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport? The dashboard will: - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. - Calculate the amount of profit gained by these wallets. - Identify top 5 games creating the most profit. - Identify top 5 games attracting the highest number of users.
Untitled Board
Oct 29, 2022 - Welcome to Axelar! What better to way to get used to Axelar data than to analyze how people enter the ecosystem? With that in mind, analyze the activity that occurs on Axelar's Satellite Bridge. Since inception, what are the top paths over Satellite. by volume and $ amount? What is the most used token to transfer (USDC, wETH, wAXL, etc.)?a Top analyses will show bridging activity since inception and analyze how that has changed over time.
MonkeDAO Validator
Feb 19, 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.
Failed or not ? - Harmony blockchain
Mar 11, 2022 - Create a visualization about the total transaction daily on harmony blockchain and show the success rate for transactions and compare it with others networks
Bentobox Stats
May 15, 2022 - "Answer the following questions about Bentobox. Ideally on both ethereum and polygon. - What's the average deposit size per user in 2022? compare with 2021? -What is the average number of coins deposited per user? For this question you can ignore deposits of less than $50 USD."
Question 41: 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.
Votes, Votes, Votes_not used
Apr 23, 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?
Secondary Sales Activity
Jun 22, 2022 - Q2. 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.
32. - Whales Comin’ and Goin’
Feb 3, 2022 - Define a whale. Show the number of whales leaving liquidity pools on Sushiswap each day over the past 2 months. Do the same for the number of whales entering liquidity pools
Daily Transactions and Unique Addresses
Jul 12, 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.
Staking Yield
Jan 19, 2022 - How Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Polygon Block Performance
Jul 28, 2022 - What is the average time between blocks on Polygon?
123. Anchor Borrows and Deposits
Dec 29, 2021 - Question: How have the average and total borrows and deposits on Anchor changed over time?
stETH/ETH Fluctuation
Jun 14, 2022 - Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, Curve stETH/ETH pool composition, etc.