DAY | WEEK_PERIOD | Total New Wallets | Total Fableborne New | Fableborne | Pixel | Wild Forest | Axie | Lumiterra | Other | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 476182 | 123458 | 84012 | 6728 | 547135 | |
2 | 2024-10-02 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 118558 | 574 | 5603 | 380 | 126053 | |
3 | 2024-10-03 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 127009 | 181 | 2433 | 221 | 70550 | |
4 | 2024-10-04 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 102643 | 454 | 1982 | 249 | 41028 | |
5 | 2024-10-05 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 98656 | 407 | 1421 | 59 | 28926 | |
6 | 2024-10-06 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 88564 | 230 | 1543 | 440 | 11025 | |
7 | 2024-10-07 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 98243 | 174 | 3533 | 84 | 14322 | |
8 | 2024-10-08 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 74295 | 108 | 1260 | 60 | 25298 | |
9 | 2024-10-09 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 72191 | 24 | 1028 | 52 | 9627 | |
10 | 2024-10-10 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 69017 | 31 | 921 | 78 | 16233 | |
11 | 2024-10-11 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 73521 | 27 | 964 | 34 | 10921 | |
12 | 2024-10-12 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 69809 | 42 | 1046 | 58 | 19394 | |
13 | 2024-10-13 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 66838 | 20 | 890 | 14 | 9669 | |
14 | 2024-10-14 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 12260 | 11 | 2636 | 28 | 11320 | |
15 | 2024-10-15 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 126645 | 18 | 1202 | 34 | 8782 | |
16 | 2024-10-16 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 45796 | 24 | 1016 | 53 | 11755 | |
17 | 2024-10-17 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 55038 | 16 | 1221 | 51 | 9061 | |
18 | 2024-10-18 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 77492 | 9 | 1118 | 27 | 9682 | |
19 | 2024-10-19 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 54918 | 11 | 964 | 47 | 8641 | |
20 | 2024-10-20 00:00:00.000 | Week 1 (Nov 20-26) | 7391558 | 110267 | 55204 | 6 | 987 | 113 | 16079 |
0xHaM-dGames
Updated 2025-02-12
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 contract_addresses AS (
SELECT
contract_address,
project
FROM (
VALUES
('0xd887014121ddbad4494093689997125dde30612a', 'Fableborne'),
('0x3825ff6b6ad0f460660547e5890425ee821bd02c', 'Fableborne'),
('0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee', 'Pixel'),
('0x7eae20d11ef8c779433eb24503def900b9d28ad7', 'Pixel'),
('0x1136dac182ab639632a38540c6f33c01e02e51a6', 'Wild Forest'),
('0x9d3936dbd9a794ee31ef9f13814233d435bd806c', 'Axie Infinity'),
('0x32950db2a7164ae833121501c797d79e7b79d74c', 'Axie Infinity'),
('0x05b0bb3c1c320b280501b86706c3551995bc8571', 'Axie Infinity'),
('0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3', 'Axie Infinity'),
('0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe', 'Lumiterra')
) AS t (contract_address, project)
),
total_new_wallets AS (
-- Calculate total new wallets for the entire period
SELECT
COUNT(DISTINCT t.FROM_ADDRESS) as total_new_wallets,
COUNT(DISTINCT CASE
WHEN t.TO_ADDRESS IN (
'0xd887014121ddbad4494093689997125dde30612a',
'0x3825ff6b6ad0f460660547e5890425ee821bd02c'
) THEN t.FROM_ADDRESS
END) as total_fableborne_new_wallets
FROM (
SELECT
FROM_ADDRESS,
MIN(BLOCK_TIMESTAMP) as first_tx
FROM ronin.core.fact_transactions
GROUP BY 1
) first_txs
JOIN ronin.core.fact_transactions t ON t.FROM_ADDRESS = first_txs.FROM_ADDRESS
Last run: 2 months ago
...
135
12KB
8s