Yousefi_1994
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.
Ethereum - Total Metamask Users
Jun 25, 2022 - 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?
Analysis of Active Users in Flow
Apr 14, 2023 - Daily active users (DAUs) are important in blockchain because they indicate the level of adoption and usage of the network on a daily basis. A high number of DAUs suggests that the network is being widely used and trusted, which can increase the value and utility of the underlying cryptocurrency. Additionally, DAUs can provide insights into the network's performance and capacity, as a high volume of transactions being created by its active users can put a strain on the network's resources.
StarkWare - ETH Deposited or Withdrawn
Jun 30, 2022 - 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
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?
Algorand Bounties (Pricing ASAs)
May 8, 2022 - Description of work: part one ---> to address this part of the table algorand.prices_swap, we perform the calculations on 25-04-2022 at 12 o'clock part 2 ---> to address this part of the table algorand.prices_swap, we calculate volume, highest average volatility and most swapped in the last 90 days for each ASA'S
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.
Terra - Governance Grind
Jan 22, 2023 - As Terra 2.0 has expanded, we’ve seen a number of governance proposals come to light.
🔵 Euro Stablecoin on Avalanche
May 30, 2023 - Euro Coin, or EUROC, is a euro-backed stablecoin that’s accessible globally on Ethereum and Avalanche. Similar to USDC, Euro Coin is issued by Circle under a full-reserve model. Designed for stability, Euro Coin is 100% backed by euros held in euro-denominated banking accounts so that it’s always redeemable 1:1 for euros.
NEAR - Tracking MarketingDAO Grants
Feb 3, 2023 - The NEAR MarketingDAO is in need of a grants tracking dashboard to better monitor the outcome of grant requests from their treasury.
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.
Sushiswap Bounties(Trident)
Apr 29, 2022 - The Sushi Next Generation AMM: Trident Description of work: In this article, using search and research on trident, we examined how it works and its features and compared it with other products on Defi.
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.
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