CryptoIcicle
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
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?
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?
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'
Flow vs Other L1s Pt (II)
Jul 16, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
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: 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.
Flow NFT Comparison
Sep 16, 2022 - -- Compare and contrast the NFT market and ecosystem across at least three different chains -- (you can do more if you wish, but there must be at least three included.) -- Explain how the various chains differ in terms of metrics such as: -- Total Sales -- Total Unique Buyers -- Total Volume -- Average Sales/Day -- Average Buyers/Day -- Average Sales Price/Day
Optimism NFT Purchasing Behavior
Oct 20, 2022 - -- Show the distribution of all NFT sales on Optimism by price. -- What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? -- Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
Open Analyitics Bounty: Optimism
Jul 24, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Optimism tables, which can be found under the "Optimism
Optimism Free Square Question
Jun 25, 2022 - -- Show us what you can do with this new Optimism data!
What's going on with Optimism?
Jul 22, 2022 - What's going on with Optimism? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).
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!
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?
Seasons in the City - The Financial District
Oct 19, 2022 - It’s autumn in the Northern Hemisphere. What season is it in the City of NEAR? Pick one of the districts from the NEAR Tournament and review how activity there has changed over the past 90 days. What has changed? What trends can you spot? Is it truly “winter” in your chosen “district” or area (NFTs, DeFi, etc.)?
Flow-10.NFT Buying Behavior on Flow
Jun 12, 2022 - -- Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. -- Is there more or less "whale" activity on Flow compared to each of the other chains? -- What do "whales" tend to focus on in Flow? -- How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? -- Are wallets more interested in new projects, or already existing projects on Flow?