Blockhouse
    • Home
    • Quickstart
    • Tutorial Videos
      • SDK Walkthrough
      • Algorithm Products Walkthrough
      • Connecting with Lime
      • Connecting with Interactive Brokers
  • Core Product
    • Platform Architecture Overview
    • How to Send Your Data
    • Visualizing Trade Insights: Pre & Post-Trade Dashboards
    • Analyzing Trades with TCA Reports
    • Smart Order Routing & Execution Algorithms
  • Asset Classes
    • Fixed Income
      • Data Schemas & Execution Formats
      • Standards and Conventions
      • Venues and Datasets
    • Equities
      • Data Schemas & Execution Formats
      • Standards and Conventions
      • Venues and Datasets
    • Crypto
      • Data Schemas & Execution Formats
      • Standards and Conventions
      • Venues and Datasets
  • API Reference
    • Execution API
      • Introduction & Installation
      • Managing Orders
      • Full SDK Example & Notes
  • FIX API
    • About FIX API
Powered by GitBook
On this page
  1. Asset Classes
  2. Crypto

Data Schemas & Execution Formats

Historical Trade Data Schema Historical trade data contains information about executed trades over a given period. Each trade is uniquely identified and includes details about execution, pricing, and fees.

Field

Type

Description

id

INT

A unique identifier assigned to each trade.

order

STRING

The order ID associated with the trade, if available.

info

STRING

Additional details about the trade, stored in raw format.

timestamp

FLOAT

Unix epoch timestamp indicating when the trade occurred.

datetime

TIMESTAMP

The execution date and time of the trade in UTC.

symbol

STRING

The trading pair (e.g., BTC/USD, ETH/USD).

type

STRING

The order type (e.g., market, limit, stop-limit).

side

STRING

The trade direction, either "buy" or "sell."

takerOrMaker

STRING

Specifies whether the trade was executed as a taker or a maker.

price

FLOAT

The price at which the trade was executed.

amount

FLOAT

The quantity of the asset traded.

cost

FLOAT

The total cost of the trade (price * amount).

fee

STRING

The trade fee details, including cost and currency.

fees

STRING

Any additional fee details if applicable.

Batch Trade Data Schema Batch trade data follows the same structure as historical trade data but is collected in batches at specific intervals instead of continuously.

Field

Type

Description

id

INT

A unique identifier assigned to each trade.

order

STRING

The order ID associated with the trade, if available.

info

STRING

Additional details about the trade, stored in raw format.

timestamp

FLOAT

Unix epoch timestamp indicating when the trade occurred.

datetime

TIMESTAMP

The execution date and time of the trade in UTC.

symbol

STRING

The trading pair (e.g., BTC/USD, ETH/USD).

type

STRING

The order type (e.g., market, limit, stop-limit).

side

STRING

The trade direction, either "buy" or "sell."

takerOrMaker

STRING

Specifies whether the trade was executed as a taker or a maker.

price

FLOAT

The price at which the trade was executed.

amount

FLOAT

The quantity of the asset traded.

cost

FLOAT

The total cost of the trade (price * amount).

fee

STRING

The trade fee details, including cost and currency.

fees

STRING

Any additional fee details if applicable.

Market Data Schema Market data captures real-time information about trade orders, bids, asks, and overall market movements.

Field

Type

Description

timestamp_ny

STRING

Timestamp of the order event in New York time.

side

STRING

The order side: "Bid" (buy) or "Ask" (sell).

price

FLOAT

The current market price of the asset.

size

INT

The number of units in the order.

symbol

STRING

The trading pair (e.g., BTC/USD).

action

STRING

The type of order action (e.g., add, modify, cancel).

order_type

STRING

Defines the type of order (e.g., market, limit, stop-limit).

Data Schema

DEX Transaction Data

Description

DEX transaction data captures all relevant on-chain swaps, trades, and liquidity interactions on decentralized exchanges. Each transaction record provides details about executed swaps, liquidity additions, removals, and associated metadata.

Fields (dex_transaction_data)

Field

Type

Description

tx_hash

string

Unique transaction identifier.

block_number

int64

Block where the transaction was confirmed.

timestamp

int64

Unix timestamp for transaction execution.

address

string

DEX contract or liquidity pool address.

from

string

Sender wallet address.

to

string

Recipient contract address.

token0

object

First token in the swap (symbol, address).

token1

object

Second token in the swap (symbol, address).

amount0In

float64

Amount of token0 input.

amount1In

float64

Amount of token1 input.

amount0Out

float64

Amount of token0 output.

amount1Out

float64

Amount of token1 output.

pool

string

Liquidity pool identifier.

fee

float64

Transaction fee.

price_impact

float64

Calculated price impact percentage.

method_id

string

Function signature for the transaction.

success

boolean

Whether the transaction was successful.

DEX Market Data

Description

DEX market data provides real-time and historical insights into decentralized liquidity pools, token reserves, exchange rates, and trading activity.

Fields (dex_market_data)

Field

Type

Description

timestamp

string

Timestamp of the market snapshot.

pool_address

string

Address of the liquidity pool.

token0_reserve

float64

Reserve amount for first token.

token1_reserve

float64

Reserve amount for second token.

liquidity

float64

Total pool liquidity value.

fee_tier

int

Fee percentage tier (e.g., 0.3%, 1%).

price

float64

Current exchange rate between tokens.

volume_24h

float64

Trading volume in the last 24 hours.

tvl

float64

Total value locked in the pool.

apr

float64

Annual percentage rate for liquidity providers.

active_tick

int

Current tick index (for V3 pools).

tick_spacing

int

Distance between ticks.

PreviousCryptoNextStandards and Conventions

Last updated 2 months ago