STAT_DATE | MIN_BLOCK_NUMBER | FIRST_TX_HASH | TX_COUNT | |
|---|---|---|---|---|
1 | 2025-03-05 00:00:00.000 | 6311943 | 0xe7c75de5520d74bbb1fcfe3f009f5b1357351d7cdcfcdb930300d78a724bfec9 | 12127 |
2 | 2025-03-06 00:00:00.000 | 6363835 | 0xc002f6d9d95482467aebcec6e48e12895a3126857db04088568029dd0274b08a | 31384 |
3 | 2025-03-07 00:00:00.000 | 6523373 | 0xbfb8c9c42d99f794c046aedb1a65bdbad4f65d9bf56af458b51692ccf41c6524 | 305 |
4 | 2025-03-08 00:00:00.000 | 6689100 | 0x9e7c170ac1786e8813bd688112e012e53ec269c4649be7b73c58006dc7e5cb7b | 429 |
5 | 2025-03-09 00:00:00.000 | 6861544 | 0xdda8a9be7d9577983c19c0fa3d612a68851fc5c86b0eff26a3f730922e25c89e | 372 |
6 | 2025-03-10 00:00:00.000 | 7032838 | 0x757b52ca488b8acfd3ecf52957a64c5117dd6c9567f56c131a1c82f0b9532846 | 435 |
7 | 2025-03-11 00:00:00.000 | 7203346 | 0x24d0ddd0eb810fcb65e0ebeb3e89a4232174ad1703cbd8566fb450ef092fab17 | 562 |
8 | 2025-03-12 00:00:00.000 | 7363776 | 0xd5683ca97456bc44335dc6e0c0a154a3db0af16cf9981327d1b80006af93fc25 | 335 |
9 | 2025-03-13 00:00:00.000 | 7509626 | 0x65d62e5ad7a2d853c19b6286d091dd4a18baf68cef8f43e241defce109646b67 | 242 |
10 | 2025-03-14 00:00:00.000 | 7649242 | 0x16b2d76f88c31933ad6551986ba4c94d63d1b558c63484586258c7e7cfdffe66 | 4 |
aPriorishare_rate_bugs
Updated 6 days ago
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 token_withdraw_request_raw_dwd as
(
select
-- BLOCK_TIMESTAMP
-- ,TX_HASH
-- ,from_address
-- ,to_address
-- ,depoist_value
-- ,EVENT_INDEX
-- ,CONTRACT_ADDRESS
*
from
(
select
BLOCK_NUMBER
,BLOCK_TIMESTAMP
,TX_HASH
,EVENT_INDEX
,CONTRACT_ADDRESS
,TOPICS
,'0x' || RIGHT(TOPIC_1, 40) as from_address
-- ,'0x' || RIGHT(TOPIC_2, 40) as to_address
,TOPIC_0
,TOPIC_1
,TOPIC_2
,TOPIC_3
,DATA as block_data
,ORIGIN_FROM_ADDRESS
,ORIGIN_TO_ADDRESS
,ORIGIN_FUNCTION_SIGNATURE
,TX_SUCCEEDED
,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 65, 64)))/1e18 as shares
,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(REPLACE(data, '0x', ''), 129, 64)))/1e18 as assets
from monad.testnet.fact_event_logs
where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
Last run: 6 days ago
10
1KB
62s