amir007-Q63RX1
ETH and BTC sell-off
May 1, 2023 - It was reported in the news that some wallets with high balances have transferred Ethereum to CEX to sell them. This news caused the price of Bitcoin to fall. Many sources consider the reason for this to be the Arkham alarm, which mistakenly warned large investors. In this dashboard, we will examine the truth!, whether the news was published correctly and what effect it had on the price of Bitcoin.
Gaming on Sol
Feb 9, 2023 - According to Spire, gaming has been picking up on Solana https://twitter.com/voteforpedrito/status/1620886335937708032?s=20&t=cOIVO1EtSx4F4dkzNT78iA Between Star Atlas, Genopets, and Aurory, games are beginning to allow users to experiment with what they have been building over the past year and a half. Create a dashboard showing user activity and growth of these three games. Is there any crossover between these three games in terms of users or does each game seem to have its own fan base? What is the profile of gaming users on Solana? What types of activities are these users doing within the games and within the Solana ecosystem?
Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge.
Uniswap Monthly New Users
May 16, 2023 - Uniswap has been operating as one of the most famous DEXs in the cryptocurrency world for several years now and has released its native token called UNI. In this dashboard, we discuss the growth or decline of new users on this platform.
Polygon Block Performance
Jul 24, 2022 - Block Performance on blockchains (Polygon, Solana, Flow, Arbitrum, Optimism)
Continued Growth?
Jan 28, 2023 - In recent years, various networks entered the blockchain technology and achieved success in different periods of time and have taken action to attract more investors. Although the Tera network was a bitter event for the crypto world, the emergence of new networks indicates the promising future of blockchain. Each of the networks has entered the crypto world with different features and characteristics. Three lovely networks Polygon, Optimism and Arbitrum with their unique features are currently operating. In this article, we will examine the rate of growth of each of their parameters and we will examine them with various comparisons in order to finally compare their status compared to year 2022 and see if this growth has continued or not.
Avalanche Gas Fees
Mar 29, 2023 - In this dashboard, we will review Gas Fees on the Avalanche network. Which contracts have the most gas and which dApps have paid the most gas fees to the Avalanche network. By default, the last 180 days are checked, which can be changed and adjusted.
Exploring 'ez' Tables Part 2
Feb 6, 2023 - Description: Using the table ethereum.core.ez_nft_mints, select one or a few recent project mints and determine how “successful” they were. How success is defined is up to you! You could look at: volume of ETH spent, number of NFTs minted, unique addresses minting the project, fees spent in ETH by minters. For some above and beyond work, follow the project in the ethereum.core.ez_nft_sales table - how did the project fare post-mint? Finally, for a challenge one could look to ethereum.core.fact_transactions or ethereum.core.fact_event_logs for failed mint transactions. Was this a popular project? Did users burn ETH trying to mint, only to have their transactions fail? What advanced insights can we derive by going directly to the transactions?
USDC Deposits into PoolTogether (Ethereum)
Jun 22, 2022 - PoolTogether is a crypto-powered savings protocol based on Premium Bonds. Save money and have a chance to win every week. (https://pooltogether.com)
Distinct Wallets (zkSync)
Jun 16, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design.
ERC20 Tokens (zkSync)
Jun 16, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design.
Exploring the ARB Token on Osmosis DEX
May 24, 2023 - After the ARB token was listed in Osmosis DEX, we saw various activities on this token. Swapping and using Liqudity Pool along with OSMO token along with incentive prizes has been a feature of Osmosis DEX. With a closer look, we will get good statistics about it.
Angel has risen
Dec 23, 2021 - In crypto we can allocate the small remaining amount of each transaction to Angel List of addresses that have been donated to Angel in 2021:
Loop Airdrop
Oct 30, 2021 - New Season: 7oct-28oct 2021, Wallet addresses have provided liquidity to the Loop Protocol between the 7th and the 28th of October (UTC). We are rewarding a total of 2M LOOP to these people calculated daily over the 22 days. 137 contract address are lucky in this season. We pay reward base on 20 days because 2 days of this period has not any transaction! 100k LOOP for every day.
Bot Swappers
Apr 27, 2022 - The detection of bots and the function of hunters can be detected by Artificial Intelligence (AI) and the study of human behavior. In this regard, by focusing on the execution time of transactions, it is possible to prove the existence of bots to some extent.
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?
NEAR Protocol or Project Dashboard
Apr 12, 2023 - Burrow is a decentralized, non-custodial pool-based interest rates platform that enables users to supply assets to earn interest, and to borrow against them to unlock liquidity. Burrow is similar in nature to Aave, Compound, and other pool-based protocols. Burrow runs natively on the NEAR blockchain, a layer 1, proof-of-stake, sharded blockchain with a WebAssembly runtime. The Burrow protocol's smart contracts are written in Rust.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
Task 1 - eth2 stakers
Dec 30, 2021 - Description: Pull list of addresses that directly staked 32 eth for eth 2 Relevant contract: 0x00000000219ab540356cBB839Cbe05303d7705Fa Complications: filter for staking pools Deliverable: script to pull addresses & list of addresses
HODLers vs LPers vs Stakers
Jul 12, 2022 - How are users in incentivized pools behaving vs. non-LP OSMO token holders?
Borrowing activity on Aave
Mar 9, 2023 - This dashboard cover below stats: Unique borrowers of SNX, UNI & MKR on Aave V2. Total cumulative borrow for each asset on Aave V2. Visualize borrowing of each asset over time. Repay volumes of SNX, UNI & MKR on Aave V2. Stable and variable borrow rate on Market.