monad testnet - gas guzzlers

marqumonad testnet - gas guzzlers

Updated 2025-03-11

with

create_txs as (

select distinct

to_address

from monad.testnet.fact_traces

where tx_succeeded

and trace_succeeded

and type ilike 'create%'

and to_address is not null

all_txs as (

select

fact_transactions.block_timestamp

, fact_transactions.tx_hash

, fact_transactions.tx_succeeded

, fact_transactions.to_address

, fact_transactions.tx_fee

from monad.testnet.fact_transactions

inner join create_txs

on fact_transactions.to_address = create_txs.to_address

where fact_transactions.to_address is not null

and block_timestamp >= '2025-01-07'

agg_24h as (

select

Last run: 2 days ago

	CONTRACT_ADDRESS	LABEL	COUNT_TXS	SUM_FEES	AVG_FEE	MEDIAN_FEE	COUNT_TXS_24H	SUM_FEES_24H	AVG_FEE_24H	MEDIAN_FEE_24H	\|	\|\|
1	0x38f7f5147f8d185577edf2c72b3367992b01c58d	unknown	221750	223410.59223	1.00749	1.35267	13971	21076.48698	1.50859	1.65002	\|	\|\|
2	0x0000000000000068f116a894984e2db1123eb395	unknown	1285472	52337.62937	0.04071	0.00889	27013	7287.70967	0.26979	0.00883	\|	\|\|
3	0x8462c247356d7deb7e26160dbfab16b351eef242	unknown	114727997	201772.21717	0.00176	0.00173	3850170	6706.92224	0.00174	0.00173	\|	\|\|
4	0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7	unknown	14576230	278089.45526	0.01908	0.0208	342571	6349.3836	0.01853	0.0208	\|	\|\|
5	0x760afe86e5de5fa0ee542fc7b7b713e1c5425701	unknown	22801048	179683.88894	0.00788	0.00233	672991	5272.6213	0.00783	0.00234	\|	\|\|
6	0xca810d095e90daae6e867c19df6d9a8c56db2c89	unknown	12256498	121346.52588	0.0099	0.00845	380904	3641.37693	0.00956	0.00841	\|	\|\|
7	0xd227d3bce59b91380b7bc4a61a045b528b509439	unknown	11165397	95732.05149	0.00857	0.00519	408261	3219.60814	0.00789	0.00519	\|	\|\|
8	0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0	unknown	11219739	95386.77472	0.0085	0.00664	367803	2846.07827	0.00774	0.00664	\|	\|\|
9	0x822eb1add41cf87c3f178100596cf24c9a6442f6	unknown	2136610	90469.7796	0.04234	0.01118	72985	2820.48757	0.03864	0.01122	\|	\|\|
10	0xb2f82d0f38dc453d596ad40a37799446cc89274a	aprMON	9700786	80291.99417	0.00828	0.0041	364718	2775.05133	0.00761	0.00421	\|	\|\|
11	0xb600de0ebee70af4691dbf8a732be7791b6ce73a	unknown	5797	2382.21108	0.41094	0.00587	5797	2382.21108	0.41094	0.00587	\|	\|\|
12	0x2c9c959516e9aaedb2c748224a41249202ca8be7	unknown	10209738	89030.24256	0.00872	0.00505	299531	2238.53609	0.00747	0.00493	\|	\|\|
13	0xc816865f172d640d93712c68a7e1f83f3fa63235	unknown	6417898	81209.51158	0.01265	0.01013	174730	2108.27999	0.01207	0.00999	\|	\|\|
14	0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfd	unknown	4751971	62913.53064	0.01324	0.01197	147111	1852.20876	0.01259	0.01193	\|	\|\|
15	0xcbe623d259261ffa0cfaff44484bff46c1b7d6c2	unknown	2139574	51416.81303	0.02403	0.0055	82894	1638.92529	0.01977	0.0055	\|	\|\|
16	0xe06d980e8e0f2fe42f3c0fbe6926b4e921b33833	unknown	2495276	21059.47168	0.00844	0.00445	249069	1542.12831	0.00619	0.00445	\|	\|\|
17	0xcbcd292c9dae11875e090bb963aa4c74ccce6a23	unknown	1370135	20518.25019	0.01498	0.01233	94459	1403.52045	0.01486	0.01277	\|	\|\|
18	0xedb0f17e5b701c8a1278b94b961384cf4015f240	unknown	119988	82670.83532	0.68899	0.304	4664	1371.19041	0.29399	0.2575	\|	\|\|
19	0xd3c4819fac00517dc99fcab732866873216edb11	unknown	22915	1346.2346	0.05875	0.00731	22908	1346.19048	0.05877	0.00731	\|	\|\|
20	0x3a98250f98dd388c211206983453837c8365bdc1	unknown	8468120	36073.72476	0.00426	0.00327	276536	1313.05503	0.00475	0.00312	\|	\|\|

...

1000

122KB

386s

flipside

flipside