mycelium_v1_arbitrum

Tables

Vault_BuyUSDG_event

USDG stablecoin purchase events emitted by vault contracts, recording the deposited token type, amount, receiving account, minted USDG quantity, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	21	0x2de28ab4827112cd3f89e5353ca5a8d80db7018f	62262791	826112123458011287	486646789190374	2023-02-19T00:38:13.000Z	0x78f80ddbdadad648e478af06d12cacd93a51f33d37ce4a32738bc783c934bc5f
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	8	0x2de28ab4827112cd3f89e5353ca5a8d80db7018f	62520381	337470000000000000	200000000000000	2023-02-19T19:08:49.000Z	0x6b89061f0f87f9c67acac664b7e69b8d94fce9e7b49bb7c4d27ba6f758b43c1f
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	22	0x2de28ab4827112cd3f89e5353ca5a8d80db7018f	62357415	15655866369074419083	9246728014218926	2023-02-19T07:42:41.000Z	0x436986f86061ced579de7880d5e709691a30bb4e33319a95bee30788d1cc9080

Example Query

Query with partition filter

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

Vault_CollectMarginFees_event

Margin fee collection events emitted by perpetual futures vault contracts. Records fee amounts in both native token and USD-denominated values charged on leveraged trading 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeUsd`	`STRING`	USD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
`in_feeTokens`	`STRING`	Fee amount collected in token units. String-encoded integer value representing the quantity of tokens charged as the fee.

Sample Data

address	removed	in_token	in_feeUsd	log_index	block_number	in_feeTokens	block_timestamp	transaction_hash
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	8075036832273183794835744000000	19	77905035	8075036	2023-04-07T07:33:20.000Z	0xb1fc36e691d18371b05be41c3cdd9ca166c6251c2ed69fb1635ff7c5ff37377d
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	11206827724489454300730907500000	48	77910887	11206827	2023-04-07T07:57:31.000Z	0x6604dbba236debab72be2b8094295613b06861361723954976839967b177f285
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	12031586537495815198455750000000	22	77910431	12031586	2023-04-07T07:55:41.000Z	0x764f062dab6d81783fd63a2779e2bad1af35e4842c3b376ad1b1d1b8138bc909

Example Query

Query with partition filter

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

Vault_CollectSwapFees_event

Swap fee collection events emitted by GMX-style vault contracts, recording the token address, fee amount in both native token units and USD-denominated value. Used for protocol revenue tracking and fee distribution analytics across perpetual trading and liquidity platforms.

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_feeUsd`	`STRING`	USD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
`in_feeTokens`	`STRING`	Fee amount collected in token units. String-encoded integer value representing the quantity of tokens charged as the fee.

Sample Data

address	removed	in_token	in_feeUsd	log_index	block_number	in_feeTokens	block_timestamp	transaction_hash
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	243257870171246515716571200000	5	60286122	252149571811788708	2023-02-12T15:03:24.000Z	0xba5808fae6d1ced8f66f282b366d930a7f846614484f57f507d1f1f3945dc6c5
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	208500090402230187586400000000	6	60376142	227138335359127000	2023-02-12T22:08:05.000Z	0x172c3ac8676023c988d0a937929e5f252159f6454bc25a428d346bfacd8cda00
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	375261794873035840000000000000	13	60281381	389380417300000000	2023-02-12T14:42:03.000Z	0x570a4987c3f4d84af087329b93be5ecb05b0de55a21ef06a4deaffa3258b8876

Example Query

Query with partition filter

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

Vault_DecreasePoolAmount_event

Token removal events from Mycelium perpetual futures vault on Arbitrum. Records when liquidity is withdrawn from the vault’s token pools, tracking token addresses and amounts for analyzing vault composition changes and 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_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
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	5413770676866370293	9	30245877	2022-10-15T12:58:45.000Z	0xe882ba09477811fb17b22601de48c14005ff9356a9d15fd60c8aca0d259a9427
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	4453772479450039085	19	30246766	2022-10-15T13:04:35.000Z	0xd29d6449511a88cd2526189dacf86753104c71cce880b1a837123f13b3e59568
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	4412204696292305615	21	30243871	2022-10-15T12:44:48.000Z	0x58aba3fb7acf098b9457838bc7dd61b1faf458041890b0e8c950ace7c662d9f5

Example Query

Query with partition filter

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

Vault_DecreasePosition_event

Emitted when a leveraged trading position is reduced or closed, recording position size changes, collateral withdrawals, and associated fees. Used for tracking position lifecycle and calculating realized PnL in perpetual futures protocols.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralDelta`	`STRING`	Change in collateral amount for the position. String-encoded integer value representing the delta in the smallest unit of the collateral token.
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_key	address	removed	in_price	in_isLong	log_index	in_account	block_number	in_sizeDelta	in_indexToken	block_timestamp	transaction_hash	in_collateralToken
1160650887002313936902260693248	0x00263ec6e84611f3a2678ca888c1cec7a2795a80feef8593c77cb62ed9e8cb08	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	925934300000000000000000000000	true	5	0x38fcf6aaf523118bfea55ab0747e490cef5e71f2	25630947	3817930549349716897704804912000000	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	2022-09-21T05:59:51.000Z	0x4b65a9962f43b4223ab967cdb9912440da14d327d7e2c728698b2e67f09504be	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978
325716378747653691529811805264	0x00263ec6e84611f3a2678ca888c1cec7a2795a80feef8593c77cb62ed9e8cb08	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	921947500000000000000000000000	true	5	0x38fcf6aaf523118bfea55ab0747e490cef5e71f2	25718717	1082114215108484025015986064000000	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	2022-09-21T14:53:50.000Z	0x43cc08a937942dd37c926a48d8d038022c918ece5b6902a8cf06899d23552168	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978
487905031563822736879082760000	0xb904ee43488671569e048c0f140cad3f2fe8462b0370d096f7502ba2b64f3ba6	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	934904600000000000000000000000	true	12	0x7dd0b347392bbf364c0ea365778cfde455f97c49	25757661	1626350105212742456263609200000000	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978	2022-09-21T18:40:20.000Z	0x66947902767a28b82dc1c277159af9f1510973e6e4a8762a224edf7fe4c0707d	0x11cdb42b0eb46d95f990bedd4695a6e3fa034978

Example Query

Query with partition filter

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

Vault_IncreasePoolAmount_event

Vault liquidity addition events from Mycelium V1 perpetual futures protocol on Arbitrum, tracking when tokens are deposited into the vault’s asset pool. Used for monitoring vault liquidity changes and capital flow patterns across different collateral tokens.

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
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	860022000000000000	6	56778261	2023-01-31T02:18:15.000Z	0xac2eb2fee41a28a388fe2b0ce2b5f1ff293769164f22f965abd64237293a739c
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	220015531235940350	7	56812891	2023-01-31T06:09:27.000Z	0xfc1f8b03159787e70b766b0204123e7a3794fc357b6d3b0f078394c10606f4c1
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	14108861165799871202	12	56924738	2023-01-31T16:17:06.000Z	0xfcbcdda89c6505824de41759d32f5c55f3b5dc7c9c5206c5aaf89784278607a7

Example Query

Query with partition filter

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

Vault_IncreasePosition_event

Perpetual futures position increase events emitted when traders add collateral or size to existing leveraged positions. Records account, collateral token, index token, position size change in USD, execution price, fees, and position direction (long/short).

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralDelta`	`STRING`	Change in collateral amount for the position. String-encoded integer value representing the delta in the smallest unit of the collateral token.
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_key	address	removed	in_price	in_isLong	log_index	in_account	block_number	in_sizeDelta	in_indexToken	block_timestamp	transaction_hash	in_collateralDelta	in_collateralToken
468272087342010000000000000000	0xc2b04f8566e6d5f790b2aa77f66c81abd9e0b2285fa0f8e685b16604b531eeea	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	16558930000000000000000000000000000	true	15	0xfafa345a3ee5a766645f2aaf1c86d64fe067cf21	37728402	520302319268900000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2022-11-13T10:24:30.000Z	0xdff43f59c9c02330da9c22eef6b4fab2a609b9f65f0d440e6e7f8a762f7265cc	24947518348700000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
16983432931691766777653448000000	0x26ddd5e9086cd8248e2753c887cf191104cdce04fe79f041fc61ca7179fafaed	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	1242025000000000000000000000000000	true	22	0x02e1d330d23b14fee45a8733580ae23fdbffbf71	37745958	18870481035213074197392720000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-11-13T11:49:34.000Z	0x699df80cdbdbe6a822bf90e8583a8a08fbb35b9a5df859f17aa20daa013ea876	2993399606118450000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1
2543705966248734759960829500000	0x5002bfe20903620a53196f84b53667c9bdde99143eaaaad1cb972ae68d0723ff	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	1218675000000000000000000000000000	true	14	0x1cb41e63c8a901ea941976f449a0101017582eb2	37863222	2826339962498594177734255000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-11-13T21:37:21.000Z	0xb1463067c74aba10949fd7bef421ec5aa8ccc304bb2594aee0f3d922aa48715e	133457708587500000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1

Example Query

Query with partition filter

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

Vault_LiquidatePosition_event

Perpetual futures position liquidation events recording forced closure of undercollateralized positions. Contains account, collateral token, index token, position size, mark price, and realized profit/loss for risk management and leverage analytics.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_collateral`	`STRING`	Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_reserveAmount`	`STRING`	Amount of tokens reserved in the protocol for the position or operation. String-encoded integer value representing the reserved quantity in the smallest unit of the relevant token.
`in_realisedPnl`	`STRING`	Realized profit or loss from the position at close or liquidation. String-encoded integer value representing the net gain or loss in the smallest unit of the collateral token.
`in_markPrice`	`STRING`	Market price of the index token at the time of position liquidation. String-encoded integer representing the price with 30 decimal places of precision.

Sample Data

in_key	address	in_size	removed	in_isLong	log_index	in_account	block_number	in_markPrice	in_collateral	in_indexToken	block_timestamp	in_reserveAmount	transaction_hash	in_collateralToken
0x595e830622a7f7a3ae201a8c68ff8cc83ecc868d0f704606af88e8c7962e0202	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	483045578459036778271320000000000	false	false	2	0xfefccb2c6a77edd5a48733782ce8a01c065d483c	40045586	1097020000000000000000000000000000	9565258979386866899555812000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-11-21T20:08:24.000Z	483045578	0xceedf39255cbb9ac32171c5cb533caf089989b3eafb77b03eef1e5c9aa19aded	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8
0xb740df420c159785a70ca59bde7f9b4720b2c03a8fc1a841db73136af284b6a3	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	522056111496695589214240000000000	false	true	4	0x9fab54e099ec1cbb5ce8836eb30e542a2d04c899	39781674	5650541400000000000000000000000	17314722674621387010584635800000	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	2022-11-21T00:07:26.000Z	90567278390977649394	0x9525e85e97d85562a5a55549f70fb066347c335e629f1466bc534f60dfb6470b	0xf97f4df75117a78c1a5a0dbb814af92458539fb4
0x53ff82973edd19d67971402e32ac994e0accdf68a51529bfa8f422881254ce5b	0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	552290162131139700126300000000000	false	true	4	0x6a1128c36cf3886ea0e8f799f6003f614b013af5	39959527	1132400000000000000000000000000000	10939938854081974269886330000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-11-21T13:49:54.000Z	482897754770603917	0x5f0a28ba6201aeac8e17f3045181c732ed801269f566042869a8c8aff79802f1	0x82af49447d8a07e3bd95bd0d56f35241523fbab1

Example Query

Query with partition filter

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

Vault_SellUSDG_event

USDG stablecoin redemption events emitted when users sell USDG tokens back to the vault for an underlying collateral token. Records the account address, USDG amount burned, output token and amount received, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash	in_feeBasisPoints
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	15	0xd98d8e458f7ad22dd3c1d7a8b35c74005eb52b0b	54987822	132782572869336584885	81467370997238222	2023-01-23T19:34:24.000Z	0xa91caa69d57871a939e619788b75beb7a320bd7b148994db87d8ce5048bc5166	39
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	15	0x7d17c6f00da9dfc198beff58744971543c4b365b	54985606	4763042151407523568	4744942	2023-01-23T19:20:21.000Z	0x58000de06af501bc91722842e73ce46823a052503ec3bd0d28089703091f01b5	38
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	60	0x8c90e009a6567ea39fe1443ae3ab03c0eb80cc11	254682492	2088882036928344028	3424	2024-09-18T04:27:49.000Z	0xd4014e6af43c0b20d4c45ab5933302398999340e1012863c87a857f7435313ee	58

Example Query

Query with partition filter

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

Vault_Swap_event

Swap events emitted by decentralized exchange vault contracts containing input/output token addresses, amounts, pool identifiers, and swap fee data. Tracks token exchanges executed through vault-based automated market maker protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutAfterFees`	`STRING`	Amount of output tokens received after swap fees are deducted. Numeric string representing the net token quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	log_index	in_account	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash	in_feeBasisPoints	in_amountOutAfterFees
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	15	0x9e52272477c2fcbe2c38bf12dd06cb5739975867	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	2934363575943580	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	208806530	831230019100290	2024-05-07T14:33:04.000Z	0xf13ea6b9228562a28212ab78f2fabbd07fbe41aab0655dfd08d5d2796889ad83	20	829567559062089
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	14	0x018feadd83a8f2ad4d2508469a3a3215483c4377	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	8	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	117394547	2363700000000000	2023-08-02T11:06:40.000Z	0x7d13d6e974ff421469f6eaa30632cb8df2013f99a21119e43c48c64373885fdb	20	2358972600000000
0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855	false	9	0x64768a3a2453f1e8de9e43e92d65fc36e4c9872d	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	19479830745087242037	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	75099010	74387662640573087	2023-03-30T02:08:55.000Z	0xd39c292c770d12581f1a7add34ba68c83c67d2c89bb6d7e31e3453233cbbb651	32	74149622120123253

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Vault_BuyUSDG_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePoolAmount_event

Vault_DecreasePosition_event

Vault_IncreasePoolAmount_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_SellUSDG_event

Vault_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Vault_BuyUSDG_event

​Vault_CollectMarginFees_event

​Vault_CollectSwapFees_event

​Vault_DecreasePoolAmount_event

​Vault_DecreasePosition_event

​Vault_IncreasePoolAmount_event

​Vault_IncreasePosition_event

​Vault_LiquidatePosition_event

​Vault_SellUSDG_event

​Vault_Swap_event

Tables

Vault_BuyUSDG_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePoolAmount_event

Vault_DecreasePosition_event

Vault_IncreasePoolAmount_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_SellUSDG_event

Vault_Swap_event