impossible_v1_bsc

Tables

IFAllocationMaster1_Stake_event

Stake deposit events from Impossible Finance (IF) allocation master contract on BNB Smart Chain, capturing user staking amounts with trackId identifiers. Used for tracking staking participation and allocation pool positions across different reward tracks.

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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0x7b842bb21aae05262f0d8d3de30fc7e1f3a57bd3	false	2400000000000000000000	440	18484799	2022-06-07T15:42:29.000Z	0x99ab779f3f8fb85be3af9376c693e0a086c834d968391f2b1d84d1cbefe27b41
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0xc322ef51a8b00b210055f95c20d1776b725821f4	false	99144634908589985155	80	18478118	2022-06-07T10:07:43.000Z	0xc62e9d358b8d2eec1d0f0ae15d2e25861f669df3ef9840f11559fc2ed140d3e0
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0x5ee03ca52a5c97ef7071b65b277cc969af0490f8	false	100000000000000000000	807	18482424	2022-06-07T13:43:38.000Z	0x0afc30a352c8920f765c7d1d29328f63068a92b9048c5d2556ed6963741ede86

Example Query

Query with partition filter

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

IFAllocationMaster1_Unstake_event

Unstake event logs from Impossible Finance’s IFAllocationMaster1 contract on BNB Smart Chain (BSC), recording token withdrawal amounts and user addresses. Used for tracking staking exits and liquidity removal from allocation pools.

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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0x0c7fde641b99453e0a578d09862dae6c2f925cfa	false	365632296071408366479	714	18937089	2022-06-23T10:33:00.000Z	0x675d29db2a1c633e3b0e7d0e608875b903ec06df63aadadff0fee8a7f189f873
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0x76bd3d007fdd664b2273a5b097ba60cfa3e29229	false	304397169398208625818	254	18947914	2022-06-23T19:35:06.000Z	0xe629dafb138fabe4ea1baa45ca99ea86a7ad1caf96d487abfebc9a8438c179f4
0xfc652ea2e8a373c16f3d8c5bd25e9898b9699ecb	0xfbf2e062628c0669ca2b439cf2758d1e04c47587	false	10000000000000000000000	165	18944021	2022-06-23T16:20:26.000Z	0x21b93bea59f402c442366cd9803770dc20e1cb3d8a3e0886c769d1f596fe3380

Example Query

Query with partition filter

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

IFAllocationMaster2_Stake_event

User staking events from Impossible Finance on BSC, tracking deposits into allocation pools with amounts, user addresses, and track identifiers. Used for analyzing staking participation and capital allocation across IF protocol pools.

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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	in_trackId	block_number	block_timestamp	transaction_hash
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0xed2906014ddb64f000f649ff08be6caf4a079df5	false	196944450000000000000	561	12	15623076	2022-02-27T13:28:20.000Z	0xadcc568b746986285fd6b6315c195f6fd019be24f6083a18e7b16b03695c13e4
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0xa0a132189c885a56280f3137a1f9947d785d1d9b	false	3000000000000000000	112	12	15618479	2022-02-27T09:38:20.000Z	0x8733f824881f638b9ce443370120e22211bf52dd3c9f12e5914c47ab034c0cc2
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0x3fd60411ac601f770ec110c3161e7f8bbe71a9f8	false	101111050000000000000	420	12	15610106	2022-02-27T02:38:46.000Z	0x3306386caec0c9d863496c85e951d69c045aadc23d41642329ac38f023e966bc

Example Query

Query with partition filter

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

IFAllocationMaster2_Unstake_event

Unstake event logs from Impossible Finance allocation master contract on BNB Smart Chain, recording user withdrawals with amounts and allocation track identifiers. Used for tracking staking pool exit activity and analyzing locked token release 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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	in_trackId	block_number	block_timestamp	transaction_hash
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0x375eeabbe80297f9f8fe8654e03bf4476ad82db0	false	888580000000000000	179	12	22988299	2022-11-12T09:42:20.000Z	0x3605eb6e8a00cfbaccbc957e5231d6ca3efe5cb9e8afe6679b4f99436b5b8b7c
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0x41b201ed95d67a219f6813f1a2aa2c98b47d0bb2	false	13393000000000000000000	3	7	22981065	2022-11-12T03:33:42.000Z	0x41d290f287584562d0e8a8a6af00186499f67b5512fec4d774d6bc4302b89ef5
0x1d37f1e6f0cce814f367d2765ebad5448e59b91b	0x41b201ed95d67a219f6813f1a2aa2c98b47d0bb2	false	5000000000000000000000	3	6	22981062	2022-11-12T03:33:33.000Z	0xa15cec558b8b1c041fe4d299cfea321dfe1e2b1753c94a6c2c7a224fde9ac522

Example Query

Query with partition filter

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

IFAllocationMaster3_Stake_event

Staking event logs from Impossible Finance (IF) allocation pools on Binance Smart Chain, recording user deposits with track identifiers and token amounts (in wei). Used for analyzing staking behavior, tracking pool participation, and monitoring user allocations across different IF campaigns.

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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	in_trackId	block_number	block_timestamp	transaction_hash
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0x6b8b2d2d04bc6dc09fc33f97f8cd6cf1605063bd	false	32473200000000000000	757	12	12657023	2021-11-15T01:41:49.000Z	0x28c32608eaa06319b45d1f0ed01741f5631246522618c3c3f0af0074087f89de
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0x3ced2c4a49c7a8120795009ea03f077617ba071e	false	1299162400000000000000	906	12	12681888	2021-11-15T23:38:26.000Z	0x388184b9e83d6d882712780a7620fbe0119528b66b72774b7df71ecb1d22ed1f
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0x1c1a668f666e4b5df9cac504cc1b2438f077c749	false	78092710000000000000	637	12	12660193	2021-11-15T04:28:10.000Z	0x505f166a4558618274df810ea7a1b0a4e77e4052801f757bd2fd02f5407268bd

Example Query

Query with partition filter

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

IFAllocationMaster3_Unstake_event

Unstake events from Impossible Finance v1 allocation master contract on BNB Smart Chain, recording user withdrawals with token amounts (in wei) and track identifiers. Used for analyzing staking pool withdrawal patterns and tracking individual unstaking positions across different allocation tracks.

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_trackId`	`STRING`	Identifier for the staking track or tier. Numeric string representation of the track category.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.

Sample Data

address	in_user	removed	in_amount	log_index	in_trackId	block_number	block_timestamp	transaction_hash
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0xd0d4574abc24b5699919b0739e6724bc5800c269	false	294881820000000000000	707	12	17764983	2022-05-13T10:57:32.000Z	0x3e26aedc7b0fde7f1c03142a6f2cf1ebc63f5c2822fd1e8af224f1cb742cbf62
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0x06f1621185f2b98f4f1a2e04cc9f5ffe41ff742a	false	13220860000000000000	287	0	11032615	2021-09-18T21:34:13.000Z	0xa8df7d519f60fb5ab9ad179576a13e5bb9f67e97ed7260f12bd2878cb406722f
0x1abd0067f60513f152ff14e9cd26a62c820d022c	0x06f1621185f2b98f4f1a2e04cc9f5ffe41ff742a	false	76303860000000000000	344	1	11032606	2021-09-18T21:33:46.000Z	0x89d2d5b62f194007aa823a11679936026c176509e71d17c90208ab60cbbe72a7

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

IFAllocationMaster1_Stake_event

IFAllocationMaster1_Unstake_event

IFAllocationMaster2_Stake_event

IFAllocationMaster2_Unstake_event

IFAllocationMaster3_Stake_event

IFAllocationMaster3_Unstake_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​IFAllocationMaster1_Stake_event

​IFAllocationMaster1_Unstake_event

​IFAllocationMaster2_Stake_event

​IFAllocationMaster2_Unstake_event

​IFAllocationMaster3_Stake_event

​IFAllocationMaster3_Unstake_event

Tables

IFAllocationMaster1_Stake_event

IFAllocationMaster1_Unstake_event

IFAllocationMaster2_Stake_event

IFAllocationMaster2_Unstake_event

IFAllocationMaster3_Stake_event

IFAllocationMaster3_Unstake_event