DAY | TRANSACTION | ALL_USERS | Returning Users | New User | |
|---|---|---|---|---|---|
1 | 2024-04-09 00:00:00.000 | 22715 | 11045 | 7290 | 3755 |
2 | 2023-10-09 00:00:00.000 | 6525 | 3761 | 1628 | 2133 |
3 | 2024-04-21 00:00:00.000 | 17717 | 8602 | 5401 | 3201 |
4 | 2023-08-21 00:00:00.000 | 3807 | 1621 | 754 | 867 |
5 | 2024-06-03 00:00:00.000 | 27321 | 8143 | 5468 | 2675 |
6 | 2023-07-27 00:00:00.000 | 435 | 11 | 6 | 5 |
7 | 2023-11-11 00:00:00.000 | 6643 | 3750 | 1895 | 1855 |
8 | 2024-05-25 00:00:00.000 | 23648 | 6944 | 4684 | 2260 |
9 | 2024-12-18 00:00:00.000 | 42353 | 10719 | 7599 | 3120 |
10 | 2024-07-21 00:00:00.000 | 24561 | 7293 | 5003 | 2290 |
11 | 2024-03-06 00:00:00.000 | 8367 | 3619 | 2269 | 1350 |
12 | 2024-02-08 00:00:00.000 | 5828 | 2954 | 2186 | 768 |
13 | 2024-02-17 00:00:00.000 | 10417 | 5436 | 3029 | 2407 |
14 | 2024-07-30 00:00:00.000 | 33159 | 7173 | 5211 | 1962 |
15 | 2024-09-16 00:00:00.000 | 15766 | 5086 | 3749 | 1337 |
16 | 2024-08-07 00:00:00.000 | 33973 | 7409 | 5438 | 1971 |
17 | 2024-09-25 00:00:00.000 | 23725 | 7711 | 5460 | 2251 |
18 | 2024-03-26 00:00:00.000 | 17099 | 8789 | 4740 | 4049 |
19 | 2023-10-19 00:00:00.000 | 7334 | 3726 | 1838 | 1888 |
20 | 2025-01-07 00:00:00.000 | 35944 | 8651 | 6879 | 1772 |
freeman_7All user
Updated 2025-01-23
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
›
⌄
-- Odos volume
With advancswapAndlimit as (
select
tx_hash as hash
,origin_from_address as user
,date_trunc('day',block_timestamp) as day
from arbitrum.defi.ez_dex_swaps
--where origin_to_address = lower('0x5e4EC180fA2BaBE43a97E40354fad873D4f2A05F')
where origin_to_address = lower('0xa669e7A0d4b3e4Fa48af2dE86BD4CD7126Be4e13')
union all
select
tx_hash as hash
,origin_from_address as user
,date_trunc('day',block_timestamp) as day
from optimism.defi.ez_dex_swaps
--where origin_to_address = lower('0x8525E1A0494877aF744E33C5982e9dfBe417B2F8')
where origin_to_address = lower('0xCa423977156BB05b13A2BA3b76Bc5419E2fE9680')
union all
select
tx_hash as hash
,origin_from_address as user
,date_trunc('day',block_timestamp) as day
from ethereum.defi.ez_dex_swaps
--where origin_to_address = lower('0xC6A5e5b46ea58D2DAdb150c7A53BEC8E7d3326A6')
where origin_to_address = lower('0xCf5540fFFCdC3d510B18bFcA6d2b9987b0772559')
union all
Last run: about 2 months ago
...
558
26KB
66s