mummy_v1_optimism

Tables

StakedMlpTracker_Claim_event

Reward claim events from Mummy Finance’s staked MLP (Mummy Liquidity Provider) tracker contract on Optimism. Used to analyze staking reward distributions and user claiming 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
0xc2c5968e16ec9fabc39e27f9abfc07c8cfba6f16	false	1072224674370943376	34	0x06f07090afdf5deceab8c434e324adc07a7b0376	107849094	2023-08-06T04:42:45.000Z	0xbf8d30f72a685be39a2085553c7589aac6ee0eb167f25fae3e8e1a811e1c17cc
0xc2c5968e16ec9fabc39e27f9abfc07c8cfba6f16	false	468213730920992669	38	0x1eb601191f801c82cdea148ab595b82e88c8a4bc	107869468	2023-08-06T16:01:53.000Z	0x5c0d4dbc43a40e819a2953dd33da5961653c0b0f96f22cdfab0e551a01437712
0xc2c5968e16ec9fabc39e27f9abfc07c8cfba6f16	false	161567253500403779	55	0x2a7d9f22f7c75589cc7be54347247b3063b1654d	107879541	2023-08-06T21:37:39.000Z	0x7b906daafffdfea4caba52d4a2cc4c4674ceb931c17763df51b6bb85cb7f7ad2

Example Query

Query with partition filter

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

StakedMmyTracker_Claim_event

Claim events from Mummy Finance’s staked MMY (Mummy token) rewards tracker on Optimism, recording when users claim their staking rewards with receiver addresses and claimed amounts. Used for analyzing staking reward distribution patterns and user claim 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
0x04f23404553fcc388ec73110a0206dd2e76a6d95	false	91037973788241001	3	0xd1421ae08b24f5b24fa97980341dabcadeed3873	99535304	2023-05-18T13:46:50.000Z	0xfe049e99b64968f070dbc901111df021e682520fa6d645d44d38cfe8cba18e17
0x04f23404553fcc388ec73110a0206dd2e76a6d95	false	9439095893634358	3	0xcc7f328b5e05073913ded9e7e7789901dd6ec47e	99511865	2023-05-18T12:31:24.000Z	0x80ea95cb412457499c337472d97d73f91bd151e7427c330f68437e0c66db2fe2
0x04f23404553fcc388ec73110a0206dd2e76a6d95	false	12266197753912749	3	0x9b9e8bc43c15559653868587a193bd014dff5c65	99328398	2023-05-18T06:20:03.000Z	0x163e86a6c89945987712ba91cf1d3f0d6058ff348f4458d58f0dd16a1ea5c720

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x8700daec35af8ff88c16bdf0418774cb3d7599b4	16317818181818181818180000000000	29	96211364	6532353155251473906	2023-05-03T22:58:35.000Z	0x00ce66e044627393f646414f77a01b7da48923f225d11f8d08f32b1a715c9074
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	16363636363636363636362500000000	13	96211364	16363636	2023-05-03T22:58:35.000Z	0x00ce66e044627393f646414f77a01b7da48923f225d11f8d08f32b1a715c9074
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	133992014237454545454541899477350	13	96121612	133992014	2023-05-03T13:31:52.000Z	0x04d54a5770e4f2235cc2cbd6f573f8cd26a930452642219c73bfcbf217d7b1d2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	556719505067040000000000000000	11	85557909	74413813600000000	2023-04-02T09:39:09.000Z	0xfc98369a8cfa72784e9ce21a525d7b478b807c6922a9a827a13806f9b00b81be
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	178055828053067136007600000000	12	85669216	24403243798731859	2023-04-02T19:00:40.000Z	0x4fb22265ab603a2b1bf7291c80a4933aef332b6745a45e417d641127f1b14b74
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	372408496472961062432500000000	12	85593228	50213509940397905	2023-04-02T12:43:36.000Z	0x7a25b5a19187cae4086171fecb0453fb27fbbd171e8c5dc273f53028f1e064f0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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
114508427184466019415937245195000	0x0229c02cb239e66525e435e14e02691936cdb7181baafa01a757c464c05bf16c	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1784190000000000000000000000000000	false	5	0x90a15abb59f9032b45bba254c6de8d16495d51e4	85675649	87611650485436893202706385000000000	0x4200000000000000000000000000000000000006	2023-04-02T19:39:05.000Z	0x7639811422236c794acf871dda6c8b428258f609abf1ed674e92bd2faf807fe2	0x7f5c764cbc14f9669b88837ca1490cca17c31607
128751304347087378639658253355000	0x228015f0700883292abc20f05b9788d437685a364f9dccc0884bf86000e1e499	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1784190000000000000000000000000000	true	5	0x7c3c1cf0d68e0b53df148f38116b7a6babc7af2b	85675543	88004992718446601940983085000000000	0x4200000000000000000000000000000000000006	2023-04-02T19:38:35.000Z	0x7bb45a5238ec32d01c37e13f14bad14fddc714a103ab3ed8509d7c5a54c50e47	0x4200000000000000000000000000000000000006
8998464708658250512284936295000	0x87f7c4917617762bb8db8e7430c4f9bf30e114f6e8fadc1b6317b4c72fd90168	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1817225000000000000000000000000000	true	17	0x0fccc86490badac5758e90264e4197aab72521ac	85500395	8918200900553271072631255000000000	0x4200000000000000000000000000000000000006	2023-04-02T03:25:10.000Z	0x4eb83546be1211053abb5cf52dd53a269fe2f43139a9f09f54e1fc20ba62fd55	0x4200000000000000000000000000000000000006

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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
4031522737515000000000000000000	0xe33c6ede535bc2086bd965e20e8d75d1612485c199ca27bbdd9a89c90b2f1de7	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	38092500000000000000000000000000000	true	20	0x7f825692dfae7107d16bf4e2071fe06b1bc72297	112804120	4031522737515000000000000000000000	0x68f180fcce6836688e9084f035309e29bf0a2095	2023-11-28T21:30:17.000Z	0x4c1b34261630e4989b71d0c753de8ef17ef1e42c4f58c840b0512c6c9ce02a9f	138448334025000000000000000000000	0x68f180fcce6836688e9084f035309e29bf0a2095
7709958229044000000000000000000	0xe33c6ede535bc2086bd965e20e8d75d1612485c199ca27bbdd9a89c90b2f1de7	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	37388750000000000000000000000000000	true	30	0x7f825692dfae7107d16bf4e2071fe06b1bc72297	112791232	7709958229044000000000000000000000	0x68f180fcce6836688e9084f035309e29bf0a2095	2023-11-28T14:20:41.000Z	0xc7bca63eac11b777aa7c1dc97e57e87ce23c27fab6201337520d6f8a67b8125a	199959895537500000000000000000000	0x68f180fcce6836688e9084f035309e29bf0a2095
494278846153846153845364312500	0xec5a21bb9cbea52a14dfed18e0a7fc938dd74d7c768698c87d7cce3ee187c868	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1282500000000000000000000000000	true	21	0x4408e04e4d8aeb7edbc0bc0ae66028762fdf29e5	110557040	493269230769230769229980000000000	0x4200000000000000000000000000000000000042	2023-10-07T21:07:37.000Z	0xf97f8ba5cd991be31ad14d00360b3f4441b80545c3029aa42edc4432caf4cedb	12825000000000000000000000000000	0x4200000000000000000000000000000000000042

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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
0xf9a740e242db24051d745590aa9cc74d5df8c7990f6120eff94b329bbf622d5c	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	469914634146341463413532000000000	false	true	5	0xf3f925dae7cbf25621326b7782589ad5ae82062d	87197213	7134900000000000000000000000000	9484082704154058536586468000000	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	2023-04-07T07:34:39.000Z	65297663328887857071	0x75a664805c2f4b1bd194ca763e08fb22a3149fc1b7b3cf7c4c3062cfce1dde0c	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6
0x8875d09cc7a83b08bf0f75a74e97ee6503ac8633fa769449a78dc86aca29d88d	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	941911301321451959018271550000000	false	true	13	0x7547803d25da013ee66c13aa29a11d931008223b	111040551	1167300000000000000000000000000	32359960431757910164205970203000	0x4200000000000000000000000000000000000042	2023-10-19T01:44:39.000Z	784095638385257359749	0x3ad711971ce90c1feb8bed4d626693ac398611fb73682569547e876fb4466cdc	0x4200000000000000000000000000000000000042
0x921ded92209d09f02cf4fbdb838bb866f8ee5d76c68a0751feec56f460f2da19	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	216621252676273096043350000000000	false	true	26	0xcf2a8b8563ee046bccbf33fc58c6d29b1db0c6ae	111040566	1155000000000000000000000000000	14422655168553411841956650000000	0x4200000000000000000000000000000000000042	2023-10-19T01:45:09.000Z	177849961146365431891	0xf24a77e1033357a73da88343bcccd602d272890fb83f97ff69a5787939f52519	0x4200000000000000000000000000000000000042

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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_amountOutAfterFees
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	74	0xf0694acc9e941b176e17b9ef923e71e7b8b2477a	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	2017247150	0x8700daec35af8ff88c16bdf0418774cb3d7599b4	97269044	925342729000000000000	2023-05-10T15:42:49.000Z	0x5a67a1926f4d082d6f2c3d54ac7514c6350ddf63bf0b0581b477d6c2f4b82c1a	925342729000000000000
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	11	0xf0694acc9e941b176e17b9ef923e71e7b8b2477a	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	642622	0x8700daec35af8ff88c16bdf0418774cb3d7599b4	97277494	296617000000000000	2023-05-10T17:07:38.000Z	0xe83d8822c5f4449cf66870c8e08a7c5c7acf5cf83b275a983cada9ae61296574	296617000000000000
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	10	0xf0694acc9e941b176e17b9ef923e71e7b8b2477a	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	7501958	0x8700daec35af8ff88c16bdf0418774cb3d7599b4	97276216	3457330000000000000	2023-05-10T16:52:39.000Z	0xa05f45b74337d507af5c44181b06e695c7bd4518c8fe14bd31bafd3b15c4cbd2	3457330000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_optimism.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