DATE | NEW_TRADERS | CUMULATIVE_TRADERS | |
|---|---|---|---|
1 | 2025-06-16 00:00:00.000 | 5798 | 3832564 |
2 | 2025-06-09 00:00:00.000 | 36846 | 3826766 |
3 | 2025-06-02 00:00:00.000 | 95994 | 3789920 |
4 | 2025-05-26 00:00:00.000 | 28840 | 3693926 |
5 | 2025-05-19 00:00:00.000 | 40290 | 3665086 |
6 | 2025-05-12 00:00:00.000 | 29519 | 3624796 |
7 | 2025-05-05 00:00:00.000 | 16149 | 3595277 |
8 | 2025-04-28 00:00:00.000 | 10054 | 3579128 |
9 | 2025-04-21 00:00:00.000 | 10615 | 3569074 |
10 | 2025-04-14 00:00:00.000 | 7450 | 3558459 |
11 | 2025-04-07 00:00:00.000 | 4796 | 3551009 |
12 | 2025-03-31 00:00:00.000 | 9131 | 3546213 |
13 | 2025-03-24 00:00:00.000 | 16536 | 3537082 |
14 | 2025-03-17 00:00:00.000 | 13344 | 3520546 |
15 | 2025-03-10 00:00:00.000 | 19796 | 3507202 |
16 | 2025-03-03 00:00:00.000 | 14422 | 3487406 |
17 | 2025-02-24 00:00:00.000 | 12844 | 3472984 |
18 | 2025-02-17 00:00:00.000 | 15307 | 3460140 |
19 | 2025-02-10 00:00:00.000 | 14767 | 3444833 |
20 | 2025-02-03 00:00:00.000 | 7160 | 3430066 |
Ali3NDately New & Cumulative SwappersOver Time (Avalanche Chain Monitor)
Updated 12 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
›
⌄
-- 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 12 hours agoAuto-refreshes every 24 hours
...
228
9KB
182s