cryptex_v2_arbitrum

Tables

AccessControlledOffchainAggregator_NewTransmission_event

Chainlink oracle price feed transmission events from Cryptex V2 on Arbitrum, recording aggregated price data with individual observer submissions and median answers per round. Used for analyzing oracle update frequency, price deviation patterns, and data provider reliability.

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_aggregatorRoundId`	`STRING`	Sequential round identifier for this price aggregator update. Increments with each new transmission to track oracle data freshness.
`in_answer`	`STRING`	Consensus answer value submitted by the oracle aggregator for this round. This median value is derived from the array of observations submitted by multiple oracle nodes.
`in_transmitter`	`STRING`	Ethereum address of the oracle node that submitted this price report to the aggregator contract. Hex-encoded, 0x-prefixed 40-character string identifying the specific transmitter in the oracle network.
`in_observations`	`ARRAY<STRING>`	Array of individual price observations from multiple oracle nodes before aggregation. Typically contains 10 values representing raw data submissions from each oracle in the decentralized network.
`in_observers`	`STRING`	Compact byte string identifying which oracle nodes submitted observations for this price transmission round. Each byte encodes an observer index, enabling efficient on-chain verification of oracle participation.
`in_rawReportContext`	`STRING`	Raw metadata bytes from the oracle reporting context, containing the epoch and round information for this price transmission. Hex-encoded value used internally by the Chainlink oracle contract to track report provenance.

Sample Data

address	removed	in_answer	block_number	in_observers	in_transmitter	block_timestamp	in_observations	transaction_hash	in_rawReportContext	in_aggregatorRoundId
0x7b9845a634822c543f5ce544dd7d7797b79a06b8	false	112003483021568580000	56456281	0x03040701020800050609	0x3cae103213db7673072e138a622bd17b20bc7ad4	2023-01-29T20:52:28.000Z	[“111398891103100000000”,“111398891103100000000”,“111398891103100000000”,“112003483021568580000”,“112003483021568580000”,“112003483021568580000”,“113397830549400000000”,“113397830549400000000”,“113397830549400000000”,“113397830549400000000”]	0xdc5cc44b821c94f95d2619c3793f50ba2f0c2f1b7c93d217f49a2a9f05da9b80	0x0000000000000000000000b73308060eb1a83d92ecc837e0e3183e000207bb03	8127
0x7b9845a634822c543f5ce544dd7d7797b79a06b8	false	110268933742321950000	56326517	0x03040701020800050609	0x3cae103213db7673072e138a622bd17b20bc7ad4	2023-01-29T09:48:32.000Z	[“109237025473600000000”,“109237025473600000000”,“109385458436800000000”,“109810232933248060000”,“109810232933248060000”,“110268933742321950000”,“111366798681000000000”,“111366798681000000000”,“111366798681000000000”,“111366798681000000000”]	0x964a328db96f02172654b06408fce1b2226566d218318c8432560c89b76e177a	0x0000000000000000000000b73308060eb1a83d92ecc837e0e3183e000206de02	8121
0x7b9845a634822c543f5ce544dd7d7797b79a06b8	false	109146819231024120000	56242694	0x03040701080200050609	0x5616caaba92cdf656e7d1ba36fe1bd878e51c174	2023-01-29T00:46:40.000Z	[“108050280664300000000”,“108050280664300000000”,“108050280664300000000”,“108708515671922180000”,“108708515671922180000”,“109146819231024120000”,“110272710427600000000”,“110272710427600000000”,“110272710427600000000”,“110272710427600000000”]	0x115524a72493dc18355a9c5d135c998d2e95c7a5cee05e78ba7cf8efb7a746d2	0x0000000000000000000000b73308060eb1a83d92ecc837e0e3183e0002062905	8116

Example Query

Query with partition filter

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

AccessControlledOffchainAggregator2_NewTransmission_event

Chainlink oracle price feed transmission events for Cryptex protocol on Arbitrum, capturing aggregated price observations from multiple oracle nodes. Records contain the consensus answer, individual observer submissions, round identifiers, and transmitter addresses for analyzing oracle network behavior and data quality.

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_aggregatorRoundId`	`STRING`	Incremental round identifier for this oracle aggregator’s price update cycle. Monotonically increasing integer that tracks the sequence number of transmission events for this specific price feed.
`in_answer`	`STRING`	Consensus value reported by the oracle aggregator in this transmission round. Integer value typically representing a price or metric scaled by decimal precision.
`in_transmitter`	`STRING`	Ethereum address of the oracle node that submitted this price feed update to the aggregator contract. Hex-encoded, 0x-prefixed 40-character identifier of the transmitting node in the Chainlink OCR (Off-Chain Reporting) network.
`in_observations`	`ARRAY<STRING>`	Array of raw price observations submitted by individual oracle nodes before aggregation. Contains unfiltered values from multiple data sources that are combined to produce the final consensus answer.
`in_observers`	`STRING`	Hex-encoded array of oracle node identifiers that submitted price observations for this aggregator round. Each byte represents a specific oracle in the decentralized network providing off-chain data.
`in_rawReportContext`	`STRING`	Raw report context data from the Chainlink oracle transmission, encoded as a hex string. Contains metadata about the oracle round and aggregation process.

Sample Data

address	removed	in_answer	log_index	block_number	in_observers	in_transmitter	block_timestamp	in_observations	transaction_hash	in_rawReportContext	in_aggregatorRoundId
0x67db13c76ce77e8feef9b500616162ec142597ac	false	11890920294772	27	236694483	0x04060002070801030509	0x01f4e56d5ee46e84edf8595ca7a7b62a3306de76	2024-07-27T19:47:24.000Z	[“11888739567022”,“11889411000000”,“11889900572166”,“11890815576571”,“11890815576571”,“11890920294772”,“11894637099999”,“11894637099999”,“11894637099999”,“11894637099999”]	0x5b51d1c97a52610904bfad14f808eade2fe5212ed64ddb4e60bef1d67fcc747b	0x0000000000000000000000f4354a423657d02ac71b8ca1ab0fe84a0002ba0b06	40136
0x67db13c76ce77e8feef9b500616162ec142597ac	false	12061303090832	2	236733699	0x02070308090605010400	0x01f4e56d5ee46e84edf8595ca7a7b62a3306de76	2024-07-27T22:31:58.000Z	[“12052391722440”,“12052391722440”,“12054301266015”,“12054301266015”,“12054301266015”,“12061303090832”,“12063247762748”,“12072194259481”,“12072194259481”,“12075680684454”]	0x669104080e993fbc72649765f03447ac232c45a6260f889031119bac72bae506	0x0000000000000000000000f4354a423657d02ac71b8ca1ab0fe84a0002ba4205	40155
0x67db13c76ce77e8feef9b500616162ec142597ac	false	11929880700000	0	236713342	0x05010406000308090207	0x01f4e56d5ee46e84edf8595ca7a7b62a3306de76	2024-07-27T21:06:26.000Z	[“11909285400000”,“11910304893083”,“11910304893083”,“11925095907368”,“11928455538314”,“11929880700000”,“11929880700000”,“11929880700000”,“11932842000000”,“11932842000000”]	0x42ae96b2a9e2ba83f40c7a0e22edd8b1879b333abb8f11eaf952d95f11f8a2be	0x0000000000000000000000f4354a423657d02ac71b8ca1ab0fe84a0002ba2602	40151

Example Query

Query with partition filter

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

BalancedVault_PositionUpdated_event

Position rebalancing events from Cryptex Finance BalancedVault contracts on Arbitrum, tracking target position sizes across underlying product addresses. Used to analyze vault strategy adjustments and portfolio allocation changes over time.

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_product`	`STRING`	Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_targetPosition`	`STRING`	Target position size for the product in the vault’s rebalancing strategy, denominated in the product’s base units. Values represent 18-decimal fixed-point integers indicating the desired exposure level.

Sample Data

address	removed	log_index	in_product	block_number	block_timestamp	transaction_hash	in_targetPosition
0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	false	12	0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	121088679	2023-08-13T20:04:55.000Z	0x0e39ebe908dea79ef1b64e3d8321a97e7fdef3d904e2f2ceee7250eaf8741fc3	751980093073226448308
0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	false	15	0x4243b34374cfb0a12f184b92f52035d03d4f7056	121088679	2023-08-13T20:04:55.000Z	0x0e39ebe908dea79ef1b64e3d8321a97e7fdef3d904e2f2ceee7250eaf8741fc3	751980093073226448308
0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	false	31	0x4243b34374cfb0a12f184b92f52035d03d4f7056	121087689	2023-08-13T20:00:21.000Z	0x06bbf48fd056d9395eb7a044f1cd5022e319a681c0a30dce83144b5491847cbd	751984756234651777606

Example Query

Query with partition filter

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

Product_MakeClosed_event

Maker position closure events from Cryptex v2 protocol on Arbitrum, capturing account address, position version identifier, and closure amount in wei. Useful for tracking liquidity provider exits and position lifecycle 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1378367742278080656	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3646	139100412	2023-10-09T17:53:51.000Z	0xa373d31f72e394fc516ecafb149443b01df3aacd3e395c00af943d543e374f72
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	101131715270208559119	9	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3640	138962126	2023-10-09T07:51:59.000Z	0xfdfeaba9dadcdc0c7b9cd1457bbdd992f5f3a4f5417a0e2c488585d55993f535
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	31574927309708655840	6	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3640	138989660	2023-10-09T09:51:23.000Z	0xf19b5757f9e60e6488d0ed0f25875a37da358169728be76d5251253eea1fbffd

Example Query

Query with partition filter

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

Product_MakeOpened_event

Event logs capturing maker order openings on Cryptex v2 protocol on Arbitrum, recording the account address, position amount in wei, and version identifier. Used for tracking liquidity provision and maker position lifecycle 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1014586785859486193	22	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	17284	267048390	2024-10-24T04:34:57.000Z	0x14066c1634493964a9d5b1f8a197aaee1d4b5669263557323aa97ec72fbd4e76
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	5900454265905691951	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3432	127986983	2023-09-04T15:15:33.000Z	0xe5f25934adc0d4e37bfd51c0b694897998d72027e42b12764b3de716eb34e01d
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	4737051437713110645	19	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3434	128069464	2023-09-04T22:03:10.000Z	0x9e71740af2a77db9da3a1f656cffb9addb306abcfb85c211dd9fd576b96718dc

Example Query

Query with partition filter

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

Product_TakeClosed_event

Position closure events from Cryptex v2 protocol on Arbitrum capturing account addresses, closed position amounts, and version identifiers for tracking user exits from derivative products.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	41207158363320166217	11	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	1423	100773277	2023-06-13T14:53:58.000Z	0xaf9ef08aca12490b4b920fd3a963794af9f4e372a84bee74cc189946276a0da8
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	523077457061848533648	3	0xb564c78dca958ac4089339ce8ecd8617ba72f389	1423	100769632	2023-06-13T14:38:47.000Z	0xb86f652f1a27cf320ce4274afeaf44216ec86e242d2ef4bd3fa2991491ef619e
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	451739959105334438	2	0x7456dc5db0e9fc2a0f77189571b7e1832eff7166	3736	141342963	2023-10-17T08:37:10.000Z	0x17e23491e33bc0658e20565661331722f5268c4b39565d0181217d0d8df52940

Example Query

Query with partition filter

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

Product_TakeOpened_event

Position opening events from Cryptex V2 protocol on Arbitrum capturing when traders take (open) new positions with account addresses, position sizes, and version identifiers for tracking trading activity and position lifecycle.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	72840422961580614	12	0x121e1573b7c6c15aa4c036d54bfd2974cf38a163	4196	148197710	2023-11-08T01:23:09.000Z	0x1f632ea4b132cbf86ca2f356d6fcfad265d26746454a71fc455b35b2bd15e19b
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	72840422961580614	12	0x138217746bd24765ada859ed9cf23182e456ca3d	4196	148250519	2023-11-08T05:10:02.000Z	0x1b10f4517d9c5378d840196abd28de2362cec4d3874cf87fc57f19c4cb252fd5
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	364202114807903074	12	0x1df2535cf0956abec21c4738534885d3849d6578	4196	148259894	2023-11-08T05:49:33.000Z	0x426644ca70c728e89105260593fe23a9f26314a93e66749aaa6dfe0e65cf7702

Example Query

Query with partition filter

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

Product2_MakeClosed_event

Position closure events from Cryptex v2 protocol on Arbitrum, tracking maker position exits with closed amounts, account addresses, and version identifiers. Used for analyzing position lifecycle, liquidity provision patterns, and account-level trading behavior.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	31574927309708655840	9	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3640	138989660	2023-10-09T09:51:23.000Z	0xf19b5757f9e60e6488d0ed0f25875a37da358169728be76d5251253eea1fbffd
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	101131715270208559119	12	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3640	138962126	2023-10-09T07:51:59.000Z	0xfdfeaba9dadcdc0c7b9cd1457bbdd992f5f3a4f5417a0e2c488585d55993f535
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	5348564197429893	13	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	3641	138990296	2023-10-09T09:54:04.000Z	0x2c0be503e00012d0edf7dd406a5aaead8f5e30b70e3c309ad975ca57a7b7f4a9

Example Query

Query with partition filter

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

Product2_MakeOpened_event

Maker position opening events from Cryptex V2 protocol on Arbitrum, capturing account addresses, collateral amounts, and version states when liquidity providers establish new positions. Used for tracking market maker activity and liquidity provision 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	944572522170389417	18	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2793	117050290	2023-08-01T10:00:49.000Z	0xd1de6534bc46654ebfa92d795f2d04491d4e8331a4b1a4504132dc94b5e9fc12
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	251002240476435698	18	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2804	117202937	2023-08-01T21:00:37.000Z	0xb2acb6ad346eb4b0de0771f19a07ae3c07c6612df4bceb16a328d8d205767f34
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	221219514395355689	18	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2802	117175485	2023-08-01T19:00:26.000Z	0xd3714133673b692045447a0a74a5ee2948a30570f52e044fc12412d03c99bb71

Example Query

Query with partition filter

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

Product2_TakeClosed_event

Position closure events from Cryptex Finance v2 protocol on Arbitrum, capturing account addresses, closure amounts, and version identifiers. Used for tracking perpetual product liquidations and voluntary position exits across protocol versions.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	30555534645130202181	3	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	1326	99605300	2023-06-10T04:32:13.000Z	0x8bd2e4ad57a270413b96bc55fd6b4201eca01649d5e2cf198cb5091db883492a
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	390068280658740361	1	0xada8c9f47d2eb77bd5c8c18ee61ab7d9588c0890	4084	145952024	2023-11-01T05:34:19.000Z	0x6610617c256809dca355a8f94a30dbe951426c7097ee3053eb9a6bbaf218645a
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	390068209010080043	1	0x847064070a42b08b34e0f32433378a6198e83fd7	4086	145976127	2023-11-01T07:16:16.000Z	0x9a969f6978d009fc3550ab223de9b6822f07ea52c4458af89cdee97cdd25ba74

Example Query

Query with partition filter

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

Product2_TakeOpened_event

Position opening events from Cryptex V2 perpetual futures protocol on Arbitrum. Tracks account addresses, position sizes (in_amount), and protocol state versions for analyzing trader behavior and position flow.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	3957233651348546772	35	0x830bc5551e429ddbc4e9ac78436f8bf13eca8434	10396	200539070	2024-04-13T08:54:55.000Z	0x80a6c9367d0a6dd518710c8377677b12f4f64c3e46282c5c5ad90b93d3cafee4
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	30620633699689250269	12	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	1638	103272042	2023-06-21T01:38:37.000Z	0xac5569118b9098a0cc56ecf8db520a90178777d8c5aeb7c72d33fa44e2f746fe
0x4243b34374cfb0a12f184b92f52035d03d4f7056	false	9791747640246429059	12	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	1661	103487572	2023-06-21T16:43:23.000Z	0xf65a7c212311201dc911d8600947d49ef9e6f70eba1d3c6893bdd13f52905bb3

Example Query

Query with partition filter

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

Product3_MakeClosed_event

Maker position closure events from Cryptex v2 protocol on Arbitrum, tracking liquidity provider exits with account addresses, version identifiers, and withdrawn amounts. Used to analyze market maker behavior and liquidity dynamics across protocol versions.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	135562177753020792803687444	10	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	2867	134530385	2023-09-25T17:42:35.000Z	0x4d457325d67606dfa9804e681c2a381f489ea0aa5212e94ba84b4fd0061f8b30
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	63425613352321127631252228	10	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	2839	134403298	2023-09-25T08:27:14.000Z	0xf070c5559e24f3cd5287de35e66f62d4bf086a75123c74a56b348eb571c6db37
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	67964504915754391434118469	10	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	2832	134377135	2023-09-25T06:34:45.000Z	0xab98d71397282fa1cab8e91c4fbee1e00beba5cad41110218c806bebef02b3cf

Example Query

Query with partition filter

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

Product3_MakeOpened_event

MakeOpened events from Cryptex V2 Product3 contract on Arbitrum, capturing maker position openings with account addresses, position amounts, and version identifiers. Used to track liquidity provision activity and maker order book depth changes in the Cryptex protocol.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	6532496338419724249146879	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1994	130128922	2023-09-11T14:08:07.000Z	0x2ee3372328a6c6f96df746f1b822f180e54b3359130794c8534183f2660140e1
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	3697112783644576422813651	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1966	129963292	2023-09-11T01:46:00.000Z	0x32b253561f8482997943260f6a8f4c68272bc71a1829ba23c1c89a2d6c094c8b
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	1438909381081185743297697	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1973	130008373	2023-09-11T05:21:01.000Z	0x99ab9c7db46128ae13d000420621b7c485298011f63bc30ede38e60f1edfa3da

Example Query

Query with partition filter

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

Product3_TakeClosed_event

Position closure events from Cryptex v2 protocol on Arbitrum, tracking take-profit or take-loss orders executed with account addresses, closure amounts, and versioned state. Used for analyzing trading strategy outcomes and position management behavior.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	45101080632158133584990001	3	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	903	124361961	2023-08-24T02:19:20.000Z	0x44bd8e66fd97df058996114a125225cc9ed58447801b493d66c2876032087a82
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	12593767505054753383027991522	33	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	1504	127042730	2023-09-01T13:53:20.000Z	0x1b07f5b6b45e5a45b0ccc9817af31aa81ceb6ad2b2649052adc316619083dc4a
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	17768212973073870169885253	3	0x6b1ef382f3639b3a7e1a21786702c48406bd8e75	1490	126922832	2023-09-01T05:20:22.000Z	0x79cb2d976d81148b39abebaec4b6e1d278f41e415ea444addeda6dfa802f7d70

Example Query

Query with partition filter

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

Product3_TakeOpened_event

Position open events from Cryptex V2 protocol on Arbitrum, tracking account addresses, position amounts, and version identifiers. Used for analyzing trading activity and position lifecycle within the protocol’s Product3 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.
`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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	97763531566744274407984024	12	0x6b1ef382f3639b3a7e1a21786702c48406bd8e75	422	121675914	2023-08-15T15:38:54.000Z	0x4abea55de5ce6dd0d3bfb054a16e3d3bee207650c5ca50987aa6c6ec092d3f62
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	344670926132693500638837069	12	0xd4fa23307a181b9ca567886eb5bcd5c8f8f8bb3e	2390	132362628	2023-09-19T00:12:25.000Z	0xe48405dec709a138c7d311eaeda34cd5d333ed63626b0c128083a5155b6c130f
0xc555e66b017ffce7b17f64b2dda186210364fd0d	false	28942436364723703519123935	14	0xf6a16a48099497c59e8abeaa37bb37b2f9b793d4	125	119750963	2023-08-09T15:56:24.000Z	0x411fec6f1f0f78bccb7da6aa16eb7ff5bcbe431a77f39d97937c83e862142827

Example Query

Query with partition filter

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

Product4_MakeClosed_event

Market maker position closure events from Cryptex v2 protocol on Arbitrum. Tracks when liquidity provider positions are closed with account addresses, position amounts, and version identifiers for analyzing maker activity and position lifecycle.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x741bfef86f612b43016430312e0f33efce9af8c5	false	1573198838769564829749542	16	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1653	127822048	2023-09-04T03:01:49.000Z	0x8ee1688aa182955a17ff9d17cf1c3e5db2b58c33a66deba6940fe828448664a0
0x741bfef86f612b43016430312e0f33efce9af8c5	false	1565291625051574081194830	16	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1700	128082970	2023-09-04T23:27:13.000Z	0x84cffdc1c8b4dfdfa3dfba3a1732b91b598732f7c5526454ad61a884c2aa58a4
0x741bfef86f612b43016430312e0f33efce9af8c5	false	1398566224723287544455978	16	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	1648	127795262	2023-09-04T00:45:08.000Z	0xa78d3f5fea9ab84ab1cc57b4e44955cb05cf9f64b45b165e9fcb0657b0a03561

Example Query

Query with partition filter

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

Product4_MakeOpened_event

MakeOpened event logs from Cryptex V2’s Product4 contract on Arbitrum, capturing maker position openings with position size, account address, and version identifier. Used for tracking liquidity provision activity and maker position lifecycle 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x741bfef86f612b43016430312e0f33efce9af8c5	false	1520235773974818111482056	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	3634	139931476	2023-10-12T09:42:52.000Z	0xaaeb7905b73a8a3440729762ffb780063322c2f5f4c2df08424659f368a198b1
0x741bfef86f612b43016430312e0f33efce9af8c5	false	490694219438732539114876	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	3622	139836236	2023-10-12T02:17:30.000Z	0xba31772a0fb76f034d4ac038346667afea502db9ba669a0e8caaccb40567dad4
0x741bfef86f612b43016430312e0f33efce9af8c5	false	304715152085028280802551	14	0xb84b9d427fb30ed3641afac2e07b8c471bb0c6ee	3627	139870757	2023-10-12T05:09:04.000Z	0xe31d2243f0ebedf801e5e12e64b94ef222fc220a1d0cd623408efc308ba28da8

Example Query

Query with partition filter

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

Product4_TakeClosed_event

Position closure events from Cryptex V2 protocol on Arbitrum, tracking when traders close their derivative positions with account addresses, closure amounts, and version identifiers for reconciling position lifecycle and trading volume.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x741bfef86f612b43016430312e0f33efce9af8c5	false	12827982325060161083905445141	6	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	2357	132200509	2023-09-18T11:20:31.000Z	0x6af84541b7ba50f1e55b2bb1c0f3677948710aafbe102f85bf344f86434c67f8
0x741bfef86f612b43016430312e0f33efce9af8c5	false	5787878163855418075295062706	27	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	1339	126103510	2023-08-29T14:30:22.000Z	0x2308d09525690e3e4dbc2b17835e27b111b259103b07cfac3183f8707521cb89
0x741bfef86f612b43016430312e0f33efce9af8c5	false	95458910039850985016414794	3	0xd4fa23307a181b9ca567886eb5bcd5c8f8f8bb3e	219	120477147	2023-08-11T21:38:31.000Z	0x8306c8a6deda9379cf14b91c5360707f7b5f16856e8251c58331b74bdeb1b38c

Example Query

Query with partition filter

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

Product4_TakeOpened_event

Position opening events from Cryptex v2 protocol on Arbitrum. Records when traders open maker positions (takes) with account addresses, position amounts, and version identifiers for tracking protocol state 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.
`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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`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	in_account	in_version	block_number	block_timestamp	transaction_hash
0x741bfef86f612b43016430312e0f33efce9af8c5	false	12827982325060161083905445141	18	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	1516	127069789	2023-09-01T15:50:37.000Z	0x32273e55fe1c4d93b8f0b38d6f03e6e0bd03727c391c7b08bfbde89b34f57346
0x741bfef86f612b43016430312e0f33efce9af8c5	false	1505064118554259177525258706	3	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	1329	126076889	2023-08-29T12:36:23.000Z	0xeaa21b825ef3239ff403cdd57a5db037262866f5542ef523b5142ae3cc686994
0x741bfef86f612b43016430312e0f33efce9af8c5	false	4282814045301158897769804000	34	0x8540f80fab2afcae8d8fd6b1557b1cf943a0999b	1080	124864425	2023-08-25T15:20:48.000Z	0x8ff3f54c010a20f7e0faf0006de5aa3ed0ac09ef96b7e2045fc99e2fcb29f704

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AccessControlledOffchainAggregator_NewTransmission_event

AccessControlledOffchainAggregator2_NewTransmission_event

BalancedVault_PositionUpdated_event

Product_MakeClosed_event

Product_MakeOpened_event

Product_TakeClosed_event

Product_TakeOpened_event

Product2_MakeClosed_event

Product2_MakeOpened_event

Product2_TakeClosed_event

Product2_TakeOpened_event

Product3_MakeClosed_event

Product3_MakeOpened_event

Product3_TakeClosed_event

Product3_TakeOpened_event

Product4_MakeClosed_event

Product4_MakeOpened_event

Product4_TakeClosed_event

Product4_TakeOpened_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AccessControlledOffchainAggregator_NewTransmission_event

​AccessControlledOffchainAggregator2_NewTransmission_event

​BalancedVault_PositionUpdated_event

​Product_MakeClosed_event

​Product_MakeOpened_event

​Product_TakeClosed_event

​Product_TakeOpened_event

​Product2_MakeClosed_event

​Product2_MakeOpened_event

​Product2_TakeClosed_event

​Product2_TakeOpened_event

​Product3_MakeClosed_event

​Product3_MakeOpened_event

​Product3_TakeClosed_event

​Product3_TakeOpened_event

​Product4_MakeClosed_event

​Product4_MakeOpened_event

​Product4_TakeClosed_event

​Product4_TakeOpened_event

Tables

AccessControlledOffchainAggregator_NewTransmission_event

AccessControlledOffchainAggregator2_NewTransmission_event

BalancedVault_PositionUpdated_event

Product_MakeClosed_event

Product_MakeOpened_event

Product_TakeClosed_event

Product_TakeOpened_event

Product2_MakeClosed_event

Product2_MakeOpened_event

Product2_TakeClosed_event

Product2_TakeOpened_event

Product3_MakeClosed_event

Product3_MakeOpened_event

Product3_TakeClosed_event

Product3_TakeOpened_event

Product4_MakeClosed_event

Product4_MakeOpened_event

Product4_TakeClosed_event

Product4_TakeOpened_event