top_trace_contracts

maybeyonastop_trace_contracts

Updated 2025-03-28

-- forked from top_tx_contracts @ https://flipsidecrypto.xyz/studio/queries/1f13ed97-40b1-4a6b-98ce-b3a75282d2c5

with

labels as (

select

contract_address,

dapp,

name

from $query('92e9b095-a8c5-44f1-8c63-caf6feb228b1')

traces as (

select * from swell.core.fact_traces

where origin_function_signature != '0x'

and trace_address != 'ORIGIN'

and origin_from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'

and origin_to_address != '0x4200000000000000000000000000000000000007'

txs as (

select * from swell.core.fact_transactions

where origin_function_signature != '0x'

and from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'

and to_address != '0x4200000000000000000000000000000000000007'

traces_enhanced as (

select

t.block_timestamp,

t.tx_hash,

t.from_address,

t.to_address,

t.input,

t.trace_succeeded,

t.gas_used,

txs.gas_used as total_gas_used,

txs.tx_fee_precise,

txs.l1_fee_precise,

(t.gas_used/txs.gas_used)*txs.tx_fee_precise as trace_tx_fee,

Last run: 22 days ago

	TO_ADDRESS	DAPP	NAME	TOTAL_TX_FEE	GIGA_GAS_UNITS	TRACES	TXS	TOTAL_L1_FEES	SEQ_REV
1	0x646929453e753565467f330110850885ead93fa9	ambient	hot proxy	0.10298794766	6.247854	85674	83807	0.03116331513	0.07182463253
2	0x1073fc2eaff48b2670b993ba61a6885c924f77b5	neptune	clpool impl	0.03711664048	3.93975	117571	25744	0.00799558834	0.02912105214
3	0x41675c099f32341bf84bfc5382af534df5c7461a			0.01458133364	3.52164	106138	16710	0.01359373904	0.0009875946
4	0x075ef0be7f0e83c3b55bce7603cbbf1acc3171f8	neptune	nft manager	0.02337222327	2.670128	34687	13451	0.00366372463	0.01970849864
5	0xea87ae93fa0019a82a727bfd3ebd1cfca8f64f1d	hyperlane	mailbox impl	0.23870399591	2.567162	26101	15281	0.02312958245	0.21557441346
6	0x4ee2f9b7cf3a68966c370f3eb2c16613d3235245	layerzero old	impl	0.03274737028	2.561891	231248	224990	0.03191663954	0.00083073074
7	0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d	ambient	crocswap dex	0.0362620355	2.12868	67029	22361	0.00501546907	0.03124656643
8	0xb81131b6368b3f0a83af09db4e39ac23da96c2db	oracle	oracle	0.07608979314	2.084676	39696	38102	0.06970829249	0.00638150065
9	0x918261fa5dd9c3b1358ca911792e9bdf3c5cca35	merkl	distributor impl	0.09235408365	2.045651	19497	19497	0.03500367086	0.05735041279
10	0x40a2accbd92bca938b02010e17a5b8929b49130d			0.00301573461	1.753599	5581	5576	0.00270206243	0.00031367218
11	0x5e81ba89d50fc72e5189c14c0fe6b96afb26ffa4	neptune	SWELL/WETH	0.0139317215	1.655573	49885	11850	0.00276992915	0.01116179235
12	0x18bb314a6615bee12e408c9df36de4afb6805833			0.07204812475	1.605678	17607	6900	0.00935577058	0.06269235417
13	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	erc20	USDe	0.02776476343	1.590958	150310	73366	0.00823960897	0.01952515446
14	0xc87d0cc4c8a5a912fbe394e16cc5d9a2f1ff59d8			0.02308226697	1.541868	6953	5151	0.00128268923	0.02179957774
15	0xcb566e3b6934fa77258d68ea18e931fa75e1aaaa			0.01849879739	1.407613	18356	18330	0.0100180039	0.00848079349
16	0x882cd0c5d50b6dd74b36da4bdb059507fddeddf2			0.16895515281	1.370861	27499	7712	0.0177737276	0.15118142521
17	0xda1f8ea667dc5600f5f654df44b47f1639a83dd1	erc20	wSWELL	0.05543858609	1.366089	20409	19684	0.02315205287	0.03228653322
18	0x4200000000000000000000000000000000000006	erc20	WETH	0.0202706949	1.28732	163691	40435	0.00378519946	0.01648549544
19	0x10499d88bd32af443fc936f67de32be1c8bb374c			0.00699195702	1.089437	36324	7796	0.00185848658	0.00513347044
20	0x3a464f746d23ab22155710f44db16dca53e0775e	hyperlane	mailbox	0.04616260528	1.035457	15671	9944	0.00231189003	0.04385071525

...

1000

102KB