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.
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?
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!
ENS Registration & ETH Fees
Dec 13, 2021 - [ENS 7] ENS registration is cheap, but gas is not. Do more people register domains when gas is lower? Was there a spike in registrations when during recent ETH price dips?
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.
MetricsDAO Workshop #2
Feb 9, 2022 - Anchor's Collateral - Trends over time and changing user behaviors.
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?
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?
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.
The Great Dumpening
May 9, 2022 - Alt Title, someone arbed the peg and ETH Twitter is all mad.
USD, Terra USD
Nov 30, 2021 - [terra 103] Analyze the volume of UST being sent to other chains from Terra using Wormhole.
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?
bLUNA vs LUNA
Aug 18, 2021 - [Terra 46] Compare the quantity of Bonded Luna to unbonded Luna. Visualize the changes in each over a time period of your choice, and provide a quick explanation of the insights or significance: what can we learn from the ratio of bLUNA to LUNA?
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?
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?
CRV Token Uses
Sep 21, 2021 - [Curve Bounty 1] What else do people do with the CRV token (besides vote-lock)?
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?
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.
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.
RUNE Price and THOR Swaps
Nov 3, 2021 - [THOR Bounty 9] Is there a relationship between rune price and trade volume?