vivianngdora
[1. [Easy] New Active Users]
Dec 12, 2021 - In the dashboard, I will calculate and visualize the total number of new users per day, which conducted transactions with ParaSwap over the past two months.
IL INSURANCE
Apr 11, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance?
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Inflows and Outflows
Sep 13, 2022 - What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
7. [Hard] ENS vs Gas
Dec 14, 2021 - ENS registration is cheap, but gas is not. Do more people register domains when gas is lower? Was there a spike in registrations when during recent ETH price dips?
Aave and stAave Movements on Ethereum Mainnet
Jun 4, 2023 - Creating visualizations depicting the daily, weekly and/or monthly movements of AAVE tokens on the Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and withdrawal activities, as well as the daily staking and unstaking of AAVE tokens.
5. [Easy] What are the most popular tokens on Harmony?
Mar 11, 2022 - Find the most interesting tokens on harmony and explain why they are most used tokens by providing insights.
$RUNE Movement from Crypto.com
Jun 19, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Active Addresses
Jun 8, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Monthly Swap Volume
May 11, 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?
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?
33. - Price Status Quo
Feb 2, 2022 - Does the price of the Sushi token tend to follow the trend of the rest of the market? Does the price follow the trend of the rest of the DEXs? Why or why not might this be?
Opening Positions
Jun 29, 2022 - Q1. Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
Outbound Traffic
Mar 15, 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?
Average Age of Synth Holders
Apr 13, 2022 - Q59. 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.
Polygon NFT
Jul 17, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
123. [Easy] Anchor Borrows and Deposits
Dec 29, 2021 - How have the average and total borrows and deposits on Anchor changed over time?
Untitled Board
Oct 20, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?