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?
Pudgy Penguins Trading Metrics
Aug 6, 2021 - Flipside's databases are generally 30-60 mins behind the live blockchain. Charts autorefresh every 30 min.
MetricsDAO Workshop #2
Feb 9, 2022 - Anchor's Collateral - Trends over time and changing user behaviors.
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.
Anchors Aweigh! βοΈπΈ
Jan 5, 2022 - [Terra 123] How have the average and total borrows and deposits on Anchor changed over time?
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?
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?
The Great Dumpening
May 9, 2022 - Alt Title, someone arbed the peg and ETH Twitter is all mad.
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?
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?
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?
USD, Terra USD
Nov 30, 2021 - [terra 103] Analyze the volume of UST being sent to other chains from Terra using Wormhole.
ENS Claims and Price Action
Dec 13, 2021 - [ENS 4] Make a scatterplot showing the relationship between ENS price and the number of airdrops claimed.
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.
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!
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.