Carl Cervone

Add TVL volume and LP fees to timeseries metrics factories

1

### What is it? The final step! Implement the metrics like this [one](https://github.com/opensource-observer/oso/blob/main/warehouse/oso_sqlmesh/oso_metrics/blockchain/defillama_tvl.sql) and update the metrics factory. Definition of done: the new timeseries metrics are available in `timeseries_metrics_by_project_v0` via...

Create daily de-duped events for TVL volume and LP fees

1

### What is it? Here's what we currently do for TVL: https://github.com/opensource-observer/oso/blob/main/warehouse/oso_sqlmesh/models/intermediate/defillama/int_events_daily__defillama_tvl.sql Definition of done: - A single `int_events_daily__*` model that be used for timeseries metrics There are probably two...

Update the DefiLlama dagster asset to include trading volumes and LP fees

1

### What is it? This will need to be extended: https://github.com/opensource-observer/oso/blob/main/warehouse/oso_dagster/assets/defillama.py Relevant queries: - For Trading Volumes, we need one like [this](https://api.llama.fi/summary/dexs/velodrome-v1?excludeTotalDataChart=true&excludeTotalDataChartBreakdown=false) - For LP Fees, we need one like...

Create timeseries metrics for TVL volume and LP fees

1

### What is it? Related to [this issue](https://github.com/opensource-observer/oso/issues/3752) For Trading Volumes, we need one like [this](https://api.llama.fi/summary/dexs/velodrome-v1?excludeTotalDataChart=true&excludeTotalDataChartBreakdown=false) For LP Fees, we need one like [this](https://api.llama.fi/summary/fees/velodrome-v3?dataType=dailyFees)

Differentiate `direct` and `transitive` npm dependencies

1

### What is it? GitHub now differentiates dependency types for npm packages. https://github.blog/changelog/2025-03-04-easily-distinguish-between-direct-and-transitive-dependencies-for-npm-packages/ Previously, devs were mildly frustrated about lots of transitive dependencies showing up in their dependency tree (eg,...

Get OpenQ list of foundry imports

2

### What is it? - [x] Script for pulling the repos we want to scan is [here](https://github.com/opensource-observer/insights/blob/main/analysis/optimism/pyoso/20250416_OnchainBuilderRepos.ipynb) - [x] Get results back from OpenQ - [ ] Include as data...

Repository clustering analysis for EF

3

### What is it? ## Context We built an initial [Hex dashboard](https://app.hex.tech/00bffd76-9d33-4243-8e7e-9add359f25c7/app/0196171a-97f4-7008-9434-720289cf8e67/latest) that identifies repos in the Ethereum ecosystem We received the following feedback: > I was wondering if you...

Ensure no gaps in incremental models

3

### What is it? We've noticed a few gaps in some of our incremental models, which could be the result of source data having a service interruption when we are...

Create SCW factory mapping

1

### What is it? Here's the basic query from Bundle Bear: ``` SELECT 'base' AS CHAIN, TO_ADDRESS AS ADDRESS, FROM_ADDRESS AS FACTORY_CONTRACT, l.NAME AS FACTORY_NAME FROM BASE.RAW.TRACES t INNER JOIN...