Balances and transactions

Endpoint

https://us.market-api.kaiko.io/v2/data/wallet.v1/audit

Parameters

Parameter

Description

Example

Required?

blockchain

Always solana.

solana

sort

The sorting order for the results.

asc or desc

page_size

Number of results to return data for. (max: 5000).

See Pagination

100

start_time

Starting time in ISO 8601 (inclusive).

2022-05-01T00:00:00.000Z

end_time

Ending time in ISO 8601 (inclusive).

2022-05-01T00:00:00.000Z

transaction_hash

Filter by transaction hash.

syJFDzPJJ92GLsXqYXUKEY23e8uoLPAdgci7Ko9cUYZxvCvf5SHdKnYuC1Jh7UrTSzRc2EpUB7kzCwGd2qdTnKD

user_address

Filter by user address.

2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2

token_address

Filter by token address.

EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v

token_symbol

Filter by token symbol.

SOL

Fields

Field

Description

Example

chain

Blockchain name.

solana

block_number

The height of the block.

328800011

timestamp

The timestamp of the block.

1742793063000000000

user_address

The address on which the row is focused.

CsVdJ8WH8Q9eHSTRpwtwN3TYApm24QnLKYUMNxJ3DaED

transaction_hash

Transaction hash.

syJFDzPJJ92GLsXqYXUKEY23e8uoLPAdgci7Ko9cUYZxvCvf5SHdKnYuC1Jh7UrTSzRc2EpUB7kzCwGd2qdTnKD

transaction_type

Event type. See more information below.

transfer

transaction_index

The index of the transaction.

15

ordinal

Index of the event.

5

sender_address

The address that sends tokens or coins.

2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2

receiver_address

The address that receives tokens or coins.

CsVdJ8WH8Q9eHSTRpwtwN3TYApm24QnLKYUMNxJ3DaED

token_symbol

Symbol of the token or coin transfered

SOL

token_address

The address of the token or coin transfered.

So11111111111111111111111111111111111111112

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

3.697694466

amount_usd

Amount of asset transferred in usd.

513.02619

balance_after

Wallet balance for the user_address for this asset.

2816.119373498

balance_after_usd

Wallet balance for the user_address for this asset in usd.

390714.54077

Request example

curl --compressed -H "Accept: application/json" -H "X-Api-Key: <client-api-key>" \
  "https://eu.market-api.kaiko.io/v2/data/wallet.v1/audit?blockchain=solana"

##### 1. Import dependencies #####
import requests
import pandas as pd

##### 2. Choose the value of the query's parameters #####
# ---- Required parameters ---- #
blockchain = "solana" 

# ---- Optional parameters ---- #
start_time = "2025-03-05T00:00:00Z"
end_time = "2025-03-05T00:02:00Z"
page_size = 100
sort = "desc"
transaction_hash = None
user_address = None
token_address = None

# ---- API key configuration ---- #
api_key = "YOUR_API_KEY"

##### 3. Get the data #####
# ---- Function to run an API call ---- # 
# Get the data in a dataframe --------- # 

def get_kaiko_data(api_key: str, blockchain: str, start_time: str, end_time: str, page_size: int, sort: str, transaction_hash: str, user_address: str, token_address: str):
    headers = {'Accept': 'application/json', 'X-Api-Key': api_key}
    
    url = f'https://us.market-api.kaiko.io/v2/data/wallet.v1/audit'
    params = {
        "blockchain": blockchain,
        "start_time": start_time,
        "end_time": end_time,
        "page_size": page_size,
        "sort": sort,
        "transaction_hash": transaction_hash,
        "user_address": user_address,
        "token_address": token_address
    }

    try:
        res = requests.get(url, headers=headers, params=params)
        res.raise_for_status() 
        data = res.json()
        if 'data' not in data:
            print("No data returned.")
            return pd.DataFrame() 
        df = pd.DataFrame(data['data'])

        # Handle pagination with continuation token
        while 'next_url' in data:
            next_url = data['next_url']
            if next_url is None:
                break
            res = requests.get(next_url, headers=headers)
            res.raise_for_status()
            data = res.json()
            if 'data' in data:
                df = pd.concat([df, pd.DataFrame(data['data'])], ignore_index=True)
        return df

    except requests.exceptions.RequestException as e:
        print(f"API request error: {e}")
        return pd.DataFrame() 

# ---- Get the data ---- #
df = get_kaiko_data(api_key=api_key, blockchain=blockchain, start_time=start_time, end_time=end_time, page_size=page_size, sort=sort, transaction_hash=transaction_hash, user_address=user_address, token_address=token_address)
print (df)

Response example

{
  "query":
    {
        "live": "False",
        "start_time": "2024-01-01T00:00:00.000Z",
        "end_time": "2024-01-02T00:00:00.000Z",
        "start_block": 0,
        "end_block": 0,
        "page_size": 100,
        "sort": "0",
        "data_version": "v1",
        "commodity": "wallet_data",
        "request_time": "2024-01-01T00:00:00.000Z"
    },
    "time": "2024-01-01T00:00:00.000Z",
    "timestamp": 1732530743000,
    "access":
    {
        "access_range":
        {
            "start_timestamp": 1073001600000,
            "end_timestamp": "None"
        },
        "data_range":
        {
            "start_timestamp": "None",
            "end_timestamp": "None"
        }
    },
    "data":
    [
    	{
            "chain": "solana",
            "block_number": 328800011,
            "timestamp": 1742793063000000000,
            "user_address": "h3ZXAE168mNxsszYYrUfkMVSCWx6DU2Uvrx97Kb1Nch",
            "transaction_hash": "swSCgiEcupMtZpvuhubRp1h9BXkWdgox11qgJKofNxSnMTQuqAJEGbaiQyJtg5qXxVtyeVzUDizyLvcHcVj7E2k",
            "transaction_type": "transaction_fee",
            "transaction_index": 990,
            "ordinal": 11,
            "sender_address": "h3ZXAE168mNxsszYYrUfkMVSCWx6DU2Uvrx97Kb1Nch",
            "receiver_address": "",
            "token_symbol": "SOL",
            "token_address": "NativeSoL1111111111111111111111111111111111",
            "direction": "out",
            "amount": 5e-06,
            "amount_usd": 0.0006937108995617679,
            "balance_after": 51.445994867,
            "balance_after_usd": 7137.729475607333
        },
        /* ... */
    ],
    "continuation_token": "xxx",
    "next_url": "https://us.market-api.kaiko.io/v2/data/wallet.v1/audit?continuation_token=xxx"
    }
}

Possible values for the field `transaction_type`:

Value

Description

transfer

A coin transfer operation.

token_transfer

This operation involves the transfer of (SPL) tokens.

gas_fees

The amount of gas purchased by the initiator to execute the transaction.

PreviousSolana Wallets NextCME

Last updated 6 months ago

Was this helpful?

##### 1. Import dependencies ##### import requests import pandas as pd ##### 2. Choose the value of the query's parameters ##### # ---- Required parameters ---- # blockchain = "solana" # ---- Optional parameters ---- # start_time = "2025-03-05T00:00:00Z" end_time = "2025-03-05T00:02:00Z" page_size = 100 sort = "desc" transaction_hash = None user_address = None token_address = None # ---- API key configuration ---- # api_key = "YOUR_API_KEY" ##### 3. Get the data ##### # ---- Function to run an API call ---- # # Get the data in a dataframe --------- # def get_kaiko_data(api_key: str, blockchain: str, start_time: str, end_time: str, page_size: int, sort: str, transaction_hash: str, user_address: str, token_address: str): headers = {'Accept': 'application/json', 'X-Api-Key': api_key} url = f'https://us.market-api.kaiko.io/v2/data/wallet.v1/audit' params = { "blockchain": blockchain, "start_time": start_time, "end_time": end_time, "page_size": page_size, "sort": sort, "transaction_hash": transaction_hash, "user_address": user_address, "token_address": token_address } try: res = requests.get(url, headers=headers, params=params) res.raise_for_status() data = res.json() if 'data' not in data: print("No data returned.") return pd.DataFrame() df = pd.DataFrame(data['data']) # Handle pagination with continuation token while 'next_url' in data: next_url = data['next_url'] if next_url is None: break res = requests.get(next_url, headers=headers) res.raise_for_status() data = res.json() if 'data' in data: df = pd.concat([df, pd.DataFrame(data['data'])], ignore_index=True) return df except requests.exceptions.RequestException as e: print(f"API request error: {e}") return pd.DataFrame() # ---- Get the data ---- # df = get_kaiko_data(api_key=api_key, blockchain=blockchain, start_time=start_time, end_time=end_time, page_size=page_size, sort=sort, transaction_hash=transaction_hash, user_address=user_address, token_address=token_address) print (df)

Good night

Endpoint

Parameters

Fields

Request example

Response example

Possible values for the field transaction_type:

Possible values for the field `transaction_type`: