| event_type | VARCHAR(16777216) | Transfer event type specific to ERC1155 tokens. Either ‘transfer_single’ or ‘batch_transfer’. |
| array_index | NUMBER(38,0) | Index position within a batch transfer array. For single transfers, this value is 0. |
| address | VARCHAR(42) | Address of the account that was credited or debited amount of ERC1155 token |
| counterparty_address | VARCHAR(42) | The address of counter party of this credit or debit transfer |
| token_address | VARCHAR(42) | Token address of the ERC1155 token |
| token_name | VARCHAR(16777216) | Name of the ERC1155 token |
| token_symbol | VARCHAR(16777216) | Token symbol of this token |
| token_id | VARCHAR(16777216) | Unique ID of the ERC1155 token |
| raw_amount_str | VARCHAR(16777216) | Balance of tokens (unnormalized) in string |
| raw_amount | FLOAT | Balance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved |
| amount_str | VARCHAR(16777216) | Amount of tokens moved in string |
| amount | FLOAT | Amount of tokens moved |
| usd_amount | VARCHAR(16777216) | The amount of tokens moved, in USD. |
| usd_exchange_rate | VARCHAR(16777216) | Exchange rate used to calculate the USD amount. |
| operator | VARCHAR(42) | The operator address authorized by the NFT owner to transfer tokens on their behalf. |
| transaction_from_address | VARCHAR(42) | The address of the sending party of this transaction. |
| transaction_to_address | VARCHAR(42) | The address of the receiving party of this transaction. |
| transaction_hash | VARCHAR(66) | Transaction hash that this transfer belongs to |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block. The first transaction has index 0. |
| log_index | NUMBER(38,0) | The position of this log within the block. The first log has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred |
| block_number | NUMBER(38,0) | The block number that the corresponding transaction of this transfer belongs to |
| block_hash | VARCHAR(66) | The block hash that the corresponding transaction of this transfer belongs to |
| unique_id | VARCHAR(16777216) | Unique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type |
| _tokens_updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the token metadata was last updated. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh |
