CoinConverse
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Unique Buyers and Sellers
May 3, 2022 - Are more people joining or leaving the Moon Birds community? Look at unique buyers and sellers over a period of time
SOL OpenSea vs Magic Eden
Apr 13, 2022 - Q53. OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
Velodrome Health (Redux)
Nov 14, 2022 - Dashboard by PM...#6566 Question: Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
xSUSHI
Jan 27, 2022 - In this query, we aim to describe the mechanism behind xSushi token. - To illustrate the total supply of xSushi over the past 3 months. - How does this relate to the total supply of Sushi over the past 3 months?
Yet Another Acme Question
Apr 21, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make? You can also refer to the Dashboards from Question #157 here: https://teamflipside.notion.site/Terra-Dashboards-Powered-by-the-Flipside-Community-defa0c2160694af599beecba089b813d
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
143 - Terra Altcoin Behavior
Feb 7, 2022 - In this analysis, we picked a Terra “altcoin” named MINE token and assess its performance over the past 90 days. Here, we show the daily price and the daily number of transactions of the MINE token over the past 90 days.
1. [Easy] Angel has risen
Dec 23, 2021 - Outline: - We aim to show the relationship of the number of charitable donations to Angel's charity wallet across the time of this year (2021) - We make a pie chart to demonstrate the top 10 highest donations wallets to Angel's protocol
Top LDO Holders
Jun 2, 2022 - Q1. Who are the top LDO holders on Ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Early Pool Activity liquidity vol
May 17, 2022 - Q79. For each pool, show the swap volume and the liquidity after its first week going live (you can use the first swap date to determine when a pool went live)
Net Bonding Flow
May 10, 2022 - Q84. Show the net bonding amount over time. You can show a line chart with the cumulative amount bonded over time or a chart showing weekly or monthly net changes (or a visualization of your choice!)
USDC Declining on Solana?
Oct 7, 2022 - Dashboard by PM...#6566 Question: It looks like over the last few weeks the market cap of USDC on Solana has been declining. What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem? Are other stablecoins also dropping in market cap on Solana?
FSC Bounty - Gains Network vs GMX
Nov 5, 2022 - Dashboard by PM...#6566 A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56. Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem?
stETH Most Common Pools
Apr 25, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Popular Contracts on Flow
May 28, 2022 - Q1. What are the 10 most popular contracts that have been used on Flow since May 9th? What do each of those contracts do and why do you think they are so popular? Are there any contracts that seem to be trending and growing in popularity?
140. Anchor Collateralization
Feb 3, 2022 - In this query, We compared the overall bLUNA and bETH collateral provided on Anchor in terms of total USD and the number of unique users. Furthermore, we visualized the amount of USD collateralization and the number of unique users of bLUNA over the past 90 days.
When Do Transactions Fail?
May 31, 2022 - Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?