nsa2000Total number of pools, tokens, and pairs on Sushiswap
    Updated 2022-10-26
    with oppools as (select pool_address, pool_name, token0_address as Tokens from optimism.sushi.dim_dex_pools union all select pool_address, pool_name, token1_address from optimism.sushi.dim_dex_pools),

    ethpools as (select pool_address, pool_name, token0 as Tokens from ethereum.core.dim_dex_liquidity_pools where platform ='sushiswap' union all select pool_address,pool_name, token1 from ethereum.core.dim_dex_liquidity_pools where platform ='sushiswap')


    select 'Optimism' as blockchain,
    count (distinct pool_address) as Pools_Count,
    count (distinct pool_name) as Pairs_Count,
    count (distinct tokens) as Tokens_Count
    from oppools

    union ALL

    select 'Ethereum' as blockchain,
    count (distinct pool_address) as Pools_Count,
    count (distinct pool_name) as Pairs_Count,
    count (distinct tokens) as Tokens_Count
    from ethpools
    Run a query to Download Data