Skip to main content

​
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.
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__disputeIDSTRINGIdentifier 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__tokenAmountSTRINGAmount 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__ETHAmountSTRINGETH 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.
addressremovedlog_indexin__addressblock_numberin__ETHAmountin__disputeIDblock_timestampin__tokenAmounttransaction_hash
0x988b3a538b618c7a603e1c11ab82cd16dbe28069false2970x55122fdca4ba43294677d96c12ce76dabc459a2b167260821100000000000000015282023-02-28T10:31:47.000Z00x55dddd19aae0f6d8f18ff666a2b6bcd7b5ee37784094dc6e4ff2e2b5630f50cb
0x988b3a538b618c7a603e1c11ab82cd16dbe28069false6210x379e9883833baf8402414bef58858cc8c84624d9163512132500000000000000014402023-01-07T00:05:59.000Z00xcf7493ea32bc31f862bda13a993e4fd4d20fdd769fa6624090a7e3b0c6ca7d1d
0x988b3a538b618c7a603e1c11ab82cd16dbe28069false2060x1fcb32c860b9f4c0df99d1fd54e7ce958e9e93cc163543502500000000000000014422023-01-07T10:36:59.000Z00xd156ac20dfe4b774d227a694b987c398a733e345549a24bde6a2dc0f89290736
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.
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__claimantSTRINGAddress of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string.
in__balanceSTRINGToken amount represented in smallest denomination. String-encoded integer value without decimal places.
addressremovedlog_indexin__balanceblock_numberin__claimantblock_timestamptransaction_hash
0xdbc3088dfebc3cc6a84b0271dade2696db00af38false207113518420431173529432158896070xae30f8bcdfa81f37b38d6e221a2775c7d03aa7792022-11-03T12:50:47.000Z0x464b835b4169853c108805034b413f7dece6aa96f6560eeb46c99b169e92433b
0xdbc3088dfebc3cc6a84b0271dade2696db00af38false11619658841716079000149636140423240x6f5f5d2a7d9b6ea028b8efceab2ff221a27ab6e32022-01-20T12:08:08.000Z0x9bf0f961305e3b4bd416ca4af7b3950ff103f2ff57585de64131e179102c1969
0xdbc3088dfebc3cc6a84b0271dade2696db00af38false1217121814179694304134144153096640xfd4ba0a1c08e0af938a2b1ac06e8937c8535ec932022-08-09T18:55:27.000Z0xbdc88e7cb69e76a2a1e4a43f6c4193a7cda7e44b54bcfc5ff7ce3fef2928eb11
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