mummy_v1_arbitrum

Tables

StakedMlpTracker_Claim_event

Reward claim events from Mummy Finance’s staked MLP (Mummy Liquidity Provider) token tracker on Arbitrum. Records when users claim their staking rewards, showing claimed amounts and recipient addresses for analyzing yield distribution patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xad96d9736484e35985773bdf7dba5750dc830042	false	76736125869163799713	7	0xbcc8cb0a825c61355a460da85159f1b43d5d49ab	116820320	2023-07-31T17:10:22.000Z	0x8c75c49782291527ce00bdf12ab6fd2e83461ce1ae4fb8c69e75642dff366e8f
0xad96d9736484e35985773bdf7dba5750dc830042	false	6227025178439516176	7	0x60acaef73c74d370df3c5029f915e280f398bebe	116874317	2023-07-31T21:02:47.000Z	0x73731f1253ffe9b1a561e06e6f030ae70dbf266e466411ed217dbcf7bbc56445
0xad96d9736484e35985773bdf7dba5750dc830042	false	7635689389668605010	9	0x42dbd726f2d74e7b1780afcacd46da8838a47c2b	116629922	2023-07-31T03:44:18.000Z	0x28e35b359d8f02a8c1490433d5f949ea8874ce6c435ae7b29de157081fc37950

Example Query

Query with partition filter

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

StakedMmyTracker_Claim_event

Reward claim events from Mummy Finance’s staked MMY token tracker contract on Arbitrum. Records user reward withdrawals with claim amounts and recipient addresses for tracking staking incentive distributions.

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
0x52cc60893d3bd8508baab835620cbf9ddfa0a13c	false	1249322746253858156	7	0xf5cae6dca50963957fb47a4c094f9f00478606f4	153632811	2023-11-24T14:39:56.000Z	0x5e268804c7c27effdcdfc6fe5383ef192414bafa34737ec201171d4809200783
0x52cc60893d3bd8508baab835620cbf9ddfa0a13c	false	2566543760788832719	7	0x5ca80c9290b067ef5e06545a062c5924fa9496fd	153536941	2023-11-24T07:52:58.000Z	0xc71934b9d2ee23a82b97d17281fd9fbeb36b26d99969e99c8fd278590e3377a5
0x52cc60893d3bd8508baab835620cbf9ddfa0a13c	false	483146006202826260	7	0x34a4392c184a7bb5f62675adbc8e93bd193991ac	153537532	2023-11-24T07:55:26.000Z	0x73e243c028cfce74e6a4ff943367ed5886c1aac989fe1755ff98a8e95db46fb9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_arbitrum.StakedMmyTracker_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
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	47442087373555000000000000000	1	122058717	164	2023-08-16T20:43:18.000Z	0x26452c67b72f9ff02704893ed1e550b5fac6132183431fd21c6a00aaeccabc87
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	43770649099685500000000000000	32	121832746	149	2023-08-16T04:13:07.000Z	0xc80b09e046eecbd81531ae6479c57a334dad338bf5d1b1d21d3aee55b6854fa6
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	216928219005014497474023330000	13	122055673	120021256327414	2023-08-16T20:30:20.000Z	0x748b54b2b4440dd355a818c782cde9af58cc635d2aad2568fe31f5f0a81d0a7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_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
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a	1637942526983720817685315749	45	260343970	77652481613191	2024-10-04T15:58:24.000Z	0xdaf58fd37d7a5773aca90d5416cfe4911609da99b7a23e3197e341c7bd4a6ccd
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	179494779900000000000000000000	4	137360042	654	2023-10-04T07:57:36.000Z	0xc5ba0c17e178a2a4180cd29e4fbea094e2ddab7a6d752001e466198e92f7781d
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	31992805800000000000000000000	5	137415389	116	2023-10-04T11:50:23.000Z	0x72716ca9216b52af94717bee86e1e86f71e47247c2dacfd9ea8f33ef91dd1186

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_arbitrum.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_collateralDelta	in_collateralToken
120281901056664649629162967635	0x612ee3ff7b447c9be72318f85c1a0ac8cae40afc62d8da80cd2e9e3ff7308084	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	45081656000000000000000000000000	true	20	0x5451cf07f9ce7f40dab2412c00ac2f5721387c6d	145329388	51000000000000000000000000000000	0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a	2023-10-30T06:24:48.000Z	0x99d65547045425388f57bfd3272838a981d80622a2dbdc278004bb1bafeb9fa4	10053526970468250549946194783580	0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a
179696769795000000000000000000	0x19fb71d75b79549ffb25f1f55ab9732a27a6df24bb08ceed5730ac62ce7b3fc1	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	1798820000000000000000000000000000	true	20	0x7c293364f42425add2cf2ae1450ea36075076e0a	145499827	179696769795000000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2023-10-30T19:10:35.000Z	0x430cc00fc6c83a9d8977eac3dfdefcde7ec8bffe6f16135e705e1b904702dde9	0	0x82af49447d8a07e3bd95bd0d56f35241523fbab1
35894910179640718063935000000	0x19fb71d75b79549ffb25f1f55ab9732a27a6df24bb08ceed5730ac62ce7b3fc1	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	1799745000000000000000000000000000	true	28	0x7c293364f42425add2cf2ae1450ea36075076e0a	145499221	35894910179640718063935000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2023-10-30T19:07:30.000Z	0x84b02cbed35926ab9608607852f5b6dd6d8f1102fb78245a527b09f262375ff4	0	0x82af49447d8a07e3bd95bd0d56f35241523fbab1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_arbitrum.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
4089968172939900000000000000000	0x2a3160ae295d0064fdb44c38fb175ff9d9b71760cb0e26178d21b2e34a6abddf	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	30553150000000000000000000000000000	true	32	0x979edfe09015880e7c14a173d39785eaa1e2b721	110495468	4089968172939900000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2023-07-12T15:46:52.000Z	0xb4615a4b968d671b049d3816013dd9f7ca03c895567777f22641bc140ad51dfb	45006012076000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
185463444738000000000000000000	0xab13b366aa645ec307ee848be760e108b53de5fd0a8ed831794a7ac13a275ca5	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	30504450000000000000000000000000000	true	37	0xb25420bde26ae36578563079aa7afb8b590e48d7	110497917	185463444738000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2023-07-12T15:57:15.000Z	0x6214064e826fa2b3de55baedb260b880a51fdd5b210313dcc17883c2b04ea66b	168452588923500000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
20570639003100000000000000000	0xab13b366aa645ec307ee848be760e108b53de5fd0a8ed831794a7ac13a275ca5	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	30572150000000000000000000000000000	true	32	0xb25420bde26ae36578563079aa7afb8b590e48d7	110495858	20570639003100000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2023-07-12T15:48:30.000Z	0xd496171e33f4bf62ab33e9e5b2c269c453c5e2c353787c87c3fe5ed049c88a29	18682029422000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_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
0x9d0961c82d83bf724cab73dd64bf87933d8d9f4f6a9dccace3086da3d0e0c575	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	696034764837873786407232830400000	false	true	4	0x14317db38f1468bf6c4437ef5001d4168c59092c	173767762	1710522100000000000000000000000	18086394018196392855592767169600	0x912ce59144191c1204e64559fe8253a0e49e6548	2024-01-24T17:34:30.000Z	400764041997440527604	0xf0bec0377c0e48f99d8a2a6832de7e0aad360c391bd5e2afb45e0a6293c55bac	0x912ce59144191c1204e64559fe8253a0e49e6548
0x81117fc8af59c2f7790b36121b6c31d8535ae1cb14cac64c862a3b3426ab00b7	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	281038420967051534982915000000000	false	true	6	0x14317db38f1468bf6c4437ef5001d4168c59092c	176371592	2242607400000000000000000000000000	13846697851595750165147085000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2024-02-01T11:25:35.000Z	121378175631825902	0x19a331c55bcc65db280d776319ca743aa275ff11fc6ddab1b3a18e3e28b31331	0x82af49447d8a07e3bd95bd0d56f35241523fbab1
0x9d0961c82d83bf724cab73dd64bf87933d8d9f4f6a9dccace3086da3d0e0c575	0x304951d7172bcada54ccac1e4674862b3d5b3d5b	242497004893742214872634770400000	false	true	5	0x14317db38f1468bf6c4437ef5001d4168c59092c	155587847	1002491000000000000000000000000	11713396497097864589658445729600	0x912ce59144191c1204e64559fe8253a0e49e6548	2023-11-30T15:42:09.000Z	226610371494906076898	0x8e682886be181563b42d8dc148b7e7302550f14032a45f58bf54202860535e75	0x912ce59144191c1204e64559fe8253a0e49e6548

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_arbitrum.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
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	9	0x018feadd83a8f2ad4d2508469a3a3215483c4377	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	355000000000000000	0x3082cc23568ea640225c2467653db90e9250aaa0	116754151	2178472521886138877230	2023-07-31T12:31:01.000Z	0x0d143a87713f83aa1e25fde058f1115cadcd3a7e660542bfbeac669f6ee0d4f2	12	2175858354859875510577
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	10	0xdd94018f54e565dbfc939f7c44a16e163faab331	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3432852417034389	0x3082cc23568ea640225c2467653db90e9250aaa0	116694845	21178008373239300733	2023-07-31T08:22:42.000Z	0x0e3934365d162f6dd176dad5cfbc36d7b91d67d31c7debd83cea49dbb808dc97	12	21152594763191413572
0x304951d7172bcada54ccac1e4674862b3d5b3d5b	false	17	0xdd94018f54e565dbfc939f7c44a16e163faab331	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	537892375629844119	0x3082cc23568ea640225c2467653db90e9250aaa0	116827625	3329019023421998761049	2023-07-31T17:41:47.000Z	0x3c9f978534bd4635ac9127d76c9a28f4166b7bd1cd0e35b60f4570c0e834d057	12	3325024200593892362535

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

StakedMlpTracker_Claim_event

StakedMmyTracker_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

​StakedMlpTracker_Claim_event

​StakedMmyTracker_Claim_event

​Vault_CollectMarginFees_event

​Vault_CollectSwapFees_event

​Vault_DecreasePosition_event

​Vault_IncreasePosition_event

​Vault_LiquidatePosition_event

​Vault_Swap_event

Tables

StakedMlpTracker_Claim_event

StakedMmyTracker_Claim_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePosition_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_Swap_event