angealCurrent Positions
    Updated 2021-05-25

    WITH positions AS (
    SELECT * FROM uniswapv3.positions
    ),
    max_blocks AS (
    SELECT
    max(block_id) AS block_id,
    pool_address,
    liquidity_provider,
    nf_token_id

    FROM positions
    GROUP BY
    pool_address,
    liquidity_provider,
    nf_token_id
    )


    SELECT
    blockchain,
    p.block_id,
    block_timestamp,
    tx_id,
    fee_percent,
    liquidity_adjusted,
    p.liquidity_provider,
    nf_position_manager_address,
    p.nf_token_id,
    p.pool_address,
    p.pool_name,
    p.tick_lower,
    p.tick_upper,
    p.price_lower_0_1,
    Run a query to Download Data