Yousefi_1994
Algorand - Algofi Recursive Borrowing
May 22, 2022 - Letβs look at AlgoFi Recursive borrowing! This is where you supply the same asset you borrow
Algorand - New Wallets In May
Jun 16, 2022 - How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
Terra - Governance Grind
Jan 22, 2023 - As Terra 2.0 has expanded, weβve seen a number of governance proposals come to light.
Flow Speed
Jun 2, 2022 - One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute.
ZK Sync - ERC20 Tokens
Jun 17, 2022 - Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
ECO - Daily Transfer Volume
May 23, 2023 - Eco is a decentralized currency enabling a new type of Economy β one that works more transparently and in our collective best interest. Itβs the combination of something old β the ambition of building a better currency β and something new β the technology for currencies to be managed independently by their communities.
NEAR - Social Dashboard
Mar 6, 2023 - Near Social is a social data protocol built on top of NEAR Protocol. Near Social started with a centralized (federated) social network based on mastodon.social. Using near accounts names as credentials for the mastodon instance. In this dashboard, we will review Near Social
THORChain - New User Onboarding
Jun 28, 2022 - When a new wallet gets created, where are they first getting their $RUNE? Is it from a direct transfer? Or from a centralized exchange? From a $RUNE upgrade from BNB.RUNE or ETH.RUNE? Or from a swap from another chain's asset to $RUNE? If it's a swap, which chain / asset are they coming from? Are there any trends over time you can see?
ECO: Unveiling Token Emissions and Holding Wallets
May 31, 2023 - This dashboard provides you with real-time insights into the Emissions, Holding Wallets and Transacting Wallets of the ECO token, a decentralized currency designed to create a transparent and collectively beneficial economy.
Algorand - 2022 Yieldly Staking Pool Analysis
May 19, 2022 - Let's get a better understanding of the YLDY staking pool usage in 2022.
Algorand Week: Gard + Yieldly (Staking GARD on Algostake)
May 19, 2022 - Users can stake GARD on Algostake to earn GARDIAN, a token that will be used to redeem GARD governance tokens.
Juno Scavenger Hunt
May 28, 2022 - Welcome to Juno! We hope this Juno Hunt will help you find an easy and enjoyable entry point into the ecosystem.
Osmosis - Privacy Coins and Politics
Jun 14, 2022 - Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
Sushiswap Bounties (Market Volatility)
May 20, 2022 - The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety.
New Wallets from NFTs
Jun 10, 2022 - Letβs look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets. For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO and wallets created in May and June with >1 ALGO. Also note we only want to look at arc69 NFTs
Ethereum - Top TOKE Holders
Jun 22, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Algorand - Rand Gallery Wallets
May 20, 2022 - Letβs look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior
Algorand Week: DEXs (Tinyman Farming Pool Incentives)
May 16, 2022 - Description of work: Tinyman is currently offering incentivized LP farming on USDt/ALGO USDC/ALGO and USDC/USDt pairs. The Tinyman Staking program started on March 10th. Our goal is to compare the impact of the Tinyman Farming Pool from the start to the present on mint and burn on the three USDt / ALGO USDC / ALGO and USDC / USDt pair pools and before. Also compare these three pools with the large pools on tinyman. Finally, consider its effect on the number of wallets and liquidity. NOTE ---> we use [algorand] schema, [account_asset and application_call_transaction] tables.
Algorand - Letβs look into wallet activity with regards to Algorand NFTs.
May 29, 2022
THORChain Bounties (Net Synth Amounts)
Apr 28, 2022 - Description of work: For the first step, for each asset and blockchain, we calculate the amount of burns and mints separately. In the second step, we calculate the net_synth_amount value for each asset and blockchain, and in the last step, we compare each net_synth_amount value for each asset and blockchain.
MakerDAO Bounties - DAI Volume
May 15, 2022 - Description of work: In this question we want calculate daily volume of DAI transactions and compare to other stablecoins. also we want to know what DAI is used for the most. we use `[ethereum_core]` schema `[ez_token_transfers]` and `[fact_event_logs]` tables to do this