1 of 6

Kaiko Blockchain Monitoring

Ethereum Wallets

What is this endpoint for?

This endpoint offers in-depth insights into Ethereum wallets including transfers and wallet balances over time.

Balances and transactions

Endpoint

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

Parameters

Parameter

Description

Example

Required?

blockchain

Always ethereum.

ethereum

sort

The sorting order for the results.

asc or desc

page_size

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

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

The transaction hash to filter on.

0xf7825247b9a9355c0fb45ec0d008fe638ce5bae9cb877c6a28a91d9ea5f17341

user_address

The address to filter on.

0x000000fee13a103a10d593b9ae06b3e05f2e7e1c

token_address

The token address to filter on.

0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2

Fields

Field

Description

Example

chain

Blockchain name.

ethereum

block_number

The height of the block.

7005997

timestamp

The timestamp of the block.

1546560004

user_address

The address on which the row is focused.

0xc8c939539efb7f5ba903fc99b61656979c46c045

transaction_hash

Transaction hash.

0x5a9e11432e5c7e2fccf598606858619cbd72f1de40db625fc4749ec1b032e144

transaction_type

gas_buy

transaction_index

The index of the transaction.

0

ordinal

Generated number that gives the order of each balance impact, for one file. Based on call index and log indexes.

2

sender_address

The address that sends tokens or coins.

0xc8c939539efb7f5ba903fc99b61656979c46c045

receiver_address

The address that receives tokens or coins.

0x5a0b54d5dc17e0aadc383d2db43b0a0d3e029c4c

initiator_address

The address that signed the transaction.

0xc8c939539efb7f5ba903fc99b61656979c46c045

token_symbol

Symbol of the token or coin transfered

ETH

token_address

The address of the token or coin transfered.

0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

0.16

amount_usd

Amount of asset transferred in usd.

23.863262042004745

balance_after

Wallet balance for the user_address for this asset.

0.4814735188

balance_after_usd

Wallet balance for the user_address for this asset in usd.

71.80955465881561

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=ethereum"

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

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

# ---- 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": "ethereum",
            "block_number": 21264197,
            "timestamp": 1732530743000000000,
            "user_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "transaction_hash": "0x4ae1bc32d34a7b66fd23c6527a46cf9bb3158452044eea43762e351aa2fdabca",
            "transaction_type": "coin_transfer",
            "transaction_index": 188,
            "ordinal": 0,
            "sender_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "receiver_address": "0x90cdc2572f170178ac5027af0dcf141870a962e3",
            "initiator_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "token_symbol": "ETH",
            "token_address": "0",
            "direction": "out",
            "amount": 0.00237201,
            "amount_usd": 8.217764039189689,
            "balance_after": 6966.056486974737,
            "balance_after_usd": 24133712.966482032
        },
        /* ... */
    ],
    "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

reward_mine_uncle

Uncle block rewards are awarded to miners who generate an uncle block that gets included in a valid block added to the chain. These uncle blocks are analogous to stale blocks in Bitcoin. However, rather than being disregarded, uncle blocks receive rewards dependent on their novelty.

reward_mine_block

Rewards granted to the miner who mines the current block.

dao_refund_contract

This is related to the execution of the DAO hard-fork, an event that occurred as a response to the notorious DAO hack in 2016. This hard-fork moved all the Ether initially stored in The DAO (and its child DAOs) to a refund contract. From this contract, original DAO token holders could claim their proportional share of the funds.

dao_adjust_balance

Refers to any adjustment made to an account’s balance in relation to DAO-related hard-fork or operations.

coin_transfer

A coin transfer operation.

genesis_balance

Refers to the balance attributed to addresses during the genesis block.

gas_buy

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

reward_transaction_fee

Reward earned by the miner for including the transaction in the block.

reward_fee_reset

gas_refund

The process of refunding gas to the initiator when the state store is cleared.

touch_account

Refers to the process of interacting with an account in some way, such as updating its nonce.

suicide_refund

The process of refunding gas to a contract owner when the SELFDESTRUCT operation is called, as it clears the store.

suicide_withdraw

This action allows the withdrawal of the remaining coin (ex: ETH) in a self-destructed account to a specific address.

call_balance_override

This operation overrides the default balance of an account.

burn

Burning coins in chains where this process occurs.

withdrawal

Allows the withdrawal of rewards or stake for validators.

token_transfer

This operation involves the transfer of (ERC20) tokens.

wrap_coin

This operation mints WETH tokens after a coin (ex: ETH) deposit.

unwrap_coin

This operation burns WETH tokens before a coin (ex: ETH) withdrawal.

token_deposit

This operation allows the deposit of (ERC20) tokens into staking contracts or escrow.

token_withdrawal

This operation allows the withdrawal of (ERC20) tokens from the staking contracts or escrow.

unknown

Unknown balance_change reason, only happens for the chain’s coin.

Bitcoin Wallets

What are these endpoint for?

These endpoints offers in-depth insights into BTC wallets including transactions, transfers and wallet balances over time.

Balances

What is this endpoint for?

This endpoint offers in-depth insights into Bitcoin wallets including transfers and wallet balances over time.

Endpoint

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

Parameters

Parameter

Required

Description

Example

blockchain

Always bitcoin.

bitcoin

sort

The sorting order for the results.

asc or desc

page_size

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

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

The transaction hash to filter on.

5ae688ab08139338e3024e150339ffa94c9d2ba23f38d0838025a41dc2fac3e6

user_address

The address to filter on.

bc1qm8ktha9m745u2gh54kprk72eu9t6n5xa2adckn

Fields

Field

Description

Example

blockchain

Blockchain name.

bitcoin

block_number

The height of the block.

871899

timestamp

The timestamp of the block.

1732536300000000000

address

The address on which the row is focused.

bc1qhyar38j6catjs8y30naptzrs8jhgudhzcv8s98

transaction_hash

Transaction hash.

e84b146c3f26545b525772a38425513f36a1738bfbb49a474aefe14a8c6d7903

transaction_id

Transaction ID.

334480d40ca84435bf440da99e9454cca25d06163996cd9a6ba4b517b9da1608

transaction_type

witness_v0_keyhash

transaction_index

The index of the transaction.

4695

internal_transaction_index

1

token_symbol

Symbol of the token or coin transfered

BTC

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

0.0022931

amount_usd

Amount of asset transferred in usd.

225.6601111753002

balance_after

Wallet balance for the user_address for this asset.

0

balance_after_usd

Wallet balance for the user_address for this asset in usd.

0

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=bitcoin"

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

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

# ---- Optional parameters ---- #
start_time = "2022-05-01T00:00:00.000Z"
end_time = "2022-30-01T00:00:00.000Z"
page_size = 100
sort = "desc"
transaction_hash = None
user_address = "1FfmbHfnpaZjKFvyi1okTjJJusN455paPH"

# ---- 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):
    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
    }

    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)
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": 1732536300000,
    "access":
    {
        "access_range":
        {
            "start_timestamp": 1073001600000,
            "end_timestamp": "None"
        },
        "data_range":
        {
            "start_timestamp": "None",
            "end_timestamp": "None"
        }
    },
    "data":
    [
        {
            "blockchain": "bitcoin",
            "block_number": 871899,
            "timestamp": 1732536300000000000,
            "address": "bc1qt42fgv262u3d2qvpmwecpxdwfmxpjug6mxn532",
            "transaction_hash": "e84b146c3f26545b525772a38425513f36a1738bfbb49a474aefe14a8c6d7903",
            "transaction_id": "334480d40ca84435bf440da99e9454cca25d06163996cd9a6ba4b517b9da1608",
            "transaction_type": "witness_v0_keyhash",
            "transaction_index": 4695,
            "internal_transaction_index": 0,
            "token_symbol": "BTC",
            "direction": "in",
            "amount": 0.00228863,
            "amount_usd": 225.22022599935772,
            "balance_after": 1.06076911,
            "balance_after_usd": 104388.50259209116
        },
        /* ... */
    ],
    "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

minerReward

multisig

pubkey

pubkeyhash

scripthash

witness_unknown

witness_v0_keyhash

witness_v0_scripthash

witness_v1_taproot

nulldata

nonstandard

Transaction

What is this endpoint for?

This endpoint offers in-depth insights into Bitcoin wallets at the transaction level over time.

Endpoint

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

Parameters

Parameter

Required

Description

Example

blockchain

Always bitcoin.

bitcoin

sort

The sorting order for the results.

asc or desc

page_size

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

100

start_block

Starting block height (inclusive).

600000

end_block

Ending block height (inclusive).

700000

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

The specific transaction hash to query.

f6932e70e4c5483d7b1fa2ee7c56ad89207221bbf186ad0a15cd0cc4e18906f5

Fields

Field

Description

Example

chain

Blockchain name.

bitcoin

block_number

The height of the block.

395211

timestamp

The timestamp of the block.

1453853136

transaction_hash

Transaction hash.

94ad60ff0ef4cd0f31cab884adc6c39720273e9468ac0019a339911f0dd26e76

transaction_id

Transaction ID.

f6932e70e4c5483d7b1fa2ee7c56ad89207221bbf186ad0a15cd0cc4e18906f5

transaction_index

The index of the transaction.

0

sender_addresses

The addresses that sends the coin.

[1A8MMLhpGEyNqEsqzkReXtmBx9LBQgt8Mh]

receiver_addresses

The addresses that receives the coin.

[19Ntq9wC9i39284EZVVf4R7DbCz7gThxzs,12eKGe5hLdKBe8mQ7dv8NixEcX96XHBkoZ]

token_symbol

Symbol of the coin transfered

BTC

amount_out

Amount of asset transfered.

10.12592654

fees

Fees paid for the transaction.

0.0004

amount_out_usd

Amount of asset transferred in usd.

3965.771819253574

fees_usd

Fees paid for the transaction in usd.

0.15665813112855445

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/transactions?blockchain=bitcoin"

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

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

# ---- Optional parameters ---- #
start_block = 600000
end_block = 600001
start_time = None
end_time = None
page_size = 100
sort = "desc"
transaction_hash = 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_block: int, end_block: int, start_time: str, end_time: str, page_size: int, sort: str, transaction_hash: str):
    headers = {'Accept': 'application/json', 'X-Api-Key': api_key}
    
    url = f'https://us.market-api.kaiko.io/v2/data/wallet.v1/transactions'
    params = {
        "blockchain": blockchain,
        "start_block": start_block,
        "end_block": end_block,
        "start_time": start_time,
        "end_time": end_time,
        "page_size": page_size,
        "sort": sort,
        "transaction_hash": transaction_hash
    }

    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_block=start_block, end_block=end_block, start_time=start_time, end_time=end_time, page_size=page_size, sort=sort, transaction_hash=transaction_hash)
print (df)

Response example

{
    "query":
    {
        "live": "False",
        "start_time": "2009-01-01T00:00:00.000Z",
        "end_time": "2009-01-01T00:00:00.000Z",
        "start_block": 0,
        "end_block": 0,
        "page_size": 1000,
        "sort": "ASCENDING",
        "data_version": "v1",
        "commodity": "wallet_data",
        "request_time": "2009-01-01T00:00:00.000Z"
    },
    "time": "2009-01-01T00:00:00.000Z",
    "timestamp": 1704069091000,
    "access":
    {
        "access_range":
        {
            "start_timestamp": 1073001600000,
            "end_timestamp": "None"
        },
        "data_range":
        {
            "start_timestamp": "None",
            "end_timestamp": "None"
        }
    },
    "data":
    [
        {
            "chain": "bitcoin",
            "block_number": 823787,
            "timestamp": 1704069091000000000,
            "transaction_hash": "e651241e9982332ea4cf59923d8cbc7468e1960bb5ab9f68d9e72984830c530c",
            "transaction_id": "e651241e9982332ea4cf59923d8cbc7468e1960bb5ab9f68d9e72984830c530c",
            "transaction_index": 15,
            "sender_addresses":
            [
                "1n8gms991ydy1e696e9sb9esyy5cksu7hz"
            ],
            "receiver_addresses":
            [
                "1n8gms991ydy1e696e9sb9esyy5cksu7hz",
                "3juadjkqtgzr9p9n59rtugv5pl2tohf6t9",
                "bc1q5g4w7sajpqvd0syvghsqvrxcf2ysxce0yxqjkx"
            ],
            "token_symbol": "BTC",
            "amount_out": 0.37257751,
            "fees": 0.0014,
            "amount_out_usd": 15729.55,
            "fees_usd": 59.1
        },
        /* ... */
    ],
    "continuation_token": "xxx",
    "next_url": "https://us.market-api.kaiko.io/v2/data/wallet.v1/transactions?continuation_token=xxx"
    }
}

Balances

What is this endpoint for?

This endpoint offers in-depth insights into Bitcoin wallets including transfers and wallet balances over time.

Endpoint

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

Parameters

Parameter

Required

Description

Example

blockchain

Always bitcoin.

bitcoin

sort

The sorting order for the results.

asc or desc

page_size

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

See

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

The transaction hash to filter on.

5ae688ab08139338e3024e150339ffa94c9d2ba23f38d0838025a41dc2fac3e6

user_address

The address to filter on.

bc1qm8ktha9m745u2gh54kprk72eu9t6n5xa2adckn

Fields

Field

Description

Example

blockchain

Blockchain name.

bitcoin

block_number

The height of the block.

871899

timestamp

The timestamp of the block.

1732536300000000000

address

The address on which the row is focused.

bc1qhyar38j6catjs8y30naptzrs8jhgudhzcv8s98

transaction_hash

Transaction hash.

e84b146c3f26545b525772a38425513f36a1738bfbb49a474aefe14a8c6d7903

transaction_id

Transaction ID.

334480d40ca84435bf440da99e9454cca25d06163996cd9a6ba4b517b9da1608

transaction_type

Transaction type. See information .

witness_v0_keyhash

transaction_index

The index of the transaction.

4695

internal_transaction_index

1

token_symbol

Symbol of the token or coin transfered

BTC

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

0.0022931

amount_usd

Amount of asset transferred in usd.

225.6601111753002

balance_after

Wallet balance for the user_address for this asset.

0

balance_after_usd

Wallet balance for the user_address for this asset in usd.

0

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=bitcoin"

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

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

# ---- Optional parameters ---- #
start_time = "2022-05-01T00:00:00.000Z"
end_time = "2022-30-01T00:00:00.000Z"
page_size = 100
sort = "desc"
transaction_hash = None
user_address = "1FfmbHfnpaZjKFvyi1okTjJJusN455paPH"

# ---- 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):
    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
    }

    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)
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": 1732536300000,
    "access":
    {
        "access_range":
        {
            "start_timestamp": 1073001600000,
            "end_timestamp": "None"
        },
        "data_range":
        {
            "start_timestamp": "None",
            "end_timestamp": "None"
        }
    },
    "data":
    [
        {
            "blockchain": "bitcoin",
            "block_number": 871899,
            "timestamp": 1732536300000000000,
            "address": "bc1qt42fgv262u3d2qvpmwecpxdwfmxpjug6mxn532",
            "transaction_hash": "e84b146c3f26545b525772a38425513f36a1738bfbb49a474aefe14a8c6d7903",
            "transaction_id": "334480d40ca84435bf440da99e9454cca25d06163996cd9a6ba4b517b9da1608",
            "transaction_type": "witness_v0_keyhash",
            "transaction_index": 4695,
            "internal_transaction_index": 0,
            "token_symbol": "BTC",
            "direction": "in",
            "amount": 0.00228863,
            "amount_usd": 225.22022599935772,
            "balance_after": 1.06076911,
            "balance_after_usd": 104388.50259209116
        },
        /* ... */
    ],
    "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

minerReward

multisig

pubkey

pubkeyhash

scripthash

witness_unknown

witness_v0_keyhash

witness_v0_scripthash

witness_v1_taproot

nulldata

nonstandard

Transaction

What is this endpoint for?

This endpoint offers in-depth insights into Bitcoin wallets at the transaction level over time.

Endpoint

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

Parameters

Parameter

Required

Description

Example

blockchain

Always bitcoin.

bitcoin

sort

The sorting order for the results.

asc or desc

page_size

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

See

100

start_block

Starting block height (inclusive).

600000

end_block

Ending block height (inclusive).

700000

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

The specific transaction hash to query.

f6932e70e4c5483d7b1fa2ee7c56ad89207221bbf186ad0a15cd0cc4e18906f5

Fields

Field

Description

Example

chain

Blockchain name.

bitcoin

block_number

The height of the block.

395211

timestamp

The timestamp of the block.

1453853136

transaction_hash

Transaction hash.

94ad60ff0ef4cd0f31cab884adc6c39720273e9468ac0019a339911f0dd26e76

transaction_id

Transaction ID.

f6932e70e4c5483d7b1fa2ee7c56ad89207221bbf186ad0a15cd0cc4e18906f5

transaction_index

The index of the transaction.

0

sender_addresses

The addresses that sends the coin.

[1A8MMLhpGEyNqEsqzkReXtmBx9LBQgt8Mh]

receiver_addresses

The addresses that receives the coin.

[19Ntq9wC9i39284EZVVf4R7DbCz7gThxzs,12eKGe5hLdKBe8mQ7dv8NixEcX96XHBkoZ]

token_symbol

Symbol of the coin transfered

BTC

amount_out

Amount of asset transfered.

10.12592654

fees

Fees paid for the transaction.

0.0004

amount_out_usd

Amount of asset transferred in usd.

3965.771819253574

fees_usd

Fees paid for the transaction in usd.

0.15665813112855445

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/transactions?blockchain=bitcoin"

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

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

# ---- Optional parameters ---- #
start_block = 600000
end_block = 600001
start_time = None
end_time = None
page_size = 100
sort = "desc"
transaction_hash = 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_block: int, end_block: int, start_time: str, end_time: str, page_size: int, sort: str, transaction_hash: str):
    headers = {'Accept': 'application/json', 'X-Api-Key': api_key}
    
    url = f'https://us.market-api.kaiko.io/v2/data/wallet.v1/transactions'
    params = {
        "blockchain": blockchain,
        "start_block": start_block,
        "end_block": end_block,
        "start_time": start_time,
        "end_time": end_time,
        "page_size": page_size,
        "sort": sort,
        "transaction_hash": transaction_hash
    }

    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_block=start_block, end_block=end_block, start_time=start_time, end_time=end_time, page_size=page_size, sort=sort, transaction_hash=transaction_hash)
print (df)

Response example

{
    "query":
    {
        "live": "False",
        "start_time": "2009-01-01T00:00:00.000Z",
        "end_time": "2009-01-01T00:00:00.000Z",
        "start_block": 0,
        "end_block": 0,
        "page_size": 1000,
        "sort": "ASCENDING",
        "data_version": "v1",
        "commodity": "wallet_data",
        "request_time": "2009-01-01T00:00:00.000Z"
    },
    "time": "2009-01-01T00:00:00.000Z",
    "timestamp": 1704069091000,
    "access":
    {
        "access_range":
        {
            "start_timestamp": 1073001600000,
            "end_timestamp": "None"
        },
        "data_range":
        {
            "start_timestamp": "None",
            "end_timestamp": "None"
        }
    },
    "data":
    [
        {
            "chain": "bitcoin",
            "block_number": 823787,
            "timestamp": 1704069091000000000,
            "transaction_hash": "e651241e9982332ea4cf59923d8cbc7468e1960bb5ab9f68d9e72984830c530c",
            "transaction_id": "e651241e9982332ea4cf59923d8cbc7468e1960bb5ab9f68d9e72984830c530c",
            "transaction_index": 15,
            "sender_addresses":
            [
                "1n8gms991ydy1e696e9sb9esyy5cksu7hz"
            ],
            "receiver_addresses":
            [
                "1n8gms991ydy1e696e9sb9esyy5cksu7hz",
                "3juadjkqtgzr9p9n59rtugv5pl2tohf6t9",
                "bc1q5g4w7sajpqvd0syvghsqvrxcf2ysxce0yxqjkx"
            ],
            "token_symbol": "BTC",
            "amount_out": 0.37257751,
            "fees": 0.0014,
            "amount_out_usd": 15729.55,
            "fees_usd": 59.1
        },
        /* ... */
    ],
    "continuation_token": "xxx",
    "next_url": "https://us.market-api.kaiko.io/v2/data/wallet.v1/transactions?continuation_token=xxx"
    }
}

Balances and transactions

Endpoint

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

Parameters

Parameter

Description

Example

Required?

blockchain

Always ethereum.

ethereum

sort

The sorting order for the results.

asc or desc

page_size

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

See

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

The transaction hash to filter on.

0xf7825247b9a9355c0fb45ec0d008fe638ce5bae9cb877c6a28a91d9ea5f17341

user_address

The address to filter on.

0x000000fee13a103a10d593b9ae06b3e05f2e7e1c

token_address

The token address to filter on.

0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2

Fields

Field

Description

Example

chain

Blockchain name.

ethereum

block_number

The height of the block.

7005997

timestamp

The timestamp of the block.

1546560004

user_address

The address on which the row is focused.

0xc8c939539efb7f5ba903fc99b61656979c46c045

transaction_hash

Transaction hash.

0x5a9e11432e5c7e2fccf598606858619cbd72f1de40db625fc4749ec1b032e144

transaction_type

Event type. See more information .

gas_buy

transaction_index

The index of the transaction.

0

ordinal

Generated number that gives the order of each balance impact, for one file. Based on call index and log indexes.

2

sender_address

The address that sends tokens or coins.

0xc8c939539efb7f5ba903fc99b61656979c46c045

receiver_address

The address that receives tokens or coins.

0x5a0b54d5dc17e0aadc383d2db43b0a0d3e029c4c

initiator_address

The address that signed the transaction.

0xc8c939539efb7f5ba903fc99b61656979c46c045

token_symbol

Symbol of the token or coin transfered

ETH

token_address

The address of the token or coin transfered.

0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

0.16

amount_usd

Amount of asset transferred in usd.

23.863262042004745

balance_after

Wallet balance for the user_address for this asset.

0.4814735188

balance_after_usd

Wallet balance for the user_address for this asset in usd.

71.80955465881561

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=ethereum"

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

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

# ---- 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": "ethereum",
            "block_number": 21264197,
            "timestamp": 1732530743000000000,
            "user_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "transaction_hash": "0x4ae1bc32d34a7b66fd23c6527a46cf9bb3158452044eea43762e351aa2fdabca",
            "transaction_type": "coin_transfer",
            "transaction_index": 188,
            "ordinal": 0,
            "sender_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "receiver_address": "0x90cdc2572f170178ac5027af0dcf141870a962e3",
            "initiator_address": "0xd2674da94285660c9b2353131bef2d8211369a4b",
            "token_symbol": "ETH",
            "token_address": "0",
            "direction": "out",
            "amount": 0.00237201,
            "amount_usd": 8.217764039189689,
            "balance_after": 6966.056486974737,
            "balance_after_usd": 24133712.966482032
        },
        /* ... */
    ],
    "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

reward_mine_uncle

reward_mine_block

Rewards granted to the miner who mines the current block.

dao_refund_contract

dao_adjust_balance

Refers to any adjustment made to an account’s balance in relation to DAO-related hard-fork or operations.

coin_transfer

A coin transfer operation.

genesis_balance

Refers to the balance attributed to addresses during the genesis block.

gas_buy

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

reward_transaction_fee

Reward earned by the miner for including the transaction in the block.

reward_fee_reset

gas_refund

The process of refunding gas to the initiator when the state store is cleared.

touch_account

Refers to the process of interacting with an account in some way, such as updating its nonce.

suicide_refund

The process of refunding gas to a contract owner when the SELFDESTRUCT operation is called, as it clears the store.

suicide_withdraw

This action allows the withdrawal of the remaining coin (ex: ETH) in a self-destructed account to a specific address.

call_balance_override

This operation overrides the default balance of an account.

burn

Burning coins in chains where this process occurs.

withdrawal

Allows the withdrawal of rewards or stake for validators.

token_transfer

This operation involves the transfer of (ERC20) tokens.

wrap_coin

This operation mints WETH tokens after a coin (ex: ETH) deposit.

unwrap_coin

This operation burns WETH tokens before a coin (ex: ETH) withdrawal.

token_deposit

This operation allows the deposit of (ERC20) tokens into staking contracts or escrow.

token_withdrawal

This operation allows the withdrawal of (ERC20) tokens from the staking contracts or escrow.

unknown

Unknown balance_change reason, only happens for the chain’s coin.

Kaiko Blockchain Monitoring

Ethereum Wallets

What is this endpoint for?

Balances and transactions

Endpoint

Parameters

Fields

Request example

Response example

Possible values for the field transaction_type:

Bitcoin Wallets

What are these endpoint for?

Balances

What is this endpoint for?

Endpoint

Parameters

Fields

Request example

Response example

Possible values for the field transaction_type:

Transaction

What is this endpoint for?

Endpoint

Parameters

Fields

Request example

Response example

Kaiko Blockchain Monitoring

Bitcoin Wallets

What are these endpoint for?

Ethereum Wallets

What is this endpoint for?

Balances

What is this endpoint for?

Endpoint

Parameters

Fields

Request example

Response example

Possible values for the field transaction_type:

Transaction

What is this endpoint for?

Endpoint

Parameters

Fields

Request example

Response example

Balances and transactions

Endpoint

Parameters

Fields

Request example

Response example

Possible values for the field transaction_type:

Possible values for the field `transaction_type`:

Possible values for the field `transaction_type`:

Possible values for the field `transaction_type`:

Possible values for the field `transaction_type`: