metaplex_v1_solana

Tables

TokenMetadata_Create_instruction

Token metadata creation instructions from Metaplex Token Metadata program on Solana, capturing NFT and fungible token minting with name, symbol, URI, creator addresses, royalty fees, and token standards (NonFungible, Fungible, FungibleAsset).

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
`in_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_sysvar_instructions`	`STRING`	Address of the Solana Sysvar Instructions program account passed to this instruction. Always set to the canonical address Sysvar1nstructions1111111111111111111111111 for instruction introspection.
`in_update_authority`	`STRING`	Account authorized to modify the token metadata after creation. Base58-encoded Solana public key.
`in_remaining_accounts`	`JSON`	Additional accounts required for instruction execution beyond the standard account set. JSON array of Base58-encoded Solana public keys.
`in_creators`	`JSON`	Array of creator accounts and their ownership shares for the NFT. JSON objects containing address (Base58-encoded Solana public key), share (percentage as integer 0-100), and verified (boolean) fields.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_seller_fee_basis_points`	`STRING`	Seller fee charged on secondary sales expressed in basis points. String-encoded integer where 100 basis points equals 1%.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in_is_mutable`	`STRING`	Boolean flag indicating whether the token metadata can be modified after creation. String-encoded as ‘true’ or ‘false’.
`in_primary_sale_happened`	`STRING`	Boolean flag indicating whether the NFT or token has completed its initial primary sale. Set to ‘false’ upon creation and updates to ‘true’ after first sale.
`in_token_standard`	`STRING`	Metaplex token standard type specified at creation (NonFungible, Fungible, FungibleAsset, etc.). Determines the token’s capabilities and compliance with SPL token standards.
`in_print_supply`	`STRING`	Print supply configuration for the NFT or token. Specifies whether additional copies can be minted, with values like ‘Zero’ for unique items or null for fungible tokens.

Sample Data

in_uri	in_mint	in_name	in_payer	in_symbol	block_slot	in_creators	in_metadata	in_authority	in_is_mutable	surrogate_key	transaction_id	block_timestamp	in_print_supply	instruction_type	executing_account	in_system_program	in_token_standard	instruction_index	transaction_index	transaction_signer	in_update_authority	in_remaining_accounts	in_sysvar_instructions	in_primary_sale_happened
	GJoDPz8sGnF5LzoeNCtAcizhE5pS4WhQHymwEJuhj3MG	MYC	29e3KoFib8ADUKPgkrEYcpYbkkbLKvyocxq2FyNAXL1w	MYC	371512944	[{“address”:“29e3KoFib8ADUKPgkrEYcpYbkkbLKvyocxq2FyNAXL1w”,“share”:100,“verified”:true}]	8qqAT3bXSfkKWVvz4eqjGRhKUxrcgLg2pVeStyLa924d	29e3KoFib8ADUKPgkrEYcpYbkkbLKvyocxq2FyNAXL1w	true	371512944-iDuDPBGCkuSHpiXxot4uSYmfBSw84HMvqZg2z9WBo8X8GjtBFdexLns1s9kgvprTs3AevhofDwBdkfKytezTWx1-0	iDuDPBGCkuSHpiXxot4uSYmfBSw84HMvqZg2z9WBo8X8GjtBFdexLns1s9kgvprTs3AevhofDwBdkfKytezTWx1	2025-10-06T06:03:13.000Z	Zero	Create	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	11111111111111111111111111111111	NonFungible	0	51	29e3KoFib8ADUKPgkrEYcpYbkkbLKvyocxq2FyNAXL1w	29e3KoFib8ADUKPgkrEYcpYbkkbLKvyocxq2FyNAXL1w	[]	Sysvar1nstructions1111111111111111111111111	false
https://23o3.com/api/nft/collection-json/FS-002.json	AXEsqzh8z9ZepbmbBjvoPnbvYrDZSA6qaxKHkJKq9bBs	File Storage NFT Collection	ASsXxXPmaidY3j612aLsxseuAkYAjYVfEXuC4hbUkG1e	FSC	371477952	[{“address”:“ASsXxXPmaidY3j612aLsxseuAkYAjYVfEXuC4hbUkG1e”,“share”:100,“verified”:true}]	2Ab6gG1gTVmaezZAvVc4CJJN6BWWBcQU2wNY8Ar6pJSp	ASsXxXPmaidY3j612aLsxseuAkYAjYVfEXuC4hbUkG1e	true	371477952-3wGQUxvqVfyfSXipUgcJwa7FtzkTeVfvhNfWA2MnabWnWmisNg1BnuazrSY47FhucVqWe8KLfbFNuGvYdgiWDp78-0	3wGQUxvqVfyfSXipUgcJwa7FtzkTeVfvhNfWA2MnabWnWmisNg1BnuazrSY47FhucVqWe8KLfbFNuGvYdgiWDp78	2025-10-06T02:12:10.000Z	Zero	Create	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	11111111111111111111111111111111	NonFungible	0	23	ASsXxXPmaidY3j612aLsxseuAkYAjYVfEXuC4hbUkG1e	ASsXxXPmaidY3j612aLsxseuAkYAjYVfEXuC4hbUkG1e	[]	Sysvar1nstructions1111111111111111111111111	false
https://95a7b7ed6dcc93099b459dddedb39cd9.ipfscdn.io/ipfs/QmSvnt5hGEwRfcS32r8XGGTfKTVHPA4ovXdFJiCGbmzAu5/0	6w54cb92MfK7duKRY1pKzbVHpRdbpNZc6baTzYocLrAP	Birbhalla	8XyuQyLtTbcNvkPcjfnZDyDp7QJsig86yw47NwxWSAYj	BHLA	371645182	[{“address”:“97re9hThEyURhjNxvDnMKu5kTcc9jkvw1vQ2qE1qAC4w”,“share”:100,“verified”:true}]	6WgAykhDAyYcjzu8qbFSABZbMNGrfSfgFtu5nc3KAri7	97re9hThEyURhjNxvDnMKu5kTcc9jkvw1vQ2qE1qAC4w	true	371645182-4qaBwEdP5RtSjCsUahp6Vs7CTURHrsWxfg8tG2DxYarXLeMUmRDvfDGwbJ7yY9t7feiaiThtoXyMseH6TAEcGm9-4	4qaBwEdP5RtSjCsUahp6Vs7CTURHrsWxfg8tG2DxYarXLeMUmRDvfDGwbJ7yY9t7feiaiThtoXyMseH6TAEcGm9	2025-10-06T20:35:45.000Z		Create	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	11111111111111111111111111111111	FungibleAsset	4	51	8XyuQyLtTbcNvkPcjfnZDyDp7QJsig86yw47NwxWSAYj	97re9hThEyURhjNxvDnMKu5kTcc9jkvw1vQ2qE1qAC4w	[]	Sysvar1nstructions1111111111111111111111111	false

Example Query

Query with partition filter

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

TokenMetadata_CreateMetadataAccount_instruction

Metaplex Token Metadata Program CreateMetadataAccount instruction calls on Solana, recording NFT and token metadata creation with name, symbol, URI, creator shares, royalty basis points, and mutability settings. Used for tracking NFT mints and analyzing collection launches and creator attribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
`in_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_mint_authority`	`STRING`	Account authorized to sign for minting new tokens of the specified mint. Base58-encoded Solana public key, typically matches the transaction signer for new token creation.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_update_authority`	`STRING`	Account authorized to modify the token metadata after creation. Base58-encoded Solana public key.
`in_remaining_accounts`	`JSON`	Additional accounts required for instruction execution beyond the standard account set. JSON array of Base58-encoded Solana public keys.
`in_creators`	`JSON`	Array of creator accounts and their ownership shares for the NFT. JSON objects containing address (Base58-encoded Solana public key), share (percentage as integer 0-100), and verified (boolean) fields.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_seller_fee_basis_points`	`STRING`	Seller fee charged on secondary sales expressed in basis points. String-encoded integer where 100 basis points equals 1%.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in_is_mutable`	`STRING`	Boolean flag indicating whether the token metadata can be modified after creation. String-encoded as ‘true’ or ‘false’.

Sample Data

in_uri	in_mint	in_rent	in_payer	in_symbol	block_slot	in_creators	in_metadata	in_is_mutable	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	in_mint_authority	in_system_program	instruction_index	transaction_index	transaction_signer	in_update_authority	in_remaining_accounts	outer_executing_account	outer_instruction_index	in_seller_fee_basis_points
https://testlaunchmynft.mypinata.cloud/ipfs/QmNNRY8cVi8i4By9F9AYDoRvZ44L5k9N2Rc1HCjWuTCUWY/58.json	2A624rcMa434zqfo2vdrJosB7VwiEpSAZwAEQUCD38GV	SysvarRent111111111111111111111111111111111	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	PixGG	137154195	[{“address”:“2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T”,“share”:0,“verified”:true},{“address”:“GgurWUpUX2CcEt5nScGMVZoiai9bJtqpT6eAM2dEaxhq”,“share”:100,“verified”:false}]	FkNMoKRQFpoCXDVxaMyvKfBNeuEeUEJrKvAJQZZ8h5mb	true	137154195-55SAFQVpiY64FLk7H7pcz2BHQsRuUnC5jynYewZq7ouK5UyM8wvQv1ZzDbjs9yvrwtWNhd2vpBb9FQsdEMC4b39F-4-2	55SAFQVpiY64FLk7H7pcz2BHQsRuUnC5jynYewZq7ouK5UyM8wvQv1ZzDbjs9yvrwtWNhd2vpBb9FQsdEMC4b39F	2022-06-11T11:05:57.000Z	CreateMetadataAccount	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	11111111111111111111111111111111	2	129	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	4	500
https://testlaunchmynft.mypinata.cloud/ipfs/QmNNRY8cVi8i4By9F9AYDoRvZ44L5k9N2Rc1HCjWuTCUWY/59.json	4WmHRNwbzjNHH6DUwNVKV53DKc5iZdS4dYD3noY539Df	SysvarRent111111111111111111111111111111111	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	PixGG	137154237	[{“address”:“2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T”,“share”:0,“verified”:true},{“address”:“GgurWUpUX2CcEt5nScGMVZoiai9bJtqpT6eAM2dEaxhq”,“share”:100,“verified”:false}]	EbKJzKpdv8F75RBo6VW2jKjyC7ttK2zKkjwBruWUoyfM	true	137154237-51oa4g8nirfGxVcBJ6dmpB8EzuCRPMMhcdWZQLfJ7AB7zisXDwzQtfpnzRL7cBoi6TkLUmmQ9GsuTcfSE69GFWA6-4-2	51oa4g8nirfGxVcBJ6dmpB8EzuCRPMMhcdWZQLfJ7AB7zisXDwzQtfpnzRL7cBoi6TkLUmmQ9GsuTcfSE69GFWA6	2022-06-11T11:06:23.000Z	CreateMetadataAccount	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	11111111111111111111111111111111	2	208	C2PwbPzC5rFSJYjPiHkULSiZH4jSmRXDfMPLNxgqNGbM	2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	4	500
https://testlaunchmynft.mypinata.cloud/ipfs/QmNNRY8cVi8i4By9F9AYDoRvZ44L5k9N2Rc1HCjWuTCUWY/60.json	FtfryF29ZhBm4dWyorjmqNCyfP8EpVxW6UifL9ZtY7h3	SysvarRent111111111111111111111111111111111	3uZLmiPRLjFnM1D6oeF8on5jNX3jhfTR1EMtsUC5S7Qu	PixGG	137156138	[{“address”:“2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T”,“share”:0,“verified”:true},{“address”:“GgurWUpUX2CcEt5nScGMVZoiai9bJtqpT6eAM2dEaxhq”,“share”:100,“verified”:false}]	3f661Q4LK5GDR8wFAxSjEL8SvdpwtnZuDkm2sZvGMpfD	true	137156138-4DdqV3am5rkiSw5H3mMg6rxF5GZS8feMkB6dxgiddyx9nwHWMdAfo9gUdJGJV7dZmHs2FgUSVWoXnNr4m2ucmQXo-4-3	4DdqV3am5rkiSw5H3mMg6rxF5GZS8feMkB6dxgiddyx9nwHWMdAfo9gUdJGJV7dZmHs2FgUSVWoXnNr4m2ucmQXo	2022-06-11T11:29:02.000Z	CreateMetadataAccount	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	3uZLmiPRLjFnM1D6oeF8on5jNX3jhfTR1EMtsUC5S7Qu	11111111111111111111111111111111	3	74	3uZLmiPRLjFnM1D6oeF8on5jNX3jhfTR1EMtsUC5S7Qu	2RKuBjaGYW1RL3Lz3VxPVRhgjdRZco91H6cogPbAmY2T	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	4	500

Example Query

Query with partition filter

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

TokenMetadata_CreateMetadataAccountV2_instruction

NFT metadata creation events from Metaplex Token Metadata program on Solana, capturing token name, symbol, URI, creator information, and royalty settings for analyzing minting activity and NFT collection launches.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
`in_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_mint_authority`	`STRING`	Account authorized to mint new tokens for the specified SPL token mint. Typically matches the payer or transaction signer during initial token creation.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_update_authority`	`STRING`	Account authorized to modify the token metadata after creation. Base58-encoded Solana public key.
`in_remaining_accounts`	`JSON`	Additional accounts required for instruction execution beyond the standard account set. JSON array of Base58-encoded Solana public keys.
`in_creators`	`JSON`	Array of creator accounts and their ownership shares for the NFT. JSON objects containing address (Base58-encoded Solana public key), share (percentage as integer 0-100), and verified (boolean) fields.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_seller_fee_basis_points`	`STRING`	Seller fee charged on secondary sales expressed in basis points. String-encoded integer where 100 basis points equals 1%.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in_is_mutable`	`STRING`	Boolean flag indicating whether the token metadata can be modified after creation. String-encoded as ‘true’ or ‘false’.

Sample Data

in_uri	in_mint	in_name	in_rent	in_payer	in_symbol	block_slot	in_creators	in_metadata	in_is_mutable	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	in_mint_authority	in_system_program	instruction_index	transaction_index	transaction_signer	in_update_authority	in_remaining_accounts	outer_executing_account	outer_instruction_index	in_seller_fee_basis_points
https://gateway.pinata.cloud/ipfs/QmTMZUdmq3kk2P4NML6AF6npvjUm7v1i5MNqG8RJ8WoLF4	FuAWqPYERSKGyQkxRk3vzpPi5bYDmCMKnCF8mNr5ibKU	Matrix Sol		21o9v45HbdNx2hBR6JCH5kuSj2WsJWvuUxeFtnao5ASQ	MTRIX	178431399		DWcsupKGQWXxVqhDSMaDHiQG7sYt3QnUrqWGj4r284zg	true	178431399-TvPJpPJSXtZZTsMvRLbq4bp3rZfMKrXkeVznMXCU8MbrHzsrKHe4Pf8tkk2b7pCE13ks1Pfci44V46JWspvfQ1d-0	TvPJpPJSXtZZTsMvRLbq4bp3rZfMKrXkeVznMXCU8MbrHzsrKHe4Pf8tkk2b7pCE13ks1Pfci44V46JWspvfQ1d	2023-02-18T17:02:06.000Z	CreateMetadataAccountV2	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	21o9v45HbdNx2hBR6JCH5kuSj2WsJWvuUxeFtnao5ASQ	11111111111111111111111111111111	0	0	21o9v45HbdNx2hBR6JCH5kuSj2WsJWvuUxeFtnao5ASQ	21o9v45HbdNx2hBR6JCH5kuSj2WsJWvuUxeFtnao5ASQ	[]			0
https://shdw-drive.genesysgo.net/3BUHffyLbhUy5tpZHWVrMAmitfcfksuZ8XgmhjTKCu6t/HonpKYnWW3C2CKddkHQVyfnL5cYG8QU49B6NqXz9kJpW-497.json	HonpKYnWW3C2CKddkHQVyfnL5cYG8QU49B6NqXz9kJpW	Honey	SysvarRent111111111111111111111111111111111	229eCBRDbAYFdMesuUnwznVX7qN9pu3DFGx24s1uUB2b	HON	178388070		CD8F8rvPLM8pnejXcrvXkXvkuTbNXkfkY3BLHg3dxApT	true	178388070-3oga8rvzzYZjkF3d3WTcwX3R7RnXHjKqhcwXLwiWpG2AcHKmjsFj7rSejgvFizVPJHPRYB2cJRh4MsmdCoD4ahxP-0	3oga8rvzzYZjkF3d3WTcwX3R7RnXHjKqhcwXLwiWpG2AcHKmjsFj7rSejgvFizVPJHPRYB2cJRh4MsmdCoD4ahxP	2023-02-18T10:52:57.000Z	CreateMetadataAccountV2	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	229eCBRDbAYFdMesuUnwznVX7qN9pu3DFGx24s1uUB2b	11111111111111111111111111111111	0	23	229eCBRDbAYFdMesuUnwznVX7qN9pu3DFGx24s1uUB2b	229eCBRDbAYFdMesuUnwznVX7qN9pu3DFGx24s1uUB2b	[]			0
https://www.arweave.net/g3Y-99ekxZu7EwEnjUGDbb1EP_-j62jEDeRa0oAKW9Q?ext=json	AjABFaDTpyzENLckmno6mJ3MkyeLQsWDPq5uFHqEeBEW	Forest No.1	SysvarRent111111111111111111111111111111111	29Lkc87RRWVoACr7pXotjVEAJ8iSP8TLV9S1CzHf3zvw	NFTPro	178447675	[{“address”:“29Lkc87RRWVoACr7pXotjVEAJ8iSP8TLV9S1CzHf3zvw”,“share”:100,“verified”:true}]	4wA5jMb5CfoaAGUv4BR87cxQHj3igLSuoMWMF8WFbDxJ	true	178447675-58y4u85n1EZ3Jw7b1186ryzA6AFBkjtjNLbSmxdvJczjEgbpzzHb1B3QmF2knYntSdo3DKPSKTQCg9kybbEbyUDC-0-10	58y4u85n1EZ3Jw7b1186ryzA6AFBkjtjNLbSmxdvJczjEgbpzzHb1B3QmF2knYntSdo3DKPSKTQCg9kybbEbyUDC	2023-02-18T19:19:53.000Z	CreateMetadataAccountV2	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	84w5UYJr1M2FQ9fuN3Mnkjy8dF1kZZue6FNTdgD74MH8	11111111111111111111111111111111	10	72	29Lkc87RRWVoACr7pXotjVEAJ8iSP8TLV9S1CzHf3zvw	29Lkc87RRWVoACr7pXotjVEAJ8iSP8TLV9S1CzHf3zvw	[]	AARtaGrVezbP5sxuWcGpthAmtZVQ912gRWxuYFzFP775	0	500

Example Query

Query with partition filter

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

TokenMetadata_CreateMetadataAccountV3_instruction

NFT metadata creation instructions from Metaplex Token Metadata program on Solana. Records contain mint addresses, creator arrays, royalty settings, and metadata URIs for tracking NFT minting events and collection analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
`in_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_mint_authority`	`STRING`	Authority account with permission to mint new tokens to this address. Typically the same as the payer or update authority in NFT minting operations.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_remaining_accounts`	`JSON`	Additional accounts required for instruction execution beyond the standard account set. JSON array of Base58-encoded Solana public keys.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_update_authority`	`STRING`	Account authorized to modify the token metadata after creation. Base58-encoded Solana public key.
`in_creators`	`JSON`	Array of creator accounts and their ownership shares for the NFT. JSON objects containing address (Base58-encoded Solana public key), share (percentage as integer 0-100), and verified (boolean) fields.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_seller_fee_basis_points`	`STRING`	Seller fee charged on secondary sales expressed in basis points. String-encoded integer where 100 basis points equals 1%.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in_is_mutable`	`STRING`	Boolean flag indicating whether the token metadata can be modified after creation. String-encoded as ‘true’ or ‘false’.

Sample Data

in_uri	in_mint	in_payer	in_symbol	block_slot	in_creators	in_metadata	in_is_mutable	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	in_mint_authority	in_system_program	instruction_index	transaction_index	transaction_signer	in_update_authority	in_remaining_accounts	outer_executing_account	outer_instruction_index	in_seller_fee_basis_points
https://nftstorage.link/ipfs/bafybeic4gil5hq5seo26el7sk66k5v64zsmj7dlgifq6y7guxewnscaafi/0.json	6LePVPjVSAtk51aM6oMM82H5rtWjAaRaW3YacCgxPDPE	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	CBONG	153502116	[{“address”:“FzKuurBCvHjAjgUVFVSPfa3T8RkaZ1kYrDesZMvK5mcY”,“share”:0,“verified”:true},{“address”:“1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg”,“share”:100,“verified”:false}]	C55wUTEHDjZbU7Hh78EXY3RZyKGR6yopFgqhWHEVKU6Q	true	153502116-4E9sew3duVKBezcKk68nSKeoo6qVBE6Q5UN4BS1QmiFy2kSgGg1tkrBKJSVKswfbM3UfGzjKWDkJq9Td7JeoZk4N-1-11	4E9sew3duVKBezcKk68nSKeoo6qVBE6Q5UN4BS1QmiFy2kSgGg1tkrBKJSVKswfbM3UfGzjKWDkJq9Td7JeoZk4N	2022-10-03T13:47:53.000Z	CreateMetadataAccountV3	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	11111111111111111111111111111111	11	2	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	FzKuurBCvHjAjgUVFVSPfa3T8RkaZ1kYrDesZMvK5mcY	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	1	1000
https://nftstorage.link/ipfs/bafybeic4gil5hq5seo26el7sk66k5v64zsmj7dlgifq6y7guxewnscaafi/1.json	DkQXqi35VEjvTHjj9min7knCHHZYxJMWmRWK4bJo9WJ1	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	CBONG	153502120	[{“address”:“FzKuurBCvHjAjgUVFVSPfa3T8RkaZ1kYrDesZMvK5mcY”,“share”:0,“verified”:true},{“address”:“1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg”,“share”:100,“verified”:false}]	258u3ojtPNTaCiNpxVBe1XVt9D1MpHRjcdci8BWYbdi9	true	153502120-iBpusm5YmNgRJmA32QPcqvFqx8G6iH4mbve2vY2DKef8oH3tFt7Whne3srwpooc9JutD4vEx9Kb4VGSwYSpMZr3-1-10	iBpusm5YmNgRJmA32QPcqvFqx8G6iH4mbve2vY2DKef8oH3tFt7Whne3srwpooc9JutD4vEx9Kb4VGSwYSpMZr3	2022-10-03T13:47:55.000Z	CreateMetadataAccountV3	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	11111111111111111111111111111111	10	5	1234XWmeuYb2RQUyzzk6NupXoR5tUgK79m9MYhZ7aCXg	FzKuurBCvHjAjgUVFVSPfa3T8RkaZ1kYrDesZMvK5mcY	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	1	1000
https://nftstorage.link/ipfs/QmWa1ExWmwXpWD5vzdkFFE4prNmr2pqZqdrQAN1E9hixqZ/519.json	FoKfP9URbdJLkPURYJqXqogW4zarseY4ib2nhihiF6p4	12BWEJySVidsCnaY7YzqMD5d3PhmqyXSdicz8GJw4XoW	OTW	153523149	[{“address”:“6FpzpxcdQaKfqUW4Q5U6M4cmUfagNsYmHif6ioxPLrzG”,“share”:0,“verified”:true},{“address”:“9UWBd9R6nLAmBDvM9HoA74tD9yUk2VRfo9ZVVUYeb1bb”,“share”:100,“verified”:false}]	3BgJhpzVpQYt7tK717S7SJJJCEmpjseTSpaoiMfmrA83	true	153523149-4iNviL5BT4NoCYyT4ZgiGEBA3SXh37PPvUgNgGFfu74iAhiZ3a7X2e4HTDJ5eKcZPattFft7AvmmHtT837gZ1Qbw-1-11	4iNviL5BT4NoCYyT4ZgiGEBA3SXh37PPvUgNgGFfu74iAhiZ3a7X2e4HTDJ5eKcZPattFft7AvmmHtT837gZ1Qbw	2022-10-03T17:26:06.000Z	CreateMetadataAccountV3	metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s	12BWEJySVidsCnaY7YzqMD5d3PhmqyXSdicz8GJw4XoW	11111111111111111111111111111111	11	5	12BWEJySVidsCnaY7YzqMD5d3PhmqyXSdicz8GJw4XoW	6FpzpxcdQaKfqUW4Q5U6M4cmUfagNsYmHif6ioxPLrzG	[]	ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv	1	1000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

TokenMetadata_Create_instruction

TokenMetadata_CreateMetadataAccount_instruction

TokenMetadata_CreateMetadataAccountV2_instruction

TokenMetadata_CreateMetadataAccountV3_instruction

​Tables

​TokenMetadata_Create_instruction

​TokenMetadata_CreateMetadataAccount_instruction

​TokenMetadata_CreateMetadataAccountV2_instruction

​TokenMetadata_CreateMetadataAccountV3_instruction

Tables

TokenMetadata_Create_instruction

TokenMetadata_CreateMetadataAccount_instruction

TokenMetadata_CreateMetadataAccountV2_instruction

TokenMetadata_CreateMetadataAccountV3_instruction