MoDeFieclipse users - popular app over time
    Updated 2025-02-23
    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
    WEEK_START
    PROGRAM_NAME_
    USER_COUNT
    1
    2024-08-19 00:00:00.000Nifty16
    2
    2024-08-26 00:00:00.000Nifty214
    3
    2024-08-26 00:00:00.000Sharp Trade1
    4
    2024-08-26 00:00:00.000Send Arcade1
    5
    2024-09-02 00:00:00.000Hyperlane2
    6
    2024-09-02 00:00:00.000Nifty1
    7
    2024-09-02 00:00:00.000Metaplex Core1
    8
    2024-09-09 00:00:00.000Save Finance2
    9
    2024-09-09 00:00:00.000Send Arcade1
    10
    2024-09-09 00:00:00.000Hyperlane1
    11
    2024-09-16 00:00:00.000Hyperlane385
    12
    2024-09-16 00:00:00.000Orca2
    13
    2024-09-23 00:00:00.000Hyperlane1435
    14
    2024-09-23 00:00:00.000Nifty39
    15
    2024-09-23 00:00:00.000Sharp Trade4
    16
    2024-09-23 00:00:00.000Lifinity4
    17
    2024-09-23 00:00:00.000Orca1
    18
    2024-09-23 00:00:00.000Send Arcade1
    19
    2024-09-30 00:00:00.000Hyperlane2199
    20
    2024-09-30 00:00:00.000Nifty141
    ...
    165
    7KB
    304s