wiotx_v1_iotex

Tables

WIOTX_Deposit_event

Wrapped IOTX (WIOTX) deposit events on IoTeX blockchain recording native IOTX token wrapping into ERC-20 format. Tracks depositor addresses and wrapped amounts in wei for analyzing token wrapping activity and liquidity flows.

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_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_dst	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x0f814827f651bcbf4971975f6eb55b2b6c5bcb4f	701351000000000000000	0xa00744882684c3e4747faefd68d283ea44099d03	false	10	35355953	2025-03-21T18:59:55.000Z	0x62ce621e09225fa6abb12991c21ca14cff16e6e8ce3e2b97e8cddf538d862f27
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	117453307832204866	0xa00744882684c3e4747faefd68d283ea44099d03	false	20	35342279	2025-03-21T00:00:00.000Z	0x51dcca436cecd88854029361f608b252503e3cec4e9124cde1adc39dac28931f
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	109658064599377676	0xa00744882684c3e4747faefd68d283ea44099d03	false	25	35342279	2025-03-21T00:00:00.000Z	0x476d0a789bd9ae2f9b7cef8e885f388e25317f6dbca08be74bf55a356fb0054d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wiotx_v1_iotex.WIOTX_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WIOTX_Withdrawal_event

Withdrawal events from the wrapped IOTX (WIOTX) token contract on IoTeX blockchain, recording when users unwrap WIOTX back to native IOTX. Contains withdrawal amounts in wei (in_wad), source addresses, and transaction metadata for tracking token redemptions.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_src	in_wad	address	removed	block_number	block_timestamp	transaction_hash
0x03030ca5d84772535640772c79059b0c196e496f	330051726433876340900	0xa00744882684c3e4747faefd68d283ea44099d03	false	15331384	2022-01-15T15:30:45.000Z	0x9d49bae70c637ae0b07932e24f519977d9b1e0feb62126497e5f4db898dc4df0
0x092ad7131626f4b7c2b14cd2d21651127a548063	11289275336430651453	0xa00744882684c3e4747faefd68d283ea44099d03	false	15320241	2022-01-15T00:01:30.000Z	0xc71870110cbb0e43e75f48a994f303283c42c72f0afa6e6c9c0b2808dd3287a0
0x0a0f5cbf76e098b9b37742c2d47dac6d3074516e	12307430947787640031	0xa00744882684c3e4747faefd68d283ea44099d03	false	15335237	2022-01-15T20:52:05.000Z	0x29530d66cd446cac6a7c2a0b9ead18664e03bb221e49f7613838f1ae01f4528c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wiotx_v1_iotex.WIOTX_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WIOTX9_Deposit_event

Deposit events from the Wrapped IOTX (WIOTX) token contract on IoTeX blockchain, recording conversions of native IOTX to WIOTX tokens. Captures recipient addresses and deposit amounts in wei denomination for tracking token wrapping activity.

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_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_dst	in_wad	address	removed	block_number	block_timestamp	transaction_hash
0x4cabcdfffe5af697289b714c475f969a1981f886	10000000000000000	0xa00744882684c3e4747faefd68d283ea44099d03	false	23273907	2023-04-21T09:20:00.000Z	0x7049b8c3bdef4e19a0dc96626d23f19bdf87bc748b8173dac710473404a14da8
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	1000000000000000000	0xa00744882684c3e4747faefd68d283ea44099d03	false	23270118	2023-04-21T04:04:15.000Z	0x62deafcd36c3df432d2a50ad17a134155029df92d383b74878b8cb5787e6975d
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	1000000000000000000	0xa00744882684c3e4747faefd68d283ea44099d03	false	23267443	2023-04-21T00:21:20.000Z	0x02fcc518d216220d82a75009fdf88335f184ca76ede44e721ebe3b5427eb60bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wiotx_v1_iotex.WIOTX9_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WIOTX9_Withdrawal_event

Withdrawal events from the WIOTX (Wrapped IOTX) token contract on IoTeX, recording unwrapping transactions where users convert WIOTX back to native IOTX. Includes withdrawal amounts in wei units and source addresses for tracking liquidity flows and wrapped token usage patterns.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x0f814827f651bcbf4971975f6eb55b2b6c5bcb4f	57933202143030062084	0xa00744882684c3e4747faefd68d283ea44099d03	false	5	26390480	2023-10-18T19:27:40.000Z	0x1a8a7a3d4c7a420e115f3018ffbb4d73a205a8a652f939241fbc67871d538ac5
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	5154159121279873310	0xa00744882684c3e4747faefd68d283ea44099d03	false	4	26387633	2023-10-18T15:30:15.000Z	0x6a44356d8b43a3ce9b3a9fdda1aadbea380cc9b779a462c81670887ad6460ef8
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	1957795709891348023	0xa00744882684c3e4747faefd68d283ea44099d03	false	4	26390132	2023-10-18T18:58:40.000Z	0x848ca0d817427ab0a9b243872480773d736100c5c2adbd1fe14de15fc22a4e2c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wiotx_v1_iotex.WIOTX9_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

WIOTX_Deposit_event

WIOTX_Withdrawal_event

WIOTX9_Deposit_event

WIOTX9_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WIOTX_Deposit_event

​WIOTX_Withdrawal_event

​WIOTX9_Deposit_event

​WIOTX9_Withdrawal_event

Tables

WIOTX_Deposit_event

WIOTX_Withdrawal_event

WIOTX9_Deposit_event

WIOTX9_Withdrawal_event