looksrare_v1_ethereum

Tables

Exchange_RoyaltyPayment_event

Royalty payment events from LooksRare V1 NFT marketplace on Ethereum, capturing amounts paid to collection creators when NFTs are sold. Contains payment details including recipient addresses, token IDs, and payment currency for analyzing creator revenue and royalty structures.

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_collection`	`STRING`	Contract address of the NFT collection involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_royaltyRecipient`	`STRING`	Ethereum address that received the royalty payment from the NFT sale on LooksRare. Hex-encoded, 0x-prefixed 40-character string representing the creator or rights holder wallet.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_tokenId	in_currency	block_number	in_collection	block_timestamp	transaction_hash	in_royaltyRecipient
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	90000000000000000	55	254	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14074197	0x026224a2940bfe258d0dbe947919b62fe321f042	2022-01-25T10:20:54.000Z	0x45469d91f8ccef6248f5b0eeb863892c93af47a7da1f4cd9139c1f985202599b	0x557068a9b7d66f97a61b97c80541eb17672e1e6f
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	40000000000000000	57	9571	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14075222	0x0616a2ef54bad0b37dce41c8d8e35cce17a926f3	2022-01-25T14:17:13.000Z	0x3f94958f2451374f719c5cf10df414650d17bf33eb4753e211ca19b03de31ff5	0x3dcb97ac03b6568e1d0b3e90a20ecc0f6dca34a4
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	25750000000000000	145	1358	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14076915	0x066f2d5ead7951f0d0038c19affd500b9f02c0e5	2022-01-25T20:32:00.000Z	0xb597002b27a100cf0457a70a952976a4d2c9e275d1edb668be77170da5857fb3	0x06caeb8090e2e7553bdfcb46e48f040fc5131afb

Example Query

Query with partition filter

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

Exchange_TakerAsk_event

TakerAsk fulfilled order events from LooksRare V1 NFT marketplace on Ethereum, recording when buyers accept seller listings with maker/taker addresses, NFT collection, token ID, price in currency (typically WETH), and strategy contract. Used for analyzing NFT trading activity, price discovery, and market maker behavior on LooksRare.

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_orderNonce`	`STRING`	Incremental counter used by the maker to track and invalidate their orders on LooksRare. Nonce values increment sequentially and can be used to cancel multiple outstanding orders at once.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collection`	`STRING`	Contract address of the NFT collection involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_maker	in_price	in_taker	in_amount	log_index	in_tokenId	in_currency	in_strategy	block_number	in_orderHash	in_collection	in_orderNonce	block_timestamp	transaction_hash
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0x7e0875fb8bf493d268efdf0b7aa7cd29614a03cc	10000000000000000	0x879485a16327aaf917836b26ca146b05ff93364a	1	375	186	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x09f93623019049c76209c26517acc2af9d49c69b	16566880	0x7e42c0bc95731b5f881d02158c530015e6c92ddff73ec78f612eadd6b5311c26	0x198478f870d97d62d640368d111b979d7ca3c38f	142	2023-02-06T02:52:23.000Z	0x628296bed4585a3de44797f7afca3a4911fe37f475f231cd0aeb6e9b01c2e77e
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0xe852c2189316ec5eee9f36272962ade430f38531	12000000000000000	0x385df8cbc196f5f780367f3cdc96af072a916f7e	1	23	478	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x09f93623019049c76209c26517acc2af9d49c69b	16567868	0x8a8665989e7bbb5b76e6fb259dc98b1dba230910da3fc826675c032bcc60f8ce	0xb67812ce508b9fc190740871032237c24b6896a0	16469	2023-02-06T06:10:47.000Z	0x742b30fa3850d62fe40275f17dd4be86f8ce2d10c9b4b8090041744b659a9c67
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0xda28c33f93f99fdda59f63be9af9ff71e0b068c2	20000000000000000	0xadb040f4f27ea941bccac56b763f577da2ed0311	1	255	2692	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x09f93623019049c76209c26517acc2af9d49c69b	16566352	0x7e33b665e23b49f96f566f5d9ff053b1490fb870dd08a86e24eef688fc55c5ca	0x5dff0b226fde7085a850aff06e2ea62d1ad506f5	0	2023-02-06T01:06:11.000Z	0x5f913436fce3dcc38f853c4121c8b93ea5634a89264682298e7f0601f54e07cd

Example Query

Query with partition filter

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

Exchange_TakerBid_event

NFT purchase events from LooksRare V1 marketplace on Ethereum where buyers accept maker sell orders. Records include collection address, token ID, sale price in WETH, maker/taker addresses, and order hash for analyzing NFT trading activity 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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_orderNonce`	`STRING`	Sequential nonce value for the maker’s order to prevent replay attacks and order conflicts. Increments with each new order from the same maker address on LooksRare v1.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collection`	`STRING`	Contract address of the NFT collection involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_maker	in_price	in_taker	in_amount	log_index	in_tokenId	in_currency	in_strategy	block_number	in_orderHash	in_collection	in_orderNonce	block_timestamp	transaction_hash
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0xdcaba4bf782b693def3adf5b21d81de6328e00f7	111000000000000000	0x266e873a0d1e76c63af2f50bc5ca6d25867d4300	1	524	1	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x56244bb70cbd3ea9dc8007399f61dfc065190031	14643645	0x7645ccbf358448379c1136e3df280693c905e3149466082391e75b49c8dc7e40	0x00047d0d2a0afad9aedc5e840533df8336f85e4e	37	2022-04-23T22:03:36.000Z	0xd8213cc7c4023ccbe62d7f614300eed5649c25a7375c30875e8a0a73eef80554
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0xe9d4f4f93c7c0ebf3bdfed9eff721476ce951e61	49000000000000000	0xc3d3517a05edd30ee7f11823332e1770d9cbe7be	1	77	1379	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x56244bb70cbd3ea9dc8007399f61dfc065190031	14642521	0xf759f7ce8bdd6faf4b244eacdd75bf1fa73f6891bcf13e2e3b50752f6f30a0a2	0x00758fb0c83a68b6ce4fcf1d2665600f3f0e4570	36	2022-04-23T17:53:16.000Z	0x56aeaacf6a3d7d0c4329ccbd70f179fad73c85afc8bac37ae9da155c1470fd12
0x59728544b08ab483533076417fbbb2fd0b17ce3a	false	0xe9d4f4f93c7c0ebf3bdfed9eff721476ce951e61	50000000000000000	0xc3d3517a05edd30ee7f11823332e1770d9cbe7be	1	324	6028	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x56244bb70cbd3ea9dc8007399f61dfc065190031	14642524	0xa559c7a8aa57049d3d84a57f23a8ed5952f97e0921b8065b7b8aa095486218ad	0x00758fb0c83a68b6ce4fcf1d2665600f3f0e4570	35	2022-04-23T17:53:43.000Z	0xda4ffa4008095001910c398d82f97308d40fbb08211c778e15123319395a66b3

Example Query

Query with partition filter

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

ExchangeV2_TakerAsk_event

NFT sale events from LooksRare V2 marketplace on Ethereum where sellers (ask users) accept buyer bids, capturing token transfers, payment details in WETH, and marketplace fees for analyzing secondary market trading 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_nonceInvalidationParameters`	`STRUCT<orderHash STRING, orderNonce STRING, isNonceInvalidated BOOL>`	Structured data containing order management details including the order hash, sequential nonce number, and invalidation status flag. Used to prevent replay attacks and track which orders have been executed or cancelled on the LooksRare exchange.
`in_askUser`	`STRING`	Ethereum address of the seller (ask side) in the NFT trade. Always represents the current owner listing their NFT for sale on LooksRare.
`in_bidUser`	`STRING`	Ethereum address of the buyer (taker) who accepted the listed ask order. Always a non-zero address representing the party purchasing the NFT.
`in_strategyId`	`STRING`	Identifier for the trading strategy used to execute this NFT sale on LooksRare V2. Typically ‘0’ for standard sales or ‘1’ for alternative matching strategies.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collection`	`STRING`	Contract address of the NFT collection involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_itemIds`	`ARRAY<STRING>`	Token IDs being traded in this NFT marketplace transaction. Array of numeric identifiers representing specific NFTs within the collection, typically contains a single item for standard sales.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_feeRecipients`	`ARRAY<STRING>`	Array of Ethereum addresses receiving fees from the NFT sale transaction. Typically includes the seller’s address and platform fee recipient, with zero addresses indicating no fee for that position.
`in_feeAmounts`	`ARRAY<STRING>`	Array of fee amounts in wei charged for this transaction, typically including marketplace fee, royalty payment, and protocol fee.

Sample Data

address	removed	log_index	in_amounts	in_askUser	in_bidUser	in_itemIds	in_currency	block_number	in_collection	in_feeAmounts	in_strategyId	block_timestamp	in_feeRecipients	transaction_hash	in_nonceInvalidationParameters
0x0000000000e655fae4d56241588680f86e3b2377	false	254	[“1”]	0x003e626d8fcc6488efa42c0b2d52e90d17870797	0x93bc760ea647abf0d93e22eddefa12aa922a890c	[“2739”]	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17645530	0x2ee6af0dff3a1ce3f7e3414c52c48fd50d73691e	[“22785500000000000”,“0”,“114500000000000”]	1	2023-07-08T00:37:11.000Z	[“0x003e626d8fcc6488efa42c0b2d52e90d17870797”,“0x0000000000000000000000000000000000000000”]	0x92735269f5c6d4643251c7125f26c55cd2fb6d28a41f5f416fcb7ad92958d29f	{“orderHash”:“0x468234b8b22ea89b28633435bc1bd1f522099723c46c525165065e1e9e53996a”,“orderNonce”:“21”,“isNonceInvalidated”:true}
0x0000000000e655fae4d56241588680f86e3b2377	false	252	[“1”]	0x003e626d8fcc6488efa42c0b2d52e90d17870797	0x93bc760ea647abf0d93e22eddefa12aa922a890c	[“6526”]	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17645539	0x2ee6af0dff3a1ce3f7e3414c52c48fd50d73691e	[“22686000000000000”,“0”,“114000000000000”]	1	2023-07-08T00:38:59.000Z	[“0x003e626d8fcc6488efa42c0b2d52e90d17870797”,“0x0000000000000000000000000000000000000000”]	0x745b9ab15e75ff50fd93f68701a3c4590b89d9f2e32ae267bcf26fe387a5f023	{“orderHash”:“0x8bbec43dd9e6293a4c82b2df5f14adc1567cb919d89312e258bf9e017d7795f6”,“orderNonce”:“20”,“isNonceInvalidated”:true}
0x0000000000e655fae4d56241588680f86e3b2377	false	299	[“1”]	0x003e626d8fcc6488efa42c0b2d52e90d17870797	0x93bc760ea647abf0d93e22eddefa12aa922a890c	[“8265”]	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17645543	0x2ee6af0dff3a1ce3f7e3414c52c48fd50d73691e	[“22586500000000000”,“0”,“113500000000000”]	1	2023-07-08T00:39:47.000Z	[“0x003e626d8fcc6488efa42c0b2d52e90d17870797”,“0x0000000000000000000000000000000000000000”]	0x511d39d522c619b507ed9fed8271a59df38cdd45e99b7fec08182139c2d0273b	{“orderHash”:“0xd0a94d3155e34fcd858b9230e779b501164487277c314bd829d652087c7ea626”,“orderNonce”:“19”,“isNonceInvalidated”:true}

Example Query

Query with partition filter

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

ExchangeV2_TakerBid_event

NFT purchase events from LooksRare V2 marketplace on Ethereum where buyers accept seller listings, capturing token IDs, prices in ETH or ERC20, fee distributions, and order nonce invalidation data for analyzing secondary market trading 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_nonceInvalidationParameters`	`STRUCT<orderHash STRING, orderNonce STRING, isNonceInvalidated BOOL>`	Structured data containing order hash, nonce value, and invalidation status used to prevent replay attacks in the LooksRare marketplace. Includes the unique order identifier, sequential nonce number, and boolean flag indicating whether the nonce has been invalidated.
`in_bidUser`	`STRING`	Ethereum address of the user who placed the accepted bid on the LooksRare marketplace. This address is the buyer who will receive the NFT after the transaction settles.
`in_bidRecipient`	`STRING`	Ethereum address that receives the NFT(s) purchased through this taker bid transaction. Typically matches `in_bidUser` but may differ if the NFT is being sent to a different recipient.
`in_strategyId`	`STRING`	Identifier of the matching strategy used to execute this taker bid on LooksRare v2 exchange. Appears to be ‘0’ for standard ERC-721 single-token purchases based on sample data.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collection`	`STRING`	Contract address of the NFT collection involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_itemIds`	`ARRAY<STRING>`	Token IDs of the NFTs being purchased in this taker bid transaction. Array of numeric identifiers representing specific tokens within the collection.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_feeRecipients`	`ARRAY<STRING>`	Array of wallet addresses receiving fees from this NFT purchase transaction. Typically includes marketplace fee recipient and creator royalty recipient (zero address when no royalty).
`in_feeAmounts`	`ARRAY<STRING>`	Array of fee amounts in wei deducted from the sale transaction, corresponding to each recipient in in_feeRecipients. Typically includes marketplace fees, creator royalties, and protocol fees in that order.

Sample Data

address	removed	log_index	in_amounts	in_bidUser	in_itemIds	in_currency	block_number	in_collection	in_feeAmounts	block_timestamp	in_bidRecipient	in_feeRecipients	transaction_hash	in_nonceInvalidationParameters
0x0000000000e655fae4d56241588680f86e3b2377	false	287	[“1”]	0x00000060bb1e57e3f1af1102f68db9fc2ee489bc	[“9054”]	0x0000000000000000000000000000000000000000	17560242	0x364c828ee171616a39897688a831c2499ad972ec	[“405960000000000000”,“0”,“2040000000000000”]	2023-06-26T01:08:11.000Z	0x00000060bb1e57e3f1af1102f68db9fc2ee489bc	[“0xed7a86ebdd39bc4a9339d0aa3bb91b497caf7686”,“0x0000000000000000000000000000000000000000”]	0xb544519217f4ec3c50e950348da1558d1f1d0fa100767203d3dfc5c1ab1b02cb	{“orderHash”:“0x07023cb0b7bb75532cf46a88e1ea0c9bec9db1d97206d331797a394c50bbe4bc”,“orderNonce”:“4”,“isNonceInvalidated”:true}
0x0000000000e655fae4d56241588680f86e3b2377	false	194	[“1”]	0x03a33d1d1992a7cd57a98d061de954724fd904ca	[“4187”]	0x0000000000000000000000000000000000000000	17563649	0xc1922a5abfa18110827c0666b7bbac0389ab7396	[“14925000000000000”,“0”,“75000000000000”]	2023-06-26T12:38:35.000Z	0x03a33d1d1992a7cd57a98d061de954724fd904ca	[“0x36710d7f633c006892573f939f8e690e919057c2”,“0x0000000000000000000000000000000000000000”]	0x39d0f6aef9ea6e9586da608dde6319a2e01766d23fdc405d36a72d3a6a1103b4	{“orderHash”:“0xf1a95b52e3362f24512432f9e79b31823b88ecfe56bae6a202f3c0a4537272d3”,“orderNonce”:“0”,“isNonceInvalidated”:true}
0x0000000000e655fae4d56241588680f86e3b2377	false	100	[“1”]	0x48428426f3b65f7a19d9fd712d1864e7b634a206	[“1392”]	0x0000000000000000000000000000000000000000	17563159	0x9c9a7bda362b4b0a3829a01cfa77d8d0b30d8444	[“11940000000000000”,“0”,“60000000000000”]	2023-06-26T10:59:23.000Z	0x48428426f3b65f7a19d9fd712d1864e7b634a206	[“0x1afb2d72bc5d13e5a718766c5f5403fbc29b186c”,“0x0000000000000000000000000000000000000000”]	0x6e19bcb76047616de89579130fab3e3d8cd227f0f09a56d50d6c5bc78686efc3	{“orderHash”:“0x22589dbf55d637a1b6c18765cb8fdd80b89589fe125bb78ba40dcd3ab7fbd7f8”,“orderNonce”:“664009”,“isNonceInvalidated”:true}

Example Query

Query with partition filter

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

MultiRewardsDistributor_Claim_event

Reward claim events from LooksRare V1 NFT marketplace on Ethereum, tracking user withdrawals of trading incentives and staking rewards by round and tree ID. Used for analyzing LooksRare token distribution patterns and user reward claiming behavior.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardRound`	`STRING`	Identifier for the reward distribution cycle during which these tokens were claimed. Typically increments sequentially with each new distribution period on the LooksRare platform.
`in_totalAmount`	`STRING`	Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
`in_treeIds`	`ARRAY<INT64>`	Identifiers for the specific reward pools or merkle trees from which tokens are being claimed in this transaction. Array can contain multiple IDs when claiming from different reward sources simultaneously.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

address	in_user	removed	log_index	in_amounts	in_treeIds	block_number	in_rewardRound	in_totalAmount	block_timestamp	transaction_hash
0x0554f068365ed43dcc98dcd7fd7a8208a5638c72	0x2afbf58dccae8b7fa610decb8db80d8261601cad	false	225	[“272004989864254228685”]	[0]	18425596	549	272004989864254228685	2023-10-25T06:53:47.000Z	0xc22d9741f68aff07c4b6e90b3be943956917d6369d900e599da071c6705a8752
0x0554f068365ed43dcc98dcd7fd7a8208a5638c72	0x93b8893e482faf7472e25b5994acb6ca3631cae6	false	240	[“222714690706675783412”,“7154490659894435595”]	[0,1]	18426001	549	229869181366570219007	2023-10-25T08:15:11.000Z	0x8b1955949d4e21f2e7977b45b6e36465b7edfe240606cdbf1c7c22a9c843caca
0x0554f068365ed43dcc98dcd7fd7a8208a5638c72	0xadc28e50fa4f57a998accc2da36cc087376e8c84	false	127	[“72863577716424362570733”]	[0]	15723664	173	72863577716424362570733	2022-10-11T08:26:23.000Z	0xfc65db12f75e3cffdd25d7faf113fcf5d9ed12d1e38178cfe69d1cd97fe1ac76

Example Query

Query with partition filter

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

SeasonRewardsDistributor_RewardsClaim_event

LooksRare NFT marketplace seasonal reward claim events on Ethereum, tracking user addresses claiming LOOKS token rewards by season round with claimed amounts in wei. Used for analyzing trading reward distribution patterns and user participation across LooksRare’s incentive program seasons.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardRound`	`STRING`	Season identifier for the LooksRare trading rewards program being claimed. Numeric string representing the reward distribution period (e.g., ‘2’, ‘5’).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	in_rewardRound	block_timestamp	transaction_hash
0x5c073cecafc56ee9f4335230a09933965c8ed472	0x1ab9cc2ee65f1d4d3cef63e6434869ad9ed3c4a1	false	13784374213971186586	353	17698831	2	2023-07-15T12:38:11.000Z	0x172c97ef47a4499e124f57339594fc7955604ac91b14b882ff906db2b9190fc7
0x5c073cecafc56ee9f4335230a09933965c8ed472	0xa34add7490b454edc46489d7fc7125be24ccac8f	false	607112676404621092761	258	17696450	2	2023-07-15T04:31:47.000Z	0x2f3624827d48a355502bc2d6bae8290547c1c53f2d8e86e327df30c8210c7a7e
0x5c073cecafc56ee9f4335230a09933965c8ed472	0x5e2eabfaddf49615f84734724b77eeeebc5ebd71	false	78229828445391092970	467	17696464	2	2023-07-15T04:34:47.000Z	0x46f753fcfdc369c2c1e355554140b40a762ba6df8a640dcbf221e69fb38e86ca

Example Query

Query with partition filter

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

TradingRewardsDistributor_RewardsClaim_event

Trading rewards claim events from LooksRare v1 NFT marketplace on Ethereum, recording user reward redemptions by round with token amounts. Used for analyzing platform incentive program participation and reward distribution patterns across trading epochs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardRound`	`STRING`	Identifier for the trading rewards distribution period on LooksRare. Increments sequentially with each reward cycle, with round 36 occurring in mid-February 2022.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	in_rewardRound	block_timestamp	transaction_hash
0x453c1208b400fe47acf275315f14e8f9f9fbc3cd	0xb26265e3d361e68e5d48968b5f7e9229516d9ea3	false	84427059827804404055	498	14220396	36	2022-02-17T00:29:17.000Z	0xaeb7fe8732f8108f856e02546f75a4eddcdc067324ed487632893031265edf96
0x453c1208b400fe47acf275315f14e8f9f9fbc3cd	0x08fa73edae34fcdeeaafd24198fdd7e71ad4e329	false	6163041722965622021	567	14221557	36	2022-02-17T04:48:47.000Z	0x9a085804414daf238aaf356fe9fd8a04ce32aab85e03f397dd9fdd100325c53b
0x453c1208b400fe47acf275315f14e8f9f9fbc3cd	0x66d16484353cdc4cb7178d147d20c13a9a9def13	false	4416244043189264860	344	14221684	36	2022-02-17T05:15:00.000Z	0x4192d4a62bd88502d635920856b27a2638db239e909b42c6ebe603211a65a4a3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Exchange_RoyaltyPayment_event

Exchange_TakerAsk_event

Exchange_TakerBid_event

ExchangeV2_TakerAsk_event

ExchangeV2_TakerBid_event

MultiRewardsDistributor_Claim_event

SeasonRewardsDistributor_RewardsClaim_event

TradingRewardsDistributor_RewardsClaim_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Exchange_RoyaltyPayment_event

​Exchange_TakerAsk_event

​Exchange_TakerBid_event

​ExchangeV2_TakerAsk_event

​ExchangeV2_TakerBid_event

​MultiRewardsDistributor_Claim_event

​SeasonRewardsDistributor_RewardsClaim_event

​TradingRewardsDistributor_RewardsClaim_event

Tables

Exchange_RoyaltyPayment_event

Exchange_TakerAsk_event

Exchange_TakerBid_event

ExchangeV2_TakerAsk_event

ExchangeV2_TakerBid_event

MultiRewardsDistributor_Claim_event

SeasonRewardsDistributor_RewardsClaim_event

TradingRewardsDistributor_RewardsClaim_event