Michael Silberling

Create tables where we can manually contracts and/or deployers. We can use these in addition to the Growthepie and OSO labels & should also have a plan for how to...

Dependency on migrating existing API models & knowing what they'll look like **Problem:** We use various data sources for chain data. and eventually we want to join them. Each source...

**Rebuild a new chain metadata structure that:** Chains in the Superchain 1. Reads from the superchain-registry as the main Superchain source of truth #1063 - This should contain current state...

Migrate OP Collective Revenue Transactions

1

Requirement on having ETH transfers for L1 and L2s. Existing Notebook: https://github.com/ethereum-optimism/op-analytics/blob/main/op_collective_economics/opcollective_feesplit/op_collective_revenue.ipynb Existing Dune Query: https://dune.com/queries/3046107 **Ideal set-up is we:** 1. Have a list of all OP Collective Receiver Addresses...

Migrate L2Beat data pre-API update - I believe this goes farther back in history? Data lives in: - `oplabs-tools-data.api_table_uploads.daily_l2beat_aoc_by_token` - `oplabs-tools-data.api_table_uploads.daily_l2beat_l2_activity`

Migrate OVM1 Data to New Schema / Folder

1

Legacy OVM1 data (before the current OP Mainnet Chain) is necessary for usage and economics. Legacy aggregate data from Dune lives in `oplabs-tools-data.api_table_uploads.dune_ovm1_daily_data`

Final Query: Join data sources together and build/select metrics

1

Use #1089 mappings to join data sources together. Generate rank selection order, when a data type is available in multiple places (i.e. if we have transactions per day from L2Beat,...

Currently pulls all chains and unique deployer addresses from Dune: https://github.com/ethereum-optimism/op-analytics/blob/main/other_chains_tracking/get_filtered_deployers.ipynb This metric has become largely useless, so TBD if we want to scrap it. We alternatively, could replace this...

Re-Build L1 Costs Model

3

- Index L1 and Beacon Blobs (pull from Goldsky) - Map to all Superchain & known OP Stack Chain address combinations, also supporting historical changes (I.e. OP Mainnet OVM1) -...