sound_v2_ethereum

Tables

Artist_EditionCreated_event

Music NFT edition creation events from Sound Protocol v2 on Ethereum. Tracks edition parameters including price (0.1 ETH typical), quantity minted, royalty basis points (1000 BPS = 10%), and funding recipient addresses for analyzing artist drop configurations.

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_editionId`	`STRING`	Unique identifier for the edition within the artist contract. Numeric string representation starting from 1.
`in_fundingRecipient`	`STRING`	Ethereum address designated to receive the sales proceeds from this edition. Typically the artist’s wallet or a payment splitter contract.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_royaltyBPS`	`STRING`	Royalty percentage for secondary sales expressed in basis points (BPS), where 10000 equals 100%. Typically set to 1000 (10%) based on sample values.
`in_startTime`	`STRING`	Start timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_endTime`	`STRING`	End timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.

Sample Data

address	removed	in_price	log_index	in_endTime	in_quantity	block_number	in_editionId	in_startTime	in_royaltyBPS	block_timestamp	transaction_hash	in_fundingRecipient
0x87853a0b58f2c36feaf0f9183953d9319e598c16	false	100000000000000000	397	4294967295	25	13882231	1	1640642400	1000	2021-12-26T17:46:16.000Z	0x1f09acd9eb12d3d56d0d1d413ba67c5256c2eb820d644193eafb38c842fdbeec	0xa838829224da02187bf5983f280f8f3abe5fda06
0xe8efaa0060e5382a7a50047d56dadcf0769f1ad8	false	100000000000000000	847	4294967295	25	13800168	1	1639519200	1000	2021-12-14T00:37:59.000Z	0x7f39905a411ea58d3af55adea41c4eb45a6839d8ccce1fa5c3f5a68a6fbf5362	0x51761d3cf3d6c954e5016ccf6f67f2d3a7749459
0xc5d82e66edfbf01b952f5cb36793fd0ddc38a601	false	100000000000000000	154	4294967295	25	13806312	1	1639605600	1000	2021-12-14T23:43:15.000Z	0x2bf06117104498311e321124a0d02e270278cc77f38aef1167564ab5ce3e05ae	0x4e29d8fbcb1b92c37077adc4f18571c5d786d3bd

Example Query

Query with partition filter

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

Artist_EditionPurchased_event

Edition purchase events from Sound Protocol v2 on Ethereum, tracking NFT music edition sales with buyer addresses, cumulative sale counts, and minted token IDs. Used for analyzing artist sales velocity and collector behavior in the music NFT marketplace.

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_editionId`	`STRING`	Unique identifier for the edition within the artist contract. Numeric string representation starting from 1.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_numSold`	`STRING`	Cumulative count of editions sold from this artist’s collection at the time of this purchase event. Increments sequentially with each sale, starting from 1 for the first purchase.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_buyer	log_index	in_numSold	in_tokenId	block_number	in_editionId	block_timestamp	transaction_hash
0x23aa7060d0a966edeb298e645da304911e7157c1	false	0x40402322ecb6c61610b9ad2cf889792c5e2295b2	56	1	340282366920938463463374607431768211457	14611604	1	2022-04-18T21:33:19.000Z	0xd5243a4dc127cacd0688cef9b8be456c099603be54171caec9c17c698988705c
0x23aa7060d0a966edeb298e645da304911e7157c1	false	0x37039e0fed64f3114864ecb5f74232d626e3c07d	82	2	340282366920938463463374607431768211458	14611604	1	2022-04-18T21:33:19.000Z	0x5f0a7e7eb607f3db251fa8bc611d5320d255260b2eef4da05bca02461e972de2
0x23aa7060d0a966edeb298e645da304911e7157c1	false	0x6399532a408efe7813c22dba7900400471e0b88d	86	3	340282366920938463463374607431768211459	14611604	1	2022-04-18T21:33:19.000Z	0xaa06d5bc8e67cd9205c5e44853f711fe1cce1a4dc1fdb1406c15024a20f5c096

Example Query

Query with partition filter

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

ArtistCreator_CreatedArtist_event

Artist profile creation events from Sound Protocol v2 on Ethereum, capturing when new musicians join the platform with their assigned contract address, symbol, and unique artist ID. Used for tracking artist onboarding activity and protocol growth metrics.

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_artistId`	`STRING`	Platform-assigned unique identifier for the artist within the Sound protocol ecosystem. Typically starts from ‘0’ for new artists and increments sequentially, though some artists may be assigned specific numeric IDs.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_artistAddress`	`STRING`	Contract address of the newly created artist token on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20-compatible artist contract deployed through Sound Protocol.

Sample Data

address	in_name	removed	in_symbol	log_index	in_artistId	block_number	block_timestamp	in_artistAddress	transaction_hash
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	San Holo	false	SANHOLO	232	0	15195384	2022-07-22T23:18:13.000Z	0xdf1f9ca3acebd5f830499270b9ae323b93889da8	0xe63207f4475cec5fa0c131a1427a65a8029349e03407cce5d7342d15d43b9f3d
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	Charm Taylor	false	CHARM	382	0	15509833	2022-09-10T16:44:18.000Z	0xffcf0f0ce6c72ae208a2002f286d37b26e4275de	0x2dd4f39b0208f618c460352c5646c4b37cb34fe291f695ff6939aa2c47318e38
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	SLOE JACK	false	SLOEJACK	441	43	14148707	2022-02-05T22:34:57.000Z	0x869f8a4bad7cfc932f692af09645f263ee538a89	0x8afd38251641318e9b1cf1f6bad0e8f7d97a5b9b334017e79b5c7967ba43f195

Example Query

Query with partition filter

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

ArtistCreatorV2_CreatedArtist_event

Artist profile creation events from Sound.xyz music NFT platform on Ethereum. Contains artist registration data including name, ticker symbol, wallet address, and unique artist ID for tracking creator onboarding and identity.

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_artistId`	`STRING`	Platform-assigned unique identifier for the artist within the Sound protocol system. Sequential numeric IDs issued as strings, starting from 0 and incrementing with each new artist registration.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_artistAddress`	`STRING`	Contract address of the artist’s token on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the deployed artist contract created by Sound protocol’s ArtistCreatorV2.

Sample Data

address	in_name	removed	in_symbol	log_index	in_artistId	block_number	block_timestamp	in_artistAddress	transaction_hash
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	Jesse Boykins III	false	JBIII	142	20	13903014	2021-12-29T22:44:33.000Z	0xa7ff114a6ba8b9646a2c20690a75e460b51eff73	0xe59cd93dbd9895b3e152190c8e82546d1bb89db35659bdb00b885897bcbbad04
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	Domino	false	DOMINO	263	0	14981534	2022-06-17T22:07:40.000Z	0x24bb48e27c98202909196e809cf071bd97a4ada0	0x2f021ec783fd6d004a2465933438bc78059c88d1d32409b4618b81d2d798d316
0x78e3adc0e811e4f93bd9f1f9389b923c9a3355c2	Pauline Herr	false	PH	72	23	13981653	2022-01-11T02:59:10.000Z	0xe8a190328f48246eb0fdbd85b71aad0f58fe06bd	0x2c58c23b3be8945dcedbf408fcf2fdce9ea667064af1d96222cfe8caf3840329

Example Query

Query with partition filter

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

ArtistV1_EditionCreated_event

Edition creation events from Sound Protocol V2 on Ethereum, capturing music NFT release configurations including pricing (0.05-0.1 ETH typical), quantity limits, sale windows, and 10% royalty settings (1000 basis points). Used for analyzing artist release strategies and edition economics on the Sound music NFT 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_editionId`	`STRING`	Unique identifier for the edition within the artist contract. Numeric string representation starting from 1.
`in_fundingRecipient`	`STRING`	Ethereum address that will receive the proceeds from sales of this edition. Typically the artist’s wallet or a designated payment recipient for the NFT collection.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_royaltyBPS`	`STRING`	Royalty percentage for secondary sales expressed in basis points (BPS), where 10000 equals 100%. Sample values of 1000 indicate a 10% royalty on resales.
`in_startTime`	`STRING`	Start timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_endTime`	`STRING`	End timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_permissionedQuantity`	`STRING`	Number of edition tokens reserved for permissioned minting, accessible only to addresses with special allowlist or signing privileges. Typically equals or exceeds the public quantity allocation based on sample values.
`in_signerAddress`	`STRING`	Address authorized to sign mint requests for this edition. Remains constant across editions at 0xa66cdda1817c85ed3d232a5affd17673e933d8a7 based on sample data.

Sample Data

address	removed	in_price	log_index	in_endTime	in_quantity	block_number	in_editionId	in_startTime	in_royaltyBPS	block_timestamp	in_signerAddress	transaction_hash	in_fundingRecipient	in_permissionedQuantity
0xb4dac5809d75daa5091de62175c6bb36dac624a3	false	80000000000000000	17	4294967295	10	14924331	2	1655170481	1000	2022-06-08T02:40:18.000Z	0xa66cdda1817c85ed3d232a5affd17673e933d8a7	0x19c4468e1dc9ef2c299835cfda9b75cd9278cc3cd41abb049a88f42e2564f453	0x93bb3dc705fb2ad98b696bcc17a0fb7d439d12f4	25
0xd5d0bb6b5e6dd29055271b5ea9d2d746c66ce98d	false	100000000000000000	189	4294967295	50	14564016	3	1650398611	1000	2022-04-11T11:00:28.000Z	0xa66cdda1817c85ed3d232a5affd17673e933d8a7	0x32d0f9a7a44b3e695d7aacd43cb2f25e61a4105101ec27bb8491b1c672df871e	0xe43c5133f66f58fe5ac8f9000aae020fbb9b0f85	50
0xc4c26501a5251d89a192fb6564df476e000fe211	false	100000000000000000	130	4294967295	50	14563620	2	1650225815	1000	2022-04-11T09:32:05.000Z	0xa66cdda1817c85ed3d232a5affd17673e933d8a7	0x6adf10d99d9484b71b763c1bacfdf60dbaf7449b835e0d52ef18a736b55102e8	0xa86cd47b4016a8b7c37040ad80183ed7170e1d99	50

Example Query

Query with partition filter

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

ArtistV1_EditionPurchased_event

Edition purchase events from Sound protocol’s ArtistV1 contract on Ethereum, tracking NFT music edition sales with buyer addresses, edition identifiers, sequential ticket numbers, and cumulative sold counts. Used for analyzing music NFT mint activity, collector behavior, and edition sellout 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_editionId`	`STRING`	Unique identifier for the edition within the artist contract. Numeric string representation starting from 1.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_numSold`	`STRING`	Cumulative count of edition tokens sold up to and including this purchase transaction. Represents the running total of sales for this edition ID at the time of this specific purchase event.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_ticketNumber`	`STRING`	Sequential ticket number assigned to this specific NFT purchase within the edition. Increments with each sale to track individual NFT identities within the limited edition collection.

Sample Data

address	removed	in_buyer	log_index	in_numSold	in_tokenId	block_number	in_editionId	block_timestamp	in_ticketNumber	transaction_hash
0x53af4705e25e0eea416ffb470a3cad970b4fe66b	false	0x446d8d058af53553b858e982be5c6a3bc9d41ed1	606	1	340282366920938463463374607431768211457	14769667	1	2022-05-13T21:04:31.000Z	6	0xb5587e1905792f9d911a1791e00398d4fdc37af32d99e7d3c39b5394326c117e
0x53af4705e25e0eea416ffb470a3cad970b4fe66b	false	0xdbfadb1c177f42ac09ab9a7294b6356ba0891ee6	629	2	340282366920938463463374607431768211458	14769667	1	2022-05-13T21:04:31.000Z	15	0x1fde130c003ec6700a42d5c80ad4ea825132881cf83151c12fd65b82fa3866a6
0x53af4705e25e0eea416ffb470a3cad970b4fe66b	false	0xd6fc40daacaa29f6ab145b37c22e6ab0a4f51f61	784	3	340282366920938463463374607431768211459	14769667	1	2022-05-13T21:04:31.000Z	10	0x2e43af28a94fe6f185165260e6e22ed1507d648e791601b3c2678169fb0c0963

Example Query

Query with partition filter

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

Creator_SoundEditionCreated_event

NFT music edition deployment events from Sound Protocol v2 on Ethereum. Records edition contract addresses, deployer accounts, initialization parameters, and configured minting modules for analyzing creator launches and platform adoption.

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 on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the deployed music 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 Sound Edition contract during deployment. Hex-encoded calldata containing configuration parameters like metadata URIs, minting prices, and edition settings.
`in_contracts`	`ARRAY<STRING>`	Array of contract addresses called during the Sound edition creation process. Typically contains module contracts for pricing, minting mechanics, and metadata configuration.
`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 return values from contract calls executed during Sound edition creation, typically containing transaction identifiers or success indicators. Each hex-encoded value corresponds to the result of a contract interaction in the in_contracts and in_data arrays.

Sample Data

address	in_data	removed	log_index	in_results	in_deployer	in_initData	block_number	in_contracts	block_timestamp	in_soundEdition	transaction_hash
0xaef3e8c8723d9c31863be8de54df2668ef7c4b89	[“0x1c10893f00000000000000000000000065c25fadd9b88df5c8c101a3b99a5d614b7085960000000000000000000000000000000000000000000000000000000000000002”,“0x1c10893f000000000000000000000000eae422887230c0ffb91fd8f708f5fdd354c92f2f0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b000000000000000000000000cdf64b312d4fa4598af4cd7856c3107b505eae2000000000000000000000000000000000000000000000000000071afd498d000000000000000000000000000000000000000000000000000000000000640e56520000000000000000000000000000000000000000000000000000000064124a6c00000000000000000000000000000000000000000000000000000000ffffffff000000000000000000000000000000000000000000000000000000000000020f0000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”,“0xc309c47d000000000000000000000000cdf64b312d4fa4598af4cd7856c3107b505eae2051357f72c6fdbdba8938b756268f82b11874f695018264a08a0d92c1be62eb4100000000000000000000000000000000000000000000000000038d7ea4c6800000000000000000000000000000000000000000000000000000000000640a33b800000000000000000000000000000000000000000000000000000000640e5652000000000000000000000000000000000000000000000000000000000000020f000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”]	false	218	[“0x”,“0x”,“0x000000000000000000000000000000000000000000000000000000000000039b”,“0x00000000000000000000000000000000000000000000000000000000000002c5”]	0x2fffcfd0fe423750b4cdd3630e3cb631dbc8c46b	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000e311e941d49dbf1747e8531209f4d3f4c49f5ea000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002400000000000000000000000008e9b9def32f375cc7e0162b470a81e4c0ed4ee8a00000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000064124a6c00000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000008436173686d65726500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000054633563352000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f79336a41326a714b6d504b6b3157643152516e586f4136455934646a5831714b416b4c42486b445a576e3000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f6a5775414644456f776d4d797068656d74444a6875646c737773594d49596751595a635f7352574352693000000000000000000000000000000000	16788255	[“0xcdf64b312d4fa4598af4cd7856c3107b505eae20”,“0xcdf64b312d4fa4598af4cd7856c3107b505eae20”,“0x65c25fadd9b88df5c8c101a3b99a5d614b708596”,“0xeae422887230c0ffb91fd8f708f5fdd354c92f2f”]	2023-03-09T04:24:59.000Z	0xcdf64b312d4fa4598af4cd7856c3107b505eae20	0x8c9f777aeef1526eacfb35f6539579bcb1cf701613ea1b197c4bc836e965080d
0xaef3e8c8723d9c31863be8de54df2668ef7c4b89	[“0x1c10893f00000000000000000000000065c25fadd9b88df5c8c101a3b99a5d614b7085960000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b000000000000000000000000e61ddc1ea5444aa5a63cc4e15a4ecd84d85fd7c90000000000000000000000000000000000000000000000000011c37937e08000000000000000000000000000000000000000000000000000000000006413992600000000000000000000000000000000000000000000000000000000641a2fe800000000000000000000000000000000000000000000000000000000ffffffff000000000000000000000000000000000000000000000000000000000000020f0000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”]	false	287	[“0x”,“0x000000000000000000000000000000000000000000000000000000000000039c”]	0x4960d7fa12b034ae57de64e8eba55d107cb11f7d	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000e311e941d49dbf1747e8531209f4d3f4c49f5ea000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002400000000000000000000000004960d7fa12b034ae57de64e8eba55d107cb11f7d00000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000019000000000000000000000000000000000000000000000000000000007fffffff00000000000000000000000000000000000000000000000000000000641a2fe80000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000d4d792043616c69666f726e6961000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006534a43414c490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f5a2d61616f7743314b794b6e61724a36422d5046435471346434422d44377051374b624834763675376d7700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f7555536267746e732d72794d667a68454d464b31734f696254795368503079707747596332637a3346345900000000000000000000000000000000	16791958	[“0xe61ddc1ea5444aa5a63cc4e15a4ecd84d85fd7c9”,“0x65c25fadd9b88df5c8c101a3b99a5d614b708596”]	2023-03-09T16:52:35.000Z	0xe61ddc1ea5444aa5a63cc4e15a4ecd84d85fd7c9	0xf66b23bfa2d7461b76ca7458fea09c7673b97a0b15c926013c9fd541937c376a
0xaef3e8c8723d9c31863be8de54df2668ef7c4b89	[“0x1c10893f00000000000000000000000065c25fadd9b88df5c8c101a3b99a5d614b7085960000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b0000000000000000000000000a12a9355aed609bbd8c252e7b4da1946d071cf4000000000000000000000000000000000000000000000000002386f26fc1000000000000000000000000000000000000000000000000000000000000640b93ee0000000000000000000000000000000000000000000000000000000064122ac800000000000000000000000000000000000000000000000000000000ffffffff000000000000000000000000000000000000000000000000000000000000020f000000000000000000000000000000000000000000000000000000000000001900000000000000000000000000000000000000000000000000000000000000190000000000000000000000000000000000000000000000000000000000000005”]	false	324	[“0x”,“0x000000000000000000000000000000000000000000000000000000000000039e”]	0x1f1228c858cb8c842333b697e3285b53f3ae2548	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000003ca50e8da8c3d359fc934aea0161f5346ccb62a100000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002400000000000000000000000001f1228c858cb8c842333b697e3285b53f3ae254800000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000001900000000000000000000000000000000000000000000000000000000000000190000000000000000000000000000000000000000000000000000000064122ac800000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000009737472616e676572730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000542454e4e59000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f33383275656e6b704b79335035736a354a337a616e4e5f525367386445463436504a7a457076684d4a597300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f42306e644b5662345472664359614e2d635a78785963305447557a4b5350586e304e316b6470736e57785500000000000000000000000000000000	16793598	[“0x0a12a9355aed609bbd8c252e7b4da1946d071cf4”,“0x65c25fadd9b88df5c8c101a3b99a5d614b708596”]	2023-03-09T22:25:47.000Z	0x0a12a9355aed609bbd8c252e7b4da1946d071cf4	0x2620cddf85794b6eae71bb20cd103ff03ef8467511af9632b9b69a14ae5f9680

Example Query

Query with partition filter

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

MerkleDropMinter_Minted_event

NFT mint events from Sound.xyz’s MerkleDropMinter contract on Ethereum, capturing music NFT edition purchases with buyer addresses, token IDs, quantities, and fee breakdowns (platform and affiliate). Used for analyzing Sound protocol minting activity, revenue distribution, and affiliate program 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.

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
0xeae422887230c0ffb91fd8f708f5fdd354c92f2f	false	0x46dac7412752e7567c941e8233f9bd647a0e46be	587	282	0xc0a5628785713673b4bf3b8a0cc954a3e9eda1da	1	16455721	0x0000000000000000000000000000000000000000	false	2	500000000000000	2023-01-21T14:17:47.000Z	0xa8d664c6e99421393d69869eb17c444b1bcb7b369d6e3891ed958c8113d15264	10000000000000000
0xeae422887230c0ffb91fd8f708f5fdd354c92f2f	false	0x7f1c1907bbeb8fd7a926834546d1f056dde01b32	587	299	0xc0a5628785713673b4bf3b8a0cc954a3e9eda1da	1	16458375	0x0000000000000000000000000000000000000000	false	3	500000000000000	2023-01-21T23:10:35.000Z	0xc16d77f6f68b596e8b72348a64b10e66bf8c1f2eaae97bec74f8917a44d1dae1	10000000000000000
0xeae422887230c0ffb91fd8f708f5fdd354c92f2f	false	0xb2ea3889506327db2defb9554752d211f8e2a366	587	124	0xc0a5628785713673b4bf3b8a0cc954a3e9eda1da	1	16455202	0x0000000000000000000000000000000000000000	false	1	500000000000000	2023-01-21T12:33:59.000Z	0x38f0be9e00022e3bfbfe3f52383f69521a3377c41dcdf21f8e041965d18bfff8	10000000000000000

Example Query

Query with partition filter

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

MerkleDropMinterBankless_Minted_event

NFT minting events from Sound.xyz’s MerkleDropMinterBankless contract on Ethereum, recording edition purchases with buyer addresses, token IDs, quantities, ETH payment amounts, and optional affiliate fee data. Used for analyzing Sound protocol music NFT sales and tracking Bankless-affiliated minting campaigns.

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.

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	in_requiredEtherValue
0xda4b6fbb85918700e5ee91f6ce3cc2148af02912	false	0xaba49c1098cc0fa65bf2393822ae8a350019f374	15	502	0x85eff19b724b2085e6938259169daabcad1cac96	1	16870830	0x0000000000000000000000000000000000000000	false	10	2023-03-20T19:01:11.000Z	0xbbec8adfdd176c6dbe19f510adcf2cce3e0bf687c3845764d9605a5cc94a0601	50000000000000000
0xda4b6fbb85918700e5ee91f6ce3cc2148af02912	false	0x2d50ae0ad5b79c861b8cad5982bdcdf66376ac4b	15	376	0x85eff19b724b2085e6938259169daabcad1cac96	1	16870830	0x0000000000000000000000000000000000000000	false	9	2023-03-20T19:01:11.000Z	0xfdd870750aa14960f9b373956cd83e9bb2f36541c72ff5e02434cba00c74db26	50000000000000000
0xda4b6fbb85918700e5ee91f6ce3cc2148af02912	false	0x05a13dcf55ea6d532f15284f39e02811fc183a8a	15	224	0x85eff19b724b2085e6938259169daabcad1cac96	1	16871103	0x0000000000000000000000000000000000000000	false	40	2023-03-20T19:56:11.000Z	0xb67eca19f134b26fc6f7da4f2e07a240a90f5cebd8c60af68a2f31951c8e742a	50000000000000000

Example Query

Query with partition filter

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

MerkleDropMinterBonfire_Minted_event

NFT mint events from Sound.xyz’s MerkleDropMinter contract on Ethereum, tracking music edition purchases with buyer addresses, quantities, token IDs, and platform/affiliate fee splits. Enables analysis of Sound protocol revenue distribution and music NFT 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_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.

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
0x10cc86404d619f8c3961f4ec5fed80fec2b07b4d	false	0x73049572cd23836b1a1822edddf245e8f0888fd5	5	223	0x9bad271a443a74595bb84dfb1f779ffc894cbb8b	1	16721876	0x7acc1f792556a1dff2bab8c7c51342f2be49be7f	true	1	1500000000000000	2023-02-27T20:21:47.000Z	0x366e21cfc864eaa80de8785124c2087335a529c3ce8af492b340e140f9cddd70	30000000000000000
0x10cc86404d619f8c3961f4ec5fed80fec2b07b4d	false	0x11b4e83bc3e9605f03e2a4c34bd09567be5aebbe	0	167	0x5855ebdc37f15abaa966eaef42e74bb3e3dba41c	1	16565931	0x7acc1f792556a1dff2bab8c7c51342f2be49be7f	true	1	5000000000000	2023-02-05T23:41:47.000Z	0x06a79216724f011f84d918e320afd6f61274f059b2ca83966d47127c1b3d390b	100000000000000
0x10cc86404d619f8c3961f4ec5fed80fec2b07b4d	false	0x4c72e2fba571176b111b2095b9479ce5b8572a1f	9	328	0x223f801b71c3e800e1bffcb565247274a2d5b8b1	1	17331394	0x0000000000000000000000000000000000000000	false	3	0	2023-05-24T20:22:35.000Z	0x606a25f51756b7e71b8a5abd7ac3fc4f51826c8718db3100fd2ba6d32f700a75	10000000000000000

Example Query

Query with partition filter

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

MerkleDropMinterInvinMusic_Minted_event

NFT mint events from Sound.xyz’s MerkleDropMinter contract for InvinMusic editions on Ethereum, capturing buyer addresses, token quantities, edition contracts, and payment details including platform and affiliate fees.

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.

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	in_requiredEtherValue
0x3950009ccef646fb44e8806fcf1669de816b0030	false	0x90876256884227ca24babf9109b27c6d0c4a47ea	12	196	0x8fae04d5b26eb507525e15a3981ddebc9fc302bc	5	17228064	0x0000000000000000000000000000000000000000	false	29	2023-05-10T05:55:23.000Z	0x3429e7da6bf0ab67def81954e38635aba67d00f110c9cc5fe17d469514c80755	10000000000000000
0x3950009ccef646fb44e8806fcf1669de816b0030	false	0xb612ec3909f4ba5bda1afe0fe99f4564fa83ac17	15	1029	0x50832fd7385e540ba2a821e9b50478c47b2ab046	1	17222049	0x0000000000000000000000000000000000000000	false	17	2023-05-09T09:37:35.000Z	0x441ef8d8cfca574754469ee2c84e5c9b6a0ce29f3a1bdfed9f5d1017c15feac9	50000000000000000
0x3950009ccef646fb44e8806fcf1669de816b0030	false	0xb031bd1e477a1e9666071dae0c5c035b8912bc0d	15	97	0x50832fd7385e540ba2a821e9b50478c47b2ab046	1	17220829	0x0000000000000000000000000000000000000000	false	15	2023-05-09T05:31:11.000Z	0xba638be44fe5e1b2ecb235113ce87e43ce112b2c38ed21cb3a8ae507205b0d0d	50000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sound_v2_ethereum.MerkleDropMinterInvinMusic_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 Ethereum, capturing edition purchases with quantity, pricing, and affiliate tracking. Used for analyzing music NFT sales patterns, platform fee revenue, and referral attribution across Sound’s creator ecosystem.

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
0xc025b29469b651a2c85bdda533664c92968533f3	false	0xc3af8efe3c865b8363a79b13b27db530eb5d24af	13	200	0x960ef9988439f9c3488282aaf89ff94a6f0b592d	1	17301215	0x0000000000000000000000000000000000000000	false	326	125000000000000	2023-05-20T14:25:23.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x68a5eb8b2a24bbcc29044122c933fc9a1af63252827ab212d0497b7a9de5f8e5	2500000000000000
0xc025b29469b651a2c85bdda533664c92968533f3	false	0x8bf2ffc89c70efbe245aa81cc597c7e359925d61	13	419	0x960ef9988439f9c3488282aaf89ff94a6f0b592d	1	17301044	0x0000000000000000000000000000000000000000	false	325	125000000000000	2023-05-20T13:50:47.000Z	0	0x1f5349f5533e9ea2daf6c63b8f3a775a2828c4d7f376a6d53eaf5aa10f0129ff	2500000000000000
0xc025b29469b651a2c85bdda533664c92968533f3	false	0xcddf6531cd48936fc850e51b95a3d3d966beb43d	13	402	0x960ef9988439f9c3488282aaf89ff94a6f0b592d	1	17299360	0x0000000000000000000000000000000000000000	false	324	125000000000000	2023-05-20T08:09:59.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x5d2fe16b7626ef58d8c3abdfe0b024c5e9b0947001e52a03988feaee1e649226	2500000000000000

Example Query

Query with partition filter

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

MerkleDropMinterV2_Minted_event

Minted event records from Sound Protocol’s MerkleDropMinterV2 contract on Ethereum, capturing music NFT edition purchases with buyer addresses, quantities, token IDs, and fee breakdowns including platform and affiliate fees. Used for analyzing Sound’s music NFT sales, pricing dynamics, and referral program effectiveness.

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
0x64f877c44364f840e676fc19cf1711ef95b57bf5	false	0xaeb7ad5a15f01cf3974a0a7be48e4a560fda664c	19	102	0x240747f386bfe1ba1c15ff3e43ad7696a6682df7	4	18073774	0x0000000000000000000000000000000000000000	false	22	700000000000000	2023-09-06T00:14:35.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x6d33465d93bbaacfb1c9b02c5f32390c10d777f319101788202927d006f7b1b0	17500000000000000
0x64f877c44364f840e676fc19cf1711ef95b57bf5	false	0x24a0e4ee348f33252e83fe1e824499381dd21aa9	22	657	0x35caec65f1b8637c1f92e128fe7304c6ee58dba4	1	18232832	0x0000000000000000000000000000000000000000	false	9	700000000000000	2023-09-28T07:44:59.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x3a67aa95f3f5fe7a512dd34ca1907806b0d8f6a4397b29e0ffc780509109335e	9700000000000000
0x64f877c44364f840e676fc19cf1711ef95b57bf5	false	0xf79c8e6bb5cca36a9edc01bc8b6412ace154f3eb	10	220	0x8b91cf24c27258e281564170f734807690b1f0d6	1	17865514	0x0000000000000000000000000000000000000000	false	1	700000000000000	2023-08-07T20:44:11.000Z	0	0x91ca51b9a4a4b5c08b4db7cf387e53ea529e4beaa9e6c57827e2a6991489f7d3	800000000000000

Example Query

Query with partition filter

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

RangeEditionMinter_Minted_event

NFT mint events from Sound.xyz v2 Range Edition minting contract on Ethereum, capturing buyer addresses, quantities, token IDs, and fee breakdowns (platform and affiliate fees in wei). Used for analyzing music NFT sales activity and affiliate referral 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.

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
0x65c25fadd9b88df5c8c101a3b99a5d614b708596	false	0x4df655fb805e0a8ac2dfb92f187bc0ed0c6d0914	745	220	0xa6c4df945dbb1d71fe9a8d71ae93b8d5c2bbebe4	1	16552642	0x0000000000000000000000000000000000000000	false	3557	210000000000000	2023-02-04T03:08:47.000Z	0x1dc7b41d1be3f693140e2f6da84c852298403d5c7cc10547ca418d45826ae1e1	4200000000000000
0x65c25fadd9b88df5c8c101a3b99a5d614b708596	false	0x9b0c89b9e698aa887ee51af06ef63dbfbde2badc	745	154	0xa6c4df945dbb1d71fe9a8d71ae93b8d5c2bbebe4	1	16552271	0x0000000000000000000000000000000000000000	false	3365	210000000000000	2023-02-04T01:54:23.000Z	0x3a76930bc881f32a656128e584873cd873738a0a1aae84c24d90ed9d069eba4b	4200000000000000
0x65c25fadd9b88df5c8c101a3b99a5d614b708596	false	0x9538fd48f3c658cbd625c6fcb462926ced08e7a5	745	929	0xa6c4df945dbb1d71fe9a8d71ae93b8d5c2bbebe4	1	16554955	0x0000000000000000000000000000000000000000	false	4500	210000000000000	2023-02-04T10:55:23.000Z	0xf4fe98fa511b98a167da9d4d3df026b9390109bbf09cc141b4b8c08a304d7fad	4200000000000000

Example Query

Query with partition filter

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

RangeEditionMinterBankless_Minted_event

NFT mint events from Sound.xyz’s RangeEditionMinter contract for Bankless editions on Ethereum, tracking individual purchases with buyer addresses, token IDs, quantities, ETH costs, and affiliate attribution. Used for analyzing mint activity, affiliate performance, and primary sales revenue across Bankless music NFT drops.

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.

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	in_requiredEtherValue
0x4552f8b70a72a8ea1084bf7b7ba50f10f2f9daa7	false	0x3839acf1ee7699d1f46b1be840d8ad8317fdf757	4	145	0x4bddca6edd01e9b69f61016d7d2e4220c6e85a53	1	16427355	0x7acc1f792556a1dff2bab8c7c51342f2be49be7f	true	1	2023-01-17T15:15:23.000Z	0x9a1f1fbc1ea4ca03e22d9e6e3ad30f3e8724bc12b5ffa72d4128f6a85be06c16	100000000000000
0x4552f8b70a72a8ea1084bf7b7ba50f10f2f9daa7	false	0x2487fc7e019860afbfc7fb16689e421843c777e2	11	207	0x14d7b5aa6de2472af82abbe435fc0ce95fab9c60	1	16572656	0x7acc1f792556a1dff2bab8c7c51342f2be49be7f	true	68	2023-02-06T22:12:59.000Z	0x08ace8708f2215d416a5861e35f03081f081748472e64d95782c49bd611fa346	70000000000000000
0x4552f8b70a72a8ea1084bf7b7ba50f10f2f9daa7	false	0xc075de56a56d4f1248c3de4e3c045dc4912390c1	11	316	0x14d7b5aa6de2472af82abbe435fc0ce95fab9c60	1	16572675	0x7acc1f792556a1dff2bab8c7c51342f2be49be7f	true	72	2023-02-06T22:16:47.000Z	0xdd14600bd9fea477e1d7f9237c84f4f676631c1e2f204c8ea265503242a554ff	70000000000000000

Example Query

Query with partition filter

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

RangeEditionMinterBonfire_Minted_event

NFT edition mint events from Sound.xyz’s Range Edition Minter contract on Ethereum, tracking buyer addresses, token IDs, quantities, and fee structures (platform and affiliate) for music NFT collectible purchases.

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.

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
0xaf120e5b55a90dcfa33093f895a7a971ceafc1f5	false	0x8a7d9289ee4ff2a9c8af60d2eea1007147f454c7	38	208	0xb8f942e2af8b97028883eb45f08ca8dfe43c36d7	1	17923931	0x0000000000000000000000000000000000000000	false	14	2023-08-16T00:51:11.000Z	0xf656e7ec25a9c493e5a7db5a3df7efbc57537d6a154c2757d7543c8a7016652d
0xaf120e5b55a90dcfa33093f895a7a971ceafc1f5	false	0xd5478c835c1f9f26ba907aaf0110067d07b6f8b9	49	429	0xac596e723af2fe85a17a50ba9a5138a9807704f1	1	18158813	0x0000000000000000000000000000000000000000	false	2	2023-09-17T22:52:23.000Z	0xc7275f33fcef6f8ae3e2d3b380b81e49fc60ad6af6eae256fea25613db3204ab
0xaf120e5b55a90dcfa33093f895a7a971ceafc1f5	false	0x844a76fc7c8f91e540fac7e304cd2aa918bd4779	49	168	0xac596e723af2fe85a17a50ba9a5138a9807704f1	1	18158649	0x0000000000000000000000000000000000000000	false	1	2023-09-17T22:18:47.000Z	0x93650b3040af35fa4f29f9d820e2d56922be1a2e6aad5368b9c19fea2986db41

Example Query

Query with partition filter

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

RangeEditionMinterInvinMusic_Minted_event

NFT mint events from Sound.xyz’s InvinMusic range edition minter contract on Ethereum, capturing music NFT purchases with buyer addresses, edition contracts, token IDs, quantities, payment amounts in wei, and optional affiliate referral data for analyzing music NFT sales and distribution 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_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.

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	in_requiredEtherValue
0x53a9a0bbc478632da7c3a28883eb8e501708c136	false	0x1bae9c27cf9d9b55d1b92aa3edb63e779f5dcd80	30	171	0xa90cc9eb0f8c090eda3c00ed5fd07a0d71ba8b0a	1	17761457	0x0000000000000000000000000000000000000000	false	9	2023-07-24T07:24:47.000Z	0x5f691ca2b06a61aa0381b134ac1736f0e3791ec0e00a788e04164587b5756634	3000000000000000
0x53a9a0bbc478632da7c3a28883eb8e501708c136	false	0x89343ef54def2dfd091d79e23518783febd9be55	1	312	0x676fc7bd06efa76e2211807d31c0c1b3d83f1381	1	16928342	0x5b93ff82faaf241c15997ea3975419dddd8362c5	true	67	2023-03-28T20:56:23.000Z	0xdaf39dcc03409ec49b152df489a3452fc4f709e1a633dce149e9b31023e0ae7e	3000000000000000
0x53a9a0bbc478632da7c3a28883eb8e501708c136	false	0x89343ef54def2dfd091d79e23518783febd9be55	1	225	0x676fc7bd06efa76e2211807d31c0c1b3d83f1381	1	16928346	0x5b93ff82faaf241c15997ea3975419dddd8362c5	true	68	2023-03-28T20:57:11.000Z	0xb0a5d3abe65875f7c87813bbf2c827ffeb44bbd378b926651ff8b7d080d3e087	3000000000000000

Example Query

Query with partition filter

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

RangeEditionMinterV1_Minted_event

NFT mint events from Sound.xyz’s Range Edition Minter V1 contract on Ethereum, capturing music NFT purchases with quantity, pricing (ETH value and platform fees), buyer addresses, edition contracts, token IDs, and optional affiliate tracking. Used for analyzing Sound protocol minting activity, pricing trends, and collector behavior across music releases.

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
0x6c05ead00da635e7de355977428d1fb31f80fd54	false	0x2f262bdfe6e355b3a884b5bfb0d55ffeec578fbb	59	300	0x0db9479b9ae53865b2da22dd02f97b8fe0b10032	1	17871829	0x0000000000000000000000000000000000000000	false	84	750000000000000	2023-08-08T17:55:59.000Z	0	0x90f5de34b7ba2404c25278ca840d066e621e9d2074eff162899fabf38d66f5cc	15000000000000000
0x6c05ead00da635e7de355977428d1fb31f80fd54	false	0x1a1c37c145a1eab58c43f003ebb55c18083b5987	124	232	0x032ee11b5fd5d312d3d4984212fa4883964066ee	1	17526480	0x0000000000000000000000000000000000000000	false	5	300000000000000	2023-06-21T07:14:11.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0xc1b0f598ac2dd121d23c5219e975844f20e5e815af1e18d4f2817ef7f283a022	6000000000000000
0x6c05ead00da635e7de355977428d1fb31f80fd54	false	0x15b73b5d6cadeecadb844dc0490078a798932c58	59	214	0x0db9479b9ae53865b2da22dd02f97b8fe0b10032	1	17526579	0x0000000000000000000000000000000000000000	false	66	750000000000000	2023-06-21T07:34:11.000Z	0	0x44703913ae9c7cca23b1108f6088705632c61a59613b37f2159e45570b488fe1	15000000000000000

Example Query

Query with partition filter

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

RangeEditionMinterV2_Minted_event

NFT mint event records from Sound.xyz’s RangeEditionMinterV2 contract on Ethereum, capturing music NFT purchases with buyer address, token IDs, quantities, and fee breakdowns including platform and affiliate fees.

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
0x3c95775ba56bfcd337998cc84f0388251d6aec7b	false	0x19b6b38387299d5ba6bcf2c94dd39f19d744075a	1	503	0x0c5e1eb0e2414ce9d301a8eeb6dff4e1061a7816	1	17682491	0x0000000000000000000000000000000000000000	false	21	700000000000000	2023-07-13T05:23:35.000Z	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x1d61b2c47ae4eb9bb20f7dfba2eb1e9929e161107f838ff6bc2a6afb01c92267	5700000000000000
0x3c95775ba56bfcd337998cc84f0388251d6aec7b	false	0x61e722c09ad1f625de6f2a1543577a67faf31119	1	326	0x0c5e1eb0e2414ce9d301a8eeb6dff4e1061a7816	1	17681367	0x0000000000000000000000000000000000000000	false	20	700000000000000	2023-07-13T01:35:23.000Z	0	0x46bdc8fd67dff400e4b134aaabf0f0edbccb726250af3b676de954e1ba079537	5700000000000000
0x3c95775ba56bfcd337998cc84f0388251d6aec7b	false	0x35f64560c51c8772f75186a8931929589b7c8d80	7	238	0x8ce8d40ba7bf178c2b6ec8c91c76a7102be9ed00	1	17684977	0x0000000000000000000000000000000000000000	false	8	700000000000000	2023-07-13T13:49:11.000Z	0	0x141d02b7d0874af84bcfacbfa2307adf2e6d959bb2f52b353bf11b5a0f47b4e8	5700000000000000

Example Query

Query with partition filter

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

SAM_Bought_event

Purchase events from Sound.xyz SAM (Sound Artist Minting) protocol on Ethereum. Tracks music NFT edition purchases with bonding curve pricing, buyer addresses, fee breakdowns (artist, platform, affiliate, golden egg), and token IDs for analyzing collector behavior and revenue 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_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
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0xfb067cbee50cd212ea0bec199cffe43f73b91fc1	93	0xafde9b5298daa92627b8bda937ac87b5aaf8fe33	1	17213581	0x0000000000000000000000000000000000000000	375337962232500	false	165	125112654077500	2023-05-08T05:04:59.000Z	5504956779417372	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x48cacb4bf6d8e3afb7dc4861e6936698352e349c705a2d43994b8fe94bb5478d	5
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x2b49302355d1cb7a3f1450fa1f04627356ecabf9	290	0xc4958f72c23662f76849c3929835d61ec8a842aa	1	17215483	0x0000000000000000000000000000000000000000	375084490557750	false	140	125028163519250	2023-05-08T11:29:11.000Z	5501239194853843	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x35bbdec7b5cbaad2ab38b6398fc67b61299d67e2ae1762289333d205821cc69d	2
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x51a8b04e69b1e8aec0a110a9e9ff9870377b1993	202	0x0e8c725b06a35b895dfe5c919dfc782a21684ba7	1	17708299	0x0000000000000000000000000000000000000000	375018719012250	false	17	125006239670750	2023-07-16T20:42:35.000Z	5500274545517307	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xd52ea50c03f1d388cc4b357ea97fec50924559931a198a4ab21b8a4592a52ce0	0

Example Query

Query with partition filter

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

SAM_Sold_event

NFT sale events from Sound Protocol’s SAM (Sound Auction Marketplace) on Ethereum, capturing music edition sales with bonding curve pricing, token IDs, seller addresses, and payout amounts. Enables analysis of music NFT trading activity and creator revenue 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_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
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x63a65fc3a6e3714e2a210b7fe17a9d743426da22	273	0xc54c6c76e7c68de2546e0f4d4115b91afb9a2bc9	[“604”,“605”,“606”,“607”,“608”,“609”,“610”,“611”,“612”,“613”,“614”,“615”,“616”,“617”,“618”,“619”,“620”,“621”,“622”,“623”]	18017372	162974881137497970	2023-08-29T02:40:59.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xec40767dd465afada134523b15a850adba3ef84c206fdcd3ac9180cedccf751d	168
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0xb5673e9ce563109216c81810273a82e6ed6e49e2	189	0x00396a23e204f3cf9e3a768c0218525501f45af1	[“857”,“858”,“859”,“860”,“861”,“862”,“863”,“864”,“865”,“866”,“867”,“868”,“869”,“870”,“871”,“872”,“873”,“874”]	17646900	76073186490845541	2023-07-08T05:14:11.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x4bc4e7b899b622de00ce883ea592db05d3a97cb718543e7088091c5ecf1683f0	126
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0xfb0609465f5f9a006234cc1446060f3d74bdd71f	232	0x34269da9138fd3347898217c6f9f73608373b5eb	[“563”,“564”,“565”]	17649783	15121916746293898	2023-07-08T14:57:59.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x65117a24150147cd9f867b3ccd162e872f6e049a0fa1b4ac8d1b49edd6d9e887	19

Example Query

Query with partition filter

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

SAMV1_Bought_event

Music NFT purchase events from Sound.xyz (Sound Artist Minter V1) on Ethereum. Tracks edition sales with bonding curve pricing, buyer addresses, artist/platform/affiliate fee splits, and attribution IDs for analyzing music NFT trading activity and revenue 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_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
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x4b8f9f3527868118475561eba84d060e4f1fb8d7	594	0x4d337bce1a5528a20a457289502d448d7bd782d4	1	18051567	0x0000000000000000000000000000000000000000	450089851260000	false	20	150029950420000	2023-09-02T21:41:59.000Z	6601317818484672	107748729757103714510389597206597106928039729295290739516031959671260410664983	0xd2bffac00ac37ec29793128caf617594e22a1050d6cbd85e9b60ee4ad4fb46f5	1
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x539252ef9473086216bf8ed14daf383539d12fbe	220	0x60f9916b5f63bf9bc5891ca64fa07cd59ce2bb99	1	17158241	0x0000000000000000000000000000000000000000	375009387839250	false	108	125003129279750	2023-04-30T10:22:35.000Z	5500137688316427	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x4cd23368e33fe891d934b591e88e3bebde48ea4c629c8c629ec70b4b10d1bc4a	0
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0xa3288b2bbf311a7fb68c7f07c326217b0b0dbcb9	284	0x09bef3e9a1ac6987cf6ed555b4a68a2019610586	1	17160672	0x0000000000000000000000000000000000000000	375009387839250	false	239	125003129279750	2023-04-30T18:33:23.000Z	5500137688316427	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x2b6cfbe52ba6115b42ca5f9e71e17dd603c203d0846b4c7c4fb6d817c49d4c5e	0

Example Query

Query with partition filter

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

SAMV1_Sold_event

Secondary sale events from Sound.xyz’s SAM (Sound Automated Market) V1 bonding curve protocol on Ethereum. Tracks NFT edition resales with pricing curves, token IDs, payout amounts, and attribution data for analyzing music NFT 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_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
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x18ec5566ad26e2ac609822395d6d9e98a39c90ef	80	0x9bf82be1a8d003417e0999000e4cdb1187512815	[“21”,“22”]	17155547	10007635443043047	2023-04-30T01:18:11.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xc190aab757eb76e65281dbca73b7f7fde5ad8a7e1c3a2ae82bf82d26d902c0dd	6
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0xe2a26a4df24f65e790b108e4f62322333000bbef	329	0x659d9c4c146a652c6a8d3bd41f95ebc431e77533	[“444”,“446”]	17573966	10000625855987135	2023-06-27T23:30:47.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x9dc68e2678b521627a95a4adb1ca322bab4242c6660719baff9a4dcdbc4f8bb8	2
0xb77a65e680ba99bdfb530d3cc0692cd75b088ba1	false	0x03a1752d689ac9ef936898189aa9c0a7011842b9	289	0x03502106e4331e474c2d29b6b557d6694a87acaa	[“574”,“575”,“576”,“577”,“578”,“579”,“580”,“581”,“582”,“583”,“584”,“585”,“586”,“587”,“588”,“589”,“590”,“591”,“592”,“593”,“594”,“595”,“596”,“597”,“598”,“599”,“600”,“601”,“602”,“603”,“604”,“605”,“606”,“607”,“608”,“609”,“610”,“611”,“612”,“613”]	17689223	254465311110446900	2023-07-14T04:06:35.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x84f00deca778bb902223ca223c39525845dfca31f796916d07344dfbf98b97d3	192

Example Query

Query with partition filter

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

SAMV2_Bought_event

Music NFT purchase events from Sound.xyz protocol (SAMV2 contract) on Ethereum. Tracks buyer activity, edition mints, token pricing with bonding curve mechanics, and fee distribution across artists, platform, affiliates, and golden egg rewards.

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
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0xe733b65ef1fffa734c7cea6e8463506fff83855a	306	0xd28db962fba67fbb65608b1ca348b82b65e8be84	1	17969392	0x0000000000000000000000000000000000000000	375018719012250	false	2	700000000000000	2023-08-22T09:34:47.000Z	6075268305846557	107748729757103714510389597206597106928039729295290739516031959671260410664983	0x559cdacca355091f9bf5c39aabdaa6716c9c3878a11f5c8666f5a27b7189f8be	0
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0xdc3f4b133561ab3278cf50740b9b6ac6cab34ff1	314	0xbe974cf2475b1ffa00e3a4671af2833fdce47d4f	1	17753189	0x0000000000000000000000000000000000000000	600029950419750	false	56	700000000000000	2023-07-23T03:39:11.000Z	9300429289354641	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x03da1aa0d7c0b9063efa2b5248f31b809f6d5f64cc66a3a780e4a8e82bc71f45	0
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0x7f1938ceb2b7ad7e33299171377faf4fce721443	35	0xf9ad583ac41aa535ba8874991b36d5d1327a14dd	1	17883253	0x0000000000000000000000000000000000000000	50022462815000	false	585	700000000000000	2023-08-10T08:19:35.000Z	1750471719116749	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xfa8798ecadece4fc38872a145caedafd580e7664ceb12b3821a148ad23c3313a	2

Example Query

Query with partition filter

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

SAMV2_Sold_event

Secondary market sales of Sound Protocol V2 music NFTs on Ethereum, tracking token resales with pricing data from bonding curve mechanics. Useful for analyzing price discovery, holder behavior, and secondary market liquidity of music edition NFTs.

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
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0x9e8fc5cdd838d6d486d167e4573fdb60dac50aef	301	0xbc274d2f4be62139bf15169f65c358ae48e4215c	[“8”,“61”]	18393718	10120051267301667	2023-10-20T19:47:47.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x7d531022301e51ee1d01e3b549aba9e2f8811a6838f5c22211d60f47899662d0	16
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0x08a0ebc290bbe9dff529af7d1bb7d980c3732a9f	213	0xbc274d2f4be62139bf15169f65c358ae48e4215c	[“24”,“34”,“48”,“49”]	18398511	20157239705613410	2023-10-21T11:53:11.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0x1613ff58866e189eb1a0fedda32c1c8b31bed0cdd335353940eeabc39a9065e6	14
0x9fbd0eae64c6c5427914fc4939cd62a3fd88d217	false	0xd3c45a5b9aea1cd78c7a2527012bc4acec9c8050	236	0x8f9f8d1f1fa415640c193956838a78729c497115	[“9”,“10”]	19106927	10010233060206587	2024-01-28T18:49:47.000Z	100034050823429212663744024974472219327326309225212339598659123908725914828493	0xef264b1021d16b8f08323d31852d2ff695f97fdb03dbe52f1d6cbcfad7d5da4b	5

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Artist_EditionCreated_event

Artist_EditionPurchased_event

ArtistCreator_CreatedArtist_event

ArtistCreatorV2_CreatedArtist_event

ArtistV1_EditionCreated_event

ArtistV1_EditionPurchased_event

Creator_SoundEditionCreated_event

MerkleDropMinter_Minted_event

MerkleDropMinterBankless_Minted_event

MerkleDropMinterBonfire_Minted_event

MerkleDropMinterInvinMusic_Minted_event

MerkleDropMinterV1_Minted_event

MerkleDropMinterV2_Minted_event

RangeEditionMinter_Minted_event

RangeEditionMinterBankless_Minted_event

RangeEditionMinterBonfire_Minted_event

RangeEditionMinterInvinMusic_Minted_event

RangeEditionMinterV1_Minted_event

RangeEditionMinterV2_Minted_event

SAM_Bought_event

SAM_Sold_event

SAMV1_Bought_event

SAMV1_Sold_event

SAMV2_Bought_event

SAMV2_Sold_event

​Tables

​Artist_EditionCreated_event

​Artist_EditionPurchased_event

​ArtistCreator_CreatedArtist_event

​ArtistCreatorV2_CreatedArtist_event

​ArtistV1_EditionCreated_event

​ArtistV1_EditionPurchased_event

​Creator_SoundEditionCreated_event

​MerkleDropMinter_Minted_event

​MerkleDropMinterBankless_Minted_event

​MerkleDropMinterBonfire_Minted_event

​MerkleDropMinterInvinMusic_Minted_event

​MerkleDropMinterV1_Minted_event

​MerkleDropMinterV2_Minted_event

​RangeEditionMinter_Minted_event

​RangeEditionMinterBankless_Minted_event

​RangeEditionMinterBonfire_Minted_event

​RangeEditionMinterInvinMusic_Minted_event

​RangeEditionMinterV1_Minted_event

​RangeEditionMinterV2_Minted_event

​SAM_Bought_event

​SAM_Sold_event

​SAMV1_Bought_event

​SAMV1_Sold_event

​SAMV2_Bought_event

​SAMV2_Sold_event

Tables

Artist_EditionCreated_event

Artist_EditionPurchased_event

ArtistCreator_CreatedArtist_event

ArtistCreatorV2_CreatedArtist_event

ArtistV1_EditionCreated_event

ArtistV1_EditionPurchased_event

Creator_SoundEditionCreated_event

MerkleDropMinter_Minted_event

MerkleDropMinterBankless_Minted_event

MerkleDropMinterBonfire_Minted_event

MerkleDropMinterInvinMusic_Minted_event

MerkleDropMinterV1_Minted_event

MerkleDropMinterV2_Minted_event

RangeEditionMinter_Minted_event

RangeEditionMinterBankless_Minted_event

RangeEditionMinterBonfire_Minted_event

RangeEditionMinterInvinMusic_Minted_event

RangeEditionMinterV1_Minted_event

RangeEditionMinterV2_Minted_event

SAM_Bought_event

SAM_Sold_event

SAMV1_Bought_event

SAMV1_Sold_event

SAMV2_Bought_event

SAMV2_Sold_event