List of Top Addresses Interacted by OCA Users

alitaslimiList of Top Addresses Interacted by OCA Users

Updated 9 days ago

select

origin_to_address as "Address",

initcap(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 in (

'0xc891eb4cbdeff6e073e859e987815ed1505c2acd', -- EURC

'0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b', -- VEUR

'0x228a48df6819ccc2eca01e2192ebafffdad56c19' -- VCHF

)

group by

"Address",

"Label"

order by

"Transactions" desc

Last run: 9 days ago

	Address	Label	Transactions	Users
1	0xc891eb4cbdeff6e073e859e987815ed1505c2acd	Circle	33023	13028
2	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	Trader Joe	24457	4837
3	0x88de50b233052e4fb783d4f6db78cc34fea3e9fc	Odos	14610	504
4	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	Paraswap	7824	335
5	0x1fd108cf42a59c635bd4703b8dbc8a741ff834be	Dexalot	4241	1523
6	0xcd2e3622d483c7dc855f72e5eafadcd577ac78b4	Layerzero	3537	1
7	0x052af5b8ac73082d8c4c8202bb21f4531a51dc73	Beefy Finance	2942	1436
8	0x1111111254eeb25477b68fb85ed929f73a960582	1inch	2901	2460
9	0xeed3c159f3a96ab8d41c8b9ca49ee1e5071a7cdd	Dexalot	2564	165
10	0x794a61358d6845594f94dc1db02a252b5b4814ad	Aave	1193	3
11	0x228a48df6819ccc2eca01e2192ebafffdad56c19	Vnx	912	514
12	0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b	Vnx	802	175
13	0x6131b5fae19ea4f9d964eac0408e4408b66337b5	Kyberswap	357	159
14	0xdef1c0ded9bec7f1a1670819833240f027b25eff	0x	350	293
15	0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31	Metamask	316	162
16	0x45a62b090df48243f12a21897e7ed91863e2c86b	Trader Joe	231	88
17	0x6352a56caadc4f1e25cd6c75970fa768a3304e64	Openocean	183	126
18	0xc4729e56b831d74bbc18797e0e17a295fa77488c	Yield Yak	164	81
19	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	Lifi	105	73
20	0xc5b8ce3c8c171d506deb069a6136a351ee1629dc	Glacier	96	34

2KB

flipside