TIME | USERS | |
|---|---|---|
1 | 2025-02-26 08:00:00.000 | 9796 |
2 | 2025-02-21 17:00:00.000 | 769 |
3 | 2025-02-25 14:00:00.000 | 2264 |
4 | 2025-02-22 06:00:00.000 | 737 |
5 | 2025-02-28 21:00:00.000 | 4482 |
6 | 2025-03-08 05:00:00.000 | 4532 |
7 | 2025-03-12 23:00:00.000 | 8282 |
8 | 2025-03-22 18:00:00.000 | 5385 |
9 | 2025-02-25 09:00:00.000 | 1881 |
10 | 2025-03-11 04:00:00.000 | 7679 |
11 | 2025-03-20 20:00:00.000 | 6468 |
12 | 2025-03-26 18:00:00.000 | 6524 |
13 | 2025-04-14 08:00:00.000 | 7850 |
14 | 2025-04-13 19:00:00.000 | 6874 |
15 | 2025-02-20 05:00:00.000 | 295 |
16 | 2025-03-19 21:00:00.000 | 5407 |
17 | 2025-03-21 07:00:00.000 | 39465 |
18 | 2025-03-23 05:00:00.000 | 6769 |
19 | 2025-04-11 15:00:00.000 | 5967 |
20 | 2025-04-06 14:00:00.000 | 7095 |
Hessishmagma - ot 2
Updated 10 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 tx as
(select
a.BLOCK_TIMESTAMP,
a.ORIGIN_FROM_ADDRESS,
value as amount,
CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS gmon_amount,
a.tx_hash
from monad.testnet.fact_event_logs a
join monad.testnet.fact_traces b
on a.tx_hash = b.tx_hash
where --a.tx_hash = '0x0e75324175e3f0be40532bf15613b998e33ffb375818b7e64d4d45ece828c45e' and
a.ORIGIN_FUNCTION_SIGNATURE = '0xd5575982'
and a.TX_SUCCEEDED = 'TRUE'
and a.ORIGIN_TO_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and a.CONTRACT_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and b.to_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and b.value > 0
union
select
a.BLOCK_TIMESTAMP,
a.ORIGIN_FROM_ADDRESS,
value as amount,
CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS gmon_amount,
a.tx_hash
from monad.testnet.fact_event_logs a
join monad.testnet.fact_traces b
on a.tx_hash = b.tx_hash
where --a.tx_hash = '0xa0bd668ea1856d13d35fcb07fa24c913285fb10f8b648a33de0a3a4c2ea9d514' and
a.ORIGIN_FUNCTION_SIGNATURE = '0x6fed1ea7'
and a.TX_SUCCEEDED = 'TRUE'
and a.ORIGIN_TO_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'
Last run: 10 days ago
...
1247
40KB
188s