jackguy
Mirror & Anchor TVLs
Aug 1, 2021 - How have the TVLs on Mirror and Anchor changed over the past two weeks? Are there any correlations that you can see? What might be some reasons for these relationships?
Examining Loop Liquidity
Jan 24, 2022 - Visualize decentralized exchange (DEX) pools on LOOP (ex aUST/UST) vs Average # of liquidity positions on Loop DEX. Display the mean, median, and mode….3 separate graphs. The goal of this graph is to tell us: For wallets that have UST/aUST liquidity positions, how many other positions, on average, do these wallets also have on the DEX? If we can see mean, median, and mode, we can determine data skew from outliers
Governance Reaction to Terra
May 22, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
$RUNE Price vs Swapping Volume
Jan 21, 2022 - Is the price of $RUNE correlated with the swap volume currently happening on THORChain? (e.g. if swaps go up, does the $RUNE price also go up with it?)
Post Airdrop Behavior
Dec 6, 2021 - What percentage of claimed ENS has remained in their original wallet? What % of the total airdropped ENS has been claimed on each day? Lastly, are top ENS airdropped wallets more likely to sell or hold their ENS than the average wallet?
Sankey Swap Diagrams
Dec 13, 2021 - roduce a Sankey chart of the most common swaps. Velocity doesn’t currently support Sankey charts, so feel free to get creative with how you produce them!
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 21, 2022 - Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. This strategy’s overall return depends on how often the call options are exercised, i.e. how often LUNA ends up above the strike price of the option.
Thorra-Luna-UST
Apr 18, 2022 - How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? How do the fees generated from these pools compare to other pools?
In The Stars
May 30, 2022 - Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. Does the volume of swaps involving Stars change around this time? Analyze the volume of swaps involving STARS from March 20th until present.
Weighted-Average LP Duration
May 2, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
Randomearth marketplace
Oct 20, 2021 - This dashboard shows how the release of Galatic Punks was the start a boom in NFTs on the Randomearth marketplace.
Sushi on Polygon
Mar 23, 2022 - What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Delegator Delegation Distribution
Aug 21, 2021 - What is the average and median number of validators that delegators delegate to?
AlgoFi's AlgoVault Governance Period 3
Apr 24, 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
IL Insurance
Apr 12, 2022 - What % of users that are removing liquidity are receiving IL insurance?
Sushiswap Transaction
Aug 30, 2021 - Over the last 30 days, find SushiSwap transacters from the dex_swaps table. How many of these addresses also exist on Polygon, and have swapped with SushiSwap there? Compare the average fees paid per swap for these addresses on Ethereum vs. Polygon.
Failed Transactions
Dec 24, 2021 - What is the success rate of an ENS claimed transaction (i.e. how often have transactions not failed)? How much in fees have been lost in failed transactions attempting to claim the ENS airdrop?
Foundation Mint and Sales
Apr 21, 2022 - Using the Ethereum_core schema, analyze mint and sales activity on the Foundation platform over the past 3 months. How does the token transfer volume on foundation compare to that of OpenSea Shared Mints?
Acquiring goBTC and goETH
Apr 7, 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.
User Journey and Outflows
Nov 13, 2021 - Show the number of users leaving the Sushi ecosystem every day (haven’t made a transaction in over a month and have no liquidity provided). Where are these users going? Why might users be leaving Sushi for other protocols?
Node Churning Events
May 7, 2022 - In the THORChain ecosystem, a "churn" happens when one node goes from "Active" -> "Standby" or "Disabled" and another goes from "Ready" -> "Active". Show the cadence of node churning events over time.
Monthly Swap Volume
May 11, 2022 - 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?
Crypto-Cosmology, Part 1: Wormhole
Nov 14, 2021 - As Wormhole has added Terra support with the Columbus 5 upgrade, analyze the initial activity: how many users are engaging, what tokens are they receiving vs sending? Which destinations/sources are most popular? What is the adoption rate, i.e. how rapidly are users choosing to use Wormhole over the Terra-specific Bridge? Anything else you observe of interest?
Galactic Punks New User Onboarding
Oct 16, 2021 - How many users joined Terra just to get involved with GP? Example - deposited UST/LUNA/asset and one of their only/first transactions was minting/buying/trading GPs? What else have they gotten involved with since?
Inflows and Outflows on Polygon
Aug 20, 2021 - What is the volume of ETH and a stable coin of your choice that's moved between the Polygon network and the Ethereum network across the bridge? How has that changed over time?
CRV Deposits Over Time
Feb 18, 2022 - Show the deposits of CRV over time by unique wallets; unique users; and total amount
Saber and daoSOL
Feb 18, 2022 - Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? How many unique wallets have added liquidity to that pool since February 1st? Create a visualization showing liquidity trends with this pool.
Yet Another Acme Question
Apr 22, 2022 - Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version.
New NFT Mints
May 16, 2022 - How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum?
Liquidity Journey
Dec 17, 2021 - How does capital move across the Stader ecosystem? When a user deposits money into the Stader ecosystem, what do they do with it? What do users do with their LunaX tokens?
Price + Circulating Supply
Jun 4, 2022 - Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Tracer Voters
Feb 27, 2022 - How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX
Meteors, Eggs, and Dust, oh my!
Dec 16, 2021 - -How many unique owners are there for Meteors -How many unique owners are there for Eggs? -How many unique owners are there for Dusts?
Anchor Dominance
Feb 13, 2022 - 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?
Revenue Distribution
Dec 25, 2021 - How much revenue has been generated from ENS name registrations since the airdrop? How much revenue has been generated from ENS name renewals since the airdrop? Create at least one visual depicting the relationship between these two revenue streams. How do you expect this dynamic to change over the next two years.