0xHaM-dTop Projects By TXs[Past Week]
    Updated 2025-02-15
    with events as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    program_id,
    signers[0] as user
    from eclipse.core.fact_events_inner
    where succeeded = True
    )
    , inner_events as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    program_id,
    signers[0] as user
    from eclipse.core.fact_events
    where succeeded = True
    )
    , combine as (
    select * from events
    UNION ALL
    select * from inner_events
    )
    , functionTb as (
    select
    BLOCK_TIMESTAMP,
    program_id,
    TX_ID,
    user,
    case
    when program_id = 'EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y' then 'Hyperlane'
    when program_id = 'BgG35GxoaMgmiam3EJzcwivwQ2DTYGPTLfUCg7bhiH6V' then 'Hyperlane multi-sig'
    when program_id = 'Hs7KVBU67nBnWhDPZkEFwWqrFMUfJbmY2DQ4gmCZfaZp' then 'Hyperlane igp'
    when program_id = '4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12' then 'Lifinity'
    when program_id = 'iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU' then 'Invariant'
    when program_id = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'
    Last run: about 2 months ago
    No Data to Display
    0
    2B
    7s