BLOCK_TIMESTAMP | TX_HASH | NFT_CONTRACT | SELLER | BUYER | TOKEN_ID | FINAL_PRICE | GAS_FEE | TRANSFER_TYPE | ROW_NUM | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-02-19 16:05:51.000 | 0xf8dfdde083bf3ad7925ae358bbab76c9fe40d4370dddab41a8a064cd10e5c13b | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x78d07358af56736f660053a95aaf020d4df37654 | 0 | 25 | 0.0214526832 | minted | 1 |
2 | 2025-02-19 16:05:53.000 | 0xa9f3259d5c32fe9c55437a9e8c8865a773c1a70eb370f7efd854bbed73d1afd2 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x62019def3369d46e3011b213f99a3f2819448b45 | 1 | 25 | 0.0214526832 | minted | 1 |
3 | 2025-02-19 16:07:32.000 | 0x4517d3e6f83e7d0c4e92b9454eca12b8ffacb4f8629d8af4f62e707bd40601f1 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x4a5fe6843eb2db4ba71d82e0e0c6cf5d29fc776d | 2 | 0 | 0.008186048 | minted | 1 |
4 | 2025-02-19 16:07:42.000 | 0x8598aeb59bd3cc69bd9324268af9523cb7ede52dd2d791b7823953e9392f7961 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x18b95f1aafcb42c11fe0145b754954347e781606 | 3 | 0 | 0.0081848 | minted | 1 |
5 | 2025-02-19 16:07:59.000 | 0x8b179fa61f7d0200a9d4582d3cd4f5c2cd52705cb274384d817512021e0604f7 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xc539034a9ba4d6c612421b72be5f84d9c8463cbb | 4 | 0 | 0.008186672 | minted | 1 |
6 | 2025-02-19 16:08:00.000 | 0x83dc016b04073491325a4a0180b3ab0878ccc5e5c953218a77c0b6173d8f46c4 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xecc830d5427c563daa120e09c350e323b701e51c | 5 | 0 | 0.008071752 | minted | 1 |
7 | 2025-02-19 16:08:06.000 | 0x77a9d92cd900d1c29c185ba3f199f916cecdf786040266674497cf6dc59f419a | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x95cb32be2265a0522c283d004632eb613537f49c | 6 | 0 | 0.008187348 | minted | 1 |
8 | 2025-02-19 16:08:06.000 | 0x4f1767bc6979311545d563a3b48f610d8df88a4d55dcdf74c2426b6c21b52fa6 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x8fa3f0843c44b39bef932e9472709a7858ec2ec6 | 7 | 0 | 0.008187348 | minted | 1 |
9 | 2025-03-12 03:47:11.000 | 0xc834b2cad4e600f87f69531f561cf3d2a8d70a77a80b29b6725c1ac1656c9802 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x8fa3f0843c44b39bef932e9472709a7858ec2ec6 | 0xa3a16cc35eac85d2d5623d73959ca3757089fb57 | 7 | 1450 | 0.01733732 | instant_sell | 2 |
10 | 2025-03-12 19:28:38.000 | 0x40f22c2d940d3173fae1a7dcfcf0d0743f111f98d2ef90711ae976df676a52fd | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0xa3a16cc35eac85d2d5623d73959ca3757089fb57 | 0xbcaeaaa71d3cb592dcee414da94206c045fae60e | 7 | 1800 | 0.009010196 | listed_fulfill | 3 |
11 | 2025-02-19 16:08:10.000 | 0x47b9d813885849e985ce4fc1ae8b81e9fb07ae0dd9f9c735d26693d40aa9f4a9 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xf5ede9501e8827ff9dc13a83dc967f9b7bef4024 | 8 | 0 | 0.0078712 | minted | 1 |
12 | 2025-02-19 16:09:03.000 | 0xce06809fa2f436e0156d70324ecadf51b2779c7bc0ff953dc81140c19da5195c | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xe668569e8e4ec78a9054be071290f76fa420097d | 9 | 0 | 0.008186048 | minted | 1 |
13 | 2025-02-19 16:09:04.000 | 0x85dbf4c66802bfcc62caa58085d683cc9610222303d12ff5a1861e95df28b613 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x034187bd94b15b7503d1819d6a64cd1f0fc59b8c | 10 | 0 | 0.008187348 | minted | 1 |
14 | 2025-02-19 16:09:32.000 | 0x46b838f51a0daf1a9ccfd97a02bac8a13293b143835b672f31044b159ba4ee2f | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xf4ec1661a9b6229038b51e2ff8ae347f5f2e1901 | 11 | 0 | 0.008186672 | minted | 1 |
15 | 2025-02-19 16:09:35.000 | 0xdec137776184545d4d5121418d8bb9e173c79877a5654a85361448986ef35cc5 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x2dda79f2af4b411d0c23e96db2a06a5b80dcfba2 | 12 | 0 | 0.008187348 | minted | 1 |
16 | 2025-02-21 12:08:54.000 | 0x17902e878bfda3065f6576b310dcbe5c774f82077ecf1ec59ebc5537834d9faf | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x2dda79f2af4b411d0c23e96db2a06a5b80dcfba2 | 0x000000a584697755a0378444f34fec06229b7e38 | 12 | 3500 | 0.00898092 | listed_fulfill | 2 |
17 | 2025-03-09 03:41:23.000 | 0x647f8893f22a73eab76897523384afd7ce4a2455b5454521785d2f117cc5e7d7 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x000000a584697755a0378444f34fec06229b7e38 | 0x62f76deccd33bf2d1dd5263231b08d44300c7bcd | 12 | 2990 | 0.009012692 | listed_fulfill | 3 |
18 | 2025-02-19 16:09:43.000 | 0xafab7ffd792df2874fae901748d3f0b6f38ebeafa69577fdb23abdfea3f261c8 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x6cc78993fc28d60b6653a2e7e89d6a5b69975e6b | 13 | 0 | 0.0147360096 | minted | 1 |
19 | 2025-02-19 16:09:59.000 | 0x2d2f80e2b0fcf1d5dd8c4c4f36c2b8bbecf61efb4f15a92db5dbd61837483747 | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xa9342dbb10d10bc034c582effce3c2935f0f329b | 14 | 0 | 0.0147348864 | minted | 1 |
20 | 2025-02-22 00:27:17.000 | 0x40346a14990304ef046601c5b78c8f92e7953a4f5175fc36a01cf95d73dbd6fb | 0xe8f0635591190fb626f9d13c49b60626561ed145 | 0x1e3cfee7b721e17b057e93d2e4af33723818f766 | 0xa3a16cc35eac85d2d5623d73959ca3757089fb57 | 352 | 2650 | 0.01702948 | instant_sell | 3 |
JeffersComplete transfer schema
Updated 2025-03-24
999
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
›
⌄
with tx_hashes as
(
select
distinct m.tx_hash
from monad.testnet.fact_event_logs m
join monad.testnet.fact_transactions t
on m.tx_hash = t.tx_hash
where (m.contract_address = '0xe8f0635591190fb626f9d13c49b60626561ed145' -- include all txs related to the NFT address
or (m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' and m.origin_to_address = '0x224ecb4eae96d31372d1090c3b0233c8310dbbab')) -- include txs that involve a payment for a NFT on Magic Eden
and m.block_timestamp >= '2025-02-19 16:00:00' -- start of minting phase
and t.tx_succeeded = TRUE
),
transfers as -- this part decodes hexadecimal values to numeric and make sure only the relevant tx hashes are included
(
select
m.block_timestamp,
m.tx_hash,
m.contract_address AS nft_contract,
m.origin_from_address,
m.origin_to_address,
m.topic_0,
m.topic_1,
m.topic_2,
CASE
when topic_3 = NULL
then 0
else TO_NUMERIC(utils.udf_hex_to_int(topic_3)) -- convert tokenid to numeric
END as token_id,
CASE
when m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
then TO_NUMERIC(utils.udf_hex_to_int(REPLACE(m.data, '0x0000000000000000000000000000000000000000000000', ''))) / POWER(10,18) -- make the hex WMON value numeric
else 0
END as data_converted,
t.value as MON_value,
t.tx_fee as gas_fee
Last run: about 1 month ago
...
1246
336KB
64s