toucan_v1_celo

Tables

BCT_Deposited_event

BCT (Base Carbon Tonne) token deposit events from Toucan Protocol on Celo, recording carbon credit token deposits into the pool with deposit amounts and underlying ERC20 token addresses. Used for tracking carbon credit tokenization 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
0x02de4766c272abc10bc88c220d214a26960a7e92	false	900000000000000000	1	18782810	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	2023-04-15T18:10:30.000Z	0x197e0aefaf1c4214beabba1ff1663541d3304e375e126cbb87d7ed7d1f04cf14
0x02de4766c272abc10bc88c220d214a26960a7e92	false	1000000000000000000	1	18782742	0x96e58418524c01edc7c72dadde5fd5c1c82ea89f	2023-04-15T18:04:50.000Z	0x61e556cea663cc907216cda84c018c1f628f867a20503c4593779e51e60e7ce0
0x02de4766c272abc10bc88c220d214a26960a7e92	false	20000000000000000	1	18815091	0x96e58418524c01edc7c72dadde5fd5c1c82ea89f	2023-04-17T15:00:35.000Z	0x7ee84c24818e2144ee63360fb209ac4058a17c7830a12747f3d43cf002c77661

Example Query

Query with partition filter

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

BCT_Redeemed_event

Redemption events from Toucan Protocol’s Base Carbon Tonne (BCT) pool on Celo, recording when users burn BCT tokens to receive underlying carbon credit ERC20 tokens. Captures account addresses, redeemed token contracts, and amounts for tracking carbon credit 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_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
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	19573084516520464	28	0x7ebae2e3be88b4bb76e7952149a3b37121bc2473	31283917	2025-03-28T17:57:55.000Z	0xd49044872a4d314ecd70445868fd82d889e5505e4418169a8ccf464e552423f7
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	900000000000000	4	0xdb45168bcc54a46960df8fbdad6d44433b13a6a5	31283158	2025-03-28T17:45:16.000Z	0x5430c49883437fa42b39a9a8a2bd97395b27e7c252c05d6afc576f0098940329
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xd131ed94b36877c66016e3bcd374c306dbfdb3b9	118290683902978964940	21	0xce10d577295d34782815919843a3a4ef70dc33ce	21167180	2023-08-31T17:53:04.000Z	0x091e316e4ca66314c0c1aff6cc3f30da01556d3ea6a2aac4b17f97c38af364d5

Example Query

Query with partition filter

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

NCT_Deposited_event

Nature Carbon Tonne (NCT) token deposit events on Toucan Protocol’s Celo deployment, recording when carbon credit ERC20 tokens are deposited into the NCT pool with deposit amounts and token addresses. Useful for tracking carbon credit tokenization activity and pool composition analysis.

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
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	1170877538545432058	256	28208809	0x96e58418524c01edc7c72dadde5fd5c1c82ea89f	2024-10-12T06:58:46.000Z	0x9ade942e203e0c6f2aab034ea9d0617c7a227782853410d351a51016c8084f80
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	20000000000000000	10	19987505	0x96e58418524c01edc7c72dadde5fd5c1c82ea89f	2023-06-24T11:23:16.000Z	0x2234be6392234761d347db536e93bdff762ffc776860efe3c108386ee8e62a54
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	9117992484165893	36	28185242	0x96e58418524c01edc7c72dadde5fd5c1c82ea89f	2024-10-10T22:14:48.000Z	0x2ec3dea195231719d4e09afb992008f9217e836a6ffbf34a595f2f35fb7eba74

Example Query

Query with partition filter

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

NCT_Redeemed_event

Redemption events for NCT (Nature Carbon Tonne) pool tokens on Toucan Protocol’s Celo deployment, recording when users burn pool tokens to withdraw specific underlying carbon credit tokens. Used for tracking carbon credit withdrawals and analyzing which vintage tokens are redeemed from the NCT basket.

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
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	0x3e7a610b66b621d48404e4408e16c80962a6c30b	540857123005431893	4	0xdfc180272fc8e0b4fd6e5e1179808ad1049c4dc1	19604386	2023-06-02T07:16:15.000Z	0xe44122f31d825d04b38aa6cbd1a6c206467660f3498b7685e57fe1ab788bb590
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	0xf92cb18c27506b8b020560b4231358e9aaa77660	657790631415463019	7	0xdfc180272fc8e0b4fd6e5e1179808ad1049c4dc1	19604386	2023-06-02T07:16:15.000Z	0xe44122f31d825d04b38aa6cbd1a6c206467660f3498b7685e57fe1ab788bb590
0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe	false	0xd337d13cea5691777bcee01b2f75be93d59c4459	1000000000000000000	26	0xeb947e9b0aeced803f7e4e83da8b096e14df2153	21526647	2023-09-21T13:09:52.000Z	0xbcfca8648289d2f6f2dab933079f3e63ea2f0b432b166523aaf7ae0817e8173e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BCT_Deposited_event

BCT_Redeemed_event

NCT_Deposited_event

NCT_Redeemed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BCT_Deposited_event

​BCT_Redeemed_event

​NCT_Deposited_event

​NCT_Redeemed_event

Tables

BCT_Deposited_event

BCT_Redeemed_event

NCT_Deposited_event

NCT_Redeemed_event