azerbaijan
Spectrum Scavenger Hunt (Mandarin)
Jan 27, 2022 - 寻宝包括:为ASTRO-UST矿池提供流动性,用SPEC代替UST,向治理组织质押SPEC
NEAR Meta-Analysis
Sep 14, 2022 - Take a look at the winning submission to our NEAR Tournament, as well as the three runner-up submissions (links can be found below). Craft your own remix to these dashboards, analyzing and summarizing the most important points in a single easy-to-view dashboard, with your own original commentary.
$ARB DAO Allocation
Mar 27, 2023 - 1.13% of ARB Allocations have been sent to DAOs within the Arbitrum ecosystem. If you were the Arbitrum Foundation, how would you allocate these tokens across DAO users, and why? First analyze the top DAOs within the arbitrum ecosystem. Then, provide reasoning through on-chain data as to why they should receive an allocation and how much?1.13% of ARB Allocations have been sent to DAOs within the Arbitrum ecosystem. If you were the Arbitrum Foundation, how would you allocate these tokens across DAO users, and why? First analyze the top DAOs within the arbitrum ecosystem. Then, provide reasoning through on-chain data as to why they should receive an allocation and how much?
NEAR Gas Guzzlers
Jul 26, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Kujira Scavenger Hunt (Mandarin)
Jan 29, 2022 - SQL Code of: 从 UST 置换成 KUJI 质押KUJI 将 UST 存入 Kujira Orca 以竞标清算
Terra - 13. Terra Grants Funding
Feb 16, 2023 - Examine grants funding since the launch of Terra 2. If possible, identify the grants transactions (feel free to supplement this with off-chain research to identify who’s been funded and in what amounts). Based on your investigation, produce a simple, clean dashboard that tracks grant funding thus far on Terra 2.
Solana Scavenger Hunt 2.0
Feb 11, 2022 - Set up a Phantom Exchange Wallet and fund it with SOL Stake SOL via MonkeDAO’s DAOPool to receive daoSOL Stake the daoSOL on Saber Stake LP on Saber
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)
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
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.
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.