top_tx_signatures

maybeyonastop_tx_signatures

Updated 2025-03-28

with

labels as (

select

signature,

dapp,

action

from $query('d453be90-00db-41cb-9972-e597fb35c4f6')

)

select

origin_function_signature as signature,

l.dapp,

l.action,

sum(tx_fee_precise) as total_tx_fee,

sum(gas_used/1e9) as giga_gas_units,

count(*) as txs,

sum(l1_fee_precise) as total_l1_fees,

total_tx_fee - total_l1_fees as seq_rev

from swell.core.fact_transactions t

left join labels l

on t.origin_function_signature = l.signature

where origin_function_signature != '0x'

and from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'

and to_address != '0x4200000000000000000000000000000000000007'

group by 1,2,3

order by giga_gas_units desc

limit 1000

Last run: 13 days ago

	SIGNATURE	DAPP	ACTION	TOTAL_TX_FEE	GIGA_GAS_UNITS	TXS	TOTAL_L1_FEES	SEQ_REV
1	0x3161b7f6	layerzero	unknown	0.1848321515	7.959477	209404	0.1752793613	0.009552790197
2	0xa15112f9	ambient	usercmd	0.1080055184	5.418386	49756	0.05423005118	0.05377546719
3	0x2bf4762b	brahma	wswell claim	0.02955027499	4.294875	13791	0.02525580197	0.004294473015
4	0xb7a16251	oracle	update	0.1461284905	3.453696	35349	0.1331469367	0.0129815538
5	0x7c39d130			0.232973633	1.955215	10424	0.03763623728	0.1953373958
6	0x71ee95c0	merkl	claim	0.1044661776	1.87874	10884	0.04500750979	0.0594586678
7	0xf970cf64	router	swap	0.08242865826	1.76413	6840	0.01325062985	0.06917802841
8	0x3d719cd9	ambient	swap	0.03984212509	1.545307	14271	0.01173349502	0.02810863007
9	0xc7c7f5b3	layerzero	bridge out	0.01690725845	1.033734	3991	0.004621540791	0.01228571766
10	0x81b4e8b4			0.02018373024	1.017603	4203	0.00400952232	0.01617420792
11	0xc5918880			0.003013965318	0.886125	2761	0.00212718669	0.0008867786276
12	0x211c6b73			0.002567040573	0.87646	3352	0.001690346962	0.0008766936109
13	0x45c37e14			0.05454155385	0.79895	8307	0.01905483828	0.03548671556
14	0xb143044b			0.02814811422	0.782705	10448	0.02720549003	0.0009426241855
15	0xb6b55f25			0.01043491418	0.777869	2152	0.001025258056	0.009409656126
16	0x095ea7b3			0.02500041337	0.724349	15622	0.01024497967	0.0147554337
17	0x93674396			0.004364581883	0.699383	3820	0.002719497055	0.001645084828
18	0xc16ae7a4	euler	batch	0.01847410188	0.690428	2678	0.003228248435	0.01524585344
19	0xac9650d8			0.01427616137	0.671878	2625	0.003243921759	0.01103223961
20	0xcfc32570			0.01152740142	0.664413	7157	0.01073124243	0.0007961589869

...

1000

80KB

flipside