sound_v2_optimism

Tables

MerkleDropMinter_Minted_event

NFT mint events from Sound Protocol’s MerkleDropMinter contract on Optimism, tracking music NFT purchases with buyer addresses, edition contracts, token IDs, quantities, and fee data. Used for analyzing Sound.xyz minting activity, affiliate revenue sharing, and music creator sales performance.

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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintId`	`STRING`	Unique identifier for the minting schedule or configuration associated with the NFT purchase. Numeric string representation.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_requiredEtherValue`	`STRING`	Total Ether value required for the NFT mint transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	in_mintId	log_index	in_edition	in_quantity	block_number	in_affiliate	in_affiliated	in_fromTokenId	block_timestamp	transaction_hash
0x65d21a94c78a5f9ef68a2be141d0c91afc51a7d3	false	0xb5cd58e6d1ca87d0aa63f2ef03b5f2f24e453867	30	33	0x160d2ecef8161c20595f6b21732c6e23bd9bec75	1	105947506	0x0000000000000000000000000000000000000000	false	113	2023-06-23T04:16:29.000Z	0xceb7f36f06c5641a792a4c23005a8258abe1d9a2ef7c6ba6ffabb3bd17dad76b
0x65d21a94c78a5f9ef68a2be141d0c91afc51a7d3	false	0x2aab747822b72b9e749252899f19f92e107454dc	30	25	0x160d2ecef8161c20595f6b21732c6e23bd9bec75	1	105965443	0x0000000000000000000000000000000000000000	false	686	2023-06-23T14:14:23.000Z	0x4eec738cfdfb4e4bfd0bac7ad9fd33daa02a82effea51a3bd1ae8c63fa500ae0
0x65d21a94c78a5f9ef68a2be141d0c91afc51a7d3	false	0x63a65fc3a6e3714e2a210b7fe17a9d743426da22	30	83	0x160d2ecef8161c20595f6b21732c6e23bd9bec75	1	105943952	0x0000000000000000000000000000000000000000	false	77	2023-06-23T02:18:01.000Z	0x6dcc009936d82737f1e4df1342064769c08797f9c1398cc4baf5048698a1e362

Example Query

Query with partition filter

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

MerkleDropMinterV1_Minted_event

NFT mint events from Sound Protocol’s MerkleDropMinterV1 contract on Optimism, capturing edition purchases with buyer addresses, quantities, token IDs, and fee distributions. Tracks platform and affiliate fees in wei for analyzing Sound’s music NFT minting economics and referral 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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintId`	`STRING`	Unique identifier for the minting schedule or configuration associated with the NFT purchase. Numeric string representation.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_requiredEtherValue`	`STRING`	Total Ether value required for the NFT mint transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	in_mintId	log_index	in_edition	in_quantity	block_number	in_affiliate	in_affiliated	in_fromTokenId	in_platformFee	block_timestamp	in_attributionId	transaction_hash	in_requiredEtherValue
0x46f81107e99adf80b8ea49ab7281b984f826fbd0	false	0x22ded344533e41ac32f3943ef8c6af9442184f6d	192	26	0x70147537309328630ee013ea0ac982acd574b4a4	1	108082492	0x0000000000000000000000000000000000000000	false	41	700000000000000	2023-08-11T14:22:41.000Z	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x5ab2b354ab7a3a10e08ee74308be43e9bbe341cdfa7e0190df05729087e3dc25	700000000000000
0x46f81107e99adf80b8ea49ab7281b984f826fbd0	false	0x56a5fb55d3e789b635b18dae15d9468d703641e9	192	7	0x70147537309328630ee013ea0ac982acd574b4a4	1	108060548	0x0000000000000000000000000000000000000000	false	37	700000000000000	2023-08-11T02:11:13.000Z	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x36c3b03190d3132b96ea8812efaa760dcdef71ef51528db1a24c522f0189ad9a	700000000000000
0x46f81107e99adf80b8ea49ab7281b984f826fbd0	false	0x26567d4436ca791c87ce6661fc3bc8c5c9e68c77	192	9	0x70147537309328630ee013ea0ac982acd574b4a4	1	108063256	0x0000000000000000000000000000000000000000	false	38	700000000000000	2023-08-11T03:41:29.000Z	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x6f1c06a5ce002b5772ac360d6948cdeede7043939360712d5ddfe0fa88a8d518	700000000000000

Example Query

Query with partition filter

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

RangeEditionMinter_Minted_event

NFT mint events from Sound.xyz range edition minter contract on Optimism, tracking individual purchases with buyer addresses, token IDs, quantities, ETH amounts, platform fees, and affiliate attribution. Used for analyzing music NFT sales patterns and platform economics.

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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintId`	`STRING`	Unique identifier for the minting schedule or configuration associated with the NFT purchase. Numeric string representation.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_requiredEtherValue`	`STRING`	Total Ether value required for the NFT mint transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	in_mintId	log_index	in_edition	in_quantity	block_number	in_affiliate	in_affiliated	in_fromTokenId	in_platformFee	block_timestamp	in_attributionId	transaction_hash	in_requiredEtherValue
0x1a36729fc276c3649da2cf1eb986d7dabd5d5d99	false	0xcd7a011517f5c038995afaf5a84f4959e0f07c1d	66	10	0x87841b040d84516cc56b777d315e25ce5a094760	1	114910848	0x0000000000000000000000000000000000000000	false	3517	777000000000000	2024-01-16T15:54:33.000Z	0	0x0e39de0f35870fe90b7cf64c5fd4eb8976f70e85f3e1bcd93c238a88a8ed486a	5777000000000000
0x1a36729fc276c3649da2cf1eb986d7dabd5d5d99	false	0xe7096daf78c15bf0889230a328e3482930f3c936	66	2	0x87841b040d84516cc56b777d315e25ce5a094760	1	107083482	0x0000000000000000000000000000000000000000	false	3500	250000000000000	2023-07-19T11:22:21.000Z	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x2ba8b77c31447fc571b530a121526210ce0e8f0d50c603625a05a0ba1f9a7e50	5000000000000000
0x1a36729fc276c3649da2cf1eb986d7dabd5d5d99	false	0x7af44c5b5a56bb20face8a15429fa4b475a0f452	66	26	0x87841b040d84516cc56b777d315e25ce5a094760	1	107081322	0x0000000000000000000000000000000000000000	false	3499	250000000000000	2023-07-19T10:10:21.000Z	0	0x5ba16573acb85dbad2a4600eba7cb0828f5af4cc28cf19c5eebb9450fe24f596	5000000000000000

Example Query

Query with partition filter

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

RangeEditionMinterV1_Minted_event

NFT (Non-Fungible Token) mint events from Sound.xyz’s Range Edition Minter V1 contract on Optimism, capturing music NFT purchases with buyer addresses, edition contracts, token quantities, pricing in wei, and platform/affiliate fee distribution.

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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintId`	`STRING`	Unique identifier for the minting schedule or configuration associated with the NFT purchase. Numeric string representation.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_requiredEtherValue`	`STRING`	Total Ether value required for the NFT mint transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	in_mintId	log_index	in_edition	in_quantity	block_number	in_affiliate	in_affiliated	in_fromTokenId	in_platformFee	block_timestamp	transaction_hash	in_requiredEtherValue
0x403471cbcab399896004bc0af2b4674d4ab3b53b	false	0x504c47cc30c97471bdd06dba2da801e12822c01a	189	3	0x18d0f6f3d7f902205a50751455538e1cbc3c090d	1	111267967	0x0000000000000000000000000000000000000000	false	1	700000000000000	2023-10-24T08:05:11.000Z	0x7f92e3eb2a2879f66318116e0ec269238db795a6a2ffe89fd2a9ec44ad6c1bf2	700000000000000
0x403471cbcab399896004bc0af2b4674d4ab3b53b	false	0x82dd0d8cabb5d78aafb043b85189cef9c2205861	1302	19	0xe688c62b5e2e70f8879377312bb7977558ebb47a	1	111263603	0x0000000000000000000000000000000000000000	false	1	700000000000000	2023-10-24T05:39:43.000Z	0x308230e53f6171dabdcae879f680da9a5fc940311b2e3ebeee8e90430f64c6b0	5700000000000000
0x403471cbcab399896004bc0af2b4674d4ab3b53b	false	0x1f5c91c68328da3208bb7a40e544eef1c1a37186	189	17	0x18d0f6f3d7f902205a50751455538e1cbc3c090d	1	111269963	0x0000000000000000000000000000000000000000	false	2	700000000000000	2023-10-24T09:11:43.000Z	0x77352a3673724b9f69d847c356485417187dfa6c39f12905828cfb29045c3442	700000000000000

Example Query

Query with partition filter

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

SAM_Bought_event

Sound protocol (SAM) music NFT purchase events on Optimism with bonding curve pricing, capturing buyer addresses, edition contracts, quantities, and fee distributions (artist, platform, affiliate, golden egg).

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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_fromCurveSupply`	`STRING`	Supply count on the bonding curve before the transaction executed. Numeric string representation.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_totalPayment`	`STRING`	Total payment amount for the NFT purchase transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_artistFee`	`STRING`	Fee paid to the artist for the music edition NFT sale. Numeric string representation of the amount in wei.
`in_goldenEggFee`	`STRING`	Fee allocated to the Golden Egg program for the music NFT purchase. Numeric string representation of the amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	log_index	in_edition	in_quantity	block_number	in_affiliate	in_artistFee	in_affiliated	in_fromTokenId	in_platformFee	block_timestamp	in_totalPayment	in_attributionId	transaction_hash	in_fromCurveSupply
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0xaa467c39a3e83481666d1d759e8fadc85ddaa1ca	16	0x2e979d075329f038c10f0abf80f7fb5e870c8708	4	108617399	0x0000000000000000000000000000000000000000	600404330671500	false	119	200134776890500	2023-08-23T23:32:55.000Z	8805930183182988	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x3332c5e26e5a23e8facc02e653e325432e9c6eb054e5e5e21d0aeb39a6083e30	1
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0x4f6d0ca7e66d5e447862793f23904ba15f51f4de	5	0x57ccc124dcb9109200091cbcf4c89050cc0df908	1	108616481	0x0000000000000000000000000000000000000000	375673884452250	false	24	125224628150750	2023-08-23T23:02:19.000Z	5509883638638052	28491257979823205126001384036080989318975561218829897592679475148759285881305	0x967a435b100f97fafaf86aec77f2f1e6096c8555ff96455529a9597a9d73d977	5
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0xbd2241720848c6bffa8102eb88b05c077a2640ca	33	0x160d2ecef8161c20595f6b21732c6e23bd9bec75	1	108612490	0x0000000000000000000000000000000000000000	75003743802000	false	24586	25001247934000	2023-08-23T20:49:17.000Z	1100054909102861	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x429010dc395d777cad3f246b747b29829c3a66005b8bf77faac2b843defa1f8e	0

Example Query

Query with partition filter

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

SAM_Sold_event

NFT sale events from Sound.xyz music collectibles protocol on Optimism, capturing bonding curve sales with seller addresses, token IDs, payout amounts, and edition contract references. Used for analyzing music NFT trading activity, creator earnings, and bonding curve supply 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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromCurveSupply`	`STRING`	Supply count on the bonding curve before the transaction executed. Numeric string representation.
`in_tokenIds`	`ARRAY<STRING>`	Array of NFT token identifiers sold in the transaction. Numeric string elements representing sequential token IDs from the edition.
`in_totalPayout`	`STRING`	Total amount paid to the seller from the NFT sale transaction. Numeric string representation in wei (smallest denomination of the native token).
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_seller	log_index	in_edition	in_tokenIds	block_number	in_totalPayout	block_timestamp	in_attributionId	transaction_hash	in_fromCurveSupply
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0x6afb361adc741ec7d3ee31d7578ae6acda2568f5	6	0xf03392def590227ad0327ac2a44d5c52a2b39ebe	[“79”]	114590636	3000149752100584	2024-01-09T06:00:49.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xa871c6b627408ead8cfd74542bfbc061d8792705789b27ab51116cccca4a3599	1
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0xd3c45a5b9aea1cd78c7a2527012bc4acec9c8050	39	0xc59cceb481f81d883fa9d501d4464bf47c499c32	[“103”]	109836839	3345028839745536	2023-09-21T05:00:55.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x5030f0378e113e68f11b1986d0a87d83ac2eb7264b81911a6d30aee128d7525c	48
0x2a3a42c653e427f4d44ea47007a99ee6bbae65af	false	0x763d7679deaaa655ba4a940b3a1e4e308076b3cb	185	0xf03392def590227ad0327ac2a44d5c52a2b39ebe	[“4372”,“4373”,“4374”,“4375”,“4376”,“4377”,“4378”,“4379”,“4380”,“4381”]	113926590	30057654558724840	2023-12-24T21:05:57.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x86df4991249516f68a983e230c4de660c37dfae89f05a1b215a90ac9026fb2d5	10

Example Query

Query with partition filter

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

SAMV1_Bought_event

Purchase events from Sound.xyz music NFT marketplace on Optimism, capturing bonding curve-based edition sales with payment breakdowns including artist, platform, affiliate, and golden egg fees for analyzing creator economics 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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenId`	`STRING`	Starting token identifier of the minted NFT range. Numeric string representation indicating the first token ID in the sequence of tokens being minted or purchased.
`in_fromCurveSupply`	`STRING`	Supply count on the bonding curve before the transaction executed. Numeric string representation.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_totalPayment`	`STRING`	Total payment amount for the NFT purchase transaction. Numeric string representation of the amount in wei.
`in_platformFee`	`STRING`	Platform fee charged for the transaction. Numeric string representation of the fee amount in wei.
`in_artistFee`	`STRING`	Fee paid to the artist for the music edition NFT sale. Numeric string representation of the amount in wei.
`in_goldenEggFee`	`STRING`	Fee allocated to the Golden Egg program for the music NFT purchase. Numeric string representation of the amount in wei.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_affiliated`	`BOOL`	Boolean flag indicating whether the transaction involved an affiliate referral.
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_buyer	log_index	in_edition	in_quantity	block_number	in_affiliate	in_artistFee	in_affiliated	in_fromTokenId	in_platformFee	block_timestamp	in_totalPayment	in_attributionId	transaction_hash	in_fromCurveSupply
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0xb1805d6dc2961aa1b3cccf77e034fbf31704d56f	42	0x879a85822a6c6dc84c96b94bceb2f24d2b21a394	1	108132120	0x0000000000000000000000000000000000000000	18575665358250	false	298	700000000000000	2023-08-12T17:56:57.000Z	966251203476874	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xa5f0f888ab6c6a9fa01cb9943035f905a480f3573771b50fbaeef4b46497984c	171
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0xb991175200a225f124c7bb820751411144d03552	44	0x04db718b776d996996cd30dfc7bd891bc94a7694	1	108122398	0x0000000000000000000000000000000000000000	45002246281500	false	10536	700000000000000	2023-08-12T12:32:53.000Z	1345032196701616	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xc6793efaf6d94118a98d43fb3aa6e114895b769ba623df4ee37df97fd9f025f0	0
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0x9aac41b6232558098d887db35ac3463defca3658	34	0x04db718b776d996996cd30dfc7bd891bc94a7694	1	108130369	0x0000000000000000000000000000000000000000	45002246281500	false	10549	700000000000000	2023-08-12T16:58:35.000Z	1345032196701616	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xeadedc3425f0f2388597076b7c7c35e2ebb3fee465d6ec8b16fa7cd5b40a20a4	0

Example Query

Query with partition filter

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

SAMV1_Sold_event

NFT sale events from Sound Protocol SAMV1 (Sound Artist Minting V1) contract on Optimism. Tracks secondary sales with seller addresses, token IDs, edition contracts, payout amounts, and bonding curve supply positions for analyzing music NFT 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_edition`	`STRING`	Contract address of the music edition NFT being minted, bought, or sold. Hex-encoded, 0x-prefixed, 42-character string.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromCurveSupply`	`STRING`	Supply count on the bonding curve before the transaction executed. Numeric string representation.
`in_tokenIds`	`ARRAY<STRING>`	Array of NFT token identifiers sold in the transaction. Numeric string elements representing sequential token IDs from the edition.
`in_totalPayout`	`STRING`	Total amount paid to the seller from the NFT sale transaction. Numeric string representation in wei (smallest denomination of the native token).
`in_attributionId`	`STRING`	Unique identifier linking the transaction to its referral or attribution source. Numeric string representation that can be zero for non-attributed transactions.

Sample Data

address	removed	in_seller	log_index	in_edition	in_tokenIds	block_number	in_totalPayout	block_timestamp	in_attributionId	transaction_hash	in_fromCurveSupply
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0xec060105b57f8b0e9c01a5ef08906ea99f43220a	1	0x5839c928a80bdcdfdce5beff8093cfc33cb76a7a	[“75”]	107727738	5024958683430700	2023-08-03T09:17:33.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x86c04b8c1e4a53f19df9f0157f855f4726d9c4fee6e17a05e5fa381feb9079a9	10
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0xec060105b57f8b0e9c01a5ef08906ea99f43220a	4	0x5839c928a80bdcdfdce5beff8093cfc33cb76a7a	[“76”]	107717252	5000249586834307	2023-08-03T03:28:01.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xa92815a10a7169783308037361c81abf6b1c17157de367c64182d10e1e274fc3	1
0x12a1458b9162dbf50983e72e78e41e37f5bf1a80	false	0xe35bddef8f95e36af834372622301cad72f2d0cf	18	0xab65e3c0d1c08eddef0a966faea35bb31d1dd5c9	[“138”]	107713946	2025557691832832	2023-08-03T01:37:49.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xcfa5f8520e7feb07abb852378077c2621e66f8f08ffda58bc404e1e45d48bb66	16

Example Query

Query with partition filter

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

SoundCreator_SoundEditionCreated_event

Event logs for new music edition NFT deployments on Sound Protocol v2 on Optimism. Records the creation of edition contracts with pricing, timing, and royalty configuration for analyzing artist release activity and minting mechanics.

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_soundEdition`	`STRING`	Contract address of the newly created Sound Edition NFT collection on Optimism. Emitted as part of the SoundEditionCreated event to identify the deployed edition contract.
`in_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
`in_initData`	`STRING`	Initialization data passed to the SoundEdition contract at creation, containing encoded parameters for NFT metadata, pricing, timing, and edition configuration. Hex-encoded bytes string used in contract deployment.
`in_contracts`	`ARRAY<STRING>`	Array of contract addresses involved in the Sound edition creation event, such as minter modules and registry contracts. Typically contains 2-6 addresses representing the various protocol components instantiated during edition deployment.
`in_data`	`ARRAY<STRING>`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_results`	`ARRAY<STRING>`	Array of hex-encoded return values from contract calls executed during Sound edition creation. Contains empty strings (0x) for void functions and encoded data for functions returning values like edition IDs or configuration confirmations.

Sample Data

address	in_data	removed	log_index	in_results	in_deployer	in_initData	block_number	in_contracts	block_timestamp	in_soundEdition	transaction_hash
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f0000000000000000000000001a36729fc276c3649da2cf1eb986d7dabd5d5d990000000000000000000000000000000000000000000000000000000000000002”,“0x1c10893f00000000000000000000000065d21a94c78a5f9ef68a2be141d0c91afc51a7d30000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b0000000000000000000000003fc58265e0212e9e29b4a81d37851e0d2f9af482000000000000000000000000000000000000000000000000000aa87bee538000000000000000000000000000000000000000000000000000000000006491e92300000000000000000000000000000000000000000000000000000000649b23a000000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”,“0xc309c47d0000000000000000000000003fc58265e0212e9e29b4a81d37851e0d2f9af4826147b6eae0ccdaf77b23f8993f2334d98765e0fe4f7fb46d516f39b60baed08100000000000000000000000000000000000000000000000000071afd498d0000000000000000000000000000000000000000000000000000000000006491e8e400000000000000000000000000000000000000000000000000000000649b236400000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”,“0x2ceb70ac0000000000000000000000002a3a42c653e427f4d44ea47007a99ee6bbae65af”,“0x41f6ec4f0000000000000000000000003fc58265e0212e9e29b4a81d37851e0d2f9af482000000000000000000000000000000000000000000000000000aa87bee5380000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000042038c65bb94000000000000000000000000000000000000000000000000000000000000000058100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000028f290f04152a91c69c27db06b682604e081201fd931a8c8bc021e91f2c1b9f048ee025b77802efd356e2b01ebfed9e5a55c9eb1”]	false	29	[“0x”,“0x”,“0x0000000000000000000000000000000000000000000000000000000000000020”,“0x0000000000000000000000000000000000000000000000000000000000000018”,“0x”,“0x”]	0x28f290f04152a91c69c27db06b682604e081201f	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000c417a48cd096067520747607a0331f0e00000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000087790c73b711c873cc2b0bf7d4ee2f9b6db1068e00000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff00000000000000000000000000000000000000000000000000000000649b23a000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000002324400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000054845414c59000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f4333317664626a6837317063324e41684773376b55756874776c7745476b58726778374d7479587a534c5900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f565f2d6b6b354653482d5669494471757a337345697648774e3071414d76474d5673736a6233625163645900000000000000000000000000000000	105673251	[“0x3fc58265e0212e9e29b4a81d37851e0d2f9af482”,“0x3fc58265e0212e9e29b4a81d37851e0d2f9af482”,“0x1a36729fc276c3649da2cf1eb986d7dabd5d5d99”,“0x65d21a94c78a5f9ef68a2be141d0c91afc51a7d3”,“0x3fc58265e0212e9e29b4a81d37851e0d2f9af482”,“0x2a3a42c653e427f4d44ea47007a99ee6bbae65af”]	2023-06-16T19:54:39.000Z	0x3fc58265e0212e9e29b4a81d37851e0d2f9af482	0x75c6177d1f524ff30780c8fc32dfee75fdd15e662598f1974e94bee0c6da616a
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f0000000000000000000000001a36729fc276c3649da2cf1eb986d7dabd5d5d990000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b00000000000000000000000073209ee937173bda063c3894679526b20f6f7e6900000000000000000000000000000000000000000000000000038d7ea4c6800000000000000000000000000000000000000000000000000000000000648d52e800000000000000000000000000000000000000000000000000000000648d52e900000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000a800000000000000000000000000000000000000000000000000000000000000a80000000000000000000000000000000000000000000000000000000000000001”]	false	16	[“0x”,“0x000000000000000000000000000000000000000000000000000000000000001f”]	0x107720be62963cbafa38b2c4454c21c51d218e0a	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000c417a48cd096067520747607a0331f0e00000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000260000000000000000000000000107720be62963cbafa38b2c4454c21c51d218e0a00000000000000000000000000000000000000000000000000000000000003e800000000000000000000000000000000000000000000000000000000000000a800000000000000000000000000000000000000000000000000000000000000a800000000000000000000000000000000000000000000000000000000648d52e900000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000023454d504952452028427265616b626561742041706f63616c797073652052656d69782900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008454d504952454242000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f64724d697965456d495a416a35516e615a2d43534756374143625268447a6e484e64506a4663455154597700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f72646651544c326d7279306c51386b4a4f5435676b57446f614c4b6b4b4d51514837643573316a4334453800000000000000000000000000000000	105647932	[“0x73209ee937173bda063c3894679526b20f6f7e69”,“0x1a36729fc276c3649da2cf1eb986d7dabd5d5d99”]	2023-06-16T05:50:41.000Z	0x73209ee937173bda063c3894679526b20f6f7e69	0xda14b1c6c8bd84ecfb75110ab36912ed566d3c4984bd16ff2aa9b7d2fd76f3c4
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b000000000000000000000000f89dde7c60e7f9db525a600b993d711c1ac0d0b000000000000000000000000000000000000000000000000000005af3107a40000000000000000000000000000000000000000000000000000000000064cd20800000000000000000000000000000000000000000000000000000000064dfc6b800000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”]	false	17	[“0x”,“0x0000000000000000000000000000000000000000000000000000000000000270”]	0x08054020cabfe02365109aea5737fb0d5ffc3a76	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000c417a48cd096067520747607a0331f0e00000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000008054020cabfe02365109aea5737fb0d5ffc3a7600000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000064dfc6b80000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000f547269676765722054686572617079000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000085452475448525059000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f736b50574b6f5552457757334c7233564a69544d6278784d566d714a75444639797a6d596135505467597700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f377a4e2d454653564d664b657141443274525171306a6832314e456d6861536a41497852433735646c6c6f00000000000000000000000000000000	107754218	[“0xf89dde7c60e7f9db525a600b993d711c1ac0d0b0”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”]	2023-08-04T00:00:13.000Z	0xf89dde7c60e7f9db525a600b993d711c1ac0d0b0	0x901307a7f4dffb7bc26f26dfe3f653f43350a96ab55924c49e3d38a962daa5af

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MerkleDropMinter_Minted_event

MerkleDropMinterV1_Minted_event

RangeEditionMinter_Minted_event

RangeEditionMinterV1_Minted_event

SAM_Bought_event

SAM_Sold_event

SAMV1_Bought_event

SAMV1_Sold_event

SoundCreator_SoundEditionCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MerkleDropMinter_Minted_event

​MerkleDropMinterV1_Minted_event

​RangeEditionMinter_Minted_event

​RangeEditionMinterV1_Minted_event

​SAM_Bought_event

​SAM_Sold_event

​SAMV1_Bought_event

​SAMV1_Sold_event

​SoundCreator_SoundEditionCreated_event

Tables

MerkleDropMinter_Minted_event

MerkleDropMinterV1_Minted_event

RangeEditionMinter_Minted_event

RangeEditionMinterV1_Minted_event

SAM_Bought_event

SAM_Sold_event

SAMV1_Bought_event

SAMV1_Sold_event

SoundCreator_SoundEditionCreated_event