BLOCK_NUMBER | BLOCK_TIMESTAMP | VERSION | TX_HASH | SUCCESS | TX_TYPE | SENDER | SIGNATURE | PAYLOAD | PAYLOAD_FUNCTION | CHANGES | EVENTS | GAS_UNIT_PRICE | GAS_USED | MAX_GAS_AMOUNT | EXPIRATION_TIMESTAMP_SECS | VM_STATUS | STATE_CHANGE_HASH | ACCUMULATOR_ROOT_HASH | EVENT_ROOT_HASH | FACT_TRANSACTIONS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 147002154 | 2024-02-17 21:23:05.077 | 456035891 | 0x4aadce9529296b0138757eb4f16d4ba62da26de334876025537c47e6cefc8024 | TRUE | user_transaction | 0xd44f78c25d2d9c58a5fd36ab7d8c77cb918423251fcf0b0d586e1a09bfd98333 | {"public_key":"0x13b4f5cd75762f176daddc732809b7fc8ee670b2e7d9a58e4024b59... | {"arguments":["0x664e7e4165867ff72b35a3b7a1dac36df415047082c5f7e6ff47ba5... | 0xb5a3d63d4b76e6088db9c674c478eac7433ad1136d82a411b1d7822a51bb8950::port... | [{"address":"0xb5a3d63d4b76e6088db9c674c478eac7433ad1136d82a411b1d7822a5... | [{"data":{"collection_creator":"0x664e7e4165867ff72b35a3b7a1dac36df41504... | 100 | 1512 | 3024 | 1708205072 | Executed successfully | 0xbcf056d8d71156139ee39c8c6f67afb24fa078a4f53db699b477b780ca14e5a9 | 0xef48d0197dfa232d34bdd1700bbac38aca689aa1d2391cc41f1335cf79290a64 | 0x1f687fc5e956f88c3bde07cf1f13a1a28ebb87ba46b007a5db03a3f61bdc2f34 | 717ed299e59d2b7fd312eeb58e88c3de | 2024-02-17 21:51:19.593 | 2024-02-18 00:11:12.555 |
freemartianTopaz Workspace
Updated 2024-02-18
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
›
⌄
-- offer tx: 0xa33cf5b86a5fb1651d13e9316e6633a108d1fb7f96b937d3c8c92d9465993857
-- cancel offer: 0x95e8779ee9a5a76c16642cc89d43018eba6caaa7cfb101fb4b6c7be3dedfb80b
-- buy NFT: 0x1cc7a9f0c37e9f51bedcecd11049d80c0de412d030c22c4db8cb00fafd91ef35
-- list: 0x431c34bba132ba79e318035313f2a70d48439902c9bb2e0f50701fe4dd6fbe82
-- SELECT * FROM aptos.core.fact_transactions
-- WHERE tx_hash IN (
-- '0xa33cf5b86a5fb1651d13e9316e6633a108d1fb7f96b937d3c8c92d9465993857' -- offer
-- ,
-- '0x95e8779ee9a5a76c16642cc89d43018eba6caaa7cfb101fb4b6c7be3dedfb80b' -- cancel offer
-- ,
-- '0x1cc7a9f0c37e9f51bedcecd11049d80c0de412d030c22c4db8cb00fafd91ef35' -- buy nft
-- ,
-- '0x431c34bba132ba79e318035313f2a70d48439902c9bb2e0f50701fe4dd6fbe82' -- list nft
-- )
SELECT
*
-- payload_function
-- split_part(payload_function,'::',2) || '::' || split_part(payload_function,'::',3) AS function
FROM aptos.core.fact_transactions
-- WHERE split_part(payload_function,'::',1) = '0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2'
-- GROUP BY 1
WHERE tx_hash = '0x4aadce9529296b0138757eb4f16d4ba62da26de334876025537c47e6cefc8024'
Last run: about 1 year ago
1
9KB
12s