superrare_v1_ethereum

Tables

MarketplaceV1_AcceptBid_event

Accepted bid events from SuperRare v1 marketplace on Ethereum, recording NFT sales where sellers accept standing bids. Contains bidder and seller addresses, sale prices in wei, token IDs, and origin contract addresses for analyzing secondary market dynamics.

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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	log_index	in__amount	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__originContract
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	202	150000000000000000	0xf1f29fe92b6d2e9fb63a8b614e6daa427207318c	0xa353401738e7ec6a4db9c0ee4c66eb5252f681c4	16236	11616900	2021-01-08T22:55:58.000Z	0x00c375bed274e9981b0cf2400f2486a696786ca3c3dea48c0ef442d1f27aa0fe	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	159	150000000000000000	0xf1f29fe92b6d2e9fb63a8b614e6daa427207318c	0xa353401738e7ec6a4db9c0ee4c66eb5252f681c4	16240	11616661	2021-01-08T21:58:19.000Z	0x5adec940b63cdbf879ba3b075f9fef7ea8eee2f99324777eb41668775295bc88	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	238	500000000000000000	0x0e22a5bc9e5f9aca14e491a6a0072934ce6b8b73	0x4f2e614e8290feb7d302cfd4062e786211644bf2	16600	11615564	2021-01-08T17:57:41.000Z	0xbd7acd50996d7d7f34e90de177064c683e00527e1f605bf2075c1f35b1cf3386	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0

Example Query

Query with partition filter

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

MarketplaceV1_Sold_event

NFT sale events from SuperRare’s v1 marketplace on Ethereum, capturing buyer, seller, token ID, and sale price in wei for each completed transaction. Used for analyzing SuperRare secondary market activity, price trends, and collector 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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__buyer`	`STRING`	Ethereum address of the buyer in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	in__buyer	log_index	in__amount	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__originContract
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	0x42f7c5275ac4372156027d939843c9c42523df2e	160	12000000000000000000	0x4bcd0e71b9b7604cc8e373fa8e4817c972f629e5	16733	11362825	2020-11-30T22:21:23.000Z	0x3fb88886dd2665dc845a93f87ccb3da23c8b137aa2a7df1742b1a4cc4238e44e	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	0x42f7c5275ac4372156027d939843c9c42523df2e	263	15000000000000000000	0xd9f15ed23b760d9ff4477e025aacdf45b71ddaef	15682	11363124	2020-11-30T23:29:23.000Z	0x64dacae7a41bebb363bfe3218e376481c85f97b7f417466750c120d6c1d4cf23	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x2947f98c42597966a0ec25e92843c09ac17fbaa7	false	0x6dc43be93a8b5fd37dc16f24872babc6da5e5e3e	48	631067961165049000	0x6d75d7d7ac8d90c2d7e5ee01df4b463ef99674bf	11117	11357178	2020-11-30T01:49:38.000Z	0x2dd8fbdecb46514bf925c37a019bd82db524329e310f35ea48b3203fc87192da	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0

Example Query

Query with partition filter

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

MarketplaceV2_AcceptBid_event

Accepted bid events from SuperRare NFT marketplace version 2 on Ethereum, recording when sellers accept offers from bidders. Contains bidder and seller addresses, sale price in wei, and token identifiers for analyzing secondary market pricing and acceptance patterns.

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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	log_index	in__amount	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__originContract
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	126	200000000000000000	0xe98bd4b49a1eafa8c2ecbf562073a12fae464b65	0xb445b423ec29746c7e2175baa88132890e81b6b5	20671	12120350	2021-03-27T09:38:14.000Z	0x377bca398fe3c9ab3a04d3c45150c97c68dba2e12299e3fec5371c4d5b271750	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	204	350000000000000000	0xf9e216b4864a5fd7cb03172261682537f8af47ed	0x0bfc14b3e1c8883231811b10794375fa79134fad	22226	12120520	2021-03-27T10:22:31.000Z	0xf1409655a05a86500c79c9f7d66e2ef9b65debafd7936df56d9a3d326730d250	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	195	400000000000000000	0x21e10167f7e56419c763c32a070b32705f036acb	0x0bfc14b3e1c8883231811b10794375fa79134fad	22309	12120617	2021-03-27T10:43:39.000Z	0xd842418d66d31d12201c6993b751f1e01b32f74fa1418d98208eeed73791d21b	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0

Example Query

Query with partition filter

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

MarketplaceV2_Sold_event

NFT sale events from SuperRare’s MarketplaceV2 contract on Ethereum, capturing buyer, seller, token ID, and sale price in wei for each completed transaction. Used for tracking secondary market activity and price discovery on the SuperRare platform.

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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__buyer`	`STRING`	Ethereum address of the buyer in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	in__buyer	log_index	in__amount	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__originContract
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	0xf902d068920234957d2908b8b0156e61c0bea2c2	399	1800000000000000000	0x75c526847d5fb1ec5a20ede7f217bf9478891c25	18660	13089096	2021-08-24T16:23:04.000Z	0xd91499e79cd2dce740eb8c9ba8edb0fbf88648e22ab333e4ffd1ad318358060a	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	0x9674ede5eb609f9483dd1682f2160ec45105250d	28	2000000000000000000	0xf8b32d30ac6ab3030595432533d7836fd76b078d	27430	13090456	2021-08-24T21:13:36.000Z	0xf0fdbb7ba8de91264957c63a1f5331c2e49897049989737202ddc0cd0fd738bc	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x65b49f7aee40347f5a90b714be4ef086f3fe5e2c	false	0x4c36b84b2974604e0fea458198f30864a70481e0	75	2000000000000000000	0x5e93a2fcce9737b0615e347b5f3a67bac390b8ce	22621	13087767	2021-08-24T11:27:48.000Z	0xc183c2b798b8d21d2b03b6b122a36484b3bf3f95c434188720a7de2ffe401a5c	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0

Example Query

Query with partition filter

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

RarityPool_RewardClaimed_event

Staking reward claim events from SuperRare v1 Rarity Pool contracts on Ethereum, recording when users withdraw earned rewards with claimer addresses and token amounts. Used for analyzing staking participation, reward distribution patterns, and staker behavior across different pool contracts.

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__msgSender`	`STRING`	Address of the account that called the contract function. Hex-encoded, 0x-prefixed, 42-character string.
`in__claimer`	`STRING`	Ethereum address of the user claiming their staking rewards from the SuperRare RarityPool contract. Always matches `in__msgSender` in sample data, indicating direct claims by reward recipients.
`in__amountToStaker`	`STRING`	Amount of reward tokens distributed to the staker who claimed from the SuperRare rarity pool. Value is in wei (smallest token unit), with zero indicating no reward was available at claim time.

Sample Data

address	removed	log_index	in__claimer	block_number	in__msgSender	block_timestamp	transaction_hash	in__amountToStaker
0xfefd0c3b8d9bb2514b2d7cfa5b69f9b7fceb9b9f	false	284	0x4c97542874cdad022e79485678e5746f96d38a75	18245404	0x4c97542874cdad022e79485678e5746f96d38a75	2023-09-30T02:00:35.000Z	0xfebe7d631938617c690b6584755abceb21b17d8bbc2f9ec2d1800de03f456e98	9288250802420657031
0xfefd0c3b8d9bb2514b2d7cfa5b69f9b7fceb9b9f	false	321	0xe67af016e88a886e86c70697f128b54f1ac11539	18242418	0xe67af016e88a886e86c70697f128b54f1ac11539	2023-09-29T15:59:47.000Z	0xad8f34347b8cff10000d44f1bb344004d23ebd57bd2587bb81f2ee1f48712f49	2150004478247971271
0x468c02ca3a2c03aa8a0be57ec06b460b92f40340	false	300	0x4c97542874cdad022e79485678e5746f96d38a75	18243399	0x4c97542874cdad022e79485678e5746f96d38a75	2023-09-29T19:16:47.000Z	0xc2f3af53c30730ad528db4aa47decdcc4002949d9838411227479603dce8c8cd	9310690236723349962

Example Query

Query with partition filter

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

RarityPoolFactory_StakingContractCreated_event

Staking contract deployment events from SuperRare’s Rarity Pool Factory on Ethereum, recording when users create new staking pools for specific NFT artists or collectors. Used to track staking contract instantiation and analyze which artists/collectors have dedicated staking pools.

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__deployingUser`	`STRING`	Ethereum address of the user who initiated the creation of the staking contract. This is the wallet that deployed the staking mechanism, which may differ from the artist address being staked on.
`in__userStakedOn`	`STRING`	Address of the SuperRare artist or creator whose works are being staked in this newly deployed staking contract. This field identifies which creator’s NFTs are the subject of the staking pool.
`in__stakingAddress`	`STRING`	Contract address of the newly deployed staking contract created by the RarityPoolFactory. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the staking pool instance.

Sample Data

address	removed	log_index	block_number	block_timestamp	in__userStakedOn	transaction_hash	in__deployingUser	in__stakingAddress
0x5d09145e1e798c7a885e49a6fc4f0542ce231a47	false	205	18130565	2023-09-13T23:10:23.000Z	0xf65db13b5ee031cb0ebba525ef21aa6c586681b3	0xdb97dd3993d916eb468d18362b1912331a0ab4012db5ea8bc4a7a9cdf721b517	0x03018c0dad483a344841675321d9676054dc9c9c	0xe5e6f9cd97db8aa8c4b33848bf2a47cfc589bf5b
0x5d09145e1e798c7a885e49a6fc4f0542ce231a47	false	112	18130081	2023-09-13T21:32:59.000Z	0x2b561ff6e1d13ad930582462512911d7c632c75c	0xc41d643774ef7a3c3472f5a52f9805f3eed95b841c74cab000b4b246496f5f06	0x2b561ff6e1d13ad930582462512911d7c632c75c	0x34e4001f573cf9cf8c0f427a19e6655a446c7df0
0x5d09145e1e798c7a885e49a6fc4f0542ce231a47	false	138	18124719	2023-09-13T03:30:35.000Z	0xd656f8d9cb8fa5aeb8b1576161d0488ee2c9c926	0xd2a15228bbbabce53d9b7e8731d76cad2107e64beb09ff8088e4b129e6a8a544	0x335e19b3f5dcfa2e398ee7d5ff430a1f8ccc88b2	0x27f04df5b1e842ad206f3eec096657ab8d1703d3

Example Query

Query with partition filter

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

RewardAccumulatorFactory_RewardSwapContractCreated_event

Event logs tracking the creation of new reward swap contracts by SuperRare’s RewardAccumulatorFactory on Ethereum. Links each deployed reward contract to its associated staking address for analyzing the platform’s staking reward distribution infrastructure.

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__stakingAddress`	`STRING`	Ethereum address of the staking contract associated with the newly created reward swap contract. Hex-encoded, 0x-prefixed 40-character string uniquely identifying the staking component in SuperRare’s reward accumulator system.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__stakingAddress
0x7eeb592e65d7f977717ece8f087dbd931f3b21c5	false	142	18071991	2023-09-05T18:14:35.000Z	0xf429d2dc5d0301165d23ad4e6ac4bcade2ec9b406a66d235a1356aa15229203f	0x0336c2d0361d603f507d814a9d75b95760f24cd5
0x7eeb592e65d7f977717ece8f087dbd931f3b21c5	false	574	18066973	2023-09-05T01:23:11.000Z	0x9aa9b5931cc1094f7902c76ea716522888bbeb52a747059891074b963f1aa93f	0x12cb220a07fb642cf963fe16fed79e805d27880f
0x7eeb592e65d7f977717ece8f087dbd931f3b21c5	false	228	18070291	2023-09-05T12:30:59.000Z	0xa37a8c9b106d9c059390139c1797b7b0fc8f24a5ba7aba235cbe92667d28fe6d	0x6247a4a9a1520591178f55df3ded0a4e9e1a6c76

Example Query

Query with partition filter

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

SuperRare_AcceptBid_event

Accepted bid events from SuperRare v1 NFT marketplace on Ethereum, recording when sellers accept standing bids with bidder address, sale price in wei, and token ID. Used for analyzing secondary market sales activity and price discovery on the platform.

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__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	log_index	in__amount	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	229	375000000000000000	0xada616ab0d9774fd62a41cbc8471c2a971a82c1e	0x5c57abd3548b87ef9babea37ed3abd51fad523a3	822	12743504	2021-07-01T18:57:43.000Z	0x75bdafe4de4a85cdc8694a15242c12f71316b51e291709e3af3c670ff64f5f07
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	231	1500000000000000000	0x5efdb6d8c798c2c2bea5b1961982a5944f92a5c1	0xa353401738e7ec6a4db9c0ee4c66eb5252f681c4	755	12743496	2021-07-01T18:54:34.000Z	0x7753fb7fb6fcc489c2ccbf131cf9d462ed502e021af1e31c24615bd60bb397ed
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	143	300000000000000000	0xdf73e10067c84808308f8f97cc6c69385fef2280	0x99d46eb671bfb7f367ebf9d5fc76b99587277de5	3942	12742449	2021-07-01T14:57:43.000Z	0x3fc2a1ea9b7137de3495de609b291a642296598eab682947df7c6c662fb80289

Example Query

Query with partition filter

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

SuperRare_Sold_event

NFT sale events from SuperRare v1 marketplace on Ethereum, capturing seller-to-buyer transfers with sale prices in wei and token IDs. Used for tracking SuperRare secondary market activity and historical pricing of digital artworks.

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__buyer`	`STRING`	Ethereum address of the buyer in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	in__buyer	log_index	in__amount	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	0xb3007ff3c3f40bdf0126fec7c8e43c3fc50ea813	171	50000000000000000	0xb308082a84f0cedabde8f8c019dc28c2140c9822	1543	7077501	2019-01-16T19:07:36.000Z	0x20d98e17776dda960a3a744cd975066094c5c39f83a3c8df1a96f42f8f43aee3
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	0x830e3a6766c753e041aa5b78e94213972a99d400	168	50000000000000000	0xb308082a84f0cedabde8f8c019dc28c2140c9822	1541	7077501	2019-01-16T19:07:36.000Z	0xa0dbac6609f298e85fa7825f9299846e034973ed70b05c0f5724e20615d12e34
0x41a322b28d0ff354040e2cbc676f0320d8c8850d	false	0x10017ca37b1257ac0771e24652aa28c758e378eb	92	500000000000000000	0xb3007ff3c3f40bdf0126fec7c8e43c3fc50ea813	1408	7076982	2019-01-16T16:59:04.000Z	0x6437b5dc6eae640d973030eedb4eaca3fcdf320fcbecdbd18225300195a6be37

Example Query

Query with partition filter

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

SuperRareAuctionHouse_AuctionSettled_event

Completed auction records from SuperRare NFT marketplace on Ethereum, capturing settlement events with final bid amounts, winning bidder addresses, and seller details for each tokenId. Used for analyzing NFT auction outcomes, price discovery, and market participant 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__contractAddress`	`STRING`	Contract address of the NFT collection where the auctioned token resides on Ethereum. Hex-encoded, 0x-prefixed 40-character string, typically pointing to SuperRare’s main NFT contract.
`in__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	log_index	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__contractAddress
0x8c9f364bf7a56ed058fc63ef81c6cf09c833e656	false	108	0x0000000000000000000000000000000000000000	0x13e49cd3f314188032bed445a2f3de55f3669110	15901	11898508	2021-02-21T05:51:14.000Z	0x66b94447f8d252339bdcb88ea9423553aada0b54ef2933dabd6d86770e4cbea1	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x8c9f364bf7a56ed058fc63ef81c6cf09c833e656	false	187	0x0000000000000000000000000000000000000000	0x85e0f48f07b159d5cdbca62f66934c4a6dc8ae9f	9640	11902762	2021-02-21T21:29:21.000Z	0x38dba3f52046f3902a07f7a06d5a8f886250b7ad4f71209aeb44674df5321086	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0
0x8c9f364bf7a56ed058fc63ef81c6cf09c833e656	false	127	0x0000000000000000000000000000000000000000	0x85e0f48f07b159d5cdbca62f66934c4a6dc8ae9f	19293	11903032	2021-02-21T22:26:32.000Z	0x2b690004189ca73881a6d5b1e1987214eafc4880e3c97d809dab28cc9ecd4ad5	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0

Example Query

Query with partition filter

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

SuperRareBazaar_AcceptOffer_event

Accepted offer events from SuperRare’s Bazaar marketplace contract on Ethereum, capturing NFT sales when sellers accept bids. Contains buyer/seller addresses, sale amounts, token IDs, and revenue split details for tracking secondary market transactions and royalty distributions.

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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__currencyAddress`	`STRING`	Contract address of the payment token used in the accepted offer. The zero address (0x000…000) indicates ETH was used as the payment currency.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.
`in__splitAddresses`	`ARRAY<STRING>`	Array of Ethereum addresses that receive portions of the sale proceeds when the offer is accepted. Corresponds to the `in__splitRatios` values to determine each recipient’s share of the payment.
`in__splitRatios`	`ARRAY<INT64>`	Revenue share ratio allocated to each address in the split payment distribution for this accepted offer. Value of 100 represents 100% allocation, commonly seen when only the seller receives proceeds.

Sample Data

address	removed	log_index	in__amount	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	in__splitRatios	transaction_hash	in__originContract	in__splitAddresses	in__currencyAddress
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	120	1000000000000000000	0x71a548c09c6d09df38811c6df025d281e878258b	0x66ff8f288c413e61c8ee807088ce301c03076e6e	3	15998492	2022-11-18T17:48:47.000Z	[100]	0xb3016b7abdff6805abac7c5fb457b5fda7c6320cf71468a406c2c875a538b2c5	0x33965d7fea021ce436e02dfcdf87b99c3f3750bd	[“0x66ff8f288c413e61c8ee807088ce301c03076e6e”]	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	23	1000000000000000000	0x9303ffccc6df17225baf77a0405598d19ea0d427	0x5f98736a54e68104d5e4f272484840094712d66e	3	16000246	2022-11-18T23:41:23.000Z	[100]	0x757a0e8c676cf849c939b9f4e95b66f4cdad7552d83580ddd666526b487c0a74	0x75240fb0ee029c284893097054a9779d9f197289	[“0x5f98736a54e68104d5e4f272484840094712d66e”]	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	147	4200000000000000000	0x1c4633f750ccdf4f40c9e88f5986a80c814b851f	0xb92b87a226cc740b3c5934047d3481fa87474de4	6	15998303	2022-11-18T17:10:23.000Z	[100]	0xc62460ba646c20461fb669f8f22c822fddc1db1e0f7cae27c1180ee4dbde91a4	0x8a3f232ed817f67c33697b6bd2ddcac2c6282ba7	[“0xb92b87a226cc740b3c5934047d3481fa87474de4”]	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

SuperRareBazaar_AuctionSettled_event

Auction settlement events from SuperRare NFT marketplace on Ethereum, recording final sale price, winning bidder, and seller for completed auctions. Used for analyzing NFT sales data, price discovery, and marketplace activity on the SuperRare platform.

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__contractAddress`	`STRING`	Contract address of the NFT being auctioned on SuperRare’s bazaar marketplace. Hex-encoded, 0x-prefixed 40-character string representing the ERC-721 token contract.
`in__bidder`	`STRING`	Ethereum address of the bidder in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.
`in__currencyAddress`	`STRING`	Contract address of the payment token used in the auction settlement. Zero address (0x000…000) indicates native ETH was used as payment currency.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	log_index	in__amount	in__bidder	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__contractAddress	in__currencyAddress
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	40	0	0x0000000000000000000000000000000000000000	0xbfc9f6c46715755e2ee8b01f20ab36d22cb4ad4f	7	16198064	2022-12-16T15:10:11.000Z	0x055464dd1a3c3d307d6b8bd1f6551744ca0140b1d9fb4c676d0ad3a33c2be8d4	0xdcf153c98d343cff8801eb9f85040af4cc99a7a2	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	34	0	0x0000000000000000000000000000000000000000	0xd5a904c0ee3b7b2f1ea56c55d8b90c713f719575	41104	16197556	2022-12-16T13:28:11.000Z	0x731956815c4bd4c6286b3c8529b160060ce8feca1db93d959f4d805f4ae02dee	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	42	555550000000000000	0x240ad467a71210629d71d4de22ebde27951c83fc	0xfd9513d0ea7f6677ee55f0b4e474fff667089865	41298	16198860	2022-12-16T17:50:11.000Z	0x1c0cd0af48de3db2389c2a948c7713f62a2402a8f16114a79b85f41451340ae1	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

SuperRareBazaar_Sold_event

NFT sale transactions from the SuperRare Bazaar marketplace on Ethereum, capturing buyer/seller addresses, token IDs, sale prices, and payment currency for secondary market trading activity. Used for analyzing SuperRare marketplace volume, pricing trends, and collector behavior across multiple NFT contracts.

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__originContract`	`STRING`	Contract address of the NFT collection being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in__buyer`	`STRING`	Ethereum address of the buyer in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__seller`	`STRING`	Ethereum address of the seller in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__currencyAddress`	`STRING`	Contract address of the payment token used in the sale, typically ETH (zero address) or an ERC-20 token. All sample transactions use the zero address (0x00…00), indicating native ETH payments.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.

Sample Data

address	removed	in__buyer	log_index	in__amount	in__seller	in__tokenId	block_number	block_timestamp	transaction_hash	in__originContract	in__currencyAddress
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	0x03018c0dad483a344841675321d9676054dc9c9c	237	50000000000000000	0x2638f91804b32190622ef82c6a265d8e9dae57a6	203	17809067	2023-07-30T23:18:23.000Z	0xd8366e44381331504da0839ac0e86a85955064170ec561600a34d639941f36c3	0x1e31fe630faf5782f20a187d7d21958b5f3bd699	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	0x03018c0dad483a344841675321d9676054dc9c9c	23	150000000000000000	0x7beed30332656ca4220cb2ce8e4508fb18013e8d	18	16494080	2023-01-26T22:48:59.000Z	0x17cb38fe9fc9b5c1c323a32a420dd410615b56893c0f859711196a13721ec795	0x22197a98390189c57216a0096bdbde2c9a3b6db7	0x0000000000000000000000000000000000000000
0x6d7c44773c52d396f43c2d511b81aa168e9a7a42	false	0x5f7476aca630a79d89b8a1b4d92fc91c65c01abf	25	1450000000000000000	0x9f6431646cc0657f3f5c2f3b2d70119661fa259b	41867	16489726	2023-01-26T08:14:35.000Z	0x0cf9d19df792f34d0acfcbef232ab3c193a8b65567beb6e214a349912fff24fa	0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MarketplaceV1_AcceptBid_event

MarketplaceV1_Sold_event

MarketplaceV2_AcceptBid_event

MarketplaceV2_Sold_event

RarityPool_RewardClaimed_event

RarityPoolFactory_StakingContractCreated_event

RewardAccumulatorFactory_RewardSwapContractCreated_event

SuperRare_AcceptBid_event

SuperRare_Sold_event

SuperRareAuctionHouse_AuctionSettled_event

SuperRareBazaar_AcceptOffer_event

SuperRareBazaar_AuctionSettled_event

SuperRareBazaar_Sold_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MarketplaceV1_AcceptBid_event

​MarketplaceV1_Sold_event

​MarketplaceV2_AcceptBid_event

​MarketplaceV2_Sold_event

​RarityPool_RewardClaimed_event

​RarityPoolFactory_StakingContractCreated_event

​RewardAccumulatorFactory_RewardSwapContractCreated_event

​SuperRare_AcceptBid_event

​SuperRare_Sold_event

​SuperRareAuctionHouse_AuctionSettled_event

​SuperRareBazaar_AcceptOffer_event

​SuperRareBazaar_AuctionSettled_event

​SuperRareBazaar_Sold_event

Tables

MarketplaceV1_AcceptBid_event

MarketplaceV1_Sold_event

MarketplaceV2_AcceptBid_event

MarketplaceV2_Sold_event

RarityPool_RewardClaimed_event

RarityPoolFactory_StakingContractCreated_event

RewardAccumulatorFactory_RewardSwapContractCreated_event

SuperRare_AcceptBid_event

SuperRare_Sold_event

SuperRareAuctionHouse_AuctionSettled_event

SuperRareBazaar_AcceptOffer_event

SuperRareBazaar_AuctionSettled_event

SuperRareBazaar_Sold_event