LPs New Position Count

Nige7777LPs New Position Count

Updated 2021-07-14

-- select distinct pool_address

-- ,pool_name

-- from uniswapv3.positions

-- where 1=1

-- and lower(pool_name) like '%usdc-weth%'

-- and block_timestamp >= CURRENT_DATE -2

-- select count(*), liquidity_provider

-- from uniswapv3.lp_actions

-- where 1=1

-- and pool_address in

-- (

-- '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',

-- '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',

-- '0x7bea39867e4169dbe237d55c8242a8f2fcdcc387'

-- )

-- and block_timestamp >= CURRENT_DATE -30

-- GROUP BY liquidity_provider

-- ORDER BY count(*) DESC

-- limit 10

-- select * from uniswapv3.positions where liquidity_provider = '0x33cb9f2f86964dbbefeff8867e70fbffe8a4ef00' and pool_address in (

-- '0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',

-- '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',

-- '0x7bea39867e4169dbe237d55c8242a8f2fcdcc387'

-- )

-- order by block_id , nf_token_id

-- select * from uniswapv3.lp_actions where 1=1 -- tx_id = '0x98d4048b525037cb965ae4f11e2b9fda3950350acba9ca875646042d74df6714'

-- and nf_token_id = 23462

Run a query to Download Data

flipside