Skip to main content

Table Details

PropertyValue
Table Namecelo.assets.stablecoin_transfers
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id
Clustering Key(s)block_timestamp::date, token_address
Search Optimizationfrom_address, to_address, transaction_hash, token_address

Table Columns

Column NameData TypeDescription
from_addressVARCHAR(42)Address where the stablecoin is being transferred from.
to_addressVARCHAR(42)Address where the stablecoin is being transferred to.
token_addressVARCHAR(42)Token address of the stablecoin transferred.
token_nameVARCHAR(16777216)Name of the stablecoin transferred.
token_symbolVARCHAR(16777216)Symbol of the stablecoin transferred.
raw_amount_strVARCHAR(16777216)Amount of tokens transferred (unnormalized) in string to retain precision.
raw_amountFLOATAmount of tokens transferred (unnormalized).
amount_strVARCHAR(16777216)Amount of tokens transferred, normalized in string to retain precision.
amountFLOATAmount of tokens transferred, normalized.
usd_amountFLOATThe USD amount of the tokens at the time of the transfer.
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.
transaction_hashVARCHAR(66)Transaction hash that this transfer belongs to.
transaction_indexNUMBER(38,0)The position of this transaction in the block. The first transaction has index 0.
log_indexNUMBER(38,0)The position of this log within the block. The first log has index 0.
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this transfer 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 stablecoin transfer.
currencyVARCHAR(16777216)The fiat currency that the stablecoin is pegged to (e.g., USD, EUR).
base_assetVARCHAR(16777216)The base asset or backing of the stablecoin.
is_bridgeBOOLEANWhether the stablecoin is a bridged version from another chain.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
_metadata_updated_atTIMESTAMP_LTZ(9)Timestamp of when the stablecoin metadata was last updated.