theericstoneInverted ETH/DAI Positions
    Updated 2021-11-11
    with pools as (
    select * from uniswapv3.pools
    where pool_address = '0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
    )

    select * from (
    select
    distinct
    liquidity_provider,
    nf_token_id,
    pool_address,
    pool_name,
    last_value(tx_id) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tx_id,
    last_value(liquidity_adjusted) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as liquidity_adj,
    last_value(tick_upper) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tick_upper,
    last_value(tick_lower) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as tick_lower,
    last_value(price_lower_0_1_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_0_1_usd,
    last_value(price_upper_0_1_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_0_1_usd,
    last_value(price_lower_1_0_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_1_0_usd,
    last_value(price_upper_1_0_usd) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_1_0_usd,
    last_value(price_lower_0_1) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_0_1,
    last_value(price_upper_0_1) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_0_1,
    last_value(price_lower_1_0) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_lower_1_0,
    last_value(price_upper_1_0) OVER(partition by liquidity_provider, nf_token_id, pool_address, pool_name order by block_id) as price_upper_1_0
    from uniswapv3.positions pos
    where pos.pool_address in (select pool_address from pools)
    and pos.tick_lower > 0
    and pos.block_timestamp > '2021-05-05 01:00:00'
    )
    where liquidity_adj > 0
    order by liquidity_adj desc;


    Run a query to Download Data