jxboi
Contractually Obligated
Mar 10, 2022 - Question 162: Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
Solana Health in Bear Market
Jun 1, 2022 - Q80. Create a dashboard with at least 5 different metrics of your choosing showing Solana's health and adoption as a blockchain as market conditions have soured.
Head to Head
Mar 28, 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?
Unique Buyers and Sellers
May 3, 2022 - Are more people joining or leaving the Moon Birds community? Look at unique buyers and sellers over a period of time.
Safety Module Dashboard
Sep 27, 2021 - Question: Create a dashboard breaking down all of the components of and week-over-week metric changes of those components for the Aave Safety Module, including the amount of Safety Capital available, the distributions and APR of the respective staking pools, and comparison of these to the TVL and total borrows on Aave V1 and V2 over the past year.
Acquiring goBTC and goETH
Apr 4, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Uniswap - 1. Active AMM Users
Mar 17, 2022 - This dashboard will be showing number of active users (wallets) on Uniswap v2/3 and Sushiswap over the past year. We will be comparing two metrics - monthly unique active users - monthly transactions (swaps)
Terra LFG
Mar 11, 2022 - LFG mission was to build a promote a decentralized economy with the primary focus on Terra and its stablecoins primarily UST. Unlike collateralized stablecoins like USDT or USDC, UST maintain its peg through arbitrage incentives and open market operations which run the risk of depeg during extreme market conditions. To protect UST peg in these extreme conditions, LFG is establishing a decentralized UST Reserve Protocol. This reserve will act as a backstop for UST by swapping UST for other non-correlated assets like BTC in an event UST deviates from its peg.
Terra 2 Dashboard
Oct 15, 2022 - In this dashboard, we will look at various metrics using mainly data from terra.core.fact_messages and terra.core.fact_transactions table. The metrics are grouped into 3 categories 1. Transaction Volume & Fee 2. Transfers 3. Delegation
Defly Token Launch
Feb 6, 2022 - Chart the number of Defly Swaps by day on Tinyman What was the biggest swap for Defly on Tinyman? Chart the distribution of Defly among in wallets.
Lockdrops Keep Fallin' On My Head
Jan 22, 2022 - Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Active Wallets on Terra
May 5, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Optimism: User Behavior
Jun 24, 2022 - How is user behavior different on Optimism compared to L1?
Staking APY
Oct 12, 2021 - Select a time period (minimum 30 days) and break down staking returns into their component parts. How much of overall staking yield comes from airdrops historically? How do you expect this to change between now and year's end?
Paraswap Monthly Swap Volume
Dec 12, 2021 - 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?
141. Staking Yield, Mvmt. II: Anchor
Jan 29, 2022 - Imagine it is February 20 and the Anchor yield reserve has reached 0. Using data to support your answer, assess what the APY on Anchor Earn would be, based on LUNA staking yield and ANC incentives. How might this compare to stablecoin yields that are currently available from other protocols (not limited to Terra)?
Uniswap - 3. Unisocks NFT
Mar 17, 2022 - This dashboard will look into the price of SOCKS over time as well as the return on investment of SOCKS if we bought SOCKS before Jan'21.
![[Loop] Airdrop Actually Claimed](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675644046/https://next.flipsidecrypto.xyz/previews/dashboards/ee36060b-f47d-4710-aa1d-5301c18e3c3d%3Ftype%3Dcover "[Loop] Airdrop Actually Claimed")
Transactional Nature
Mar 31, 2022 - Q171. In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps.
Chai Volume
Sep 12, 2021 - Has the volume of Chai being transacted with changed over the past 6 months? Provide visualizations as well as analysis to explain the patterns of how Chai's volume has changed over time.
A World Without Anchor
May 5, 2022 - This dashboard will attempt to paint a world without Anchor and the imagine the impact on Terra ecosystem including User and UST growth.
Dodge, Duck, Dip, Dive and $DOGE
Jan 22, 2022 - What % of the swaps made this week involved $DOGE?
When Do Transactions Fail?
Jan 16, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
The call is coming from inside the house
Dec 13, 2021 - This dashboard aims to answer the question if the price jump of $ SUSHI on December 8th was driven by dex trades (as opposed to off-chain trades) by looking at trades in any SUSHI/WETH, SUSHI/USDC and SUSHI/USDT pools on Uniswap and Sushiswap on that day.
Daily bETH Volume
Oct 9, 2021 - What is the daily volume of bETH bridged from Ethereum to Terra using Lido? Has there been an increase leading up to Columbus-5? What is the daily volume of bETH bridged from Terra back to Ethereum?
Validator Pageant
Mar 13, 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.
Fuse Pool USDC Allocation
Mar 20, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Liquidation Risks
Dec 24, 2021 - This dashboard will explore the worst-case scenarios for liquidation on Anchor. When have the most liquidations occurred, how much, and how many users were impacted?
1. Weigh Anchor (Users)
Jan 8, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry? Note: you may define “top user” as you wish, but your definition and results should be defensible using data and at least one visualization.
