Balances and transactions
Endpoint
https://us.market-api.kaiko.io/v2/data/wallet.v1/auditParameters
blockchain
Always solana.
solana
sort
The sorting order for the results.
asc or desc
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.
token_symbol
Filter by token symbol.
Fields
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_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:
transaction_type: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.
Last updated
Was this helpful?
