flipside

    All collections
    freemartianAll collections
    Updated 2025-06-06
    WITH collections AS (
    SELECT
    value:address AS collection_address,
    value:name AS collection_name
    FROM (
    SELECT livequery.live.udf_api('https://raw.githubusercontent.com/mehdimarjan/magiceden-on-monad/refs/heads/main/collections.json') AS response
    ), LATERAL FLATTEN (input => response:data)
    ),
    transactions AS (

    -- ======= single sale =======

    select
    el.block_timestamp,
    el.tx_hash,
    el.origin_from_address AS buyer,
    tr.value AS amount,
    count(*) as nft_count,
    'MON' as token_paid,
    1 as rank,
    FROM monad.testnet.fact_event_logs el
    LEFT JOIN monad.testnet.fact_transactions tr ON (el.tx_hash = tr.tx_hash)
    WHERE
    el.origin_to_address = '0x0000000000000068f116a894984e2db1123eb395'
    AND el.contract_address <> '0x0000000000000068f116a894984e2db1123eb395'
    AND el.origin_function_signature = '0xe7acab24'
    AND el.tx_succeeded
    -- AND el.block_timestamp::date > current_date - 30
    group by
    el.block_timestamp,
    el.tx_hash,
    el.origin_from_address,
    tr.value

    union all

    Last run: 12 days ago
    CONTRACT_ADDRESS
    COLLECTION_NAME
    TRANSACTIONS
    NFTS_SOLD
    BUYERS
    AMOUNTS
    RANK
    1
    		0xe8f0635591190fb626f9d13c49b60626561ed145
    Skrumpets
    		4624853182086335.21🥇
    2
    		0xc5c9425d733b9f769593bd2814b6301916f91271
    Purple Frens
    		120312338491488478.02023101🥈
    3
    		0x66e40f67afd710386379a6bb24d00308f81c183f
    Molandaks
    		7424798046131386838.70461829🥉
    4
    		0x6341c537a6fc563029d8e8caa87da37f227358f4
    Molandaks Mint Pass
    		2582652321333719.1709014
    5
    		0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308
    Nad Name Service
    		100399340558548531245467.209675585
    6
    		0x26c86f2835c114571df2b6ce9ba52296cc0fa6bb
    Lil Chogstars
    		888882829234.900645946
    7
    		0x87e1f1824c9356733a25d6bed6b9c87a3b31e107
    Spikes
    		179419351122826660.5436419367
    8
    		0xa568cabe34c8ca0d2a8671009ae0f6486a314425
    Meowwnads
    		608865963388765897.7583567258
    9
    		0x3a9acc3be6e9678fa5d23810488c37a3192aaf75
    Monadverse: Chapter 2
    		344133556930755720110.7430792689
    10
    		0xe6b5427b174344fd5cb1e3d5550306b0055473c6
    Chogs Mystery Chest
    		251251199678374.66055510
    11
    		0xce3be27bdf0922e92bbf3c2eefbb26487946ed4c
    Monadverse: Chapter 8
    		344603460530173642836.01874988211
    12
    		0x4870e911b1986c6822a171cdf91806c3d44ce235
    Sealuminati Testnetooor
    		697599853998580893.20865626412
    13
    		0x3a9454c1b4c84d1861bb1209a647c834d137b442
    The10kSquad
    		577369533448513018.57851662213
    14
    		0x1af07e2367046c22bfe2b13c70b4a585cabe8875
    Talentum Community Arts
    		10091400971849502188.50491640414
    15
    		0x813fa68dd98f1e152f956ba004eb2413fcfa7a7d
    Monadverse: Chapter 6
    		318923209629141499475.72322912115
    16
    		0x3db6c11474893689cdb9d7cdedc251532cadf32b
    Mecha Box Mint Pass
    		280280224498263.62197516
    17
    		0xed52e0d80f4e7b295df5e622b55eff22d262f6ed
    r3tards
    		186196157479722.50717
    18
    		0xc29b98dca561295bd18ac269d3d9ffdfcc8ad426
    Monadverse: Chapter 7
    		318313235627376437290.79926313118
    19
    		0x800f8cacc990dda9f4b3f1386c84983ffb65ce94
    LaMouchNFT
    		579764164290432930.815015719
    20
    		0x88bbcba96a52f310497774e7fd5ebadf0ece21fb
    Chewy
    		9911098642428708.9332378920
    ...
    2215
    195KB
    455s