flipside

    NFT Transfers Breakdown
    FatemeTheLadyNFT Transfers Breakdown
    Updated 2025-02-12
    SELECT
    nft.name as "NFT Name",
    CASE
    WHEN nft.name = 'Lumiterra Game Item' THEN nft.name
    ELSE 'others'
    END AS "NFT Category",
    COUNT(*) AS "Total NFT Transfers"
    FROM ronin.nft.ez_nft_transfers nft
    WHERE DATE(nft.block_timestamp) >= '2024-10-01'
    GROUP BY 1,2
    ORDER BY 3 desc
    Last run: about 2 months ago
    NFT Name
    NFT Category
    Total NFT Transfers
    1
    		Pixel Dungeons Itemsothers7648234
    2
    		Lumiterra Game ItemLumiterra Game Item5674264
    3
    		Axieothers3345635
    4
    		Wild Forest Unitsothers1749414
    5
    		Axie Consumable Itemothers1452536
    6
    		Nyang Kitothers1187189
    7
    		Axie Materialothers1031022
    8
    		PHZMothers1013722
    9
    		The Machines Arena Componentsothers426674
    10
    		others416369
    11
    		Ragnarok Monstersothers354981
    12
    		Wild Forest Packsothers113953
    13
    		Primal HeroZothers101819
    14
    		RTTempothers100000
    15
    		Axie Runeothers72520
    16
    		Axie Accessoryothers60343
    17
    		Farm Landothers52368
    18
    		others49552
    19
    		FightLeagueChipsothers48756
    20
    		Wild Forest Skinsothers46951
    94
    3KB
    2s