flipside

    Looking for a Eclipse program id instruction names
    flyingfishLooking for a Eclipse program id instruction names
    Updated 2025-03-07
    -- forked from Looking for a Solana program id instruction names @ https://flipsidecrypto.xyz/studio/queries/cc1b5553-2408-4daf-b281-af6115f6812c

    with
    logs as (
    select
    block_timestamp
    , tx_id
    , program_id
    , index
    , substr(livequery.utils.udf_base58_to_hex(instruction:data), 3, 16) as fun_hex
    , instruction
    , inner_instruction
    , log_messages
    from eclipse.core.fact_transactions
    join eclipse.core.fact_events using(block_timestamp, tx_id)
    where 1 = 1
    and block_timestamp > current_date - {{lookback_days}}
    and program_id = '{{program_address}}'
    and succeeded
    --limit 20
    -- and tx_id = '4ocENbUDh8EezVxbDVmrEguS1YfyvM3EKvqWHBaD7mnrG5rsLmcbdMKvkwm9XKEaTMTyUv2G6VzYM11xheoc1McL'
    -- and block_id = 25196010
    )

    , flattened_logs as (
    select
    logs.*
    , f.index as log_index
    , f.value as log_msg
    , CASE
    WHEN LOG_MSG LIKE '% invoke [%' THEN log_msg
    ELSE NULL
    END AS program_invocation
    from logs
    , lateral flatten (input => log_messages) f
    )
    Last run: about 2 months ago
    INSTRUCTION_NAME
    INSTRUCTION_HEX_IDENTIFIER
    LOG_REFERENCES
    FIRST_LOG_REFERENCE
    LAST_LOG_REFERENCE
    SAMPLE_TX
    SAMPLE_INSTRUCTION
    SAMPLE_INNER_INSTRUCTION
    SAMPLE_INSTRUCTION_DATA
    1
    		SwapBaseInput8fbe5adac41e33de4212025-02-07 18:13:50.0002025-03-07 00:37:49.000
    3dhFQg6VRrLAhfC5wpzJCTtBezyWtNgBko8xhJDQWxeeHBMDmfcNAR1pzZvNtAnE7hGLxt9V...
    {"accounts":["DNkZLxq2Yup6XxiV7LyMTgLcs4ABbKxjZhnWFHa4FwPt","8Fw8mqzUTA6...
    {"index":3,"instructions":[{"parsed":{"info":{"authority":"DNkZLxq2Yup6X...
    E73fXHPWvSRXfo3gKquCoiZVBWPXNGKvF
    2
    		SwapBaseOutput37d96256a34ab4ad932025-02-22 12:46:07.0002025-03-06 14:14:15.000
    4y64U1m1qak7se7CgnBj5eSMDDxqwsKLHFFD5L5gLShWVrsBKWWKq6e7PYhjJ6KHdDj62L4k...
    {"accounts":["8BBbkvr5cMNgbTrsSZhpbiCXepEXgEufiMmJggTmuMrt","8Fw8mqzUTA6...
    {"index":3,"instructions":[{"parsed":{"info":{"authority":"8BBbkvr5cMNgb...
    66JafaVu7KN8prYiRjZM8zL1UrqAdxkTR
    3
    		Depositf223c68952e1f2b6342025-02-21 15:05:58.0002025-03-07 03:11:58.000
    31Db6h7Ai6JyXaRavynvxmXXtsnBDqLb38HKvciMRLweAVhtKzwYoWDWJziJYHDnrHrkdXvx...
    {"accounts":["8Gk6zPsSDqAN42mAFXZ6cftcSedntUbGKmFz6vSaESjt","8Fw8mqzUTA6...
    {"index":2,"instructions":[{"parsed":{"info":{"authority":"8Gk6zPsSDqAN4...
    HJDJa2VrXJbbYybufeWLQUnyCtphZFArHRekdSaVN4fH
    4
    		UpdateAmmConfig313cae889a1c74c8332025-02-07 11:47:14.0002025-02-28 11:39:03.000
    39S8DErrzzu53a3yiCTBw19zAGg7hUtDH9dKxQmTCGJL31Hz8DFfQct9yAp97baJsaA2sVaZ...
    {"accounts":["8FeijbkxxXJEB1f14feTryJH5B57s8Jrx26nE1VuaTDA","D7yRdhWdKig...
    TqUqBuCpNAD2DMy2pNqaWBZ
    5
    		Withdrawb712469c946da122152025-02-23 22:58:18.0002025-03-07 03:31:47.000
    2esHULpJmJsADNFd7NhUtWfutbXcs7966zXiHGmjtaF9fUEjw7CZz1h51iXqt5UTtrT7pXkZ...
    {"accounts":["61yh5ZeB9j9dZftq1msQtbG5kwN1SEfhqGrvGzb1YZ9H","8Fw8mqzUTA6...
    {"index":3,"instructions":[{"parsed":{"info":{"account":"5SLcGoRr3kFe9AZ...
    DKdmmkf3icp9c4MUUm6fLfpZEiCm3uHoC8CfM9JUVNFq
    6
    		Initializeafaf6d1f0d989bed82025-02-07 16:56:17.0002025-02-07 17:25:24.000
    4eRFh6E2PTYemaWec1GjL1JMVLXgrGYTprwtpKBGcbayTTwsocerzRPuNjWc2EUsgBKVFAFt...
    {"accounts":["6pvHsUrhZ6H7S3CUU8yBLz6HQRC7SPxPouKKTmN9LN5","D7yRdhWdKig5...
    {"index":1,"instructions":[{"parsed":{"info":{"lamports":14280,"newAccou...
    CpoVi745fTaBDQebRjNn3r2xhABQUaATaXmpS5x37iB9
    7
    		CreateAmmConfig8934edd4d7756c6832025-02-07 11:45:35.0002025-02-07 11:45:59.000
    39c8zWg29t7877gWq4N2fCoqgLsqyZQX94Eo1bn5paDhQs2hvhVsb2wMXX6jUd5giaB2Lwc7...
    {"accounts":["8FeijbkxxXJEB1f14feTryJH5B57s8Jrx26nE1VuaTDA","qfnGo4zthsq...
    {"index":0,"instructions":[{"parsed":{"info":{"lamports":24752,"newAccou...
    3HpFwckDLu4aqUtco4ggfhfoFnMVHkqzHXXCiNUkRQrE6FArXhWXZvHgfR
    7
    16KB
    39s