flipside

    top program by users[Last Week]
    0xHaM-dtop program by users[Last Week]
    Updated 9 days ago
    -- forked from h4wk / top program by users @ https://flipsidecrypto.xyz/h4wk/q/DogcQDb2C0dc/top-program-by-users


    with events as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    program_id,
    signers[0] as user
    from eclipse.core.fact_events_inner
    WHERE block_timestamp::date < trunc(current_date, 'week')
    AND block_timestamp::date >= trunc(current_date, 'week') - 7
    AND succeeded = True
    )
    , inner_events as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    program_id,
    signers[0] as user
    from eclipse.core.fact_events
    WHERE block_timestamp::date < trunc(current_date, 'week')
    AND block_timestamp::date >= trunc(current_date, 'week') - 7
    AND succeeded = True
    )
    , combine as (
    select * from events
    UNION ALL
    select * from inner_events
    )

    select
    program_id,
    case
    when program_id = 'EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y' then 'Hyperlane'
    when program_id = 'BgG35GxoaMgmiam3EJzcwivwQ2DTYGPTLfUCg7bhiH6V' then 'Hyperlane multi-sig'
    Last run: 9 days ago
    PROGRAM_ID
    PROGRAM_NAME
    PROGRAM
    USER_COUNT
    1
    		turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxNturb...dGxN121246
    2
    		whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcOrcaOrca39191
    3
    		CLMMjQ8usCDmeP2hZFc6Mhih7JFbjg6mHeRxeEtTWHNfCLMM...WHNf24123
    4
    		So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAosave: lendingsave: lending18524
    5
    		iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEUInvariantInvariant16513
    6
    		TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9SAllDomains TLDAllDomains TLD13857
    7
    		ALTNSZ46uaAUU7XUV6awvdorLGqAsPwa9shm7h4uP2FKAllDomains Name ServiceAllDomains Name Service13780
    8
    		4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12LifinityLifinity11656
    9
    		SBondMDrcV3K4kxZR1HNVT7osZxAHVHgYXL5Ze1oMUvSBon...oMUv9834
    10
    		TCSVHqadS2swhap43BnZtmeEAPNXfpc3w2HLBredVaRTCSV...dVaR9788
    11
    		55ttmJsE9v5PtScfnA2q6S9VXgSPopV6WziiwH94SYws55tt...SYws9766
    12
    		Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kAAstr...35kA8660
    13
    		sooGfQwJ6enHfLTPfasFZtFR7DgobkJD77maDNEqGkDsolar: ammsolar: amm8317
    14
    		MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrMemo...fcHr5357
    15
    		22WrapbNKwPSy3HcGQTTJpgv43tszbZdTEfBEWmGYX2V22Wr...YX2V5042
    16
    		metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1smeta...8x1s4375
    17
    		EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9YHyperlaneHyperlane3876
    18
    		Hs7KVBU67nBnWhDPZkEFwWqrFMUfJbmY2DQ4gmCZfaZpHyperlane igpHyperlane igp3875
    19
    		CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7dMpl CoreMpl Core3531
    20
    		Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTicRari...LTic2960
    20
    2KB
    114s