USERS | TOTAL_MON | MAX_TIME | MIN_TIME | LAST_BLOCK | |
|---|---|---|---|---|---|
1 | 437976 | 1009859.41416843 | 2025-02-19 07:26:37.000 | 2025-02-19 06:24:53.000 | 3931556 |
TheLaughingManspecial gas - overview
Updated 2025-02-24
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
›
⌄
with gas_base as (
SELECT
tx_hash
, block_number
, block_timestamp
, TO_ADDRESS as wallet
, VALUE as amount
--, row_number() OVER (partition by to_address ORDER BY tx_hash DESC) as rank
from monad.testnet.fact_traces
WHERE 1=1
--AND tx_hash = '0xdac05244373d466d547690ecaf151b3a3a1d6365a520c68528e8a83681dc7351'
AND origin_to_address = '0x9fb480a193c250bf8ece39df5d9d728e21026b34'
AND origin_function_signature = '0x7a53bcfc'
AND TX_SUCCEEDED
AND trace_index>=1
AND block_number<4000000
)
SELECT
COUNT(distinct wallet) as users
, SUM(amount) as total_mon
, MAX(block_timestamp) as max_time
, MIN(block_timestamp) as min_time
, MAX(block_number) as last_block
from gas_base
Last run: 2 months ago
1
87B
7s