ADJUSTED_TIMESTAMP | TX_HASH | TOKEN_ID | FINAL_PRICE | |
|---|---|---|---|---|
1 | 2025-03-03 19:00:30.000 | 0x37e5145cdf0c02d3f70f3a6c8e1ace60e715e92433ed549f1fff679740986c5b | 47 | 199 |
2 | 2025-03-03 19:02:51.000 | 0x3c0dc68b2a031ff48a4e348119e3bd26c7c25b33152a36db0fe505da544a1c9e | 48 | 280 |
3 | 2025-03-03 18:45:17.000 | 0xf7856a7592ac020ad881d4fb06a3fe10e95be4d288b19efbae423bc18ecfea73 | 48 | 64 |
4 | 2025-03-03 18:46:07.000 | 0x3e64a9c18562b1c72260bc89b44ec8660a663d56934de2060071536a9faaed6b | 47 | 63 |
5 | 2025-03-03 18:48:40.000 | 0xa163208887e5b316faba57f81151913a4374fb4b1a2909863e5ddb7fdff672b3 | 49 | 125 |
6 | 2025-03-03 19:11:27.000 | 0xfc7404e4ae7f09f378b5d332e66c4d238a8fb6c19048857256cb54e65cf3fa28 | 36 | 290 |
7 | 2025-03-03 19:16:44.000 | 0x1b26c62defdd8b60a076713980548b1ed4e6c3e3784bc44bce0c0ad1f8dc4612 | 41 | 100 |
8 | 2025-03-03 19:50:57.000 | 0x6026ca9c3aec921bfd37fcab073e9f66cce06f296bfb589771ee5b18019a9d30 | 64 | 205 |
9 | 2025-03-03 20:05:21.000 | 0xeabab258c8072b9c2ccde2cb5c566abbb2b814050e5c38ca15d30cb1b1913080 | 67 | 350 |
10 | 2025-03-03 21:01:43.000 | 0xa930a3ed5f73e351bd8df1e9ad897e2c6d49e3ae8e2bcca54df350676f0be1be | 34 | 180 |
11 | 2025-03-03 21:26:46.000 | 0x45113f898c34a4091f5efba76a454c4f092d32b4ec238e3db8c104ed36eeaf22 | 20 | 96.1 |
12 | 2025-03-03 23:02:36.000 | 0xaee890a46d745098996c43885b47317137b66a734129e5e91af76e16c9e28604 | 6 | 249 |
13 | 2025-03-03 23:15:12.000 | 0x057a498424799ebddc1eb473d045f3d74bd6223a6ab43b34fb897d08da0855f4 | 131 | 96 |
14 | 2025-03-04 05:37:45.000 | 0x0bbd123af751c23a19510ff01b5719f2774b926364c27ae863db881526934c14 | 20 | 210 |
15 | 2025-03-04 07:55:32.000 | 0xc54bb97c61f12797eab8a9ce238bf8ae9d8fbccd9b8f5f79971c797a07949079 | 150 | 100 |
16 | 2025-03-03 18:52:48.000 | 0x3a93b7551810bff6e8ab9c86588314440b13c7e143f9f253e1215a5057df4d80 | 36 | 101 |
17 | 2025-03-03 18:53:24.000 | 0x350e1c56dbc1f2414e2bb185ff310484c79c0826ef5468094c3ba3a13e74cab0 | 14 | 100 |
18 | 2025-03-05 01:59:12.000 | 0xd8fe0d7c841fc31207ad3dc077d5525701cbcf63eaca115a1966300aa0bdaeab | 140 | 113 |
19 | 2025-03-05 03:43:45.000 | 0x7e194c33185c0fc3fdc38b8e6c2b2ff706243d30dc5a4971c05420046083826f | 146 | 163.9996 |
20 | 2025-03-05 06:39:39.000 | 0x0d4fee7e6a35a251c09be40077105bcf8e9715eb7b5a8399ecb18660e7f4e91e | 277 | 112.03 |
JeffersSold prices over time
Updated 2025-03-28
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 = '0xed52e0d80f4e7b295df5e622b55eff22d262f6ed' -- 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-03-03 18:33: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
...
158
16KB
66s