Skip to main content

​
Tables

​
BondingManager_Reward_event

Reward distribution events from Livepeer’s BondingManager contract on Ethereum, recording token amounts paid to transcoders (video processing nodes) for their work. Used for analyzing transcoder earnings, network participation incentives, and token emission patterns.
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_transcoderSTRINGEthereum address of the transcoder (video node operator) receiving the reward in the Livepeer network. Always populated with a 0x-prefixed 40-character hex string identifying the delegated transcoder.
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
0x511bc4556d823ae99630ae8de28b9b80df90ea2efalse1358714759382554110306778913300x345551571c5ef20111c6168b9a498dfb836e7c092019-06-04T06:49:36.000Z0x12af8a792d87acc77227dbe93324942b12d639d1ff12b3633092727685a36887
0x511bc4556d823ae99630ae8de28b9b80df90ea2efalse27973431347223176624010578913690xd18a02647d99dc9f79afbe0f58f8353178e6141f2019-06-04T06:57:28.000Z0x1546dab0d69e65447ecfb7b4517fdb4f2dd34d2e0630d70ec1abeae7d84c66fc
0x511bc4556d823ae99630ae8de28b9b80df90ea2efalse2935542369657491788825978913460x21d1130dc36958db75fbb0e5a9e3e5f5680238ff2019-06-04T06:52:45.000Z0xaa2e1fdefa0389b3c53082e5e427d139a9143329701804879b82fd05ff6d22c8
Query with partition filter
SELECT *
FROM `tt-contracts.livepeer_v1_ethereum.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 Ethereum, recording when broadcasters’ payment tickets are successfully redeemed by orchestrators. Contains ticket parameters including face value, win probability, sender/recipient addresses, and cryptographic proof data for analyzing payment settlement patterns.
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 redeemed ticket denominated in wei (smallest ETH unit, 1e-18 ETH). Represents the payment amount the recipient receives upon successful ticket redemption.
in_winProbSTRINGProbability threshold that determines if a ticket wins in Livepeer’s probabilistic micropayment system. Represented as a large integer value where higher numbers indicate lower winning probability.
in_senderNonceSTRINGNonce value from the sender at the time of ticket creation, used to ensure ticket uniqueness. Increments sequentially with each new ticket issued by the sender address.
in_recipientRandSTRINGCryptographic random value generated by the ticket recipient used in the probabilistic payment protocol. This large integer serves as entropy to determine winning tickets in Livepeer’s payment system.
in_auxDataSTRINGAuxiliary data field containing additional context or metadata for the winning ticket, typically including block number and transaction-specific identifiers. Hex-encoded string with 0x prefix, commonly used in Livepeer’s probabilistic micropayment protocol.
addressremovedin_senderlog_indexin_auxDatain_winProbblock_numberin_faceValuein_recipientin_senderNonceblock_timestampin_recipientRandtransaction_hash
0x5b1ce829384eebfa30286f12d1e7a695ca45f5d2false0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e2710x00000000000000000000000000000000000000000000000000000000000007b8bf9a98e27f460175c8deb350ee258374802198e81d43ccf01e353f9a5e91a623617557809265686375592378586713002175217439918216749674877108000000000000113835981875000000000000000xbdcbe92befbf36d63ec547bba5842997d77dc84112020-12-04T03:01:52.000Z756479081995463418282836115062832186962093831044630410181671275115964218513800x979fd68aae04cb04cfb427a9aa851baa6aecd79ba6760911c1fe6ce1c37dc28c
0x5b1ce829384eebfa30286f12d1e7a695ca45f5d2false0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e1540x00000000000000000000000000000000000000000000000000000000000007b8bf9a98e27f460175c8deb350ee258374802198e81d43ccf01e353f9a5e91a623617557809265686375592378586713002175217439918216749674877108000000000000113840611875000000000000000xe3a5793d7c1d2a04a903fa1695b3e3555d6084ca12020-12-04T04:49:35.000Z1018578154160994379918309653188395187047386696210746622073173585921144021650580xcc17a69903dc08e7534453c5d50d24f950c4c09d54081502bb9747bd9f3422c2
0x5b1ce829384eebfa30286f12d1e7a695ca45f5d2false0xc3c7c4c8f7061b7d6a72766eee5359fe4f36e61e2470x00000000000000000000000000000000000000000000000000000000000007b964be751ab4188e1d47417afe3196e9574e866330c87d9c5997ff26e1285211a7617557809265686375592378586713002175217439918216749674877108000000000000113890841875000000000000000xe9e284277648fcdb09b8efc1832c73c09b5ecf5912020-12-04T23:26:15.000Z191199915785096459231747088868219752436876322163504611517155600075899902348150x00f624e06d7b1e6f2cc867e12d32f871de9de5284c6eed18a24f75eb0177a03a
Query with partition filter
SELECT *
FROM `tt-contracts.livepeer_v1_ethereum.TicketBroker_WinningTicketRedeemed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100