> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# mycelium_v1_arbitrum

> Tables in tt-contracts.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.

<Accordion title="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%.                                  |
</Accordion>

<Accordion title="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 | 21         | 0x2de28ab4827112cd3f89e5353ca5a8d80db7018f | 62262791      | 826112123458011287   | 486646789190374  | 2023-02-19T00:38:13.000Z | 0x78f80ddbdadad648e478af06d12cacd93a51f33d37ce4a32738bc783c934bc5f | 0                  |
  | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | false   | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 8          | 0x2de28ab4827112cd3f89e5353ca5a8d80db7018f | 62520381      | 337470000000000000   | 200000000000000  | 2023-02-19T19:08:49.000Z | 0x6b89061f0f87f9c67acac664b7e69b8d94fce9e7b49bb7c4d27ba6f758b43c1f | 0                  |
  | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | false   | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 22         | 0x2de28ab4827112cd3f89e5353ca5a8d80db7018f | 62357415      | 15655866369074419083 | 9246728014218926 | 2023-02-19T07:42:41.000Z | 0x436986f86061ced579de7880d5e709691a30bb4e33319a95bee30788d1cc9080 | 0                  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_BuyUSDG_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                            |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_CollectMarginFees_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                            |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_CollectSwapFees_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_DecreasePoolAmount_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                             |
</Accordion>

<Accordion title="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                        |
  | ------------------------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------- | ------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | ---------------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------------------------------ |
  | 1160650887002313936902260693248 | 0x00263ec6e84611f3a2678ca888c1cec7a2795a80feef8593c77cb62ed9e8cb08 | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | false   | 925934300000000000000000000000 | true       | 5          | 0x38fcf6aaf523118bfea55ab0747e490cef5e71f2 | 25630947      | 3817930549349716897704804912000000 | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 | 2022-09-21T05:59:51.000Z | 0x4b65a9962f43b4223ab967cdb9912440da14d327d7e2c728698b2e67f09504be | 0                   | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 |
  | 325716378747653691529811805264  | 0x00263ec6e84611f3a2678ca888c1cec7a2795a80feef8593c77cb62ed9e8cb08 | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | false   | 921947500000000000000000000000 | true       | 5          | 0x38fcf6aaf523118bfea55ab0747e490cef5e71f2 | 25718717      | 1082114215108484025015986064000000 | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 | 2022-09-21T14:53:50.000Z | 0x43cc08a937942dd37c926a48d8d038022c918ece5b6902a8cf06899d23552168 | 0                   | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 |
  | 487905031563822736879082760000  | 0xb904ee43488671569e048c0f140cad3f2fe8462b0370d096f7502ba2b64f3ba6 | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | false   | 934904600000000000000000000000 | true       | 12         | 0x7dd0b347392bbf364c0ea365778cfde455f97c49 | 25757661      | 1626350105212742456263609200000000 | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 | 2022-09-21T18:40:20.000Z | 0x66947902767a28b82dc1c277159af9f1510973e6e4a8762a224edf7fe4c0707d | 0                   | 0x11cdb42b0eb46d95f990bedd4695a6e3fa034978 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_DecreasePosition_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_IncreasePoolAmount_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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).

<Accordion title="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.                             |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_IncreasePosition_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                    |
</Accordion>

<Accordion title="Sample Data">
  | in\_key                                                            | address                                    | in\_size                          | removed | in\_isLong | log\_index | in\_account                                | block\_number | in\_markPrice                      | in\_collateral                   | in\_indexToken                             | in\_realisedPnl | block\_timestamp         | in\_reserveAmount    | transaction\_hash                                                  | in\_collateralToken                        |
  | ------------------------------------------------------------------ | ------------------------------------------ | --------------------------------- | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ---------------------------------- | -------------------------------- | ------------------------------------------ | --------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0x595e830622a7f7a3ae201a8c68ff8cc83ecc868d0f704606af88e8c7962e0202 | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | 483045578459036778271320000000000 | false   | false      | 2          | 0xfefccb2c6a77edd5a48733782ce8a01c065d483c | 40045586      | 1097020000000000000000000000000000 | 9565258979386866899555812000000  | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0               | 2022-11-21T20:08:24.000Z | 483045578            | 0xceedf39255cbb9ac32171c5cb533caf089989b3eafb77b03eef1e5c9aa19aded | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 |
  | 0xb740df420c159785a70ca59bde7f9b4720b2c03a8fc1a841db73136af284b6a3 | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | 522056111496695589214240000000000 | false   | true       | 4          | 0x9fab54e099ec1cbb5ce8836eb30e542a2d04c899 | 39781674      | 5650541400000000000000000000000    | 17314722674621387010584635800000 | 0xf97f4df75117a78c1a5a0dbb814af92458539fb4 | 0               | 2022-11-21T00:07:26.000Z | 90567278390977649394 | 0x9525e85e97d85562a5a55549f70fb066347c335e629f1466bc534f60dfb6470b | 0xf97f4df75117a78c1a5a0dbb814af92458539fb4 |
  | 0x53ff82973edd19d67971402e32ac994e0accdf68a51529bfa8f422881254ce5b | 0xdfba8ad57d2c62f61f0a60b2c508bcdeb182f855 | 552290162131139700126300000000000 | false   | true       | 4          | 0x6a1128c36cf3886ea0e8f799f6003f614b013af5 | 39959527      | 1132400000000000000000000000000000 | 10939938854081974269886330000000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0               | 2022-11-21T13:49:54.000Z | 482897754770603917   | 0x5f0a28ba6201aeac8e17f3045181c732ed801269f566042869a8c8aff79802f1 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_LiquidatePosition_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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%.                                  |
</Accordion>

<Accordion title="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                 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_SellUSDG_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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%.                                  |
</Accordion>

<Accordion title="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      |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.mycelium_v1_arbitrum.Vault_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***