binhachonCLUB Liquidity - Largest trade
    Updated 2022-03-11
    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