Skip to main content

​
Tables

​
ERC20_Transfer_event

ERC-20 token transfer events decoded from transaction logs, containing sender address, recipient address, and token amount. Primary source for tracking fungible token flows and wallet holdings across EVM-compatible blockchains.
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.
address_base58STRINGBase58-encoded Tron contract address corresponding to the hex-encoded address field. This is Tron’s native address format, starting with ‘T’ and used in wallets and explorers.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberaddress_base58block_timestamptransaction_hash
0x7b1b6e07a157cb4bdaa6906b6c461f7d8c9c316d0x01771ca76e32b2340ac4715f17bbc9e2a5801b380xd6f0cd08cb576b08d36ad1ed5750db3e62a688a1false1753759809TA6xNHwEUdMk1ftvKfvsQXAayrBtuyoRY92023-08-13T04:46:57.000Z0x3397a0f8d234e4e3abf07d7412c1a64d4c31de091eb7ba364121dc35f2742e6e
0x18670a845732863eb04fefa1807660cfd9d60fc20x01771ca76e32b2340ac4715f17bbc9e2a5801b380xd6f0cd08cb576b08d36ad1ed5750db3e62a688a1false1153759821TA6xNHwEUdMk1ftvKfvsQXAayrBtuyoRY92023-08-13T04:47:33.000Z0x2a59b33242b32921af062c1e6fa4b13061d254702e7b015c71cc09cc9fd8b397
0x82d1e5c078aa995bbb93efb0e2d45fa26d75adcf0x01771ca76e32b2340ac4715f17bbc9e2a5801b380x9c9fadd77a8ca689c1e15deb05c485ee493cf68ffalse11453759886TA6xNHwEUdMk1ftvKfvsQXAayrBtuyoRY92023-08-13T04:50:48.000Z0x1c66bc7420777cdfa16c10da8b60186ff4882acdf5b033c42c109e1970ffc607
Query with partition filter
SELECT *
FROM `tt-contracts.tron.ERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
TRC20_Transfer_event

Token transfer events from TRC-20 contracts on the Tron blockchain, capturing sender, recipient, value, and contract address for each transfer. Used for analyzing token flows, wallet activity, and TRC-20 token usage patterns across the Tron network.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
TLjuXc7xknySr1aYxzL5trdXm3SWMx8kxSfalse104133201692019-10-04T16:15:06.000Z0x7d7738492d29715f9b78625c9a990cce6eb23007b598a15c33d9cf7bfd823d06
TLjuXc7xknySr1aYxzL5trdXm3SWMx8kxSfalse31133154522019-10-04T12:19:12.000Z0x430ae6516597bbb25bc13ad5ef739fd8e6826e50f988fc7b5777878d962115d5
TLjuXc7xknySr1aYxzL5trdXm3SWMx8kxSfalse111133177702019-10-04T14:15:06.000Z0x3a48ffbe02395661553e25683e4185b60dfb44052664ee4ec8d724accef05cb6
Query with partition filter
SELECT *
FROM `tt-contracts.tron.TRC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100