CREATE_DATE | DAILY_NEW_HOLDER | CUM_APRMON_HOLDER | |
|---|---|---|---|
1 | 2025-02-18 00:00:00.000 | 3 | 3 |
2 | 2025-02-19 00:00:00.000 | 10079 | 10082 |
3 | 2025-02-20 00:00:00.000 | 35293 | 45375 |
4 | 2025-02-21 00:00:00.000 | 26728 | 72103 |
5 | 2025-02-22 00:00:00.000 | 25760 | 97863 |
6 | 2025-02-23 00:00:00.000 | 30466 | 128329 |
7 | 2025-02-24 00:00:00.000 | 34313 | 162642 |
8 | 2025-02-25 00:00:00.000 | 114755 | 277397 |
9 | 2025-02-26 00:00:00.000 | 267350 | 544747 |
10 | 2025-02-27 00:00:00.000 | 94987 | 639734 |
11 | 2025-02-28 00:00:00.000 | 53794 | 693528 |
12 | 2025-03-01 00:00:00.000 | 46769 | 740297 |
13 | 2025-03-02 00:00:00.000 | 51374 | 791671 |
14 | 2025-03-03 00:00:00.000 | 77318 | 868989 |
15 | 2025-03-04 00:00:00.000 | 90528 | 959517 |
16 | 2025-03-05 00:00:00.000 | 37292 | 996809 |
17 | 2025-03-06 00:00:00.000 | 42352 | 1039161 |
18 | 2025-03-07 00:00:00.000 | 35738 | 1074899 |
19 | 2025-03-08 00:00:00.000 | 29968 | 1104867 |
20 | 2025-03-09 00:00:00.000 | 32058 | 1136925 |
aPrioriaprMON Holders Trend
Updated 2 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_transfer_raw_dwd as
(
select
BLOCK_TIMESTAMP
,TX_HASH
,from_address
,to_address
,transfer_value/1e18 as transfer_value
,EVENT_INDEX
,CONTRACT_ADDRESS
from
(
select
BLOCK_NUMBER
,BLOCK_TIMESTAMP
,TX_HASH
,EVENT_INDEX
,CONTRACT_ADDRESS
,TOPICS
,'0x' || RIGHT(TOPICS[1], 40) as from_address
,'0x' || RIGHT(TOPICS[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(DATA, 3))) AS transfer_value
from monad.testnet.fact_event_logs
where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
and TX_SUCCEEDED
-- and TX_HASH='0x11376bfba87753d01faa55b94da60c098cb8353dc050e7474f3f1c8061282d6d'
and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
Last run: 2 days ago
28
1KB
15s