dune query by solana pumpfun instruction code

select
    account_arguments[8] as dev_addr,
    count(account_arguments[1]) as token_addr_count
from
    solana.instruction_calls
where
    executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
    and bytearray_substring (data, 1, 8) = 0x181ec828051c0777
    -- FROM_HEX('b712469c946da122')
    and tx_success = true
    AND block_time > NOW() - INTERVAL '30' day
    -- AND block_time BETWEEN date '2025-01-01' AND date '2025-01-31'
group by
    1
order by
    2 desc

create

181ec828051c0777

Buy

66063d1201daebea

Sell

33e685a4017f83ad

withdraw

b712469c946da122

python code

import re
from hashlib import sha256

def camel_to_snake(text):
    str1 = re.sub('(.)([A-Z][a-z]+)', r'\1_\2', text)
    return re.sub('([a-z0-9])([A-Z])', r'\1_\2', str1).lower()

ix_name = "Buy"
ix_name = "Sell"
ix_name = "Create"
ix_name = "withdraw"

stuff = f"global:{camel_to_snake(ix_name)}"
encode = sha256(stuff.encode()).digest()[:8]

print("action: ", stuff)
print(encode.hex())

rust code