dolomite_v1_arbitrum - Token Terminal Docs

Tables

BorrowPositionProxy_BorrowPositionOpen_event

Event logs tracking new borrow position openings on Dolomite v1 lending protocol on Arbitrum. Records borrower addresses and unique position indices for monitoring leverage activity 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__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrowAccountIndex`	`STRING`	Unique identifier for a specific borrow account position within Dolomite’s protocol. Represented as a large integer value that distinguishes individual borrowing positions for the same borrower address.

Sample Data

address	removed	log_index	block_number	in__borrower	block_timestamp	transaction_hash	in__borrowAccountIndex
0xe43638797513ef7a6d326a95e8647d86d2f5a099	false	3	104602011	0x1faf923d31954ea1c9f166dc2492b40b6745b79d	2023-06-25T00:55:52.000Z	0xaae2ffda8eab802e9c99144d84cabcd96f4e4ed006f3bddf4fff08f4a0a50ef6	17520326488749081996619435081750720910750273211623416170173738924380470190258
0xe43638797513ef7a6d326a95e8647d86d2f5a099	false	0	104814919	0xf73cb174e5f525e7139db12178a68275604fce67	2023-06-25T15:59:55.000Z	0xe7af7c3e326be2d7ddb8c744925621661e79db25d018ab33a55d8a384269e1f8	78787854062748365795256193922239968091210618452263969673489490643520705241142
0xe43638797513ef7a6d326a95e8647d86d2f5a099	false	0	104591232	0xa7462ac5ce32b5387651ad60dde7f970740772f9	2023-06-25T00:07:51.000Z	0x00c1ec7e9b7c3e4699ba6ab6ba243bda5d85e88cd8aa8095fafcbeabfcaddf38	82661779444498200941321354128404501272913200604326407648106279997937365707775

Example Query

Query with partition filter

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

BorrowPositionProxyV2_BorrowPositionOpen_event

Borrow position creation events from Dolomite v1 lending protocol on Arbitrum, capturing when users open new isolated margin accounts. Contains borrower addresses and unique account numbers for tracking leverage position lifecycles.

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__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrowAccountNumber`	`STRING`	Unique identifier for a borrower’s account position in the Dolomite protocol, represented as a large integer. Each borrower can have multiple accounts with distinct identifiers for managing separate positions.

Sample Data

address	removed	block_number	in__borrower	block_timestamp	transaction_hash	in__borrowAccountNumber
0x38e49a617305101216ec6306e3a18065d14bf3a7	false	132107841	0xc1a9e8c22c77546f7bacb37f4b480def256bd60b	2023-09-18T04:31:14.000Z	0xd53a81931b580ac68c9912f82c7489a526f7b27dd9028fd4e945105be8739fce	73477562853622761467582309264697839979719104833078957804587532587893326622136
0x38e49a617305101216ec6306e3a18065d14bf3a7	false	132111888	0xa5a540ebd011e7d35ecc2dbc36ece9c0c3afbdde	2023-09-18T04:51:03.000Z	0xc99fe2bc4bf742f264c10ed0d6521e043fa5336d8d32ac40ee3a6300c2912091	100463039202735519434357126461227079548978340180041808051546446176174681661492
0x38e49a617305101216ec6306e3a18065d14bf3a7	false	132181161	0xe920579ee6ac1d7d7f6d4f7ff4428269f0f6835b	2023-09-18T09:58:28.000Z	0x26cdf181717e4cc8b1bfaaf588939773a23f7583e77f0f02b2e7fa38ea20cdd3	97757968839549196062985520820208708829464833633212497420137789167677205760769

Example Query

Query with partition filter

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

DolomiteMargin_LogAddMarket_event

Event log emitted when a new market is added to the Dolomite margin protocol, recording the assigned market identifier and token address. Used for tracking market availability and supported assets across Dolomite deployments.

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_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_token	log_index	in_marketId	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x4186bfc76e2e237523cbc30fd220fe055156b41f	20	49	220833208	2024-06-11T19:46:18.000Z	0xf2e7e4a96c4597a9c8715b76c2ce9a56db63d80420b6d93a3f84c4eed96ac8f8
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x57f5e098cad7a3d1eed53991d4d66c45c9af7812	9	48	220833208	2024-06-11T19:46:18.000Z	0xf2e7e4a96c4597a9c8715b76c2ce9a56db63d80420b6d93a3f84c4eed96ac8f8
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x2adba3f917bb0af2530f8f295ad2a6ff1111fc05	13	10	103377073	2023-06-21T09:03:55.000Z	0x8efbc07ec436fbf87863107d5aaf1586d52c766233b931aecc511c449fa8e36c

Example Query

Query with partition filter

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

DolomiteMargin_LogBuy_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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_takerMarket`	`STRING`	Market identifier for the token sold in the swap. Numeric string representing the Dolomite protocol’s internal market ID.
`in_makerMarket`	`STRING`	Market identifier for the token received in the swap. Numeric string representing the Dolomite protocol’s internal market ID.
`in_takerUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the taker market position in the Dolomite protocol. Contains deltaWei (balance change) and newPar (principal balance after update), each with a sign indicating positive or negative value and a numeric string value.
`in_makerUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the maker market position in the Dolomite protocol. Contains deltaWei (balance change) and newPar (principal balance after update), each with a sign indicating positive or negative value and a numeric string value.
`in_exchangeWrapper`	`STRING`	Contract address of the exchange wrapper used to facilitate the token swap in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DolomiteMargin_LogCall_event

Event log emitted when an external contract call is executed within a Dolomite Margin account operation. Contains the account owner, sub-account number, and callee address for tracking protocol interactions and external integrations.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_callee`	`STRING`	Contract address of the callee invoked in the Dolomite protocol operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_callee	log_index	block_number	block_timestamp	in_accountOwner	in_accountNumber	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x00e4180f25896229979a52d73be22963e93bc8ce	14	289449487	2024-12-28T09:42:28.000Z	0xc42bbb590c8d30980e8770fabd728168391de421	53234473273899670776489749533005911553580402802450762408806006447685355645099	0xd2050aace6c88866144e47f3e8f8f31031e3c9081c90a513bcfe4775f6d1c1d4
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x00e4180f25896229979a52d73be22963e93bc8ce	9	289468609	2024-12-28T11:02:09.000Z	0xb007ff0f47cfb36f5682a3a48017db9caba7db98	89399195349342979017400601950075013038158106456762613284645715458683328893029	0xdad617e19c385abdc3d4dc553cab2a5794c7500dfb4883646d969d4549536c38
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x00e4180f25896229979a52d73be22963e93bc8ce	46	289454776	2024-12-28T10:04:30.000Z	0x8d0b9badf52c71165a6df80bb9033bf877a9e302	1010631906686377722343762136550357647753935874432373029295041516919135975852	0xc4931b9097c055808e5473ec2128c534d6968e9ed1646ea3a44fa875465160f1

Example Query

Query with partition filter

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

DolomiteMargin_LogDeposit_event

Deposit events emitted by the DolomiteMargin protocol recording account collateral additions. Contains account owner, market identifier, depositor address, and balance changes including the Wei delta and updated principal balance with sign indicators.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_update`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Account balance update containing the change in Wei (deltaWei) and the new principal balance (newPar). Each component includes a boolean sign indicator and a numeric string value representing the amount.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_from	removed	in_update	log_index	block_number	block_timestamp	in_accountOwner	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	0xadb9d68c613df4aa363b42161e1282117c7b9594	false	{“newPar”:{“sign”:true,“value”:“120029775440322250”},“deltaWei”:{“sign”:true,“value”:“1000000000000000”}}	43	199678187	2024-04-10T20:39:55.000Z	0xa4a2e39b198877393edc274cc8886078ae4baad3	0x2a58d5dbf250250b3ad71aba308afa60544dae95f8cd8d39253f1dee08eef1fe
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	0xbdaee0edcc7d3f159325c29f7ca2cd3e50967c93	false	{“newPar”:{“sign”:true,“value”:“10654845608880682990”},“deltaWei”:{“sign”:true,“value”:“5000000000000000000”}}	15	199572345	2024-04-10T13:14:07.000Z	0xbdaee0edcc7d3f159325c29f7ca2cd3e50967c93	0xdad5fc687d806c6d96d58ad6ed4a9ebb9de991cb1ae5523c390cd2e8b47f7332
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	0xadb9d68c613df4aa363b42161e1282117c7b9594	false	{“newPar”:{“sign”:true,“value”:“50435748340785550”},“deltaWei”:{“sign”:true,“value”:“51600000000000000”}}	16	199608992	2024-04-10T15:48:48.000Z	0xdcb906044452856242401323e4c76df9f15690e1	0x92ac322c4bc8eea9b09036a16366262499119000dc3a8e32b17be792666a3010

Example Query

Query with partition filter

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

DolomiteMargin_LogIndexUpdate_event

Interest rate index updates for Dolomite margin markets containing borrow rate, supply rate, and last update timestamp. Tracks the accumulation of interest over time for each market identifier.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_index`	`STRUCT<borrow STRING, supply STRING, lastUpdate STRING>`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_market	log_index	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“borrow”:“1025574056975364497”,“supply”:“1008386364797307389”,“lastUpdate”:“1737937078”}	12	9	299638707	2025-01-27T00:17:58.000Z	0x731256621a9aa7bcad356dc7b15f8f302d9e9ee188f66df02f8f9267d58dfe13
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“borrow”:“1316034143775013117”,“supply”:“1226877912977430873”,“lastUpdate”:“1737937078”}	5	7	299638707	2025-01-27T00:17:58.000Z	0x731256621a9aa7bcad356dc7b15f8f302d9e9ee188f66df02f8f9267d58dfe13
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“borrow”:“1048341785081365358”,“supply”:“1019722028757033908”,“lastUpdate”:“1737937078”}	39	10	299638707	2025-01-27T00:17:58.000Z	0x731256621a9aa7bcad356dc7b15f8f302d9e9ee188f66df02f8f9267d58dfe13

Example Query

Query with partition filter

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

DolomiteMargin_LogInterestRate_event

Interest rate update events emitted by Dolomite Margin protocol contracts, recording rate changes for lending markets. Contains market identifier and new rate value for tracking borrowing cost dynamics.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_rate`	`STRUCT<value STRING>`	Interest rate value used in the protocol operation. Numeric string representation without decimal formatting.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DolomiteMargin_LogLiquidate_event

Liquidation events from the Dolomite margin trading protocol recording undercollateralized position seizures. Contains liquidator and liquidated account identifiers, market IDs for collateral and debt assets, and balance updates (deltaWei and newPar) for both parties’ positions.

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_solidAccountOwner`	`STRING`	Account address of the entity performing the liquidation or vaporization in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_solidAccountNumber`	`STRING`	Account number identifying the liquidator’s position in the Dolomite protocol. String-encoded numeric value, with 0 representing the default account and larger values representing isolated sub-accounts.
`in_liquidAccountOwner`	`STRING`	Account address of the entity whose position is being liquidated in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidAccountNumber`	`STRING`	Account number identifying the position being liquidated in the Dolomite protocol. String-encoded numeric value, with 0 representing the default account and larger values representing isolated sub-accounts.
`in_heldMarket`	`STRING`	Market identifier for the collateral asset held by the account. String-encoded numeric value representing the market ID in the Dolomite protocol.
`in_owedMarket`	`STRING`	Market identifier for the debt asset owed by the account. String-encoded numeric value representing the market ID in the Dolomite protocol.
`in_solidHeldUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidator’s collateral position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).
`in_solidOwedUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidator’s debt position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).
`in_liquidHeldUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidated account’s collateral position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).
`in_liquidOwedUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidated account’s debt position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).

Sample Data

address	removed	log_index	block_number	in_heldMarket	block_timestamp	transaction_hash	in_solidHeldUpdate	in_solidOwedUpdate	in_liquidHeldUpdate	in_liquidOwedUpdate	in_solidAccountOwner	in_liquidAccountOwner	in_liquidAccountNumber
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	31	213935994	7	2024-05-22T17:17:40.000Z	0x229753ccd5643dfad2b942b4277acaf0de50b2fdb967d07227ae552aa1c8ee38	{“newPar”:{“sign”:true,“value”:“353036309775378588”},“deltaWei”:{“sign”:true,“value”:“20205593573381661”}}	{“newPar”:{“sign”:true,“value”:“6209526448941145910”},“deltaWei”:{“sign”:false,“value”:“5863275030221”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“20205593573381661”}}	{“newPar”:{“sign”:false,“value”:“4262071250265”},“deltaWei”:{“sign”:true,“value”:“5863275030221”}}	0x1ff6b8e1192eb0369006bbad76da9068b68961b2	0x60b47e130b64d1514e61811541215e9aba1c9f01	1818340209764264718739867023107231399134460632933499603921569377885393186089
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	33	213879637	28	2024-05-22T13:18:07.000Z	0x28fe75f0d4f99d4ac7442a883a27cf8f1b82bb91d593dbfa13d63dda574e1af2	{“newPar”:{“sign”:true,“value”:“72432945546843431992”},“deltaWei”:{“sign”:true,“value”:“72432945546843431992”}}	{“newPar”:{“sign”:true,“value”:“6188285668338638899”},“deltaWei”:{“sign”:false,“value”:“20486557230044780”}}	{“newPar”:{“sign”:true,“value”:“8764110157991944509”},“deltaWei”:{“sign”:false,“value”:“72432945546843431992”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“20486557230044780”}}	0x1ff6b8e1192eb0369006bbad76da9068b68961b2	0xfa8c419f57a71771f61530c0ad5b363e26c05129	73393820303938633648714426277132004145259668624937110196805672159401770351114
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	37	196371870	7	2024-04-01T05:50:58.000Z	0xaeb19bd5bb4e409f46debc0ff65613a47d67d8f413d5d3a4d750a7cb27042989	{“newPar”:{“sign”:true,“value”:“36583886417404860”},“deltaWei”:{“sign”:true,“value”:“20234763144494875”}}	{“newPar”:{“sign”:true,“value”:“4216882894424545763”},“deltaWei”:{“sign”:false,“value”:“8539829529376”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“20234763144494875”}}	{“newPar”:{“sign”:false,“value”:“1590673056249”},“deltaWei”:{“sign”:true,“value”:“8539829529376”}}	0x1ff6b8e1192eb0369006bbad76da9068b68961b2	0x0b6b2740ab0508ee9ca739c7b3da2e1cdc3dd2a6	106213372350936711848973969323130927348206794191629942222831237375019609718162

Example Query

Query with partition filter

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

DolomiteMargin_LogOperation_event

Event log emitted by DolomiteMargin protocol contracts when an operation is executed, recording the sender address and transaction context. Used for tracking protocol interactions and operation sequencing across margin trading activities.

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.

Sample Data

address	removed	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x1d9e10b161ae54feabe1e3f71f658cac3468e3c3	1	191518283	2024-03-18T03:27:57.000Z	0xb35ce2e8ccfedec979d7d703e4aecb8329761b4960515c56edb5fdab44c0c30d
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x1d9e10b161ae54feabe1e3f71f658cac3468e3c3	4	191607505	2024-03-18T09:44:01.000Z	0x2fceb9942271f05aa9b268382eca300637e2a683bdc13887f0e43f9b638250ce
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x1d9e10b161ae54feabe1e3f71f658cac3468e3c3	4	191596121	2024-03-18T08:56:30.000Z	0x8a70d1e89d6d16ce4d0c12307b38e6d56bba9bdaf3bce5e69a971ef3980224fa

Example Query

Query with partition filter

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

DolomiteMargin_LogOperatorSet_event

Operator authorization events from Dolomite Margin protocol recording when an owner grants or revokes trusted operator status to an address. The in_trusted flag indicates whether the operator is being authorized or deauthorized to execute operations on behalf of the owner.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_trusted`	`BOOL`	Boolean flag indicating whether the operator has trusted status for the owner’s account.

Sample Data

address	removed	in_owner	log_index	in_trusted	in_operator	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0xbd63e9b1a9ae262ae66a5979423f2d2b94e87813	0	true	0xce451310d82742a1689a5de6bac9fcf8a976b568	28738238	2022-10-06T17:40:26.000Z	0x884fb7f7f73e4d8d37f5aa2d65cc1ae138106c0d71d1160676b52d64eee2b48e
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0xbd63e9b1a9ae262ae66a5979423f2d2b94e87813	0	true	0x8a80212d49f0169d58d61a5c448687d48cd6f879	28738242	2022-10-06T17:40:28.000Z	0xecc4994d5362c095019b94682a5666a2f3ee9982f8140f5238f082412312c337
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0x1ff6b8e1192eb0369006bbad76da9068b68961b2	3	true	0x84b027f8fcefe40d044ccf9ccb54cc6e48c53450	97815160	2023-06-04T20:46:39.000Z	0xd4018290e00bbeeff41ec8d47ca39e78c91440f2e44c17898c1fbcaefb2e4fe1

Example Query

Query with partition filter

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

DolomiteMargin_LogOraclePrice_event

Oracle price update events emitted by Dolomite Margin contracts, containing market identifiers and updated asset prices. Used for tracking price feed changes and valuation snapshots across Dolomite protocol markets.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_price`	`STRUCT<value STRING>`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.

Sample Data

address	removed	in_price	in_market	log_index	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	1000098710000000000000000000000	2	10	83291377	2023-04-23T00:33:22.000Z	0x2a73c25756161671a152743492bbb8877ca343997484987e980b5f6da14a155c
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	1868511676570000000000	0	9	83291377	2023-04-23T00:33:22.000Z	0x2a73c25756161671a152743492bbb8877ca343997484987e980b5f6da14a155c
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	1856488600000000000000	0	3	83291672	2023-04-23T00:34:34.000Z	0x104ef8c5d25ba6b7e17ae76ca0a6fa7f1f323cbad84bae08c516337863377199

Example Query

Query with partition filter

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

DolomiteMargin_LogSell_event

Token swap events from the Dolomite protocol recording account-to-market trades with balance updates. Contains taker market (sold token), maker market (received token), account identifiers, exchange wrapper address, and delta/principal balance changes for both positions.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_takerMarket`	`STRING`	Market identifier for the token sold in the swap. Numeric string representing the Dolomite protocol’s internal market ID.
`in_makerMarket`	`STRING`	Market identifier for the token received in the swap. Numeric string representing the Dolomite protocol’s internal market ID.
`in_takerUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the taker market position in the Dolomite protocol. Contains deltaWei (balance change) and newPar (principal balance after update), each with a sign indicating positive or negative value and a numeric string value.
`in_makerUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the maker market position in the Dolomite protocol. Contains deltaWei (balance change) and newPar (principal balance after update), each with a sign indicating positive or negative value and a numeric string value.
`in_exchangeWrapper`	`STRING`	Contract address of the exchange wrapper used to facilitate the token swap in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_makerUpdate	in_takerMarket	in_takerUpdate	block_timestamp	in_accountOwner	in_accountNumber	transaction_hash	in_exchangeWrapper
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	25	235474893	{“newPar”:{“sign”:true,“value”:“29549036282876696”},“deltaWei”:{“sign”:true,“value”:“30819625559587692”}}	5	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“106056615”}}	2024-07-24T06:46:03.000Z	0x7889a4334d7b84915808bed68db6ffeb924bb73f	22915502503770025904068094555348490688423387972734942842302800097572922539108	0xeca0b7493f0eb668f0975611c59b6609c99db275abcf532c28b84e0c6e371b34	0xd991d9e0a22a51391c25b258eef8c1c4a392383a
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	44	235580142	{“newPar”:{“sign”:true,“value”:“141217130983076153”},“deltaWei”:{“sign”:true,“value”:“147291292500582459”}}	18	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“500000001573429157”}}	2024-07-24T14:05:39.000Z	0x09fa38eba245bb68354b8950fa2fe71f02863393	61612390510868214907201826586488220425985307343751415628683162301469906587993	0x52cdc06a454f21bbc6fed9f70b4952f9df2250584441d7327544532289c72744	0x2cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	32	235466136	{“newPar”:{“sign”:true,“value”:“22873706736268971”},“deltaWei”:{“sign”:true,“value”:“23857235425435880”}}	7	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“105941532524989806330”}}	2024-07-24T06:09:27.000Z	0x299ecfdf7e0fc7181137f17ad4b18473ed995ccf	42801751572331579392507950090018340081673318631891413747995797303448620834604	0x49b6fdfbe866e86ce86309c94ecf851cc74e5184ad281aed3dc360fc814397b2	0x2cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c

Example Query

Query with partition filter

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

DolomiteMargin_LogSetEarningsRate_event

Earnings rate configuration events emitted by Dolomite Margin protocol contracts when the protocol fee rate is updated. Records the new earnings rate value applied to interest calculations for the lending 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_earningsRate`	`STRUCT<value STRING>`	Earnings rate parameter set in the protocol. Stored as a struct containing an 18-decimal fixed-point number represented as a string.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_earningsRate	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	1	45418507	2022-12-12T00:48:57.000Z	850000000000000000	0x7198b53ac4ee4c2df0bb64a7b501004c389f94564b26150c6a47b1a5e99d8498

Example Query

Query with partition filter

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

DolomiteMargin_LogSetEarningsRateOverride_event

Event logs emitted when earnings rate overrides are set for specific markets in the DolomiteMargin protocol. Contains the market identifier and the override value applied to modify default earnings rate calculations.

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_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_earningsRateOverride`	`STRUCT<value STRING>`	Custom earnings rate set for a specific market in the Dolomite protocol. Struct containing a string value representing the rate override.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DolomiteMargin_LogSetLiquidationSpread_event

Event log emitted when the liquidation spread parameter is updated in the Dolomite Margin protocol. Records the new spread value used to calculate liquidator incentives during position liquidations.

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_liquidationSpread`	`STRUCT<value STRING>`	Liquidation spread parameter for the Dolomite protocol. Struct containing a string value field representing the spread in wei, with 18 decimal precision.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DolomiteMargin_LogSetLiquidationSpreadPremium_event

Event log emitted when liquidation spread premium parameters are configured for a specific market in the Dolomite margin protocol. Records the market identifier and the new premium value applied to liquidation spreads for risk management.

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_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_liquidationSpreadPremium`	`STRUCT<value STRING>`	Liquidation spread premium parameter for a Dolomite market. String representation of the premium value in wei, where 1e18 represents 100% (e.g., ‘200000000000000000’ equals 20%).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DolomiteMargin_LogSetSpreadPremium_event

Liquidation spread premium configuration changes for Dolomite margin markets on Arbitrum, recording the premium percentages applied to each market ID during liquidations. Used for tracking risk parameter adjustments and analyzing liquidation incentive structures across different collateral types.

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_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_liquidationSpreadPremium`	`STRUCT<value STRING>`	Liquidation spread premium parameter for a Dolomite market. String representation of the premium value in wei, where 1e18 represents 100% (e.g., ‘200000000000000000’ equals 20%).

Sample Data

address	removed	log_index	in_marketId	block_number	block_timestamp	transaction_hash	in_liquidationSpreadPremium
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	23	27	155303607	2023-11-29T18:04:11.000Z	0x9c8ccf24938306f51d28aa36a9d1c2ad058715e527af89648718a3440c2c903f	400000000000000000
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	16	26	155303607	2023-11-29T18:04:11.000Z	0x9c8ccf24938306f51d28aa36a9d1c2ad058715e527af89648718a3440c2c903f	2000000000000000000
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	8	25	155303607	2023-11-29T18:04:11.000Z	0x9c8ccf24938306f51d28aa36a9d1c2ad058715e527af89648718a3440c2c903f	2000000000000000000

Example Query

Query with partition filter

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

DolomiteMargin_LogTrade_event

Trade execution events from Dolomite Margin protocol containing maker and taker account details, market identifiers, position deltas, and auto-trader addresses. Captures bilateral trades with input/output market pairs and balance updates for both counterparties.

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_takerAccountOwner`	`STRING`	Address that owns the taker account in the Dolomite protocol trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_takerAccountNumber`	`STRING`	Account identifier for the taker side of the trade in the Dolomite protocol. Numeric string that can be either a simple index (0) or a large integer representing a virtual account.
`in_makerAccountOwner`	`STRING`	Address that owns the maker account in the Dolomite protocol trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAccountNumber`	`STRING`	Account identifier for the maker side of the trade in the Dolomite protocol. Numeric string that can be either a simple index (0) or a large integer representing a virtual account.
`in_inputMarket`	`STRING`	Market identifier for the asset received by the taker in the trade. Numeric string representing the market index in the Dolomite protocol.
`in_outputMarket`	`STRING`	Market identifier for the asset sent by the taker in the trade. Numeric string representing the market index in the Dolomite protocol.
`in_takerInputUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the taker’s input position resulting from the trade. Structure contains deltaWei (signed change in Wei units) and newPar (signed new principal balance), where sign is true for positive and false for negative values, both represented as numeric strings.
`in_takerOutputUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the taker’s output position resulting from the trade. Structure contains deltaWei (signed change in Wei units) and newPar (signed new principal balance), where sign is true for positive and false for negative values, both represented as numeric strings.
`in_makerInputUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the maker’s input position resulting from the trade. Structure contains deltaWei (signed change in Wei units) and newPar (signed new principal balance), where sign is true for positive and false for negative values, both represented as numeric strings.
`in_makerOutputUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the maker’s output position resulting from the trade. Structure contains deltaWei (signed change in Wei units) and newPar (signed new principal balance), where sign is true for positive and false for negative values, both represented as numeric strings.
`in_autoTrader`	`STRING`	Contract address of the automated trading contract that executed or facilitated the trade. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_autoTrader	block_timestamp	in_outputMarket	transaction_hash	in_makerInputUpdate	in_takerInputUpdate	in_makerAccountOwner	in_makerOutputUpdate	in_takerAccountOwner	in_takerOutputUpdate	in_takerAccountNumber
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	7	50439314	0xb77a493a4950cad1b049e222d62bce14ff423c6f	2023-01-03T02:43:47.000Z	2	0xbfe890b75845d8d3f23b04cefcaaec9b0212239513b2191da7460a5f8c77bc40	{“newPar”:{“sign”:true,“value”:“468504409862956301312”},“deltaWei”:{“sign”:true,“value”:“256546414436602713”}}	{“newPar”:{“sign”:true,“value”:“83453035998402849”},“deltaWei”:{“sign”:false,“value”:“256546414436602713”}}	0xb77a493a4950cad1b049e222d62bce14ff423c6f	{“newPar”:{“sign”:true,“value”:“567606631298”},“deltaWei”:{“sign”:false,“value”:“310052383”}}	0x73c95b3d3f78000699cacab90fe59af12ee2c542	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“310052383”}}	100036664860478834360034067759389768186578538004104136683019453783299521127311
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	9	50580693	0xb77a493a4950cad1b049e222d62bce14ff423c6f	2023-01-03T16:07:12.000Z	2	0xaa0f0b3a51c0db940bfd4becd55ca7c16376d7a9a5a62274a906e27eaff7d5b8	{“newPar”:{“sign”:true,“value”:“467882979399076176776”},“deltaWei”:{“sign”:true,“value”:“248407475891701”}}	{“newPar”:{“sign”:true,“value”:“252186191246181”},“deltaWei”:{“sign”:false,“value”:“248407475891701”}}	0xb77a493a4950cad1b049e222d62bce14ff423c6f	{“newPar”:{“sign”:true,“value”:“566755467495”},“deltaWei”:{“sign”:false,“value”:“300000”}}	0x8b4e6fc5ec524a227a62e99eeb12133b05cdd658	{“newPar”:{“sign”:true,“value”:“299996”},“deltaWei”:{“sign”:true,“value”:“300000”}}	0
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	7	50461315	0xb77a493a4950cad1b049e222d62bce14ff423c6f	2023-01-03T05:13:52.000Z	2	0x2553ee9ba177c675aefcd39701b97c12805246fd74f182f3c8571f4847efcc70	{“newPar”:{“sign”:true,“value”:“468587689665086387241”},“deltaWei”:{“sign”:true,“value”:“440000000000000”}}	{“newPar”:{“sign”:true,“value”:“559996120055067”},“deltaWei”:{“sign”:false,“value”:“440000000000000”}}	0xb77a493a4950cad1b049e222d62bce14ff423c6f	{“newPar”:{“sign”:true,“value”:“567606099924”},“deltaWei”:{“sign”:false,“value”:“531381”}}	0xd532bd6c3f912d61656f08fe189cac2268da8db6	{“newPar”:{“sign”:true,“value”:“531374”},“deltaWei”:{“sign”:true,“value”:“531381”}}	0

Example Query

Query with partition filter

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

DolomiteMargin_LogTransfer_event

Transfer events from Dolomite Margin protocol recording balance changes between two accounts within a specified market. Contains account identifiers, market ID, and balance updates (deltaWei and newPar) for both accounts involved in the transfer.

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_accountOneOwner`	`STRING`	Owner address for the first account in a transfer operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountOneNumber`	`STRING`	Account identifier for the first account in a transfer operation. Numeric string that can represent either a simple account number (e.g., ‘0’) or a large integer identifier.
`in_accountTwoOwner`	`STRING`	Owner address for the second account in a transfer operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountTwoNumber`	`STRING`	Account identifier for the second account in a transfer operation. Numeric string that can represent either a simple account number (e.g., ‘0’) or a large integer identifier.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_updateOne`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Account balance update for the first account in the transfer, containing the change in Wei balance (deltaWei) and the new principal balance (newPar). Each balance component includes a boolean sign indicator (true for positive, false for negative) and a numeric string value.
`in_updateTwo`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Account balance update for the second account in the transfer, containing the change in Wei balance (deltaWei) and the new principal balance (newPar). Each balance component includes a boolean sign indicator (true for positive, false for negative) and a numeric string value.

Sample Data

address	removed	log_index	block_number	in_updateOne	in_updateTwo	block_timestamp	transaction_hash	in_accountOneOwner	in_accountTwoOwner	in_accountOneNumber
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	33	287268076	{“newPar”:{“sign”:false,“value”:“54142124639705318”},“deltaWei”:{“sign”:false,“value”:“60000000000000000”}}	{“newPar”:{“sign”:true,“value”:“56782531376559091”},“deltaWei”:{“sign”:true,“value”:“60000000000000000”}}	2024-12-22T01:42:42.000Z	0x3219081c55df6c16ca61b8fb8f997a5ff82388643ba6c862402b5630fc98de47	0x00908a54988f2db52436351ac8188cf68bf92fec	0x00908a54988f2db52436351ac8188cf68bf92fec	12562511162665904084083977492640863593297497592780609681133138287464432983761
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	7	287271104	{“newPar”:{“sign”:false,“value”:“99260534130616993”},“deltaWei”:{“sign”:false,“value”:“50000000000000000”}}	{“newPar”:{“sign”:true,“value”:“47318769084190911”},“deltaWei”:{“sign”:true,“value”:“50000000000000000”}}	2024-12-22T01:55:24.000Z	0xbd93223c4ca40ce472ebf74e25168a0eff37e4e0fa87bcfb2c8092f3634830bb	0x00908a54988f2db52436351ac8188cf68bf92fec	0x00908a54988f2db52436351ac8188cf68bf92fec	12562511162665904084083977492640863593297497592780609681133138287464432983761
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	12	287426288	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“110003491502198673”}}	{“newPar”:{“sign”:true,“value”:“943064314717362”},“deltaWei”:{“sign”:false,“value”:“110003491502198673”}}	2024-12-22T12:43:42.000Z	0x5cf2599fe37058871719f793beed03bb3612388556ef418aa241b927b6698f69	0x00908a54988f2db52436351ac8188cf68bf92fec	0x00908a54988f2db52436351ac8188cf68bf92fec	12562511162665904084083977492640863593297497592780609681133138287464432983761

Example Query

Query with partition filter

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

DolomiteMargin_LogVaporize_event

Vaporization events from the Dolomite margin protocol recording debt elimination from undercollateralized accounts. Contains liquidator and vaporized account identifiers, market IDs for collateral and debt assets, and balance updates (deltaWei and newPar) for both positions.

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_solidAccountOwner`	`STRING`	Account address of the entity performing the liquidation or vaporization in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_solidAccountNumber`	`STRING`	Account number identifying the liquidator’s position in the Dolomite protocol. String-encoded numeric value, with 0 representing the default account and larger values representing isolated sub-accounts.
`in_vaporAccountOwner`	`STRING`	Account address of the entity whose position is being vaporized in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_vaporAccountNumber`	`STRING`	Account number identifying the vaporized position in the Dolomite protocol. String-encoded numeric value representing the sub-account being liquidated through vaporization.
`in_heldMarket`	`STRING`	Market identifier for the collateral asset held by the account. String-encoded numeric value representing the market ID in the Dolomite protocol.
`in_owedMarket`	`STRING`	Market identifier for the debt asset owed by the account. String-encoded numeric value representing the market ID in the Dolomite protocol.
`in_solidHeldUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidator’s collateral position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).
`in_solidOwedUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the liquidator’s debt position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).
`in_vaporOwedUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the vaporized account’s debt position in the Dolomite protocol. Structured as deltaWei (change in balance with sign and string value) and newPar (new principal balance with sign and string value).

Sample Data

address	removed	log_index	block_number	in_owedMarket	block_timestamp	transaction_hash	in_solidHeldUpdate	in_solidOwedUpdate	in_vaporOwedUpdate	in_solidAccountOwner	in_vaporAccountOwner	in_vaporAccountNumber
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	27	168056090	2	2024-01-07T16:02:43.000Z	0x8a6ca9df1989f6204f5b8b99ef39f7ed460b54c12b8ee0dd9355c3cd1536e764	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:true,“value”:“5”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“10090”}}	0x52256ef863a713ef349ae6e97a7e8f35785145de	0xb8fd61993b7e95ef57d7ae0ae62bee03b9eee760	106876258068914935116567023597389640643402496213994320244959369035096116678266
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	27	168056330	2	2024-01-07T16:03:44.000Z	0x623cca18e7e5abefb62c248e03e468c76b6529f17ba49db11c858bdd4f291247	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:true,“value”:“5”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“57704”}}	0x52256ef863a713ef349ae6e97a7e8f35785145de	0xa5e1bac0ee7b3afe9bfa1ea11e3cc141f72cff38	38971613263643293981477018390815334982484437980556590705552548380676179035616
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	27	168056192	7	2024-01-07T16:03:10.000Z	0xa72ff96818c898acceb036989fbc5112c0843d016f9bc53cc60e21771f1a66f7	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:true,“value”:“69646644813732842”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:false,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“5387179217278969782”}}	0x52256ef863a713ef349ae6e97a7e8f35785145de	0xb506c02f6b5b84e630e21b56347f2ec1a293b29f	62905638187777776648800951888947211282478833858377094316155105920963727233124

Example Query

Query with partition filter

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

DolomiteMargin_LogWithdraw_event

Withdrawal events from Dolomite margin protocol accounts tracking asset removals with account owner, market identifier, recipient address, and balance updates. Balance changes include both the Wei-denominated delta and resulting principal amount with sign indicators for position direction.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_update`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Account balance update containing the change in Wei (deltaWei) and the new principal balance (newPar). Each component includes a boolean sign indicator and a numeric string value representing the amount.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_update	log_index	block_number	block_timestamp	in_accountOwner	transaction_hash
0xadb9d68c613df4aa363b42161e1282117c7b9594	0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“481625072341022341”}}	4	48822483	2022-12-25T18:41:17.000Z	0xc76466556b8e2f5f5d933e4a39f80885f7362cd7	0xff1245f5098e3abe7f7a707a30a064036e5dd8e4a7ce7b573353079c8f37deb6
0xadb9d68c613df4aa363b42161e1282117c7b9594	0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“401406846892005561”}}	4	48807136	2022-12-25T17:19:08.000Z	0xb8281a7caf09bb7a74c6db3c188f1aa4d528ab6f	0x4e60000bae6c7eb30fa5d8b07b80c6674b29c19b92505ca6eb7d249652752b3f
0xadb9d68c613df4aa363b42161e1282117c7b9594	0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“700000493691862798”}}	4	48725053	2022-12-25T10:26:30.000Z	0x37802de6e0a8b253d70a30e48b912e7baf7a6f57	0x86f2793547f5c3f1a170abf5d03a4c2e0c5f554fe08ee0a93c027ca087c103f4

Example Query

Query with partition filter

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

DolomiteMargin_LogWithdrawExcessTokens_event

Event log recording excess token withdrawals from Dolomite Margin protocol contracts. Contains the withdrawn token address and amount, enabling tracking of protocol surplus token removals and treasury management operations.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	2790248010511879262675	95	324301993	2025-04-08T18:36:40.000Z	0xa3601f8667e4b5eb39c996cfbab7c768c538ecd32b64f919cd00701bbafb103c
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	49826062215	74	324301993	2025-04-08T18:36:40.000Z	0xa3601f8667e4b5eb39c996cfbab7c768c538ecd32b64f919cd00701bbafb103c
0x6bd780e7fdf01d77e4d475c821f1e7ae05409072	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	13568303235	23	324301993	2025-04-08T18:36:40.000Z	0xa3601f8667e4b5eb39c996cfbab7c768c538ecd32b64f919cd00701bbafb103c

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositCancelled_event

Cancelled asynchronous deposit events from Dolomite v1 protocol on Arbitrum, tracking failed or user-cancelled deposit operations with deposit keys and token addresses. Used for monitoring deposit flow interruptions and analyzing user cancellation 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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0xa98b838f8ec672e15935662e84f83ef315a13cdb97a0d7c51a58522ec350c9ef	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	45	216386039	2024-05-29T22:04:53.000Z	0x8568730c7987ac974b61c30062311f97c14224f6d57c01569e843adcda678c64
0x11f38ac68327d4e4a525b4d4fc0612dc67d567af49a4c8a18eea4c6bc4d8e058	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	51	216251578	2024-05-29T12:43:53.000Z	0xe3e6ff32c8de6329474c0d5cd665dc89cdc2610f54c2fe039a72f58eb8b24e7f
0x3e6acd8c5288b405c2635d0340cd176d12aa96c96c8802d0f011894fe1b2f2ad	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x2c799166c9f0dbf9efc5004cbce4c5a37fa39329	35	216278073	2024-05-29T14:34:46.000Z	0x621e5d474b6e5a58d1f0e5dccb5a602c0e317db7c5210331d36747381c500912

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositCancelledFailed_event

Failed asynchronous deposit cancellation events from Dolomite V1 protocol on Arbitrum. Records deposit operations that encountered errors during cancellation, including the deposit key, token address, and failure reason for troubleshooting failed transactions.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reason`	`STRING`	Enumerated code indicating the cause or category of the operation or state change. Non-negative integer value representing different reason types defined by the protocol.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x8369ab5b9e3f29d439a23876ccb5ae44b738ffce9a51c1a2df3da19eb06bcf65	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x2c799166c9f0dbf9efc5004cbce4c5a37fa39329	6	198562238	2024-04-07T14:45:35.000Z	0x5b9ebdff2d54b17625aa72e45b02e33c9a7deee694c9f05490f31b38c45b42fb
0xe86f33c7c852812dabfd5c442c9f9fe99461eda40b038787d89961a3c60fd73d	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x2c799166c9f0dbf9efc5004cbce4c5a37fa39329	6	198562470	2024-04-07T14:46:34.000Z	0x215b550323fefae17b5a7ab9142884e23b1138d71b18067c4239ca6861f57157
0xc6e8e63e4adcad30c4b5c83e9a9ee456e86e19a1da38352e5597ab57ef8d0f54	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x2c799166c9f0dbf9efc5004cbce4c5a37fa39329	8	198580774	2024-04-07T16:02:52.000Z	0x8b54d1e9fa69e510b59016c4a9a8a950f6742f0ec8a1a840cb8517e2371c319e

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositCreated_event

Asynchronous deposit creation events from Dolomite v1 protocol on Arbitrum, capturing vault deposits with input/output token amounts and unique deposit keys. Used for tracking cross-asset deposit conversions and vault funding activity.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_deposit`	`STRUCT<key STRING, vault STRING, accountNumber STRING, inputToken STRING, inputAmount STRING, outputAmount STRING, isRetryable BOOL>`	Nested record containing the complete deposit operation details for this async deposit event. Includes vault address, input/output token addresses and amounts, unique key identifier, account number, and retry flag.

Sample Data

in_key	address	removed	in_token	log_index	in_deposit	block_number	block_timestamp	transaction_hash
0x0f6f87c0975e6faae799cf6e96111fde2f455fc6f979e046deaaa96e546e736a	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	47	{“key”:“0x0f6f87c0975e6faae799cf6e96111fde2f455fc6f979e046deaaa96e546e736a”,“vault”:“0x79fcda7a02d1f91a9b80bfceb8904885ae465674”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“1269255”,“isRetryable”:false,“outputAmount”:“764111874006350641”,“accountNumber”:“0”}	197823351	2024-04-05T11:14:59.000Z	0x5543efea96afb5cb3ebe122513611f9f92417ea98ac4db5f5fbf5224f8abba4a
0x78b69fe49c5c63edf1ba7a04e35e01bbceb041a8c00059a6e1bb98ef8f9c0116	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	40	{“key”:“0x78b69fe49c5c63edf1ba7a04e35e01bbceb041a8c00059a6e1bb98ef8f9c0116”,“vault”:“0x0770b25ab53d9835a4e99df2e8ea150eecd4a65e”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“1213102”,“isRetryable”:false,“outputAmount”:“725433435079278588”,“accountNumber”:“0”}	197750617	2024-04-05T06:11:28.000Z	0x54fbace37b8b65f8c0e0907f4778bd929bbe01d2e6b38cca8d5b08b1c5bca87f
0x15abc02a0950f4f9fe7f339296e87e67bf205874625d047cf66b2538175b6b89	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	86	{“key”:“0x15abc02a0950f4f9fe7f339296e87e67bf205874625d047cf66b2538175b6b89”,“vault”:“0xd39c3618dc4319d165a156748f64ff466a7875cf”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“1000063”,“isRetryable”:false,“outputAmount”:“595759545949686097”,“accountNumber”:“0”}	197875414	2024-04-05T14:52:24.000Z	0x37c1299d1b2d123244afd69caff69f4af4d510705938326cc4ba7706a8cba208

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositExecuted_event

Async deposit execution events from Dolomite v1 protocol on Arbitrum, tracking when asynchronous deposit operations complete with unique deposit keys and token addresses. Used for monitoring cross-contract deposit flows and reconciling multi-step deposit transactions.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0xe893bf58f6a05aa0540ac25f2a600f10e6143a65fc3a4f831066a38c53ac2263	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	90	200102786	2024-04-12T02:20:08.000Z	0x5d594b277d0ecdd3afd24e885fc7879dc7333bab2623635fe4c625c464383d35
0xca289b21cf2dcce44ff77022bc626b24ff430785eb52c5fa1f698fc16118817c	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	69	200142135	2024-04-12T05:05:11.000Z	0xe30374587d0c672ee77500cbbdb666fbade3563278f32621a3139d089e19879c
0x6e6b16022a864a1a7e942d98006fc6468c403f3ad64993e8ebfd812359e11f78	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	46	200142503	2024-04-12T05:06:43.000Z	0x5dc4527f3d1ee1805515f2c5146a552d12e527f828f2a614336a89d16b4f28be

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositFailed_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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reason`	`STRING`	Enumerated code indicating the cause or category of the operation or state change. Non-negative integer value representing different reason types defined by the protocol.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncDepositOutputAmountUpdated_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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncWithdrawalCancelled_event

Cancelled asynchronous withdrawal events from Dolomite protocol on Arbitrum, tracking user-initiated withdrawal cancellations with unique withdrawal identifiers and token addresses. Useful for analyzing withdrawal behavior patterns and protocol liquidity management.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x169208701d8c96d213102ffc48f291684aad675d6a18a0dd0bf79510631507ee	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	19	280647258	2024-12-02T18:18:14.000Z	0xe4737af73d4014a34e36b92475f985ae9b9b3f7eb1666fb7a54d26f15ad0f2d7
0x151e4c881782dc50729a47aa4a2a0166ad941207832129209508f4b7b5151dea	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	18	280614137	2024-12-02T15:59:19.000Z	0xaeebd01b30dc8094a5c8cbc5770ce6657a7a4eb5d8d11e2def6cd88da2d30477
0xe63c31fa266e913f376db23705481719b746868beff67d715694b316c0f884fd	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	33	280496871	2024-12-02T07:46:24.000Z	0xac16db72ca3726c1624620428ae4847595d2b1f29b4c197a978dacaa8aed9229

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncWithdrawalCreated_event

Asynchronous withdrawal requests created on Dolomite v1 protocol on Arbitrum, tracking vault withdrawals with input tokens, output tokens, amounts, and execution parameters. Used for analyzing cross-asset withdrawal patterns and protocol liquidity flows.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawal`	`STRUCT<key STRING, vault STRING, accountNumber STRING, inputAmount STRING, outputToken STRING, outputAmount STRING, isRetryable BOOL, isLiquidation BOOL, extraData STRING>`	Nested record containing the full withdrawal request details including input/output tokens, amounts, vault address, and account information. Populated for each AsyncWithdrawalCreated event on Dolomite v1 protocol.

Sample Data

in_key	address	removed	in_token	log_index	block_number	in_withdrawal	block_timestamp	transaction_hash
0x39cd96e49ea0fcb4f6ecee810e8b51a618bbc015fa5d37c87ce8ea499637c5ae	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	11	228378331	{“key”:“0x39cd96e49ea0fcb4f6ecee810e8b51a618bbc015fa5d37c87ce8ea499637c5ae”,“vault”:“0x66ee72bf3e00d9a285431736b359fbdfb45b3d4e”,“extraData”:“0x0000000000000000000000000000000000000000000000000724dd7f9ca654c800000000000000000000000000000000000000000000000000000000188e2476”,“inputAmount”:“496476062025817139318”,“isRetryable”:false,“outputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“outputAmount”:“803036659”,“accountNumber”:“54076474303824601452235742064867467441076616048029936658255918624530999131528”,“isLiquidation”:false}	2024-07-03T16:07:15.000Z	0xbdc9e6f26b93c45f388c443af4ad6b1430a1e0eb9c6d53cc2008ce47c92c81b1
0x2523ef8ab7e61d9b4471ced072730f5b85b49e519d7c172efc537ef235e5ccba	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0xb15bbbfcff6c411410c66642306d1ffa7ecec4d8	10	289614486	{“key”:“0x2523ef8ab7e61d9b4471ced072730f5b85b49e519d7c172efc537ef235e5ccba”,“vault”:“0x8f0e004a66120b32e8157831be1c07c28c368ddd”,“extraData”:“0x00000000000000000000000000000000000000000000000006f05b59d3b2000000000000000000000000000000000000000000000000000000000000000b4fee”,“inputAmount”:“1000000000000000000000”,“isRetryable”:false,“outputToken”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“outputAmount”:“1482717”,“accountNumber”:“0”,“isLiquidation”:false}	2024-12-28T21:12:49.000Z	0x4c50f7aeb9159c10443e3d2ba522745e76fe3374a3edf311535bbdaa7fff6d11
0x3c195a3c263c7bbbe1d1918b1a4982400cb5398f1d7ec8cb62cd08f5e9f44364	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0xb15bbbfcff6c411410c66642306d1ffa7ecec4d8	17	289616908	{“key”:“0x3c195a3c263c7bbbe1d1918b1a4982400cb5398f1d7ec8cb62cd08f5e9f44364”,“vault”:“0x8f0e004a66120b32e8157831be1c07c28c368ddd”,“extraData”:“0x00000000000000000000000000000000000000000000000006f05b59d3b200000000000000000000000000000000000000000000000000000000000000125d61”,“inputAmount”:“1623399678654498228606”,“isRetryable”:false,“outputToken”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“outputAmount”:“2407107”,“accountNumber”:“0”,“isLiquidation”:false}	2024-12-28T21:23:04.000Z	0xe11f47efae97ac7619c9d1138377289f705bca7f0743e09cfc0ce8196f5ad703

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncWithdrawalExecuted_event

Completed asynchronous withdrawal events from Dolomite v1 protocol on Arbitrum, tracking when delayed withdrawal requests are executed with unique identifiers and token addresses. Used for monitoring withdrawal processing times and analyzing liquidity flow patterns across different token markets.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x2d4f0b1c89a064842a11a52646fbcdcaab853b8c9cd8e713f70de4321964eff8	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	78	222926816	2024-06-17T21:07:52.000Z	0xd884a2c78a9b9e1cb34004c028c5deb39888469e0d725fc737576e841382ed81
0x1969d036973041a5d16533dd0f2dfa30eadfec421a49ba545d4638e9d2691f46	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	56	222905043	2024-06-17T19:36:29.000Z	0x7e9556cfb7d15d3f7a3321d72ddd429ae806325b53da8753c3aa1f69a07fd550
0x270ed199e8331e6cfd5aceaf01c7b4a7afab5d408c4847047658e5b404e38ad1	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x1e8e8b7a2f827b3bc12b00ee402145061b7050ef	58	222823995	2024-06-17T13:56:44.000Z	0xfd4be82d0790238bb48663dc16d48f5be73dab5dd9a12ffd57930bdd1a0a3c02

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncWithdrawalFailed_event

Failed asynchronous withdrawal events from Dolomite v1 protocol on Arbitrum, capturing withdrawal attempts that failed with error reasons and associated token addresses. Useful for monitoring withdrawal system health and identifying common failure patterns like slippage violations.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reason`	`STRING`	Enumerated code indicating the cause or category of the operation or state change. Non-negative integer value representing different reason types defined by the protocol.

Sample Data

in_key	address	removed	in_token	in_reason	block_number	block_timestamp	transaction_hash
0xd15e32608c12165dc3d687d0a0a39b2ba387762fc743462d9ec1c04dc02b2104	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	GenericTraderProxyBase: Invalid minOutputAmountWei	221093890	2024-06-12T13:46:48.000Z	0x70ea79604e69aaa5ea6073512839db12fd34f11cb839b4c283d9bda49e361aa0
0xd15e32608c12165dc3d687d0a0a39b2ba387762fc743462d9ec1c04dc02b2104	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	GenericTraderProxyBase: Invalid minOutputAmountWei	221054138	2024-06-12T11:00:34.000Z	0x54a41e6fd3d66861e6915e01551ead2e543b518777c6ef649f469714db8140ce
0xd15e32608c12165dc3d687d0a0a39b2ba387762fc743462d9ec1c04dc02b2104	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	GenericTraderProxyBase: Invalid minOutputAmountWei	221149715	2024-06-12T17:39:23.000Z	0x6dab89807e1e3120894dde579a2004abdec62b22fac12ad36d9092d6b0144e23

Example Query

Query with partition filter

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

EventEmitterRegistry_AsyncWithdrawalOutputAmountUpdated_event

Asynchronous withdrawal output amount updates from Dolomite protocol on Arbitrum, tracking final token amounts received for withdrawal requests. Used to analyze withdrawal execution prices and slippage between initiation and completion.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_key	address	removed	in_token	log_index	block_number	block_timestamp	in_outputAmount	transaction_hash
0x4f74dfc9eb8deab7bab37946ada07736dd30eda3aa3d02f2f271f27d01e2b7a5	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x2c799166c9f0dbf9efc5004cbce4c5a37fa39329	41	238176357	2024-08-01T03:02:00.000Z	2845853914585704678	0xa379e072d558abbe466fd8d8f27fa90d9d5f905917868fefcefc9b9a98017c59
0x573d0223566baa3de70b3476ca740651f73f35b07e21c51f37ad091a76c6807f	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	3	256241484	2024-09-22T17:22:24.000Z	1466145	0x6db317bb778f2a33cbc2aca827abce64647dddd157f1d3ab84b6dfc99d893c1b
0x573d0223566baa3de70b3476ca740651f73f35b07e21c51f37ad091a76c6807f	0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	0x18cb14564fbb015bd3439220d177799355abc0e0	35	256241436	2024-09-22T17:22:12.000Z	1466145	0xa6a795d9da2b14427284de849f3b5ccffc74c2afc59fe7e37d6dcc84aa724254

Example Query

Query with partition filter

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

EventEmitterRegistry_BorrowPositionOpen_event

Borrow position creation events from Dolomite V1 margin protocol on Arbitrum, tracking when users open leveraged positions with borrower addresses and account numbers. Used for analyzing borrowing activity, position lifecycle tracking, and identifying active margin traders.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAccountNumber`	`STRING`	Account number identifier for the borrowing position within Dolomite’s margin trading system. Numeric string that can be 0 for primary accounts or higher values (100000+) for isolated sub-accounts.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	transaction_hash	in_borrowAccountNumber
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	2	0xfd5b0928bb188f87c04d82a9cee6a9987e6252a1	275291727	2024-11-17T04:14:18.000Z	0xab379263e4104bbd021212c89430baef3c8d4475727a54503616dfd0142d7155	100000
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	23	0x2e8fba7125cfad75b8bc750832b06acae9729b16	275254521	2024-11-17T01:38:25.000Z	0xdc2db226bdbe0b94c84a837d91048abf623e226c8387b73bc2b396aa1eec41dd	100089
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	25	0xe81fd4d869da37282223f703486657b783e91605	193019787	2024-03-22T12:17:33.000Z	0x4ce260fa4c83496e86fca729b50dfd290145ad4f30c1e123e61f84f09a809057	0

Example Query

Query with partition filter

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

EventEmitterRegistry_DistributorRegistered_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_oTokenAddress`	`STRING`	-
`in_pairToken`	`STRING`	-
`in_paymentToken`	`STRING`	Contract address of the token used for payment in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

EventEmitterRegistry_MarginPositionClose_event

Margin position closure events from Dolomite v1 protocol on Arbitrum, capturing token swaps and withdrawals when users close leveraged positions. Contains input/output token addresses, balance deltas, and withdrawal amounts for analyzing deleverage activity and position unwinds.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawalToken`	`STRING`	Contract address of the token being withdrawn from the margin position. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token on Arbitrum.
`in_inputBalanceUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance change details for the input token being supplied to close the margin position. Contains the change in token amount (deltaWei) and the resulting balance (newPar) with directional sign indicators.
`in_outputBalanceUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance change details for the output token position after closing the margin trade. Contains the new balance (newPar) and the delta amount (deltaWei) with their respective signs indicating positive or negative values.
`in_marginWithdrawalUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance update for the withdrawal token being removed from the margin position, including the delta (change amount) and new par value after the close operation. Structured as a record with sign and value fields for both deltaWei and newPar components.

Sample Data

address	removed	log_index	block_number	in_inputToken	in_outputToken	block_timestamp	in_accountOwner	in_accountNumber	transaction_hash	in_withdrawalToken	in_inputBalanceUpdate	in_outputBalanceUpdate	in_marginWithdrawalUpdate
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	35	225835962	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x912ce59144191c1204e64559fe8253a0e49e6548	2024-06-26T07:16:07.000Z	0x186b4e576e34974c776ab8048970aefd9c71468e	0	0xe7baf5ac3ebd8f7d55fe68446c33a0a121dc1b121d6d3216f24b2121fb3e8020	0x912ce59144191c1204e64559fe8253a0e49e6548	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“18600562536933757”}}	{“newPar”:{“sign”:true,“value”:“309839329831898262”},“deltaWei”:{“sign”:true,“value”:“0”}}	{“newPar”:{“sign”:true,“value”:“309839329831898262”},“deltaWei”:{“sign”:true,“value”:“0”}}
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	39	228218259	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	2024-07-03T04:57:28.000Z	0x186b4e576e34974c776ab8048970aefd9c71468e	81522404985538452547573247393214139077021095138389258433323485546776872143334	0x5b475e8abd3c2dcfb489775275dd0fbbcac02d8f2ac3508fad2570f76f41eaec	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:false,“value”:“3991315388196338”}}	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“719127113075372827”}}	{“newPar”:{“sign”:true,“value”:“0”},“deltaWei”:{“sign”:true,“value”:“719127113075372827”}}

Example Query

Query with partition filter

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

EventEmitterRegistry_MarginPositionOpen_event

Margin position opening events from Dolomite v1 protocol on Arbitrum, recording when users open leveraged positions by depositing collateral and borrowing assets. Tracks account details, token pairs (input/output tokens), balance changes, and margin deposit updates for analyzing leverage trading activity.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositToken`	`STRING`	Contract address of the token being deposited into the reward pool or margin position. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputBalanceUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance change details for the input token being traded. Contains the new position amount (newPar) and the change amount (deltaWei), both with sign indicators showing positive or negative values.
`in_outputBalanceUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance change of the output token in the margin position, including the new principal (Par) and delta in Wei. Structured record containing sign indicators and large integer values representing token amounts.
`in_marginDepositUpdate`	`STRUCT<deltaWei STRUCT<sign BOOL, value STRING>, newPar STRUCT<sign BOOL, value STRING>>`	Balance change of the deposited collateral token for this margin position. Nested structure containing the new principal amount (newPar) and delta in Wei (deltaWei), with sign indicating positive (true) or negative (false) balance movement.

Sample Data

address	removed	log_index	block_number	in_inputToken	in_outputToken	block_timestamp	in_accountOwner	in_depositToken	in_accountNumber	transaction_hash	in_inputBalanceUpdate	in_marginDepositUpdate	in_outputBalanceUpdate
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	35	214391841	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2024-05-24T01:41:36.000Z	0x186b4e576e34974c776ab8048970aefd9c71468e	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	46617519933583559882001672882979059002621578863896201104189923471582749265660	0xa984e9d5684b69333d6d9597741d63954d36eefb81ab3ef54f5d21de844a5ba6	{“newPar”:{“sign”:false,“value”:“218424873219063037”},“deltaWei”:{“sign”:false,“value”:“224984205051226686”}}	{“newPar”:{“sign”:true,“value”:“1936072891613194”},“deltaWei”:{“sign”:true,“value”:“1998628233242531”}}	{“newPar”:{“sign”:true,“value”:“1936072891613194”},“deltaWei”:{“sign”:true,“value”:“1998628233242531”}}
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	45	223743789	0x912ce59144191c1204e64559fe8253a0e49e6548	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2024-06-20T06:01:17.000Z	0x186b4e576e34974c776ab8048970aefd9c71468e	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	94906611790831570792784580318987263526490522185249817028830774744034923825664	0x4088379793c0d59aaea0ba9372e6e54f0661b1ff762f5b93fc710389f41b7757	{“newPar”:{“sign”:false,“value”:“16874546668004100147”},“deltaWei”:{“sign”:false,“value”:“17326028942234136832”}}	{“newPar”:{“sign”:true,“value”:“4806920907288766”},“deltaWei”:{“sign”:true,“value”:“4998061332112089”}}	{“newPar”:{“sign”:true,“value”:“4806920907288766”},“deltaWei”:{“sign”:true,“value”:“4998061332112089”}}
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	50	225793465	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2024-06-26T04:19:02.000Z	0x186b4e576e34974c776ab8048970aefd9c71468e	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	81522404985538452547573247393214139077021095138389258433323485546776872143334	0x206634afb8b73909af1f196486f151bb7f2bde5f996caecc82a72f5e8dfaae99	{“newPar”:{“sign”:false,“value”:“694225825949299467”},“deltaWei”:{“sign”:false,“value”:“718642480993819437”}}	{“newPar”:{“sign”:true,“value”:“3830262745902267”},“deltaWei”:{“sign”:true,“value”:“3988776386829017”}}	{“newPar”:{“sign”:true,“value”:“3830262745902267”},“deltaWei”:{“sign”:true,“value”:“3988776386829017”}}

Example Query

Query with partition filter

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

EventEmitterRegistry_RewardClaimed_event

Reward claim events from Dolomite protocol on Arbitrum, tracking user reward distributions by epoch and distributor contract. Used for analyzing incentive program participation and reward distribution patterns across protocol epochs.

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_distributor`	`STRING`	Address of the distributor contract responsible for managing the token distribution or reward allocation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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	in_user	removed	in_epoch	in_amount	log_index	block_number	in_distributor	block_timestamp	transaction_hash
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	0x18b0046ef6ee3fd03ba91a190e37e7ae72b89d8b	false	2	1796909000927131928710	50	209868663	0x2e3d10cc42227af0ce908f00c76ffe1de1728b4b	2024-05-10T16:51:21.000Z	0x0735a8fd33c77c5318c7de9e89cadb1cf1f1e4d5aac4853cc36e05372fb65fd4
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	0x4d35dd2e1c7673bf08de47e1a46f3d05a9e7ceeb	false	2	10412089750720015588000	18	209926443	0x2e3d10cc42227af0ce908f00c76ffe1de1728b4b	2024-05-10T20:53:48.000Z	0x074be17fad5ea9c34744c85eae8c34e21641e87b4fea8e82a41cd61cb87ea8de
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	0xd6b9608036f292d218ba6cdc11f3ee4a0cbb1b88	false	2	25036656104563255904308	0	209931753	0x2e3d10cc42227af0ce908f00c76ffe1de1728b4b	2024-05-10T21:16:16.000Z	0x0cf9b32973e6b3f58567672f378181af39f9e1b0f151f7e2def317c370f617d0

Example Query

Query with partition filter

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

EventEmitterRegistry_ZapExecuted_event

Zap execution records from Dolomite protocol on Arbitrum tracking multi-step token swaps through their EventEmitterRegistry contract. Contains swap routes (marketIdsPath), trader addresses, execution parameters, and encoded trade data for analyzing cross-market arbitrage and liquidity aggregation activity.

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_accountOwner`	`STRING`	Owner address of the account in the Dolomite protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountNumber`	`STRING`	Account identifier associated with the owner’s position in the Dolomite protocol. Numeric string representing a unique sub-account within the user’s address space.
`in_marketIdsPath`	`ARRAY<STRING>`	Array of market IDs representing the token swap path through Dolomite’s markets. Each element is a numeric market identifier (as string) showing the sequence of markets traversed during the zap execution.
`in_tradersPath`	`ARRAY<STRUCT<traderType INT64, makerAccountIndex STRING, trader STRING, tradeData STRING>>`	Nested structure containing trader addresses and encoded trade execution parameters for each step in the multi-hop swap path. Each trader entry includes the trader contract address, trade-specific calldata, trader type identifier, and maker account index for the transaction.

Sample Data

address	removed	log_index	block_number	in_tradersPath	block_timestamp	in_accountOwner	in_accountNumber	in_marketIdsPath	transaction_hash
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	60	234969370	[{“trader”:“0xd991d9e0a22a51391c25b258eef8c1c4a392383a”,“tradeData”:“0x54e3f31b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000460000000000000000000000000000000000000000000000000000000000000002000000000000000000000000082af49447d8a07e3bd95bd0d56f35241523fbab1000000000000000000000000ec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8000000000000000000000000000000000000000000000000002386f26fc100000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000001fba14f03edcf400000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000220000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000003e0000000000000000000000000d991d9e0a22a51391c25b258eef8c1c4a392383a000000000000000000000000a75c21c5be284122a87a37a76cc6c4dd3e55a1d40100000000000000000000000000000000000000000000000000000000031388000000000000000000000000000000000000000000000000000000000000042000000000000000000000000000000000000000000000000000000000669f073fdfa1b1c1ba474c779d3cdd051744283c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001b81d678ffb9c0263b24a97847620c99d213eb140000000000000000000000000000000000000000000000000000000000000124c04b8d59000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee570000000000000000000000000000000000000000000000000000000066a7ed5f000000000000000000000000000000000000000000000000002386f26fc100000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002b82af49447d8a07e3bd95bd0d56f35241523fbab1000064ec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000124000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“traderType”:0,“makerAccountIndex”:“0”}]	2024-07-22T19:28:59.000Z	0x0442dd88a482833fe2ca98a6b66526aa640321f3	53701764009024545329140105184117612691277478483204747436160224852916726906934	[“0”,“15”]	0xc0e82f15e53b9813dc884533122e08c4f40ac9d15dd24fa329b4b56677e26ad4
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	26	234969564	[{“trader”:“0x2cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c”,“tradeData”:“0x00000000000000000000000082af49447d8a07e3bd95bd0d56f35241523fbab1000000000000000000000000000000000000000000000000002386f26fc100000000000000000000000000009b99e9c620b2e2f09e0b9fced8f679eecf2653fe0000000000000000000000005979d7b546e38e414f7e9822514be443a4800529000000000000000000000000000000000000000000000000001e4723259a443e000000000000000000000000000000000000000000000000001e2061b0ef41570000000000000000000000002cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c00000000000000000000000000000000000000000000000000000000000001400000000000000000000000009b99e9c620b2e2f09e0b9fced8f679eecf2653fe000000000000000000000000000000000000000000000000000000003f76e5e60000000000000000000000000000000000000000000000000000000000000068020203000701010102fb5e6d0c1dfed2ba000fbc040ab8df3615ac329c000000000000000000000159ff0000000000000000000000000000000000000000000082af49447d8a07e3bd95bd0d56f35241523fbab15979d7b546e38e414f7e9822514be443a4800529000000000000000000000000000000000000000000000000”,“traderType”:0,“makerAccountIndex”:“0”}]	2024-07-22T19:29:48.000Z	0x0442dd88a482833fe2ca98a6b66526aa640321f3	53701764009024545329140105184117612691277478483204747436160224852916726906934	[“0”,“14”]	0xd9cc8a6087d3b3302dc541f2e7bc6533294ea8310d68c2264a375f121b9982fe
0x4bff12773b0dc3cb35f174b5cd351f662018cc2f	false	35	234831622	[{“trader”:“0x2cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c”,“tradeData”:“0x000000000000000000000000af88d065e77c8cc2239327c5edb3a432268e583100000000000000000000000000000000000000000000000000000000773594000000000000000000000000009b99e9c620b2e2f09e0b9fced8f679eecf2653fe00000000000000000000000082af49447d8a07e3bd95bd0d56f35241523fbab100000000000000000000000000000000000000000000000007f71f29d086d88000000000000000000000000000000000000000000000000007eced1667cdda000000000000000000000000002cdbb25b4aca98a55f6b1a0f67d9f43455e67f3c00000000000000000000000000000000000000000000000000000000000001400000000000000000000000009b99e9c620b2e2f09e0b9fced8f679eecf2653fe000000000000000000000000000000000000000000000000000000003f76e5e60000000000000000000000000000000000000000000000000000000000000048010203002801010102ff00000000000000000000000000000000000000000000af88d065e77c8cc2239327c5edb3a432268e583182af49447d8a07e3bd95bd0d56f35241523fbab1000000000000000000000000000000000000000000000000”,“traderType”:0,“makerAccountIndex”:“0”}]	2024-07-22T09:53:00.000Z	0x0769c5d106fffb68421c59b04845d7857afda15a	0	[“17”,“0”]	0x0e113399a2b876c92b86369ad8178dbbbfd12e7d8934fce2b32d0f5886c61766

Example Query

Query with partition filter

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

RewardsDistributor_Claimed_event

Reward claim events from Dolomite protocol on Arbitrum, recording user addresses, epoch numbers, and token amounts distributed from the RewardsDistributor contract. Enables tracking of reward distributions across epochs and analysis of user claim 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_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	in_user	removed	in_epoch	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x66cd7d0cc677f42f6662622c60a5e60ef573db67	0x00cb97487391d0ac7819c77098dbfd75b1d76787	false	17	122391173051909294771	8	190944102	2024-03-16T10:50:55.000Z	0x1e94b4be56c853672592b262506107a1a34f54a229b7173b39edd36507ce313b
0x66cd7d0cc677f42f6662622c60a5e60ef573db67	0x048a8bb49ac39c7a31ffba9f9b6522396df26b2b	false	9	75856771167661502	8	191030318	2024-03-16T16:51:56.000Z	0xf694ed47eda6b35b6651f1dbcfc7b8adba1ebce90dda4cd74fe725cb24d2d2e1
0x66cd7d0cc677f42f6662622c60a5e60ef573db67	0x048a8bb49ac39c7a31ffba9f9b6522396df26b2b	false	11	618375091708085578	14	191030318	2024-03-16T16:51:56.000Z	0xf694ed47eda6b35b6651f1dbcfc7b8adba1ebce90dda4cd74fe725cb24d2d2e1

Example Query

Query with partition filter

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

VesterProxy_ClosePositionWindowSet_event

Configuration changes for position closing time windows in Dolomite’s vesting proxy contract on Arbitrum. Tracks when close position window durations are modified, with values in seconds (604800=7 days, 2592000=30 days, 31536000=365 days).

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_closePositionWindow`	`STRING`	Time window duration in seconds during which positions can be closed in the Dolomite vesting contract. Common values include 604800 (7 days), 2592000 (30 days), and 31536000 (365 days).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_closePositionWindow
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	1	161770607	2023-12-20T02:10:37.000Z	0x01fdf564bcc191d2515d1c89cb4c6a5eb55b756bb50f202b7040c1d1c2b231bd	2592000
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	3	150138915	2023-11-13T22:57:43.000Z	0xb120e987446a66ef0def072fb79c06df6ea5ea6872254e0377ec615716686d93	604800
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	1	227882025	2024-07-02T05:33:15.000Z	0x268d4349acc93a661f2b174639889447999192e1566537000e029fdde0db3e8b	31536000

Example Query

Query with partition filter

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

VesterProxy_EmergencyWithdraw_event

Emergency withdrawal events from Dolomite V1 vesting contracts on Arbitrum. Tracks forced withdrawals from vesting positions by owner address and vesting ID for monitoring early exit activity.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_vestingId`	`STRING`	Unique identifier for the vesting position. Numeric string representation assigned sequentially to each vesting arrangement.
`in_pairTax`	`STRING`	Tax amount or fee associated with the trading pair in the emergency withdrawal transaction. Always appears as ‘0’ in sample data, indicating either no tax charged or a waived fee scenario.

Sample Data

address	removed	in_owner	log_index	block_number	in_vestingId	block_timestamp	transaction_hash
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0xdfcec744c8417d2a0ef72fe520438dd20f368369	8	171972964	589	2024-01-19T10:02:16.000Z	0xc60b863b90d22a1f38be93cc1815acaad08667ea2efed257f464e76155a4f9c1
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0xdfcec744c8417d2a0ef72fe520438dd20f368369	9	171978292	686	2024-01-19T10:24:51.000Z	0x1d88bc60ab5291ca664a7c00c09f84dbb2d412bd16e1e6699d18e429d42e696a
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0xdfcec744c8417d2a0ef72fe520438dd20f368369	12	171975571	497	2024-01-19T10:13:20.000Z	0x7afe671a45e5338f630f5cfddeb6bf1d70d02810f492927c188dbe8296b66849

Example Query

Query with partition filter

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

VesterProxy_EmergencyWithdrawTaxSet_event

Emergency withdrawal tax configuration changes for Dolomite v1 vesting contracts on Arbitrum. Tracks when the penalty tax rate for early withdrawals is modified, useful for monitoring vesting parameter governance.

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_emergencyWithdrawTax`	`STRING`	The tax rate (in basis points or wei) applied when users perform an emergency withdrawal from the vesting contract. A value of ‘0’ indicates no tax is charged on emergency withdrawals.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_emergencyWithdrawTax
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	5	150138915	2023-11-13T22:57:43.000Z	0xb120e987446a66ef0def072fb79c06df6ea5ea6872254e0377ec615716686d93	0

Example Query

Query with partition filter

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

VesterProxy_ForceClosePositionTaxSet_event

Event log tracking changes to the force close position tax parameter in Dolomite’s vesting proxy contract on Arbitrum. Records administrative updates to the liquidation penalty fee (measured in basis points, e.g., 500 = 5%) applied when positions are forcibly closed.

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_forceClosePositionTax`	`STRING`	Tax rate applied when a position is forcibly closed, expressed in basis points where 500 equals 5%. This parameter determines the penalty fee charged to users whose positions are liquidated or force-closed by the protocol.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_forceClosePositionTax
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	4	150138915	2023-11-13T22:57:43.000Z	0xb120e987446a66ef0def072fb79c06df6ea5ea6872254e0377ec615716686d93	500

Example Query

Query with partition filter

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

VesterProxy_PositionClosed_event

Token vesting position closure events from Dolomite v1 protocol on Arbitrum. Tracks when vesting schedules complete or are terminated early, including owner addresses, vesting IDs, and ETH costs paid for early withdrawal.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_vestingId`	`STRING`	Unique identifier for the vesting position. Numeric string representation assigned sequentially to each vesting arrangement.
`in_ethCostPaid`	`STRING`	ETH cost paid in wei to close the vesting position, typically zero but may contain non-zero values when gas or fees are involved. String-encoded integer representing the amount in smallest denomination (wei).

Sample Data

address	removed	in_owner	log_index	block_number	in_vestingId	block_timestamp	transaction_hash
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0x2b4905464319b184aeadd265d8d59740178f1e52	21	253711711	2007	2024-09-15T08:18:38.000Z	0x6279ed0f4d6404540de7c1106e4ff7808fea4eb2ab40a55ea2df8123bbcd0d59
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0x3b411cb6f1f30e90cce2ba5f1d3c8c4dabc7dace	28	253837569	1952	2024-09-15T17:07:02.000Z	0xd04236ae85b99559db01ce9a4b4f520ff10b88df67c3054d8504f140b4d80b42
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0x3b411cb6f1f30e90cce2ba5f1d3c8c4dabc7dace	27	253837494	1868	2024-09-15T17:06:44.000Z	0xedf80363fb1398d8a95d056a90d6216f6e12d30e40887c4c4b516a899ce9d197

Example Query

Query with partition filter

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

VesterProxy_PositionForceClosed_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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_vestingId`	`STRING`	Unique identifier for the vesting position. Numeric string representation assigned sequentially to each vesting arrangement.
`in_pairTax`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VesterProxy_PromisedTokensSet_event

Event log tracking promised token balance updates in Dolomite’s vesting proxy contract on Arbitrum. Records changes to vested token amounts with removal flags for analyzing token vesting schedules and claim activity.

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_promisedTokensSet`	`STRING`	Total amount of tokens promised or vested through the Dolomite VesterProxy contract at the time of the event. Values are denominated in the smallest token unit (wei-equivalent), representing cumulative vesting commitments.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_promisedTokensSet
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	1	256768240	2024-09-24T06:09:02.000Z	0x8b669632639c9709fdcdcfe144bf26254aa28fa80614fb549e2189de14f59dab	601607729988476129367143
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	3	256787879	2024-09-24T07:31:08.000Z	0x08807fb9938d59840d6367b7a2533ccb23a6f30f5dfe9206f77320dd511010a2	601601635669241873897741
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	2	256714001	2024-09-24T02:21:50.000Z	0xa894f395acf838632b23a18b9005ced40cd17eedeadbbf6d7960f228915c3184	603114228951460380989120

Example Query

Query with partition filter

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

VesterProxy_VestingPositionCreated_event

Token vesting position creation events from Dolomite protocol on Arbitrum. Records each new vesting schedule with position ID, token amount, creator address, duration (typically 280 days or 7 days), and start timestamp for tracking time-locked token releases.

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_vestingPosition`	`STRUCT<creator STRING, id STRING, startTime STRING, duration STRING, amount STRING>`	Structured data about the newly created vesting position, including unique identifier, token amount, creator address, vesting duration in seconds, and Unix timestamp start time. Contains comprehensive metadata for tracking and managing individual token vesting schedules on Dolomite.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_vestingPosition
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	8	184410185	2024-02-25T18:32:49.000Z	0x98cfc49788cf94a1c72e73b81a28e2e6624b504c11ce74633252d2ff9e72141d	{“id”:“1892”,“amount”:“128897580496786011641”,“creator”:“0x8284dd79d44e7d7bac9c285ab1ff8e072183b5c1”,“duration”:“24192000”,“startTime”:“1708885969”}
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0	184204458	2024-02-25T03:53:29.000Z	0x5e1c043b638e660f7466341bf362c9af93a29d8fa2848110e9e8a3b33d9f2c04	{“id”:“1885”,“amount”:“149000000000000000000”,“creator”:“0xd2f80f967a31fe7c521416a7552c25f32ce4babc”,“duration”:“24192000”,“startTime”:“1708833209”}
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0	184255479	2024-02-25T07:34:37.000Z	0xc793df5dc3f97e7645d5ac1c2e6fc3079bcf09764034ecd78a2e548e06161193	{“id”:“1886”,“amount”:“290745038530914422280”,“creator”:“0x777538e9e6fb692420ecd63add56ae2e34227e94”,“duration”:“24192000”,“startTime”:“1708846477”}

Example Query

Query with partition filter

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

VesterProxy_VestingStarted_event

Token vesting schedule initiation events from Dolomite v1 protocol on Arbitrum. Tracks when new vesting positions are created with unique vesting IDs, owner addresses, token amounts, and duration periods (ranging from 14 days to 280 days based on sample data).

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_vestingId`	`STRING`	Unique identifier for the vesting position. Numeric string representation assigned sequentially to each vesting arrangement.

Sample Data

address	removed	in_owner	in_amount	log_index	in_duration	block_number	in_vestingId	block_timestamp	transaction_hash
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0x5edf3310e7c81fabb034e7130f78c74c0d4809a7	4929011616049864360934	53	1209600	158422341	329	2023-12-09T14:05:31.000Z	0xa7c91fba6103db8e48123799945ff4644f9d2753177cd235ba956eaadeaffe8b
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0x06f8859d5d5fb395ba9efdc55879c9ff3a92db8c	4760699376658703526676	12	1209600	158422639	330	2023-12-09T14:06:43.000Z	0xfc976edf2f61c631095e31bf203ec8120314ffd3b851d4db3c89ff89d7804023
0x531bc6e97b65adf8b3683240bd594932cfb63797	false	0xc711bffd52995d206997796de8fb50be58abe691	95517511891525329133	23	12096000	158550026	335	2023-12-09T23:26:31.000Z	0x8c4cf0d4fe940eb82f46cc86e821aa673a5af006d0d2fde20e54e824109f7cfb

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​BorrowPositionProxy_BorrowPositionOpen_event

​BorrowPositionProxyV2_BorrowPositionOpen_event

​DolomiteMargin_LogAddMarket_event

​DolomiteMargin_LogBuy_event

​DolomiteMargin_LogCall_event

​DolomiteMargin_LogDeposit_event

​DolomiteMargin_LogIndexUpdate_event

​DolomiteMargin_LogInterestRate_event

​DolomiteMargin_LogLiquidate_event

​DolomiteMargin_LogOperation_event

​DolomiteMargin_LogOperatorSet_event

​DolomiteMargin_LogOraclePrice_event

​DolomiteMargin_LogSell_event

​DolomiteMargin_LogSetEarningsRate_event

​DolomiteMargin_LogSetEarningsRateOverride_event

​DolomiteMargin_LogSetLiquidationSpread_event

​DolomiteMargin_LogSetLiquidationSpreadPremium_event

​DolomiteMargin_LogSetSpreadPremium_event

​DolomiteMargin_LogTrade_event

​DolomiteMargin_LogTransfer_event

​DolomiteMargin_LogVaporize_event

​DolomiteMargin_LogWithdraw_event

​DolomiteMargin_LogWithdrawExcessTokens_event

​EventEmitterRegistry_AsyncDepositCancelled_event

​EventEmitterRegistry_AsyncDepositCancelledFailed_event

​EventEmitterRegistry_AsyncDepositCreated_event

​EventEmitterRegistry_AsyncDepositExecuted_event

​EventEmitterRegistry_AsyncDepositFailed_event

​EventEmitterRegistry_AsyncDepositOutputAmountUpdated_event

​EventEmitterRegistry_AsyncWithdrawalCancelled_event

​EventEmitterRegistry_AsyncWithdrawalCreated_event

​EventEmitterRegistry_AsyncWithdrawalExecuted_event

​EventEmitterRegistry_AsyncWithdrawalFailed_event

​EventEmitterRegistry_AsyncWithdrawalOutputAmountUpdated_event

​EventEmitterRegistry_BorrowPositionOpen_event

​EventEmitterRegistry_DistributorRegistered_event

​EventEmitterRegistry_MarginPositionClose_event

​EventEmitterRegistry_MarginPositionOpen_event

​EventEmitterRegistry_RewardClaimed_event

​EventEmitterRegistry_ZapExecuted_event

​RewardsDistributor_Claimed_event

​VesterProxy_ClosePositionWindowSet_event

​VesterProxy_EmergencyWithdraw_event

​VesterProxy_EmergencyWithdrawTaxSet_event

​VesterProxy_ForceClosePositionTaxSet_event

​VesterProxy_PositionClosed_event

​VesterProxy_PositionForceClosed_event

​VesterProxy_PromisedTokensSet_event

​VesterProxy_VestingPositionCreated_event

​VesterProxy_VestingStarted_event

Tables

BorrowPositionProxy_BorrowPositionOpen_event

BorrowPositionProxyV2_BorrowPositionOpen_event

DolomiteMargin_LogAddMarket_event

DolomiteMargin_LogBuy_event

DolomiteMargin_LogCall_event

DolomiteMargin_LogDeposit_event

DolomiteMargin_LogIndexUpdate_event

DolomiteMargin_LogInterestRate_event

DolomiteMargin_LogLiquidate_event

DolomiteMargin_LogOperation_event

DolomiteMargin_LogOperatorSet_event

DolomiteMargin_LogOraclePrice_event

DolomiteMargin_LogSell_event

DolomiteMargin_LogSetEarningsRate_event

DolomiteMargin_LogSetEarningsRateOverride_event

DolomiteMargin_LogSetLiquidationSpread_event

DolomiteMargin_LogSetLiquidationSpreadPremium_event

DolomiteMargin_LogSetSpreadPremium_event

DolomiteMargin_LogTrade_event

DolomiteMargin_LogTransfer_event

DolomiteMargin_LogVaporize_event

DolomiteMargin_LogWithdraw_event

DolomiteMargin_LogWithdrawExcessTokens_event

EventEmitterRegistry_AsyncDepositCancelled_event

EventEmitterRegistry_AsyncDepositCancelledFailed_event

EventEmitterRegistry_AsyncDepositCreated_event

EventEmitterRegistry_AsyncDepositExecuted_event

EventEmitterRegistry_AsyncDepositFailed_event

EventEmitterRegistry_AsyncDepositOutputAmountUpdated_event

EventEmitterRegistry_AsyncWithdrawalCancelled_event

EventEmitterRegistry_AsyncWithdrawalCreated_event

EventEmitterRegistry_AsyncWithdrawalExecuted_event

EventEmitterRegistry_AsyncWithdrawalFailed_event

EventEmitterRegistry_AsyncWithdrawalOutputAmountUpdated_event

EventEmitterRegistry_BorrowPositionOpen_event

EventEmitterRegistry_DistributorRegistered_event

EventEmitterRegistry_MarginPositionClose_event

EventEmitterRegistry_MarginPositionOpen_event

EventEmitterRegistry_RewardClaimed_event

EventEmitterRegistry_ZapExecuted_event

RewardsDistributor_Claimed_event

VesterProxy_ClosePositionWindowSet_event

VesterProxy_EmergencyWithdraw_event

VesterProxy_EmergencyWithdrawTaxSet_event

VesterProxy_ForceClosePositionTaxSet_event

VesterProxy_PositionClosed_event

VesterProxy_PositionForceClosed_event

VesterProxy_PromisedTokensSet_event

VesterProxy_VestingPositionCreated_event

VesterProxy_VestingStarted_event