KeyrockLiquidswap dominance
    Updated 2024-01-16
    SELECT DATE, SUM(VOLUME) as tot_volume, CASE WHEN protocol = 'liquidswap'
    THEN 'liquidswap'
    ELSE 'other'
    END as protocol
    FROM external.defillama.fact_dex_volume
    WHERE chain = 'aptos'
    GROUP BY date, protocol
    ORDER BY date


    QueryRunArchived: QueryRun has been archived