FatemeTheLadyDaily Stats
    Updated 2025-02-12
    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
    Date
    NFT
    Total NFT Transfers
    Active Addresses
    Unique NFT Contracts
    Transaction Fee (RON)
    1
    2024-10-01 00:00:00.000others8596416801453981.641928023
    2
    2024-10-01 00:00:00.000Lumiterra Game Item89378664143.408266172
    3
    2024-10-02 00:00:00.000Lumiterra Game Item83978389121.103864956
    4
    2024-10-02 00:00:00.000others12245316374482688.985555921
    5
    2024-10-03 00:00:00.000others6625714722442156.73400633
    6
    2024-10-03 00:00:00.000Lumiterra Game Item73097296118.381808716
    7
    2024-10-04 00:00:00.000others5371513412451847.493895941
    8
    2024-10-04 00:00:00.000Lumiterra Game Item67816773116.999962256
    9
    2024-10-05 00:00:00.000others5340613256451577.699007154
    10
    2024-10-05 00:00:00.000Lumiterra Game Item50915085112.780553196
    11
    2024-10-06 00:00:00.000others8148512530475379.634444446
    12
    2024-10-06 00:00:00.000Lumiterra Game Item51485141112.923670996
    13
    2024-10-07 00:00:00.000others345501040248997.257730753
    14
    2024-10-07 00:00:00.000Lumiterra Game Item3315331318.299528336
    15
    2024-10-09 00:00:00.000Lumiterra Game Item47234722111.835643216
    16
    2024-10-09 00:00:00.000others8665013787504780.996456582
    17
    2024-10-10 00:00:00.000Lumiterra Game Item51775164113.061741436
    18
    2024-10-10 00:00:00.000others8095316088503809.694582288
    19
    2024-10-11 00:00:00.000Lumiterra Game Item48844807117.065684695
    20
    2024-10-11 00:00:00.000others7059915347472302.722718236
    ...
    268
    19KB
    11s