livepeer_v1_arbitrum

Tables

BondingManager_Reward_event

Reward distribution events from Livepeer’s BondingManager contract on Arbitrum, tracking token rewards paid to transcoders (video encoding nodes) for their work. Used for analyzing transcoder earnings, reward frequency, and protocol incentive distribution over time.

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_transcoder`	`STRING`	Address of the Livepeer transcoder (delegated validator) receiving the reward distribution. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_transcoder	block_timestamp	transaction_hash
0x35bcf3c30594191d53231e4ff333e8a770453e40	false	34837131356111534654	4	181089777	0x72a798ed05f3b445fba4bafdf643028fb5ed03cc	2024-02-15T18:52:06.000Z	0x03906adc5bfe12a60e203a0b86eff1b53e844a5f459f29854d47782f4c79ea08
0x35bcf3c30594191d53231e4ff333e8a770453e40	false	11118366989926444753	4	181089964	0x22ae24c2d1f489906266609d14c4c0387909a38a	2024-02-15T18:52:56.000Z	0x2b7a4b7c8df7e58ae8d1d324ff93e7d51ef202e9963332c382dddb9ee63c83b5
0x35bcf3c30594191d53231e4ff333e8a770453e40	false	169433116744000028515	4	181090037	0x21d1130dc36958db75fbb0e5a9e3e5f5680238ff	2024-02-15T18:53:14.000Z	0x6085407ef2c24b5dc12adba7af958762642e96b90f0f93bf4c59957fdeb9bab9

Example Query

Query with partition filter

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

TicketBroker_WinningTicketRedeemed_event

Winning ticket redemption events from Livepeer’s probabilistic micropayment system on Arbitrum, recording when orchestrators successfully redeem payment tickets with sender, recipient, face value, and winning probability data. Used for analyzing payment flows and network economics in the decentralized video transcoding protocol.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_faceValue`	`STRING`	Face value of the winning ticket in wei (smallest unit of ETH on Arbitrum). Represents the maximum potential payout amount for the ticket redemption.
`in_winProb`	`STRING`	Probability that the Livepeer payment ticket will be a winning ticket, expressed as a large integer value. This determines the likelihood of the ticket being redeemed for payment based on the protocol’s probabilistic micropayment system.
`in_senderNonce`	`STRING`	Nonce value from the sender’s ticket representing the sequence number for replay protection. Increments with each new ticket issued by the sender address.
`in_recipientRand`	`STRING`	Random value generated by the ticket recipient, used as entropy in the probabilistic payment verification process. This large integer varies per ticket redemption and helps ensure fairness in Livepeer’s ticket-based micropayment system.
`in_auxData`	`STRING`	Auxiliary data associated with the Livepeer ticket redemption, stored as a hex-encoded string. Contains additional metadata or parameters required for ticket validation on the Livepeer network.

Sample Data

address	removed	in_sender	log_index	in_auxData	in_winProb	block_number	in_faceValue	in_recipient	in_senderNonce	block_timestamp	in_recipientRand	transaction_hash
0xa8bb618b1520e284046f3dfc448851a1ff26e41b	false	0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e	1	0x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4	9649340769776349618630915417390658987772498722136713669954799000000000000	71393368	12000000000000000	0xbe8770603daf200b1fa136ad354ba854928e602b	1	2023-03-19T10:05:42.000Z	87698018381495415847719802680661416270982673481056460047878442134791972402194	0x10e264e1bef15c657fb5273dad97155fc0a144c705232360095b3dde8fbc67be
0xa8bb618b1520e284046f3dfc448851a1ff26e41b	false	0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e	1	0x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4	9649340769776349618630915417390658987772498722136713669954799000000000000	71361493	12000000000000000	0xa20416801ac2eacf2372e825b4a90ef52490c2bb	1	2023-03-19T07:52:53.000Z	104132080188188698986839214458683206070393021862150329969780834956008548345011	0x53998f27c44ae7f2755edc404270a361b3df4a0a5d0ec5e63801e54b2d68edc0
0xa8bb618b1520e284046f3dfc448851a1ff26e41b	false	0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e	1	0x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4	9649340769776349618630915417390658987772498722136713669954799000000000000	71254190	12000000000000000	0x02b6aac33a397aaadee5227c70c69bb97f2cc529	1	2023-03-19T00:14:38.000Z	40639598220142965532885899373471704181564662427813853964653843015526289797986	0xabd2d652b2fcff9725add4545c6f6603cd3f88128b53145154f5b91c07f3ef84

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BondingManager_Reward_event

TicketBroker_WinningTicketRedeemed_event

​Tables

​BondingManager_Reward_event

​TicketBroker_WinningTicketRedeemed_event

Tables

BondingManager_Reward_event

TicketBroker_WinningTicketRedeemed_event