quix_v1_optimism

Tables

ExchangeV2_BuyOrderFilled_event

NFT (ERC-721) buy order fulfillment events from Quix marketplace on Optimism, recording buyer, seller, token ID, and price for each completed purchase. Used for analyzing Quix marketplace trading volumes, NFT collection liquidity, and price discovery.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc721address`	`STRING`	Contract address of the ERC-721 NFT collection being traded in this buy order. Hex-encoded, 0x-prefixed 40-character string on Optimism.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.

Sample Data

address	removed	in_buyer	in_price	in_seller	log_index	in_tokenId	block_number	block_timestamp	in_erc721address	transaction_hash
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0x766920baefab30d4115a400c08e0726f507f07a1	160000000000000000	0xa0f2521364c98a4a2a12f396cd5b680665834fab	5	5684	6912197	2022-05-02T08:14:36.000Z	0xb8df6cc3050cc02f967db1ee48330ba23276a492	0xb2562c7ce5d4ec67f668dc202894b87ccba1b6572f0b6441f74423ed09776615
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0x766920baefab30d4115a400c08e0726f507f07a1	125000000000000000	0xe92a0a5c8fef3be8722c0eb0d29a53ee505b95dd	5	9897	6915240	2022-05-02T09:25:26.000Z	0xb8df6cc3050cc02f967db1ee48330ba23276a492	0x1f2b5ac0c112fd23c9c5c62fca1f6b6806d5f3e93d32bf8ba8b3466e6ddfb4ef
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0xdcf9be598bebb59cacaacf93bd919b812089c825	79000000000000000	0xac98d36783266bc4fbae14751c69aff811406932	5	9052	6911872	2022-05-02T08:07:25.000Z	0xb8df6cc3050cc02f967db1ee48330ba23276a492	0xe70fcb861cd02785677b9f15fb3258a71a25b3e370436830cac60b340e1d10f5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quix_v1_optimism.ExchangeV2_BuyOrderFilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ExchangeV2_DutchAuctionFilled_event

Dutch auction completion events from Quix NFT marketplace on Optimism, recording final sale price, buyer, seller, and ERC-721 token details for completed descending-price auctions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc721address`	`STRING`	Contract address of the ERC-721 NFT collection being auctioned on the Quix marketplace. Hex-encoded, 0x-prefixed 40-character string on Optimism.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.

Sample Data

address	removed	in_buyer	in_price	in_seller	log_index	in_tokenId	block_number	block_timestamp	in_erc721address	transaction_hash
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0x4e62ec86f6ce66aee778635c968f46e1fd01f821	27030000000000000	0x6fcec5d08f585fba9e08d188031b5b97730908c3	2	152	6073855	2022-04-20T10:30:40.000Z	0x52782699900df91b58ecd618e77847c5774dcd2e	0xa8eef86a704e98b2c2209152f3e0bdfc732caf94d50b5772456c17886501fc8b
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0xd351f42110782b176dcdf669689576e754da9c84	66725000000000000	0x222dac59a36daa8f3508ed24aacbf16d706312c6	2	6590	6230584	2022-04-22T11:31:45.000Z	0xb8df6cc3050cc02f967db1ee48330ba23276a492	0xd2c62872c592e18f710a8bdf92ce6405a87ec7edbd3434bef0f3ef1081b6db75
0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6	false	0xfc1a7a26ff9aa2b6b298f3658cc90ff89b62a072	141500000000000000	0x058ace5f0e29ba3fe5e0f391fce42d3fa2cbd979	0	4206	12503216	2022-06-20T20:37:19.000Z	0xb8df6cc3050cc02f967db1ee48330ba23276a492	0x25d1204a4e72fedd4106d914f56053424916d38fe129c225a49037da8b44f60c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quix_v1_optimism.ExchangeV2_DutchAuctionFilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ExchangeV2_SellOrderFilled_event

NFT (ERC-721) sale events from Quix marketplace on Optimism, capturing buyer, seller, token ID, collection address, and sale price in wei. Used for analyzing NFT trading volume, price discovery, and marketplace activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc721address`	`STRING`	Contract address of the ERC-721 NFT collection being traded in this sell order fulfillment event. Hex-encoded, 0x-prefixed 40-character string representing the NFT smart contract on Optimism.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.

Sample Data

address	removed	in_buyer	in_price	in_seller	log_index	in_tokenId	block_number	block_timestamp	in_erc721address	transaction_hash
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0x7ea4cc1ebeefc127ac1f216ca20159a3839d31a4	10000000000000000	0xeae03eb54eb26b38057544895e834af42fc46a69	2	1211	7619036	2022-05-10T09:17:30.000Z	0x006eb613cc586198003a119485594ecbbdf41230	0x53aa4ffe0f7340c9afd9cd4832053154773cc6d996ac7be0cf6fa10a5b5ebf4e
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0x1c1ce70ca6975cf60658fa55ae9358c8b295d062	48000000000000000	0x22e86ab483084053562ce713e94431c29d1adb8b	2	387399921507286253577	7652968	2022-05-10T14:53:10.000Z	0x0e55e1913c50e015e0f60386ff56a4bfb00d7110	0x082e35d26e064c6b658341fbe725d647c8775733dbf2a09258d6ef8d8da72977
0x20975da6eb930d592b9d78f451a9156db5e4c77b	false	0xadc24d7b630759a3af7f52716d91299c999a2213	9500000000000000	0xb8ca87b017906b4eac99d830ab42827d4046921f	2	2449	7625648	2022-05-10T10:20:59.000Z	0x2c7de36caf3a014d724de4f461343d68099093ea	0xa225f3567621e38985aee441b1c981c478bdef6bd946d5c2499efb2a263d1eaa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quix_v1_optimism.ExchangeV2_SellOrderFilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ExchangeV2_BuyOrderFilled_event

ExchangeV2_DutchAuctionFilled_event

ExchangeV2_SellOrderFilled_event

​Tables

​ExchangeV2_BuyOrderFilled_event

​ExchangeV2_DutchAuctionFilled_event

​ExchangeV2_SellOrderFilled_event

Tables

ExchangeV2_BuyOrderFilled_event

ExchangeV2_DutchAuctionFilled_event

ExchangeV2_SellOrderFilled_event