vertex_v1_arbitrum

Tables

ArbAirdrop_ClaimArb_event

ARB token claim events from Arbitrum’s airdrop contract, tracking weekly distributions to eligible accounts with claimed amounts in wei. Used for analyzing airdrop participation patterns and token distribution across claim 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 Arbitrum airdrop claim period when the tokens were claimed. Values are numeric strings representing sequential weekly distribution periods.
`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
0x75a99528b5fc4d328473032c9f390db7c8babdf1	16	false	373900000000000000	13	0x33c821a01cfadb52b91e8c6454fc3e4ff322212d	286308665	2024-12-19T06:49:47.000Z	0x48b8cb40f6f9bba4366db77588b8d98183738856d5b587cbad257c06aa446ad2
0x75a99528b5fc4d328473032c9f390db7c8babdf1	5	false	64204400000000000000	7	0x51f5a4ae44e90c1212c29927216296f29151f4d8	161693914	2023-12-19T20:07:38.000Z	0x0942f733ae36b5ab0f093f9435d16dea37c00d19051ac16810c6bd4619db83ff
0x75a99528b5fc4d328473032c9f390db7c8babdf1	5	false	7205600000000000000	1	0xf8bb57ea7dca833d4bfddab16dcd157a958a3d0e	161533666	2023-12-19T08:27:21.000Z	0x1455b8bc59378905a37fd74c7d30af5a638ade6d9fcbd17e2a320e062526569d

Example Query

Query with partition filter

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

OffchainBook_FillOrder_event

Order fill events from Vertex Protocol’s offchain orderbook on Arbitrum, capturing trade executions with price, size, fees, and subaccount identifiers. Used for analyzing trading patterns, fee structures, and maker-taker dynamics in the decentralized exchange.

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_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_nonce	in_amount	in_digest	log_index	in_isTaker	in_priceX18	block_number	in_baseDelta	in_feeAmount	in_expiration	in_quoteDelta	in_subaccount	block_timestamp	transaction_hash
0xf03f457a30e598d5020164a339727ef40f2b8fbc	false	1781870579201082082	-63000000000000000	0x2133e53f41e784b94add57a741286f9a0a2e1b8e4152bb3de6db82dd4ff76f18	105	true	34493000000000000000000	147882590	-63000000000000000	439072200000000000	11529216745392586321	2194821927800000000000	0x00bdf4629bf08c60cc107c617205d2a01548ff7964656661756c740000000000	2023-11-07T02:31:30.000Z	0x124fe67e19189daa472d1797b208101a49a97e409282209526716e6df421d2e0
0xf03f457a30e598d5020164a339727ef40f2b8fbc	false	1781875324413280565	58000000000000000	0x8273196c723296c8ad45349f7588f895ffeb9566f4675a377b196208051cc93b	135	true	35264000000000000000000	147899833	58000000000000000	405106621324264852	11529216745397111744	-2025633106621324264852	0x00bdf4629bf08c60cc107c617205d2a01548ff7964656661756c740000000000	2023-11-07T03:46:40.000Z	0xdc086e0d333f0207ef58f1b1c62d6373ea03f8e4069dc2941dfdf5b8374c2c03
0xf03f457a30e598d5020164a339727ef40f2b8fbc	false	1781878932703806085	-60000000000000000	0x4aea8689d511cda36ce82700b35c8d893870d2118e52623c390df98c04429d18	7	true	34511000000000000000000	147912992	-60000000000000000	418272000000000000	11529216745400552864	2090841728000000000000	0x00bdf4629bf08c60cc107c617205d2a01548ff7964656661756c740000000000	2023-11-07T04:45:13.000Z	0x29655588f9cebcce15394ae3fac97e5d15cc230fe4b0e2c36e7b12c7a4fcc014

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.vertex_v1_arbitrum.OffchainBook_FillOrder_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
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	8000000000000000	0x943ec35d149f9334e8d9fdade550369de86c68cbb4976889bb3e721113849c5f	205	false	99473000000000000000000	288621960	8000000000000000	2	-795784000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2024-12-26T00:02:24.000Z	0x05cfc35099b4c2c7d4445538706748f60685d6a5bb0dfd228019c2eccf64fba5
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	-30000000000000000	0xd5ebeaa9b672502c2828db3d5e74e878b3951dd157c2996a0e64360711c88574	93	true	99391000000000000000000	288621960	-30000000000000000	2	2981730000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2024-12-26T00:02:24.000Z	0x05cfc35099b4c2c7d4445538706748f60685d6a5bb0dfd228019c2eccf64fba5
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	15500000000000000000	0x13538d1f9cc7eef94874b7261fe81c5c05ee2a43f9699b1a12b763855135bc70	73	true	40236000000000000000	288621960	15500000000000000000	52	-623658000000000000000	0x0000000000000000000000000000000000000000000000000000000000000001	2024-12-26T00:02:24.000Z	0x05cfc35099b4c2c7d4445538706748f60685d6a5bb0dfd228019c2eccf64fba5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.vertex_v1_arbitrum.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
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	1	1	187309421	2024-03-05T10:37:59.000Z	0x753af468f06a9b6bdb88e53dbf4d2dc17d33da877354f7f6414aa177e590bf96

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.vertex_v1_arbitrum.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
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	0	0xb746472c10f9f128ff9f5029f424cc91bb1d8c3a	187309421	2024-03-05T10:37:59.000Z	0x0000000000000000000000000000000000000000	0x753af468f06a9b6bdb88e53dbf4d2dc17d33da877354f7f6414aa177e590bf96
0xa4369d8e3dc847aedf17f4125f1abb1bc18fc060	false	40	0x2bc1f3512c372f54d987b1de7a6eb72dfdf61533	212228959	2024-05-17T15:32:39.000Z	0xb746472c10f9f128ff9f5029f424cc91bb1d8c3a	0xa37872c570557a0d4b25ca7fed3d152e64323c60e549f89890c002bf638ce7c3

Example Query

Query with partition filter

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

VrtxAirdrop_ClaimVrtx_event

VRTX token airdrop claim events from the Vertex Protocol on Arbitrum, tracking epoch-based distribution claims with account addresses and token amounts. Used for analyzing airdrop participation patterns and token distribution across claim 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`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_epoch	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xafe39cd8e17fa4172144ff95274bb665da411f80	false	15	29962500000000000000	1	0x91d8e910cd54a978f5929bb63b0a1cee5aeac09b	232341343	2024-07-15T04:07:43.000Z	0x544bb86b999cdbb2b9b942db86a2ce5f93d9f689c78e5ff820b44d0f73a35e9d
0xafe39cd8e17fa4172144ff95274bb665da411f80	false	15	53417100000000000000	2	0x420394563f1e41267ddf44ef2754e9ce28ffcba0	232587690	2024-07-15T21:17:32.000Z	0x64f8a496f87ffdb8277a686c8492f5fc6be5e3364e8a0f77cce07be21a3ff049
0xafe39cd8e17fa4172144ff95274bb665da411f80	false	15	29355800000000000000	2	0x2deead549876c7297630f21681a1fa64e24caae4	232620193	2024-07-15T23:33:34.000Z	0x63969da6e6c2a0185a922ed1c6daeb85810f6399de78573cc7116cd146785796

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ArbAirdrop_ClaimArb_event

OffchainBook_FillOrder_event

OffchainExchange_FillOrder_event

OffchainExchange_Initialized_event

OffchainExchange_OwnershipTransferred_event

VrtxAirdrop_ClaimVrtx_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ArbAirdrop_ClaimArb_event

​OffchainBook_FillOrder_event

​OffchainExchange_FillOrder_event

​OffchainExchange_Initialized_event

​OffchainExchange_OwnershipTransferred_event

​VrtxAirdrop_ClaimVrtx_event

Tables

ArbAirdrop_ClaimArb_event

OffchainBook_FillOrder_event

OffchainExchange_FillOrder_event

OffchainExchange_Initialized_event

OffchainExchange_OwnershipTransferred_event

VrtxAirdrop_ClaimVrtx_event