DAYS | ACTIVE_WALLETS | |
|---|---|---|
1 | 2024-01-26 00:00:00.000 | 16762 |
2 | 2024-01-25 00:00:00.000 | 24242 |
3 | 2024-01-24 00:00:00.000 | 25554 |
4 | 2024-01-23 00:00:00.000 | 18001 |
5 | 2024-01-22 00:00:00.000 | 18038 |
6 | 2024-01-21 00:00:00.000 | 18446 |
7 | 2024-01-20 00:00:00.000 | 18706 |
8 | 2024-01-19 00:00:00.000 | 16939 |
9 | 2024-01-18 00:00:00.000 | 17612 |
10 | 2024-01-17 00:00:00.000 | 16717 |
11 | 2024-01-16 00:00:00.000 | 16687 |
12 | 2024-01-15 00:00:00.000 | 16970 |
13 | 2024-01-14 00:00:00.000 | 16749 |
14 | 2024-01-13 00:00:00.000 | 16159 |
15 | 2024-01-12 00:00:00.000 | 16278 |
16 | 2024-01-11 00:00:00.000 | 15085 |
17 | 2024-01-10 00:00:00.000 | 16585 |
18 | 2024-01-09 00:00:00.000 | 16875 |
19 | 2024-01-08 00:00:00.000 | 15578 |
20 | 2024-01-07 00:00:00.000 | 15451 |
0xHedmanDaily Active Wallets
Updated 2024-01-26
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 A as (
SELECT
date_trunc('day', block_timestamp) as days,
count(distinct FROM_ADDRESS) as Active_Wallets
FROM bsc.core.fact_transactions
WHERE TO_ADDRESS = '0x98f39d0f8c67885071cc99c5af1d4cacbcc89b0c'
GROUP BY 1
ORDER BY days desc
-- ),
-- B as (SELECT
-- date_trunc('day', block_timestamp) as days,
-- count(distinct FROM_ADDRESS) as Active_Wallets_Base
-- FROM base.core.fact_transactions
-- WHERE TO_ADDRESS = '0x47fbe95e981c0df9737b6971b451fb15fdc989d9'
-- GROUP BY 1
-- ORDER BY days desc)
-- SELECT A.days, Active_Wallets, Active_Wallets_Base
-- FROM
-- A LEFT JOIN B
Last run: about 1 year ago
...
370
12KB
39s