> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# sound_v1_optimism

> Tables in tt-contracts.sound_v1_optimism

## 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.

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.sound_v1_optimism.SoundCreator_SoundEditionCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***