Avalanche | List of Top Addresses Interacted by BTC.b Users

alitaslimiAvalanche | List of Top Addresses Interacted by BTC.b Users

Updated 2025-03-04

select

origin_to_address as "Address",

project_name as "Label",

count(distinct tx_hash) as "Transactions",

count(distinct origin_from_address) as "Users"

from

avalanche.core.ez_decoded_event_logs logs

join avalanche.core.dim_labels labels on logs.origin_to_address = labels.address

where

tx_status = 'SUCCESS'

and contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'

group by

"Address",

"Label"

order by

"Transactions" desc

Last run: 12 days agoAuto-refreshes every 12 hours

	Address	Label	Transactions	Users
1	0x152b9d0fdc40c096757f570a51e494bd4b943e50	btc.b	2382297	1023111
2	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	trader joe	1609225	608126
3	0x2297aebd383787a160dd0d9f71508148769342e3	layerzero	1435573	851503
4	0xcd2e3622d483c7dc855f72e5eafadcd577ac78b4	layerzero	1132142	1
5	0x88de50b233052e4fb783d4f6db78cc34fea3e9fc	odos	392233	24689
6	0x1111111254eeb25477b68fb85ed929f73a960582	1inch	212684	72969
7	0x794a61358d6845594f94dc1db02a252b5b4814ad	aave	109459	20883
8	0xdef1c0ded9bec7f1a1670819833240f027b25eff	0x	96407	47494
9	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	trader joe	85316	33416
10	0x1111111254fb6c44bac0bed2854e76f90643097d	1inch	85195	55505
11	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	paraswap	80607	45452
12	0x60ae616a2155ee3d9a68541ba4544862310933d4	trader joe	42944	3929
13	0xe547cadbe081749e5b3dc53cb792dfaea2d02fd2	gmx	42611	4
14	0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31	metamask	36712	21114
15	0x89a415b3d20098e6a6c8f7a59001c67bd3129821	benqi finance	25636	3838
16	0x6352a56caadc4f1e25cd6c75970fa768a3304e64	openocean	21038	12217
17	0x1fd108cf42a59c635bd4703b8dbc8a741ff834be	dexalot	16256	7601
18	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	lifi	14830	9456
19	0xc4729e56b831d74bbc18797e0e17a295fa77488c	yield yak	14329	2547
20	0x6131b5fae19ea4f9d964eac0408e4408b66337b5	kyberswap	13596	7492

...

140

9KB

95s

flipside