tron

Tables

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`miner_hex`	`STRING`	Validator address that produced this block in hexadecimal format with 0x prefix. Corresponds to the EVM-compatible representation of the same address shown in miner field.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.

Sample Data

size	miner	nonce	number	uncles	mix_hash	miner_hex	timestamp	block_hash	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	transactions_root
177	TAAdjpNYfeJ2edcETNpad1QpQWJfyBdB9V	0x0000000000000000	32255035	[]	0x0000000000000000000000000000000000000000000000000000000000000000	0x022939a4a06cbc7b384096c1af8657ec435173af	2021-07-25T19:22:00.000Z	0x0000000001ec2c3bca44f9c0971a2e789ceb798044e5e16c8e8b05a766ca3875	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x	0x0000000001ec2c3abd670aeb84c01b32ed8ea308800008cc53145863ed2745e9	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000
177	TAAdjpNYfeJ2edcETNpad1QpQWJfyBdB9V	0x0000000000000000	32240399	[]	0x0000000000000000000000000000000000000000000000000000000000000000	0x022939a4a06cbc7b384096c1af8657ec435173af	2021-07-25T07:08:57.000Z	0x0000000001ebf30f81755647a50ce02103ae74a0d1a31f00ad1c8c843f7fa4a4	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x	0x0000000001ebf30e64dee83ccddf75edbc71efbc664fdf8faa55a7585681cbd7	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000
177	TCEo1hMAdaJrQmvnGTCcGT2LqrGU4N7Jqf	0x0000000000000000	32259271	[]	0x0000000000000000000000000000000000000000000000000000000000000000	0x18e2e1c6cdf4b74b7c1eb84682e503213a174955	2021-07-25T22:54:12.000Z	0x0000000001ec3cc7e411c5b3c59c596d7763070ce2f5a016fa7acd009cbc2a00	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x	0x0000000001ec3cc673cdbbad28f200324058cd652154af766ecf91bf00b528d8	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.tron.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

internal_transactions

Contract-triggered value transfers and subcalls on Tron, including caller/receiver addresses, call values, and execution status. Used for analyzing smart contract interactions and tracing multi-step transaction flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`internal_transaction_hash`	`STRING`	Unique identifier for the internal transaction event occurring within a parent transaction. Hex-encoded, 0x-prefixed 64-character hash that distinguishes individual contract calls or value transfers nested within the same on-chain transaction.
`internal_transaction_index`	`INT64`	Position of this internal transaction within the parent transaction’s execution trace. Sequential integer starting from 0, uniquely identifying each internal call within a single transaction.
`caller_address_hex`	`STRING`	Contract address initiating the internal transaction in hex format. Base58-encoded Tron address converted to hex-encoded, 0x-prefixed 40-character string for cross-chain compatibility.
`caller_address`	`STRING`	Address of the contract or account that initiated this internal call in Tron’s base58check format (starting with ‘T’). This is the sender within the smart contract execution, which may differ from the original transaction signer.
`transfer_to_address_hex`	`STRING`	Contract address receiving the internal transfer on Tron, represented in hex-encoded format with 0x prefix. This is the hexadecimal equivalent of the base58-encoded transfer_to_address.
`transfer_to_address`	`STRING`	Contract address receiving the internal transaction. Base58-encoded Tron address format (begins with ‘T’), may be a user wallet or smart contract.
`rejected`	`BOOL`	Indicates whether the internal transaction execution failed on-chain. A true value means the call was reverted, while false or null typically indicates successful execution.
`note`	`STRING`	Describes the type of internal call or operation performed within the transaction. Common values include “call” for contract-to-contract interactions on the Tron network.
`call_value_info`	`ARRAY<STRUCT<call_value STRING, token_id STRING>>`	Value and token identifier for TRX or TRC10 token transfers in this internal transaction. Contains `call_value` (amount transferred in sun for TRX) and `token_id` (TRC10 identifier, null for TRX transfers).

Sample Data

note	block_number	caller_address	block_timestamp	call_value_info	transaction_hash	caller_address_hex	transfer_to_address	transfer_to_address_hex	internal_transaction_hash	internal_transaction_index
call	32091698	TQ6961nJ24tooqyeYrdk6Zf8cE99PeGfYH	2021-07-20T03:03:33.000Z	[{“token_id”:null,“call_value”:null}]	0x0955d30b12a22434b0668c00fb64ac51d4fcfa0532844e4244f179f7554caa94	0x9ae167ad8bc11563cabb7b649adc8b446d260152	TZ8X4674TPKhaLbkfitYqaZiADs5X5KtEG	0xfe0db4b8015a3254531140e79ab412a287af4ff5	0x5b8b6e120621106be0c087e62f1df5bab873a528f2f36fa8658ff86b7f477aaa	30
call	32098293	TVz5DomRgT4o6tewNWjJWUynSQirLfG7Km	2021-07-20T08:33:51.000Z	[{“token_id”:null,“call_value”:null}]	0x0a9354e8c924ea8d91ee3b3135bc69c6ec7bc7142ecf5b8b2de0ee537b732501	0xdb8c6fe27a2038ed2010e0a565a8303283c66043	TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	0xa614f803b6fd780986a42c78ec9c7f77e6ded13c	0x0f3d37b5996fccfafa04b55413a29c1c3f5f8915dc146046c9f33527073d2d21	22
call	32112310	TPY3P5CNW4XdFzqrJEf5ehvfp9Pg2Bjjgz	2021-07-20T20:15:27.000Z	[{“token_id”:null,“call_value”:null}]	0x1dc4b0b531201efa93a239afe59fa9b24c010702aa442cfea057f0836923958e	0x94cf54c88551774ace7425879c28454494bdc6a7	TKSLNVrDjb7xCiAySZvjXB9SxxVFieZA7C	0x67da83cfc7d0a1894bb52d7fb12ac8f536b0716f	0x955c643fd730b0dac8ef2b46d37d68f61a538da4d18e0bf2069c876f31419f68	21

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.tron.internal_transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

logs

Event logs emitted by smart contracts during transaction execution, containing indexed topics for efficient filtering and ABI-encoded data payloads. Primary source for tracking contract interactions, token transfers, and state changes across blockchain networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
`address_hex`	`STRING`	Contract address that emitted the log event in hex format. Hex-encoded, 0x-prefixed 40-character string representation of the Tron address.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`topics`	`ARRAY<STRING>`	Indexed event parameters from the emitted log. Array of 66-character hex strings including 0x prefix, where the first element is the event signature hash and subsequent elements are indexed parameters.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.

Sample Data

data	topics	address	removed	log_index	block_hash	address_hex	block_number	block_timestamp	transaction_hash	transaction_index
0x4c83c9b67c803fc1ac6922c42a883e03bf23b4c678353eb4953f572207cf058d00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000084d20c88bd00000000000000000000000000000000000000000000000000000000000000400000000000000000000000005261c7bfe92d2f9853cce7c8624f31a4d5fef6c70000000000000000000000000000000000000000000000000000000000000001000000000000000000000041a614f803b6fd780986a42c78ec9c7f77e6ded13c00000000000000000000000000000000000000000000000000000000	[“0x1246c6f8fd9f4abc542c7c8c8f793cfcde6b67aed1976a38aa134fc24af2dfe3”,“0x000000000000000000000000e36c6ed5ee69f91fc91e6edaeab00afb890abc95”]	TA1XrrmSmZDNVxzYCcMfBokH9WsRxZjdMM	false	12	0x0000000001b8e43354659af8c4ed248eb473982768d4929ff4d0e6dae3fef9bd	0x00709305abd22d06c344c7ae2c9a094e8f04c54f	28894259	2021-03-30T03:47:45.000Z	0xe540a32bb2434703f997fc316b9196f29983a3575e0badcfa67d01cc524787b8	21
0x7fcd268f1faaceef04a4f5805d10243079e035f5e83c9086b853ba258ba0cb6b00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000084d20c88bd00000000000000000000000000000000000000000000000000000000000000400000000000000000000000005261c7bfe92d2f9853cce7c8624f31a4d5fef6c70000000000000000000000000000000000000000000000000000000000000001000000000000000000000041a614f803b6fd780986a42c78ec9c7f77e6ded13c00000000000000000000000000000000000000000000000000000000	[“0x1246c6f8fd9f4abc542c7c8c8f793cfcde6b67aed1976a38aa134fc24af2dfe3”,“0x000000000000000000000000ce7e022fb6720f31d2134db54306dc0802ae3b26”]	TA1XrrmSmZDNVxzYCcMfBokH9WsRxZjdMM	false	11	0x0000000001b8e4925f104ec0c49869ba7b277457402ac71bb69067e65666afa1	0x00709305abd22d06c344c7ae2c9a094e8f04c54f	28894354	2021-03-30T03:52:30.000Z	0x4e2979f55d7a99b29e1da91508d1b03b19c3e8b8c3c748ef1396050f9e909fb5	12
0x313d44956e27560d4c4f1dec24921201046bfa5d5ae874f111afb81872005d5d00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000084d20c88bd00000000000000000000000000000000000000000000000000000000000000400000000000000000000000005261c7bfe92d2f9853cce7c8624f31a4d5fef6c70000000000000000000000000000000000000000000000000000000000000001000000000000000000000041a614f803b6fd780986a42c78ec9c7f77e6ded13c00000000000000000000000000000000000000000000000000000000	[“0x1246c6f8fd9f4abc542c7c8c8f793cfcde6b67aed1976a38aa134fc24af2dfe3”,“0x0000000000000000000000001a695ebe2f03296c5e56e4ba6a828b39cecb45d6”]	TA1XrrmSmZDNVxzYCcMfBokH9WsRxZjdMM	false	192	0x0000000001b8e53b36d986c64c5ab9adb6dd87e8ef78ca2e27738d038f97f1a1	0x00709305abd22d06c344c7ae2c9a094e8f04c54f	28894523	2021-03-30T04:00:57.000Z	0x1004743ee83c8f956484a4155cfaaf481304136599e83667a2adba6cda0ddd6c	191

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.tron.logs`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`from_address_hex`	`STRING`	Hex-encoded representation of the sender’s address with 0x prefix, converting Tron’s Base58 address format to standard hexadecimal. Always present for valid transactions.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`r`	`STRING`	ECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
`s`	`STRING`	ECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
`to_address_hex`	`STRING`	Destination address of the transaction in hex-encoded format with 0x prefix. Functionally equivalent to `to_address` but using hexadecimal representation instead of Tron’s base58 encoding.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_type`	`INT64`	EIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`receipt_contract_address_hex`	`STRING`	Contract address created by this transaction in hex-encoded format (0x-prefixed), populated only for contract deployment transactions. Null for standard transfers and contract calls.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_info_asset_issue_id`	`INT64`	Identifier for Tron TRC-10 asset issuance transactions. Null for standard TRX transfers and smart contract interactions.
`receipt_info_contract_address`	`STRING`	Contract address created by this transaction if it was a contract deployment. Null for all other transaction types including simple transfers and contract interactions.
`receipt_info_exchange_received_amount`	`INT64`	Amount received from a decentralized exchange (DEX) trade executed within this transaction, denominated in SUN (smallest TRX unit). Null when transaction does not involve DEX operations.
`receipt_info_contract_result`	`ARRAY<STRING>`	Execution result of a smart contract call returned by the Tron Virtual Machine (TVM). Empty string indicates successful execution; may contain error data when transaction fails.
`receipt_info_result`	`STRING`	Execution result status code for the transaction’s receipt on TRON. Typically null for successful transactions, non-null values indicate specific error conditions.
`receipt_info_res_message`	`STRING`	Human-readable error or status message returned by the transaction execution. Null when transaction succeeds, may contain error details on failure.
`receipt_info_fee`	`INT64`	Network fee charged for this transaction in SUN (smallest TRX unit, 1 TRX = 1,000,000 SUN). Covers bandwidth and energy costs on the Tron network.
`receipt_info_withdraw_amount`	`INT64`	Amount of TRX withdrawn from staked resources in this transaction, measured in sun (1 TRX = 1,000,000 sun). Null when the transaction does not involve stake withdrawals.
`receipt_info_withdraw_expire_amount`	`INT64`	TRX amount from expired unstaking operations that became available to withdraw in this transaction. Null when no expired unstaking withdrawals occurred.
`receipt_info_unfreeze_amount`	`INT64`	Amount of TRX unfrozen in this transaction, denominated in sun (1 TRX = 1,000,000 sun). Null when no unfreezing occurred.
`receipt_info_energy_fee`	`INT64`	Bandwidth fee paid in SUN for energy consumption when the account’s frozen energy is insufficient. Null when transaction did not consume additional energy beyond account’s frozen balance.
`receipt_info_energy_penalty_total`	`INT64`	Total energy penalty charged due to excessive resource consumption or bandwidth violations. Typically null for standard transactions; populated when network resource limits are exceeded.
`receipt_info_energy_usage`	`INT64`	Total energy consumed by this transaction for smart contract execution. Null for simple TRX transfers; populated when contract calls require computational resources.
`receipt_info_energy_usage_total`	`INT64`	Total energy consumed by the transaction including energy from caller and contract owner. Null for simple transfers without smart contract execution.
`receipt_info_net_fee`	`INT64`	Fee in sun paid for bandwidth consumption in this transaction. Null if no bandwidth fee was charged.
`receipt_info_net_usage`	`INT64`	Bandwidth points consumed by the transaction for network resource usage on Tron. Typically null when bandwidth fees are paid via TRX burn instead of bandwidth point allocation.
`receipt_info_origin_energy_usage`	`INT64`	Energy units consumed from the contract deployer’s frozen energy resources during transaction execution. Null for transactions that did not invoke smart contracts or used only bandwidth.
`receipt_info_cancel_unfreeze_v2_amount`	`ARRAY<STRUCT<key STRING, value INT64>>`	Structured data representing amounts being cancelled from Tron’s unstaking v2 mechanism within this transaction. Typically empty for standard transfers, populated when users cancel pending unstake operations.
`internal_transactions_count`	`INT64`	Number of internal transactions (contract-to-contract or contract-to-account calls) triggered by this transaction. Null when no internal transactions occurred.

Sample Data

r	s	v	input	value	gas_price	block_hash	to_address	block_number	from_address	receipt_status	to_address_hex	block_timestamp	from_address_hex	receipt_info_fee	transaction_hash	transaction_index	receipt_logs_bloom	receipt_info_net_fee	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price	receipt_info_contract_result	receipt_info_cancel_unfreeze_v2_amount
0x9fd20c2835aca24b792a8ef58bee665ffba7b134c727ba3bbb402cf8b267f05d	0x1c139e65c1273df38ac37122a7455d50f28a7497926636844b71927c19477dbc	27	0x	400000000	10	0x0000000001332a54df53ae7cdd927e9bf38b3a486a40e3052394809ca6f307b3	TFuZC1uxPgRcxMHnrk9pp12iNaDz1rs8Am	20130388	TAGoxYjDfXPRigzDakBxZHZWd89MqcdPuP	true	0x411ff197a3b042aea6ad8466fdcbae46442bf0f0	2020-05-28T08:56:54.000Z	0x03544071e124d7ed574fa845137f01e8aa4ba513	2760	0x0a9c42fd39fde516e35f8abcabe296d5068a655fc1d83a236684da86cbeb7c7e	8	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2760	8	246177	10	[""]	[]
0x9bf2511af4b8c2a693eb70afd97fe4a68bcccd284d16fad829e35ec6a8c7752f	0x580575e927a264661dee709a8dbedaaf03ea13e80f89f275edc52d73b850ca54	27	0x	400000000	10	0x00000000013320c46a1793e262b29795487d9683885472cfc99d065f5694cc21	TNaDXpHED64bgw1zY1ttF17g3y1M4CXGEF	20127940	TAGoxYjDfXPRigzDakBxZHZWd89MqcdPuP	true	0x8a4082bf7911bbafae53f76b4620399fa1f17cac	2020-05-28T06:54:30.000Z	0x03544071e124d7ed574fa845137f01e8aa4ba513	2760	0x282e3fec0792fce2dcb0d44f4e4a7c8ef37a3cc1816db44c42eadc50bd1605e0	10	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2760	10	115371	10	[""]	[]
0xab1b176bc1a18c71de57d8f35a4ead5336a2e947f1895dc6577c679f2e6bf4d9	0x39a73f2fc8f1cab941631c65c0a70d51c2a72be05cda7e427cf776827e387c17	28	0x	400000000	10	0x00000000013329323507a914831def5d94fc4aa9df08486889eafebb1d12e6d2	TFVZpsX8GmSwjiKh4GXZ1pdia7DVpUsYRz	20130098	TAGoxYjDfXPRigzDakBxZHZWd89MqcdPuP	true	0x3c967db6ea6d2ac21385fc00b12af48af670b96b	2020-05-28T08:42:24.000Z	0x03544071e124d7ed574fa845137f01e8aa4ba513	2780	0xea504471a29b4e8794a6ae00d997734a21c0aa4a7db96fd38f2507bd0cc0c61d	7	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2780	7	202890	10	[""]	[]

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.tron.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

wallet_blocks

Token sale participation records on Tron, tracking user purchases of TRC-10 tokens during initial issuance events. Contains buyer addresses, token identifiers (hex-encoded names), and purchase amounts for analyzing early token distribution and crowd sale activity.

Columns

Column	Type	Description
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`type`	`STRING`	Transaction type indicating the specific contract operation performed. All sample values show ParticipateAssetIssueContract, representing participation in Tron token issuance events (TRC10 token purchases).
`owner_address`	`STRING`	Tron wallet address that initiated or owns the transaction participating in a TRC-10 token issuance. Base58-encoded address beginning with ‘T’ that identifies the participant purchasing tokens.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`amount`	`STRING`	Amount transferred in the transaction or operation. Negative values indicate debits, positive values indicate credits.
`asset_name`	`STRING`	Hex-encoded identifier of the TRC10 token being participated in or transferred. When decoded from hex, reveals human-readable token names like “GEMS”, “COFFEE”, or “LoveHearts”.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.

Sample Data

type	amount	asset_name	to_address	block_number	owner_address	block_timestamp	transaction_hash
ParticipateAssetIssueContract	500000	24454544	TVWbwZ13tPjRUgXn1rKHmR1Nf6szgEftB8	3793266	TE6yif4xXNyaPW8tz3qnKBFuWmZvcg2ikS	2018-11-04T11:44:27.000Z	0x4f1a4c6a8913f32ef0c8acbac96704bd39605c3f1a97271df9a2b54d8508291a
ParticipateAssetIssueContract	25000000	54524f4e474f4c44	TXr6ScFtkntXGQURAwJkCY7JzoQAyLsv6g	3802513	TR1sZJiYBoyD8Jj7F156JDoncqbR2AWXZt	2018-11-04T19:27:00.000Z	0x484d15d565f262a487628dce761a99b89cd351a86e840ec26b26984e40ae3fa4
ParticipateAssetIssueContract	330000000	245452584c6f7474657279	TBrwiwUz7PnGaTu7oc9KBfnt9vEjtzsDri	3800413	TTTyju2b9PM8PgwHhqtFB3CXqbFM9qqBWr	2018-11-04T17:41:54.000Z	0x6523a8df74cd1a99b6a641c320e0fe3377c8ebc529eeeeba2a15d5cf92fffc82

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.tron.wallet_blocks`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

internal_transactions

logs

transactions

wallet_blocks

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​internal_transactions

​logs

​transactions

​wallet_blocks

Tables

blocks

internal_transactions

logs

transactions

wallet_blocks