Nige7777test
Updated 2021-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- select count(*) , label
-- from ethereum.erc20_balances
-- where amount_usd > 1000000
-- and balance_date >= '2021-05-29T00:00:00Z'
-- group by label
-- select distinct pool_name , pool_address from uniswapv3.positions
-- where pool_name like 'USDC_WETH%'
select *
from uniswapv3.positions
where
--pool_name like 'USDC_WETH%' and
block_timestamp >= '2021-05-30T16:00:00Z'
order by block_timestamp desc
Run a query to Download Data