ETH -> Polygon Bridge Data
Aug 21, 2021 - Using udm_events and events_emitted produces different / missing? data
Curve Liquidity for Liquid Staking
Sep 21, 2021 - [Curve Bounty 2] Analyze the stETH-ETH pool over the past 30 days. What trends can you identify? What might be causing them?
Delegator Overlap
Aug 17, 2021 - [Terra 44] Which validators do the top 25 delegators (by volume) delegate to? Do they tend to delegate to the same validators, or to different ones?
Ethereum UST Peg - Uniswap Liquidity vs Volatility
Jul 27, 2021 - Terra Bounty 28 - Compare the price of the UST-Tether pool on Uniswap V3 against the UST oracle price on Terra.
UST in May: What's a Dollar Worth?
May 10, 2022 - Charts set to refresh hourly, timestamps are in UTC. Note: Terra data is updating intermittently due to the multiple network halts.
Stablecoin Supplies on the Terra Blockchain
Sep 8, 2021 - 61. [Easy] Stablecoin Total Supply \\ Make a visualization that shows the total circulating supply of each pegged currency in the Terra ecosystem over the past 6 months.
Polygon Bridge
Aug 22, 2021 - [Matic 1] - What is the volume of ETH and a stable coin of your choice that's moved between the Polygon network and the Ethereum network across the bridge? How has that changed over time?
MetricsDAO Workshop #2
Feb 9, 2022 - Anchor's Collateral - Trends over time and changing user behaviors.
Rewards and Gas
Sep 28, 2021 - [yveCRV Bounty 2] yveCRV Vault users can claim rewards weekly, yvBOOST users have their rewards automatically claimed and reinvests into yveCRV to compound rewards. 1. How many users are claiming rewards weekly in yveCRV? 2. How much gas have yveCRV holders spent since yvBoost launched? 3. Have users of the yveCRV vault made good decisions about claiming tokens with regard to gas fees?
Terra Gas
Sep 14, 2021 - [Terra Bounty 66] Find the largest transactions in the past 30 days. How does the gas fee limit set on these transactions compare to the actual gas used for them?
Bitcoin
Jul 19, 2023 - Eric asked me to show off some queries and/or dashboards for the Bitcoin launch but I only had like 20 mins before the call so here are some queries and charts!
Pudgy Penguins Trading Metrics
Aug 6, 2021 - Flipside's databases are generally 30-60 mins behind the live blockchain. Charts autorefresh every 30 min.
LUNA Price Volatility
Aug 4, 2021 - Terra Bounty 31 - What has the daily volatility (standard deviation of price day over day) of LUNA price been over the past 2 weeks? How does that compare to the volatility of ETH over the past 2 weeks? What are events and/or factors potentially impacting these?
Flow Events Backfill
Aug 11, 2022 - Monitoring the rewalk of blocks that were ingested from 7/18-8/4 where transaction event data was missing due to the new HTTPS endpoint. The black line is transaction and block count within the events table, while the bars are the total transactions and events in the core tables. We should expect the line to start to meet the bars as the backfill occurs.
Near Developer Report, 2022 Year End
Dec 30, 2022 - An investigation into developer activity on NEAR related GitHub repositories, per the ecosystem compiled by Electric Capital. Methodology and data extraction explained in the below linked GitHub Repository.
Chai Volume and Terra Fees
Aug 17, 2021 - [Terra 45] What has the monthly volume of payments been on Chai over the past year? What have been the total monthly fees been on Terra over the past year?
THORBURN - Upgrades to Native RUNE
Oct 27, 2021 - [Thor Bounty 2] Show the volume of non-native rune being upgraded to native RUNE, broken down by chain (ETH + BNB)
THORChain - Now Open 24/7!
Nov 3, 2021 - [THOR Bounty 8] What time periods (GMT) see the heaviest swap, LP add/withdrawal volumes by asset?
USD, Terra USD
Nov 30, 2021 - [terra 103] Analyze the volume of UST being sent to other chains from Terra using Wormhole.
The Great Dumpening
May 9, 2022 - Alt Title, someone arbed the peg and ETH Twitter is all mad.
Terra Fees and Volume
Aug 11, 2021 - [41] How have fees changed over time on Terra? Is this correlated with total transaction volume on Terra?
Anchors Aweigh! ⚓️💸
Jan 5, 2022 - [Terra 123] How have the average and total borrows and deposits on Anchor changed over time?
UST Anchors Down
Aug 25, 2021 - [T 49] Anchor's deposit balance has passed 1bn, or 48% of the total UST supply! How has Anchor's growth impacted the growth of UST? Things to explore could be the growth of UST before and after protocol launch and the % of total available UST has been deposited in Anchor over time. Overall - has Anchor solidified itself as an essential foundation protocol of the Terra ecosystem?
Self-Validation
Jul 16, 2021 - Terra Bounty 30 - For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
CRV Token Uses
Sep 21, 2021 - [Curve Bounty 1] What else do people do with the CRV token (besides vote-lock)?
THORSwap User Metrics
Oct 27, 2021 - [THOR Bounty 5] Show the number of swaps as well as the unique number of swappers in total and by pool, today and daily.
RUNE Price and THOR Swaps
Nov 3, 2021 - [THOR Bounty 9] Is there a relationship between rune price and trade volume?
Flow Latency // Time to Complete Coverage
Dec 8, 2023 - Latency on Flow is expected to be worse than other chains because, at minimum, 4 calls are required to generate a complete block. Blocks are requested by height, which returns an array of collections by ID. These collections are containers for transactions, thus the collection response (called by individual ID) contains an array of transaction IDs. Transactions are then requested by ID, twice, for the tx body and tx response. The response contains the event data and is often an order of magnitude slower than the other 3 gRPC calls.