BLOCK_TIMESTAMP | TX_HASH | NFT_CONTRACT | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | TOPIC_0 | TOPIC_1 | TOPIC_2 | TOPIC_3 | TOKEN_ID_ | DATA_CONVERTED | MON_VALUE | GAS_FEE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-03 15:12:26.000 | 0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d | 0xed52e0d80f4e7b295df5e622b55eff22d262f6ed | 0x0405313c22750208f92a1b5131b4f91b0291c70b | 0x000000009e44eba131196847c685f20cd4b68ac4 | 0x4cdc0855317fc903931370d8fa2cbf56b50c63f39e1a46f1d5859b2d91b2c2c4 | 0 | 0 | 0.009422764 | ||||
2 | 2025-03-03 15:12:26.000 | 0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d | 0xed52e0d80f4e7b295df5e622b55eff22d262f6ed | 0x0405313c22750208f92a1b5131b4f91b0291c70b | 0x000000009e44eba131196847c685f20cd4b68ac4 | 0xc7f505b2f371ae2175ee4913f4499e1f2633a7b5936321eed1cdaeb6115181d2 | 0 | 0 | 0.009422764 | ||||
3 | 2025-03-03 15:12:26.000 | 0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d | 0xed52e0d80f4e7b295df5e622b55eff22d262f6ed | 0x0405313c22750208f92a1b5131b4f91b0291c70b | 0x000000009e44eba131196847c685f20cd4b68ac4 | 0x8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e0 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000405313c22750208f92a1b5131b4f91b0291c70b | 0 | 0 | 0.009422764 | ||
4 | 2025-03-03 15:12:26.000 | 0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d | 0x000000009e44eba131196847c685f20cd4b68ac4 | 0x0405313c22750208f92a1b5131b4f91b0291c70b | 0x000000009e44eba131196847c685f20cd4b68ac4 | 0xa35e7914bdeb3c867652bf563a8fef465d3247bcbe2ee9563fe41acad61f01f9 | 0 | 0 | 0.009422764 |
Jefferscool-indigo
Updated 2025-03-25
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
›
⌄
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,
m.topic_3,
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
from monad.testnet.fact_event_logs m
join monad.testnet.fact_transactions t
on m.tx_hash = t.tx_hash
where m.tx_hash = '0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d'
Last run: about 1 month ago
4
1KB
39s