Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_soundEditionSTRINGContract address of the newly created Sound Edition NFT on Optimism. Hex-encoded, 0x-prefixed 40-character address representing the deployed edition contract.
in_deployerSTRINGAddress of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
in_initDataSTRINGInitialization 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_contractsARRAY<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_dataARRAY<STRING>Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
in_resultsARRAY<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.
addressin_dataremovedlog_indexin_resultsin_deployerin_initDatablock_numberin_contractsblock_timestampin_soundEditiontransaction_hash
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x1c10893f00000000000000000000000046f81107e99adf80b8ea49ab7281b984f826fbd00000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b0000000000000000000000000eb15e73800932e315e65e591540efd61846ac2b0000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000064f0ff500000000000000000000000000000000000000000000000000000000064f0ff5100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000008500000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000000000002”,“0xc309c47d0000000000000000000000000eb15e73800932e315e65e591540efd61846ac2bb92192937bf101eaf2a9494b9765718b77beafd007664fa94b926b86f275e6340000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000064f0e3300000000000000000000000000000000000000000000000000000000064f0ff5000000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000000000002”]false75[“0x”,“0x”,“0x00000000000000000000000000000000000000000000000000000000000003ed”,“0x000000000000000000000000000000000000000000000000000000000000012f”]0x926ed0d1f804f028317094040963d4a112857b410xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000385e9f438a8b5ca54bc87e2b826fb7adfdc3fd7f00000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000240000000000000000000000000c021a17cada524ec4f472f3d9a695ac73eec01d300000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000008500000000000000000000000000000000000000000000000000000000000000850000000000000000000000000000000000000000000000000000000064f0ff510000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001d6c69766520666f726576657220287769746820426c76636b2053766d2900000000000000000000000000000000000000000000000000000000000000000000064c56344556520000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f31355f47565079744241526f446c62316b6342315a67447073486a4f71704a4b7a42724c697253395f394900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f324773362d7a44654f6c4672544a45586a7049523738446d785158306f3566496d3454586a45703161394500000000000000000000000000000000108798790[“0x0eb15e73800932e315e65e591540efd61846ac2b”,“0x0eb15e73800932e315e65e591540efd61846ac2b”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”,“0x46f81107e99adf80b8ea49ab7281b984f826fbd0”]2023-08-28T04:19:17.000Z0x0eb15e73800932e315e65e591540efd61846ac2b0x37b8d352b1b303d03a44f0aa5f7a13ffee0ac0857b7f6b937e3b867f2a5c6828
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b00000000000000000000000093820c88704d75dab5690d782a20aec46f605cee0000000000000000000000000000000000000000000000000011c37937e080000000000000000000000000000000000000000000000000000000000064ee32200000000000000000000000000000000000000000000000000000000064f76ca000000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000000002710”,“0x2ceb70ac00000000000000000000000012a1458b9162dbf50983e72e78e41e37f5bf1a80”,“0x41f6ec4f00000000000000000000000093820c88704d75dab5690d782a20aec46f605cee0000000000000000000000000000000000000000000000000011c37937e08000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006e05e9fee34c000000000000000000000000000000000000000000000000000000000000000058100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000fa000000000000000000000000235b38e26fa4e3f5deeb7c2b9b9576ec590cbc34aebb663619da272bbbb189ff00eed541d415d75aed021e0a2b3977fb7d9d9ff0”]false38[“0x”,“0x00000000000000000000000000000000000000000000000000000000000003f5”,“0x”,“0x”]0x235b38e26fa4e3f5deeb7c2b9b9576ec590cbc340xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000c417a48cd096067520747607a0331f0e00000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000240000000000000000000000000235b38e26fa4e3f5deeb7c2b9b9576ec590cbc3400000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000007fffffff0000000000000000000000000000000000000000000000000000000064f76ca000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000007496d70756c7365000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007494d50554c534500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f5242696d4161674d455159716e4161544565674b6a513639784e78366b69613454364a59766a446766486f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f78422d4d4a63456871506453624c5743634159414b582d75454f6e4e4d356e656e6758666c6b434e614e4d00000000000000000000000000000000108818673[“0x93820c88704d75dab5690d782a20aec46f605cee”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”,“0x93820c88704d75dab5690d782a20aec46f605cee”,“0x12a1458b9162dbf50983e72e78e41e37f5bf1a80”]2023-08-28T15:22:03.000Z0x93820c88704d75dab5690d782a20aec46f605cee0xf7af7d26ea2bd88ee06737b3a1c04558de5bbaf8738bbaef3cf2152f4590f341
0x5bcf5773bcf1f131a0cad5c74aa9be1a80b63c55[“0x1c10893f000000000000000000000000403471cbcab399896004bc0af2b4674d4ab3b53b0000000000000000000000000000000000000000000000000000000000000002”,“0x7cbf126b000000000000000000000000aea630c6d838f4010ad8cd4a211bd2054dc66dc10000000000000000000000000000000000000000000000000005543df729c0000000000000000000000000000000000000000000000000000000000064fca4900000000000000000000000000000000000000000000000000000000064fca49100000000000000000000000000000000000000000000000000000000ffffffff00000000000000000000000000000000000000000000000000000000000001f4000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000050”]false37[“0x”,“0x00000000000000000000000000000000000000000000000000000000000003f6”]0x26d0e526263c22622b532d094b9f40600dee5e650xdd012a11000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000385e9f438a8b5ca54bc87e2b826fb7adfdc3fd7f00000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000026d0e526263c22622b532d094b9f40600dee5e6500000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000064fca49100000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000005517565656e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002514e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f5a6f3442746e3047456d4339694c6c5250496d7a6642596d5258564f72426c4b645335523831336d39353800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003061723a2f2f3567634150357474575041372d31734b79654157682d48644267326b475431325a48416b5241732d4b466700000000000000000000000000000000108821691[“0xaea630c6d838f4010ad8cd4a211bd2054dc66dc1”,“0x403471cbcab399896004bc0af2b4674d4ab3b53b”]2023-08-28T17:02:39.000Z0xaea630c6d838f4010ad8cd4a211bd2054dc66dc10xed87a512c00fb53b79e6bdbd652b4649010ee82a0a9cf4dd3393d9c66adf5c6c
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