0xKofirevhange
Updated 2023-08-17
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 m3 AS (
SELECT
PROTOCOL,
SUM(REVENUE) AS rev
FROM external.defillama.fact_protocol_fees_revenue
WHERE DATE >= current_date() - interval '1 month'
GROUP BY 1
)
, m2 AS (
SELECT
PROTOCOL,
SUM(REVENUE) AS rev
FROM external.defillama.fact_protocol_fees_revenue
WHERE DATE < current_date() - interval '1 month'
AND DATE >= current_date() - interval '2 month'
GROUP BY 1
)
, m1 AS (
SELECT
PROTOCOL,
SUM(REVENUE) AS rev
FROM external.defillama.fact_protocol_fees_revenue
WHERE DATE < current_date() - interval '2 month'
AND DATE >= current_date() - interval '3 month'
GROUP BY 1
)
SELECT
m3.PROTOCOL,
m3.rev AS m3_rev,
100*(m3.rev-m2.rev)/m2.rev AS m3_growth,
m2.rev AS m2_rev,
100*(m2.rev-m1.rev)/m1.rev AS m2_growth,
m1.rev AS m1_rev
Run a query to Download Data