DATE | TX | WALLET | CUMULATIVE_TX | CUMULATIVE_WALLET | |
|---|---|---|---|---|---|
1 | 2024-09-30 00:00:00.000 | 651806 | 106808 | 651806 | 106808 |
2 | 2024-10-07 00:00:00.000 | 772208 | 109507 | 1424014 | 216315 |
3 | 2024-10-14 00:00:00.000 | 787976 | 113523 | 2211990 | 329838 |
4 | 2024-10-21 00:00:00.000 | 792868 | 113352 | 3004858 | 443190 |
5 | 2024-10-28 00:00:00.000 | 826761 | 116545 | 3831619 | 559735 |
6 | 2024-11-04 00:00:00.000 | 843937 | 123148 | 4675556 | 682883 |
7 | 2024-11-11 00:00:00.000 | 895481 | 126852 | 5571037 | 809735 |
8 | 2024-11-18 00:00:00.000 | 931728 | 131037 | 6502765 | 940772 |
9 | 2024-11-25 00:00:00.000 | 950700 | 135028 | 7453465 | 1075800 |
10 | 2024-12-02 00:00:00.000 | 1037696 | 149608 | 8491161 | 1225408 |
11 | 2024-12-09 00:00:00.000 | 1065703 | 148250 | 9556864 | 1373658 |
12 | 2024-12-16 00:00:00.000 | 1087970 | 149893 | 10644834 | 1523551 |
13 | 2024-12-23 00:00:00.000 | 1066533 | 144400 | 11711367 | 1667951 |
14 | 2024-12-30 00:00:00.000 | 1041649 | 144985 | 12753016 | 1812936 |
15 | 2025-01-06 00:00:00.000 | 1060806 | 153382 | 13813822 | 1966318 |
16 | 2025-01-13 00:00:00.000 | 1101575 | 153534 | 14915397 | 2119852 |
17 | 2025-01-20 00:00:00.000 | 1125417 | 153320 | 16040814 | 2273172 |
18 | 2025-01-27 00:00:00.000 | 1142136 | 151333 | 17182950 | 2424505 |
19 | 2025-02-03 00:00:00.000 | 1156958 | 147968 | 18339908 | 2572473 |
20 | 2025-02-10 00:00:00.000 | 1130628 | 152512 | 19470536 | 2724985 |
yasminAxie_Infinity
Updated 2025-02-17
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
›
⌄
WITH Axie_Infinity AS (
SELECT *
FROM VALUES
('0x9d3936dbd9a794ee31ef9f13814233d435bd806c'),
('0x32950db2a7164ae833121501c797d79e7b79d74c'),
('0x05b0bb3c1c320b280501b86706c3551995bc8571'),
('0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3')
AS t(TO_ADDRESS)
),
Tb AS (
SELECT
t.BLOCK_TIMESTAMP,
t.TX_HASH,
t.FROM_ADDRESS
FROM ronin.core.fact_transactions t
JOIN Axie_Infinity m
ON t.TO_ADDRESS = m.TO_ADDRESS
)
SELECT
date_trunc('WEEK', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT TX_HASH) AS TX,
COUNT(DISTINCT FROM_ADDRESS) AS wallet,
SUM(COUNT(DISTINCT TX_HASH)) OVER (ORDER BY date_trunc('WEEK', BLOCK_TIMESTAMP)) AS cumulative_tx,
SUM(COUNT(DISTINCT FROM_ADDRESS)) OVER (ORDER BY date_trunc('WEEK', BLOCK_TIMESTAMP)) AS cumulative_wallet
FROM Tb
GROUP BY 1
ORDER BY 1;
Last run: 28 days ago
21
1KB
7s