yonus
ETH Staked
Apr 2, 2022 - Q5. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Luna price vs Terra usd supply
Dec 6, 2021 - Build a dashboard that monitors and evaluates the relationship between Luna price and UST supply. Tell us what insights your visualizations provide.
Solport vs. Magic Eden
Apr 2, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden? Solport is strongly connected to the NFT collection 'Taiyo Robotics', which incentivizes holders to increase Solport's adoption. Compare Taiyo Robotics sales on each marketplace. Do sellers care more about growing their own marketplace or capitalizing on the access to liquidity? Hint: Use solana.fact_nft_sales and solana.dim_nft_metadata Hint: ME V2 programId: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K Hint Solport programId: SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj
The Red Planet
Apr 3, 2022 - Q174. Define and assess two key metrics for the performance of Mars Protocol since launch. How is Mars doing, according to these metrics? Some example key metrics include: number of depositors and borrowers net LUNA and UST deposited and borrowed
2. [Easy] Active Weekly Users
Dec 4, 2021 - Here is the number of unique addresses who have transacted ORCA.
Secret of Ens Airdrop
Dec 13, 2021 - Look at ENS registrations before and after the cutoff date for the airdrop. Do you notice anything suspicious that makes you think that some people knew the airdrop was coming?
SOL OpenSea vs Magic Eden
Apr 10, 2022 - OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
Collateral Impact
May 18, 2022 - Q2. How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
LP participation
Dec 13, 2021 - bounty question: How many RUNE addresses are currently providing liquidity in 1 pool? 2 pools? 3+ pools? Hint Use thorchain.liquidity_actions
ENS Histogram of claiming airdrops
Dec 20, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
ENS vs GAS
Dec 13, 2021 - ENS registration is cheap, but gas is not. Do more people register domains when gas is lower? Was there a spike in registrations when during recent ETH price dips?
Hop Bridge Volume
Apr 22, 2022 - Q11. How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop? Use Ethereum_core schema. Hints: contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 Event name that sends token from user's wallet to the bridge is 'Transfer' Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
1. [Easy] Airdrop Stats
Dec 5, 2021 - eligible account to receive airdrop, are about 137,000 accounts, and 89,838 accounts claimed their ENS airdrop till now, which is 69.22% of total 25M ENS for airdrop.