flipside

    RONKE: NFTs 30d Metrics copy
    i_danRONKE: NFTs 30d Metrics copy
    Updated 7 days ago
    -- 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: 7 days ago
    NFT Address
    NFT Name
    Total Transactions
    Total Users
    Item Sales
    Volume
    User To Transaction Percentage
    1
    		0x32950db2a7164ae833121501c797d79e7b79d74cAxie2871281982871281345272.830.068959
    2
    		0xa038c593115f6fcd673f6833e15462b475994879Wild Forest Units657326496573269940.140.987343
    3
    		0x12b707c3d2786570cfdc3a998a085b62acdba4b3Axie Material5961029534771673189032.814.953867
    4
    		0x4079da822e8972982b8569e38cdf719a21069934Fishing Frenzy Fish197553231975553422.831.635029
    5
    		0x578b65568b7a6a081a477748590774a64d8a4923RuniverseItem156802411568020521.361.53699
    6
    		0xc25970724f032af21d801978c73653c440cf787cAxie Rune146035391550051837.363.691022
    7
    		0x029bb759353f6547fbe387e97869057849ab4d23Ragnarok Monsters117432651174319128.882.256664
    8
    		0x727b7ff568e7173134eb02517c4a87eac390a77bFableborne Kingdoms889337888932369187.114.250534
    9
    		0xa899849929e113315200609be208e6a0858f645cWild Forest Skins845219884522253.72.342641
    10
    		0x737b80335a9396a8658405d7adcbc57343ff0558Axie Consumable Item7861123750564043785.5215.735911
    11
    		0x810b6d1374ac7ba0e83612e7d49f49a13f1de019Ronkeverse738316177383228323.5321.901666
    12
    		0x72288a7f32bec9de4a42bd19a746b9e7798996bbPrimal HeroZ4418701441832177.6115.866908
    13
    		0xeec30410b2f1a2de6bfd1030468d2d033e307378Sunflower Land Pass4121157741216551.2138.267411
    14
    		0x9c76fc5bd894e7f51c422f072675c876d5998a9eFishing Frenzy Chests3685435368512559.6311.804613
    15
    		0x883649b1d9e8b6d69ac9c36ca58531419d7dda8fFightLeagueChips290724729071744.298.496732
    16
    		0x814a9c959a3ef6ca44b5e2349e3bba9845393947Axie Charm228221324635001.49.333918
    17
    		0x554bced1db572e16fdf4c8a6f23a301f7eb0293bPixel Heroes: Material Items19011211901318.996.365071
    18
    		0xd78efaec85c1a4f42e6edb7209067702a2be8c90KaidroJournal18211311821569.277.19385
    19
    		0x5accb2f7ed043ee30565e2d8ee3c6a8f63012f01Pixel Dragons Hatchlings16134491613100282.4427.83633
    20
    		0x23924869ff64ab205b3e3be388a373d75de74ebdPrimos The Stone Age1075460107552938.0142.790698
    20
    2KB
    8s