BLOCKCHAIN | PROTOCOL LABEL ALL | CATEGORY LIST ALL | RANK 7D | DATA 7D ($) | DATA 7D (%) | RANK 30D | DATA 30D ($) | DATA 30D (%) | |
|---|---|---|---|---|---|---|---|---|---|
1 | arbitrum | SYNAPSE | Cross Chain | 28 | $10,872 | 98% | 33 | $31,133 | -12% |
2 | polygon | ACROSS | Cross Chain | 20 | $2,923 | 98% | 22 | $9,095 | 1% |
3 | arbitrum | POSTTECHSOFI | SoFi | 43 | $1,433 | 97% | 44 | $4,567 | 14% |
4 | bsc | RAINBOW | Services | 20 | $3,140 | 96% | 24 | $11,052 | -36% |
5 | arbitrum | FRAX SWAP | Dexes | 38 | $2,257 | 95% | 39 | $8,369 | -4% |
6 | ethereum | PENDLE | Yield | 34 | $37,964 | 93% | 52 | $74,098 | 254% |
7 | ethereum | SYNTHETIX | Synthetics | 39 | $32,711 | 90% | 50 | $90,809 | -65% |
8 | boba | SUSHISWAP | Dexes | 1 | $379 | 90% | 1 | $1,323 | -22% |
9 | ethereum | MAKERDAO | CDP | 3 | $3,669,038 | 9% | 4 | $14,736,031 | -1% |
10 | solana | LIFINITY | Dexes | 2 | $126,665 | 9% | 2 | $508,193 | -8% |
11 | zksync era | PANCAKESWAP | Dexes | 2 | $25,331 | 9% | 3 | $119,149 | 44% |
12 | mantle | AGNI FINANCE | Dexes | 2 | $28,513 | 9% | 2 | $182,074 | 0% |
13 | base | DACKIESWAP | Dexes | 19 | $990 | 9% | 18 | $5,149 | 48% |
14 | base | MAVERICK PROTOCOL | Dexes | 10 | $4,910 | 9% | 12 | $19,734 | 56% |
15 | base | BALANCER | Dexes | 13 | $3,327 | 893% | 17 | $6,425 | -13% |
16 | polygon | BALANCER | Dexes | 7 | $78,399 | 87% | 7 | $219,431 | -9% |
17 | polygon | GAMMA | Yield | 5 | $138,015 | 86% | 4 | $600,780 | -30% |
18 | hydra | HYDRADEX | Dexes | 1 | $521 | 85% | 1 | $3,171 | -45% |
19 | zksync era | SATORI | Derivatives | 5 | $8,851 | 83% | 6 | $24,032 | 114% |
20 | base | PANCAKESWAP | Dexes | 7 | $8,955 | 8% | 8 | $42,865 | 19% |
tkvresearchFEES
Updated 2024-01-29
999
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
L as( select max(date_trunc('day',date)) as date from external.defillama.fact_protocol_fees_revenue),
A as(
select chain, protocol,
max(date) as max_date,
sum(case when date_trunc('day',date) >= (select date from L) - interval '7 day' then fees else 0 end) as data_1,
sum(case when date_trunc('day',date) >= (select date from L) - interval '14 day' then fees else 0 end) as data_2,
sum(case when date_trunc('day',date) >= (select date from L) - interval '30 day' then fees else 0 end) as data_3,
sum(case when date_trunc('day',date) >= (select date from L) - interval '60 day' then fees else 0 end) as data_4
from external.defillama.fact_protocol_fees_revenue
where lower(protocol) != lower(chain)
group by 1,2),
-- label category
B as(
select a.chain, a.protocol,
data_1, data_2 - data_1 as data_2,
data_3, data_4 - data_3 as data_4,
case when b.category is not null then b.category else c.category end as category
from A as a
left join external.defillama.dim_protocols as b on a.protocol = b.protocol
left join external.defillama.dim_dexes as c on a.protocol = c.dex
WHERE a.max_date = (select max(max_date) from A)
and data_1 > 100
group by 1,2,3,4,5,6,7 ),
B1 as (
select
chain, protocol, data_1, data_2, data_3, data_4,
case
when lower(protocol) = lower(chain) then 'Blockchain'
when protocol in ('Maestro','Aimbot','Banana Gun','Unibot') then 'Trading Bots'
when protocol in ('PostTechSoFi','FriendRoom','friend.tech','Stars Arena') then 'SoFi'
when protocol in ('Tangible RWA') then 'RWA'
Last run: about 1 year agoAuto-refreshes every 24 hours
...
397
36KB
4s