Trades

Our dataset endpoints is built for data warehouse syncs or data science applications. Datasets are chunked in date ranges for ease of access. We respect the semantics of each chain VM, and therefore for the EVM-based chains we have a single unified schema but for rest of the chains we have schemas that are native to that chain.

Unified EVM Schema

Field	Format	Explanation
transaction_hash	string	Transaction hash
buyer	string	Buyer address
seller	string	Seller address
collection_address	string	Collection address
collection_name	string	Collection name
collection_slug	string	Collection unique slug (Zash).
token_id	string	Token ID
price	decimal	Transaction amount paid by the buyer
currency	enum	Symbol of currency
marketplace_address	string	Marketplace address
marketplace_name	string	Unique marketplace name
aggregator_address	string	Aggregator address
aggregator_name	string	Unique aggregator name
block_hash	string	Block hash of trade
block_number	string	Block number of trade
is_mint	boolean	Is mint or not
is_bundle	boolean	Is bundle trade or not
timestamp	bigint	Block timestamp
created_at	string	UTC time ISO 8601 format.
date	string	Date string
hour	integer	Hour

An example record from the dataset:

{
  "transaction_hash": "0x89d9c6bf3f57542cdd9eb48757617b0e970b10ae21203f4883c7a45022242ea8",
  "buyer": "0x315014d50459d218d3294a888897ca12b6ce694b",
  "seller": "0xad94a2a273ca6da2641e00fc76e2f1d63f4ad4bd",
  "collection_address": "0x3903d4ffaaa700b62578a66e7a67ba4cb67787f9",
  "collection_name": "Quirkies Originals",
  "collection_slug": "quirkiesoriginals",
  "token_id": "4938",
  "price": 1.76475,
  "currency": "WETH",
  "marketplace_address": "0x00000000006c3852cbef3e08e8df289169ede581",
  "marketplace_name": "opensea",
  "aggregator_address": "0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2",
  "aggregator_name": "gem",
  "block_hash": "0x3e5e74061a3ea62ac8daa8cf52a4dd2f91bd9fdf495182f857f08adb04d5eebe",
  "block_number": 16106952,
  "is_mint": false,
  "is_bundle": true,
  "timestamp": 1670102687,
  "created_at": "2022-12-03 21:24:47",
  "date": "2022-12-03",
  "hour": 21
}

Solana Schema

Field	Format	Explanation
signature	string	Signature of transaction
buyer	string	Buyer address
seller	string	Seller address
collection_id	string	Collection address
collection_name	string	Collection name
mint	string	Mint address of the token
price	decimal	Transaction amount paid by the buyer
marketplace	string	Unique marketplace name
aggregator	string	Unique aggregator name
slot	integer	Slot number
parent_slot	integer	Parent slot number
block_height	integer	Block height
blockhash	string	Block hash
previous_blockhash	string	Previous block hash
sale_type	string	Enum type of sale. E.g. mint
timestamp	bigint	Block timestamp
created_at	string	UTC time ISO 8601 format.
date	string	Date string
hour	integer	Hour

An example record from the schema:

{
  "signature": "3GZaBSWJmBfqm4uoZjdQLZWfzdoWDanCemrqj2d18AnateqKNKuLofFXkmN8VCKtnRkPtPdjoa6uBvKDXdZ3TuRX",
  "seller": "9rNymediZZRD4VqCFxgtM3PqBY2sBd9Y3QmKt6Yf5kdX",
  "buyer": "J5PtbdS8RYvj8mm68pEPFDu22HLkwHoSa3GiSPsNfNgd",
  "price": 1.09,
  "collection": "CZ6go85CYaU3g1pcPtXRH4cH5JGjoBFvCUausVVqvwsZ",
  "collection_id": "CZ6go85CYaU3g1pcPtXRH4cH5JGjoBFvCUausVVqvwsZ",
  "collection_name": "Exomon",
  "sale_type": "secondary",
  "marketplace": "MagicEdenV2",
  "aggregator": "",
  "block_height": 149026742,
  "block_time": 1670054182,
  "blockhash": "DDvzQCsTXZAey8gb43qj33z15XdnMiBf1AALVXDe5A7w",
  "created_at": "2022-12-03 07:59:18.000",
  "mint": "9287pRWNMcNmD2DRtv5fAVKKWmxQrEsG4CFvCLY9oA3u",
  "parent_slot": 164626486,
  "parser": "MagicEdenV2",
  "previous_blockhash": "F2TJy69rBGEg6t45V1fkmrYiTai1vKYyr48xJgwaNYeY",
  "date": "2022-12-03",
  "hour": 7,
  "slot": 164626487
}