flipside

    DefiLlama - Protocols by Network
    rahoDefiLlama - Protocols by Network
    Updated 2024-10-03
    SELECT
    DATE_TRUNC('week', date) AS day,
    chain,
    COUNT(DISTINCT protocol) AS daily_prot
    FROM external.defillama.fact_protocol_tvl
    WHERE chain IN(
    'Scroll'
    -- 'Taiko'
    )
    GROUP BY 1, 2
    ORDER BY 1 DESC, 3 DESC
    QueryRunArchived: QueryRun has been archived