DATE | Existing traders | New traders | Total traders | |
|---|---|---|---|---|
1 | 2023-10-30 00:00:00.000 | 2 | 11 | 13 |
2 | 2025-01-13 00:00:00.000 | 4 | 4 | 8 |
3 | 2024-04-29 00:00:00.000 | 1 | 4 | 5 |
4 | 2023-08-21 00:00:00.000 | 0 | 1 | 1 |
5 | 2025-03-03 00:00:00.000 | 5 | 3 | 8 |
6 | 2024-07-15 00:00:00.000 | 2 | 3 | 5 |
7 | 2024-07-29 00:00:00.000 | 4 | 3 | 7 |
8 | 2024-03-11 00:00:00.000 | 6 | 9 | 15 |
9 | 2025-01-27 00:00:00.000 | 6 | 4 | 10 |
10 | 2025-02-03 00:00:00.000 | 5 | 7 | 12 |
11 | 2024-06-17 00:00:00.000 | 0 | 2 | 2 |
12 | 2024-01-01 00:00:00.000 | 5 | 8 | 13 |
13 | 2023-12-04 00:00:00.000 | 5 | 6 | 11 |
14 | 2024-11-04 00:00:00.000 | 6 | 6 | 12 |
15 | 2024-01-08 00:00:00.000 | 5 | 7 | 12 |
16 | 2024-05-20 00:00:00.000 | 2 | 2 | 4 |
17 | 2023-12-18 00:00:00.000 | 4 | 8 | 12 |
18 | 2025-03-24 00:00:00.000 | 2 | 2 | 4 |
19 | 2024-10-07 00:00:00.000 | 6 | 7 | 13 |
20 | 2024-07-22 00:00:00.000 | 3 | 1 | 4 |
Hessishxdefi-arb- weekly # of new vs existing users
Updated 9 hours ago
999
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
›
⌄
-- forked from xdefi-eth- weekly # of new vs existing users @ https://flipsidecrypto.xyz/edit/queries/d79ce0bb-e471-4396-8fc3-81cc4fa39fb6
with swap_multi as (SELECT DISTINCT tx_hash as hash, ORIGIN_FROM_ADDRESS as swapper,count(*) as steps
from arbitrum.defi.ez_dex_swaps
where --tx_hash = '0x89a3e55cf2b71170881b3a1040d62baa5816a01a71cc74ad7d7b42976768d691'
BLOCK_TIMESTAMP::date >= '2023-01-01' and
ORIGIN_TO_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and ORIGIN_from_ADDRESS not in ('0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7',
'0x90ab3b8deeaa6a3cfa3c6622f140ce56e62f47e3',
'0x36e7556a3c68876387ad02196b7e125e73939115',
'0xf91e863dcc42a81536695b2e6497797935ee5b95')
GROUP by all
having steps > 1),
swap_single as (SELECT DISTINCT tx_hash as hash, ORIGIN_FROM_ADDRESS as swapper,count(*) as steps
from arbitrum.defi.ez_dex_swaps
where --tx_hash = '0x89a3e55cf2b71170881b3a1040d62baa5816a01a71cc74ad7d7b42976768d691'
BLOCK_TIMESTAMP::date >= '2023-01-01' and
ORIGIN_TO_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and ORIGIN_from_ADDRESS not in ('0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7',
'0x90ab3b8deeaa6a3cfa3c6622f140ce56e62f47e3',
'0x36e7556a3c68876387ad02196b7e125e73939115',
'0xf91e863dcc42a81536695b2e6497797935ee5b95')
GROUP by all
having steps = 1),
side_a as (
SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
FROM_ADDRESS as swapper_a,
SYMBOL as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a
from arbitrum.core.ez_token_transfers
Last run: about 9 hours agoAuto-refreshes every 24 hours
80
3KB
349s