datavortexDaily Fees And Revenue
    Updated 2025-02-27
    WITH ProtocolTotals AS (
    SELECT
    protocol,
    chain,
    SUM(fees) AS TotalFees
    FROM
    external.defillama.fact_protocol_fees_revenue
    WHERE
    revenue IS NOT NULL
    AND chain ILIKE 'solana'
    AND date >= '2024-01-01'
    AND date < '2025-01-01'
    GROUP BY
    protocol, chain
    ORDER BY
    TotalFees DESC
    LIMIT 10
    ),
    DailyTotals AS (

    SELECT
    date,
    protocol,
    chain,
    SUM(fees) AS DailyFees,
    SUM(revenue) AS DailyRevenue
    FROM
    external.defillama.fact_protocol_fees_revenue
    WHERE
    protocol IN (SELECT protocol FROM ProtocolTotals)
    AND revenue IS NOT NULL
    AND chain ILIKE 'solana'
    AND date >= '2024-01-01'
    AND date < '2025-01-01'
    GROUP BY
    date, protocol, chain
    QueryRunArchived: QueryRun has been archived