Skip to main content

​
Tables

​
BlockRewardProcessed_event

Block reward distribution events from Berachain’s validator incentive system, recording base staking amounts and calculated reward payouts. Used for tracking validator economics and reward distribution patterns across the 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.
idSTRINGSequential integer identifier for the record within the table.
in_baseSTRINGToken or asset identifier serving as the base asset in a trading pair or financial instrument. String representation that can be either a contract address (hex-encoded, 0x-prefixed, 42-character string) or a ticker symbol.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
idaddressin_baseremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x8a63e0b1410ec95c8cdd190d789dc1ec5ab5661df764992a450fb72c680a3311-10x1ae7dd7ae06f6c58b4524d9c1f816094b1bccd8e500000000000000000false1006132941872178745133163292025-04-05T22:05:23.000Z0x8a63e0b1410ec95c8cdd190d789dc1ec5ab5661df764992a450fb72c680a3311
0xb382206cc78607690b51ab15810646acbb7e6c38c85bf93bf54159d19f6b7ef2-10x1ae7dd7ae06f6c58b4524d9c1f816094b1bccd8e500000000000000000false1006165997288236615133155582025-04-05T21:40:53.000Z0xb382206cc78607690b51ab15810646acbb7e6c38c85bf93bf54159d19f6b7ef2
0xd07df5eb9dd7e68b20a0f6e2deae1570fc9c6da603c7d4345bce8d492355e4ae-10x1ae7dd7ae06f6c58b4524d9c1f816094b1bccd8e500000000000000000false1006176384447240609133147752025-04-05T21:15:59.000Z0xd07df5eb9dd7e68b20a0f6e2deae1570fc9c6da603c7d4345bce8d492355e4ae
Query with partition filter
SELECT *
FROM `tt-contracts.berachain.BlockRewardProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
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.
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
0x00000000000000000000000000000000000000000x1fcca65fb6ae3b2758b9b2b394cb227eae404e1e0x9538e13c0e111c5b0525f1592079aa1586b4e9ccfalse102190462025-01-25T09:18:02.000Z0x5b9b070e4648674d3e4928bf0ff952ac618e74932eb333a70eb20ed7c2717264
0x00000000000000000000000000000000000000000x49a49ab0a048bcadb8b4e51c5c970c46bf889ccd0x9538e13c0e111c5b0525f1592079aa1586b4e9ccfalse1002069842025-01-25T03:03:07.000Z0x07c2647ee769fde814c58a45c841b283ab600b91ee826ddce76fee8ed5c8eaf0
0x00000000000000000000000000000000000000000x49a49ab0a048bcadb8b4e51c5c970c46bf889ccd0x83390ef6b20a29ccbf0955567556af519e86a958false1022075932025-01-25T03:22:00.000Z0xe12a92386b1dc44e958ef0f2eb9ce8ff5859f90cbffa5502498c5918f375a9cf
Query with partition filter
SELECT *
FROM `tt-contracts.berachain.ERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100