binhachonCLUB Liquidity - Largest trade
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with pool_address as (
select
pool_address
from ethereum.dex_liquidity_pools
where (token0 = '0xf76d80200226ac250665139b9e435617e4ba55f9' or token1 = '0xf76d80200226ac250665139b9e435617e4ba55f9')
and platform ilike '%uniswap%'
)
select
block_timestamp,
case when direction = 'IN' then 'Buy CLUB' else 'Sell CLUB' end as trading_direction,
case when direction = 'IN' then amount_in else amount_out end as WETH_amount,
row_number() over (order by WETH_amount desc) as rank
from ethereum.dex_swaps
where pool_address in (select pool_address from pool_address)
and token_address != '0xf76d80200226ac250665139b9e435617e4ba55f9'
qualify rank < 11
Run a query to Download Data