freemartianTop 20 Collections
    Updated 2025-04-07
    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: 10 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    TX_POSITION
    TRACE_INDEX
    FROM_ADDRESS
    TO_ADDRESS
    INPUT
    OUTPUT
    TYPE
    TRACE_ADDRESS
    SUB_TRACES
    VALUE
    VALUE_PRECISE_RAW
    VALUE_PRECISE
    VALUE_HEX
    GAS
    GAS_USED
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TRACE_SUCCEEDED
    ERROR_REASON
    REVERT_REASON
    TX_SUCCEEDED
    FACT_TRACES_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342110x66e40f67afd710386379a6bb24d00308f81c183f0x833443772d5f6e8cd5a0bba210c40fa280441387
    0x00fdd58e000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    0x0000000000000000000000000000000000000000000000000000000000000001DELEGATECALL1_0_2_000000x02052634040xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUEfd2ed21a1ed7f40f11f44bc9af91e5bc2025-04-06 16:54:07.3272025-04-06 16:54:07.327
    2
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34280x66e40f67afd710386379a6bb24d00308f81c183f0x833443772d5f6e8cd5a0bba210c40fa280441387
    0xe985e9c5000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    0x0000000000000000000000000000000000000000000000000000000000000001DELEGATECALL1_0_0_000000x021526435050xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE72f35c1525f929ccca5350443d5902742025-04-06 16:54:07.3272025-04-06 16:54:07.327
    3
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342270x0000000000000068f116a894984e2db1123eb3950x00000000000000000000000000000000000000040xf1931101ef6dcf4d5950766f5d8565262ff2e46aa5dcd7fb56ed91a0524092320xf1931101ef6dcf4d5950766f5d8565262ff2e46aa5dcd7fb56ed91a052409232STATICCALL1_0_6_900000x067199180xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUEa5f98829dae61f1ec19f3d4b4bb3fd472025-04-06 16:54:07.3272025-04-06 16:54:07.327
    4
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34260x1aed60a97192157fda7fb26267a439d523d09c5e0xfdf5cfbcf6503293046ad686bb7fee8e9885b93d
    0x2b8a88ec00000000000000000000000000000000000000000000000000000000000000...
    CALL1_0120000x02306861954320xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE4a9fa35a15b55f0890a94146af9053712025-04-06 16:54:07.3272025-04-06 16:54:07.327
    5
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342310xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x66e40f67afd710386379a6bb24d00308f81c183f
    0x00fdd58e000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    0x0000000000000000000000000000000000000000000000000000000000000000STATICCALL1_0_810000x0472505780xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUEe365e34201a46e14e69bce1aa2ecc3452025-04-06 16:54:07.3272025-04-06 16:54:07.327
    6
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34230x66e40f67afd710386379a6bb24d00308f81c183f0x833443772d5f6e8cd5a0bba210c40fa280441387
    0xf242432a000000000000000000000000b9669cf3a4bcf4fbd71de40ef27f81ff311bcb...
    DELEGATECALL0_0_010000x0273136376100xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE48f08ff22496b0bf15704b0ab367d6c52025-04-06 16:54:07.3272025-04-06 16:54:07.327
    7
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342350xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x760afe86e5de5fa0ee542fc7b7b713e1c54257010x70a08231000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b93d0x000000000000000000000000000000000000000000000009414be28e52628000STATICCALL1_0_1000000x0448325410xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE9e8d00ca5d85cbf30ffac7dbf57e060e2025-04-06 16:54:07.3272025-04-06 16:54:07.327
    8
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342190x0000000000000068f116a894984e2db1123eb3950x0000000000000000000000000000000000000004
    0x000000000000000000000000000000000000000000000000000000000000007e000000...
    0x000000000000000000000000000000000000000000000000000000000000007e000000...
    STATICCALL1_0_6_300000x0168673300xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE7ec2e7e59d2b9328a575c845490492592025-04-06 16:54:07.3272025-04-06 16:54:07.327
    9
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342220x0000000000000068f116a894984e2db1123eb3950xfbf166299d3c012de9efec0240d12756c1f4c0fc
    0x4ce34aa200000000000000000000000000000000000000000000000000000000000000...
    0x4ce34aa200000000000000000000000000000000000000000000000000000000CALL1_0_6_610000x0142592358500xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE3e4f4aa4eb3837d90156a6a44f431f132025-04-06 16:54:07.3272025-04-06 16:54:07.327
    10
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342140xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x0000000000000068f116a894984e2db1123eb3950x46423aa7f1931101ef6dcf4d5950766f5d8565262ff2e46aa5dcd7fb56ed91a052409232
    0x0000000000000000000000000000000000000000000000000000000000000000000000...
    STATICCALL1_0_500000x019408224650xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE43b81f7353c8faac5bc47cde96a992572025-04-06 16:54:07.3272025-04-06 16:54:07.327
    11
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342130xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x0000000000000068f116a894984e2db1123eb395
    0x79df72bd00000000000000000000000000000000000000000000000000000000000000...
    0xf1931101ef6dcf4d5950766f5d8565262ff2e46aa5dcd7fb56ed91a052409232STATICCALL1_0_400000x019695423120xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE6a6e775457f0f3ce98c3fc0fbad3bd0b2025-04-06 16:54:07.3272025-04-06 16:54:07.327
    12
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342300xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x0000000000000068f116a894984e2db1123eb3950x46423aa7f1931101ef6dcf4d5950766f5d8565262ff2e46aa5dcd7fb56ed91a052409232
    0x0000000000000000000000000000000000000000000000000000000000000001000000...
    STATICCALL1_0_700000x0486624650xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUEc482abf5643a79c56d9e833913cf2a1b2025-04-06 16:54:07.3272025-04-06 16:54:07.327
    13
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342230xfbf166299d3c012de9efec0240d12756c1f4c0fc0x760afe86e5de5fa0ee542fc7b7b713e1c5425701
    0x23b872dd0000000000000000000000004c3d533abbc1356a564a0c81ffc129fba007a0...
    0x0000000000000000000000000000000000000000000000000000000000000001CALL1_0_6_6_000000x0137191324550xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE0b6d315b41d7729e7d11ae88d14e72b92025-04-06 16:54:07.3272025-04-06 16:54:07.327
    14
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34220xfbf166299d3c012de9efec0240d12756c1f4c0fc0x66e40f67afd710386379a6bb24d00308f81c183f
    0xf242432a000000000000000000000000b9669cf3a4bcf4fbd71de40ef27f81ff311bcb...
    CALL0_010000x0280139403050xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE681238ea092fc4647f4c2d150c6a94822025-04-06 16:54:07.3272025-04-06 16:54:07.327
    15
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342340x66e40f67afd710386379a6bb24d00308f81c183f0x833443772d5f6e8cd5a0bba210c40fa280441387
    0x00fdd58e000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    0x0000000000000000000000000000000000000000000000000000000000000000DELEGATECALL1_0_9_000000x0451144040xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUEd8416794594cb27f6a4a150e2adad37b2025-04-06 16:54:07.3272025-04-06 16:54:07.327
    16
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34270xfdf5cfbcf6503293046ad686bb7fee8e9885b93d0x66e40f67afd710386379a6bb24d00308f81c183f
    0xe985e9c5000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    0x0000000000000000000000000000000000000000000000000000000000000001STATICCALL1_0_010000x021882436790xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE87e738fe0666363daef4eca002ab00992025-04-06 16:54:07.3272025-04-06 16:54:07.327
    17
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34250x224ecb4eae96d31372d1090c3b0233c8310dbbab0x1aed60a97192157fda7fb26267a439d523d09c5e
    0x760f2a0b00000000000000000000000000000000000000000000000000000000000000...
    CALL110000x02407872021270xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE69d8a47bab590b982356e93fa7846ca62025-04-06 16:54:07.3272025-04-06 16:54:07.327
    18
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342250x66e40f67afd710386379a6bb24d00308f81c183f0x833443772d5f6e8cd5a0bba210c40fa280441387
    0xf242432a000000000000000000000000fdf5cfbcf6503293046ad686bb7fee8e9885b9...
    DELEGATECALL1_0_6_7_000000x0105005296140xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE76ea9014981bc24897a0541940f4c0652025-04-06 16:54:07.3272025-04-06 16:54:07.327
    19
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f34210x224ecb4eae96d31372d1090c3b0233c8310dbbab0xfbf166299d3c012de9efec0240d12756c1f4c0fc
    0x4ce34aa200000000000000000000000000000000000000000000000000000000000000...
    0x4ce34aa200000000000000000000000000000000000000000000000000000000CALL010000x0290760466120xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE1cd2d2adea0c444af54746ca1195feb02025-04-06 16:54:07.3272025-04-06 16:54:07.327
    20
    110089552025-04-06 15:27:12.0000x4cdc04a8e8da6a349d40b49141aa7de20129df7784a52c73cbcf4dd7d07e7f342170x0000000000000068f116a894984e2db1123eb3950x0000000000000000000000000000000000000004
    0x0000000000000000000000000000000000000000000000000000000000000003000000...
    0x0000000000000000000000000000000000000000000000000000000000000003000000...
    STATICCALL1_0_6_100000x0169283300xb9669cf3a4bcf4fbd71de40ef27f81ff311bcb4a0x224ecb4eae96d31372d1090c3b0233c8310dbbab0x74afcbe6TRUETRUE63edafef4973cd9b3ae8adfd264277e02025-04-06 16:54:07.3272025-04-06 16:54:07.327
    37
    49KB
    38s