BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | TX_POSITION | EVENT_INDEX | CONTRACT_ADDRESS | TOPICS | TOPIC_0 | TOPIC_1 | TOPIC_2 | TOPIC_3 | DATA | EVENT_REMOVED | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | ORIGIN_FUNCTION_SIGNATURE | TX_SUCCEEDED | FACT_EVENT_LOGS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 6 | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | ["0xce771ab142d4dae572f01bd7e3eb77c8241179ce1a8128451099727badfba64e","0... | 0xce771ab142d4dae572f01bd7e3eb77c8241179ce1a8128451099727badfba64e | 0x000000000000000000000000ee7c7ffd631c6cdfb42dff6e544833c910fea4e9 | 0x0000000000000000000000002fc49a061b8ec3615b5cd1806bf287909069c5be | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x03000000000000000000000000000000000000000000000000000000003d82dc000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | 9fb66cd54e503a3931f47d6c671d2d8c | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
2 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 7 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0xc9c7c3fe08b88b4df9d4d47ef47d2c43d55c025a0ba88ca442580ed9e7348a16"] | 0xc9c7c3fe08b88b4df9d4d47ef47d2c43d55c025a0ba88ca442580ed9e7348a16 | 0x0000000000000000000000000000000000000000000000000000000000000040000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | aa28d04a50c083c2cbc541326e575497 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | |||
3 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 8 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x8292fce18fa69edf4db7b94ea2e58241df0ae57f97e0a6c9b29067028bf92d76","0... | 0x8292fce18fa69edf4db7b94ea2e58241df0ae57f97e0a6c9b29067028bf92d76 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | 10648d72862b78550405d219ec8fdee2 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | |
4 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 9 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0... | 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | f8a8ccacc599229ed9cec99c383be897 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
5 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 10 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0... | 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d | 0x9f2df0fed2c77648de5860a4cc508cd0818c85b8b8a1ab4ceeef8d981c8956a6 | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | f6793f3b790e1670c7f275ef7319ee1e | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
6 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 11 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0... | 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d | 0x8502233096d909befbda0999bb8ea2f3a6be3c138b9fbf003752a4c8bce86f6c | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | b6a9bd4c7fd90b41467d1f468cbf794a | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
7 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 12 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0... | 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d | 0x8502233096d909befbda0999bb8ea2f3a6be3c138b9fbf003752a4c8bce86f6c | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | 3669a3115e732f69fd8f28f37f5293e3 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
8 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 13 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0... | 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d | 0x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f80 | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | ec3ae958eb1df30c41ce563f464c9903 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
9 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 14 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0xbd79b86ffe0ab8e8776151514217cd7cacd52c909f66475c3af44e129f0b00ff","0... | 0xbd79b86ffe0ab8e8776151514217cd7cacd52c909f66475c3af44e129f0b00ff | 0x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f80 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f80 | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | d08f16a3458156e0190c4bb1ceb2efae | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
10 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 15 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0xe2497bd806ec41a6e0dd992c29a72efc0ef8fec9092d1978fd4a1e00b2f18304","0... | 0xe2497bd806ec41a6e0dd992c29a72efc0ef8fec9092d1978fd4a1e00b2f18304 | 0x0000000000000000000000001af20c6b23373350ad464700b5965ce4b0d2ad94 | 0x00000000000000000000000000000000000000000000000000000000000000fa | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | ae8d715d5fff18abb835af668d7fe1b8 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
11 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 16 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x90d7ec04bcb8978719414f82e52e4cb651db41d0e6f8cea6118c2191e6183adb","0... | 0x90d7ec04bcb8978719414f82e52e4cb651db41d0e6f8cea6118c2191e6183adb | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x0000000000000000000000000000000000000000000000000000000000000000 | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | 6804fdcd3c49f93d5582dd9e322b08ea | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
12 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 17 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x299d17e95023f496e0ffc4909cff1a61f74bb5eb18de6f900f4155bfa1b3b333","0... | 0x299d17e95023f496e0ffc4909cff1a61f74bb5eb18de6f900f4155bfa1b3b333 | 0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | 9a44d2a869fb20fea84ccfa570c0181b | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
13 | 4031215 | 2025-02-19 21:47:46.000 | 0x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5 | 4 | 18 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb3847402498"] | 0x7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb3847402498 | 0x0000000000000000000000000000000000000000000000000000000000000001 | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x25548ba29a0071f30e4bdcd98ea72f79341b07a1 | 0xd057c8b1 | TRUE | f6fbb2668348d4ccc0414d8b80b0ab47 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | |||
14 | 4031325 | 2025-02-19 21:48:41.000 | 0xa4056c45a9b93ad5ae9b57e2e60d25d5b397c6ce9cf62b394168da9d86c34864 | 0 | 0 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000063000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | ff5dc6353e18626672dbb60aba95e1ce | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
15 | 4031389 | 2025-02-19 21:49:13.000 | 0x363a94bb1cd2e0e680c69ffabf9a47e737c5dc5740053cc718539c15dd903349 | 5 | 13 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x0000000000000000000000000000000000000000000000000000000000000064 | 0x00000000000000000000000000000000000000000000000000000000000000c7000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | 4471148ce2e701627d8a533c689002d8 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
16 | 4031459 | 2025-02-19 21:49:48.000 | 0xe1ebbdb34bb5463e84cbd2b8c640650d770823c03216052f72336105544e6605 | 2 | 7 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x00000000000000000000000000000000000000000000000000000000000000c8 | 0x000000000000000000000000000000000000000000000000000000000000012b000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | ae0b0fa918d7c95aaa25b7ef67a92437 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
17 | 4031517 | 2025-02-19 21:50:17.000 | 0x5aa4892b0140a321f303d9e28fb21e9fccea72892e697871ec1ebf552e9e68ee | 2 | 6 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x000000000000000000000000000000000000000000000000000000000000012c | 0x000000000000000000000000000000000000000000000000000000000000018f000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | 978cbfb3385f6d8bda33de78aaef17d8 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
18 | 4031579 | 2025-02-19 21:50:48.000 | 0xf27290c6c7a43b00a95f1a100134603e592c0686e3950cf24437a0e594fd503f | 6 | 17 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x0000000000000000000000000000000000000000000000000000000000000190 | 0x00000000000000000000000000000000000000000000000000000000000001f3000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | b8a169cec4e8235a74e2935afd46feb1 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
19 | 4031644 | 2025-02-19 21:51:21.000 | 0xe2fb6b27f176db14237e02b6b3edd56a8d710aaf8115d5a3de503df5e89aed78 | 1 | 5 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x00000000000000000000000000000000000000000000000000000000000001f4 | 0x0000000000000000000000000000000000000000000000000000000000000257000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | 6617e513f48b51e0597eab8ffa3b00e1 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 | ||
20 | 4031699 | 2025-02-19 21:51:48.000 | 0x241fa178aa7c7a80cb562d04aba73f12fc8963d4c37c38254bfdf5461bb03def | 3 | 3 | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0... | 0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d | 0x0000000000000000000000000000000000000000000000000000000000000258 | 0x00000000000000000000000000000000000000000000000000000000000002bb000000... | FALSE | 0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a | 0x2fc49a061b8ec3615b5cd1806bf287909069c5be | 0xd37c353b | TRUE | 19fd55b243ff8eefa717d4cccd49a1b2 | 2025-02-19 22:53:20.665 | 2025-02-19 22:53:20.665 |
ravelmanual-emerald
Updated 2025-02-27
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
›
⌄
WITH base AS (
SELECT
ft.block_timestamp,
el.origin_from_address AS minter,
el.origin_to_address,
el.tx_hash,
TRY_CAST(
CASE
WHEN TRY_CAST(utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40)) AS DECIMAL(38,0)) <= 888
THEN utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40))
ELSE NULL
END
AS DECIMAL(38,0)) AS tokenID
FROM monad.testnet.fact_event_logs el
INNER JOIN monad.testnet.fact_traces ft
ON el.tx_hash = ft.tx_hash
WHERE contract_address = LOWER('0x2FC49a061b8ec3615b5cd1806bf287909069c5Be')
AND TX_SUCCEEDED = 'TRUE'
AND EVENT_REMOVED = 'FALSE'
)
,base2 AS (
SELECT
tx_hash,
COUNT(CASE WHEN tokenID IS NOT NULL THEN 1 END) AS tokenID_count,
COUNT(CASE WHEN tokenID IS NULL THEN 1 END) AS null_tokenID_count
FROM base
GROUP BY tx_hash
)
,base3 AS (
select *
from base2
where null_tokenID_count > tokenID_count
)
Last run: 19 days ago
...
533
445KB
8s