flipside

    GROUP BY CATEGORY
    datavortexGROUP BY CATEGORY
    Updated 2025-02-27
    SELECT
    category,
    chain_tvl,
    chain,
    protocol,
    market_cap
    FROM
    external.defillama.fact_protocol_tvl
    WHERE
    chain ILIKE 'solana'
    and category = (
    SELECT
    category
    FROM
    external.defillama.fact_protocol_tvl
    WHERE
    protocol ILIKE 'raydium'
    LIMIT
    1
    )
    and date = (
    SELECT
    MAX(date)
    FROM
    external.defillama.fact_protocol_tvl
    );
    Last run: 3 months ago
    No Data to Display
    0
    2B
    2s