rajs
Untitled Board
Nov 4, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time?
Pricing ASAs
May 10, 2022 - Finding a market price for ASAs (Algorand Standard Assets) can be difficult at times due to the lack of prices being listed on sites like CoinMarketCap or CoinGecko. Part One: Using the Price Swap table, pick a single day in the last 30 days and find the top 5 most and least expensive ASAs Pick an hour in that day and visualize the distribution of prices across all ASAs for that hour. Tip: filter the results by SWAPS_IN_HOUR to only include ASAs that had at least one swap in that hour Part Two: Find the top 10 ASAs by volume in the last 90 days using the VOLUME_USD_IN_HOUR. Which had the highest average volatility? Which was the most swapped? Tip: Take a look at the other numeric measures, outside of the price, within the Prices Swap table
Inflows and Outflows
Sep 12, 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?
ZK Sync Bounties - Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
OlympusDAO - 25. OlyZaps!
May 19, 2022 - With OlyZaps, users can trade any asset for staked OHM (sOHM). Show the weekly number of OlyZap transactions. What is the weekly amount of sOHM that was acquired using OlyZaps?
Sushiswap DEX Loyal Users
May 12, 2022 - Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. How many users keep coming back to the platform ? Use different frequencies for the ranking : Last month, Year to date and since inception
Untitled Board
Oct 18, 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?
Pool Together Bounties - USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
1M New Algorand Wallets In May
May 16, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
NFTx Bounties - Highest Sales Volume
Jun 10, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT. Hint: You can find these sales in ez_nft_sales. Visualize your findings.
Flow - NFL All Day Tournament [Round 1]
Sep 14, 2022 - Welcome to the NFL All Day Tournament! For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats. Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position, and see if there are any notable spikes in sales so far this preseason.