flipside

    Top collections by Total Amount
    freemartianTop collections by Total Amount
    Updated 8 days ago
    WITH collections AS (
    SELECT
    value:collectionId 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 (
    SELECT
    block_timestamp,
    tx_hash,
    from_address AS buyer,
    value AS amount
    FROM monad.testnet.fact_traces
    WHERE
    origin_to_address = '0x0000000000000068f116a894984e2db1123eb395'
    AND origin_function_signature = '0xe7acab24'
    AND tx_succeeded
    AND trace_address = 'ORIGIN'
    ORDER BY 1 DESC
    ),
    datas AS (
    SELECT
    t.block_timestamp,
    t.tx_hash,
    l.contract_address,
    COALESCE(c.collection_name,
    CASE
    WHEN contract_address = '0xb7e3a569a027329f72ee353a513685c87cdc5bfa' THEN 'Haha'
    WHEN contract_address = '0x3a9acc3be6e9678fa5d23810488c37a3192aaf75' THEN 'Monadverse: Chapter 2'
    WHEN contract_address = '0xba838e4cca4b852e1aebd32f248967ad98c3aa45' THEN 'Monadverse Chapter: 4'
    WHEN contract_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' THEN 'Monadverse: Chapter 1'
    WHEN contract_address = '0xcab08943346761701ec9757befe79ea88dd67670' THEN 'Monadverse: Chapter 3'
    WHEN contract_address = '0x5d2a7412872f9dc5371d0cb54274fdb241171b95' THEN 'Monadverse Chapter V: The Heroes Assemble'
    WHEN contract_address = '0x813fa68dd98f1e152f956ba004eb2413fcfa7a7d' THEN 'Monadverse: Chapter 6'
    Last run: 8 days ago
    COLLECTION
    CONTRACT_ADDRESS
    TRANSACTIONS
    BUYERS
    TOTAL_AMOUNTS
    1
    		Other Collections10008567704751197706.56115146
    2
    		Nad Name Service0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308132387379621164838.67752119
    3
    		Molandaks0x66e40f67afd710386379a6bb24d00308f81c183f42963384776778.425088877
    4
    		Skrumpets0xe8f0635591190fb626f9d13c49b60626561ed145247211747569
    5
    		Purple Frens0xc5c9425d733b9f769593bd2814b6301916f91271643535635184.8289
    6
    		Monad Dog0x4f6a24dd5173eb3e2cd5d8fe3431ea45c307030d141044849478762.27017068
    7
    		Molandaks Mint Pass0x6341c537a6fc563029d8e8caa87da37f227358f4116113433801.1798999
    8
    		MonBois0x2fc49a061b8ec3615b5cd1806bf287909069c5be928379342000.344
    9
    		Foggy0x0f2f2da004acc38f05858f9dbc0320db64c1b6c940641530306724.27923
    10
    		Monadverse: Chapter 20x3a9acc3be6e9678fa5d23810488c37a3192aaf751719516259248035.701438093
    11
    		LaMouchNFT0x800f8cacc990dda9f4b3f1386c84983ffb65ce9435112886243486.2423797
    12
    		Mecha Box Mint Pass0x3db6c11474893689cdb9d7cdedc251532cadf32b155142241113
    13
    		Chogs Mystery Chest0xe6b5427b174344fd5cb1e3d5550306b0055473c68782191149.38
    14
    		Meowwnads0xa568cabe34c8ca0d2a8671009ae0f6486a31442531712118183602.312176865
    15
    		MfersOnMonad0x03e0407332c6584e82b3ce5662184baf0261717938041591170045.249553198
    16
    		CatMon0x82eb1742eb84611ae0bb4231083d5227ca1d0680596324165684.996799
    17
    		Scroll of Coronation0x4fcf36ac3d46ef5c3f91b8e3714c9bfdb46d63a3310133153029.38
    18
    		Monadverse Chapter: 40xba838e4cca4b852e1aebd32f248967ad98c3aa452378422139147127.662379717
    19
    		Beannad0xb03b60818fd7f391e2e02c2c41a61cff86e4f3f555724472142081.2418965
    20
    		r3tards0xed52e0d80f4e7b295df5e622b55eff22d262f6ed10797141732.6866
    ...
    101
    8KB
    39s