kaibladeTotal value locked of oSQETH token in Uniswap LPs
    Updated 2022-06-30
    WITH streamlined_data AS (
    SELECT MAX(block_timestamp) AS recent_timestamp, pool_address, pool_name
    FROM flipside_prod_db.uniswapv3.pool_stats
    WHERE
    token0_symbol = 'oSQTH'
    OR
    token1_symbol = 'oSQTH'
    GROUP BY pool_name, pool_address
    ),

    expanded_data AS (
    SELECT
    stats.block_timestamp,
    stream.pool_name,
    stream.pool_address,
    (CASE
    WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_balance_adjusted
    WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_balance_adjusted
    END
    ) AS osqth_balance,
    (CASE
    WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_address
    WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_address
    END
    ) AS osqth_address,
    (CASE
    WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_balance_usd
    WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_balance_usd
    END
    ) AS osqth_balance_usd

    FROM flipside_prod_db.uniswapv3.pool_stats stats
    JOIN streamlined_data stream
    Run a query to Download Data