holdstation_v1_zksyncera

Tables

ConvertHSTCredit_Converted_event

HST credit conversion events from Holdstation protocol on zkSync Era, recording when users convert between HOLD tokens and HST tokens at a 10:1 ratio. Useful for tracking token swap activity and user engagement with Holdstation’s credit system.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_hstAmount`	`STRING`	Amount of HST (Holdstation) tokens involved in the conversion event, denominated in the token’s smallest unit (wei). Values are string-encoded to preserve precision for large integers representing token balances.
`in_holdAmount`	`STRING`	Amount of HOLD tokens converted from HST credits in the transaction, denominated in the token’s smallest unit (wei). Values represent the converted balance following a 10:1 conversion ratio from HST to HOLD.

Sample Data

address	removed	in_sender	log_index	block_number	in_hstAmount	in_holdAmount	block_timestamp	transaction_hash
0x3c27cf352ae798ca9e28616041d47441fcd36494	false	0xbb5826e15d4e1c1cc7172893acca33a9da011bff	25	22338088	537950000000000065536	53795000000000006553	2023-12-24T22:07:48.000Z	0x8249c2f64e2ec74f275b7da4ce6f5034a3a5be103fecc9cefeba7fec9c547e2e
0x3c27cf352ae798ca9e28616041d47441fcd36494	false	0xc0e5bb4d68784a8bad7c36bc49e5790cab8da83b	27	22319611	75420000000000000000	7542000000000000000	2023-12-24T16:50:47.000Z	0x0bb74b421abcd792d5d30475804be04c1b103b6135876d6b3f31883ecf4e6e1f
0x3c27cf352ae798ca9e28616041d47441fcd36494	false	0x8ede30f9ef1d9de04412cd747febd0af162bf61f	29	22327340	26530000000000000000	2653000000000000000	2023-12-24T19:03:40.000Z	0x718231b345f8477842965817a867e55d5b5b9cadc5bc613c51cdf57e684b0188

Example Query

Query with partition filter

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

HSEscrowHold_Claimed_event

Claimed event logs from Holdstation’s escrow contract on zkSync Era, recording when users withdraw held tokens with amount and epoch information. Useful for tracking escrow redemptions and analyzing token unlock 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_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.
`in_atEpoch`	`STRING`	Epoch number when the claim occurred in the Holdstation escrow system. Values are small integers representing the staking or vesting period.

Sample Data

address	in_user	removed	in_amount	log_index	in_atEpoch	block_number	block_timestamp	transaction_hash
0x671ced60a5b4baefd4fcaf15bed4dd1292ff14a0	0x09a60bd3b7fd3917da8bbfe82e549be4915cb639	false	4084850230933013972	263	52	22387609	2023-12-25T16:34:01.000Z	0x2dc5a1804aeac4e37569bea5bfc2eb50ef49f1ce43b422e2e7af06ceeff55e97
0x671ced60a5b4baefd4fcaf15bed4dd1292ff14a0	0xd7c6e2bd795c1fde51f5e24f4f542ae431fdac8c	false	146811984865701201	11	52	22381843	2023-12-25T14:54:17.000Z	0x6db4b2b1e3ea85b4ea74a43a90f8004a6b0af09e3ea4b4e329add8a71124d1a7
0x671ced60a5b4baefd4fcaf15bed4dd1292ff14a0	0x495f2d2f1b82b090bbc6fb054cdee1b9bec3581d	false	13513778071854842	14	52	22353500	2023-12-25T02:32:03.000Z	0xb26cc3ff154d1cd68f0ea10df2450004acfa69fd6034c76ac033727287f879b6

Example Query

Query with partition filter

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

HSPairInfos_FeesCharged_event

Fee charge events from Holdstation leveraged trading protocol on zkSync Era. Records funding fees, rollover fees, and profit/loss percentages for long and short positions with leverage up to 21x for analyzing trading costs and position performance.

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_pairIndex`	`STRING`	Trading pair identifier indicating which asset pair this fee charge applies to, typically an integer index referencing a specific crypto trading pair (e.g., 0 for BTC/USD).
`in_long`	`BOOL`	Long position indicator for this leveraged trade, where true represents a bet on price increase and false represents a short bet on price decrease.
`in_collateral`	`STRING`	Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_percentProfit`	`STRING`	Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor.
`in_rolloverFees`	`STRING`	Rollover fees charged on the leveraged trading position, denominated in the smallest unit of the collateral token. Can be zero for newly opened positions or positions closed quickly, typically accumulates over time based on position duration and size.
`in_fundingFees`	`STRING`	Funding fees paid or received on the leveraged position, denominated in the protocol’s base units. Can be negative when the trader receives funding or positive when paying funding, with zero indicating no funding payment at position close.

Sample Data

address	in_long	removed	log_index	in_leverage	block_number	in_collateral	in_fundingFees	block_timestamp	in_rolloverFees	in_percentProfit	transaction_hash
0xf2552477a57b64774dc35e3bb4f2941280b2c39a	true	false	59	3	13297913	783116000	0	2023-09-08T04:33:50.000Z	0	-1141268	0xb095c8c11ef1233031e40ab0ec81858a7fd67bd0ff4a974ab456aeadc728e642
0xf2552477a57b64774dc35e3bb4f2941280b2c39a	false	false	44	3	13326912	843969600	0	2023-09-08T12:54:05.000Z	12659	1159544	0xdc30ce4f051a929e8db946bc6ebc0d972a15ccc835e5de6920697265b26d8853
0xf2552477a57b64774dc35e3bb4f2941280b2c39a	true	false	5	8	13356317	260680896	145981	2023-09-08T21:14:02.000Z	1331818	33029058504	0x587cd392843712d8e71660e2cde7a70b6aee725208c4053eee67bbdbb7dc7f30

Example Query

Query with partition filter

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

HSStaking_ESHoldClaimed_event

Staking reward claim events from Holdstation’s esHOLD (escrowed HOLD token) staking contract on zkSync Era. Tracks user reward claims with epoch timing and future reward projections for analyzing staking participation and reward distribution 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_currentEpoch`	`STRING`	Epoch number during which the user claimed their esHOLD staking rewards. Represented as a string-encoded integer, incrementing with each staking period.
`in_nextEpochRewarding`	`STRING`	Total staking balance eligible for rewards in the next epoch, denominated in the smallest token unit (wei). Values represent the user’s updated stake after the current claim transaction.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_currentEpoch	transaction_hash	in_nextEpochRewarding
0x7cf68aa037c67b6dae9814745345ffa9fc7075b1	0x3cd85addd0d009e46ad3404bcd60a5c86c9533ed	false	8486525850000000000	2	22284341	2023-12-24T06:35:14.000Z	4	0xf8ea358b8d60f96a65a23dc34eadd7e41a8b76005d1a218baf5e02347c72382a	1500000000000000000000
0x7cf68aa037c67b6dae9814745345ffa9fc7075b1	0x2df4450f08a8e54fdccd5738d39afd45ed577eec	false	1811179598368000000	2	22278918	2023-12-24T05:01:13.000Z	4	0x84dc1cb8de132858b856f7e87a239c9655e4065b0707609e74053d3e4ddcb460	350000000000000000000
0x7cf68aa037c67b6dae9814745345ffa9fc7075b1	0x000002c34bae6dd7bec72acba6aaac1e01a359de	false	37212080000000000000	5	22280419	2023-12-24T05:27:08.000Z	4	0xa3b37f3a9f42d81f0068ec9ec018842cbb2d7e20c726bcf0ac9274ff285d4593	25000000000000000000000

Example Query

Query with partition filter

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

HSTradingCallbacks_AgencyFeeCharged_event

Agency fee events charged to traders on Holdstation’s trading protocol on zkSync Era, denominated in USDC (6 decimals). Used for analyzing fee revenue and trader activity patterns across the platform.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x036239f5938aa967fb08e38225fda310895a8100	6	23214861	706559	2024-01-04T16:35:30.000Z	0xef5b5ea9f7aea8445615c209e8fd956860d085af6d22a2ce4ebbfd37d5be2988
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x11ebfb331fcf6e680c383cbbb96792ae0eb7318e	91	23173601	639999	2024-01-04T04:22:21.000Z	0xd1c1673d75e83bff3cf8d3669f072fb425939a38cf5cbd6063aa67533ccf870f
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x11ebfb331fcf6e680c383cbbb96792ae0eb7318e	32	23171434	652799	2024-01-04T03:44:14.000Z	0x35b6c07f633b89242830470f19f968bb562eb7da12c6f619a54328b9dc4c04cc

Example Query

Query with partition filter

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

HSTradingCallbacks_DevGovFeeCharged_event

Development and governance fee collection events from HoldStation trading protocol on zkSync Era. Records USDC-denominated fees charged to traders, useful for analyzing protocol revenue and fee distribution.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xbc98d219b23895c230b5ae32f408b7ddc8190c84	1	15806953	3000000	2023-10-07T22:08:41.000Z	0x97562432315d9144ece88b9af99ac34dded31ed58272e1184dc3e3fcf803f242
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xc5d8902c58a285d0f1c0d56958d5a97a3aa88af9	1	15801496	1224000	2023-10-07T20:36:20.000Z	0x0722c0595c12bc7dcd62b2f8372fd89b00194d66ea8021f85a6e58b20ee12edf
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x3f35501389564a7cdb4310e156a78260a9f780e8	3	15796523	768716	2023-10-07T19:12:00.000Z	0x11392ec8a60af66008dbf1862b49ab05fa68937fc69c6dc9a4bf057e9ec221db

Example Query

Query with partition filter

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

HSTradingCallbacks_LimitExecuted_event

Limit order execution events from Holdstation perpetual trading protocol on zkSync Era. Records filled limit orders with execution price, profit/loss, USDC settlements, and trader positions for analyzing order book dynamics and trade outcomes.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_limitIndex`	`STRING`	Index of the limit order within a trader’s position. String-encoded integer identifier used to track multiple limit orders (take profit or stop loss) associated with a single trading position.
`in_t`	`STRUCT<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeUsdc STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price.
`in_nftHolder`	`STRING`	Address of the NFT holder who is entitled to collect execution fees for the limit order. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderType`	`INT64`	Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_priceImpactP`	`STRING`	Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity.
`in_positionSizeUsdc`	`STRING`	Position size in USDC for this limit order execution, denominated in the protocol’s base units (typically 6 decimals). Represents the total notional value of the leveraged position at execution time.
`in_percentProfit`	`STRING`	Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor.
`in_usdcSentToTrader`	`STRING`	USDC amount sent to the trader upon limit order execution, denominated in the token’s smallest unit (6 decimals for USDC). Zero when position is liquidated or closed at a loss.

Sample Data

in_t	address	removed	in_price	log_index	in_orderId	block_number	in_nftHolder	in_orderType	block_timestamp	in_percentProfit	transaction_hash	in_positionSizeUsdc	in_usdcSentToTrader
{“sl”:“272856009324749”,“tp”:“276000000000000”,“buy”:true,“index”:“0”,“trader”:“0x85b215da26dc7b44ebd5abfa14af95dbd4ad356f”,“leverage”:“150”,“openPrice”:“274227145049998”,“pairIndex”:“0”,“initialPosToken”:“88000000”,“positionSizeUsdc”:“88000000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	272856009324749	19	10065	3553893	0x4cf7bab01b8d3572b3dc08642ebbe2ad1acf3b99	1	2023-05-15T14:17:38.000Z	-749999999999	0xf79b2c1caa4a55dcb8a36ee50ac1e9512900a2b41b162872c1364f97de9966d4	88000000	11409025
{“sl”:“273169400000000”,“tp”:“290042900000000”,“buy”:true,“index”:“0”,“trader”:“0x43079513ebd84afb15be79021c420fe8055bc635”,“leverage”:“150”,“openPrice”:“273704884050000”,“pairIndex”:“0”,“initialPosToken”:“44000000”,“positionSizeUsdc”:“44000000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	273169400000000	17	10063	3553642	0x4cf7bab01b8d3572b3dc08642ebbe2ad1acf3b99	1	2023-05-15T14:13:16.000Z	-293464282812	0x3219016d22881bf2c6a4aa9330cd2c0bb7d697dc4b397b54a37d480754a53bea	44000000	25792700
{“sl”:“274097500000000”,“tp”:“291408800000000”,“buy”:true,“index”:“0”,“trader”:“0x43079513ebd84afb15be79021c420fe8055bc635”,“leverage”:“150”,“openPrice”:“274937500049998”,“pairIndex”:“0”,“initialPosToken”:“44000000”,“positionSizeUsdc”:“44000000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	274097500000000	18	10071	3568156	0x4cf7bab01b8d3572b3dc08642ebbe2ad1acf3b99	1	2023-05-15T18:26:18.000Z	-458286001279	0x663444f0ce9f0de087eddb8a9a49e023ba2a2ee65fee4f86ee76987ac3f4e038	44000000	18555108

Example Query

Query with partition filter

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

HSTradingCallbacks_LpFeeCharged_event

No description available.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

HSTradingCallbacks_MarketExecuted_event

Market order execution events from Holdstation perpetual trading protocol on zkSync Era. Records position opens and closes with execution prices, profit/loss, leverage, and trader details for analyzing trading performance and order 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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_t`	`STRUCT<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeUsdc STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price.
`in_open`	`BOOL`	Boolean flag indicating whether the event represents a position opening (true) or closing (false) operation.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_priceImpactP`	`STRING`	Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity.
`in_positionSizeUsdc`	`STRING`	Position size in USDC for this trade, denominated in smallest unit (6 decimals). For example, a value of 13380000 represents 13.38 USDC collateral used in the leveraged position.
`in_percentProfit`	`STRING`	Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor.
`in_usdcSentToTrader`	`STRING`	Amount of USDC transferred to the trader upon trade execution. Zero for position openings, non-zero when closing positions with profit or loss.

Sample Data

in_t	address	in_open	removed	in_price	log_index	in_orderId	block_number	block_timestamp	in_percentProfit	transaction_hash	in_positionSizeUsdc	in_usdcSentToTrader
{“sl”:“0”,“tp”:“278281482000000”,“buy”:true,“index”:“0”,“trader”:“0xf9b501476dbd564ef1cbc0dfe7b32e2a7c3f554e”,“leverage”:“150”,“openPrice”:“262597355580000”,“pairIndex”:“0”,“initialPosToken”:“12320000”,“positionSizeUsdc”:“12320000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	true	false	262597355580000	69	37613	13760037	2023-09-13T15:54:44.000Z	0	0xf6d91b6e40de738345328496bfca9003b3ddd0561117ef90bd225052572c53c7	12320000	0
{“sl”:“263000000000000”,“tp”:“255000000000000”,“buy”:false,“index”:“0”,“trader”:“0x6dec00f9bc651329bcc77f9fdcd77c92091267a0”,“leverage”:“150”,“openPrice”:“261944400000000”,“pairIndex”:“0”,“initialPosToken”:“12488000”,“positionSizeUsdc”:“12488000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	false	261703000000000	12	37577	13750187	2023-09-13T13:08:04.000Z	138235442330	0x09411edd6878605c702a4604c3c563292fc9cd8ad1c457e881adbba032512932	12488000	12800743
{“sl”:“0”,“tp”:“277282856000000”,“buy”:true,“index”:“0”,“trader”:“0x0c6df0eca9891757777ebc9e5d0ca0af6c0175dc”,“leverage”:“150”,“openPrice”:“261860734660000”,“pairIndex”:“0”,“initialPosToken”:“12488000”,“positionSizeUsdc”:“12488000”}	0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	true	false	261860734660000	20	37495	13738960	2023-09-13T09:58:08.000Z	0	0xe60f9605a85f90b71575c6b429ba8ee731a354b8806fbe8bc8bb6e67f0c9afce	12488000	0

Example Query

Query with partition filter

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

HSTradingCallbacks_NftBotFeeCharged_event

NFT bot fee charges from Holdstation trading platform on zkSync Era, recording USDC-denominated fees collected from traders. Used for analyzing bot trading costs and platform revenue.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xaa9d33ef404e943866e9adebb8663d43c12b11a4	14	15948257	1378868	2023-10-09T14:24:55.000Z	0x0e4b01ca4b23a1752fdcf75a4cac48682e790176bf578f2621e9fb463e95eac1
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xdaa340a1a5061051232ac1f7d1df2ded6b7cf1b4	14	15923585	1864200	2023-10-09T07:20:51.000Z	0xd32472f957388b65e4a10aca9bd937534334998c28dbc9490472f749d682a9b2
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x340918fa42a54f2f65ef37f196a217ffbe1ca9d3	14	15956466	2887953	2023-10-09T16:44:44.000Z	0xeef34a9fc528932ece595ebe77bcfe79df306012eeac06aca9087aae9825f17c

Example Query

Query with partition filter

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

HSTradingCallbacks_ReferralFeeCharged_event

Referral fee events from Holdstation trading protocol on zkSync Era, recording USDC-denominated commissions charged per trader transaction. Useful for analyzing referral program economics and fee distribution 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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x1fd3d6774895065912d17d8eac0150fb49515b2f	93	21537873	405000	2023-12-15T07:48:44.000Z	0x992b0b6c36e97492ea58972bc344baa3e294c75c2c766545a9f5d7db3d625713
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x1fd3d6774895065912d17d8eac0150fb49515b2f	7	21516543	405000	2023-12-15T01:40:49.000Z	0x97c723a172132669b9633ecf9a5a2de99c4fa5033bf757ed95920314d39644bc
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x1fd3d6774895065912d17d8eac0150fb49515b2f	28	21587835	463320	2023-12-15T22:04:43.000Z	0x958306b5775280a23b83c1586687b588afb8cd0dd8024e6796107f55074d8620

Example Query

Query with partition filter

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

HSTradingCallbacks_SssFeeCharged_event

SSS (spread/swap/service) fee charges from Holdstation’s trading protocol on zkSync Era. Tracks USDC-denominated fees collected from traders for analyzing protocol revenue and per-trader fee contributions.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x839f7fc0dd0139d6d6a8f7ad7baed6d058f9c80c	257	23181064	1336285	2024-01-04T06:34:38.000Z	0xffe53f51467e025a1ecadcae1d1e103eb61d0167eb34846ac001897c7bd77819
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x801b5b09ab87ef040a79350ed48ee0cad11784b1	5	23232771	1167840	2024-01-04T21:42:47.000Z	0xcd3a6e1c099680556c379b8765b122c994d0688bccaa9c92ea6fd79f9b88ac83
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0x8d03e140cbbf343b1bf209ca8b8b9c1c5ac167ba	5	23179828	670198	2024-01-04T06:12:22.000Z	0xe0b7a9f051863aa33c103e6521b78cfe637416c3ba4cf6f21e455c6f6c343bec

Example Query

Query with partition filter

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

HSTradingCallbacks_UsdcVaultFeeCharged_event

USDC vault fee charges from Holdstation trading protocol on zkSync Era. Records per-trader fee amounts in USDC (6 decimals) for analyzing fee distribution and protocol revenue.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_valueUsdc`	`STRING`	Fee amount denominated in USDC. String-encoded integer representing the smallest unit of USDC.

Sample Data

address	removed	in_trader	log_index	block_number	in_valueUsdc	block_timestamp	transaction_hash
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xd9938eeab4c59cf0ece03de5b1108ce3bdc5a677	8	22903238	544511	2023-12-31T22:09:45.000Z	0x8a1e703b1e3719f13a5c41e64551a11a747be30c14afd453210eca9600d645f8
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xf7eccb2bad4a0b3e45e212072fc23b982934390b	8	22904889	9768000	2023-12-31T22:37:52.000Z	0x5d01bc8d7fc7a0e08a045c0ae250d94baae6be36b8b8ced34eda846958f82f90
0x60fd38f02c911aa1e3cbfdc5652f30927f0f3f77	false	0xa3abc653346425f2012bdb9489fabe4b9c26a73f	8	22893405	607924	2023-12-31T19:21:23.000Z	0xd5f96d0bf9af6e6908a198f24eaa64bc2a71d46bfaf0e5cd62253e9fe2ba9200

Example Query

Query with partition filter

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

HSVestingEsHold_Claimed_event

Vesting claim events from Holdstation’s escrowed HOLD token contract on zkSync Era. Records user withdrawals of vested esHOLD tokens by epoch, with claim amounts and timing for analyzing token unlock schedules and claiming 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_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.
`in_atEpoch`	`STRING`	Vesting epoch identifier at which the esHOLD tokens were claimed by the user. Numerical value stored as string, typically ranges from 1 to 8 representing sequential claim periods.

Sample Data

address	in_user	removed	in_amount	log_index	in_atEpoch	block_number	block_timestamp	transaction_hash
0x9e6c653a0b82427350685d4f2e59a5d6c70523cf	0xd951da0f8cfefd3a1a17c3312ee1d18cac271469	false	355000000000000000	299	1	21192023	2023-12-11T04:05:06.000Z	0x0063228049ee394072c8d449edfde22693cb1a70688cced5057920611db18148
0x9e6c653a0b82427350685d4f2e59a5d6c70523cf	0x939d6ff091dd5625dd6909ececb12449488280b7	false	1115000000000000000	61	1	21206912	2023-12-11T08:30:16.000Z	0xf4b9bf29700234fbebf44dcf2d8f5a0ba145da061e28ec98582849181de3c133
0x9e6c653a0b82427350685d4f2e59a5d6c70523cf	0xdc678b788bd4ca9d231f388d3ae45cf9a6eba234	false	9039999999999998976	4	8	23365818	2024-01-06T12:30:16.000Z	0x775e93f3a7b9342f0e5a1b292dc0411ddc91ccd7162bced5de7a0564fee21b06

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ConvertHSTCredit_Converted_event

HSEscrowHold_Claimed_event

HSPairInfos_FeesCharged_event

HSStaking_ESHoldClaimed_event

HSTradingCallbacks_AgencyFeeCharged_event

HSTradingCallbacks_DevGovFeeCharged_event

HSTradingCallbacks_LimitExecuted_event

HSTradingCallbacks_LpFeeCharged_event

HSTradingCallbacks_MarketExecuted_event

HSTradingCallbacks_NftBotFeeCharged_event

HSTradingCallbacks_ReferralFeeCharged_event

HSTradingCallbacks_SssFeeCharged_event

HSTradingCallbacks_UsdcVaultFeeCharged_event

HSVestingEsHold_Claimed_event

​Tables

​ConvertHSTCredit_Converted_event

​HSEscrowHold_Claimed_event

​HSPairInfos_FeesCharged_event

​HSStaking_ESHoldClaimed_event

​HSTradingCallbacks_AgencyFeeCharged_event

​HSTradingCallbacks_DevGovFeeCharged_event

​HSTradingCallbacks_LimitExecuted_event

​HSTradingCallbacks_LpFeeCharged_event

​HSTradingCallbacks_MarketExecuted_event

​HSTradingCallbacks_NftBotFeeCharged_event

​HSTradingCallbacks_ReferralFeeCharged_event

​HSTradingCallbacks_SssFeeCharged_event

​HSTradingCallbacks_UsdcVaultFeeCharged_event

​HSVestingEsHold_Claimed_event

Tables

ConvertHSTCredit_Converted_event

HSEscrowHold_Claimed_event

HSPairInfos_FeesCharged_event

HSStaking_ESHoldClaimed_event

HSTradingCallbacks_AgencyFeeCharged_event

HSTradingCallbacks_DevGovFeeCharged_event

HSTradingCallbacks_LimitExecuted_event

HSTradingCallbacks_LpFeeCharged_event

HSTradingCallbacks_MarketExecuted_event

HSTradingCallbacks_NftBotFeeCharged_event

HSTradingCallbacks_ReferralFeeCharged_event

HSTradingCallbacks_SssFeeCharged_event

HSTradingCallbacks_UsdcVaultFeeCharged_event

HSVestingEsHold_Claimed_event