flipside

    Top 100 collections by Total Amount
    freemartianTop 100 collections by Total Amount
    Updated 1 hour ago
    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

    -- ======= bulk sale (single buyer) =======
    Last run: about 1 hour agoAuto-refreshes every 1 hour
    COLLECTION
    CONTRACT_ADDRESS
    TRANSACTIONS
    BUYERS
    TOTAL_AMOUNTS
    1
    		Other Collections157137211708105531030.20764555
    2
    		Skrumpets0xe8f0635591190fb626f9d13c49b60626561ed1454413061840807.1
    3
    		Purple Frens0xc5c9425d733b9f769593bd2814b6301916f9127111248071371932.24922101
    4
    		Molandaks0x66e40f67afd710386379a6bb24d00308f81c183f714144671343649.22144958
    5
    		Nad Name Service0x3019bf1dfb84e5b46ca9d0eec37de08a59a4130890664516631203628.47775588
    6
    		Molandaks Mint Pass0x6341c537a6fc563029d8e8caa87da37f227358f42121911071130.1598999
    7
    		Spikes0x87e1f1824c9356733a25d6bed6b9c87a3b31e1071443925727262.716332824
    8
    		Meowwnads0xa568cabe34c8ca0d2a8671009ae0f6486a31442558213292703251.275502945
    9
    		Lil Chogstars0x26c86f2835c114571df2b6ce9ba52296cc0fa6bb5753645789.90064594
    10
    		Monadverse: Chapter 20x3a9acc3be6e9678fa5d23810488c37a3192aaf753046527382596681.282058254
    11
    		Chogs Mystery Chest0xe6b5427b174344fd5cb1e3d5550306b0055473c6215177592781.300655
    12
    		Sealuminati Testnetooor0x4870e911b1986c6822a171cdf91806c3d44ce23565453711495480.703410624
    13
    		The10kSquad0x3a9454c1b4c84d1861bb1209a647c834d137b44253723218471309.292006222
    14
    		Mecha Box Mint Pass0x3db6c11474893689cdb9d7cdedc251532cadf32b253205442183.301975
    15
    		Talentum Community Arts0x1af07e2367046c22bfe2b13c70b4a585cabe887567451106418356.109333507
    16
    		LaMouchNFT0x800f8cacc990dda9f4b3f1386c84983ffb65ce9455594112414101.3241047
    17
    		r3tards0xed52e0d80f4e7b295df5e622b55eff22d262f6ed177151405922.507
    18
    		Monadverse: Chapter 80xce3be27bdf0922e92bbf3c2eefbb26487946ed4c2776624242397536.234987
    19
    		Chewy0x88bbcba96a52f310497774e7fd5ebadf0ece21fb869565392764.81323799
    20
    		Monadverse: Chapter 60x813fa68dd98f1e152f956ba004eb2413fcfa7a7d2769325508387863.037150231
    ...
    101
    8KB
    886s