EVENT_DATE | UNIQUE_MEMBERS | MEMBERSHIP_TXNS | |
|---|---|---|---|
1 | 2025-03-19 00:00:00.000 | 1 | 1 |
2 | 2025-03-18 00:00:00.000 | 941 | 3612 |
3 | 2025-03-17 00:00:00.000 | 154 | 443 |
4 | 2025-03-16 00:00:00.000 | 269 | 858 |
5 | 2025-03-15 00:00:00.000 | 47 | 100 |
6 | 2025-03-14 00:00:00.000 | 105 | 235 |
7 | 2025-03-13 00:00:00.000 | 104 | 185 |
8 | 2025-03-12 00:00:00.000 | 154 | 495 |
9 | 2025-03-11 00:00:00.000 | 509 | 1425 |
10 | 2025-03-10 00:00:00.000 | 159 | 416 |
11 | 2025-03-09 00:00:00.000 | 189 | 433 |
12 | 2025-03-08 00:00:00.000 | 421 | 1214 |
13 | 2025-03-07 00:00:00.000 | 245 | 681 |
14 | 2025-03-06 00:00:00.000 | 967 | 2966 |
15 | 2025-03-05 00:00:00.000 | 643 | 2023 |
16 | 2025-03-04 00:00:00.000 | 241 | 857 |
17 | 2025-03-03 00:00:00.000 | 415 | 1341 |
18 | 2025-03-02 00:00:00.000 | 1666 | 5123 |
19 | 2025-03-01 00:00:00.000 | 632 | 2361 |
20 | 2025-02-28 00:00:00.000 | 329 | 1145 |
permaryGuild Membership Activity
Updated 2025-03-19
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
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS event_date,
COUNT(DISTINCT FROM_ADDRESS) AS unique_members,
COUNT(*) AS membership_txns
FROM ronin.core.fact_transactions
WHERE TO_ADDRESS = '0x7ac8de4b2d37ac6136be285ee7060e8676c9644f' -- Guild contract
AND TX_SUCCEEDED = TRUE
GROUP BY event_date
ORDER BY event_date DESC;
Last run: about 1 month ago
...
170
6KB
2s