saeide-ahmadi-7
Average Optimism Portfolio (redux)
Nov 8, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
NBA Playoff Usage
Jun 27, 2022 - Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
ETH Staked
Jun 13, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
NEAR City Layout
Nov 3, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time? Grand Prize submissions will also explore these metrics for at least one other blockchain.
Applications on Algorand
Jun 29, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021? Start off by looking at: -Average number of TX calls per block, day -Number of wallets making application calls Then do your own analysis that shows whether there is more or less application usage on Algorand in the first half of 2022 compared to the 2nd half of 2021.
Ailing Alameda
Nov 8, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency? Note any other interesting trends or events you see.
Open Analytics Bounty: Optimism (November 5)
Nov 10, 2022 - Open Analytics Bounty: Optimism (November 5)
Voting Activity
Jun 21, 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. Hint: Sample query to look at a Lil Noun vote select * from ethereum.core.fact_event_logs where block_number = 14887882 and tx_hash = '0x783d64b2146de10f7545e1053a6fa58d2846ee78fb5dc30ed635182ac5313e9b'
Trending NFT Projects
Jun 14, 2022 - Q8. 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?
Fuse Pool DAI Allocation
May 21, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Secondary Sales Activity
Jun 21, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings. Hint: This query looks at Nouns traits. You will need to modify it for Lil Nouns! select block_number as mint_block, block_timestamp as mint_time, tx_hash as mint_hash, contract_address, tokenflow_eth.hextoint(topics[1])::integer as tokenID, tokenflow_eth.hextoint(substr(data,3,64)) as background, tokenflow_eth.hextoint(substr(data,67,64)) as body, tokenflow_eth.hextoint(substr(data,131,64)) as accessory, tokenflow_eth.hextoint(substr(data,195,64)) as head, tokenflow_eth.hextoint(substr(data,259,64)) as glasses from ethereum.core.fact_event_logs where block_number > 12000000 and contract_address = '0x9c8ff314c9bc7f6e59a9d9225fb22946427edc03' and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478' order by tokenId desc;
ETH Deposited or Withdrawn
Jun 30, 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? Hint: Each deposit/withdrawal on StarkNet is done through the StarkNet proxy contract on Ethereum: 0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419. The logs will tell you more.
Flash Bounty: Reddit NFTs
Oct 27, 2022 - Reddit is officially in the NFT game. Find 3 metrics to compare the Reddit NFT launch to the launches of other major NFTs. Add any other interesting metrics comparing this launch to Polygon NFTs in general
![[Terra] 2. UST Deposits on Anchor Protocol](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675675525/https://next.flipsidecrypto.xyz/previews/dashboards/4c00201f-a4e1-4e54-a189-30061c3f683b%3Ftype%3Dcover "[Terra] 2. UST Deposits on Anchor Protocol")
RaceDay NFTs
Oct 20, 2022 - How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? Create a dashboard that shows off a high-level project overview of RaceDAY. Include at least these metrics, along with any others you find notable or interesting: Average Sales volume (daily/weekly/monthly) Total Sales Volume Secondary Sales vs. Mint Sales Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day Social Mentions/Shares
Welcome To Axelar Scavenger Hunt (Oct 31)
Nov 1, 2022 - Step 1: Get an Axelar Wallet Step 2: Explore Satellite Step 3: Buy AXL Step 5: Analyze To complete this bounty, create a new dashboard that outlines your entrance to Axelar and the AXL token. Please include: All transactions associated with your bridge to Osmosis via Satellite Deposit on etherscan & axelar transactions Swap for AXL on Osmosis IBC transfer from Osmosis to Axelar
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both. Hint: use the ethereum.core.ez_eth_transfers table https://etherscan.io/txs?a=0xabea9132b05a70803a4e85094fd0e1800777fbef&p=1
Algorand x Fifa Partnership
May 12, 2022 - Q64. On May 2nd, Algorand announced a technical partnership with Fifa causing the price to move 25%. Over the rest of the week, how did this impact Algorand blockchain activity? Did we see an uptick in new wallets being created? Did we see more ALGOs being transferred on a daily basis? Did we see more transactions happening occurring? Did we see more wallets sending ALGOs from centralized exchanges to their onchain wallets? Did we see an influx of swaps? Note any changes in behavior in on-chain activity that may have been caused by the Fifa partnership!
Flipside's World Cup of Bounties Side Quest: LaLiga Golazos
Dec 6, 2022 - LaLiga Golazos: Officially licensed LaLiga video collectibleshttps
Total Metamask Users
Jun 26, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking? Hint: For the purpose of this bounty, we can categorize Metamask wallets as wallets who have used the Metamask swap feature (interacted with this contract 0x881D40237659C251811CEC9c364ef91dC08D300C)
Wallet Balances & Ecosystem Growth
Oct 24, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
Top TOKE Holders
Jun 19, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Pooly NFTs
Jun 23, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Top LDO Holders
May 31, 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?
Flash Bounty: LUNA Head
Oct 7, 2022 - What's going on with LUNA, aka LUNA 2.0? Is there any unusual activity? Major whales buying or selling? What dApps are people using? Tell us the story of LUNA using the terra.core tables. Include at least three visualizations in your analysis — the best dashboards will dive deep into particularly interesting trends, outliers, or findings. They'll also be featured in a future video (so include your Twitter handle in the dashboard, and tweet it at @flipsidecrypto)!
