datavortexrevenue change
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH CurrentWeek AS (
SELECT
protocol,
SUM(revenue) AS RevenueCurrentWeek
FROM
external.defillama.fact_protocol_fees_revenue
WHERE
date >= CURRENT_DATE - INTERVAL '7 days'
AND chain ILIKE 'solana'
GROUP BY
protocol
),
PreviousWeek AS (
SELECT
protocol,
SUM(revenue) AS RevenuePrevWeek
FROM
external.defillama.fact_protocol_fees_revenue
WHERE
date >= CURRENT_DATE - INTERVAL '14 days'
AND date < CURRENT_DATE - INTERVAL '7 days'
AND chain ILIKE 'solana'
GROUP BY
protocol
)
SELECT
cw.protocol,
((cw.RevenueCurrentWeek - pw.RevenuePrevWeek) / NULLIF(pw.RevenuePrevWeek, 0)) * 100 AS RevenueChangePercentage
FROM
CurrentWeek cw
JOIN
PreviousWeek pw ON cw.protocol = pw.protocol
WHERE
((cw.RevenueCurrentWeek - pw.RevenuePrevWeek) / NULLIF(pw.RevenuePrevWeek, 0)) IS NOT NULL
ORDER BY
RevenueChangePercentage DESC
QueryRunArchived: QueryRun has been archived