Skip to main content

Tables

BackedFactory_NewToken_event

Token deployment events from the Backed Factory contract recording the creation of new tokenized real-world assets. Emitted when the factory deploys a new token contract with its name, symbol, and address for tracking tokenized securities, bonds, and equity instruments.
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_newTokenSTRINGContract address of the newly created token. Hex-encoded, 0x-prefixed, 42-character string.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_symbolSTRINGSymbol of the token involved in the transaction or event.
addressin_nameremovedin_symbollog_indexin_newTokenblock_numberblock_timestamptransaction_hash
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7Backed Coinbase GlobalfalsebCOIN90xbbcb0356bb9e6b3faa5cbf9e5f36185d53403ac9107088832025-02-28T07:24:24.000Z0x9d904957952f3f603b3d749591d6ab8fcb4cb25f0c935a35e000d0f44b0277db
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7Backed NVIDIA CorpfalsebNVDA90xa34c5e0abe843e10461e2c9586ea03e55dbcc495107093622025-02-28T07:27:24.000Z0xbe2efd8a684f7e8acd9aee4e42efff7a67667d96652c452bc5aad71ded726744
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7Backed Alphabet IncfalsebGOOGL90xebee37aaf2905b7bda7e3b928043862e982e8f32107097402025-02-28T07:30:01.000Z0xac32d23fbb364c26f85764ea995c272af1b1c26052f7d873adf1a3de9f6e97b0
Query with partition filter
SELECT *
FROM `tt-contracts.backed_v1_sonic.BackedFactory_NewToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100