flipside

    Statistic
    datavortexStatistic
    Updated 2025-02-27
    WITH ProtocolData AS (
    SELECT
    protocol,
    chain,
    market_cap,
    chain_tvl AS TVL,
    RANK() OVER(
    ORDER BY
    TVL DESC
    ) as TotalValueLockedInRank,
    RANK() OVER(
    ORDER BY
    market_cap DESC
    ) AS MarketCapRank
    FROM
    external.defillama.fact_protocol_tvl
    WHERE
    chain IlIKE 'solana'
    AND date = (
    SELECT
    MAX(Date)
    FROM
    external.defillama.fact_protocol_tvl
    )
    )
    SELECT
    *
    FROM
    ProtocolData
    WHERE
    protocol ILIKE 'raydium'
    Last run: 2 months ago
    No Data to Display
    0
    2B
    2s