flipside

    J&R On Opensea Time
    i_danJ&R On Opensea Time
    Updated 3 days ago
    Select
    date_trunc(hour, n.block_timestamp) AS "Hour"
    , n.name AS "NFT Name"
    , COUNT(n.tx_hash) AS "Mints"
    , COUNT(DISTINCT n.to_address) AS "Minters"
    -- , COUNT(CASE WHEN n.from_address = '0x0000000000000000000000000000000000000000' THEN n.tx_hash END) AS Mint
    -- , COUNT(CASE WHEN n.from_address != '0x0000000000000000000000000000000000000000' THEN tx_hash END) AS Other_Activity
    , SUM(t.tx_fee) AS "Transaction Fee Spent"
    , COUNT(CASE WHEN t.tx_succeeded THEN n.tx_hash END) AS "Successful Mint"
    , COUNT(CASE WHEN NOT t.tx_succeeded THEN n.tx_hash END) AS "Failed Mint"

    FROM ronin.nft.ez_nft_transfers n
    LEFT JOIN ronin.core.fact_transactions t on t.tx_hash = n.tx_hash
    WHERE n.contract_address IN ('0xc2f09694fcc9c9ddcbe54a72b1a3b14658d2f755', '0x2fb6feb663c481e9854a251002c772fead3974d6')
    AND n.from_address = '0x0000000000000000000000000000000000000000'
    GROUP BY 1, 2
    ORDER BY 1 DESC, 3 DESC


    Last run: 3 days ago
    Hour
    NFT Name
    Mints
    Minters
    Transaction Fee Spent
    Successful Mint
    Failed Mint
    1
    		2025-03-29 15:00:00.000Jin on a Sailing Ship220.00408591989920
    2
    		2025-03-29 15:00:00.000Ronke on a Sailing Ship110.00204159910
    3
    		2025-03-29 14:00:00.000Jin on a Sailing Ship126312632.58869509912630
    4
    		2025-03-29 14:00:00.000Ronke on a Sailing Ship124712472.55410585612470
    5
    		2025-03-29 13:00:00.000Ronke on a Sailing Ship288728875.89938627628870
    6
    		2025-03-29 13:00:00.000Jin on a Sailing Ship134413442.74858158613440
    7
    		2025-03-29 12:00:00.000Jin on a Sailing Ship331833186.77723613333180
    8
    		2025-03-29 12:00:00.000Ronke on a Sailing Ship197619764.06302930319760
    9
    		2025-03-29 11:00:00.000Jin on a Sailing Ship193919394.03881156819390
    10
    		2025-03-29 11:00:00.000Ronke on a Sailing Ship184418443.92774838618440
    11
    		2025-03-29 10:00:00.000Ronke on a Sailing Ship183018303.863194518300
    12
    		2025-03-29 10:00:00.000Jin on a Sailing Ship153215323.23309230215320
    13
    		2025-03-29 09:00:00.000Ronke on a Sailing Ship190119014.06690106719010
    14
    		2025-03-29 09:00:00.000Jin on a Sailing Ship183818383.86287760818380
    15
    		2025-03-29 08:00:00.000Jin on a Sailing Ship240224024.91353930224020
    16
    		2025-03-29 08:00:00.000Ronke on a Sailing Ship162416243.45296088416240
    17
    		2025-03-29 07:00:00.000Ronke on a Sailing Ship229222925.01022733422920
    18
    		2025-03-29 07:00:00.000Jin on a Sailing Ship154615463.3075406415460
    19
    		2025-03-29 06:00:00.000Ronke on a Sailing Ship226522655.01829289922650
    20
    		2025-03-29 06:00:00.000Jin on a Sailing Ship169216923.70200590116920
    ...
    194
    16KB
    3s