blur_v2_ethereum

Tables

BlurExchange_Execution_event

NFT (non-fungible token) trade execution events from Blur v2 marketplace on Ethereum, including sale prices, collection addresses, maker/taker fees, and trader addresses. Used for analyzing NFT trading volume, price discovery, and fee structures across collections.

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_transfer`	`STRUCT<trader STRING, id STRING, amount STRING, collection STRING, assetType INT64>`	NFT or token transfer details for the executed trade, including the asset collection address, token ID, trader address, and asset type. Always includes the collection and trader fields; amount field is typically ‘0’ for NFT (ERC-721) transfers.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_listingIndex`	`STRING`	Index position of the specific NFT listing within a batch order when multiple items are listed together. Typically ‘0’ for single-item orders or the first item in a batch.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_makerFee`	`STRUCT<recipient STRING, rate STRING>`	Fee details for the order maker, including the fee rate in basis points and the recipient address. The rate is typically 0 or 50 basis points (0.5%), with fees sent to collection-specific or zero addresses.
`in_fees`	`STRUCT<protocolFee STRUCT<recipient STRING, rate STRING>, takerFee STRUCT<recipient STRING, rate STRING>>`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.
`in_orderType`	`INT64`	Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.

Sample Data

address	in_fees	removed	in_price	log_index	in_makerFee	in_transfer	block_number	in_orderHash	block_timestamp	transaction_hash
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	{“takerFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”},“protocolFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”}}	false	59399000000000000	155	{“rate”:“50”,“recipient”:“0x7d11d1cf8a532d7594ffe5101aade8fb85f7a99f”}	{“id”:“46743599630544316520322898858516812728053568200370803953515432237130669095721”,“amount”:“0”,“trader”:“0x2cb284564c38b869cd001e9aff4f61f197db7b16”,“assetType”:0,“collection”:“0x6622fb129c4c96e8c25295fd3b32b6e67c971142”}	18117518	0x9e97f067c98a486ae561c837a3c20afe21fbcb4f981b05553a601e94266ea646	2023-09-12T03:16:23.000Z	0x91869a915f0f3157c0c5494ea5f0e4c3ccdbe1c49be0e58add5b80dc63ed6b34
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	{“takerFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”},“protocolFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”}}	false	59399000000000000	153	{“rate”:“50”,“recipient”:“0x7d11d1cf8a532d7594ffe5101aade8fb85f7a99f”}	{“id”:“112118417132375904336337863606606891715572749787730123232561652651271296010361”,“amount”:“0”,“trader”:“0x45ddb9963ca4df1cceb612a59cb916c8bde48929”,“assetType”:0,“collection”:“0x6622fb129c4c96e8c25295fd3b32b6e67c971142”}	18117518	0x7231b66eff18695eac0583a32f0de44418fe2774101fd6dc5e18eb897a9dd231	2023-09-12T03:16:23.000Z	0x91869a915f0f3157c0c5494ea5f0e4c3ccdbe1c49be0e58add5b80dc63ed6b34
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	{“takerFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”},“protocolFee”:{“rate”:“0”,“recipient”:“0x0000000000000000000000000000000000000000”}}	false	61732000000000000	154	{“rate”:“50”,“recipient”:“0x7d11d1cf8a532d7594ffe5101aade8fb85f7a99f”}	{“id”:“17435481054729917540239102205895065923063009312515632887426234879291482504725”,“amount”:“0”,“trader”:“0x45ddb9963ca4df1cceb612a59cb916c8bde48929”,“assetType”:0,“collection”:“0x6622fb129c4c96e8c25295fd3b32b6e67c971142”}	18117518	0xde375b72abc4108f85dd95ba608588d99ebf6e6f4dbea0f08a10b5c813e64b81	2023-09-12T03:16:23.000Z	0x91869a915f0f3157c0c5494ea5f0e4c3ccdbe1c49be0e58add5b80dc63ed6b34

Example Query

Query with partition filter

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

BlurExchange_Execution721MakerFeePacked_event

ERC-721 (NFT) trade execution events from Blur V2 marketplace on Ethereum with packed maker fee parameters. Records individual NFT sales with order hashes, collection identifiers, pricing, and maker fee recipient data encoded in packed integer format for gas optimization.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_tokenIdListingIndexTrader`	`STRING`	Packed parameter encoding the NFT token ID, listing index, and trader address for the ERC-721 execution event. This large integer combines multiple values to reduce gas costs in the Blur v2 exchange contract.
`in_collectionPriceSide`	`STRING`	Packed parameter encoding collection address, listing price, and order side (buy/sell) for the Blur v2 ERC-721 execution event. This large integer value must be unpacked to extract the individual components used in the NFT trade.
`in_makerFeeRecipientRate`	`STRING`	Packed integer encoding the maker’s fee recipient address and fee rate for ERC-721 trades on Blur v2. Large numeric value requires decoding to extract the individual recipient address and basis point fee rate components.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	transaction_hash	in_collectionPriceSide	in_makerFeeRecipientRate	in_tokenIdListingIndexTrader
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	184	18413906	0x383a27101c9f5b8380e3752c110171dea81bed6816505f68d63062cd18cadfe4	2023-10-23T15:37:23.000Z	0xfae70ead68c667ae0d626f59eb73e74df68f2e40727f415fb82d95aafc669ed1	11692013098647223711138545021124251645028308266896007471681432281	14652590235786915400431212384412379069791004547645	135442199153740038248903598192255431363901444730339142
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	185	18413906	0x383a27101c9f5b8380e3752c110171dea81bed6816505f68d63062cd18cadfe4	2023-10-23T15:37:23.000Z	0xfae70ead68c667ae0d626f59eb73e74df68f2e40727f415fb82d95aafc669ed1	11692013098647223711138545021124251645028308266896007471681432281	14652590235786915400431212384412379069791004547645	1417259517682995097174036399150235035168235361210154822
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	203	18412769	0xc5853cb401fc2062b19c6aa02d3affdaed1380ad5923b2af6fed31bfa4309819	2023-10-23T11:48:11.000Z	0x2d901c05a37a63a6783d825308190cc67094c17018a5bb06e53af945280ca869	314515152353610308678033103555656831951571268987850953233518912676	14777584918159937632221929497584107209083075809864	1180800033174318326332530321787898699909082961016504590

Example Query

Query with partition filter

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

BlurExchange_Execution721Packed_event

ERC-721 (NFT) trade execution events from Blur v2 marketplace on Ethereum, storing packed order data including token IDs, collection addresses, prices, and trader information. Used for analyzing NFT trading activity and order flow on Blur’s optimized exchange contract.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_tokenIdListingIndexTrader`	`STRING`	Packed composite field encoding the NFT token ID, listing index, and trader address for the executed ERC-721 trade on Blur v2. Large integer value that requires bit-shifting or decoding to extract individual components.
`in_collectionPriceSide`	`STRING`	Packed integer encoding containing NFT collection address, trade price, and order side (buy/sell) for the ERC-721 execution. This composite value must be decoded to extract individual trade parameters.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	transaction_hash	in_collectionPriceSide	in_tokenIdListingIndexTrader
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	152	17726537	0x5bc5c91b235645acd9697332d6fca6a44c1d59820e5c7039366ec47af7f0b065	2023-07-19T10:06:47.000Z	0x0a511dc16d7117f67ebfbcb1bff74bd5fad7d34e5dbcd23ed7ebb2708021718b	146150163733091605773189745552815488427867487454497482425178450	1470387886774316982791436707629665734705039277154969170
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	86	17726071	0xf806dca9f423deb1ad78db7da2b4ad3df22a98e941a4a12a11bbe213725d5ffd	2023-07-19T08:32:47.000Z	0x7e177091b53105185f69c5dd802a755211975a85c781aed22699dfb7287911e4	146150163733091605773189745552815488427867487454497482425178450	2140480541483986647176153388690750634085205724379293266
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	85	17726124	0x7a15213614984f021fdb94f72e3c1178418216c317f5a4631c736e04a12b215a	2023-07-19T08:43:35.000Z	0x9c496bc0d1efc360c965d43775eb9b869454c41bcbb80e190b25cb7909f1a3e6	146150163733091605773189745552815488427867487454497482425178450	961551476721189822789641796271164638581629802992445010

Example Query

Query with partition filter

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

BlurExchange_Execution721TakerFeePacked_event

NFT (ERC-721) trade execution events from Blur V2 marketplace on Ethereum, with packed encoding for token IDs, prices, and taker fee rates. Used for analyzing NFT sales volume, marketplace fees, and trading patterns across collections.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_tokenIdListingIndexTrader`	`STRING`	Packed data field encoding the NFT token ID, listing index, and trader address into a single large integer value. This compression technique is used by Blur to reduce gas costs by storing multiple parameters together.
`in_collectionPriceSide`	`STRING`	Packed data field containing the NFT collection address, order price, and side (buy/sell) encoded as a single large integer. This encoding reduces gas costs on Blur’s exchange contract by combining multiple order parameters into one storage slot.
`in_takerFeeRecipientRate`	`STRING`	Encoded value packing the taker fee recipient address and fee rate for this NFT execution on Blur v2. Represented as a large integer encoding multiple parameters into a single packed field.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	transaction_hash	in_collectionPriceSide	in_takerFeeRecipientRate	in_tokenIdListingIndexTrader
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	167	18352969	0x078435575dd0a9a5d3ffac870606f462d2be055352eb2cb0cd7f1fc9693e8d00	2023-10-15T03:03:23.000Z	0x58bef464fc1013ac5f95dba059425bee1ada484da6dcf236793fc4c5bb755321	452312850702443762503133391837770484809393175691397569844022351904569592343	15794164667717561851052069128171809338096529357008	255541853638975705190100742812026902392473305115138104
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	38	18354950	0xc954c75820b804d05924cd1f1811c25bc0f160094c446bd9d5ab639cfc7d5d05	2023-10-15T09:41:47.000Z	0xb2a157ab9fe1b5310ae3d46afc6f582097bd78746bbc83fb0b7b246415a7213f	452312853230841595085595440855080205998660350688671928038600506691455603328	44783408774572126363825309259827655666327675220200	808527517357773638450474074110819605799042617546025660
0xb2ecfe4e4d61f8790bbb9de2d1259b9e2410cea5	false	305	18354247	0xa43bf409f93c1b4fe5471149318bef975c0991cebc0ce1380d1f60c94efb782d	2023-10-15T07:20:11.000Z	0xffc51c3c2e5a4cae07ad2485ae94222da8aba35168d78c167f99d602b1ab8f8f	452312853172381529592359324126932812690009029902434626319560506691455603328	44783408774572126363825309259827655666327675220200	1303145434270967363917713482123090359833385744746769025

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BlurExchange_Execution_event

BlurExchange_Execution721MakerFeePacked_event

BlurExchange_Execution721Packed_event

BlurExchange_Execution721TakerFeePacked_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BlurExchange_Execution_event

​BlurExchange_Execution721MakerFeePacked_event

​BlurExchange_Execution721Packed_event

​BlurExchange_Execution721TakerFeePacked_event

Tables

BlurExchange_Execution_event

BlurExchange_Execution721MakerFeePacked_event

BlurExchange_Execution721Packed_event

BlurExchange_Execution721TakerFeePacked_event