vertex_v1_avalanche

Tables

AvaxAirdrop_ClaimArb_event

AVAX (Avalanche native token) airdrop claim events from the ClaimArb contract on Avalanche, tracking weekly reward distributions with claimed amounts and recipient accounts. Used for analyzing airdrop participation patterns and token distribution metrics across campaign periods.

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_week`	`STRING`	Week number of the airdrop distribution period being claimed. Indicates which weekly allocation window the claim corresponds to, with values starting from 1.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_week	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x0d63b0a0402e58865efad7cee7b7604802e1c205	1	false	3956700000000000000	16	0x22e645ccd3902393d6a4ace72be4c25f9f60d334	59664882	2025-04-03T16:53:58.000Z	0x57663b47a64dbe50fe3b6ebcba6839cecb15ecdd6dbc5e89e6413783aa21d7e5
0x0d63b0a0402e58865efad7cee7b7604802e1c205	1	false	4607387200000000000000	1	0xbae5b5556dd10af04cb4d4c4df5fc0a4e3a1f929	59675333	2025-04-03T22:04:52.000Z	0x614cbf366148b13fcc201ba5cbff0a42e43c2d038b72633ed519b7d5665e99ca
0x0d63b0a0402e58865efad7cee7b7604802e1c205	1	false	70000000000000000	19	0xa4fb530d7e93bf7e3fb3b59aaadbe4dfe4068e40	59658231	2025-04-03T13:57:09.000Z	0x5af5a28c32d8da8639a0ed365c757a473c05d877f3d44da296cd080bff046670

Example Query

Query with partition filter

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

OffchainExchange_FillOrder_event

Off-chain exchange order fill events recording executed trades with subaccount balances, order parameters, and settlement deltas. Contains base and quote asset changes, execution price with 18-decimal precision, maker/taker designation, order digest for verification, and product identifier for trading pairs.

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_productId`	`STRING`	Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
`in_digest`	`STRING`	Cryptographic hash of the order being filled. 66-character hex string including 0x prefix.
`in_subaccount`	`STRING`	Subaccount identifier for the order participant. 66-character hex string including 0x prefix, encoding both the wallet address and subaccount name.
`in_priceX18`	`STRING`	Execution price for the order scaled by 10^18. Numeric string representation of the price with 18 decimal places of precision.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_expiration`	`STRING`	Order expiration timestamp. Unix timestamp in seconds, or 0 for orders without expiration.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_isTaker`	`BOOL`	Boolean flag indicating whether the order was executed as a taker order in the exchange match.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_baseDelta`	`STRING`	Change in base asset quantity for the order fill. Numeric string representation in smallest denomination, positive for buys and negative for sells.
`in_quoteDelta`	`STRING`	Change in quote asset quantity for the order fill. Numeric string representation in smallest denomination, negative when buying base and positive when selling base.

Sample Data

address	removed	in_amount	in_digest	log_index	in_isTaker	in_priceX18	block_number	in_baseDelta	in_productId	in_quoteDelta	in_subaccount	block_timestamp	transaction_hash
0x5db7f0fc871598ae424324477635cacce3f07bec	false	-11000000000000000	0x91e53a9e52ee0181df13d2d76a2cdebb3166eb6bad82c569063a7c605b7c93bf	99	false	82343000000000000000000	59490192	-11000000000000000	2	905773000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2025-03-31T00:01:52.000Z	0xd52acb6b1a6cee4053aadc66d3e739fa5c30f1b4285920279753461d04737ff5
0x5db7f0fc871598ae424324477635cacce3f07bec	false	1340000000000000000	0x2cfb01a96374149ac7ead71f1b1fb86c201b193cdaa603c3637fa58db5bb46d9	165	false	1805700000000000000000	59490192	1340000000000000000	4	-2419638000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2025-03-31T00:01:52.000Z	0xd52acb6b1a6cee4053aadc66d3e739fa5c30f1b4285920279753461d04737ff5
0x5db7f0fc871598ae424324477635cacce3f07bec	false	-260000000000000000	0x1904011627aee7e1948576b54b45fcb7f4cd1516cae39f9065aadee723ff62ce	101	false	1806500000000000000000	59490192	-260000000000000000	4	469690000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2025-03-31T00:01:52.000Z	0xd52acb6b1a6cee4053aadc66d3e739fa5c30f1b4285920279753461d04737ff5

Example Query

Query with partition filter

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

OffchainExchange_Initialized_event

Contract initialization events for the Vertex protocol OffchainExchange contract, capturing version information and deployment metadata. Emitted once per contract deployment to mark the contract’s operational state activation.

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_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x5db7f0fc871598ae424324477635cacce3f07bec	false	19	1	59044023	2025-03-21T16:17:52.000Z	0x1efdaea5debf005d4287f4eff5219994eb735c5d1a90fe72f60946115bcd4ddf

Example Query

Query with partition filter

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

OffchainExchange_OwnershipTransferred_event

Ownership transfer events from OffchainExchange contracts recording changes in contract ownership. Contains previous owner, new owner addresses, and transaction metadata for tracking administrative control transitions.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x5db7f0fc871598ae424324477635cacce3f07bec	false	5	0x4e789f8bcbe830d484c9fbba11a847305744dbf6	59044814	2025-03-21T16:42:42.000Z	0xb398ae762e9d788e30f430c013f4de46d96794d8	0x8b66400820a370ad30319543f329c58823b5d0f76056d12aa7b347af4492b9cf
0x5db7f0fc871598ae424324477635cacce3f07bec	false	18	0xb398ae762e9d788e30f430c013f4de46d96794d8	59044023	2025-03-21T16:17:52.000Z	0x0000000000000000000000000000000000000000	0x1efdaea5debf005d4287f4eff5219994eb735c5d1a90fe72f60946115bcd4ddf

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AvaxAirdrop_ClaimArb_event

OffchainExchange_FillOrder_event

OffchainExchange_Initialized_event

OffchainExchange_OwnershipTransferred_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AvaxAirdrop_ClaimArb_event

​OffchainExchange_FillOrder_event

​OffchainExchange_Initialized_event

​OffchainExchange_OwnershipTransferred_event

Tables

AvaxAirdrop_ClaimArb_event

OffchainExchange_FillOrder_event

OffchainExchange_Initialized_event

OffchainExchange_OwnershipTransferred_event