DATE | LUMITERRA_NEW_ADDRESSES | TOTAL_NEW_ADDRESSES | PERCENTAGE_LUMITERRA_NEW_ADDRESSES | |
|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | 836 | 1237219 | 0.067571 |
2 | 2024-10-02 00:00:00.000 | 738 | 251150 | 0.293848 |
3 | 2024-10-03 00:00:00.000 | 758 | 200385 | 0.378272 |
4 | 2024-10-04 00:00:00.000 | 257 | 146375 | 0.175576 |
5 | 2024-10-05 00:00:00.000 | 141 | 129436 | 0.108934 |
6 | 2024-10-06 00:00:00.000 | 280 | 101775 | 0.275117 |
7 | 2024-10-07 00:00:00.000 | 107 | 67377 | 0.158808 |
8 | 2024-10-08 00:00:00.000 | 70 | 55029 | 0.127206 |
9 | 2024-10-09 00:00:00.000 | 156 | 121842 | 0.128035 |
10 | 2024-10-10 00:00:00.000 | 177 | 87217 | 0.202942 |
11 | 2024-10-11 00:00:00.000 | 83 | 85879 | 0.096648 |
12 | 2024-10-12 00:00:00.000 | 98 | 101771 | 0.096295 |
13 | 2024-10-13 00:00:00.000 | 90 | 78458 | 0.114711 |
14 | 2024-10-14 00:00:00.000 | 96 | 26894 | 0.356957 |
15 | 2024-10-15 00:00:00.000 | 87 | 137073 | 0.06347 |
16 | 2024-10-16 00:00:00.000 | 64 | 58600 | 0.109215 |
17 | 2024-10-17 00:00:00.000 | 74 | 60801 | 0.121709 |
18 | 2024-10-18 00:00:00.000 | 66 | 85858 | 0.076871 |
19 | 2024-10-19 00:00:00.000 | 164 | 73100 | 0.22435 |
20 | 2024-10-20 00:00:00.000 | 103 | 72977 | 0.14114 |
FatemeTheLadyDaily Stats copy
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 new_addresses AS (
SELECT
FROM_ADDRESS,
MIN(block_timestamp) AS first_tx_timestamp,
min(tx_hash) AS first_tx_hash
FROM ronin.core.fact_transactions
WHERE TX_SUCCEEDED=TRUE
GROUP BY FROM_ADDRESS),
lumiterra_first_tx AS (
SELECT
nft.origin_from_address,
nft.block_timestamp,
nft.tx_hash
FROM ronin.nft.ez_nft_transfers nft
JOIN new_addresses na
ON nft.origin_from_address = na.FROM_ADDRESS
AND nft.tx_hash = na.first_tx_hash
WHERE nft.name = 'Lumiterra Game Item'
),
daily_new_addresses AS (
SELECT
DATE(na.first_tx_timestamp) AS date,
COUNT(DISTINCT na.FROM_ADDRESS) AS total_new_addresses
FROM new_addresses na
GROUP BY 1
),
daily_lumiterra_new_addresses AS (
SELECT
DATE(lft.block_timestamp) AS date,
COUNT(DISTINCT lft.origin_from_address) AS lumiterra_new_addresses
FROM lumiterra_first_tx lft
GROUP BY 1
)
Last run: about 2 months ago
...
135
6KB
11s