binhachonLiquidity Activity - Which token
    Updated 2022-03-05
    with liquidity_pools as (
    select
    pool_address,
    pool_name,
    token0,
    token1
    from ethereum.dex_liquidity_pools
    where (token0 = '0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198' or token1 = '0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198')
    ),
    BANK_swap_transaction as (
    select
    pool_name,
    position('-', pool_name, 1),
    position(' ', pool_name, 1),
    substr(pool_name, position('-', pool_name, 1) + 1, position(' ', pool_name, 1) - position('-', pool_name, 1) - 1) as token1,
    amount_out
    from ethereum.dex_swaps
    where pool_address in (select pool_address from liquidity_pools)
    -- and block_timestamp > getdate() - interval'90 days'
    and direction = 'OUT'
    )
    select
    token1 as token,
    sum(amount_out) as BANK_amount,
    row_number() over (order by BANK_amount desc) as rank
    from BANK_swap_transaction
    group by token
    order by rank
    Run a query to Download Data