flipside

    eclipse; users and weekly programs
    elovianooeclipse; users and weekly programs
    Updated 2025-01-16
    -- forked from MoDeFi / eclipse users - popular app over time @ https://flipsidecrypto.xyz/MoDeFi/q/kDGxPYY1bNIa/eclipse-users---popular-app-over-time

    -- with users_first_app as (
    -- select date_trunc('week' , block_timestamp) ,
    select
    date_trunc('week' , block_timestamp) as week
    , user
    , count(distinct program) as program_interactions
    from (
    select block_timestamp
    , tx_id
    -- date_trunc('week' , block_timestamp)
    , SIGNERS[0] as 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'
    Last run: 3 months ago
    WEEK
    USER
    PROGRAM_INTERACTIONS
    1
    		2025-01-06 00:00:00.000
    2PUiePmSpFP2ieURpysaAkhP2yfA9PM45ejbERtoD8qe
    		7
    2
    		2025-01-06 00:00:00.000
    E38JuNJxyn3jpA3SMWKubbayAVNmSnbR4WnNZgc39Psp
    		7
    3
    		2025-01-06 00:00:00.000
    DvTG75e4EE6Epqu69ywNhEqkZcKs9qRoRzkKtoSke1nD
    		7
    4
    		2025-01-06 00:00:00.000
    HgcXpQEuu58bRkNGByfPKxqMQ2zogwAzwQRn6EhdUHNX
    		8
    5
    		2025-01-06 00:00:00.000
    9GFd6mDSNuVdDahF1bvVdETcsLmEkqQm2Xu6QqCae4dS
    		7
    6
    		2025-01-06 00:00:00.000
    Abw9nqWcHghxQ385UpcXzyyJoQp9dk9SzPKsWbhiZqeU
    		7
    7
    		2025-01-06 00:00:00.000
    BERMt6vHnp3Hb3jbsmMm5gESqpGWEqWEaqn7BfQR2RZ
    		7
    8
    		2025-01-06 00:00:00.000
    2xuZja8Hi8oVreG93mjkg3ebQ8t6Pd6jEegLsWVRN6gi
    		9
    9
    		2025-01-06 00:00:00.000
    J96iYKEDeFcxLXVWAwHs6fg2tF2Bmr3YwkCkNRe39xw3
    		8
    10
    		2025-01-06 00:00:00.000
    Gad9KG5NdvRnNsnAkaxFZNnWnZ4TE3m7Hn9kDT36mndD
    		9
    11
    		2025-01-06 00:00:00.000
    BDufgnvFfL9LfwrhaSNkk72DEnFhsfmUZ6SV9NuFeDvg
    		7
    12
    		2025-01-06 00:00:00.000
    AQ4broBsYUWYXkskCuZCgQuhNBTMmiFx9tDiLGuBmNCY
    		7
    13
    		2025-01-06 00:00:00.000
    7Ye3JGBRHP8WXDErYyLeV8vkdJVd8GCvJCQbJc9brKQZ
    		8
    14
    		2025-01-06 00:00:00.000
    E3Mk8uoTh15WVb8HipkpiV9YPdrjSvsFvdkDWEd2K9LG
    		7
    15
    		2025-01-06 00:00:00.000
    6AmkS1rNqwJQLrYCthmWmvkG3qGcmSGxbLqzi61ijppw
    		7
    16
    		2025-01-06 00:00:00.000
    GarbWPv4TkK8vcCyZ2Z15EC5jZaKk2myQiZjgSfJ9ThD
    		8
    17
    		2025-01-06 00:00:00.000
    21zKtQNL92R7mUWr9yp4fSGNm3UA6TdVGdXeWqDTVSmg
    		9
    18
    		2025-01-06 00:00:00.000
    2zNDnL4Mf9QxeNXsmCHb4uMLJKEijNDP4phcWcXNYKbo
    		8
    19
    		2025-01-06 00:00:00.000
    9C5iNCJMeAV6upyXvpGvL7ERqebwwZh5vPNHFqUwNsT5
    		8
    20
    		2025-01-06 00:00:00.000
    7YrDgehmaEjRtGLVbVdWr2dFp9t61KtF5qQFU71sqepr
    		8
    ...
    6364
    479KB
    19s