mercury
Stablecoin Arbitrage on Jupiter DEX Aggregator
Mar 19, 2022 - Jupiter is the key liquidity aggregator for Solana, offering the widest range of tokens and best route discovery between any token pair. Jupiter aims to provide the most friendly UX for users and most powerful tools for developers to allow them to easily access the best-in-class swap in their application, interface, or on-chain programs.
Osmosis - 8. Mars Protocol Free Play
Mar 2, 2023 - This past week the Flipside team released Mars EZ tables - let's put them to work! Create your best Mars dashboard leveraging these new tables. Top dashboards will not only provide professional grade visuals, but will incorporate sound insights to guide the reader towards the most important data points.
Flash Bounty: Miners
Sep 10, 2022 - Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count? You can define what can be considered low or high transaction count based on the transaction count distribution 75,112.5,B,M,USDC,Ethereum
DEX Popularity: Tinyman, Algofi, Pactfi
May 20, 2022 - Since the beginning of April, how has the growth of AlgoFi and Pact impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows. Do we see a change in the number of wallets swapping on these DEXs? Do we see a change in the volume of ALGOs being swapped on Tinyman and the other DEXs? Are ALGO whales swapping on certain DEXs more than others? Have we seen has the recent price change in ALGO impact the number of swaps/wallets/volume on the DEXs? If so, how?
Avalanche Swaps vs Transfers (Redux)
Dec 7, 2022 - Examine Avalanche USDC(0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E- https://snowtrace.io/token/0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e) swaps vs transfers and mints vs burns using the new fact_event_logs data and avalanche.core.fact_traces data. Lets look at volume of USDC swaps vs transfer by hour since 7/1. - What is the average amount of USDC transferred vs swapped? - Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving - Lets look at the volume of USDC mints and burns by hour since 7/1 - How many unique wallets are minting and burning USDC by day - What is the average mint vs burn for USDC by day - Note anything else interesting about USDC transactions 75, 112.5, USDC, Ethereum
Avalanche Active Users
Apr 16, 2023 - Let’s analyze Active Users on the Avalanche network. Create a parameterized dashboard that lets us explore active users across the chain. We'd recommend at least 3 tabs: active users across the chain, active users by contracts, and what dApps have the most active users over the parameterized period of time. The goal of this dashboard is to show where most of the activity is taking place on chain and where the active number of users is growing on chain. Add any additional metrics or charts that will provide users insights into contracts and dApps with growing usage based off average active users, new active users.
Avalanche Gas Fees
Mar 25, 2023 - In this dashboard, we have investigated the amount of gas used in the Avalanche network. The dashboard has two major tabs: one for contracts and one for dApps. Each tab shows which ones generate the most network fees and use the most gas over a user-selectable time period. We have also added two more tabs to the report, by using them and using the parameters below, you can analyze your desired contracts or dApps in terms of the metrics related to the gas used.
Cryptopunk Sales and Traders
Aug 30, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings. 75,225,B,M,Ethereum
Chain Swaps in Axelar
Apr 22, 2023 - Since February 23rd, you have been able to swap into 13 different Cosmos Chains via Squid: https://twitter.com/squidrouter/status/1628796403076964354?s=20 What chain has had the most activity?
NEAR On Chain Data Report: Before vs. After ATL
Jan 15, 2023 - On 2022-12-19, NEAR recorded its lowest price ($1.229) in the market and experienced a new ATL (All Time Low). After this date and according to the conditions in the market, it was able to have a good price growth (up to $2.442). The time interval from 2022-12-20 to 2022-01-18 is equal to 29 days. In this report, we tried to compare the metrics discussed in this research in two equal time periods Before (-29 days) and After (+29 days) ATL date.
HOW TO BID ON LIQUIDATIONS on KUJIRA Orca
Apr 9, 2022 - ORCA is the first product from Kujira, a dApp which make DeFi accessible to everyone
New Terra Station: Light as a Feather
Jan 24, 2023 - The announcement of Station has generated hype in the Terra community. Has this type translated to an increase in activity? To check the size of changes in activity due to this announcement, several metrics such as the number of transactions, gas used, fees, active users, new users, swap criteria, staking criteria, etc., were analyzed in two periods before and after the date of this announcement. and were compared.
AVALANCHE DEX PLATFORMAs ANALYSIS
May 3, 2023 - Flipside keeps shipping and these past weeks they shipped a DEX swaps table (avalanche.core.ez_dex_swaps). This DEX swap table includes swaps from BALANCER (soon), CURVE, FRAX, GMX, HASHFLOW, KYBER (both classic and elastic), PANGOLIN, PLATYPUS, SUSHI, TRADER JOE, UNISWAP (Soon), and WOOFI. Create a dashboard or a tool that utilizes this new table. Here are some ideas for inspiration: Popular Asset Monitor: Monitors the most popular and rising assets being traded into across Avalanche DEXes. Looks at the number of users trading the assets and at what volume. Popular LP Monitor: Monitors popular trading pairs and LP pools and calculates the pools with the largest volume of trading. Popular DEX Monitor: Looks at the USD volume of DEXes to help the ecosystem determine which DEXes are the most popular. Token Swaps History Explorer: A tool that allows users to explore and analyze their transaction history of token swaps on decentralized exchanges.
Sorare Compete With Collectibles
Nov 22, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across football, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project: - Statistics on Sorare NFTs being sold on Opensea such as buyers, volume, number of NFTs etc - Transfers and mints over time - Statistics on contract events such as players and clubs added - Provide additional insight into the players and clubs added in from the event inputs. 75, 112.5 USDC, Polygon
Sushi vs Uni on L2
Oct 15, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc. 56.872,85.308,SUSHI,Ethereum
USDC Transfer Volumes
Apr 14, 2022 - A comparison of USDC transfer volumes on Algorand, Solana and Ethereum in 2022
Flow Speed
Jun 4, 2022 - One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute. Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric has fluctuated during that time period. Level: Beginner, Payout: 18.66, Grand Price: 55.97 Flow
Polygon Block Performance
Jul 24, 2022 - What is the average time between blocks in Polygon? 75,225,B,USDC-ETH
Mega Dashboard for Optimism Bears
Nov 9, 2022 - Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. 125, 187.5, USDC, Ethereum
Getting Started With Terra Bounties
Mar 24, 2022 - How Much LUNA Did You Delegate on a Validator
bAsset, bLUNA & bETH (LOCKED Collateral in Anchor and WHERE HELD IN)
Mar 21, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
Covered Call Strategy in Friktion Volt
Mar 30, 2022 - How stake sol in Marinade Finance and Earn Passive Income with Friktion
NEAR - 16. Secrets of the NETH-erworld
Mar 1, 2023 - The day that many citizens of the City of Near had been waiting for finally arrived late last year. As of December 19, 2022, NEAR is compatible with MetaMask, marking the first time a non-EVM chain has offered compatibility with the popular ETH wallet. This was made possible by a smart contract called NETH. Now that the contact and ensuing compatibility has been live for nearly three months, it's time to dive deeper into the data. We created a dashboard monitoring NETH's adoption and usage and we tried to investigate different aspects of using NETH contract in NEAR big city.
Trending NFT Projects
Jun 11, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers? Payout: 19.92, Grand Prize: 59.76 FLOW
Bentobox Ecosystem in SushiSwap on Polygon
Mar 24, 2022 - انجام تراکنش در صرافی غیرمتمرکز سوشی سواپ از نوع سفارش محدود
Transactional Nature in Terra Blockchain
Mar 29, 2022 - How transaction volume relates to fees paid to delegators and the Fees Derived from Transactions and Native Swaps
THORChain Protocol Synth Utilization
Apr 11, 2022 - The Synth Utilisation of each Pool and Chart Over Time
Rand Gallery Wallets
May 24, 2022 - Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery? What is the total number of unique wallets that have been purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have been purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchased from rand gallery by ALGOs and the number of NFTs Tips: Check out these analyses for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/algo-rand-gallery-nft-sales-Fdtzb6 and https://app.flipsidecrypto.com/dashboard/rand-gallery-nft-sales-SYCxCf NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats