flipside

    Uniswap
    boomer77Uniswap
    Updated 2021-06-28
    WITH pool as (SELECT pool_address as Pool_Address, pool_name as Pool_name, sum(token1_balance_usd + token0_balance_usd) as total,
    token0_address as token0address, token1_address as token1address, date_trunc('Day', block_timestamp) as Dayy
    FROM uniswapv3.pool_stats

    GROUP by Pool_Address, Pool_name, token0address, token1address, Dayy)

    SELECT * FROM pool
    where token0address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') or token1address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') and total > 0
    AND Dayy = CURRENT_DATE
    ORDER by total desc

    Run a query to Download Data