Skip to main content

​
Tables

​
WETH9_Deposit_event

WETH9 (Wrapped Ether version 9) deposit events emitted when native ETH is converted to ERC-20 wrapped tokens. Contains recipient address and deposit amount in WAD units (18 decimal precision) for tracking ETH wrapping activity.
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_dstSTRINGAddress of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_wadSTRINGToken amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.
in_dstin_wadaddressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x0b929b809c5485baa13aebb491e31af1f0aa42281000000000000000x4200000000000000000000000000000000000006false36044982024-11-11T19:20:57.000Z0x93be97cda3f9a97bdbe098129c2b920e42ff8d9a86d0bf37e7b6a4c56ecd299e
0x0b929b809c5485baa13aebb491e31af1f0aa42288347821470530x4200000000000000000000000000000000000006false06047792024-11-11T19:25:38.000Z0xfb3d8b599defe5797c4243e66f82dc346536b9b5278432a2d59607e7de0cdab7
0x807180bebc4cc1e5fdea8f15e60e62bf68265e9d9978060x4200000000000000000000000000000000000006false25587962024-11-11T06:39:15.000Z0xc14257c22ef3894a3ccdbe7429f59f3cab963a3943cbd88dbd925d122e255262
Query with partition filter
SELECT *
FROM `tt-contracts.weth_v1_unichain.WETH9_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
WETH9_Withdrawal_event

WETH9 withdrawal events emitted when unwrapping wrapped Ether (WETH) back to native ETH. Contains withdrawing address and amount in WAD units (18 decimal precision).
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_srcSTRINGAddress of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
in_wadSTRINGToken amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.
in_srcin_wadaddressremovedlog_indexblock_numberblock_timestamptransaction_hash
0xdbd1d937b40c0f47bebbe9c7e14517614320a1f0983303399217190730x4200000000000000000000000000000000000006false378095242025-02-03T04:44:43.000Z0x01553b0a6f41b20f6216172532a670f433ee937c32497cfabe1fc2add7c7f7a4
0xdbd1d937b40c0f47bebbe9c7e14517614320a1f01024783747231650270x4200000000000000000000000000000000000006false377969652025-02-03T01:15:24.000Z0xaf112ca67136a5a0a85171653b27419d672aefcf9cd40052bd508f5e48fc972d
0xdbd1d937b40c0f47bebbe9c7e14517614320a1f012561860754421700x4200000000000000000000000000000000000006false378101292025-02-03T04:54:48.000Z0xe16872d2bf4ec1d4c2577ab4fc6128ec290493ef14132f47696279c57f17f216
Query with partition filter
SELECT *
FROM `tt-contracts.weth_v1_unichain.WETH9_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100