Yousefi_1994
Algofi Scavenger Hunt
May 17, 2022 - In this hunt, we learn how to swap some algo on other tokens in algofi, we also learn how to stack
📊 Analyzing Elliptic and BitOK Claims
Nov 1, 2023 - Can crypto-twitter OSINT outperform the WSJ’s chain analysis❓
Terra Bounties (Active Wallets on Terra)
Apr 29, 2022 - Description of work: In this question, we examine the active terra wallets by day, month and year, in the current year (2022) and try to draw analyzes on them. For active wallets, we can look at different Methods to determine if a wallet is still active. Example of a Methods for detecting an active wallet: `An active wallet is a wallet that has made at least one transaction in the last three months`. Terra is a proof of stake network (POS) where you can stake Terra's currency Luna to ensure network security. The next Method that can be used to determine active wallets is to first check the Terra stake table for transaction activity and then check whether the addresses that participated in these transactions still have their wallets (inventory). So let's do it
Lido - stETH vs ETH
Jun 8, 2022 - How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
MakerDAO Bounties (Collateral Impact)
May 15, 2022 - Description of work: we want find how does the volume on MakerDAO change as more collateral tokens are added to the platform? for address this question we first get daily volume mining for DAI and daily volume collateral on maker, then we compare the two for daily volume. Then we find the tokens that have the most impact on the maker volume ---> we used ethereum schema and ethereum.udm_events table for do this.
Nebula Scavenger Hunt
Apr 28, 2022 - These steps lead us to the DeFi star clusters in Terra. Once we've completed these steps, we will understand how to participate in a Liquidity Start-up (LBP) pool, which is an important way to distribute tokens in Terra projects.
Reactor Scavenger Hunt
Apr 28, 2022 - These steps lead us to the DeFi star clusters in Terra. Once we have completed these steps, we will learn how to participate in a Liquidity Trust (LBP) pool, which is an important way to distribute tokens on Terra projects.
Algorand - Wildlife Warriors NFT Drop
Jun 21, 2022 - Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife.
THORChain - Swaps to $THOR
May 27, 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?
Algorand - pNetwork Bridge Launch
Jun 23, 2022 - pNetwork is the first decentralized bridge to launch on algorand- it supports wrapped USDC, BTC, and USDT
Osmosis Scavenger Hunt
Jun 20, 2022 - Welcome to Osmosis! We hope this Osmosis Hunt will help you find an easy and enjoyable entry point into the ecosystem.
Sushi Activity on Ethereum
Jun 27, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
NFTx - User Activity
Jun 11, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
Kinetic Money Scavenger Hunt (Farsi)
Apr 28, 2022 - این مراحل شما رو با پروتوکل پرداخت وام خودکار معروف به Kinetic Money اشنا میکنه
Sushiswap Bounties (Sushiswap DEX Loyal Users)
May 6, 2022 - Description of work: Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX so ---> To address this question, we use the ethereum_core schema First step ---> Get all swaps on Sushiswap from `[ethereum_core.ez_dex_swaps]` table Second step ---> get the number of trades and number of days they in the Last month, Year and since inception`[ethereum_core.fact_transactions]` table. Last step: Find the how many users keep coming back to the platform (Sushiswap DEX Loyal Users). ---> My definition of Loyal Users: Among the addresses obtained, Loyal Users are addresses that have had at least one sushi swap trade in the past week. NOTE 1: For find Loyal Users, we filter all dates based on one week before the current date ---> `[block_timestamp < current_date - 8]`. NOTE 2: For a better comparison we have get the top 50 for wallet for each number of trades and number of days in he Last month, Year and since inception, because a large number of records are obtained in this question
Ethereum - USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Paraswap Bounties (New Active Users)
May 6, 2022 - Description of word: We want to get a unique list of new users transacted with Paraswap in the last two months so ---> To address this question, we use the ethereum_core schema First step ---> Find ParaSwap dex address from `[ethereum_core.dim_labels]` table Second step ---> We get all swaps made with Paraswap from `[ethereum_core.ez_dex_swaps]` table Third step ---> get all the previous wallets that transacted with Paraswap from `[ethereum_core.fact_transactions]` table. Last step ---> get the number of new wallets per day that have transacted with Paraswap in the last two months from `[ethereum_core.fact_transactions]` table.
Algorand Bounties (Algorand x Fifa Partnership)
May 8, 2022 - Description of work: part 1 ---> In this section, we get the number of wallets created per day from 2022-05-02 to 2022-05-07 and compare them. part 2 ---> in this section, we get ALGOs number of transferred per day from 2022-05-02 to 2022-05-07 and compare them. part 3 ---> in this section, we get Number of transactions per day from 2022-05-02 to 2022-05-07 and compare them. part 4 ---> n this section, we get Number of Sending ALGOs from centralized exchanges to onchain wallets per day from 2022-05-02 to 2022-05-07 and compare them. part 5 ---> in this section, we get Number of swaps per day from 2022-05-02 to 2022-05-07 and compare them.
Solana Bounties (Metaplex Bot Free)
May 6, 2022 - Description of work: Metaplex is a collection of tools, smart contracts, and more designed to make the process of creating and launching NFTs easier. While initially focused on supporting the needs of the arts and entertainment industry our plans extend far beyond that to all use cases where an NFT may add value. First step: ---> We want find how many bot transactions and thus how much SOL has Metaplex captured after April 29th. Second step: ---> We want to find the Bot tax that implemented by Metaplex on Bot mints. Last Step: ---> Display when these transactions occurred over time and if there were certain wallets that have been discovered to be guilty of botting the network.
Aave - Delegates' Gas Usage
Mar 22, 2023 - Aave Governance V2 is an exciting new evolution of on-chain governance, allowing unique features such as delegated voting and proposition powers, rapid protocol upgrades via short time lock executors, and governance upgrades via long time lock executors.
Terra Bounties Bots and success rate
Apr 23, 2022 - Description of work: step 1 : Get a list of bots - A robot address is detected when it has more than 15 to 20 movements per minute. Step 2: Find the list of successful transactions by bots. Get a list of successful user transactions. last step: compare bot ant user success rate
Terra Bounties (LUNA Market Cap)
May 6, 2022 - Description of work: Step 1: price -> To address this question, first in the terra.oracle_prices table by day for 30, 60, 90, past year and all time for LUNA, we get the average price on a daily basis and then left join results together. Step 2: market cap -> To address this question, we first obtain the total daily LUNA assets in the daily_balances.balance table. Then we get the average daily price for 30, 60, 90 days, past year, and the al time for LUNA, then LEFT JOIN the results together and calculate the MARKET CAP ---> JUST FOR THE LOVE OF THE TERRA PROJECT :((((((
Flow - User Behavior
Jun 20, 2022 - What are users swapping for? What activities are the most common for users on Flow right now?
Moonbirds Bounties (Unique Buyers and Sellers)
Apr 29, 2022 - Description of work: To address this question, we use the ethereum schema to achieve the results. The first step is to extract the list of contracts related to the Moon Birds project from the nft_metadata table. The second step is to review these contracts on nft_events, which we filter based on event_type = 'sale', and finally extract the list of unique buyers and sellers at intervals.
Algorand Bounties - The Octorand Universe
May 22, 2022 - Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.