Apps | # of Wallets | |
---|---|---|
1 | 1 | 409606 |
2 | 6 to 9 | 118734 |
3 | 2 | 113428 |
4 | 3 | 58961 |
5 | 4 | 48265 |
6 | 5 | 40158 |
7 | 10+ | 33053 |
MoDeFieclipse users - wallets # of apps dist
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with users_first_app as (
select BLOCK_TIMESTAMP, user,
case
when program_id in ('ALTNSZ46uaAUU7XUV6awvdorLGqAsPwa9shm7h4uP2FK','TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9S') then 'AllDomains'
when program_id='turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN' then 'Turbo Tap'
when program_id='whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'
when program_id in ('5hEa5j38yNJRM9vQA44Q6gXVj4Db8y3mWxkDtQeofKKs','RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE','Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic') then 'Scope'
when program_id='iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU' then 'Invariant'
when program_id='4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12' then 'Lifinity'
when program_id='So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' then 'Save Finance'
when program_id in ('FJu4E1BDYKVg7aTWdwATZRUvytJZ8ZZ2gQuvPfMWAz9y','EqRSt9aUDMKYKhzd1DGMderr3KNp29VZH3x5P7LFTC8m','BpXHAiktwjx7fN6M9ST9wr6qKAsH27wZFhdHEhReJsR6',
'5g5ujyYUNvdydwyDVCpZwPpgYRqH5RYJRi156cxyE3me','6tBGmKNxirxBYnm9khkaTtcr2fhJ9YviCgRm1RWM8NJv','EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y') then 'Hyperlane'
when program_id='Cook7kyoaKaiG57VBDUjE2KuPXrWdLEu7d3FdDgsijHU' then 'Let`s Cook'
when program_id='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' and INSTRUCTION:programId::string='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' then 'Send Arcade'
when program_id='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' and INSTRUCTION:programId::string!='MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr' then 'Memo Program'
when program_id='E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY' then 'Polymarket'
when program_id='DcZMKcjz34CcXF1vx7CkfARZdmEja2Kcwvspu1Zw6Zmn' then 'Sharp Trade'
when program_id='sooGfQwJ6enHfLTPfasFZtFR7DgobkJD77maDNEqGkD' then 'Solar'
when program_id='Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kA' then 'Astrol'
when program_id='7X3YmPcRu4V5GKxeFvC9MQq4bemCdR5MWea5tVs62bM9' then 'FightHorse'
when program_id='F3MQq5eugYvhUJqnRruvyv3tu7nsVBgXxJrsaKfLhRDL' then 'Moonlaunch'
when program_id='6L3qpmxyVnHT1JenPwJaP856tfWg6HPV355XVuvSzea' then 'Moon Coin'
when program_id='AssetGtQBTSgm5s91d1RAQod5JmaZiJDxqsgtqrZud73' then 'Nifty'
when program_id in ('CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d','CMAGAKJ67e9hRZgfC5SFTbZH8MgEmtqazKXjmkaJjWTJ') then 'Metaplex Core'
else program_id end as program_name, program_id, tx_id
from
(select SIGNERS[0] as USER, *,
row_number() over (partition by USER order by BLOCK_TIMESTAMP,INDEX) as rank
from eclipse.core.fact_events
WHERE SUCCEEDED=TRUE
and program_id not in (
'ComputeBudget111111111111111111111111111111','11111111111111111111111111111111','TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA',
'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL', 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL','BPFLoaderUpgradeab1e11111111111111111111111',
'Stake11111111111111111111111111111111111111','TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'))
)
Last run: 26 days ago
7
95B
313s