flipside

    Velodrome TVL
    KARTODVelodrome TVL
    Updated 2023-04-13
    WITH temp AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    LP_TOKEN_AMOUNT_USD AS LP
    FROM optimism.velodrome.ez_lp_actions
    WHERE LP_ACTION = 'deposit'

    UNION ALL

    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    -LP_TOKEN_AMOUNT_USD as LP
    FROM optimism.velodrome.ez_lp_actions
    WHERE LP_ACTION = 'withdraw'
    )

    SELECT
    DATE(BLOCK_TIMESTAMP) as time,
    SUM(LP) AS "TVL Change",
    SUM("TVL Change") OVER (ORDER BY time) AS "TVL"
    FROM temp
    GROUP BY time
    ORDER BY time desc
    Run a query to Download Data