Skip to main content

​
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.
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_transcoderSTRINGAddress of the Livepeer transcoder (delegated validator) receiving the reward distribution. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountlog_indexblock_numberin_transcoderblock_timestamptransaction_hash
0x35bcf3c30594191d53231e4ff333e8a770453e40false3483713135611153465441810897770x72a798ed05f3b445fba4bafdf643028fb5ed03cc2024-02-15T18:52:06.000Z0x03906adc5bfe12a60e203a0b86eff1b53e844a5f459f29854d47782f4c79ea08
0x35bcf3c30594191d53231e4ff333e8a770453e40false1111836698992644475341810899640x22ae24c2d1f489906266609d14c4c0387909a38a2024-02-15T18:52:56.000Z0x2b7a4b7c8df7e58ae8d1d324ff93e7d51ef202e9963332c382dddb9ee63c83b5
0x35bcf3c30594191d53231e4ff333e8a770453e40false16943311674400002851541810900370x21d1130dc36958db75fbb0e5a9e3e5f5680238ff2024-02-15T18:53:14.000Z0x6085407ef2c24b5dc12adba7af958762642e96b90f0f93bf4c59957fdeb9bab9
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.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_faceValueSTRINGFace value of the winning ticket in wei (smallest unit of ETH on Arbitrum). Represents the maximum potential payout amount for the ticket redemption.
in_winProbSTRINGProbability 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_senderNonceSTRINGNonce value from the sender’s ticket representing the sequence number for replay protection. Increments with each new ticket issued by the sender address.
in_recipientRandSTRINGRandom 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_auxDataSTRINGAuxiliary 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.
addressremovedin_senderlog_indexin_auxDatain_winProbblock_numberin_faceValuein_recipientin_senderNonceblock_timestampin_recipientRandtransaction_hash
0xa8bb618b1520e284046f3dfc448851a1ff26e41bfalse0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e10x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4964934076977634961863091541739065898777249872213671366995479900000000000071393368120000000000000000xbe8770603daf200b1fa136ad354ba854928e602b12023-03-19T10:05:42.000Z876980183814954158477198026806614162709826734810564600478784421347919724021940x10e264e1bef15c657fb5273dad97155fc0a144c705232360095b3dde8fbc67be
0xa8bb618b1520e284046f3dfc448851a1ff26e41bfalse0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e10x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4964934076977634961863091541739065898777249872213671366995479900000000000071361493120000000000000000xa20416801ac2eacf2372e825b4a90ef52490c2bb12023-03-19T07:52:53.000Z1041320801881886989868392144586832060703930218621503299697808349560085483450110x53998f27c44ae7f2755edc404270a361b3df4a0a5d0ec5e63801e54b2d68edc0
0xa8bb618b1520e284046f3dfc448851a1ff26e41bfalse0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e10x0000000000000000000000000000000000000000000000000000000000000b5b0ffc9cc153817a33f5a9a0fb795ce4f65a34994f2635da86a5b1fe48a7f0deb4964934076977634961863091541739065898777249872213671366995479900000000000071254190120000000000000000x02b6aac33a397aaadee5227c70c69bb97f2cc52912023-03-19T00:14:38.000Z406395982201429655328858993734717041815646624278138539646538430155262897979860xabd2d652b2fcff9725add4545c6f6603cd3f88128b53145154f5b91c07f3ef84
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