oso
oso copied to clipboard
Create daily de-duped events for TVL volume and LP fees
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 ways of accomplishing this:
- Update
int_events_daily__defillama_tvlto include the new event types (one big model) - Create smaller standalone models to handle each DefiLlama metric (TVL, TVL volume, LP fees) and then union into a single model
Here are some examples for inspiration: