freemartianTopaz - test
    Updated 2024-02-19

    SELECT
    block_number,
    block_timestamp,
    version,
    tx_hash,
    success,
    tx_type,
    payload_function,
    event_index,
    event_type,
    event_resource,
    event_address,
    event_data,
    event_data:amount AS quantity,
    event_data:buyer AS buyer,
    event_data:seller AS seller,
    event_data:price/pow(10,8) AS price,
    event_data:token_id:token_data_id:collection AS collection_name,
    event_data:token_id:token_data_id:name AS nft_id,
    event_data:token_id:token_data_id:creator AS creator,
    account_address AS platform_address,
    'Topaz' AS platform_name

    FROM aptos.core.fact_events
    WHERE event_module = 'events'
    AND account_address = '0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2'
    AND event_resource IN ('ClaimEvent')
    -- WHERE tx_hash = '0xd97e5cbc2b65b259fe201307861161eee50d05f8820b42dd8b0a53970dbf9466'
    -- GROUP BY 1
    ORDER BY 2 DESC

    LIMIT 100


    Last run: over 1 year ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    VERSION
    TX_HASH
    SUCCESS
    TX_TYPE
    PAYLOAD_FUNCTION
    EVENT_INDEX
    EVENT_TYPE
    EVENT_RESOURCE
    EVENT_ADDRESS
    EVENT_DATA
    QUANTITY
    BUYER
    SELLER
    PRICE
    COLLECTION_NAME
    NFT_ID
    CREATOR
    PLATFORM_ADDRESS
    PLATFORM_NAME
    1
    1473301492024-02-18 17:24:06.5944571431950x6693955c402a6642c2617d1251f42d748bf276cac1a2a611bfe1c18ae3d15b71TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc...
    Retro Boys Club
    Retro Boys Club #1985
    0xc2e477dd246bc55f0a894d4b7cf0d520a3c2431f915a317c67159a3c5f1c630a
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    2
    1473300922024-02-18 17:23:53.8474571429970x388f0308b7d04fad5177761549f6beec524601d91c19c32e5fea692c1294a05dTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc...
    Retro Boys Club
    Retro Boys Club #1131
    0xc2e477dd246bc55f0a894d4b7cf0d520a3c2431f915a317c67159a3c5f1c630a
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    3
    1473283142024-02-18 17:17:25.0674571365110x34d1a6ed83239819651cfb0809a299d9056702c22f4848840a9e99e3ec0f0113TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xd6dd5aa453299474d394a14e310a4fb174f4f22a780afe6ad24c0aa58...
    Azumi
    Azumi #6290
    0x7be51d04d3a482fa056bc094bc5eadad005aaf823a95269410f08730f0d03cb4
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    4
    1473273032024-02-18 17:13:45.3104571329150x5267af9b3d70d05ff40d7ded5e527abf48d4f72d17c17053c8f45ab848c9d759TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xd6dd5aa453299474d394a14e310a4fb174f4f22a780afe6ad24c0aa58...
    P-GANG
    P-GANG #75
    0x829290d9fc84d4da0db3f9274d7a4bf098630055f996da415c60fc9ebd0ea982
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    5
    1473258892024-02-18 17:08:40.2604571278430xde93c7a45575dd9c9c088765d437c39b489dfd7d7b035baa04d7e8252421d769TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c...
    Artroops Society
    Artroop #595
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    6
    1473258442024-02-18 17:08:30.5724571276780x7b16914dc8826a550749d935a6a2d4d3cb5c6a463e1048ba2be106ad98ef1b70TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c...
    Artroops Society
    Artroop #2070
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    7
    1473258022024-02-18 17:08:21.1784571275220x3e6d2b6f50a5904d8810113e23ce977a419641112037ca6f4b797e218c2adabfTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c...
    Artroops Society
    Artroop #1464
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    8
    1473239022024-02-18 17:01:21.8884571201580xcbfa359cf0247fd92d4e963d9bef5299faf353c78fb9721db29d2eab315a91b5TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c...
    Artroops Society
    Artroop #1336
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    9
    1473238362024-02-18 17:01:06.9404571199010x6d5ed3227cec17d82b0761679df8a28d06ec1bf9d1d54955e67e5378addab7f2TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c...
    Artroops Society
    Artroop #1187
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    10
    1473138272024-02-18 16:23:27.1824570836210xbed2bdd062ef27a59c2621641cfd4373e4174e87feea9975967dfee5fba58c72TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc...
    Aptos Toad Overload
    Aptoad #2706
    0x74b6b765f6710a0c24888643babfe337241ad1888a55e33ed86f389fe3f13f52
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    11
    1473115622024-02-18 16:14:59.2564570755220x6a00a1e87d873db391c58a6a31e8c15381905d237bdbffa286f033e63e15d1fcTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a...
    Crypto Stars
    star #3707
    0xb7ead16bbecd22dff47d1b789042d3bce44bbba7b93232d5d48f58ae07217f7
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    12
    1473068562024-02-18 15:57:21.7964570589520x3659c0c4307ecfa3fcb34be7f323d0b9eab21ede243044d863e72185314b4bf6TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x431828c0f8b775f66fb40d83ab2e21436de89f3adf7610d251422ec68...
    Aptos Names V1
    2856.washington.apt
    0x305a97874974fdb9a7ba59dc7cab7714c8e8e00004ac887b6e348496e1981838
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    13
    1473067912024-02-18 15:57:07.3184570587370x8dff342982a26c582bca6b946158f77eb9dd8e42b15909a5439d7fa625a7fee0TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x431828c0f8b775f66fb40d83ab2e21436de89f3adf7610d251422ec68...
    Aptos Names V1
    2852.washington.apt
    0x305a97874974fdb9a7ba59dc7cab7714c8e8e00004ac887b6e348496e1981838
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    14
    1473027282024-02-18 15:41:42.4224570447010xf16a3b5c694a2b475e690948ef30583eedff31ecc95cb365fa0eabb23db00160TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x891ad4757a4bb69410db66d314c481d02e125c8baec291a9cb492d23e...
    Aptos Apes Club
    Aptos Apes Club 2
    0x5e26e7e5a52f7924089566e3f1802d6c45b3b3d274d5b4d247be6e722727a6c0
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    15
    1472947662024-02-18 15:12:06.6124570167530x620bcba699aa8482100119b129220985cf49ca21f9088335739f1f59f3f82f56TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a...
    Pepe Aptos
    Pepe Aptos #454
    0x5670874f9d1d6574af9a5ca40cad692afaef0a6125f2db80527b9c2a7d496a1a
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    16
    1472941842024-02-18 15:09:59.9184570147200x3c0cbba5477b8cca04fdb612d6baa8930e21ba9ff978e1d0e16431054e470584TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a...
    Crypto Stars
    star #3705
    0xb7ead16bbecd22dff47d1b789042d3bce44bbba7b93232d5d48f58ae07217f7
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    17
    1472933912024-02-18 15:07:02.2444570119000x14320c2e79a8f4cf98ce3519de8760d031fc4556a2bbe26a3573d9762ec5a73fTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0x891ad4757a4bb69410db66d314c481d02e125c8baec291a9cb492d23e...
    Artroops Society
    Artroop #2164
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    18
    1472932692024-02-18 15:06:35.9814570114720x44574171ab9c9bb2f095b344e0e30b92e3124a8d505370e8154bb86764e03408TRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9...
    Artroops Society
    Artroop #2175
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    19
    1472932352024-02-18 15:06:28.5464570113270xa1639363ec600ed1e5a0eed2789700898c3c6dd7f0288a00016ca11cbc8a485fTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9...
    Artroops Society
    Artroop #2144
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    20
    1472932042024-02-18 15:06:21.0234570112130xedfda1fc5e9a772f819cbbcd3311c8049943dc4d6a5e3e9023d3762e67295e3cTRUEuser_transaction
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo...
    1
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even...
    ClaimEvent0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2
    {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9...
    Artroops Society
    Artroop #1722
    0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab
    0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2Topaz
    100
    88KB
    1047s