jackguy
Looking For Swap Arbitrage
Mar 31, 2022 - Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current.
Top Anchor Users
Dec 20, 2021 - Explore the power users of the Anchor Protocol. Define “power user” according to at least two metrics of your choice, and analyze Anchor users based on these metrics. Are they retail investors? Whales? Do they transact regularly or infrequently? What conclusions can we draw from your explorations?
Realized APY
May 15, 2022 - Visualize the realized APY of LP-ers that have removed liquidity from THORChain. What was their actual APY vs HODL (accounting for impermanent loss) when you pro-rate it for how long they were LP-ing for? Are certain pools out-performing others?
Lido's stETH's effect on Terra
Oct 8, 2021 - A sizable proportion of the stETH minted has been sent to the terra and converted to bETH. This bETH is being used as collaterall for borrowing UST on the Anchor protocall. In this dashboard we are going to look at how much stETH is being sent to terra and where is it being used on terra.
Swaps to $THOR
May 29, 2022 - 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?
Head to Head
Mar 28, 2022 - 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?
Guzzling Gas
Dec 20, 2021 - When do LPers decide to pay the gas fees and take profits? What percentage (and how much) of profits usually get eaten up by gas fees?
TVL Sushi vs. Uni
Feb 13, 2022 - Show the daily Total Value Locked (TVL) on Sushiswap over the past 3 months. How does this compare to the daily TVL on Uniswap over the same time period?
User LP Inflows
Nov 21, 2021 - Show the number of users entering the Sushi liquidity pools every day for the 90 (provided liquidity for the first time).
Galactic Punks Traders & Collectors
Oct 15, 2021 - How many unique GP holders are there, currently? Of these holders, what is the breakdown on the number of punks they have? Who are our frequent traders?? Define frequency if your own words.
Whale Swaps
May 4, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions? Hint: you should use parameters. you can set X as $150,000 by default.
Stability Fee
Jan 19, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
NFT Mint Sweet Spot
Apr 19, 2022 - Compare the mint price of popular Solana NFT collections to their resale price. Is there a ‘sweet spot’ for Solana NFT mint prices that fetch higher percentage returns on the secondary market? Do collections that cap the number of NFTs a wallet can mint have higher returns?
Transaction Fees Per Asset
Nov 26, 2021 - What is the average transaction fee per asset (not fees charged by pools) ? Have these changed in the last 30 days
Pool Parameter Differences
Aug 28, 2021 - than one pool on Uniswap (the pools have different fees and tick spacing), what is the TVL for each of the pools?
USDC, USDT, UST on Jupiter
Mar 5, 2022 - Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to).
Fuse Pool DAI Allocation
Mar 23, 2022 - How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Katana Covered Call Vault Popularity
Mar 28, 2022 - Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?
Forefront Curators
Mar 30, 2022 - Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? In your own words, how could Forefront incentivize growth in curator roles?
Burn bLuna Burn
Jul 1, 2021 - Using Anchor, there are two ways to burn your bLuna to redeem your Luna. "Burn" utilizes the bLuna protocol and uses the current exchange but requires 21 days, and "Instant Burn" utilizes TerraSwap which has no time lag but might suffer trade slippage and Terraswap commission. In the past 30 days, what is the ratio of Instant Burns to Burns?
Pool Sizes
Oct 30, 2021 - What is the volume of each pool by TVL? How does that compare to the depth of each pool in terms of the unique number of liquidity providers?
[redacted] Cartel
Feb 11, 2022 - Explore the [redacted] cartel; how much CRV and CVX has it accumulated? Provide & support a thesis for what role it might play in the Curve Wars.
Fault Tolerant Staking
Apr 13, 2022 - Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
HALO Distribution Analysis
Dec 4, 2021 - Analyze the wallets who used the Apollo/Angel farm. How many wallets participated? How much HALO was farmed during each day over the course of the farming event? How did the total volume change over the course of the farming event? Provide visualizations to support your answers.
Trend Analysis
Apr 3, 2022 - Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
USDC Transfer Volumes
Apr 14, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
Terra vs. Ethereum Stablecoin Volatility
Jul 25, 2021 - Compare the price of the UST tether pool on Uniswap V3 (use the uniswap_v3.pool_stats) against the UST oracle price on Terra.
Sushimaker
Apr 26, 2022 - The Sushibar is always served with fresh SUSHI from a contract that is called Sushimaker. Describe the role of sushimaker and say how many SUSHI's it serves to the sushibar per day. Also compare the amount of sushi that is being staked by users with the amount of sushi that is being served by sushimaker.
Curve Overview
Sep 18, 2021 - In this dashboard, I will give an overview of the Curve Dex swap. Some of the metrics considered when looking at a dex swap genrally, and the prevalence of whales on Curve.
Wallets With Balance
Mar 5, 2022 - Display the number of wallets with >0 balance (as of current date; show change over a time period of your choice, minimum last 7 days)
Airdrop Summary
Oct 11, 2021 - For the last 90 days, summarize the following about airdrops being claimed by addresses in the Terra ecosystem:
Stablecoin Popularity for Swaps
Apr 7, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
Claimed Token Distribution
Dec 21, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Gas as a proxy of activity
Jun 5, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?