flipside

    liquidity pools - $WIF
    Flipside Teamliquidity pools - $WIF
    Updated 2024-08-21
    -- forked from liquidity pools - $WIF @ https://flipsidecrypto.xyz/edit/queries/6e6a3e8d-29a4-49dc-875a-f525244ce235

    select count (distinct PROGRAM_ID ) as platforms
    , count (distinct LIQUIDITY_POOL_ADDRESS ) as pools
    from solana.defi.fact_liquidity_pool_actions
    where MINT = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'
    and BLOCK_TIMESTAMP >= '2024-01-01'
    and SUCCEEDED = 'TRUE'


    QueryRunArchived: QueryRun has been archived