maybeyonasuni-pool-stats
    Updated 2022-12-30
    -- select
    -- date(block_timestamp)
    -- from uniswapv3.pool_stats
    -- order by block_timestamp desc
    -- limit 100
    with top5 as(
    SELECT
    st.block_timestamp as date,
    st.pool_name,
    (st.token0_balance_usd + st.token1_balance_usd) as total_bal,
    st.pool_address
    FROM uniswapv3.pool_stats st
    INNER JOIN (
    SELECT MAX(p1.block_timestamp) as maxDate, p1.pool_address
    FROM uniswapv3.pool_stats p1
    GROUP BY p1.pool_address
    ) p2 ON st.pool_address = p2.pool_address AND st.block_timestamp= p2.maxDate
    WHERE total_bal IS NOT NULL
    ORDER BY total_bal DESC
    LIMIT 10
    ),
    top10_details as(
    SELECT
    date(st.block_timestamp) as date,
    st.pool_name,
    (st.token0_balance_usd + st.token1_balance_usd) as total_bal,
    st.pool_address,
    price_0_1,
    price_1_0,
    token0_symbol,
    token0_balance_adjusted,
    token0_balance_usd,
    Run a query to Download Data