toucan_v1_polygon

Tables

BCT_bridgeBurn_function

Base Carbon Tonne (BCT) token burn events from Toucan Protocol’s bridge on Polygon, recording when carbon credits are retired by burning tokens from user accounts. Useful for tracking carbon offset activity and retirement volumes in the on-chain carbon market.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
21799	true	16914	0x74f4f547	1313532598522770200	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0x40cb1444968244d11c6a67bdb90cd62656f27ce0	35058688	0x2f800db0fdb5223b3c3f354886d907a671414a7f	0,2,0	2022-11-01T07:33:16.000Z	0xb59da783fed82c9ddc4479e81e2060e5d90934d4400afcd4c41910b699ddb4c8
21799	true	16914	0x74f4f547	73638262627980372	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0x53691b0c4f7eb64010a1dda6dbe50bf71cc96a20	37060856	0x2f800db0fdb5223b3c3f354886d907a671414a7f	0,2,0	2022-12-20T14:31:31.000Z	0x51dfe015959efd2fe14d5b3163bc6f6103ec0fa5cf24e4e7d24a9e945439ef91
22096	true	16914	0x74f4f547	1000000000000000000	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0xbdc85027bcdbe20b3430523a773bf3008888fa9d	38595838	0x2f800db0fdb5223b3c3f354886d907a671414a7f	0,2,0	2023-01-27T17:57:11.000Z	0x1e40f61b594fb906af126b4328bc6cbdcd6b5d7aa3c63faf59f47c23f083b651

Example Query

Query with partition filter

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

BCT_bridgeMint_function

Base Carbon Tonne (BCT) token mint events from Toucan Protocol’s bridge contract on Polygon. Tracks carbon credit tokenization where off-chain credits are bridged and minted as BCT tokens with amount and recipient account data.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
110768	true	16947	0x8c2a993e	1000000000000000000	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0x00a92ff167860e93914dd9f23d806ac51be1492f	31743046	0x2f800db0fdb5223b3c3f354886d907a671414a7f	2,1,0,0,1,0	2022-08-10T20:38:52.000Z	0x61d75eb1f5d2fcdef6dd16d6bf02f319f6051def39667aef0e06cdb8e51db6de
111029	true	16947	0x8c2a993e	50000000000000000	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0x00a92ff167860e93914dd9f23d806ac51be1492f	39260542	0x2f800db0fdb5223b3c3f354886d907a671414a7f	4,1,0,0,1,0	2023-02-13T22:29:44.000Z	0xf10ba9eae91a42c64117b0afe968cb7c3480198b5e079c580659564819d03173
111029	true	16947	0x8c2a993e	50000000000000000	0xe24d5aea221cb6fad017ae4aaea4d7686bf02a55	0x00a92ff167860e93914dd9f23d806ac51be1492f	39260235	0x2f800db0fdb5223b3c3f354886d907a671414a7f	4,1,0,0,1,0	2023-02-13T22:16:12.000Z	0xc5f3f834b7e4195b4103d89983f843ca12cd8b3c6ffccaf588902fd29791a7e7

Example Query

Query with partition filter

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

BCT_Deposited_event

Carbon offset token deposits into Toucan Protocol’s Base Carbon Tonne (BCT) pool on Polygon. Records individual Toucan Carbon Tonne (TCO2) deposits with token addresses and amounts for tracking carbon credit tokenization 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_erc20Addr`	`STRING`	Contract address of the ERC20 token being deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_erc20Addr	block_timestamp	transaction_hash
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	7579000000000000000000	29	27996581	0xb0d34b2ec3b47ba1f27c9d4e8520f8fa38ef538d	2022-05-06T15:39:37.000Z	0xde305aec8d6360c01f4f6cf800a7bb5016040039d735b44fba854fa07a15fbb1
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	8542000000000000000000	19	28002255	0xb0d34b2ec3b47ba1f27c9d4e8520f8fa38ef538d	2022-05-06T19:05:42.000Z	0x3445bf9cec77037d72a9c1aab62a585b90ca330ea3685fef9c501e591c131c7d
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	850000000000000000	277	37540276	0xb139c4cc9d20a3618e9a2268d73eff18c496b991	2023-01-01T11:45:13.000Z	0xa6f5675a88293fb8a54383f5cd9d94e5433649502946566834bb1d92b29ca107

Example Query

Query with partition filter

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

BCT_Redeemed_event

Base Carbon Tonne (BCT) redemption events from Toucan Protocol on Polygon, recording when users burn BCT pool tokens to receive underlying tokenized carbon credits (TCO2s). Useful for analyzing carbon credit retirement flows and tracking which specific carbon projects are being selected from the BCT pool.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc20`	`STRING`	Contract address of the ERC20 token being redeemed or registered. Hex-encoded, 0x-prefixed, 42-character string or zero address for native tokens.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_erc20	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	0x225b28c1a77fd4493196db19c538a44801243537	8999999999999999	143	0x8ce54d9625371fb2a068986d32c85de8e6e995f8	49317772	2023-10-30T02:57:39.000Z	0x0266263cad2caab263679345ba71f55bb01579e9df6ee46c3fd4af941c0feecd
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	0xb139c4cc9d20a3618e9a2268d73eff18c496b991	8000000000000000000	47	0x8ce54d9625371fb2a068986d32c85de8e6e995f8	49341450	2023-10-30T17:10:51.000Z	0xa548e3bf21a31685d3938e9ab5578c9a9ef4ee79bf2a9a34de16807bd13cb971
0x2f800db0fdb5223b3c3f354886d907a671414a7f	false	0xb139c4cc9d20a3618e9a2268d73eff18c496b991	271616293618839540	204	0xb4eb24af4e059ac0f1b1c924bf29930aa9cd79ca	49330493	2023-10-30T10:34:04.000Z	0xa8dfc776184d392f7e330d5817757112a6c58acef9e201088162b4b963c86123

Example Query

Query with partition filter

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

CrossChainMessenger_BridgeRequestReceived_event

Cross-chain bridge request events received on Polygon from the Toucan protocol’s CrossChainMessenger contract, capturing token transfers from Celo (domain 42220) to Polygon (domain 137). Used for tracking bridge activity, transfer volumes, and cross-chain token movement 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_originDomain`	`STRING`	Domain identifier for the originating blockchain in a cross-chain transfer. Numeric string representation of the source chain identifier.
`in_toDomain`	`STRING`	Destination blockchain domain identifier for the cross-chain bridge request. Uses chain ID format (e.g., 137 for Polygon).
`in_bridger`	`STRING`	Address of the account initiating the cross-chain bridge request on the origin chain. Typically matches the recipient address for self-bridging transactions.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_requesthash`	`STRING`	Unique identifier hash for the cross-chain bridge request transaction. Hex-encoded, 0x-prefixed 64-character string used to track bridge operations across chains.

Sample Data

address	removed	in_token	in_amount	log_index	in_bridger	in_toDomain	block_number	in_recipient	in_requesthash	block_timestamp	in_originDomain	transaction_hash
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	0xd838290e877e0188a4a44700463419ed96c16107	450000000000000000000	5	0x6998fe700015f04fb192f46ec1dcb59320334f4b	137	69057842	0x6998fe700015f04fb192f46ec1dcb59320334f4b	0xc164d27d793119a198f8e92d79bec1bcdf5208b20567aacb8b52995b9f1e02ca	2025-03-14T23:54:32.000Z	42220	0x473e9a28f1229238a183d9f238382e0fb75c85bb4d87a20710c6730870b2671e
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	0xd838290e877e0188a4a44700463419ed96c16107	6002519392702246512	122	0x5815db4518902973aac8b91d64b60eb2190fdcef	137	62981611	0x5815db4518902973aac8b91d64b60eb2190fdcef	0x3e26845c9dec267ebf850de4d2d9526778c029b4d8629769bf38c57b88d1eb1f	2024-10-13T09:18:39.000Z	42220	0x6352938bdcd294dc207fd8db4799913ca2224b4bc4bb8451efd8e07c7e0b3b17
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	0xd838290e877e0188a4a44700463419ed96c16107	1250000000000000000000	239	0x6998fe700015f04fb192f46ec1dcb59320334f4b	137	76178699	0x6998fe700015f04fb192f46ec1dcb59320334f4b	0xb90667fe800377091e8d45cc06f6222d7aa3ec392fe391276a7b8de151de9dea	2025-09-07T20:41:34.000Z	42220	0xe26684fa852ad456d6a4fc96a27bf496023152da2bafd4b00779b7face5209b2

Example Query

Query with partition filter

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

CrossChainMessenger_BridgeRequestSent_event

Cross-chain bridge transfer requests from Toucan Protocol on Polygon, capturing token transfers to destination domains (primarily Celo chain ID 42220) with bridger addresses, token amounts, and unique request hashes. Used for tracking carbon credit token movements across chains and analyzing cross-chain bridge 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_originDomain`	`STRING`	Domain identifier for the originating blockchain in a cross-chain transfer. Numeric string representation of the source chain identifier.
`in_toDomain`	`STRING`	Destination chain identifier where the bridged tokens will be received. Sample values indicate Celo (42220) as the target domain from Polygon (137).
`in_bridger`	`STRING`	Address of the user or contract that initiated the cross-chain bridge request on Polygon (domain 137). This is typically the same as the recipient address, as users bridge tokens to their own address on the destination chain.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_requesthash`	`STRING`	Unique identifier hash for this specific cross-chain bridge request transaction. Hex-encoded, 0x-prefixed 64-character string generated when the bridge request is initiated.

Sample Data

address	removed	in_nonce	in_token	in_amount	log_index	in_bridger	in_toDomain	block_number	in_recipient	in_requesthash	block_timestamp	in_originDomain	transaction_hash
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	741	0xd838290e877e0188a4a44700463419ed96c16107	665000000000000000000	235	0x6998fe700015f04fb192f46ec1dcb59320334f4b	42220	69214196	0x6998fe700015f04fb192f46ec1dcb59320334f4b	0xfda3035001d73b1f43c1c07b8ab43eb6b6a17b4355ef85d1605cfc75fed367b5	2025-03-18T21:18:26.000Z	137	0x631dfda713bed65dee03db91d24502fbd23553913318e7ed6d1826080d7d6c1b
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	387	0x2f800db0fdb5223b3c3f354886d907a671414a7f	2215410247706305031	394	0x4f889fca97a1e887ff0471850a04cb57d118a828	42220	58093681	0x4f889fca97a1e887ff0471850a04cb57d118a828	0x7a4b915f72e60340b8126251013f715cff9e5c404701316c1543589593759bd3	2024-06-13T02:28:39.000Z	137	0xafe1e3340818d9fe2c5f51fd43e5a5de6e038547757776878ef734e03b13d9a0
0x050d7ce9d1ab66f510a906e1c824f9ed9ee11ce5	false	385	0x2f800db0fdb5223b3c3f354886d907a671414a7f	1379418800000000000000	77	0xca2da59ee10e34b4d5b12140e2bf38fce1fd9ee6	42220	58093354	0xca2da59ee10e34b4d5b12140e2bf38fce1fd9ee6	0x53f595c443a6216b9169e2e5dd4812cd6809a9f8c1ae64bc7de3fc439e47eb8a	2024-06-13T02:17:03.000Z	137	0xd7df8eb5e66dcc3066ff9dd3fb2b3aa38fd3c8786777196b08f9b2419ae58c12

Example Query

Query with partition filter

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

NCT_bridgeBurn_function

NCT (Nature Carbon Tonne) token bridge burn transactions on Toucan Protocol’s Polygon deployment, recording carbon credit retirements from the bridged token supply. Tracks account-specific burn amounts and execution details for analyzing carbon offset activity and token supply changes.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
21821	true	16936	0x74f4f547	150035807415472712361	0x9587660c323977cefc7072ba4e15c662338980f6	0x7dc7b25043983bbf7c30d45ffaf132c0c5f100a8	32760536	0xd838290e877e0188a4a44700463419ed96c16107	0,2,0	2022-09-06T10:59:26.000Z	0xa6383711ce95fc742a7fa0557d30b2ca2edb1e6913741ec4230a214ed88d9d0d
21821	true	16936	0x74f4f547	10000000000000000000	0x9587660c323977cefc7072ba4e15c662338980f6	0x80b815c829150d5535e8dd97339a98e650030ebe	32116016	0xd838290e877e0188a4a44700463419ed96c16107	0,2,0	2022-08-20T15:20:45.000Z	0x2e4637cf4d5a1d8c46244746fa222b0e24b83905b54950b737239f28a9d020fc
21821	true	16936	0x74f4f547	1080458181949086998878	0x9587660c323977cefc7072ba4e15c662338980f6	0x0ffad609d35c4bef104ee245a9c4c891d463aa2a	34840118	0xd838290e877e0188a4a44700463419ed96c16107	0,2,0	2022-10-26T23:17:20.000Z	0x07bfa0f08c5ee66f13f5c99054422a7dfb0922183a538e3bb1fb7ef84abcfdb5

Example Query

Query with partition filter

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

NCT_bridgeMint_function

NCT (Nature Carbon Tonne) token bridging mint events on Toucan Protocol’s Polygon deployment, recording cross-chain token issuance with recipient accounts and minted amounts. Tracks carbon credit tokenization from other chains into Polygon’s regenerative finance ecosystem.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
126844	true	34069	0x8c2a993e	500000000000000000000	0x9587660c323977cefc7072ba4e15c662338980f6	0xca9c8d118c0b3b8b2a0470e8476a661d59b1dd19	32950030	0xd838290e877e0188a4a44700463419ed96c16107	2,1,0,0,1,0	2022-09-11T00:46:51.000Z	0x37ec2336e832591ab47945f50f1c5e768c76ecc58e562e6950048f961d4ddb83
110789	true	16969	0x8c2a993e	445137659850292480008	0x9587660c323977cefc7072ba4e15c662338980f6	0xdde3e2024e270d6022d1bb4e8745e9dc6d82e0bc	32959292	0xd838290e877e0188a4a44700463419ed96c16107	2,1,0,0,1,0	2022-09-11T06:13:44.000Z	0xbe0c1f84a185a4d7ae24a4639533cbf94f6c7cd1b3b356cddf58715f9195b107
110788	true	16969	0x8c2a993e	600000000000000000000	0x9587660c323977cefc7072ba4e15c662338980f6	0xca9c8d118c0b3b8b2a0470e8476a661d59b1dd19	36138703	0xd838290e877e0188a4a44700463419ed96c16107	3,1,0,0,1,0	2022-11-27T16:46:56.000Z	0x832d7c64950906068a91141e8d210c7fb6921bba01ab8da128605c4df107d758

Example Query

Query with partition filter

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

NCT_Deposited_event

NCT (Nature Carbon Tonne) token deposit events on Toucan Protocol’s Polygon carbon bridge, recording when users deposit tokenized carbon credits into the NCT pool. Tracks deposited amounts and source ERC20 carbon credit tokens for analyzing carbon credit bridging activity and pool 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_erc20Addr`	`STRING`	Contract address of the ERC20 token being deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_erc20Addr	block_timestamp	transaction_hash
0xd838290e877e0188a4a44700463419ed96c16107	false	5000000000000000000000	134	26805632	0x68e65cc375f10baf74ac41773658dd00b5de1eaa	2022-04-06T07:56:43.000Z	0x4a953ba31093db517b33db767dcbd227256dbcc3ed2be7e5c5c08c3b7b0219da
0xd838290e877e0188a4a44700463419ed96c16107	false	1000000000000000000	233	38395655	0x62896f42cf1371b268db56e50d67c34f3eb1ad7a	2023-01-22T16:34:41.000Z	0xda5dfba302f7c2abf22ac56a1e53f124e9da9217d840a3c6eeb339126020343b
0xd838290e877e0188a4a44700463419ed96c16107	false	129200000000000000	233	38395546	0x62896f42cf1371b268db56e50d67c34f3eb1ad7a	2023-01-22T16:30:49.000Z	0x5318a8790643e34d386ecd5ee8dcbc4d74a9543ac60924eaacd35e7ded08f013

Example Query

Query with partition filter

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

NCT_Redeemed_event

NCT (Nature Carbon Tonne) token redemption events from Toucan Protocol on Polygon, tracking when users redeem pooled carbon credits for specific underlying TCO2 tokens. Used to analyze carbon credit withdrawals, redemption patterns, and liquidity flows in the Toucan carbon market infrastructure.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc20`	`STRING`	Contract address of the ERC20 token being redeemed or registered. Hex-encoded, 0x-prefixed, 42-character string or zero address for native tokens.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_erc20	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xd838290e877e0188a4a44700463419ed96c16107	false	0x04943c19896c776c78770429ec02c5384ee78292	2060025899270109	295	0xc4714e9af6dbe1b040ef94f7d3ca0d807ad9c15a	32192561	2022-08-22T13:16:58.000Z	0x5a45388f3a5afcf90166dd4d87e70ada81208c48342f43d5970573b36aa55662
0xd838290e877e0188a4a44700463419ed96c16107	false	0x04943c19896c776c78770429ec02c5384ee78292	206159065201708	276	0xc4714e9af6dbe1b040ef94f7d3ca0d807ad9c15a	32192771	2022-08-22T13:24:14.000Z	0x52ac657cf21287a70708059aa3675c04d9eb141cf0677c89f11057b067f81514
0xd838290e877e0188a4a44700463419ed96c16107	false	0x3b28baae3987502b436f6f37d1bcd7b87b517b27	102883937903803	297	0xc4714e9af6dbe1b040ef94f7d3ca0d807ad9c15a	32188303	2022-08-22T10:41:27.000Z	0x3a3846a3d4e4cd5a451787ae13221f1361cc7e0e9ed767adbbd7c03e6c830965

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BCT_bridgeBurn_function

BCT_bridgeMint_function

BCT_Deposited_event

BCT_Redeemed_event

CrossChainMessenger_BridgeRequestReceived_event

CrossChainMessenger_BridgeRequestSent_event

NCT_bridgeBurn_function

NCT_bridgeMint_function

NCT_Deposited_event

NCT_Redeemed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BCT_bridgeBurn_function

​BCT_bridgeMint_function

​BCT_Deposited_event

​BCT_Redeemed_event

​CrossChainMessenger_BridgeRequestReceived_event

​CrossChainMessenger_BridgeRequestSent_event

​NCT_bridgeBurn_function

​NCT_bridgeMint_function

​NCT_Deposited_event

​NCT_Redeemed_event

Tables

BCT_bridgeBurn_function

BCT_bridgeMint_function

BCT_Deposited_event

BCT_Redeemed_event

CrossChainMessenger_BridgeRequestReceived_event

CrossChainMessenger_BridgeRequestSent_event

NCT_bridgeBurn_function

NCT_bridgeMint_function

NCT_Deposited_event

NCT_Redeemed_event