DT | CHAIN | DEXs TVL per Traded Volume [USD] | |
---|---|---|---|
1 | 2025-01-13 00:00:00.000 | Aptos | 10.244524 |
2 | 2025-01-13 00:00:00.000 | Arbitrum | 2.332872 |
3 | 2025-01-14 00:00:00.000 | Ethereum | 2.562419 |
4 | 2025-01-13 00:00:00.000 | Near | 17.302038 |
5 | 2025-01-14 00:00:00.000 | Near | 17.007564 |
6 | 2025-01-16 00:00:00.000 | Optimism | 1.390873 |
7 | 2025-01-16 00:00:00.000 | Solana | 0.812988 |
8 | 2025-01-13 00:00:00.000 | Solana | 0.890996 |
9 | 2025-01-18 00:00:00.000 | Arbitrum | 0.845267 |
10 | 2025-01-17 00:00:00.000 | Ethereum | 3.770856 |
11 | 2025-01-18 00:00:00.000 | Aptos | 6.852013 |
12 | 2025-01-18 00:00:00.000 | Ethereum | 3.07543 |
13 | 2025-01-17 00:00:00.000 | Solana | 0.808077 |
14 | 2025-01-14 00:00:00.000 | Aptos | 7.422885 |
15 | 2025-01-14 00:00:00.000 | Solana | 0.65605 |
16 | 2025-01-15 00:00:00.000 | Aptos | 7.812432 |
17 | 2025-01-15 00:00:00.000 | Arbitrum | 0.972817 |
18 | 2025-01-14 00:00:00.000 | Arbitrum | 0.60134 |
19 | 2025-01-15 00:00:00.000 | Solana | 0.8615 |
20 | 2025-01-16 00:00:00.000 | Near | 8.67126 |
MostlyData_Daily DEX Volume
Updated 2025-01-20
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 dex_tvl as(
select
date as dt,
chain,
--category,
--protocol,
sum(chain_tvl) as daily_tvl
from external.defillama.fact_protocol_tvl
where
(
chain = 'Solana'
or chain = 'Ethereum'
or chain = 'Avalanche'
or chain = 'Arbitrum'
or chain = 'Optimism'
or chain = 'Near'
or chain = 'Aptos'
)
and date >= current_date() - interval '30 days'
and date < current_date()
and category = 'Dexes'
group by 1,2
)
,dex_volume as(
select
date as dt,
case
when chain = 'solana' then 'Solana'
when chain = 'ethereum' then 'Ethereum'
when chain = 'avalanche' then 'Avalanche'
when chain = 'arbitrum' then 'Arbitrum'
Last run: 3 months ago
42
2KB
2s