Top Interacted Protocols By Registrants ($JACK Presale on Avalaunch)

Ali3NTop Interacted Protocols By Registrants ($JACK Presale on Avalaunch)

Updated 2025-04-15

with registrantst as (

select decoded_log:user as Registrant

from avalanche.core.ez_decoded_event_logs t1

where t1.origin_to_address = '0xfae88aed6ceb890a07f23fc567370b11cb583f2d'

and t1.tx_succeeded)

select case when origin_to_address = '0xba4353e8ea0db84a0725e5e31d3703941cd43b93' then 'CLY Airdrop'

when origin_to_address = '' then ''

else coalesce (initcap(project_Name),origin_to_address) end as Destination,

count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Users

from avalanche.core.ez_decoded_event_logs t1 join registrantst t2 on t1.origin_from_address = t2.registrant

join avalanche.core.dim_labels t3 on t1.origin_to_address = t3.address

and origin_to_address != '0xfae88aed6ceb890a07f23fc567370b11cb583f2d'

and project_name != 'Avalaunch'

and origin_function_signature != '0x718af7e6'

group by 1 having destination not in ('0x82354cadd974ac35112e97db5d717408e9a297bd','0xfae88aed6ceb890a07f23fc567370b11cb583f2d','0xc354d85c24a724fda55084075fdf25c9e9cf35aa','Avalaunch','0x97a0946c837959256cc0f719a991c4807f1b9aed','0xfbdbc5774fd483f69007591b819ba0ca27f379f6')

order by users desc

Last run: 15 days agoAuto-refreshes every 6 hours

	DESTINATION	TRANSACTIONS	USERS
1	Trader Joe	156160	761
2	Layerzero	13938	611
3	Beefy Finance	12069	573
4	Pangolin	39830	514
5	Wavax	7979	438
6	Traderjoe	4522	418
7	Metamask	2898	344
8	Dexalot	3613	344
9	Odos	5948	311
10	Oh Finance	454	264
11	Yield Yak	13215	264
12	Benqi Finance	8160	252
13	Platypus Finance	12410	246
14	Coqinu	1471	200
15	Okx	722	192
16	Savax	1543	179
17	Paraswap	3619	162
18	Crabada	252490	159
19	Dai.E	849	152
20	Dragon Crypto	480	151

...

309

6KB

387s

flipside

flipside