0xHaM-dTop LP Pools
    Updated 2025-02-18
    select
    POOL_NAME,
    count(distinct TX_ID) as lp_txs,
    count(distinct PROVIDER_ADDRESS) as lp_providers,
    sum(TOKEN_A_AMOUNT_USD+TOKEN_B_AMOUNT_USD) as lp_amount_usd,
    from solana.marinade.ez_liquidity_pool_actions
    group by 1
    having lp_amount_usd > 0
    order by 4 desc
    limit 10


    Last run: about 2 months ago
    POOL_NAME
    LP_TXS
    LP_PROVIDERS
    LP_AMOUNT_USD
    1
    SOL-MSOL3900763580121215155656.4655
    2
    MSOL-USDC450499136411664461044.0177267
    3
    MSOL-USDT1871783801955158374.7205218
    4
    MSOL-ETH1133503374284416203.1662418
    5
    SOETH-MSOL224161024142901321.0525151
    6
    MSOL-SOL7010723835132967198.75284895
    7
    MNDE-MSOL12804614069112777260.21510126
    8
    ORCA-MSOL389731075297635826.53997786
    9
    BSOL-MSOL7104255379885545.84067285
    10
    MSOL-JITOSOL3773133078446392.43504564
    10
    442B
    4s