mummy_v1_fantom

Tables

StakedMlpTracker_Claim_event

Reward claim events from Mummy Finance’s staked MLP (Mummy Liquidity Provider) tracker contract on Fantom. Records user withdrawals of staking rewards with amounts in wei and recipient addresses for analyzing yield distribution and staker activity.

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
0xffb69477fee0daeb64e7de89b57846afa990e99c	false	466020136692370553	7	0x2c7f40ba6099448d14b3ebb229e677f2389afb3c	62228251	2023-05-13T21:50:46.000Z	0x3736fd882b54fe8db4766dac739d28fd10fd96a3c14d108b7262771311f373f4
0xffb69477fee0daeb64e7de89b57846afa990e99c	false	178845510445332296	7	0x92eb27db200cda8c6dff28761ee61ddea5030ef2	62207030	2023-05-13T16:03:33.000Z	0xc58e093a866e809e35ab9a953169f07e4d8060f73dc763e94072d0e12bac1e04
0xffb69477fee0daeb64e7de89b57846afa990e99c	false	10068800306500405233	7	0x6fb737d1ebb73cda6cfa36fd16d9273065d1b084	62165306	2023-05-13T02:58:24.000Z	0x1ed50e9cae389fee2b26c541bc404b0821bb4b03171a8cdbde91f551d6fe0264

Example Query

Query with partition filter

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

StakedMmyTracker_Claim_event

Reward claim events from Mummy Finance staked MMY (Mummy token) tracker contract on Fantom. Records individual claim transactions with reward amounts and recipient addresses for analyzing staking yield distribution and user 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
0x727db8fa7861340d49d13ea78321d0c9a1a79cd5	false	668172478815630659	3	0x5b3067c5e26fec823d6fbf8f315e43632658d2f6	59845406	2023-04-13T21:47:47.000Z	0xde69cf87d959d6147cad259d4bd0e8b359d79729871443aed8618bf39f552e73
0x727db8fa7861340d49d13ea78321d0c9a1a79cd5	false	592278398852868332	3	0xceae93bc099e386353b652b7e254defe52555883	59839187	2023-04-13T20:03:02.000Z	0xed3e653763ea8e48a48e0b5cb6fb6ec6f457addbe223fa79cd160207c3edb052
0x727db8fa7861340d49d13ea78321d0c9a1a79cd5	false	2113141376337716323	3	0x26384bac62582eca0062cef1028a1610ae500620	59848085	2023-04-13T22:31:51.000Z	0xe5cbf0cfb7c1fd8ba9f398c33a0c398fe54e445e74b3c13713869e8b7166ffa1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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	0x04068da6c83afcfa0e13ba15a6696662335d5b75	16013290298930670655787213103000	1	55663900	16013290	2023-02-13T00:08:37.000Z	0x492689ad729276bcf5a70aad8e7ad940664b859430f75a54944b14f97e6d88ae
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	2684322077330097087378406912000	1	55694366	2684322	2023-02-13T11:05:31.000Z	0x5d04309041b10ad69d6ca242485d81f9f91df8a06c90c8aa887b884a2965c489
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	250757110198834951456013480000	1	55673003	250757	2023-02-13T03:21:26.000Z	0x1c9b8db2e537ab448105eb1004a02357b664973229871b1e6f84e399ff2c0537

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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	0x04068da6c83afcfa0e13ba15a6696662335d5b75	22642718123160000000000000000	256	62457258	22644	2023-05-16T17:42:50.000Z	0x4c82a4a4cdde62bd3e99d514471d36e6e9d7e320215ce9af6bcc2d92bfd1b793
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	38997792210000000000000000000	1	62444746	39000	2023-05-16T13:45:51.000Z	0xc27fbc5bd752f7c2a758302564eafb57b32393702ee360bccd01875d935e7795
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	12828273750310000000000000000	2	62412265	12829	2023-05-16T03:17:15.000Z	0x018a1a71667851f91e1086dd8c37b87f3de46183fd9bcf4cbf46fddf8c33a1f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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
944499523355576739752026572855	0x040859ba90ea12227c9cdb30a10cc9e2643be7656a9c6e2d44c124442f2833a2	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	291250000000000000000000000000	false	18	0x7996a4439bcd5f805b0580c2ea7778b5b7095670	63744889	934223069590085795996069805000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-06-07T23:04:46.000Z	0x98ea3b0868a3e728c353a8388fb3d14890fe4225c2cb68cbf3501afc6e1004b2	0	0x04068da6c83afcfa0e13ba15a6696662335d5b75
44108510304738259200000000000000	0x09edf34ab778caf7221dd9ecb98569ade4960c2fb8ee24ac7c9c7ef151d2baab	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	26546050000000000000000000000000000	false	16	0x30b12942912cee5a719edec2dd147224fcc373a0	63716494	1877517145734400000000000000000000	0x321162cd933e2be498cd2267a90534a804051b11	2023-06-07T10:34:49.000Z	0xa7819ac8cbee573ec23cac59af0340d5a868be28de1ec665f52a0df12dfdf8a2	0	0x04068da6c83afcfa0e13ba15a6696662335d5b75
2660000144592592592592581027200	0x0a3154885bcbc38305130165db1080ec3ecdfc3716cf5b55edaf5c3e32092419	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	290610000000000000000000000000	false	21	0xb7093453241ea7200889fd2bebcda3ece3583348	63728789	2500000000000000000000000000000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-06-07T15:44:32.000Z	0x0ec27fbf1030da63ad10109316c7b18b9599b7db972c8592695a61e71850791c	31155135133046019116183405436416	0x04068da6c83afcfa0e13ba15a6696662335d5b75

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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
605056065058435707645600000000	0x9f6ce96c15e7a46a0368809af5e4894ad51c29e9afe62a7a8e4187e8d6960033	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1256770000000000000000000000000000	true	21	0x30b12942912cee5a719edec2dd147224fcc373a0	51948645	12101121301168714152912000000000	0x74b23882a30290451a17c44f4f05243b6b58c76d	2022-12-06T09:33:23.000Z	0x4f9b8d7b9626f6ce6a2b20d536bddac793df587b6145fe92f9a72d15a14caaf0	11041640999999999705130000000000	0x74b23882a30290451a17c44f4f05243b6b58c76d
405293495873201968116630000000	0x9f6ce96c15e7a46a0368809af5e4894ad51c29e9afe62a7a8e4187e8d6960033	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	1258820000000000000000000000000000	true	100	0x30b12942912cee5a719edec2dd147224fcc373a0	51947707	8105869917464039362332600000000	0x74b23882a30290451a17c44f4f05243b6b58c76d	2022-12-06T08:44:32.000Z	0x75f45b807928f522cdf02babe6870ad42e82f53430772349d38d5f1acebd79e3	7402055999999999601680000000000	0x74b23882a30290451a17c44f4f05243b6b58c76d
1039520958083832335326000000000	0x6cb99966cea3ef2b6f6d0afb97ccb5881ab6b880c642e3788a47a71d17071619	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	247000000000000000000000000000	true	217	0xc137b04b2ecc12169151e0a1e537f71a02d80dc3	51948844	20790419161676646706520000000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2022-12-06T09:45:08.000Z	0x2634d3bd91ac94e250e42607600e2bc163919fcbda255db1560df945498d0037	10374000000000000000000000000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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
0xd59aa2104d0065820f51146746425db59b963da272a7ca55b8911999949f51d8	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	1363636363636363636363234800000000	false	false	16	0x21f30e493991584d3a29ebb499989920caafb5c9	61498064	432400000000000000000000000000	13636363636363636363636765200000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-05-05T01:33:52.000Z	1363636363	0x4c34b143a9495982782de8faa71a574976333433fe2ee4f195f7bdba3fb1a342	0x04068da6c83afcfa0e13ba15a6696662335d5b75
0x597d9e8e1bf31884fc893e520ff8716cdd393868629a4598629821d4547664ad	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	909090909090909090908747650000000	false	false	12	0x656a41eebec46a6f3709783c8c93c2e522d2afeb	61544142	437355000000000000000000000000	9090909090909090909091252350000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-05-05T16:04:44.000Z	909090909	0x90576da4b90cdbebb034908c9ec71ddb876592a188353801459faeb1e4c1dbc1	0x04068da6c83afcfa0e13ba15a6696662335d5b75
0xc1f5204d60388e76ce9fae26be3b5d8d5fdacc25fa347398f5fcee8e532b037f	0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	909090723375000000000000000000000	false	false	20	0x656a41eebec46a6f3709783c8c93c2e522d2afeb	61544100	29574900000000000000000000000000000	9090909276625000000000000000000	0x321162cd933e2be498cd2267a90534a804051b11	2023-05-05T16:03:36.000Z	909090723	0x602be99f8c2e9865e51476393c38cf03ec1f3cae3a3049e324af8c78dd6e1b24	0x04068da6c83afcfa0e13ba15a6696662335d5b75

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mummy_v1_fantom.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	51	0x50cc648e45b84d68405ba0707e94c507b08e593d	0x049d68029688eabf473097a2fc38ef61633a3c7a	49576733	0x04068da6c83afcfa0e13ba15a6696662335d5b75	58275441	49576733	2023-03-24T12:10:58.000Z	0xa519fc74802483347655f8d972ccba97b140a5e8d7f603b8039f29658b2f2255	49576733
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	7	0x0995f3932b4aca1ed18ee08d4b0dcf5f74b3c5d3	0x321162cd933e2be498cd2267a90534a804051b11	385461	0x04068da6c83afcfa0e13ba15a6696662335d5b75	58275361	107299622	2023-03-24T12:09:47.000Z	0xf44050dcba6b1ff04ae9c01fb44c94d8d8ad810f2f5c5fecff68de9eb12c7bb5	107299622
0xa6d7d0e650aa40ffa42d845a354c12c2bc0ab15f	false	7	0x098e61189814e8a9dbb3df4c363ef704eb9e6159	0x74b23882a30290451a17c44f4f05243b6b58c76d	2309190000000000	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	58276097	4114237639200000000	2023-03-24T12:21:22.000Z	0xcff5a1621d12868e6460f9a92d5d06aa34dc841005a2bff9ff1b6d6f94968ec7	4114237639200000000

Example Query

Query with partition filter

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

Vault2_DecreasePosition_event

Position closure and reduction events from Mummy Finance V1 perpetual futures vault on Fantom. Records trader exits with position size, execution price, fees, and collateral changes for analyzing trading patterns and PnL.

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
7643956718368132500000000000000	0xf95d2ba204ccd340203a0e01ec6749bc3c3cfaff49f3b38ba8cc6f44ff960b71	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	26780555000000000000000000000000000	true	117	0x20e14b46d5a6bc9fa3414a3c3de0628081b433fa	69222767	3322015088382500000000000000000000	0x448d59b4302ab5d2dadf9611bed9457491926c8e	2023-10-11T15:44:56.000Z	0x2be4ad852811b17a68e8eeaea14ce04ea1d5cd8f84c9c214639029cce6d0bc10	0x448d59b4302ab5d2dadf9611bed9457491926c8e
1772107049985007121758422766854250	0x3c9655e540a28983fa5dfd44fa14d405a539c0c88f7851e796f424d62497a2cb	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	179055000000000000000000000000	true	20	0xd29932d75b4c7ddce52d9c99262be05252951b42	69210116	58331370967248424021014574287500000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-10-11T06:10:04.000Z	0x0b8865e0dbb7e29d26e68a49255142b6c8f6c179c66f256040af226542b6397c	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83
804889886674777808445966745600	0x9e02b578d1f7e5004d6bced2bbbef4aecd92790395e6cf46bc07a5ae9f52c933	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	180000000000000000000000000000	false	15	0x34f4c58bd278fe92b32e05452ab695383779e938	69224757	800089350571349710184857600000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-10-11T17:08:42.000Z	0xceb26ee83b29deeb5ebc209c88184eac7733a58c32c6f027ee9e9d50e054842f	0xcc1b99ddac1a33c201a742a1851662e87bc7f22c

Example Query

Query with partition filter

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

Vault2_IncreasePosition_event

Position increase events from Mummy Finance V1 perpetual trading vault on Fantom. Captures long and short position expansions with collateral added, size delta, execution price, and fees for analyzing leverage trading 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_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
499075540255684590611819875000	0x17bb03feeb5e2ef9e785688850ac22f3c48136c1b582ca47621ea33a1faec670	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	208422000000000000000000000000	false	86	0x5a462eb8e26a072e2d1b21d845057a39543c3207	67338495	499075540255684590611819875000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-08-23T16:54:31.000Z	0xedee02ee3ed64cbe62a878f7b8be539a762839369a51716f5829fed4b916eeaa	20704563000000000000000000000000	0x1b6382dbdea11d97f24495c9a90b7c88469134a4
36322768204270339003297389750	0x17bb03feeb5e2ef9e785688850ac22f3c48136c1b582ca47621ea33a1faec670	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	209135000000000000000000000000	false	14	0x5a462eb8e26a072e2d1b21d845057a39543c3207	67339147	35324617123758969822073750000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-08-23T17:16:37.000Z	0x1b37b4014c106f4ffa2eb61ecd6f166f9666bcc320d435d3d4166cd64b6511a6	2077210000000000000000000000000	0x1b6382dbdea11d97f24495c9a90b7c88469134a4
2233791999999999999999822285000	0x6950b54bb0a8ed37904b16b9ad0fbe295282624e08cb6977316896d0d94fb38d	0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	207612000000000000000000000000	false	13	0xd9e2a3b80a30cb48eef4dcb4aa8b583182a16b4b	67337755	2233791999999999999999822285000000	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2023-08-23T16:27:26.000Z	0xe1d91407528e78a4959323775507830729f3596d054c0c382ac726f6250c0f8d	24571712000000000000000000000000	0x28a92dde19d9989f39a49905d7c9c2fac7799bdf

Example Query

Query with partition filter

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

Vault2_Swap_event

Token swap events from Mummy Finance vault contract on Fantom. Captures swap amounts, fees, and token pairs for analyzing DEX trading activity and fee structures.

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
0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	15	0x061dc8e41c05207bedd6242ea4b342ef294be359	0xcc1b99ddac1a33c201a742a1851662e87bc7f22c	157108542	0x28a92dde19d9989f39a49905d7c9c2fac7799bdf	67480104	157108542	2023-08-27T08:28:19.000Z	0xd308d54096f02435192b0d9ac6bfe589ef6f54e993624618583e65ae5b528bdc	4	157045698
0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	11	0x061dc8e41c05207bedd6242ea4b342ef294be359	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	12601000000000000000000	0xcc1b99ddac1a33c201a742a1851662e87bc7f22c	67493719	2551538687	2023-08-27T16:22:54.000Z	0x453e2046707da7c1ddc9630d54556afb11557cbe1c6afce11cf4e2e80999424b	32	2543373763
0x7e9e9d925846b110b025041cfdf9942f2c401f4f	false	15	0x1a35c7357bc8d0eb9342d73d4f13c4a6f64ac1d6	0xcc1b99ddac1a33c201a742a1851662e87bc7f22c	159592469	0x28a92dde19d9989f39a49905d7c9c2fac7799bdf	67476360	159592469	2023-08-27T06:17:45.000Z	0xb61df38a727ac12dde06c7919404d457ef7b7087b36fa472d6be33732173ce50	3	159544591

Example Query

Query with partition filter

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

Overview

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

Vault2_DecreasePosition_event

Vault2_IncreasePosition_event

Vault2_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

​Vault2_DecreasePosition_event

​Vault2_IncreasePosition_event

​Vault2_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

Vault2_DecreasePosition_event

Vault2_IncreasePosition_event

Vault2_Swap_event