flipside

    top program by Txs[Last Week]
    0xHaM-dtop program by Txs[Last Week]
    Updated 2025-03-25
    -- forked from top program by users[Last Week] @ https://flipsidecrypto.xyz/studio/queries/28762100-e9d2-448a-8486-5913a0be3bcd

    -- 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
    Last run: 3 months ago
    PROGRAM_ID
    PROGRAM_NAME
    PROGRAM
    TXS_COUNT
    1
    		turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxNturb...dGxN1549227731
    2
    		2YU4ujreHtNHqA27Hh1WQoWFHm33uugCz1WhxnnCjoLf2YU4...joLf918375
    3
    		wcowrB194t27cYq4xbW7JDSpgHoViPmEgyakgFWP54awcow...P54a443805
    4
    		FUCHhfHbuxXBWiRBfVdhmiog84sUJw11aAq3ibAUGL6eFUCH...GL6e289162
    5
    		crypt2SqR1oCtS5t9cy2GNPVjwsZ8rY8iKDEfaGJFiNcryp...JFiN230343
    6
    		whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcOrcaOrca161278
    7
    		STKgRMpqo41oATf18cHGFWaqVEe9gAWjLGzGZ9WpGH2STKg...pGH2112191
    8
    		pythWSnswVUd12oZpeFP8e9CVaEqJg25g1Vtc2biRsTpyth...iRsT97284
    9
    		rec5EKMGg6MxZYaMdyBfgwp4d5rB9T1VQH5pJv5LtFJrec5...LtFJ97186
    10
    		iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEUInvariantInvariant82562
    11
    		So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAosave: lendingsave: lending75226
    12
    		CLMMjQ8usCDmeP2hZFc6Mhih7JFbjg6mHeRxeEtTWHNfCLMM...WHNf61636
    13
    		4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12LifinityLifinity59745
    14
    		HDwcJBJXjL9FpJ7UBsYBtaDjsBUhuLCUYoz3zr8SWWaQHDwc...WWaQ58705
    15
    		dice3tAhSxMAJ88Ahm6AEdWgaAigcjHBLwWzUk4hCErdice...hCEr55397
    16
    		DcZMKcjz34CcXF1vx7CkfARZdmEja2Kcwvspu1Zw6Zmndecallsdecalls33157
    17
    		Astro1oWvtB7cBTwi3efLMFB47WXx7DJDQeoxi235kAAstr...35kA28274
    18
    		minyUEFJNEyixFJRyba9gXJmXyHJCzsBcNDNL8VEjSqminy...EjSq27719
    19
    		sooGfQwJ6enHfLTPfasFZtFR7DgobkJD77maDNEqGkDsolar: ammsolar: amm27056
    20
    		55ttmJsE9v5PtScfnA2q6S9VXgSPopV6WziiwH94SYws55tt...SYws24545
    20
    1KB
    957s