Tables
KlerosLiquid_TokenAndETHShift_event
Token and ETH transfer events from Kleros Liquid decentralized arbitration court on Ethereum, tracking dispute-related payments and redistributions to juror addresses. Contains native ETH amounts in wei and token amounts (likely PNK governance token) with positive values for receipts and negative for withdrawals.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 | Identifier of the Kleros dispute for which ETH and token amounts are being shifted. Numeric string representing the unique dispute case within the arbitration system. |
in__tokenAmount | STRING | Amount of tokens being shifted in the Kleros dispute resolution process, denominated in the smallest unit of the token (wei-equivalent). Can be positive (incoming), negative (outgoing), or zero, representing token balance adjustments for jurors or parties involved in the dispute. |
in__ETHAmount | STRING | ETH transfer amount associated with this dispute resolution event, denominated in wei (1 ETH = 10^18 wei). Values can be negative to indicate outflows or positive for inflows, with most transfers ranging from 0.011 to 0.0975 ETH. |
Sample Data
Sample Data
| address | removed | log_index | in__address | block_number | in__ETHAmount | in__disputeID | block_timestamp | in__tokenAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false | 297 | 0x55122fdca4ba43294677d96c12ce76dabc459a2b | 16726082 | 11000000000000000 | 1528 | 2023-02-28T10:31:47.000Z | 0 | 0x55dddd19aae0f6d8f18ff666a2b6bcd7b5ee37784094dc6e4ff2e2b5630f50cb |
| 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false | 621 | 0x379e9883833baf8402414bef58858cc8c84624d9 | 16351213 | 25000000000000000 | 1440 | 2023-01-07T00:05:59.000Z | 0 | 0xcf7493ea32bc31f862bda13a993e4fd4d20fdd769fa6624090a7e3b0c6ca7d1d |
| 0x988b3a538b618c7a603e1c11ab82cd16dbe28069 | false | 206 | 0x1fcb32c860b9f4c0df99d1fd54e7ce958e9e93cc | 16354350 | 25000000000000000 | 1442 | 2023-01-07T10:36:59.000Z | 0 | 0xd156ac20dfe4b774d227a694b987c398a733e345549a24bde6a2dc0f89290736 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.kleros_v1_ethereum.KlerosLiquid_TokenAndETHShift_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
MerkleRedeem_Claimed_event
Token claim events from Merkle tree-based distribution contracts recording successful redemptions. Contains claimant address and claimed token balance for tracking airdrop and reward distribution execution.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__claimant | STRING | Address of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string. |
in__balance | STRING | Token amount represented in smallest denomination. String-encoded integer value without decimal places. |
Sample Data
Sample Data
| address | removed | log_index | in__balance | block_number | in__claimant | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false | 207 | 113518420431173529432 | 15889607 | 0xae30f8bcdfa81f37b38d6e221a2775c7d03aa779 | 2022-11-03T12:50:47.000Z | 0x464b835b4169853c108805034b413f7dece6aa96f6560eeb46c99b169e92433b |
| 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false | 116 | 19658841716079000149636 | 14042324 | 0x6f5f5d2a7d9b6ea028b8efceab2ff221a27ab6e3 | 2022-01-20T12:08:08.000Z | 0x9bf0f961305e3b4bd416ca4af7b3950ff103f2ff57585de64131e179102c1969 |
| 0xdbc3088dfebc3cc6a84b0271dade2696db00af38 | false | 121 | 7121814179694304134144 | 15309664 | 0xfd4ba0a1c08e0af938a2b1ac06e8937c8535ec93 | 2022-08-09T18:55:27.000Z | 0xbdc88e7cb69e76a2a1e4a43f6c4193a7cda7e44b54bcfc5ff7ce3fef2928eb11 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.kleros_v1_ethereum.MerkleRedeem_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100