flipside

    RONKE: NFTs 30d Metrics copy
    i_danRONKE: NFTs 30d Metrics copy
    Updated 2025-04-02
    -- forked from RONKE: NFTs Daily Metrics @ https://flipsidecrypto.xyz/studio/queries/09311158-a9ea-4c70-beca-386484377bf6

    With main_data AS (
    SELECT
    block_timestamp
    , contract_address
    , name
    , tx_hash
    , is_mint
    , origin_from_address
    , from_address
    , to_address
    , quantity
    , token_id
    FROM ronin.nft.ez_nft_transfers
    WHERE block_timestamp >= current_date - INTERVAL '30 Days'
    AND contract_address != '0x810b6d1374ac7ba0e83612e7d49f49a13f1de019'
    ),

    sales_txs AS (
    SELECT
    tx_hash,
    from_address as buyer,
    symbol,
    amount,
    amount_usd
    FROM ronin.core.ez_token_transfers
    WHERE to_address IN (
    '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1',
    '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3',
    '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc'
    )
    ),

    Ronke_sales AS (
    SELECT
    Last run: about 1 month ago
    NFT Address
    NFT Name
    Total Transactions
    Total Users
    Item Sales
    Volume
    User To Transaction Percentage
    1
    		0x32950db2a7164ae833121501c797d79e7b79d74cAxie2822151912822151334180.350.067679
    2
    		0xa038c593115f6fcd673f6833e15462b475994879Wild Forest Units658616716586169812.251.018812
    3
    		0x12b707c3d2786570cfdc3a998a085b62acdba4b3Axie Material5906628234850805191392.514.779399
    4
    		0x4079da822e8972982b8569e38cdf719a21069934Fishing Frenzy Fish202913412029154054.891.680548
    5
    		0x578b65568b7a6a081a477748590774a64d8a4923RuniverseItem189674171896728630.272.198555
    6
    		0xc25970724f032af21d801978c73653c440cf787cAxie Rune147015221546667679.613.550779
    7
    		0x029bb759353f6547fbe387e97869057849ab4d23Ragnarok Monsters109072471090717317.542.264601
    8
    		0x737b80335a9396a8658405d7adcbc57343ff0558Axie Consumable Item8960126581069569207.1414.118304
    9
    		0x72288a7f32bec9de4a42bd19a746b9e7798996bbPrimal HeroZ4049583404925034.9114.398617
    10
    		0x9c76fc5bd894e7f51c422f072675c876d5998a9eFishing Frenzy Chests3989474398913426.5711.882677
    11
    		0xa899849929e113315200609be208e6a0858f645cWild Forest Skins398620539862758.765.143001
    12
    		0xf6fe00893eea4d47f0cba303ef518fe4ab1c9dd6Ragnarok347582535021770.6823.741007
    13
    		0x810b6d1374ac7ba0e83612e7d49f49a13f1de019Ronkeverse31009473100112398.4230.548387
    14
    		0xeec30410b2f1a2de6bfd1030468d2d033e307378Sunflower Land Pass282390028233337.631.880978
    15
    		0x814a9c959a3ef6ca44b5e2349e3bba9845393947Axie Charm251523726626386.069.423459
    16
    		0x554bced1db572e16fdf4c8a6f23a301f7eb0293bPixel Heroes: Material Items20851162085374.055.563549
    17
    		0x883649b1d9e8b6d69ac9c36ca58531419d7dda8fFightLeagueChips17371971737759.2611.341393
    18
    		0xd78efaec85c1a4f42e6edb7209067702a2be8c90KaidroJournal14101141410278.318.085106
    19
    		0x5accb2f7ed043ee30565e2d8ee3c6a8f63012f01Pixel Dragons Hatchlings1372394137277523.328.717201
    20
    		0xd7097f65217b28885fdd5b9511b08dcd65220b67Adventure LandZ902506902129859.956.097561
    20
    2KB
    5s