Question:

Q99. Of Qualified DEX Liquidity Pools on Uniswap and Sushiswap on Ethereum mainnet (where "Qualified Pools" have AT LEAST $100,000 USD worth of total value locked (TVL): -What percentage of qualified TVL does each DEX have?  -What volume does each of these qualified pools have over the last 100,000 blocks? -What is the breakdown of major coin volume across these qualified pools (ETH, WBTC, USDC, USDT, etc.)?

Approach:

The question identified the Qualified pools on Uniswap and Sushiswap on Ethereum Mainnet as pools have at least $100,000 USD worth of total value locked (TVL). The methodology of this essay contains the following steps:

• Pools

  POOL_ADDRESS

  from ethereum.core.dim_dex_liquidity_pools where PLATFORM='sushiswap' or ‘Uniswap’

• Qualified Pools

  ADDRESS_NAME,

  sum(AMOUNT_USD) as TVL

  from flipside_prod_db.ethereum.erc20_balances x

  left outer join ethereum.core.dim_dex_liquidity_pools y on x.USER_ADDRESS=y.POOL_ADDRESS and BALANCE_DATE=CURRENT_DATE-2 and having TVL>=100000

• Volume in the last 100000 blocks

  from ethereum.sushi.ez_swaps

  where BLOCK_NUMBER>=max(BLOCK_NUMBER)-100000

• Breakdown of major coin volume

  SYMBOL,

  sum(AMOUNT_USD) as TVL

  from flipside_prod_db.ethereum.erc20_balances and SYMBOL in ('WETH','DAI', 'WBTC', 'USDC', 'USDT')

Qualified pools on Uniswap:

Key findings (Uniswap)

The first part of result section contains the Qualified pools on Uniswap:

1. About 8.53% of pools on Uniswap are Qualified and rest of them 91.5% of them are not-Qualified.
2. The USDC-WETH pool is the dominance liquidity Qualified pools on Uniswap and has the largest volume in the past 100000 blocks.
3. The breakdown of major coins across Qualified liquidity pools of Uniswap reveals the domination of WETH with 45.4% of volume.
4. The other most used tokens are USDC and DAI with 36.6% and 19.4% of volume.

Qualified pools on Sushiswap:

Key findings (Sushiswap)

The results related to the Qualified liquidity pools on Sushiswap presented in this part.

1. About 12.2% of pools on Sushiswap are Qualified and rest of them 87.8% of pools have been considered as not-Qualified pools.
2. The USDC-WETH SLP pool has the highest volume for the past 100000 blocks.
3. The breakdown of major coins across the Qualified liquidity pools on Sushiswap is WETH by 70.6% of volume.
4. The USDC and DAI are on the next ranks with 11.1% and 8.15% o volume, respectively.