Date | NFT | Total NFT Transfers | Active Addresses | Unique NFT Contracts | Transaction Fee (RON) | |
---|---|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | others | 85964 | 16801 | 45 | 3981.641928023 |
2 | 2024-10-01 00:00:00.000 | Lumiterra Game Item | 8937 | 8664 | 1 | 43.408266172 |
3 | 2024-10-02 00:00:00.000 | Lumiterra Game Item | 8397 | 8389 | 1 | 21.103864956 |
4 | 2024-10-02 00:00:00.000 | others | 122453 | 16374 | 48 | 2688.985555921 |
5 | 2024-10-03 00:00:00.000 | others | 66257 | 14722 | 44 | 2156.73400633 |
6 | 2024-10-03 00:00:00.000 | Lumiterra Game Item | 7309 | 7296 | 1 | 18.381808716 |
7 | 2024-10-04 00:00:00.000 | others | 53715 | 13412 | 45 | 1847.493895941 |
8 | 2024-10-04 00:00:00.000 | Lumiterra Game Item | 6781 | 6773 | 1 | 16.999962256 |
9 | 2024-10-05 00:00:00.000 | others | 53406 | 13256 | 45 | 1577.699007154 |
10 | 2024-10-05 00:00:00.000 | Lumiterra Game Item | 5091 | 5085 | 1 | 12.780553196 |
11 | 2024-10-06 00:00:00.000 | others | 81485 | 12530 | 47 | 5379.634444446 |
12 | 2024-10-06 00:00:00.000 | Lumiterra Game Item | 5148 | 5141 | 1 | 12.923670996 |
13 | 2024-10-07 00:00:00.000 | others | 34550 | 10402 | 48 | 997.257730753 |
14 | 2024-10-07 00:00:00.000 | Lumiterra Game Item | 3315 | 3313 | 1 | 8.299528336 |
15 | 2024-10-09 00:00:00.000 | Lumiterra Game Item | 4723 | 4722 | 1 | 11.835643216 |
16 | 2024-10-09 00:00:00.000 | others | 86650 | 13787 | 50 | 4780.996456582 |
17 | 2024-10-10 00:00:00.000 | Lumiterra Game Item | 5177 | 5164 | 1 | 13.061741436 |
18 | 2024-10-10 00:00:00.000 | others | 80953 | 16088 | 50 | 3809.694582288 |
19 | 2024-10-11 00:00:00.000 | Lumiterra Game Item | 4884 | 4807 | 1 | 17.065684695 |
20 | 2024-10-11 00:00:00.000 | others | 70599 | 15347 | 47 | 2302.722718236 |
FatemeTheLadyDaily Stats
Updated 2025-02-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DATE_TRUNC('day', nft.block_timestamp) AS "Date",
CASE
WHEN nft.name = 'Lumiterra Game Item' THEN nft.name
ELSE 'others'
END AS NFT,
COUNT(*) AS "Total NFT Transfers",
COUNT(DISTINCT nft.origin_from_address) AS "Active Addresses",
COUNT(DISTINCT nft.contract_address) AS "Unique NFT Contracts",
SUM(t.tx_fee) AS "Transaction Fee (RON)"
FROM ronin.nft.ez_nft_transfers nft
INNER JOIN ronin.core.fact_transactions t
ON t.tx_hash = nft.tx_hash
WHERE DATE(nft.block_timestamp) >= '2024-10-01'
GROUP BY 1, 2
ORDER BY 1 ASC;
Last run: about 1 month ago
...
268
19KB
11s