> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# looksrare_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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` | 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` | 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` | Array of fee amounts in wei charged for this transaction, typically including marketplace fee, royalty payment, and protocol fee. |
| 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} |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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` | 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` | 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` | 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. |
| address | removed | log\_index | in\_amounts | in\_bidUser | in\_itemIds | in\_currency | block\_number | in\_collection | in\_feeAmounts | in\_strategyId | block\_timestamp | in\_bidRecipient | in\_feeRecipients | transaction\_hash | in\_nonceInvalidationParameters |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------------------------------------ | ----------- | ------------------------------------------ | ------------- | ------------------------------------------ | ---------------------------------------------- | -------------- | ------------------------ | ------------------------------------------ | -------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------- |
| 0x0000000000e655fae4d56241588680f86e3b2377 | false | 287 | \["1"] | 0x00000060bb1e57e3f1af1102f68db9fc2ee489bc | \["9054"] | 0x0000000000000000000000000000000000000000 | 17560242 | 0x364c828ee171616a39897688a831c2499ad972ec | \["405960000000000000","0","2040000000000000"] | 0 | 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"] | 0 | 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"] | 0 | 2023-06-26T10:59:23.000Z | 0x48428426f3b65f7a19d9fd712d1864e7b634a206 | \["0x1afb2d72bc5d13e5a718766c5f5403fbc29b186c","0x0000000000000000000000000000000000000000"] | 0x6e19bcb76047616de89579130fab3e3d8cd227f0f09a56d50d6c5bc78686efc3 | \{"orderHash":"0x22589dbf55d637a1b6c18765cb8fdd80b89589fe125bb78ba40dcd3ab7fbd7f8","orderNonce":"664009","isNonceInvalidated":true} |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.looksrare_v1_ethereum.TradingRewardsDistributor_RewardsClaim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***