Skip to content

Check Lead/Lag values for Net Flows to Resolve Bad Data #1491

@MSilb7

Description

@MSilb7

Currently, net flows can record hugely bad information (i.e. 58T in flows), due to bad token-level data, either in usd price, or number of tokens.

Build an intermediate model with some logic that says "if the lead and lag (up to 2 away) is > 20x different than the current value, null this row due to bad data"

Example below, we know the middle row is incorrect:

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions