lagandispenserLiquidity Activity pools
    Updated 2022-03-10
    with list_of_token_pools as (select POOL_NAME,POOL_ADDRESS from ethereum.dex_liquidity_pools
    where TOKEN0 like '%0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198%')
    select POOL_NAME,count(DISTINCT tx_id) as tx_count,sum(amount_usd ) as sum_usd from ethereum.dex_swaps
    where POOL_ADDRESS in(select POOL_ADDRESS from list_of_token_pools) group by POOL_NAME order by POOL_NAME DESC