Skip to main content

Table Details

PropertyValue
Table Namemonad_testnet.assets.erc1155_token_transfers
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id
Clustering Key(s)block_timestamp::date
Search Optimizationtoken_address, from_address, to_address

Table Columns

Column NameData TypeDescription
event_typeVARCHAR(16777216)Type of transfer event for ERC1155 tokens. This can either be single_transfer or batch_transfer.
operatorVARCHAR(42)Address of the ERC1155 operator.
array_indexNUMBER(38,0)Index position within a batch transfer array. For single transfers, this value is 0.
from_addressVARCHAR(42)Address where the token is being transferred from.
to_addressVARCHAR(42)Address where the token is being transferred to.
token_addressVARCHAR(42)Token address of the asset transferred.
token_nameVARCHAR(16777216)Token name.
token_symbolVARCHAR(16777216)Token symbol.
token_idVARCHAR(16777216)The token ID of the token.
raw_amount_strVARCHAR(16777216)Amount of token transferred, unnormalized, in string (to retain precision).
raw_amountFLOATAmount of tokens transferred, unnormalized.
amount_strVARCHAR(16777216)Amount of token transferred, normalized, in string (to retain precision).
amountFLOATAmount of token transferred, normalized.
transaction_from_addressVARCHAR(42)The address of the sending party of this transaction.
transaction_to_addressVARCHAR(42)The address of the receiving party of this transaction (could be a contract address).
transaction_hashVARCHAR(66)The transaction hash that this transfer belongs to.
transaction_indexNUMBER(38,0)The position of this transaction in the block. The first transaction of a block has index 0.
log_indexNUMBER(38,0)The position of this log within the block. The first log of a block has index 0.
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this transaction was included on the blockchain.
block_numberNUMBER(38,0)The block number that the corresponding transaction of this transfer belongs to.
block_hashVARCHAR(66)The block hash that the corresponding transaction of this transfer belongs to.
unique_idVARCHAR(16777216)Unique ID generated for each transfer.
_tokens_updated_atTIMESTAMP_NTZ(9)Timestamp of when the token metadata was last updated.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh.