datavortexLp actions per dex
    Updated 5 days ago
    SELECT
    PLATFORM,
    COUNT(DISTINCT pool_name) AS total_pools,
    COUNT(DISTINCT LP_TOKEN_ADDRESS) AS total_lp_token_addresses,
    COUNT(DISTINCT TX_ID) AS total_actions,
    COUNT(
    DISTINCT CASE
    WHEN LP_ACTION = 'add_liquidity' THEN TX_ID
    END
    ) AS added_liquidity_actions,
    COUNT(
    DISTINCT CASE
    WHEN LP_ACTION = 'remove_liquidity' THEN TX_ID
    END
    ) AS removed_liquidity_actions
    FROM
    sei.defi.fact_lp_actions
    GROUP BY
    PLATFORM;
    Last run: 5 days ago
    PLATFORM
    TOTAL_POOLS
    TOTAL_LP_TOKEN_ADDRESSES
    TOTAL_ACTIONS
    ADDED_LIQUIDITY_ACTIONS
    REMOVED_LIQUIDITY_ACTIONS
    1
    seaswap616132292590639
    2
    fuzio6614241058366
    3
    astroport13101407662754513509
    4
    levana501068167963885
    4
    131B
    3s