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 Alphabet IncfalsebGOOGL90xebee37aaf2905b7bda7e3b928043862e982e8f32360615552024-09-18T08:51:15.000Z0xde892b9eaf53cebcb8e52d88cab4a44f6795094acb6dcd4905fe443ce9a846d9
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7Backed GameStop CorpfalsebGME140x7212088a11b4d8f6fc90fbb3dfe793b45dd72323360616192024-09-18T08:56:50.000Z0x00a2910989f4c1398949eb13f066378e8fc4a0e433794d33cbb9618195aad9f4
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7Backed CSBGC3 CHF Swiss Domestic Government Bond 0-3yrfalsebCSBGC3140xd8b95b1987741849ca7e71e976aeb535fd2e55a2360616102024-09-18T08:56:05.000Z0x8fd0fd7a31c936250ac9d40b35faec606dfed8721acfa9ffce1d143c92444a4b
Query with partition filter
SELECT *
FROM `tt-contracts.backed_v1_gnosis.BackedFactory_NewToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100