STAT_DATE | TX_COUNT | WALLET_COUNT | DEPOIST_VALUE | |
|---|---|---|---|---|
1 | 2025-02-22 00:00:00.000 | 7 | 7 | 13.93 |
2 | 2025-02-23 00:00:00.000 | 487 | 487 | 969.13 |
3 | 2025-02-24 00:00:00.000 | 1337 | 1293 | 2660.63 |
4 | 2025-02-25 00:00:00.000 | 1345 | 1307 | 2676.55 |
5 | 2025-02-26 00:00:00.000 | 1562 | 1515 | 3108.38 |
6 | 2025-02-27 00:00:00.000 | 1054 | 1022 | 2097.46 |
7 | 2025-02-28 00:00:00.000 | 785 | 758 | 1562.15 |
8 | 2025-03-01 00:00:00.000 | 862 | 825 | 1715.38 |
9 | 2025-03-02 00:00:00.000 | 1153 | 1081 | 2294.47 |
10 | 2025-03-03 00:00:00.000 | 1011 | 977 | 2011.89 |
11 | 2025-03-04 00:00:00.000 | 1166 | 1097 | 2320.34 |
12 | 2025-03-05 00:00:00.000 | 938 | 894 | 1866.62 |
13 | 2025-03-06 00:00:00.000 | 1098 | 1037 | 2185.02 |
14 | 2025-03-07 00:00:00.000 | 699 | 685 | 1391.01 |
15 | 2025-03-08 00:00:00.000 | 287 | 287 | 571.13 |
16 | 2025-03-09 00:00:00.000 | 170 | 169 | 338.3 |
17 | 2025-03-10 00:00:00.000 | 102 | 102 | 202.98 |
18 | 2025-03-11 00:00:00.000 | 57 | 57 | 113.43 |
19 | 2025-03-12 00:00:00.000 | 48 | 48 | 95.52 |
20 | 2025-03-13 00:00:00.000 | 49 | 49 | 97.51 |
aPrioriauto-stake
Updated 7 days ago
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 token_deposit_raw_dwd as
(
select
BLOCK_TIMESTAMP
,TX_HASH
,from_address as core_wallet
,to_address as other_wallet
,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(LEFT(DATA, 66),3)))/1e18 AS depoist_value
-- ,SUBSTR(LEFT(DATA, 66),3) as first_half
from monad.testnet.fact_event_logs
where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
and TX_SUCCEEDED
-- and TX_HASH='0x2bec5937c9b44308b5e6541cac461fb62217c65ba40932fbe2e3e8409e72d9d7'
Last run: 7 days ago
20
874B
59s