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

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

Updated 2025-02-19

select

origin_to_address as "Address",

project_name as "Label",

count(distinct tx_hash) as "Transactions",

count(distinct origin_from_address) as "Users"

from

arbitrum.core.ez_decoded_event_logs logs

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

where

tx_status = 'SUCCESS'

and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'

group by

"Address",

"Label"

order by

"Transactions" desc

Last run: 27 days ago

	Address	Label	Transactions	Users
1	0x2297aebd383787a160dd0d9f71508148769342e3	btc.b	831992	459833
2	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	trader joe	333533	198382
3	0xdef1c0ded9bec7f1a1670819833240f027b25eff	0x	15016	11053
4	0x7bfd7192e76d950832c77bb412aae841049d8d9b	trader joe	9163	6434
5	0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	uniswap	2989	815
6	0x4c60051384bd2d3c01bfc845cf5f4b44bcbe9de5	uniswap	2611	2034
7	0x123453a3995a7bd997e69c0b23844c48e3023816	bob	2458	27
8	0xc36442b4a4522e871399cd717abdd847ab11fe88	uniswap	2220	333
9	0x5e3d76f55ca08e53a2ebe52707f1f09dc7b6fd56	bob	1088	10
10	0x5415639627f420aa1a7a0e39ae22408e4ce650ae	acryptos	810	17
11	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	sushiswap	760	718
12	0xc06541327d1c576964a8821d7a2c2c6ebba6086a	acryptos	443	22
13	0x3344a88855e8242ded86af2f874c8928f6ad7bba	beefy finance	324	259
14	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	sushiswap	267	265
15	0xe592427a0aece92de3edee1f18e0157c05861564	uniswap	248	245
16	0x3a23f943181408eac424116af7b7790c94cb97a5	socket	130	120
17	0x9d3fbdb90c41d9aaa2100148c5c69d65bcae6fb0	bob	102	10
18	0x00000000009726632680fb29d3f7a9734e3010e2	rainbow	82	71
19	0xba12222222228d8ba445958a75a0704d566bf2c8	balancer	76	73
20	0x00000000ede6d8d217c60f93191c060747324bca	xdeployer	64	13

2KB

82s

flipside