sound_v1_optimism - Token Terminal Docs

Tables

SoundCreator_SoundEditionCreated_event

Music NFT edition creation events from Sound.xyz protocol on Optimism. Captures new edition deployments with mint parameters, deployer addresses, and contract initialization data for tracking music release activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_soundEdition`	`STRING`	Contract address of the newly created Sound Edition NFT on Optimism. Hex-encoded, 0x-prefixed 40-character address representing the deployed edition contract.
`in_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
`in_initData`	`STRING`	Initialization data passed to the newly created Sound edition contract during deployment. Hex-encoded calldata containing configuration parameters like metadata URI, royalty settings, and minting parameters.
`in_contracts`	`ARRAY<STRING>`	Array of contract addresses invoked during the Sound edition creation process. Typically includes minter modules, metadata renderers, and platform contracts configured for the new edition.
`in_data`	`ARRAY<STRING>`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_results`	`ARRAY<STRING>`	Array of hex-encoded return values from module contract calls executed during Sound edition creation. Each element corresponds to a contract call in the `in_contracts` array, typically containing deployment IDs or confirmation data.

Sample Data

address	in_data	removed	log_index	in_results	in_deployer	in_initData	block_number	in_contracts	block_timestamp	in_soundEdition	transaction_hash
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x1c10893f00000000000000000000000046f81107e99adf80b8ea49ab7281b984f826fbd00000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b0000000000000000000000000eb15e73800932e315e65e591540efd61846ac2b0000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000064f0ff500000000000000000000000000000000000000000000000000000000064f0ff5100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000008500000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000000000002”,“0xc309c47d0000000000000000000000000eb15e73800932e315e65e591540efd61846ac2bb92192937bf101eaf2a9494b9765718b77beafd007664fa94b926b86f275e6340000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000064f0e3300000000000000000000000000000000000000000000000000000000064f0ff5000000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000000000002”]	false	75	[“0x”,“0x”,“0x00000000000000000000000000000000000000000000000000000000000003ed”,“0x000000000000000000000000000000000000000000000000000000000000012f”]	0x926ed0d1f804f028317094040963d4a112857b41	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000385e9f438a8b5ca54bc87e2b826fb7adfdc3fd7f00000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000240000000000000000000000000c021a17cada524ec4f472f3d9a695ac73eec01d300000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000008500000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000064f0ff510000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001d6c69766520666f726576657220287769746820426c76636b2053766d2900000000000000000000000000000000000000000000000000000000000000000000064c56344556520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f31355f47565079744241526f446c62316b6342315a67447073486a4f71704a4b7a42724c697253395f394900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f324773362d7a44654f6c4672544a45586a7049523738446d785158306f3566496d3454586a45703161394500000000000000000000000000000000	108798790	[“0x0eb15e73800932e315e65e591540efd61846ac2b”,“0x0eb15e73800932e315e65e591540efd61846ac2b”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”,“0x46f81107e99adf80b8ea49ab7281b984f826fbd0”]	2023-08-28T04:19:17.000Z	0x0eb15e73800932e315e65e591540efd61846ac2b	0x37b8d352b1b303d03a44f0aa5f7a13ffee0ac0857b7f6b937e3b867f2a5c6828
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b00000000000000000000000093820c88704d75dab5690d782a20aec46f605cee0000000000000000000000000000000000000000000000000011c37937e080000000000000000000000000000000000000000000000000000000000064ee32200000000000000000000000000000000000000000000000000000000064f76ca000000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”,“0x2ceb70ac00000000000000000000000012a1458b9162dbf50983e72e78e41e37f5bf1a80”,“0x41f6ec4f00000000000000000000000093820c88704d75dab5690d782a20aec46f605cee0000000000000000000000000000000000000000000000000011c37937e08000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006e05e9fee34c000000000000000000000000000000000000000000000000000000000000000058100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000fa000000000000000000000000235b38e26fa4e3f5deeb7c2b9b9576ec590cbc34aebb663619da272bbbb189ff00eed541d415d75aed021e0a2b3977fb7d9d9ff0”]	false	38	[“0x”,“0x00000000000000000000000000000000000000000000000000000000000003f5”,“0x”,“0x”]	0x235b38e26fa4e3f5deeb7c2b9b9576ec590cbc34	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000c417a48cd096067520747607a0331f0e00000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000240000000000000000000000000235b38e26fa4e3f5deeb7c2b9b9576ec590cbc3400000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000064f76ca000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000007496d70756c7365000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007494d50554c534500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f5242696d4161674d455159716e4161544565674b6a513639784e78366b69613454364a59766a446766486f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f78422d4d4a63456871506453624c5743634159414b582d75454f6e4e4d356e656e6758666c6b434e614e4d00000000000000000000000000000000	108818673	[“0x93820c88704d75dab5690d782a20aec46f605cee”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”,“0x93820c88704d75dab5690d782a20aec46f605cee”,“0x12a1458b9162dbf50983e72e78e41e37f5bf1a80”]	2023-08-28T15:22:03.000Z	0x93820c88704d75dab5690d782a20aec46f605cee	0xf7af7d26ea2bd88ee06737b3a1c04558de5bbaf8738bbaef3cf2152f4590f341
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55	[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b000000000000000000000000aea630c6d838f4010ad8cd4a211bd2054dc66dc10000000000000000000000000000000000000000000000000005543df729c0000000000000000000000000000000000000000000000000000000000064fca4900000000000000000000000000000000000000000000000000000000064fca49100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000050”]	false	37	[“0x”,“0x00000000000000000000000000000000000000000000000000000000000003f6”]	0x26d0e526263c22622b532d094b9f40600dee5e65	0xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000385e9f438a8b5ca54bc87e2b826fb7adfdc3fd7f00000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000026d0e526263c22622b532d094b9f40600dee5e6500000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000064fca49100000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000005517565656e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002514e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f5a6f3442746e3047456d4339694c6c5250496d7a6642596d5258564f72426c4b645335523831336d39353800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f3567634150357474575041372d31734b79654157682d48644267326b475431325a48416b5241732d4b466700000000000000000000000000000000	108821691	[“0xaea630c6d838f4010ad8cd4a211bd2054dc66dc1”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”]	2023-08-28T17:02:39.000Z	0xaea630c6d838f4010ad8cd4a211bd2054dc66dc1	0xed87a512c00fb53b79e6bdbd652b4649010ee82a0a9cf4dd3393d9c66adf5c6c

Example Query

Query with partition filter

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

⌘I