flipside

    uniswapv3 wbtc-usdc pool
    boomer77uniswapv3 wbtc-usdc pool
    Updated 2023-04-29
    with stats as (select pool_name, date(block_timestamp) as dt, token0_symbol, token1_symbol,
    TOKEN0_BALANCE_ADJUSTED,
    TOKEN1_BALANCE_ADJUSTED,
    TOKEN0_BALANCE_USD as BTC_usd,
    TOKEN1_BALANCE_USD as USDC_usd,
    ROW_NUMBER() OVER (PARTITION BY dt ORDER BY block_timestamp desc) as rank
    from ethereum.uniswapv3.ez_pool_stats
    where pool_address = '0x99ac8ca7087fa4a2a1fb6357269965a2014abc35' AND
    date(block_timestamp) >= current_date - 31
    order by block_timestamp desc)

    select *, (btc_usd+usdc_usd) as total_bal,
    round((btc_usd/total_bal)*100,1) as wbtc_perc,
    round((usdc_usd/total_bal)*100,1) as usdc_perc,
    concat(wbtc_perc,'% - ',usdc_perc, '%') as pool_ratio
    from stats
    where rank = 1
    Run a query to Download Data