flipside

    Looking for a Solana program id instruction names
    flyingfishLooking for a Solana program id instruction names
    Updated 6 hours ago
    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 solana.core.fact_transactions
    join solana.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
    )

    , 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
    )

    , filtered_logs as (
    select
    flattened_logs.*
    , LAST_VALUE(program_invocation IGNORE NULLS)
    Last run: about 6 hours ago
    INSTRUCTION_NAME
    BASE58_IDENTIFIER
    INSTRUCTION_HEX_IDENTIFIER
    LOG_REFERENCES
    FIRST_LOG_REFERENCE
    LAST_LOG_REFERENCE
    SAMPLE_TX
    SAMPLE_INSTRUCTION
    SAMPLE_INNER_INSTRUCTION
    SAMPLE_INSTRUCTION_DATA
    1
    		ClaimFee2BH9xzWhK70bf65ab1c907fbb4024062025-05-27 00:00:02.0002025-05-30 09:38:47.000
    SHjvpREf8LGJY1Dr6SJrY8m4AYyqam2LgHrsnXgooyjPFEzmbCo3HZwjQ6RrKT3w24pWdWxj...
    {"accounts":["9dxVtUN7FDuf24o9VLPV62XXAsjuECoHWoHVfRvdWdvz","Es2sAmzftaz...
    {"index":3,"instructions":[{"parsed":{"info":{"authority":"9dxVtUN7FDuf2...
    BH9xzWhK5ooVGgiV1fMg7sQgaoNd2ACKh
    2
    		AddLiquidityByStrategy24Co7us6M03dd95da6f8d76d53911862025-05-27 00:00:02.0002025-05-30 09:38:47.000
    5sTM9afi7Y4GHrrLcyToT6NeESbpHna7R7bdGGKUBotBLXfHL9jQxFpSU3DDsu6BcWut4F69...
    {"accounts":["3irqarUzvFNPF5v1ypiXRMF9xWuRMeczoJovRocMMutQ","5BDuFW8a3JQ...
    {"index":5,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    4Co7us6MBHJN45XnQDLJS4hSz4EmPvsoXipHetBN7TduM8aduVbEo6U9KbKrNcsNDJ4aUo5JNEbb8wB2aAcLEwg7Jjg6uya3hEHMMyYghmC4ujhW2ewR3gFsFgX8n1s6iJ7F3fkXMoAhLNHCvDCEKwDa1V
    3
    		RemoveLiquidityByRange27FKxUv3occ02c391359191cd3618372025-05-27 00:00:02.0002025-05-30 09:38:47.000
    SHjvpREf8LGJY1Dr6SJrY8m4AYyqam2LgHrsnXgooyjPFEzmbCo3HZwjQ6RrKT3w24pWdWxj...
    {"accounts":["Es2sAmzftazPu4YbDZK1hvwKMTwbjenbok2ZECGfaswY","9dxVtUN7FDu...
    {"index":2,"instructions":[{"parsed":{"info":{"authority":"9dxVtUN7FDuf2...
    7FKxUv3oxZYXYxv8sbiZoWLzx2ti65GbqM8T
    4
    		Swap25Pt3sFHw414b3f4ceb5b5b881970052025-05-27 00:00:02.0002025-05-30 09:38:47.000
    36gArkN8bDMvBYPnvuFLM8CtgMJGrfXEqL7Pi7Zxd6dpxgmd5bLKL2FeK6Q8xHVgzCveyuDV...
    {"accounts":["3DdK99TzSp9LKe2pDEQN3VkCL9at5eNtBnaBiUS5E66a","LBUZKhRxPF3...
    {"index":5,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    5Pt3sFHwo4SiWbbKGxjW3AsPse1DZasjkqoiJYG3xAwh
    5
    		InitializePositionU8tsMorvdbc0ea47bebf66501915162025-05-27 00:00:05.0002025-05-30 09:38:44.000
    5sTM9afi7Y4GHrrLcyToT6NeESbpHna7R7bdGGKUBotBLXfHL9jQxFpSU3DDsu6BcWut4F69...
    {"accounts":["2ATdZCUvoZZfoSYbqkq3oxqNwgCqk6vyEcrFaCmxChyC","3irqarUzvFN...
    {"index":1,"instructions":[{"parsed":{"info":{"lamports":57406080,"newAc...
    U8tsMorvfQ13ur4eEqXjGb
    6
    		ClosePositionIfEmptyAx74Cx8U3b7cd4765b986e9d1865942025-05-27 00:00:02.0002025-05-30 09:38:46.000
    SHjvpREf8LGJY1Dr6SJrY8m4AYyqam2LgHrsnXgooyjPFEzmbCo3HZwjQ6RrKT3w24pWdWxj...
    {"accounts":["Es2sAmzftazPu4YbDZK1hvwKMTwbjenbok2ZECGfaswY","4xDXXSCKUrG...
    {"index":4,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    Ax74Cx8Uopx
    7
    		SwapPgQWtn8of8c69e91e17587c8876082025-05-27 00:00:12.0002025-05-30 09:38:41.000
    4tgzGYSg2iy5YYCJb2qgBzocScEz99xQZLYjawXhns61wazQhnufrVus5eDYxps5YzasQzAn...
    {"accounts":["HTvjzsfX3yU6BUodCjZ5vZkUrAxMDTrBs3CJaq43ashR","LBUZKhRxPF3...
    {"index":3,"instructions":[{"parsed":{"info":{"authority":"4GQeEya6ZTwvX...
    PgQWtn8oziwpxqXBawaJJgCytP2TEUFRH
    8
    		Swap2fx9RHbGF414b3f4ceb5b5b88416372025-05-27 00:00:38.0002025-05-30 09:38:46.000
    2Hz1k7TBikV8mDkG9hA3fh1YQBbGAq9cxfjKeDzsVv5DP3qfCikgNy1q87nxVBRoi5btkC5B...
    {"accounts":["AjM8Qn62EhR4ikJ1rvyeezB1NyvrSsb4zwJiFUFs9ycs","LBUZKhRxPF3...
    {"index":1,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    fx9RHbGFfZ9eJMVibfJ5ZpaD6KzYuuNk1PRRdR
    9
    		SwapExactOutPpPrXyznfa49652126cf4bb8103782025-05-27 00:00:42.0002025-05-30 09:38:48.000
    2Ficg4kr1EBNhKGqre4fsKpohQbLn4hXhCmZ8hKE2cxSCPqsYuEDzwwpvLgwrtpjjPNsqfnY...
    {"accounts":["7wkFP7EHYTgeUG5ouX64ftTsMuXpR1gFCJK6knyp22Rd","LBUZKhRxPF3...
    {"index":2,"instructions":[{"parsed":{"info":{"authority":"4GQeEya6ZTwvX...
    PpPrXyznwWLAZ1fAXF5CT4ENiz2XrxtWT
    10
    		ClaimFeeVHjhLVSha9204f8988e8468957022025-05-27 00:08:52.0002025-05-30 09:38:42.000
    5WrhUTUBwC4XEktZ492dCoe9QdvSEE6THBqXjiSPH8J7FzPhA2jxK4PEjBfT7kVXYzu2P4Ct...
    {"accounts":["5rCf1DM8LjKTw4YqhnoLcngyZYeNnQqztScTogYHAS6","5m1jGfUmwYxv...
    {"index":3,"instructions":[{"parsed":{"info":{"amount":"408338","authori...
    VHjhLVShzoA
    11
    		AddLiquidityByStrategy8seFDAZn0703967f94283dc845062025-05-27 00:00:29.0002025-05-30 09:38:43.000
    2Agaqm7RgCybkB6cNVGcU5oF2qag3FC7nHioQUqh3pF4aWF1gq4xWQJnWHJqzw52Yitpn26m...
    {"accounts":["AZaAfbEaJENbZbP5jVibrgqSANgKU8cjRgcH7YnP9siC","5rCf1DM8LjK...
    {"index":6,"instructions":[{"parsed":{"info":{"amount":"64501149883","au...
    8seFDAZncp5NmH8fasGC9fTJ2PQhr8tRfF23siWwqKyPP1seVMK6UwMhTZc6R4DwvBXEHehZEV1DYesN9uPKSe12q54vENTRZxto7syDkq9EDDk6jumyfvi3xorFS4njMtkHW33ioPJYXhH
    12
    		ClosePositionMfLxSQLg7b8651003144626240362025-05-27 00:10:03.0002025-05-30 09:38:42.000
    5WrhUTUBwC4XEktZ492dCoe9QdvSEE6THBqXjiSPH8J7FzPhA2jxK4PEjBfT7kVXYzu2P4Ct...
    {"accounts":["5m1jGfUmwYxv8Aujyetc27Zkii58eFf95NkLqud2fNZJ","5rCf1DM8LjK...
    {"index":4,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    MfLxSQLgoGV
    13
    		RemoveLiquidityByRange26Kf8gHp1a526698f04a691a38822025-05-27 00:10:03.0002025-05-30 09:38:42.000
    5WrhUTUBwC4XEktZ492dCoe9QdvSEE6THBqXjiSPH8J7FzPhA2jxK4PEjBfT7kVXYzu2P4Ct...
    {"accounts":["5m1jGfUmwYxv8Aujyetc27Zkii58eFf95NkLqud2fNZJ","5rCf1DM8LjK...
    {"index":2,"instructions":[{"parsed":{"info":{"amount":"0","authority":"...
    26Kf8gHpT2XVb3Y9nZuAdR8j8
    14
    		ClosePosition2WASAKj21ae5a2373ba2893e223692025-05-27 00:12:47.0002025-05-30 09:35:02.000
    2kRxy7PSZCTg5RAzJwsorqqBHsCcoVyXd4YcUV48r5xwDMNJ8wsDiKHtPnYrDTTQZhXkRBCT...
    {"accounts":["5JRYYaXWzZgrbk5K4mUwnSLTrnxBp2CDY1NxoDb1fsQj","CgJLwUXM4jB...
    {"index":2,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    WASAKj21HBF
    15
    		InitializeBinArray5N5iEh8c235613b94ed44bd319472025-05-27 00:00:40.0002025-05-30 09:35:28.000
    4P37pB7YMEcmpnRwSFqHY83kbf49Qwn9ab1mbdCPCMiR8khUDbBfwiNhZ9ArCGeqCf5ZNr9t...
    {"accounts":["5pA9XDJPQUYrmh8tkoBeEFYJepSUqX3TbgnxtuXJZyjt","5pJ1eTdRdcM...
    {"index":2,"instructions":[{"parsed":{"info":{"lamports":71437440,"newAc...
    5N5iEh8cThcwNHcMJ5GZ4S
    16
    		GoToABin3m7LN7yD9248aee028fd54ae9302025-05-27 00:12:12.0002025-05-30 09:15:26.000
    4txEcNeVZVwY2D1oxfiAqN73VcF3nVBXXhxAv869vinRgtbr36kRW4w1tpagaGeM5Vj5P9TM...
    {"accounts":["8XaW7WAtZTKK937irB9DMG53aSsB3gF6cu7KQwCbx8UF","LBUZKhRxPF3...
    {"index":0,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    3m7LN7yDYkTAnLJKY
    17
    		SwapExactOut2T9yQU1Eq2bd7f784893cf3518442025-05-27 00:23:07.0002025-05-30 09:17:17.000
    5zEuKho3V25j6L5qHnqDfeUksqwpaBtC54EsyGLxEhmzz4L928DUkjZbJWbk2FSgdU151LPP...
    {"accounts":["AjM8Qn62EhR4ikJ1rvyeezB1NyvrSsb4zwJiFUFs9ycs","LBUZKhRxPF3...
    {"index":2,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    T9yQU1EqMJhv745MVFq6zGjxUod1d9Q8tngNcP
    18
    		InitializeLbPair236sFunWm493b2478ed536cc67092025-05-27 00:05:57.0002025-05-30 09:35:45.000
    2ELvD6i7bk67HEs2amQW2BJB1Zifu9FjSjDPWDiSkDdDYzoJTgi6xBzBQUp96VFYNH1ZE5y9...
    {"accounts":["FnLsznSW6ihXnmkZDVkEUUvSZjoY4P9FJc74p6KULdej","LBUZKhRxPF3...
    {"index":0,"instructions":[{"parsed":{"info":{"lamports":7182720,"newAcc...
    36sFunWmrVefhwNHjhM4jbZB57ARC6zNSDbTpSbGcfCfFggr4bvu19bDK6k7JBpVg3B1M9WJ5AHuJGFh8ME8BLVZb49j8pnQXf81ouh9EtZcDzg7Z2kV5d8hnfsjVrsNfeuZsdMqLwSdYQhrjvfH
    19
    		AddLiquidityOneSide5bkCk3vi5e9b6797465fdca56042025-05-27 00:30:19.0002025-05-30 07:40:14.000
    me6xrUah1v19EZzWtanij2bpi4vdNrfiYHXb9CdAS7nYxJyDxD74pQdejzjb8ASekwGr9JFn...
    {"accounts":["F5h76yKTQV3bGU32yonrjopctxfaMdNkP3drmdwnwAa8","rZcdGVxNZox...
    {"index":2,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    5bkCk3vidiw72aFnovZs7fLEgVmuuFwgwGm3FFRuPyvT3xF28RM4HsNtxPFt4bFqHhxmdaiwfB4bm8wqTyK5NzT3ZZvLWu6QumkQGNwhXacQHA4hy1X1AY9qjhuqXx9b7LqRiPEDPi1pigTubM1C2wHnrtWw755fnkWpDrBNTZ6sTMVHQm4rrAgJj3FUeavnqrchhMjrcE3gDWuDLZqnKe2VJExb2fKSXofj7JQm6W9BsWawgfTG5YyVzEnYMkbkeUhhufSRYLxyykuQqqyRB4aKsvxMFW5nkKEKdqLFUPbqrBFQiiH53NusH8twZgobBnQFPK6UbKMsz8ydNor1FGXuFpThj3sd6gRXfTNgHmhBCw5zs4auqqNN145DvBucdM6Sq3BJ3ZRGgwCicjdDN8Jqbg3mktTNUvftgNmJrJ9Dyyah7Us8gsrXGmvCUwSCaFB1gkydWAuCQheqaHz9yMz5KvpgbXvjNDMq5hkhFN8ekfFrwtCTQmP2etkgntT7SY9xLSwCAkSVPE76vsWmXcWP2xjp8cNS3ZYrGjNaXLcaKnLWah6DE9sESh1EnDLFnsstL2wuxX2ZdsCpKkgijuzWGgfZ
    20
    		AddLiquidityOneSide393fdNzd5e9b6797465fdca54542025-05-27 16:23:47.0002025-05-29 08:21:51.000
    3JHMrmRA486hxostRegsGsbu5zQocaUk1iCQMSnTBq1Da7h35Ke48gdyrzPQQak72W5n9gBY...
    {"accounts":["HpmcS2sQFJRj4G1XgAj6S3ABgod8fkSH2dvkQ5uui9ib","4kdxjt8pKEW...
    {"index":3,"instructions":[{"accounts":["D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjz...
    393fdNzdKGnL5vb6E2AhKZAevtoN6XnvDfshpPqSBJ6EGgN
    ...
    145
    367KB
    123s