Michael Silberling
Michael Silberling
See: `oplabs-tools-data.views.daily_opstack_chain_economics` Table to aggregate all chains we monitor. Historically this has extended to as many OP Stack chains as we can track. Debatable if we still do this, or...
Script: https://github.com/ethereum-optimism/op-analytics/blob/main/op_chains_tracking/ch_gs_uploads.ipynb Read from BQ post-processing. Build functions for common formulas. Build as many segments of aggregated fields as possible. This should be a transaction & blocks-level aggregation, maybe we...
Woden transactions from World on World Chain and OP Mainnet are actually bundles of a few user transactions in the World App. We usually identify these by Multicall3 transactions, World...
Current version: https://github.com/ethereum-optimism/op-analytics/blob/main/op_chains_tracking/ch_gs_uploads.ipynb Should definitely simplify by using/building common metric calculations in our system. Like: https://github.com/ethereum-optimism/op-analytics/blob/main/helper_functions/goldsky_db_utils.py
Build a library of function calls and event selectors, that we can use for: 1. Decoding raw data 2. Mapping functions and events to human-readable names, for usage tracking (i.e....
Storing all decoded logs and traces would be heavily intensive. We could/should instead build functions that decode "on the fly" -> intake raw data and output a decoded dataframe. A...
Re-build logic to tag addresses as likely high-frequency or automated bots based on transaction throughput, hours active, etc. See old logic we developed here (used in the World Chain announcement):...
https://github.com/ethereum-optimism/design-docs/pull/317#discussion_r2322169940 Today: - Check that block gas used = sum of tx gas used for all txs in that block Jovian: - Check that block gas used = sum(max(tx gas...
## Summary - capture data quality check failures with their template names - raise errors listing each failing template - add regression test for template-aware data quality errors ## Testing...
Changes include: - Handling for larger data fields for ERC20 transfers - Safe mult UDF for INT overflow (again from larger data fields) This also changes the datatype for some...