backed_v1_polygon

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newToken`	`STRING`	Contract address of the newly created token. Hex-encoded, 0x-prefixed, 42-character string.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.

Sample Data

address	in_name	removed	in_symbol	log_index	in_newToken	block_number	block_timestamp	transaction_hash
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7	Backed Alphabet Inc	false	bGOOGL	164	0xebee37aaf2905b7bda7e3b928043862e982e8f32	61894103	2024-09-16T12:10:45.000Z	0x9e198866339b672dd0387dc015b36d05e196dc12b0ffe45ed0ce8fe05fb32c1b
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7	Backed MicroStrategy Inc	false	bMSTR	191	0xac28c9178acc8ba4a11a29e013a3a2627086e422	61894078	2024-09-16T12:09:51.000Z	0xd9df66e6b27479ed42f8dad85219567a15ac70d6eb6e61f28c29fdf6ff6f47f4
0x66287339fb0dd3f3a89d41cdf103ee8f1f90cbe7	Backed Tesla Inc	false	bTSLA	166	0x14a5f2872396802c3cc8942a39ab3e4118ee5038	61894040	2024-09-16T12:08:31.000Z	0x1323c6fa0069b6f04fefdee3089a9e0868dcb95ac2dc4259b7d2c2b696e8772a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.backed_v1_polygon.BackedFactory_NewToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

backed_v1_gnosis backed_v1_sonic

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BackedFactory_NewToken_event

​Tables

​BackedFactory_NewToken_event

Tables

BackedFactory_NewToken_event