sallar
New DEX Users
Mar 29, 2022 - Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
stETH vs. ETH
Apr 2, 2022 - Q6. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Unique Users on Algorand
Apr 8, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
CowSwap - Market Mover?
Apr 21, 2022 - Q2. Use the Ethereum_core scheme. Has CowSwap shifted the token exchange market? Show the number of swaps that are done on CowSwap compared to other DEXs over the past several months. What DEXs are the users of CowSwap coming from?
CowSwap Sushi Activity
Apr 20, 2022 - Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
ASA Asset Transfers
Apr 8, 2022 - the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset
What Are Users Swapping gALGO3 For?
Apr 26, 2022 - gALGO3 is an asset that is pegged to ALGO. Users can lock their ALGO up on Folks.finance for governance and while their ALGO is locked they receive gALGO3 and it can used for other defi activities.
Staking GARD on Algostake
May 20, 2022 - Users can stake GARD on Algostake to earn GARDIAN, a token that will be used to redeem GARD governance tokens.
The Eclipse Score
Apr 24, 2022 - Invent an easy-to use ""Eclipse Score"", based on at least 3 metrics, to display validators who are not effectively representing their delegators via voting.
Solana Health in Bear Market
May 28, 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.
Most Popular ASA To Swap From ALGOs
Apr 12, 2022 - Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
Distinct Wallets (zkSync)
Jun 17, 2022 - distinct wallets that have deposited ETH into ZkSync in the last 60 days
SOL Staker Activity
Apr 13, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Flow Speed
Jun 4, 2022 - One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute.
Solana Scavenger Hunt 2.0 (Farsi)
Feb 10, 2022 - در این هانت با شبکه سولانا آشنا شده و مقداری سولانا را استیک کرده و ایجاد نقدینگی میکنیم
Stablecoin Popularity for Swaps
Apr 8, 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.
Where’s The Pot of Gold?
Mar 20, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is
Privacy Coins + Politics
Jun 11, 2022 - impact of major news events on number and amount of swaps to SCRT
RocketPool Recent Activity
Apr 27, 2022 - RocketPool is a decentralized ETH2 Staking application. Using RocketPool, users can either stake ETH or stake ETH and run a node. Users deposit ETH and mint rETH tokens. For users only interested in staking, the minimum deposit is 0.01 ETH and the rETH tokens are liquid. For users interested in running a node and staking, the minimum deposit is 16 ETH, but better rewards are received.
Miso's Competitive Advantage
Apr 22, 2022 - Q67. Create a visual document outlining the below facts about Miso, the new addition to the Sushi menu
Standardized TVL over time (all pools)
Apr 15, 2022 - Q64. Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
MNDE Locked In Governance
Apr 30, 2022 - Create a line chart showing the total amount of MNDE tokens locked in governance over time. What percentage of the current circulating supply does this represent?