STAT_DATE | DEPOSIT_ADDRESS | DEPOSIT_AMOUNT | DEPOSIT_TX_COUNT | |
|---|---|---|---|---|
1 | 2025-02-18 00:00:00.000 | 8 | 3.765322 | 18 |
2 | 2025-02-19 00:00:00.000 | 11534 | 29476.212123 | 14641 |
3 | 2025-02-20 00:00:00.000 | 41759 | 169656.088124 | 52860 |
4 | 2025-02-21 00:00:00.000 | 36640 | 146931.995907 | 47087 |
5 | 2025-02-22 00:00:00.000 | 39835 | 89461.618339 | 57191 |
6 | 2025-02-23 00:00:00.000 | 55540 | 208872.042052 | 100204 |
7 | 2025-02-24 00:00:00.000 | 67059 | 86689.229773 | 115750 |
8 | 2025-02-25 00:00:00.000 | 162032 | 109321.618254 | 262270 |
9 | 2025-02-26 00:00:00.000 | 340674 | 136326.23759 | 519712 |
10 | 2025-02-27 00:00:00.000 | 161023 | 75678.505671 | 254849 |
11 | 2025-02-28 00:00:00.000 | 128066 | 56873.315245 | 223636 |
12 | 2025-03-01 00:00:00.000 | 107419 | 63543.387298 | 181492 |
13 | 2025-03-02 00:00:00.000 | 122466 | 51995.245478 | 197640 |
14 | 2025-03-03 00:00:00.000 | 159499 | 52052.182672 | 223740 |
15 | 2025-03-04 00:00:00.000 | 165790 | 41101.512729 | 233098 |
16 | 2025-03-05 00:00:00.000 | 107842 | 33912.089207 | 170926 |
17 | 2025-03-06 00:00:00.000 | 109269 | 37149.045043 | 175238 |
18 | 2025-03-07 00:00:00.000 | 109895 | 31845.753238 | 174165 |
19 | 2025-03-08 00:00:00.000 | 100711 | 39442.938845 | 158357 |
20 | 2025-03-09 00:00:00.000 | 97347 | 23763.741419 | 153507 |
aPrioriaPriori User Deposit Action
Updated 2 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_deposit_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(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: 2 days ago
28
1KB
31s