WEEK_START | PROGRAM_NAME_ | USER_COUNT | |
|---|---|---|---|
1 | 2024-08-19 00:00:00.000 | Nifty | 16 |
2 | 2024-08-26 00:00:00.000 | Nifty | 214 |
3 | 2024-08-26 00:00:00.000 | Sharp Trade | 1 |
4 | 2024-08-26 00:00:00.000 | Send Arcade | 1 |
5 | 2024-09-02 00:00:00.000 | Hyperlane | 2 |
6 | 2024-09-02 00:00:00.000 | Nifty | 1 |
7 | 2024-09-02 00:00:00.000 | Metaplex Core | 1 |
8 | 2024-09-09 00:00:00.000 | Save Finance | 2 |
9 | 2024-09-09 00:00:00.000 | Send Arcade | 1 |
10 | 2024-09-09 00:00:00.000 | Hyperlane | 1 |
11 | 2024-09-16 00:00:00.000 | Hyperlane | 385 |
12 | 2024-09-16 00:00:00.000 | Orca | 2 |
13 | 2024-09-23 00:00:00.000 | Hyperlane | 1435 |
14 | 2024-09-23 00:00:00.000 | Nifty | 39 |
15 | 2024-09-23 00:00:00.000 | Sharp Trade | 4 |
16 | 2024-09-23 00:00:00.000 | Lifinity | 4 |
17 | 2024-09-23 00:00:00.000 | Orca | 1 |
18 | 2024-09-23 00:00:00.000 | Send Arcade | 1 |
19 | 2024-09-30 00:00:00.000 | Hyperlane | 2199 |
20 | 2024-09-30 00:00:00.000 | Nifty | 141 |
MoDeFieclipse users - popular app over time
Updated 2025-02-23
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 null end as program_name, program_id, tx_id,
date_trunc('{{Interval}}', BLOCK_TIMESTAMP) as week_start
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: 20 days ago
...
165
7KB
304s