Crazy_Kid
Popularity of USDC, USDT, UST Swaps on Jupiter
Mar 6, 2022 - In this dashboard we will be looking at the popularity of USDC, USDT, UST(wormhole) swaps on Jupiter since Dec 1 2021, in terms of both swap count and amount. We will also look into whether there is a dominant stable coin among these three in terms of swaps and we will find out what percentage of total swaps on Jupiter are stable coin swaps.
Trend Analysis - Sushiswap vs Uniswap
Apr 5, 2022 - Analyze the trend of active users and number of swaps for Sushiswap and draw a comparison with Uniswap. Describe the trends that you see.
Stargate User Growth
Apr 27, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth?
stETH vs ETH
Apr 6, 2022 - How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Polygon NFT
Jul 16, 2022 - How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Whales & Their Vote - Terra
Feb 12, 2022 - Through this dashboard we are trying to find the no. of whales who voted at least once in the Terra/Anchor/Mirror governance vote in the past 90 days. Here, users who hold more than $1 million in either Luna/ANC/MIR on Feb 11 2022 is considered as a whale.
Top LDO Holders
Jun 1, 2022 - Who are the top LDO holders on Ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Liquidity of CLUB Token
Mar 15, 2022 - In this dashboard we will be looking at the liquidity of CLUB token on DEXs and it trade volume on Uniswap. We will analyze the largest transaction on Uniswap and its impact on the liquidity of the pool.
Top 10 Sushi Liquidity Pools on Polygon
Mar 20, 2022 - In this dashboard we will be looking at the 10 largest Sushi liquidity pools on Polygon in terms of the Total Value Locked (TVL) and their trade volume till date.
Seed Club Members & Projects
Mar 14, 2022 - How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens?
Swap Count & ASAs Traded by Algorand Wallets
Mar 24, 2022 - In this dashboard we will see the no. of swaps conducted by wallets in the Algorand ecosystem in 2022. We will also see how many Algorand Standard Assets (ASAs) were swapped for by each wallet in 2022. For convenience only those top 1000 wallets that have made the max no. of swaps and the top 1000 wallets that have swapped away the max no. of ASAs are considered here.
SOL Swaps on Jupiter & Orca
Mar 16, 2022 - In this dashboard we will be looking at the 5 most popular swaps on the basis of volume of SOL swapped on Jupiter and Orca. Then we will see a visualization of amount of SOL swapped for other coins daily on Jupiter and Orca since Jan 1, 2022. We will also see the swap success rate of SOL on Jupiter and Orca.
Active Wallet Addresses - Thorchain
Jun 21, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
STBL Staked on AlgoFi
Mar 10, 2022 - Algofi is a platform that allows Algorand users to lend and borrow to earn interest, get leverage, or short crypto assets. In this dashboard we will be looking at how much STBL - Algorand's first stablecoin, has been staked on AlgoFi.
Circulating Supply of Luna in the Past 3 Months
Feb 22, 2022 - The purpose of this dashboard is to visualize and analyze the circulating supply of Luna over the past 3 months -Nov, Dec and Jan.
New Dex Users
Mar 31, 2022 - Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange? What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
Active Wallet Growth Solana
Feb 1, 2022 - A crypto wallet is a device or application that stores a collection of keys and can be used to send, receive, and track ownership of cryptocurrencies. Wallets can take many forms. A wallet might be a directory or file in your computer's file system, a piece of paper, or a specialized device called a hardware wallet. A keypair is a securely generated private key and its cryptographically-derived public key. A private key and its corresponding public key are together known as a keypair. A wallet contains a collection of one or more keypairs and provides some means to interact with them. The public key (commonly shortened to pubkey) is known as the wallet's receiving address or simply its address. The wallet address may be shared and displayed freely. The private key is required to digitally sign any transactions to send cryptocurrencies to another address or to make any changes to the wallet. The private key must never be shared. Different wallet solutions offer different approaches to keypair security, interacting with the keypair, and signing transactions to use/spend the tokens. Solana supports several types of wallets in the Solana native command-line app as well as wallets from third-parties.
Raydium Swaps
Apr 6, 2022 - Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time?
Transfers to Centralized Exchanges in the Month of December 2021
Jan 20, 2022 - Solana is a web-scale blockchain that provides fast, secure, scalable, decentralized apps and marketplaces. Solana aims to improve blockchain scalability by using a combination of proof of stake consensus and so-called proof of history. As a result, the system supports 50,000 TPS (Transactions per second) and 400ms Block Times. Its internal cryptocurrency is SOL. Centralized exchanges are platforms which facilitate the buying and selling of cryptocurrency, either for fiat currencies, like the US dollar, or between digital assets, like BTC and ETH. They function as trusted intermediaries in trades, and often act as custodians by storing and protecting your funds. Leading exchanges facilitate every aspect of the digital asset trading experience: from security, to fair market pricing, to regulatory compliance, consumer protection, and access to various digital assets.
Meme Tokens on Sushiswap
Mar 23, 2022 - Choose the three largest meme tokens on Sushiswap. Was there ever a time when the swap volume of these tokens soared? What, if any, is the cause of this sudden increase in swap volume?
Daily Transactions and Unique Addresses - Polygon
Jul 13, 2022 - Q. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Algomint Bridge
Jan 26, 2022 - Algomint is a next generation blockchain infrastructure that solves the interoperability challenge. It brings popular assets such as Bitcoin and Ethereum to Algorand block chain. Algomint acts as a centralized bridge that allows you to wrap your BTC and ETH to use in the Algorand ecosystem. They custody your BTC and ETH in the secure vault of Copper.co, mint goBTC and goETH and supply it to you in a 1:1 ratio, which can be redeemed later on demand for the original assets.
Node Operators Who Earned the Highest Rewards
Jan 15, 2022 - Blockchain is a class of distributed ledger technology (DLT) that functions as a decentralized digital ledger of transactions that is designed to copy itself to multiple devices within a network. This means that a chronological and complete record of every network transaction gets to be distributed to a series of devices. These devices are called nodes and they are responsible for keeping a blockchain fair, secure and immutable. In simple words a node is any system or physical device that is connected to a blockchain network and can execute certain functions like creating, receiving or sending information via a communication channel. THORChain is a decentralized and autonomous cross-chain liquidity network.THORChain aims to decentralize cryptocurrency liquidity via a network of public THORNodes and ecosystem products. Access to its native and cross-chain liquidity is open to any person, product or institution. Coming to the question, the aim is to find the node operators who earned the highest rewards for their service.
ETH Staked on Lido
Apr 5, 2022 - In this dashboard we will be seeing the amount of ETH staked with Lido till date and the amount of ETH staked daily on Lido in the past 3 months. We will also analyze the trends if any.
ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?
stETH vs ETH
Jun 8, 2022 - How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
What Are Users Swapping gALGO3 For?
Apr 29, 2022 - Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance.
Impact of New CEO on the Algorand Ecosystem
Mar 10, 2022 - Through this dashboard we will be trying to examine whether the Algorand foundation's decision to appoint a new CEO - Staci Warden, had an impact on the ALGOs being moved from CEXs and vice versa. The new CEO was appointed on Feb 10, 2022. So to estimate the impact of this decision we will be looking at the transfers in the following week, i.e. from Feb 11 - Feb 17.
Swap Volume vs. LP Rewards
May 3, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
Sablier Top 10 Users
Apr 22, 2022 - List 10 users who received the most funds and 10 users who sent the most funds through cash streams.
Anchor Borrowers in the Last 3 Months
Feb 22, 2022 - In this dashboard we will be looking at those users that borrowed from Anchor market in the past 3 months - Nov, Dec & Jan and analyzing the results to find trends if any.
MIM Use Cases
Feb 10, 2022 - Magic Internet Money (MIM) is an ERC-20 token that is soft-pegged to USD. It is minted by Abracadabra.money, a decentralized platform. Abracadabra uses interest-bearing tokens as collateral to mint MIM. Interest-bearing tokens that can currently be used as collateral include liquidity provider (LP) tokens from Convex, Curve, Yearn, among others. Loan liquidations in Abracadabra differ from other stablecoin/lending protocols like MakerDAO, such that each collateralized debt position (CDP) is unique and has its own liquidation price. When the liquidation price for an individual CDP is crossed, a liquidator can buy the position by paying off any outstanding MIM.
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?
Terra wallets that made their 1st transaction in the last 90 days
Mar 6, 2022 - In this dashboard we will be looking at the wallets that made their first successful transaction in the past 90 days and how active they were since that first transaction. I have used no. of successful transactions as the metric for measuring the activity of wallets - higher the no. of transactions, higher is the activity. For the sake of convenience only the top 1000 most active wallets have been considered.
RocketPool Recent Activity
Apr 27, 2022 - Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. As we near the ETH 2 merge, are there any emerging trends? What is the average deposit size and how has that changed vs. historical performance?
Luna and Market Downturns
Feb 28, 2022 - Through this dashboard I will be trying to analyze the performance of Luna in the event of a market downturn. I will be comparing Luna against Ethereum to assess whether Luna holds its ground or crumble during a market downturn. I will be considering a drop of 3% or less during a market downturn as an indicator of stability.
Relation Between Rewads, Balance and Engagement in Algorand Wallets
Feb 3, 2022 - Algorand is a cryptocurrency and blockchain protocol that aims to be simultaneously scalable, secure, and decentralized. It uses a consensus algorithm called pure proof-of-stake. Algorand nodes reach consensus about what should appear in the blockchain through a process called PPoS (or “Pure Proof of Stake”) — which uses a staking system (instead of a Proof of Work mining system like Bitcoin’s) to verify new transactions and produce new crypto tokens. The Algorand rewards are earned by everyone holding at least one Algo proportionally to their holding of Algos. Every address that holds 1 Algo or more in a non-custodial wallet is eligible to earn rewards. For addresses managed by custodians or centralized wallets/exchanges, it depends on the terms and/or policies of the custodian or wallet/exchange. The Algorand protocol itself ensures that every account that holds 1 Algo or more is eligible to earn rewards. One doesn't need to enroll in anything or sign up for this program. Rewards can be earned automatically just by holding Algos in an Algorand Wallet.
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.
Price + Circulating Supply - Polygon
Jun 8, 2022 - Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Active Wallet Addresses
Jun 28, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
