flyingfishMeteora addLiquidityByWeight
    Updated 2025-02-04
    select
    decoded_instruction:args:liquidityParameter:binLiquidityDist as bin_json
    , (array_size(OBJECT_KEYS(bin_json)) - 1) as bin_json_size
    , bin_json:"0":binId as min_bin
    , bin_json:bin_json_size as max_bin
    , get(bin_json, (array_size(OBJECT_KEYS(bin_json)) -1) ::string) :binId as max_bin_2
    from solana.core.fact_decoded_instructions
    where tx_id = '3xZvqxp6csjWSRfmGGsZHrLLJaR4TJN4LDRfsRmPWDzWLKD9DLUcm4FVgzfNX7B4kzzMYFpEfrc8CbMbarUccc8w'
    and block_id = 318399351
    and event_type = 'addLiquidityByWeight'
    QueryRunArchived: QueryRun has been archived