azerbaijan
User Activity
Jun 13, 2022 - Q2. 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.
Flow Scavenger Hunt: NFTs and FLOATS (May 24)
May 25, 2022 - my dashboard for Flow Scavenger Hunt: NFTs and FLOATS (May 24)
Algorand Free Square
Jun 28, 2022 - Q110. Time to get creative and explore! We want you to dig into a topic/project/protocol on Algorand that you find relevant and interesting and create an analysis around it. Bonus points for creativity and uniqueness! Feel free to check out the Algorand Ecosystem map for some inspiration: https://ecosystem.algorand.com/
Active Wallets on Terra
May 4, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022. I couldn't run my SQL so I am submitting this empty dashboard to check it again tomorrow
Applications on Algorand
Jun 29, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021?
NEAR Performance
Jul 20, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Wildlife Warriors NFT Drop
Jun 19, 2022 - Q105. 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. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs: -Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance? Tips: To look at the list of the asset_ids of the NFTs: select * from algorand.asset where asset_name like 'Warrior Croc%' and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = ‘SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')"
ETH Deposited or Withdrawn
Jun 26, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Getting Started With Solana Bounties (Farsi)
Feb 17, 2022 - در این داشبورد، من تراکنش استیک مرینید خودم را به عنوان بخشی از تمام تراکنش های استیک مرینید که درآن ساعت از روزی که تراکنش من انجام شد، روی نمودار نشان میدهم
Getting Started With Algorand Bounties
Feb 8, 2022 - I found all transactions staking YLDY that happened on the day and hour I did the Algorand Scavenger Hunt, and highlighted my staking transaction among all the others.
OSMO on Coinbase
Jun 1, 2023 - Let's measure the impact that OSMO’s listing on Coinbase had on token price, $OSMO transactions and the Osmosis chain statistics.
Anchor Scavenger Hunt (Vietnamese)
Jan 28, 2022 - Tôi đã gửi một số UST của mình để kiếm lợi nhuận
Total Metamask Users
Jun 24, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Voting Activity
Jun 19, 2022 - Q1. The Lil Nouns DAO is controlled via on-chain voting by token holders. Using the Ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Astroport Scavenger Hunt (Farsi) سواپ و تامین نقدینگی در آستروپورت
Jan 25, 2022 - این هانت شامل کد مربوط به مراحل سواپ یو اس تی به آسترو و اضافه کردن آسترو و یو اس تی به استخر نقدینگی میباشد
Mars Token Launch
Feb 15, 2023 - Background: This has been a big week for the bold – as Mars Protocol had their long awaited token launch and release of their Red Bank credit outpost on Osmosis! Let’s dig into the data and track Mars' performance this week. Task: Provide insights on the following core Key Performance Indicators: Total Unique Deposit Addresses Total & by token (OSMO, ATOM, axlUSDC) Total Unique Borrower Addresses Total & by token (OSMO, ATOM, axlUSDC) Deposit Volumes How long did each asset take to reach its deposit cap? % of time each asset has spent at its deposit cap Utilization Analysis How have utilization rates changed over time by asset? What is the current total utilization rate of the protocol? Loan Analysis Volume borrowed over time Volume repaid over time How many loans have been fully repaid since launch? How many users have 0% utilization rate Ratio of farmers to active borrowers? Fees What is the cumulative amount of fees bridged back to Mars Hub (in USD and MARS) MARS Trading info Pool #907 analysis