PROTOCOLS | TOTAL_USERS | AVG_DAILY_USERS | FEES | REVENUES | |
|---|---|---|---|---|---|
1 | uniswap | 3713228 | 119781.548387 | 67947905 | 1300772 |
2 | pancakeswap | 3708918 | 119642.516129 | 16014996 | 3840219 |
3 | raydium | 1796827 | 57962.16129 | 19278894 | 2313465 |
4 | quickswap | 537625 | 17342.741935 | 1044933 | 0 |
5 | trader-joe | 480333 | 15494.612903 | 7180104 | 977852 |
6 | woofi | 460673 | 14860.419355 | 258379 | 241436 |
7 | sushiswap | 371795 | 11993.387097 | 1880302 | 280571 |
8 | balancer | 146841 | 4736.806452 | 1458973 | 585868 |
9 | camelot | 102922 | 3320.064516 | 2347839 | 566290 |
10 | curve | 102389 | 3302.870968 | 4034309 | 1210469 |
11 | dodo | 75439 | 2433.516129 | 426765 | 85342 |
12 | velodrome | 45713 | 1474.612903 | 359391 | 359391 |
zackmendelTotal FEES
Updated 2024-02-15
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 protocols AS (
SELECT
DISTINCT protocol,
CASE
WHEN protocol LIKE 'PancakeSwap%' THEN 'pancakeswap'
WHEN protocol LIKE 'Uniswap%' THEN 'uniswap'
WHEN protocol LIKE 'jupiter%' THEN 'jupiter'
WHEN protocol LIKE 'Camelot%' THEN 'camelot'
WHEN protocol LIKE 'Quickswap%' THEN 'quickswap'
WHEN (protocol LIKE 'Raydium%' OR protocol LIKE 'raydium%') THEN 'raydium'
WHEN (protocol LIKE 'Trader Joe%' OR protocol LIKE 'Joe%') THEN 'trader-joe'
WHEN (protocol LIKE 'orca%' OR protocol LIKE 'ORCA%') THEN 'orca'
WHEN protocol LIKE 'DODO%' THEN 'dodo'
WHEN protocol LIKE 'Velodrome%' THEN 'velodrome'
WHEN protocol LIKE 'Curve%' THEN 'curve'
WHEN protocol LIKE 'SushiSwap%' THEN 'sushiswap'
WHEN protocol LIKE 'WOOFi%' THEN 'woofi'
WHEN protocol LIKE 'Balancer%' THEN 'balancer'
ELSE protocol
END AS protocols,
sum (fees) AS fee,
sum (revenue) AS revenue
FROM external.defillama.fact_protocol_fees_revenue
WHERE date::date >= current_date - 30
GROUP BY 1,2
ORDER BY 3 DESC
),
daily_stats AS (
SELECT
block_timestamp::date AS dates,
CASE
WHEN platform LIKE 'pancakeswap%' THEN 'pancakeswap'
WHEN platform LIKE 'uniswap%' THEN 'uniswap'
WHEN platform LIKE 'jupiter%' THEN 'jupiter'
WHEN platform LIKE 'camelot%' THEN 'camelot'
Last run: about 1 year agoAuto-refreshes every 24 hours
12
567B
191s