flipside

    Number of LPs created in each unique platform
    fantasyNumber of LPs created in each unique platform
    Updated 2025-03-05
    SELECT
    platform,
    COUNT(DISTINCT pool_address) AS total_liquidity_pools
    FROM
    ethereum.defi.dim_dex_liquidity_pools
    WHERE
    DATE_TRUNC('day', creation_time) >= '2025-02-01'
    GROUP BY
    platform;
    Last run: about 1 month ago
    PLATFORM
    TOTAL_LIQUIDITY_POOLS
    1
    		uniswap-v3492
    2
    		verse1
    3
    		curve2
    4
    		shibaswap1
    5
    		pancakeswap-v234
    6
    		uniswap-v25163
    7
    		pancakeswap-v339
    8
    		dodo-v2107
    9
    		balancer1
    10
    		sushiswap20
    10
    172B
    1s