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.Columns
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__address | STRING | Address of the account or contract involved in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__disputeID | STRING | Unique 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__tokenAmount | STRING | Change 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__ETHAmount | STRING | ETH 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. |
Sample Data
Sample Data
| address | removed | log_index | in__address | block_number | in__ETHAmount | in__disputeID | block_timestamp | in__tokenAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002 | false | 6 | 0x001fe2cdbeeb0743679e958c0861dd8788b28b19 | 23529022 | 45000000000000000000 | 44 | 2022-08-04T21:48:00.000Z | 520000000000000000000 | 0x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b |
| 0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002 | false | 4 | 0x46fc87fc5a722f91651aeca1dfbb8be46aceb101 | 23529022 | 0 | 44 | 2022-08-04T21:48:00.000Z | -260000000000000000000 | 0x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b |
| 0x9c1da9a04925bdfdedf0f6421bc7eea8305f9002 | false | 1 | 0x2a47fb90bd1ac3c6056d2c05c5c59a5f042310aa | 23529022 | 0 | 44 | 2022-08-04T21:48:00.000Z | -260000000000000000000 | 0x3d065741a91802767d3abf65e9c450931bb7fc4975e300d84abf576989590a0b |
Example Query
Example Query
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