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 | 147330149 | 2024-02-18 17:24:06.594 | 457143195 | 0x6693955c402a6642c2617d1251f42d748bf276cac1a2a611bfe1c18ae3d15b71 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc... | Retro Boys Club | Retro Boys Club #1985 | 0xc2e477dd246bc55f0a894d4b7cf0d520a3c2431f915a317c67159a3c5f1c630a | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
2 | 147330092 | 2024-02-18 17:23:53.847 | 457142997 | 0x388f0308b7d04fad5177761549f6beec524601d91c19c32e5fea692c1294a05d | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc... | Retro Boys Club | Retro Boys Club #1131 | 0xc2e477dd246bc55f0a894d4b7cf0d520a3c2431f915a317c67159a3c5f1c630a | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
3 | 147328314 | 2024-02-18 17:17:25.067 | 457136511 | 0x34d1a6ed83239819651cfb0809a299d9056702c22f4848840a9e99e3ec0f0113 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xd6dd5aa453299474d394a14e310a4fb174f4f22a780afe6ad24c0aa58... | Azumi | Azumi #6290 | 0x7be51d04d3a482fa056bc094bc5eadad005aaf823a95269410f08730f0d03cb4 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
4 | 147327303 | 2024-02-18 17:13:45.310 | 457132915 | 0x5267af9b3d70d05ff40d7ded5e527abf48d4f72d17c17053c8f45ab848c9d759 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xd6dd5aa453299474d394a14e310a4fb174f4f22a780afe6ad24c0aa58... | P-GANG | P-GANG #75 | 0x829290d9fc84d4da0db3f9274d7a4bf098630055f996da415c60fc9ebd0ea982 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
5 | 147325889 | 2024-02-18 17:08:40.260 | 457127843 | 0xde93c7a45575dd9c9c088765d437c39b489dfd7d7b035baa04d7e8252421d769 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c... | Artroops Society | Artroop #595 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
6 | 147325844 | 2024-02-18 17:08:30.572 | 457127678 | 0x7b16914dc8826a550749d935a6a2d4d3cb5c6a463e1048ba2be106ad98ef1b70 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c... | Artroops Society | Artroop #2070 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
7 | 147325802 | 2024-02-18 17:08:21.178 | 457127522 | 0x3e6d2b6f50a5904d8810113e23ce977a419641112037ca6f4b797e218c2adabf | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c... | Artroops Society | Artroop #1464 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
8 | 147323902 | 2024-02-18 17:01:21.888 | 457120158 | 0xcbfa359cf0247fd92d4e963d9bef5299faf353c78fb9721db29d2eab315a91b5 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c... | Artroops Society | Artroop #1336 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
9 | 147323836 | 2024-02-18 17:01:06.940 | 457119901 | 0x6d5ed3227cec17d82b0761679df8a28d06ec1bf9d1d54955e67e5378addab7f2 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x8253e858cc6748e74073636e9853f4ba7968e2819016dc015c15a370c... | Artroops Society | Artroop #1187 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
10 | 147313827 | 2024-02-18 16:23:27.182 | 457083621 | 0xbed2bdd062ef27a59c2621641cfd4373e4174e87feea9975967dfee5fba58c72 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x806621879f6d11fe541b8c0e91dc58a8ccc3caa43cb92207dd01ba7cc... | Aptos Toad Overload | Aptoad #2706 | 0x74b6b765f6710a0c24888643babfe337241ad1888a55e33ed86f389fe3f13f52 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
11 | 147311562 | 2024-02-18 16:14:59.256 | 457075522 | 0x6a00a1e87d873db391c58a6a31e8c15381905d237bdbffa286f033e63e15d1fc | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a... | Crypto Stars | star #3707 | 0xb7ead16bbecd22dff47d1b789042d3bce44bbba7b93232d5d48f58ae07217f7 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
12 | 147306856 | 2024-02-18 15:57:21.796 | 457058952 | 0x3659c0c4307ecfa3fcb34be7f323d0b9eab21ede243044d863e72185314b4bf6 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x431828c0f8b775f66fb40d83ab2e21436de89f3adf7610d251422ec68... | Aptos Names V1 | 2856.washington.apt | 0x305a97874974fdb9a7ba59dc7cab7714c8e8e00004ac887b6e348496e1981838 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
13 | 147306791 | 2024-02-18 15:57:07.318 | 457058737 | 0x8dff342982a26c582bca6b946158f77eb9dd8e42b15909a5439d7fa625a7fee0 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x431828c0f8b775f66fb40d83ab2e21436de89f3adf7610d251422ec68... | Aptos Names V1 | 2852.washington.apt | 0x305a97874974fdb9a7ba59dc7cab7714c8e8e00004ac887b6e348496e1981838 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
14 | 147302728 | 2024-02-18 15:41:42.422 | 457044701 | 0xf16a3b5c694a2b475e690948ef30583eedff31ecc95cb365fa0eabb23db00160 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x891ad4757a4bb69410db66d314c481d02e125c8baec291a9cb492d23e... | Aptos Apes Club | Aptos Apes Club 2 | 0x5e26e7e5a52f7924089566e3f1802d6c45b3b3d274d5b4d247be6e722727a6c0 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
15 | 147294766 | 2024-02-18 15:12:06.612 | 457016753 | 0x620bcba699aa8482100119b129220985cf49ca21f9088335739f1f59f3f82f56 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a... | Pepe Aptos | Pepe Aptos #454 | 0x5670874f9d1d6574af9a5ca40cad692afaef0a6125f2db80527b9c2a7d496a1a | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
16 | 147294184 | 2024-02-18 15:09:59.918 | 457014720 | 0x3c0cbba5477b8cca04fdb612d6baa8930e21ba9ff978e1d0e16431054e470584 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xcfc3db762e4b04b027200ebe3362e6fd852e4f1fecb62236ff53a3d6a... | Crypto Stars | star #3705 | 0xb7ead16bbecd22dff47d1b789042d3bce44bbba7b93232d5d48f58ae07217f7 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
17 | 147293391 | 2024-02-18 15:07:02.244 | 457011900 | 0x14320c2e79a8f4cf98ce3519de8760d031fc4556a2bbe26a3573d9762ec5a73f | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0x891ad4757a4bb69410db66d314c481d02e125c8baec291a9cb492d23e... | Artroops Society | Artroop #2164 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
18 | 147293269 | 2024-02-18 15:06:35.981 | 457011472 | 0x44574171ab9c9bb2f095b344e0e30b92e3124a8d505370e8154bb86764e03408 | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9... | Artroops Society | Artroop #2175 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
19 | 147293235 | 2024-02-18 15:06:28.546 | 457011327 | 0xa1639363ec600ed1e5a0eed2789700898c3c6dd7f0288a00016ca11cbc8a485f | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9... | Artroops Society | Artroop #2144 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz | ||||
20 | 147293204 | 2024-02-18 15:06:21.023 | 457011213 | 0xedfda1fc5e9a772f819cbbcd3311c8049943dc4d6a5e3e9023d3762e67295e3c | TRUE | user_transaction | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::inbo... | 1 | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2::even... | ClaimEvent | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | {"receiver":"0xdacde22392b60bac2cfc30b3860699598c406f06c31fb6906dbf6a2d9... | Artroops Society | Artroop #1722 | 0x36606b5ed56ad36e6b337267adcd077c030d20c52d44a47ca9510a9350ca41ab | 0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2 | Topaz |
freemartianTopaz - test
Updated 2024-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
100
88KB
1047s