DATE | SWAPPERS | TRADING_VOLUME | AVERAGE_TRADING_VOLUME | MEDIAN_TRADING_VOLUME | VOLUME_PER_TRADER | |
|---|---|---|---|---|---|---|
1 | 2025-05-19 00:00:00.000 | 48168 | 716838825.16 | 715.658703957 | 61.93 | 14882.054998339 |
2 | 2025-05-12 00:00:00.000 | 52116 | 993627467.64 | 745.832742954 | 49.06 | 19065.68937831 |
3 | 2025-05-05 00:00:00.000 | 39213 | 935769648 | 903.543852941 | 53.74 | 23863.760691607 |
4 | 2025-04-28 00:00:00.000 | 37871 | 823239699.86 | 932.918231779 | 30.09 | 21737.997408571 |
5 | 2025-04-21 00:00:00.000 | 39222 | 1161679036.18 | 1094.07504507 | 39.23 | 29618.046917036 |
6 | 2025-04-14 00:00:00.000 | 30221 | 630318754.9 | 816.36086519 | 22.9 | 20856.978753185 |
7 | 2025-04-07 00:00:00.000 | 23119 | 904942767.4 | 731.680762775 | 26.98 | 39142.816185821 |
8 | 2025-03-31 00:00:00.000 | 26477 | 704186234.61 | 932.375916386 | 65.45 | 26596.148906976 |
9 | 2025-03-24 00:00:00.000 | 34338 | 730654328.28 | 960.558160693 | 60.42 | 21278.301831207 |
10 | 2025-03-17 00:00:00.000 | 31015 | 681367875.85 | 999.743047541 | 46.46 | 21968.97874738 |
11 | 2025-03-10 00:00:00.000 | 42213 | 925966437.78 | 868.24873488 | 51.67 | 21935.575244119 |
12 | 2025-03-03 00:00:00.000 | 41163 | 1292569045.04 | 889.002709192 | 58.63 | 31401.235212205 |
13 | 2025-02-24 00:00:00.000 | 37960 | 1138157202.55 | 962.395003129 | 61.44 | 29983.066452845 |
14 | 2025-02-17 00:00:00.000 | 39722 | 878439207.24 | 765.380958897 | 28.53 | 22114.677187453 |
15 | 2025-02-10 00:00:00.000 | 40477 | 1081875152.9 | 949.821473447 | 42.68 | 26728.145685204 |
16 | 2025-02-03 00:00:00.000 | 33185 | 1295950674.63 | 1166.437607731 | 84.2 | 39052.302987193 |
17 | 2025-01-27 00:00:00.000 | 56365 | 1290716594.86 | 1363.354773856 | 78.22 | 22899.256539697 |
18 | 2025-01-20 00:00:00.000 | 49363 | 1468240075.94 | 1417.424007835 | 72.64 | 29743.736724672 |
19 | 2025-01-13 00:00:00.000 | 84390 | 1614503821.77 | 1704.713870362 | 71.55 | 19131.458961607 |
20 | 2025-01-06 00:00:00.000 | 75862 | 1051487461.58 | 1330.567299897 | 60.17 | 13860.52913949 |
Ali3NDately DEX Swaps Overview Over Time (Avalanche Chain Monitor)
Updated 17 hours ago
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 dextable as (
select block_timestamp,
case when platform ilike '%trader-joe%' then 'Trader Joe'
when platform ilike '%kyber%' then 'Kyberswap'
when platform ilike '%uniswap%' then 'Uniswap'
when platform ilike '%Pharaoh%' then 'Pharaoh'
else initcap (platform) end as dex,
origin_from_address as trader,
coalesce (amount_in_usd,amount_out_usd,0) as volume
from avalanche.defi.ez_dex_swaps
where block_timestamp >= '{{From_Date}}' and block_timestamp <= '{{To_Date}}'
union all
select t1.date,
'Dexalot' as DEX,
flattened_response.value:value as trader,
t1.volume,
from (
select live.udf_api('https://metrics.avax.network/v1/active_addresses/432204'):data:results as response) as api_data,
table (flatten(input => api_data.response)) flattened_response
join (
select date,
volume
from external.defillama.fact_dex_volume
where protocol = 'dexalot') as t1
on t1.date = to_timestamp (flattened_response.value:timestamp)::date
where t1.date >= '{{From_Date}}' and t1.date <= '{{To_Date}}')
select date_trunc ({{Time_Interval}},block_timestamp) as date,
count (Distinct trader) as Swappers,
sum (coalesce (volume,0)) as Trading_Volume,
avg (coalesce (volume,0)) as Average_Trading_Volume,
median (coalesce (volume,0)) as Median_Trading_Volume,
Trading_Volume / Swappers as Volume_Per_Trader
from dextable
Last run: about 17 hours agoAuto-refreshes every 24 hours
...
224
18KB
42s