wmatic_v1_polygon

Tables

WMATIC_Approval_event

ERC-20 token approval events for Wrapped MATIC (WMATIC) on Polygon, recording owner addresses granting spending permissions to spender contracts with approved amounts. Used for tracking DEX integrations and allowance changes, with most approvals granting maximum uint256 values to QuickSwap router.

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_guy`	`STRING`	Address of the spender or recipient approved to transfer tokens. 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_guy	in_src	in_wad	address	removed	block_number	block_timestamp	transaction_hash
0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	0xfce88e5cd21ef7026ae0ae05150b4062bceb2b01	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	11536890	2021-03-03T02:46:11.000Z	0x2fdf7de5a9d0b45ef1e3d0a40976e984a1d9487aa4edb7dfe7ab2ba637279aa0
0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	0x2b62cb060e78500b482a02acc7a111b62d46e5a9	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	11552738	2021-03-03T12:27:47.000Z	0x43d49fc1cbae9face5ee86963c530497344fe03601f4c45df9cd3a52cc204621
0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	0xcf8bdae13a3f62cc3680521a560c13c7f51b2d5c	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	11534442	2021-03-03T01:19:53.000Z	0xa5a8e8ab9f0b9e50cff8074e0e233e4e292df9783aa60da1bd1ed9efc10f789e

Example Query

Query with partition filter

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

WMATIC_Deposit_event

Wrapped MATIC (WMATIC) deposit events on Polygon, recording when native MATIC is converted to the ERC-20 wrapped token. Tracks destination addresses and deposit amounts in wei for analyzing wrapping activity and token flow 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_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
0x07964f135f276412b3182a3b2407b8dd45000000	1994000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	134	69703358	2025-03-31T00:00:04.000Z	0xe0ce84c0f438480fa2c8ccfbc0d3a37f0be9d0accb9f11ce3326a888be6a5db0
0x75771cd79006e6fba3627d16086dc2d2ec37489e	4131962371995575120	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	1040	69703359	2025-03-31T00:00:06.000Z	0xa94a6ccd49488c30db12b188462c16ee5e5df543cb27de32f456ec121e524eb1
0x643770e279d5d0733f21d6dc03a8efbabf3255b4	56472152793280577536	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	704	69703360	2025-03-31T00:00:10.000Z	0x9ef88939656019a81f1dec0eb49b0dfa4f8df96bd4c4f53b509e589c00e19f6f

Example Query

Query with partition filter

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

WMATIC_Transfer_event

WMATIC token Transfer event logs on Polygon, recording movements of wrapped MATIC (ERC-20) between addresses with transfer amounts in wei. Used for tracking WMATIC flows, holder analytics, and liquidity movement across DeFi protocols on Polygon.

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_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_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x019ba0325f1988213d448b3472fa1cf8d07618d7	0x6e7a5fafcec6bb1e78bae2a1f0b612012bf14827	42986203720379056709	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	2	8969561	2020-12-30T22:06:36.000Z	0x5197cd5c468ae54f590fe0806e20b01294b0c110f5f499bc8af790669f99dcf0
0x019ba0325f1988213d448b3472fa1cf8d07618d7	0x6e7a5fafcec6bb1e78bae2a1f0b612012bf14827	41350372755061884391	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	2	8960484	2020-12-30T16:52:46.000Z	0x3233b8db8fc8b0f6888767d3a1f986e50b8b15834d74b401482e32bedf70b5c9
0x019ba0325f1988213d448b3472fa1cf8d07618d7	0x6e7a5fafcec6bb1e78bae2a1f0b612012bf14827	114564895133584999363	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	2	8965534	2020-12-30T19:47:52.000Z	0x90fb0b6a868ae0e437fbef7f224c03e1c17bd44442a2dfe31d389dd0b95ae4cd

Example Query

Query with partition filter

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

WMATIC_Withdrawal_event

Withdrawal events from the Wrapped MATIC (WMATIC) token contract on Polygon, recording when users unwrap WMATIC back to native MATIC. Contains withdrawal amounts in wei and source addresses for tracking token unwrapping 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_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
0x85059b2d4533646259a6d6266686bedb759985e9	1182331490605625460895	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	1	10833256	2021-02-14T03:58:26.000Z	0xdb395689c4fa0e44ec792980bf0bcb4c8d66b7d234d8343d92a1b1388589a1d9
0x85059b2d4533646259a6d6266686bedb759985e9	8866297094826576737949	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	6	10829788	2021-02-14T01:58:49.000Z	0xa5f3ad78cfa7391de030595d247d5b37f4e8e2ece29d2e74c6686fbd97cb9b6c
0x85059b2d4533646259a6d6266686bedb759985e9	3930495298034330397873	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	false	137	10839872	2021-02-14T07:46:54.000Z	0x08f48aa35c0915b826b27cf84bccc47c39e62430c4d6a697d6928a66f80a7bd7

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

WMATIC_Approval_event

WMATIC_Deposit_event

WMATIC_Transfer_event

WMATIC_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WMATIC_Approval_event

​WMATIC_Deposit_event

​WMATIC_Transfer_event

​WMATIC_Withdrawal_event

Tables

WMATIC_Approval_event

WMATIC_Deposit_event

WMATIC_Transfer_event

WMATIC_Withdrawal_event