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 | 13911203 | 2025-04-25 11:42:16.000 | 0xf09dc8d3b13ea8adcf5b645ee7c82b733d9364de76d3361069d07a247bfe6534 | 0 | 0 | 0xd5c1dc181c359f0199c83045a85cd2556b325de0 | ["0xb81bbaf150467ef3096ed6220cb963abc169bffd2eb88f26c47359ef344cf94c"] | 0xb81bbaf150467ef3096ed6220cb963abc169bffd2eb88f26c47359ef344cf94c | 0x00000000000000000000000000000000000000000000000000000000000003c0000000... | FALSE | 0xad97a5b4e7b4aca76de438f30ad961657e471251 | 0xd5c1dc181c359f0199c83045a85cd2556b325de0 | 0xa09e9040 | TRUE | a405c79d00e67bff5449d9a8f37be296 | 2025-04-25 12:53:34.814 | 2025-04-25 12:53:34.814 |
rohanshrothrium-XrJ1B9Search trades
Updated 10 hours ago
9
1
2
3
4
5
6
7
8
›
⌄
select
*
from monad.testnet.fact_event_logs
where block_timestamp > current_date - interval '6 days'
and contract_address=lower('0xd5c1dc181c359f0199c83045a85cd2556b325de0')
and position(lower('0x00000000000000000000000000000000000000000000000000000000000003C0') in lower(data::text)) > 0
order by block_number desc
limit 200;
Last run: about 10 hours ago
1
837B
15s