metavault_v1_polygon

Tables

StakedMvlpTracker_Claim_event

Reward claim events from Metavault’s staked MVLP (Metavault Liquidity Provider) tracker contract on Polygon. Records user reward withdrawals with amounts in wei and recipient addresses for analyzing staking yield distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xa6ca41bbf555074ed4d041c1f4551ef48116d59a	false	7999552963022992032	43	0x0a83985e4a6e8dae2b67bed4f2d9268f6806ce00	29852596	2022-06-22T03:20:07.000Z	0x3af2bb0f542c0d275b630e177477dcd8a0254c70453068b1df5ca580ebeb8242
0xa6ca41bbf555074ed4d041c1f4551ef48116d59a	false	335607751782866644232	71	0x156ce99f432f995ef574c00f9b54c3ceb5454bc0	29870696	2022-06-22T14:42:31.000Z	0x0a91ac229229d8439e93723925d80f324437ec38a6216feb69f4cfefd78289fa
0xa6ca41bbf555074ed4d041c1f4551ef48116d59a	false	90480967048559871046	99	0x1f3555e9572af36c2a0f0ec54fa929c5f7d04223	29859771	2022-06-22T07:46:03.000Z	0xaf602ec62c2d9c66914f1b709291f25b3e4e43228c210d9326980faf2c564698

Example Query

Query with partition filter

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

StakedMvxTracker_Claim_event

Reward claim events from Metavault’s staked MVX token tracker contract on Polygon, recording when users claim accumulated staking rewards. Useful for analyzing reward distribution patterns and staker behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xe8e2e78d8ca52f238caf69f020fa961f8a7632e9	false	79792319368121078	3	0xa4051a45e35360284476a19a967998c4829fcba0	44768561	2023-07-06T22:59:18.000Z	0x247098a767f75c57e7644042591b1610e02fc3b9c4889c111c6f6ba7078c2dca
0xe8e2e78d8ca52f238caf69f020fa961f8a7632e9	false	150321632700830899	7	0x83724dd189c5fce013c2e80c0f0c2a14b0c45c76	44737026	2023-07-06T03:48:31.000Z	0x5013ee2ddf5e97423bdadbc4aef2960af381addb929cf7e766ac7ccd97be5da8
0xe8e2e78d8ca52f238caf69f020fa961f8a7632e9	false	2415948408735506	9	0x273c90a6e64fa5acb2955c776de0e9002b37f30b	44734866	2023-07-06T02:30:55.000Z	0xe4653879be900b8a65da2ae28bab023553a49f7c7dee53638a81ab6e62b6c1d8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.StakedMvxTracker_Claim_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
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	473203781059477791044256471121	20	44834854	695331648004357971	2023-07-08T15:06:59.000Z	0x5e1ff9b383e5cf32308294f81dc45ed7786c6eeea5a1d6f5eb206abc385a024e
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	957675184772530995124869736293	9	44826658	1403093338778436188	2023-07-08T09:58:44.000Z	0x0d984e2585333a744e4f92b2eb48291217164488259a44a3d8cd08823fab35e0
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	14254952554645524988100167438738	15	44826692	20884981977241557176	2023-07-08T10:00:06.000Z	0x7a5a94df411da41aad74392c9f527349e94640fb5ee6943ff4ae4157233e9ce6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.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
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	26321295931233457868310067632	202	38018270	28939854294565013	2023-01-13T07:58:59.000Z	0x9431571f2249cb491d65acbb10c216e976b1481b1a07f84722ac33cba5592c9e
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	1173877069138776465600000	827	38033861	1294207571112	2023-01-13T16:57:25.000Z	0x5d9733583acc0a26d3d7418858d0f952b7a6f2f3be35dc34311fc1587c229f00
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	188463003271936978957794400000	266	38035711	207211089686840908	2023-01-13T18:00:58.000Z	0x87f26ddef9c35baa7cc10818abc4fda335eb68b31e0d9d246764fc15dc62d41e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.Vault_CollectSwapFees_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
1479187112689211650485011982234	0x02bafded759245ddff70f2c58c894c5ef81f09fbc1cb8f85aecaf82c4e18d0f9	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	840327200000000000000000000000	true	12	0x30036ff2e84dd47e1de39c5873187422641d9b03	49856495	1451606587526213592232592720543328	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-11-12T14:26:34.000Z	0xe08f00c5525008ceee73defa02cee4f24fff9d164a595478a2aa3c96128bbde9	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
915596933295267676757856301464	0x02bafded759245ddff70f2c58c894c5ef81f09fbc1cb8f85aecaf82c4e18d0f9	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	862054853960000000000000000000	true	14	0x30036ff2e84dd47e1de39c5873187422641d9b03	49862975	899407596557237403494947250946168	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-11-12T18:16:57.000Z	0xbd0a358738e73418664f69fe1589b8bb70ff2ce623a7edb1fc64b7b92162e26c	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
3488188138071677475727976540000	0x02bafded759245ddff70f2c58c894c5ef81f09fbc1cb8f85aecaf82c4e18d0f9	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	831334400000000000000000000000	true	14	0x30036ff2e84dd47e1de39c5873187422641d9b03	49847649	2873301596434660194174610000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-11-12T09:07:50.000Z	0xe4e55611fa5c29b2c73ea9201771dee8b59c1a9491c6006e70836d6c1ebcd052	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.Vault_DecreasePosition_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
59013388511574967664831991736	0x02cfbb6ce1347e30882ceebb45e166d7a2a14c09653591496de8f370794b8d42	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	1164931200000000000000000000000	true	26	0x425ca2cc0132334e41503a427d1bd4b75141b043	41539032	59013388511574967664831991735144	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-04-14T23:26:55.000Z	0xf17cc004a36b3406519e946211c4313fdc6f3eecdd30f6321a938dc91f5f8aa1	11630688000000000000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
3355584261456952314954007806576	0x82a14323ee5b45148e329abfb13d149c54eec1470d12e60ea83afb502a7332b3	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	1161928800000000000000000000000	true	29	0x5b8e1306bd9f143941b8698032ca41529580309e	41531359	185808421863680253263935302254112	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-04-14T18:22:24.000Z	0xba2da9dc6db06eebb6c5548a84f3e4f95f43feca4fb404ac5285e50bdc8e8e59	17348864796000000000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
5051808479634463005343657500000	0x57964b66544fd9936c19f7ee2f50208af28bca9c341f79c543f925e8605f7172	0x32848e2d3aecfa7364595609fb050a301050a6b4	false	1176201368928000000000000000000	true	150	0x2a6883af85fdd4c81a579c6d5ad6b25e843b659b	41521863	5051808479634463005343657500000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2023-04-14T12:32:06.000Z	0x71870dde57d573fed3098227ccd1b597b85af3f258c2cab3366a1871e6f8034f	106061049753906340598869423152000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.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
0x22870edffab98962220805ca2800de78e223fb42ce41e9ef75fa0844fa74ee3e	0x32848e2d3aecfa7364595609fb050a301050a6b4	549927354679802955664436628000000	false	true	14	0x81ebf134483d5580a4e7cf52b2798d22af1e9051	36866756	881118000000000000000000000000	36692792645320197044335563372000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2022-12-15T16:27:38.000Z	590641451193471320746	0x31096f22d31becc4800015ba8396ddc70d2b053008597bbd0c2d743f6a294118	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
0xf4b801a164adaf48c64da4bc3dd68e4ffefb1297efa0e4bfdb835f86c2b652ef	0x32848e2d3aecfa7364595609fb050a301050a6b4	570388761921466861980200000000000	false	true	83	0xf012576bbcfab8d7580315a0f006594987f06bfc	44655471	1955220000000000000000000000000000	11294614225569133138019800000000	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	2023-07-04T01:51:37.000Z	330581004038723982	0x64d4212849f6e1998e2edea9490f693b093ecc8f6ae502c5dcc417abafcd8865	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619
0xc8f186dc76b6b09d985cebfcd85181219ffa079da4487a1c80aaeccddc3bc0bd	0x32848e2d3aecfa7364595609fb050a301050a6b4	290714203471230000000000000000000	false	true	45	0xe61880588f183cfd9c65f5ce3fcbfdb1f4765a81	34858725	20569800000000000000000000000000000	9656914399528770000000000000000	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	2022-10-27T10:08:42.000Z	1392692	0xa211cb764409d35069422306b521650b63df789b4302d3f0eb606259315ba725	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.metavault_v1_polygon.Vault_LiquidatePosition_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
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	278	0xca9c89410025f2bc3befb07ce57529f26ad69093	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	5931525114703592	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32161325	11869529046831631900	2022-08-21T18:03:27.000Z	0xf7a901539d8f5f62ef7bea13e9eabfdb8cc35feb31161758674dfe940e548343	31	11832733506786453841
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	479	0xca9c89410025f2bc3befb07ce57529f26ad69093	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	5785908833811273	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32149453	11668175474158759736	2022-08-21T11:07:36.000Z	0x63bb523f8fed357fcf86568ed2d48e16a264e29a96987a1f0e70b9e6773d5497	32	11630837312641451704
0x32848e2d3aecfa7364595609fb050a301050a6b4	false	23	0x5e51629adcded51a8b51133d4b46d10ec5eb5361	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32141720	1271785814000000000000	2022-08-21T06:32:35.000Z	0x84ae9e0e4c2b9f63e19e4c753df06c0b2f9a7f460de52ffecfc92dea3e4c8e20	33	1267588920813800000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

StakedMvlpTracker_Claim_event

StakedMvxTracker_Claim_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePosition_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​StakedMvlpTracker_Claim_event

​StakedMvxTracker_Claim_event

​Vault_CollectMarginFees_event

​Vault_CollectSwapFees_event

​Vault_DecreasePosition_event

​Vault_IncreasePosition_event

​Vault_LiquidatePosition_event

​Vault_Swap_event

Tables

StakedMvlpTracker_Claim_event

StakedMvxTracker_Claim_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePosition_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_Swap_event