flipside

    Top 100 collections by Total Amount
    freemartianTop 100 collections by Total Amount
    Updated 2 hours 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 2 hours agoAuto-refreshes every 1 hour
    COLLECTION
    CONTRACT_ADDRESS
    TRANSACTIONS
    BUYERS
    TOTAL_AMOUNTS
    1
    		Other Collections133537310131533678800.15878695
    2
    		Skrumpets0xe8f0635591190fb626f9d13c49b60626561ed1454282981601128
    3
    		Molandaks0x66e40f67afd710386379a6bb24d00308f81c183f691543621294638.83717958
    4
    		Purple Frens0xc5c9425d733b9f769593bd2814b6301916f9127110697721260045.068211
    5
    		Molandaks Mint Pass0x6341c537a6fc563029d8e8caa87da37f227358f4194177917185.1598999
    6
    		Nad Name Service0x3019bf1dfb84e5b46ca9d0eec37de08a59a413087691544698653303.120055275
    7
    		Spikes0x87e1f1824c9356733a25d6bed6b9c87a3b31e1071167765620434.18264951
    8
    		Meowwnads0xa568cabe34c8ca0d2a8671009ae0f6486a31442555753208586149.653302945
    9
    		Monadverse: Chapter 20x3a9acc3be6e9678fa5d23810488c37a3192aaf752775425152523241.342251354
    10
    		Chogs Mystery Chest0xe6b5427b174344fd5cb1e3d5550306b0055473c6197165519871.3
    11
    		The10kSquad0x3a9454c1b4c84d1861bb1209a647c834d137b44250173040435847.799206222
    12
    		Sealuminati Testnetooor0x4870e911b1986c6822a171cdf91806c3d44ce23563503657431566.219919593
    13
    		Mecha Box Mint Pass0x3db6c11474893689cdb9d7cdedc251532cadf32b242197404489.301975
    14
    		LaMouchNFT0x800f8cacc990dda9f4b3f1386c84983ffb65ce9454464045402498.8751047
    15
    		Lil Chogstars0x26c86f2835c114571df2b6ce9ba52296cc0fa6bb3028352851
    16
    		Chewy0x88bbcba96a52f310497774e7fd5ebadf0ece21fb743482331243.79509999
    17
    		Blocknads0x6ed438b2a8eff227e7e54b5324926941b140eea0607427323233.807105736
    18
    		Monadverse: Chapter 70xc29b98dca561295bd18ac269d3d9ffdfcc8ad4262214219305316450.40456292
    19
    		Legacy Eggs0xa980f072bc06d67faec2b03a8ada0d6c9d0da9f81261786314221.532872323
    20
    		Mop Nads0xb600de0ebee70af4691dbf8a732be7791b6ce73a38891761311542.415821099
    ...
    101
    9KB
    567s