CryptoIcicle
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token? Hint: Here is the list of Celsius Wallets Identified by @lawmaster on twitter: https://app.flipsidecrypto.com/velocity/queries/c5c1ca1b-5299-4105-aed5-7968e2426d94
OP Price vs Swapper Activity
Oct 5, 2022 - -- Is there a relationship between OP price and trade volume? -- Make your case by including at least three visualizations.
Flash Bounty: Merge Open Analytics
Sep 24, 2022 - We want to know all about the merge — and we’re turning to you for the answers. Take a deep dive into the ETH merge and switch to POS with this Open Analytics Bounty. This is a chance to explore the topic without any specific prompt, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Solana-103.Going Down The Wormhole
Aug 9, 2022 - -- Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity -- both from Ethereum to Solana and from Solana to Ethereum. -- How are tokens being bridged from chain to chain and which actions seem to be popular among users of Wormhole? -- What actions seem to influence bridging behavior? -- What are users doing before and after bridging? -- Do users seem to think that bridging is safe or more risky relative to transfers to centralized exchanges?
Flash Bounty: Post Merge Behavior
Sep 24, 2022 - -- The merge has occurred. How have users responded in days that followed? -- Analyze any notable trends or outliers you can see since ETH switched to POS. -- Compare this to user behavior in the days and weeks leading up. -- What major changes can you see?
ETH Merge: Actually Good?
Sep 30, 2022 - -- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. -- We want you to prov11e one side or the other, with the help of Flipside data. -- Demonstrate whether the Merge had positive or negative effects on the network. -- Include least three queries and visualizations in your submission.
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
Metamask-2.Most Common Transactions
Jun 25, 2022 - -- Q2. What are the most common transactions for Metamask users? -- Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Osmo-11.wETH Deposit Rate
Jun 13, 2022 - -- Q11. Calculate the deposit rate of wETH over time on Osmosis. -- How does this compare to SushiSwap and Thorchain now? -- How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? -- Is Osmosis growing at a faster rate than Thorchain and Sushiswap? -- Hint: There are two types of wETH on Osmosis, wETH from the Gravity Bridge (gwETH) and WETH from the Axelier Bridge (axlWETH).
In the News - 13. DYDX Unlock
Jan 26, 2023 - DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members. Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react in the weeks leading up to and following the unlock? Back up your assertions with data.
Sushi-95.Celsius Swaps
Jun 19, 2022 - -- Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. -- From which one of their wallets did they conduct most of the swaps? -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
stETH/ETH Fluctuation
Jun 11, 2022 - -- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. -- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, -- Curve stETH/ETH pool composition, etc.
User Behavior (redux)
Oct 24, 2022 - -- How is user behavior different on Optimism compared to L1? -- Specifically, create a comparison between swaps and transactions on ETH mainnet vs Optimism, looking for things like daily swap volume, -- daily active users, and average volume swapped (use a single DEX for your comparison, either Uniswap or Sushiswap). -- L2 is far cheaper, but by how much? What are the average fees for a swap on Optimism compared to ETH Mainnet? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
ETH Derivatives
Sep 13, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity?
ETH Merge: Selling Event?
Sep 30, 2022 - -- Was the Merge a selling event? Why or why not? -- Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, -- along with any other visualizations you think will add to your analysis.
Sushi-110. Sushi Xswap Revenue
Sep 7, 2022 - -- How much fee in total do sushi Xswap users pay per transaction? -- What part of that goes to sushi, what part goes to stargate and what part goes to miners? (stargate does the bridging for sushi and its usually a stable coin that gets bridged) -- Chart sushi’s revenue per month from Xswap?
Sushi vs Uni on L2
Oct 17, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains.
Sushi-104.Celsius and Sushi
Jul 12, 2022 - -- Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). -- Make sure to use cross-chain tables as much as possible to capture data on all chains. -- currently, we have swaps, lending, and borrowing data cross-chain. -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels -- NOTE: This bounty will be paid on the ETH network. Please give your Sushiswap address on ETH when submitting
Optimism DEXs (redux)
Oct 25, 2022 - -- Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs based on: -- Total number of swaps by day over the last month -- Total number of wallets swapping by day -- What are the most popular asset pairs to swap from and too -- Top 10 assets swapping from -- Top 10 assets to swap to -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Sushi-89. Gas as a proxy of activity
Jun 5, 2022 - -- Q89. How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
Lido-11.HODL or Sell?
Jun 13, 2022 - -- Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. -- Have they held or sold their stETH?
Lido-10.Gain or Lose
Jun 13, 2022 - -- Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose -- depending on the peg of stETH to ETH at the time of the swap?
Metamask-3.Metamask vs. Other Platforms
Jun 25, 2022 - -- Metamask vs. Other Platforms -- Q3. How many users are swapping via MetaMask vs other platforms? -- How much volume have these users done? -- Chart a comparison between the two, and show the following metrics over a time period of your choosing: -- transaction volume, average amount swapped, and a comparison of fees.