Skip to main content

Tables

KlerosLiquid_TokenAndETHShift_event

Token and ETH balance shifts for participants in Kleros dispute resolution cases on Gnosis Chain. Tracks stake redistributions with positive and negative amounts showing reward allocations and penalties tied to specific dispute IDs.
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__addressSTRINGAddress of the account or contract involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in__disputeIDSTRINGUnique identifier for the Kleros dispute associated with this token and ETH balance shift event. Numeric string value that groups related shifts within the same arbitration case.
in__tokenAmountSTRINGChange in token balance for a participant in a Kleros dispute, denominated in wei (smallest token unit). Can be positive (token credit) or negative (token debit), with zero indicating no token transfer occurred.
in__ETHAmountSTRINGETH amount transferred or shifted for a participant in a Kleros dispute, denominated in wei (smallest ETH unit). Can be positive (received), negative (deducted), or zero depending on dispute outcomes and stake redistribution.
addressremovedlog_indexin__addressblock_numberin__ETHAmountin__disputeIDblock_timestampin__tokenAmounttransaction_hash
0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002false60x001fe2cdbeeb0743679e958c0861dd8788b28b192352902245000000000000000000442022-08-04T21:48:00.000Z5200000000000000000000x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b
0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002false40x46fc87fc5a722f91651aeca1dfbb8be46aceb101235290220442022-08-04T21:48:00.000Z-2600000000000000000000x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b
0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002false10x2a47fb90bd1ac3c6056d2c05c5c59a5f042310aa235290220442022-08-04T21:48:00.000Z-2600000000000000000000x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b
Query with partition filter
SELECT *
FROM `tt-contracts.kleros_v1_gnosis.KlerosLiquid_TokenAndETHShift_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100