DATE | NEW_TRADERS | CUMULATIVE_TRADERS | |
|---|---|---|---|
1 | 2025-04-28 00:00:00.000 | 2966 | 3569883 |
2 | 2025-04-21 00:00:00.000 | 10577 | 3566917 |
3 | 2025-04-14 00:00:00.000 | 7443 | 3556340 |
4 | 2025-04-07 00:00:00.000 | 4797 | 3548897 |
5 | 2025-03-31 00:00:00.000 | 9110 | 3544100 |
6 | 2025-03-24 00:00:00.000 | 16529 | 3534990 |
7 | 2025-03-17 00:00:00.000 | 13334 | 3518461 |
8 | 2025-03-10 00:00:00.000 | 19799 | 3505127 |
9 | 2025-03-03 00:00:00.000 | 14426 | 3485328 |
10 | 2025-02-24 00:00:00.000 | 12842 | 3470902 |
11 | 2025-02-17 00:00:00.000 | 15268 | 3458060 |
12 | 2025-02-10 00:00:00.000 | 14708 | 3442792 |
13 | 2025-02-03 00:00:00.000 | 7134 | 3428084 |
14 | 2025-01-27 00:00:00.000 | 30676 | 3420950 |
15 | 2025-01-20 00:00:00.000 | 24189 | 3390274 |
16 | 2025-01-13 00:00:00.000 | 61591 | 3366085 |
17 | 2025-01-06 00:00:00.000 | 52969 | 3304494 |
18 | 2024-12-30 00:00:00.000 | 110667 | 3251525 |
19 | 2024-12-23 00:00:00.000 | 110403 | 3140858 |
20 | 2024-12-16 00:00:00.000 | 8935 | 3030455 |
Ali3NDately New & Cumulative SwappersOver Time (Avalanche Chain Monitor)
Updated 1 hour 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
›
⌄
-- forked from Dately DEX Swaps Overview Over Time (Avalanche Chain Monitor) @ https://flipsidecrypto.xyz/studio/queries/5ca75191-d10f-46aa-8a2d-18701a9d48e3
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)
select date_trunc ({{Time_Interval}},mindate) as date,
count (Distinct trader) as New_Traders,
sum (new_traders) over (order by date) as Cumulative_Traders
from (
select trader,
min (block_timestamp) as mindate
from dextable
group by 1)
where mindate >= '{{From_Date}}' and mindate <= '{{To_Date}}'
group by 1
order by 1 desc
Last run: about 1 hour agoAuto-refreshes every 24 hours
...
221
9KB
8s