alleria
129. Transactions on Wormhole
Jan 11, 2022 - What are the transaction size & volume of transactions on Wormhole? Let's find out!
100. [Very Easy] Verify Flipside's Validator Activity!
Oct 27, 2021 - Let's see the inflows and outflows to and from Flipside's validator address!
[Lil Nouns] Voting Activity
Jun 18, 2022 - Q1. The Lil Nouns DAO is controlled via onchain 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.
Thorra-Luna-UST
Apr 17, 2022 - Q65. How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? How do the fees generated from these pools compare to other pools? Do the swaps in these 2 pools tend to be balanced or are they typically going in a certain direction (e.g. are there more swaps from $LUNA or to $LUNA)?
[Pool Together] USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
THORChain Stormchaser Hunt
Oct 24, 2021 - THORChain is a decentralized liquidity protocol that allows for swapping native assets between different blockchains such as Bitcoin, Ethereum, and Binance chains. In this scavenger hunt, steps are done to swap BNB into native RUNE, then RUNE is further swapped into BUSD.
11. THORChain: Liquidity provision
Oct 31, 2021 - What is the daily change in volume of each pool over time? How about the number of unique LP-ers adding/removing liquidity each day? Let's find out.
Impact of Terra integration on new wallets created
Apr 16, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
39. ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 10, 2022 - What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time?
3. [Easy] Number of Users of THORChain Bridges by Asset
Oct 24, 2021 - What is the number of users that are interacting with THORChain? In this dashboard, we broke down the numbers by chain to find out!
MonkeDAO Validator
Feb 18, 2022 - Let's look at the wallets that had delegated SOL to MonkeDAO on February 2022!
1. [Easy] Wallets With Balance
Feb 27, 2022 - What is the number of wallets with >0 $ONE balance on the Harmony blockchain?
1. End of Year CEX Transfers
Jan 18, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December?
1. [Easy] Asset Transaction Volume
Nov 21, 2021 - In this dashboard, we will analyze the aggregate and per asset transaction volume of mAssets in the last 90 days.
ALGO Transaction Payment Size
Mar 28, 2022 - Q43. 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(algorand.payment_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.
Fuse Pool DAI Allocation
May 22, 2022 - How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Flipside Algorand Wallet Behavior
Apr 9, 2022 - Let's look at wallet behavior associated with wallets that have been paid a Flipside Algorand bounty payout.
[Paraswap] Token Activity
May 8, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
Whale Dependency Index
Jan 23, 2022 - What is the liquidity value locked on DEX pools in Loop? How many holders are there in each pool?
73. [Easy] Airdrop Query Repo
Oct 2, 2021 - Trying my best to provide a repository of baseline queries on airdrop related stuffs. Provided with a baseline query to determine the airdrop contract address, and a baseline query to obtain information on airdrop claim transactions. (Also provided a great query example)
45. Net Swapping Ratios
Jan 15, 2022 - Which tokens have the highest and lowest ratio of being swapped from/to?
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 23, 2022 - Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. Let's look deeper!
17. [Hard] Pool Depth
Nov 7, 2021 - What is the current depth of each pool based on the number of LP-ers currently providing liquidity?
79. [Hard] Liquidation Response
Oct 2, 2021 - How would borrowers on Terra that got liquidated will react? Let's find out!
Dodge, Duck, Dip, Dive and $DOGE
Jan 21, 2022 - What % of the swaps made this week involved $DOGE?
31. [Easy] Net Liquidity
Dec 18, 2021 - A Dashboard on THORChain regarding liquidity added/removed over time