DAY | TOTAL_HOLDERS | |
|---|---|---|
1 | 2025-02-22 00:00:00.000 | 2606 |
2 | 2025-02-23 00:00:00.000 | 2722 |
3 | 2025-02-24 00:00:00.000 | 2981 |
4 | 2025-02-25 00:00:00.000 | 3155 |
5 | 2025-02-26 00:00:00.000 | 3249 |
6 | 2025-02-27 00:00:00.000 | 4104 |
7 | 2025-02-28 00:00:00.000 | 4293 |
8 | 2025-03-01 00:00:00.000 | 4393 |
9 | 2025-03-02 00:00:00.000 | 4475 |
10 | 2025-03-03 00:00:00.000 | 4565 |
11 | 2025-03-04 00:00:00.000 | 4630 |
12 | 2025-03-05 00:00:00.000 | 4788 |
13 | 2025-03-06 00:00:00.000 | 4925 |
14 | 2025-03-07 00:00:00.000 | 4975 |
15 | 2025-03-08 00:00:00.000 | 5021 |
16 | 2025-03-09 00:00:00.000 | 5066 |
17 | 2025-03-10 00:00:00.000 | 5271 |
18 | 2025-03-11 00:00:00.000 | 5332 |
19 | 2025-03-12 00:00:00.000 | 5379 |
20 | 2025-03-13 00:00:00.000 | 5405 |
feyikemiDaily Holders
Updated 2025-03-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 transfers AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS tx_day,
TO_ADDRESS AS wallet,
AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND TO_ADDRESS != '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT
DATE_TRUNC('day', block_timestamp) AS tx_day,
FROM_ADDRESS AS wallet,
-AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
),
all_days AS (
SELECT DISTINCT DATE_TRUNC('day', block_timestamp) AS day
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
),
wallet_daily_balances AS (
SELECT
tx_day,
wallet,
SUM(amount) AS daily_net
FROM transfers
GROUP BY tx_day, wallet
),
wallet_cumulative AS (
Last run: 2 months ago
33
1KB
2s