bmx_v1_base - Token Terminal Docs

Tables

DibsRewarder_Claim_event

Reward claim events from BMX protocol’s Dibs Rewarder contract on Base, tracking epoch-based token distributions to users. Records include user addresses, claimed token amounts, and epoch identifiers for analyzing 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_epoch	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x659458f3b35762416c65184a6d62f66922594198	0xedcf812f75028659db335c7f1f9cb3ab1a16fc17	false	6	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	2483442875597589304531	5	17338620	2024-07-20T09:09:47.000Z	0xde51d5545539a9eaf83687f92042482a065dd36c739fb8a2c895ef3b52c10631
0x659458f3b35762416c65184a6d62f66922594198	0xedcf812f75028659db335c7f1f9cb3ab1a16fc17	false	4	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	2730507249447225936303	2	17338646	2024-07-20T09:10:39.000Z	0xff340f73ebf85758cb8c19d5aa5982370fead8aa850d93c5857bd4809c66943e
0x659458f3b35762416c65184a6d62f66922594198	0xedcf812f75028659db335c7f1f9cb3ab1a16fc17	false	2	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	1816919874365473756947	42	17338663	2024-07-20T09:11:13.000Z	0x0bffae7466ccb4b0f3a6b6d6ed71c09447e499be2c4ca435d43b0bb1c1a95f8c

Example Query

Query with partition filter

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

DibsRewarder_Reward_event

Reward distribution events from the BMX protocol’s DibsRewarder contract on Base, tracking token rewards allocated per epoch. Used for analyzing reward distributions, epoch-based incentive programs, and token emission schedules.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`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_epoch	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x659458f3b35762416c65184a6d62f66922594198	false	4	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	8440700000000000000000	100	16224114	2024-06-24T13:59:35.000Z	0x4251598d980350a4580c3b228b08f67ba2d72de4bd32b5595262240e5aeaafc2
0x659458f3b35762416c65184a6d62f66922594198	false	20	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	121147000000000000000	118	21150346	2024-10-16T14:47:19.000Z	0x8ddffaaea94846ab4433aaa8941f8d2cde1f4886d1393bbcece294270edb37f4
0x659458f3b35762416c65184a6d62f66922594198	false	5	0x4e74d4db6c0726ccded4656d0bce448876bb4c7a	8296070000000000000000	75	16527506	2024-07-01T14:32:39.000Z	0x05d7e250ea2e34a7a7580fef76f000a5f12ad8d57a1430cbe61e5d73012b647e

Example Query

Query with partition filter

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

LSSVMPairERC721ERC20_SwapNFTInPair_event

No description available.

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_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_ids`	`ARRAY<STRING>`	Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types.
`in_royaltyAmount`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LSSVMPairERC721ERC20_SwapNFTOutPair_event

NFT purchase events from LSSVM (SudoSwap-style) liquidity pools on Base, recording ERC721 token swaps where users buy NFTs with ERC20 tokens. Contains NFT IDs, payment amounts, royalty fees, and pool addresses for analyzing NFT AMM trading 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_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_ids`	`ARRAY<STRING>`	Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types.
`in_royaltyAmount`	`STRING`	Total royalty fees paid in wei for this NFT swap transaction. Can be zero if no royalties apply to the collection being traded.

Sample Data

in_ids	address	removed	log_index	in_amountIn	block_number	block_timestamp	in_royaltyAmount	transaction_hash
[“2095”,“2097”,“2094”,“2096”]	0x0534be64468b1ca6da180825fd4781f47a539419	false	112	4337585868498530	21418002	2024-10-22T19:29:11.000Z	392541707556428	0x4a509895192099d771164a5d59a072f1d784a86fd2539f77d9046bb3fae7779c
[“716”]	0xafc2c1d58ff277726bbfc791ec6696058ff0a0b3	false	172	93732125834127529	21410249	2024-10-22T15:10:45.000Z	2716873212583200	0x28dcbcfeb3975f1bae6dd4997a993c861368156b20292c34762308035d202908
[“1694”,“495”,“1695”]	0x1b0c6134b4a78977dccdea4e4f0db2cc5edc5db4	false	142	3916189401373898	21418166	2024-10-22T19:34:39.000Z	354406280667321	0x79f4d6da46b78f5b85cfcd0a3cb87c208b0dbdfd495c6186e5cb2b23f5717673

Example Query

Query with partition filter

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

LSSVMPairERC721ERC20_swapNFTsForToken_function

No description available.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_minExpectedTokenOutput`	`STRING`	Minimum amount of tokens the caller is willing to receive from swapping NFTs. String-encoded integer representing the slippage protection threshold in the token’s smallest unit (wei for ETH).
`in_tokenRecipient`	`STRING`	Address designated to receive the tokens from the NFT swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`in_propertyCheckerParams`	`STRING`	-
`out_outputAmount`	`STRING`	Amount of tokens received from swapping NFTs. String-encoded integer representing the token quantity in the smallest unit (wei for ETH).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LSSVMPairERC721ERC20_swapNFTsForToken2_function

No description available.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_minExpectedTokenOutput`	`STRING`	Minimum amount of tokens the caller is willing to receive from swapping NFTs. String-encoded integer representing the slippage protection threshold in the token’s smallest unit (wei for ETH).
`in_tokenRecipient`	`STRING`	Address designated to receive the tokens from the NFT swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`out_outputAmount`	`STRING`	Amount of tokens received from swapping NFTs. String-encoded integer representing the token quantity in the smallest unit (wei for ETH).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LSSVMPairERC721ERC20_swapTokenForSpecificNFTs_function

Token-to-NFT swap transactions from LSSVM (Sudoswap) ERC721/ERC20 liquidity pairs on Base, capturing specific NFT ID purchases with token input amounts and slippage limits. Used for analyzing NFT marketplace liquidity pool trading patterns and price discovery dynamics.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_maxExpectedTokenInput`	`STRING`	Maximum amount of tokens the buyer is willing to spend for the NFT swap. Numeric string representing the token quantity in its smallest denomination.
`in_nftRecipient`	`STRING`	Address designated to receive the NFTs from the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isRouter`	`BOOL`	Indicates whether the function call originated through a router contract rather than directly from a user address.
`in_routerCaller`	`STRING`	Address of the original caller when the swap was routed through a router contract. Hex-encoded, 0x-prefixed, 42-character string representing the end user’s address, or zero address when called directly.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_nftIds	out_anon0	signature	to_address	in_isRouter	block_number	from_address	trace_address	block_timestamp	in_nftRecipient	in_routerCaller	transaction_hash	in_maxExpectedTokenInput
1042726	true	222077	[“3407”,“4025”,“4051”]	2368568755846588	0x6d8b99f7	0xd35ce421f0a6a6b724894bb46a42d646cc0608c0	false	22699022	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0,4,0,3	2024-11-21T11:09:51.000Z	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x51766c45b810678a969dc17120af531aeacad015dfccc90c1b11a811d166415b	2368568755846588
1050820	true	214477	[“4056”,“4044”,“4047”]	2368568755846588	0x6d8b99f7	0xd35ce421f0a6a6b724894bb46a42d646cc0608c0	false	22699155	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0,6,0,3	2024-11-21T11:14:17.000Z	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x2425ab2b5710fd880250ae1b14a03a2cddb550177f7c42471d121a28791e977c	2368568755846588
1034630	true	222077	[“4048”,“4046”,“4058”]	2368568755846588	0x6d8b99f7	0xd35ce421f0a6a6b724894bb46a42d646cc0608c0	false	22695766	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0,5,0,3	2024-11-21T09:21:19.000Z	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x1a94d7d0747019275980eab431d637ee265947b89b09f16bfd54a4812abee269	2368568755846588

Example Query

Query with partition filter

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

MultiAccount_AddAccount_event

Account creation events from BMX protocol’s multi-account system on Base, linking user addresses to named sub-accounts. Used for tracking account management activity and mapping between primary users and their trading sub-accounts.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.

Sample Data

address	in_name	in_user	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	rainbow	0x196ae16a9387a3dc5de811467a2e37d7febed304	false	448	0xf4cc4cd8cd67387cce0f72f0cfa48a52c85e54ab	22121177	2024-11-08T02:08:21.000Z	0x7c43e1145e7b92bf053bf586fde17914c2695c238ea00857ff3f3f6e7999f3e1
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	bmx	0xcbadf6880566bbb360e313cd95d67c8dfde1ab7b	false	270	0xba3f315b9819b4aa804c4e0805c7c8fddf8df491	22153087	2024-11-08T19:52:01.000Z	0x4dfc18e77d6f8d2c9848d61bb14feb8d5eaba60959ab34624eaacb053bb9f690
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	a5	0x0eafbfa3979028e531ac2ea9bfa9f1766d6efa8c	false	155	0x2b5f9fd61930b582430f6a1f575431ac6b8328b4	17261852	2024-07-18T14:30:51.000Z	0xbddc15d40b72c2b22ae0e892c69cd39a52a7955532e87685dd06463218d6ba2f

Example Query

Query with partition filter

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

MultiAccount_Call_event

Event logs from BMX protocol’s MultiAccount contract on Base capturing delegated smart account operations with encoded call data, execution status, and user-account relationships for analyzing protocol interaction patterns and transaction success rates.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__callData`	`STRING`	ABI-encoded calldata representing the function call executed on behalf of the multi-account user. Hex-encoded bytes beginning with 0x, containing the function selector and encoded parameters for the delegated call.
`in__success`	`BOOL`	Boolean flag indicating whether the delegated call execution completed successfully. True when the call succeeded, false when it reverted or failed.
`in__resultData`	`STRING`	ABI-encoded return data from the executed call on the account contract. Empty (0x) when the call completes successfully with no return value.

Sample Data

address	in_user	removed	log_index	in_account	in__success	block_number	in__callData	in__resultData	block_timestamp	transaction_hash
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x567f65992ea5586f917197cb2680dcbc76b751de	false	262	0x30a9e09c78ba867d4cf20d163712c58ead87fdb7	true	19083839	0x501e891f0000000000000000000000000000000000000000000000000000000000016f390000000000000000000000000000000000000000000000013e4d0a7ad85c00000000000000000000000000000000000000000000000000167f482d3c5b1c000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000066d0c286	0x	2024-08-29T18:43:45.000Z	0xae5942ce7e1c3dc5f49df5a5375f07959b6564bc3b7af939e224069f4cdeb27f
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x567f65992ea5586f917197cb2680dcbc76b751de	false	696	0x30a9e09c78ba867d4cf20d163712c58ead87fdb7	true	19083853	0x501e891f0000000000000000000000000000000000000000000000000000000000016f3b00000000000000000000000000000000000000000000000096f9f8dc4f79800000000000000000000000000000000000000000000000002fe8c5c495faf9000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000066d0c2a0	0x	2024-08-29T18:44:13.000Z	0x04cc8dbe2f350854658ede797125a96340af34b2451b2f2661f1e99232464d3e
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x567f65992ea5586f917197cb2680dcbc76b751de	false	230	0x30a9e09c78ba867d4cf20d163712c58ead87fdb7	true	19091001	0x7f2755b200000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000002f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000050ef6d19ca14000000000000000000000000000000000000000000000000005cea873ed6bb8800000000000000000000000000000000000000000000000000056b3af6f2598a0000000000000000000000000000000000000000000000000002b59d7b792cc5000000000000000000000000000000000000000000000000003b9b889c69d8ee0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ad78ebc5ac620000000000000000000000000000000000000000000000000000000000000795b11bf00000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000000010000000000000000000000009206d9d8f7f1b212a4183827d20de32af3a23c5900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000066d0f944ffffffffffffffffffffffffffffffffffffffffffffffea0170e67ebe9bba2400000000000000000000000000000000000000000000000050e5ef5e1177c000000000000000000000000000000000000000000000000000000000000000014012b989a51ce9312531c62f2a7dbabe4812539ce6532ebe00eb4cd5ab375f96c90000000000000000000000008a59b05281ac699321d93974a228e7ec0a2c9357000000000000000000000000ec663d5be6478617f17fdb14fe7ce126877442420000000000000000000000000000000000000000000000000000000000000020d97a47052abc201b6b1c45d98c3a60662cdd0faff5d82966d52a5c5c219aab890000000000000000000000000000000000000000000000000000000000000041cd5b915c9f1ddf5231eceb588615b543ef4247bbb872bff4e7d880af4e5c425f7d2ab68d11fd75663e556e38ea9a09a338189f6ba626516907fcb71839645a541c00000000000000000000000000000000000000000000000000000000000000	0x	2024-08-29T22:42:29.000Z	0x484a0cef9a7bcaef93b59a52bfcdcc1e15432d3d8dff4eba3f6ef084612e4ff7

Example Query

Query with partition filter

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

MultiAccount_DepositForAccount_event

Deposit events from BMX (Base) protocol’s MultiAccount contract tracking when users fund trading accounts. Used for analyzing capital flows, account funding patterns, and user deposit behavior across the platform.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0xd1a0b66835d830e9ada42eef436f3aa8005b20b5	false	60296400	821	0x9128c89194720cbc2143f38851ddf50ffefdda5e	22455833	2024-11-15T20:03:33.000Z	0x7c238452833e97c59079375cfe16898ba5d1ed744fca6413dd1cefa17e08b55f
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x567f65992ea5586f917197cb2680dcbc76b751de	false	900000000	445	0x30a9e09c78ba867d4cf20d163712c58ead87fdb7	22446534	2024-11-15T14:53:35.000Z	0x7b13e2e68b06fbf81411ceffb7bb9d3b591e5a1522b452b2b3ca9747a82bdf34
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x567f65992ea5586f917197cb2680dcbc76b751de	false	2200000000	470	0x30a9e09c78ba867d4cf20d163712c58ead87fdb7	22441633	2024-11-15T12:10:13.000Z	0xceb4c5e3651f808e7479dd816be8847b675b67aefe65def55e733a9a6546284a

Example Query

Query with partition filter

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

MultiAccount_WithdrawFromAccount_event

Withdrawal events from BMX protocol’s MultiAccount contract on Base, capturing fund movements from sub-accounts to user wallets. Used for tracking account balance changes and analyzing withdrawal patterns across trading accounts.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0xa119dd8285463e176065fefd7e91248ae19caa1f	false	126230250	223	0x752cf723da35d94388dba1c473f008e6b51d0821	22535813	2024-11-17T16:29:33.000Z	0x5bbb5dd1cfe7c1cc3b689bf5a359b32365b0c3797d27d4271986a29959ea5b46
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x13ed158678455526778249c3ef39ab75e27a3c60	false	969471431	286	0xfa9ceb6d51e6d83f0f633bd6cbcee8d961d806f3	22536241	2024-11-17T16:43:49.000Z	0x6eecb92a48d5b3b86a34b5aee0317418d454ee8c9856705cc0f51bce3b9a95fd
0x6d63921d8203044f6abad8f346d3aea9a2719ddd	0x9c5c92138a920462174df83028860d852b849bb0	false	514232495	124	0x5723cb0d37fe704d262c60f425701680075c3da9	22547736	2024-11-17T23:06:59.000Z	0x2efe0f70d913140067ef4929c0956d5953d1a45bf80624122c4381ef2484b7d7

Example Query

Query with partition filter

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

RewardDistributor_Distribute_event

Reward distribution events from the BMX protocol on Base, capturing token payouts to recipient addresses with distributed amounts. Used for tracking protocol incentive programs and analyzing reward allocation patterns across participants.

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_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	block_number	block_timestamp	transaction_hash
0x1d556f411370e5f1850a51eb66960798e6f5edec	false	88	231	17102081	2024-07-14T21:45:09.000Z	0x50e3cf17e1b6eba2b9acc863c8f7b228c2c3b714ee7691e288e1d392b1fe05fe
0x06c35893ba9bc454e12c36f4117bc99f75e34346	false	982142857142480	235	17102081	2024-07-14T21:45:09.000Z	0x50e3cf17e1b6eba2b9acc863c8f7b228c2c3b714ee7691e288e1d392b1fe05fe
0x06c35893ba9bc454e12c36f4117bc99f75e34346	false	133928571428520	151	17065986	2024-07-14T01:41:59.000Z	0x3bc32eabd75afeea393a2af9e9f8ec949d1d02a938c1b364a735a4d9880a3a9b

Example Query

Query with partition filter

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

SudoFactoryWrapper_createPair_function

Liquidity pool creation events from SudoSwap (BMX) NFT automated market maker on Base, capturing pair deployments with NFT collection addresses, bonding curves, pricing parameters, and initial liquidity deposits. Used for tracking new pool launches and analyzing AMM configuration patterns across NFT collections.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__isBuy`	`BOOL`	Indicates whether the pair is configured for buying NFTs (true) or selling NFTs (false). Determines the directionality of trades in the liquidity pool.
`in__nft`	`STRING`	Contract address of the NFT collection. Hex-encoded, 0x-prefixed, 42-character string.
`in__token`	`STRING`	Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string.
`in__bondingCurve`	`STRING`	Contract address of the bonding curve implementation used for pricing calculations. Hex-encoded, 0x-prefixed, 42-character string.
`in__delta`	`STRING`	Delta parameter for the bonding curve pricing function. Numeric string representation of the price change rate or step size between consecutive NFT trades.
`in__spotPrice`	`STRING`	Initial price point for the bonding curve pricing function. Numeric string representation in wei or smallest token denomination.
`in__lockDuration`	`STRING`	Duration in seconds that liquidity will be locked in the newly created pair contract. Common values include 86400 (1 day), 345600 (4 days), 432000 (5 days), and 604800 (1 week).
`in__initialNFTIDs`	`ARRAY<STRING>`	Array of NFT token IDs used to seed the newly created liquidity pair. Typically contains 1-10 NFT identifiers that are deposited into the pair contract upon creation.
`in__initialTokenBalance`	`STRING`	Initial token balance deposited into the newly created liquidity pair, denominated in the smallest unit of the specified token. Typically zero when creating NFT-only pools, as seen in sample transactions.
`out_pairAddress`	`STRING`	Contract address of the newly created liquidity pair on Base. Hex-encoded, 0x-prefixed address returned after successful pair creation with specified NFT collection and token parameters.

Sample Data

gas	status	in__nft	gas_used	in__delta	in__isBuy	in__token	signature	to_address	block_number	from_address	in__spotPrice	block_timestamp	out_pairAddress	in__bondingCurve	in__lockDuration	transaction_hash	in__initialNFTIDs
803702	true	0xec050653efc1e94f0d24cf8a1793ff6bfd396c98	753329	100000000000000	false	0x4200000000000000000000000000000000000006	0x87331126	0x13918a541e129a7ef210183e5e9c54486da3fb04	21716755	0x60626dbf9b36e89490c4e0a471466e1802107443	3825417075564279	2024-10-29T17:27:37.000Z	0x3f55370ce541a68976d2ad933376bd0b68c0ca8b	0xe41352cb8d9af18231e05520751840559c2a548a	345600	0x82c845f30c6423c4edffabbaf0d6ff43d8c1be4d5281bae900ff144c491e3fbd	[“1196”,“1195”,“1194”,“1192”,“1193”]
858721	true	0x2d7ca40749c2641ce0654ca1a99f0f47fe283869	803386	0	false	0x4200000000000000000000000000000000000006	0x87331126	0x13918a541e129a7ef210183e5e9c54486da3fb04	21716797	0x60626dbf9b36e89490c4e0a471466e1802107443	45142296368989206	2024-10-29T17:29:01.000Z	0x5f061b088d3e92fedbb3804b53e2cdcc2f06efbd	0xe41352cb8d9af18231e05520751840559c2a548a	432000	0xa6ad787e44fde26a5281e6b4a526202bff1bf2c74498578dfca824ae3670eed7	[“2296”,“2082”,“2055”,“1995”,“1996”,“2034”]
545287	true	0x9859ffab1cfeafa149408aa6b5a9fc7e50054265	494245	0	false	0x4200000000000000000000000000000000000006	0x87331126	0x13918a541e129a7ef210183e5e9c54486da3fb04	21716775	0x60626dbf9b36e89490c4e0a471466e1802107443	39254170755642788	2024-10-29T17:28:17.000Z	0x94eb0516c1ed59af0234c8633ed155590f404943	0xe41352cb8d9af18231e05520751840559c2a548a	604800	0x19cc703aa0c0d773ab118abd48761edc5712444862d21242673fd3d8964994be	[“811”]

Example Query

Query with partition filter

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

SudoFactoryWrapper_PairCreated_event

Trading pair creation events from the BMX SudoFactoryWrapper contract on Base, capturing when new liquidity pairs are deployed with creator addresses, unlock timestamps, and buy/sell direction flags for analyzing pair launches and liquidity provisioning 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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_unlockTime`	`STRING`	Unix timestamp indicating when the liquidity pair will be unlocked and can be withdrawn. Stored as a string representation of seconds since epoch.
`in_isBuy`	`BOOL`	Boolean flag indicating whether the newly created pair supports buying operations. Typically false in these samples, suggesting pairs configured for sell-only or liquidity provision modes.

Sample Data

address	in_pair	removed	in_isBuy	log_index	in_creator	block_number	in_unlockTime	block_timestamp	transaction_hash
0x13918a541e129a7ef210183e5e9c54486da3fb04	0x4a86428445aea0dded258b423d4b45ea257a50bc	false	false	407	0x19145b49fd5e4c345822a4a83fe5543c5bbb785c	21539337	1730472821	2024-10-25T14:53:41.000Z	0x5de40384097a8b5d249313b1e11bf76ca843b4e9a33cd3c61f66a778a756e153
0x13918a541e129a7ef210183e5e9c54486da3fb04	0x7bcde491758bff14465a6c3d9cbdd18a1e765ae2	false	false	353	0x47ade238cc739dbce060c572e7393467ed6f0c50	21542162	1730219271	2024-10-25T16:27:51.000Z	0x401ef7d79ca670bd8e073600c34598114420af4254b458c3ec48bb8f08de300b
0x13918a541e129a7ef210183e5e9c54486da3fb04	0x0930b225ff39868672f5f61a8fcf6bc691e80b77	false	false	49	0x48e53189a4aff640ce484d89b270c4aedfe4e7cc	21531752	1729939251	2024-10-25T10:40:51.000Z	0xcfb5f705237610516bf027e6c76b6cc45b9994fa087a90f47ea5c1ac9ee1b795

Example Query

Query with partition filter

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

SudoVRFRouter_AllowListHookUpdated_event

Configuration change events for SudoVRFRouter’s allowlist hook on Base, tracking updates to the hook contract address used for VRF (Verifiable Random Function) request validation. Useful for monitoring access control changes and VRF router security configuration.

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_newAllowListHook`	`STRING`	Contract address of the newly configured allowlist hook in the SudoVRF router system. Hex-encoded, 0x-prefixed 40-character string that references the hook contract controlling access permissions.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newAllowListHook
0x68d493a7daae88b296026e667cb1f2e82fa466d3	false	128	21982944	2024-11-04T21:20:35.000Z	0x57fdd5a4c40f2c4b864a8693f7d45042493734464ba70e3b083d90d2ea5cd10c	0xfc33ccf5159817e244aa0cea19dfaf6249865489
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	false	91	21022417	2024-10-13T15:43:01.000Z	0x2ea737be4116baa8aceee6b37b08ecf181c066bd7a78b52916077a0c3c697ec3	0xfc33ccf5159817e244aa0cea19dfaf6249865489
0xefdd8c665973ed4839aeb0de4667f9b5613bd936	false	150	22919046	2024-11-26T13:23:59.000Z	0x00e899dff4dfc3f367ae88f9b7d70c611aea64627f0f5cde226e4f8626526258	0xfc33ccf5159817e244aa0cea19dfaf6249865489

Example Query

Query with partition filter

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

SudoVRFRouter_FeeConfigUpdated_event

Fee configuration change events from the SudoVRF Router contract on Base, tracking updates to VRF (Verifiable Random Function) service fees and recipient addresses. Contains fee amounts in wei (typically 0.005-0.014 ETH) and the designated fee collection address for analyzing protocol fee structure changes.

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_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.
`in_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	in_feeRecipient	transaction_hash
14000000000000000	0xdbb4659f919cadf4f0bb87d02477a739b96326fe	false	59	21126813	2024-10-16T01:42:53.000Z	0xb720da1307d62e6c55ff30568657db753e5af11b	0xc0c18242ad4da855cbe294918bab15783c5c6a1c970d645e78fbd7514288dcee
14000000000000000	0x68d493a7daae88b296026e667cb1f2e82fa466d3	false	58	22091914	2024-11-07T09:52:55.000Z	0xb720da1307d62e6c55ff30568657db753e5af11b	0x7dfd71fffdefe2faa7df6dc28aa9131a2c0c91552fc40927f399d7857fdc19fb
5000000000000000	0xbd9bbd45478259f513908c42ddf66de959fbdeea	false	71	32264401	2025-06-30T21:15:49.000Z	0xb720da1307d62e6c55ff30568657db753e5af11b	0x0da425a545078ee9cdb251aacf1b596547919d9f9075fbc605b530044e027c2f

Example Query

Query with partition filter

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

SudoVRFRouter_FeeTransferred_event

Fee transfer events from SudoVRFRouter contracts on Base, recording payments from liquidity pairs to recipients with transfer amounts. Used for tracking protocol fee distributions and revenue flows from VRF (Verifiable Random Function) router operations.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pair	removed	in_amount	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x6743a10d8ea5c72ff5277f1d36dbca87d73f09ae	false	247301275760550	306	21186918	0xb720da1307d62e6c55ff30568657db753e5af11b	2024-10-17T11:06:23.000Z	0xd7881e4f5d9de2262c400e70a31b6261f73241ca5c81ccc5f405dd55e8473379
0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x8fb90246ba27156cdac8a35e23efa7e9b871b253	false	523408793264734	525	22463827	0xb720da1307d62e6c55ff30568657db753e5af11b	2024-11-16T00:30:01.000Z	0xf0527e771f0e5b321ce183ae72d6baa1a365ed81dc928087984a9f1b14412c2c
0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x8fb90246ba27156cdac8a35e23efa7e9b871b253	false	1235817586529467	124	22479090	0xb720da1307d62e6c55ff30568657db753e5af11b	2024-11-16T08:58:47.000Z	0x2b55aebd5daf69f6072e317a81b2a4fcf516218ab1bf444c517158d77afab9b3

Example Query

Query with partition filter

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

SudoVRFRouter_NFTsBought_event

NFT purchase events from SudoVRF (Verifiable Random Function) router on Base, capturing buyer addresses, NFT token IDs, pair contracts, and final prices paid. Useful for analyzing NFT trading activity and liquidity pool performance across automated market maker pairs.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_finalPrice`	`STRING`	Final price paid for the NFT purchase in the smallest denomination of the payment token (e.g., wei for ETH). Values are string-encoded integers representing the total cost for all NFTs in the transaction.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.

Sample Data

address	in_pair	removed	in_buyer	in_nftIds	log_index	block_number	in_requestId	in_finalPrice	block_timestamp	transaction_hash
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0xfbc17aacdfdb7eccc19cfb017d2f9b228ce6c7fd	false	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	[“1138”,“1068”,“1137”]	95	21120403	114447101145039863029431238128112623424783712466999536693047169686480029923792	30000000000000003	2024-10-15T22:09:13.000Z	0x8cb245c38a96b4d3d27611179dbc26ec0a8cd07b682b11b77112122cb5b8ed40
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x28f07f6a057b60a960d26ef1585adefdc722ae77	false	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	[“20615”]	190	21108886	32251788154325387264132300886374727208456979228645415950584141237786655932758	1000000000000001	2024-10-15T15:45:19.000Z	0x18771327cbd2bf687e171be229d417e355414d4a199e874300c4cf2c0b112deb
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0xeecc2335fea30036fcf21c9da06b917d9da6cdfd	false	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	[“41958”]	57	21123666	82406342094672812440567844651230961939563862438303442842496902786412098299545	1000000000000001	2024-10-15T23:57:59.000Z	0xbb49b9ff31007de79c1227b4cf7a329c0e74c0c7a5329f761d908a76e52333d0

Example Query

Query with partition filter

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

SudoVRFRouter_NFTsSold_event

No description available.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SudoVRFRouter_Refunded_event

Refund event records from the SudoVRFRouter contract on Base, capturing failed or reverted VRF (Verifiable Random Function) randomness requests. Tracks refunded amounts returned to user addresses along with associated liquidity pair contracts for analyzing VRF request failures.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	in_pair	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf3ab2f9d8c27cdca5a100afa4346821ae0a7fd04	0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x99e480a9374611f17489e5b6dfe4074a08873446	false	1000000000000001	471	21937027	2024-11-03T19:50:01.000Z	0x96986a4bfa1205e372f39d0a2fd42b422663c3c2e8d2495cae682f9b4d6ddc41
0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x28f07f6a057b60a960d26ef1585adefdc722ae77	false	1000000000000001	157	21108859	2024-10-15T15:44:25.000Z	0xce5614d093ef3b271d1fe6a21f8c298a69e1ac32de4a9dd66a46f1e2cdee8338
0x0388edc27bcaeed2371efa64e5384f6e0989277e	0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x307a52e98ba6d59f6425e3cff2c6aa6b4d551595	false	3003001000000006	384	21297129	2024-10-20T00:20:05.000Z	0x0b6837022fb6ba2cedde3fbcf20e599fdaa86ae39d58c9db0b99afd59fbaae1e

Example Query

Query with partition filter

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

SudoVRFRouter_RequestCancelled_event

Cancelled verifiable random function (VRF) request events from the SudoVRFRouter contract on Base, tracking user addresses and request IDs for randomness generation withdrawals. Used for analyzing VRF request lifecycle and cancellation patterns in on-chain randomness applications.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.

Sample Data

address	in_user	removed	log_index	block_number	in_requestId	block_timestamp	transaction_hash
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x0388edc27bcaeed2371efa64e5384f6e0989277e	false	385	21297129	82089328955510790925402111574150538233808335860720442552135821588727656598569	2024-10-20T00:20:05.000Z	0x0b6837022fb6ba2cedde3fbcf20e599fdaa86ae39d58c9db0b99afd59fbaae1e
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	false	158	21108859	3268335872574183361914687679705789961337330572591136783890734767446066055050	2024-10-15T15:44:25.000Z	0xce5614d093ef3b271d1fe6a21f8c298a69e1ac32de4a9dd66a46f1e2cdee8338
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0xf3ab2f9d8c27cdca5a100afa4346821ae0a7fd04	false	472	21937027	62995209912841211328384672185966393281714418927548686768178387682628608701587	2024-11-03T19:50:01.000Z	0x96986a4bfa1205e372f39d0a2fd42b422663c3c2e8d2495cae682f9b4d6ddc41

Example Query

Query with partition filter

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

SudoVRFRouter_RequestFailed_event

Failed verifiable random function (VRF) request events from the SudoVRFRouter contract on Base, tracking randomness generation failures with request IDs and user addresses. Used for monitoring VRF service reliability and debugging failed randomness requests in on-chain applications.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.

Sample Data

address	in_user	removed	log_index	block_number	in_requestId	block_timestamp	transaction_hash
0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x67dcd95de5a9c6fc8d5ce883a769095ac7da1e2c	false	306	22727665	69872044330292766091834941150624400719224984848439029837959670123974302519205	2024-11-22T03:04:37.000Z	0xd9b2e11057ef72e3e51cc465d8b2c220e61c6a09e48d47d521de619a52022438
0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x67dcd95de5a9c6fc8d5ce883a769095ac7da1e2c	false	382	22727710	53639902083811920664776528883993186534906958566716348732131531269935910222773	2024-11-22T03:06:07.000Z	0xc6553780fc8ebf3958d4cd2eec140dc9eb05c9da720bc91f6b15879365a38d7d
0x68d493a7daae88b296026e667cb1f2e82fa466d3	0x67dcd95de5a9c6fc8d5ce883a769095ac7da1e2c	false	280	22728986	11677151453513381698126488782080368515187144929478311696573064862968059871699	2024-11-22T03:48:39.000Z	0x090b8fbc672c6f4f771ecba0921fea4a2f6d0df230e35e09ee5db04179cd23e7

Example Query

Query with partition filter

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

SudoVRFRouter_RequestSubmitted_event

Verifiable Random Function (VRF) request submissions from the SudoVRFRouter contract on Base, tracking user-initiated randomness requests with unique request identifiers. Used for analyzing on-chain randomness generation patterns and user activity in gaming or lottery applications.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.

Sample Data

address	in_user	removed	log_index	block_number	in_requestId	block_timestamp	transaction_hash
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x9493fe47c427537788ab7479c59732e310f71739	false	136	21591380	105778618823091554200709387408536917170151306640675585166667989883061285452834	2024-10-26T19:48:27.000Z	0x9a69df222413e5abe9c7cd8762d3b2063ab256d80b9f0c55f4e6189347ab6707
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x48e53189a4aff640ce484d89b270c4aedfe4e7cc	false	80	21924252	96019316972484724080655231925453585412412593492188931998728151992677537768570	2024-11-03T12:44:11.000Z	0x998844069e0f671bd6c1bbf3a14ce534a919ed7cfe25d137f9fc9890b03bf029
0xdbb4659f919cadf4f0bb87d02477a739b96326fe	0x48e53189a4aff640ce484d89b270c4aedfe4e7cc	false	161	21925690	23281639533933458420308704489295027151275958883505127995329740461946573043698	2024-11-03T13:32:07.000Z	0xd1e159adde781ee069e70934216107c8de47f48ad8a9d192f4b82649fd3b8807

Example Query

Query with partition filter

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

SudoVRFRouter_VRFConsumerUpdated_event

No description available.

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_newVRFConsumer`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SymmioDiamond_LiquidatePartyA_event

Liquidation events for PartyA accounts in the Symmio protocol on Base, capturing underwater positions with unrealized losses exceeding allocated balances. Used to track protocol liquidations and analyze liquidator activity and trader risk exposure.

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_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_partyA`	`STRING`	Address of the party initiating or holding the primary position in the trading or liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_allocatedBalance`	`STRING`	Allocated balance of Party A at the time of liquidation, denominated in wei (10^-18 tokens). Represents the collateral amount available before unrealized losses are applied.
`in_upnl`	`STRING`	Unrealized profit and loss (UPNL) of Party A at the time of liquidation, denominated in wei. Negative values indicate losses that triggered the liquidation event.
`in_totalUnrealizedLoss`	`STRING`	Total unrealized loss for Party A at the time of liquidation, denominated in wei (18 decimals). Always negative, representing the aggregate mark-to-market losses across all open positions that triggered the liquidation event.

Sample Data

address	in_upnl	removed	in_partyA	log_index	block_number	in_liquidator	block_timestamp	transaction_hash	in_allocatedBalance	in_totalUnrealizedLoss
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	-17717286240000000000	false	0x1203f5fdfa4457a5563ab91e74bddd8e2ddcc78c	4	20610886	0x6f2f120bd82ca911a3221f228e768248bf93e8f4	2024-10-04T03:05:19.000Z	0x7ac6d3cb12400b3f512a91ca71aa81887c529312a463634a47faffd110839aa4	30190340280000000000	-17717286240000000000
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	-67287499832000000000	false	0xeccac9003ee81405c0f1488991d2b8466a1e8aee	2	20606966	0x6f2f120bd82ca911a3221f228e768248bf93e8f4	2024-10-04T00:54:39.000Z	0xb7499a0506fed07f420fb10e2b93a70c9e17a057a7b980e3cc184741c18bebbd	135386643192000000000	-67287499832000000000
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	-5818831758000000000	false	0xeccac9003ee81405c0f1488991d2b8466a1e8aee	1	20635847	0x6f2f120bd82ca911a3221f228e768248bf93e8f4	2024-10-04T16:57:21.000Z	0x2bead18aa165edc7da748ba2855da54bcd365fc2453a086cb025be170b31b602	13441915728000000000	-5818831758000000000

Example Query

Query with partition filter

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

SymmioDiamond_LiquidatePositionsPartyA_event

Liquidation events from Symmio protocol on Base where Party A positions are forcibly closed by liquidators. Contains liquidated trader addresses, liquidator addresses, and quote IDs for analyzing position liquidations and risk management in the Symmio derivatives protocol.

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_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_partyA`	`STRING`	Address of the party initiating or holding the primary position in the trading or liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteIds`	`ARRAY<STRING>`	Array of quote identifiers being liquidated in this PartyA liquidation event. Each quote ID is a string representing a unique position or order in the Symmio protocol that is subject to liquidation.

Sample Data

address	removed	in_partyA	log_index	in_quoteIds	block_number	in_liquidator	block_timestamp	transaction_hash
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0xf541af3c3ec6d0520ff9827a0457296d64b02b14	3	[“76489”]	14390092	0xd130f10cf0182c32d011a498aca7bb33dd05ac77	2024-05-13T03:05:31.000Z	0xb90946d7a33f7e9b80f9c9e28b45816baafc96b84cc24d775da49de638b8b730
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0x7a2bb8b81a6068a1eb7bd845dbb649c0a4d5224f	4	[“76487”]	14390319	0xd130f10cf0182c32d011a498aca7bb33dd05ac77	2024-05-13T03:13:05.000Z	0xc170c08f616e17d293c9cdb26468c19787ad8b446eb9be4463bda5142794f506
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0x987914519d4c7b785c822742530318cf47d1e5be	8	[“71726”]	14389664	0xd130f10cf0182c32d011a498aca7bb33dd05ac77	2024-05-13T02:51:15.000Z	0x4dc5ff3f78778ae1b1c951dbec618a75ebeb837655c453a376ec3aa10afaee4c

Example Query

Query with partition filter

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

SymmioDiamond_RequestToClosePosition_event

Position close requests from the Symmio Diamond protocol on Base. Captures trader (partyA) and counterparty (partyB) requests to close derivatives positions with specified close price, quantity, and deadline parameters for analyzing exit 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_partyA`	`STRING`	Address of the party initiating or holding the primary position in the trading or liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_partyB`	`STRING`	Contract address of the counterparty (Party B) in the position close request, typically representing the market maker or liquidity provider. Hex-encoded, 0x-prefixed 40-character Ethereum address.
`in_quoteId`	`STRING`	Unique identifier for the trading quote or position being requested to close within the Symmio protocol. Numeric string representing the specific quote record, such as ‘17773’ or ‘18282’.
`in_closePrice`	`STRING`	Proposed closing price for the position, denominated in the quote asset with 18 decimal places of precision. Value is stored as a string-encoded integer representing the raw wei amount (e.g., “989950000000000000” = 0.98995 tokens).
`in_quantityToClose`	`STRING`	Quantity of the position being requested to close, denominated in the smallest unit of the asset (wei-like precision). Values represent the absolute size of the position portion to close, typically ranging from fractional amounts to thousands of tokens.
`in_orderType`	`INT64`	Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_quoteStatus`	`INT64`	Status code of the trading quote at the time of the close position request. Numeric identifier (typically 5 in samples) representing the quote’s lifecycle state in the Symmio protocol.

Sample Data

address	removed	in_partyA	in_partyB	log_index	in_quoteId	in_deadline	block_number	in_closePrice	in_quoteStatus	block_timestamp	transaction_hash	in_quantityToClose
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0xcd17fabfac826cbda00e0f74ffdaddf0fdb40336	0x9206d9d8f7f1b212a4183827d20de32af3a23c59	62	17773	2017322953	9746747	989950000000000000	5	2024-01-26T15:27:21.000Z	0xbc796609cef3b20e3e67f4431501bb9077f636fa226ba473021cb087762354a5	308000000000000000000
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0x54b649989b269ec0ee87b7f08eadad366e7bd29b	0x9206d9d8f7f1b212a4183827d20de32af3a23c59	58	16785	2017310042	9740290	2230580000000000000000	5	2024-01-26T11:52:07.000Z	0x4c1c27665d68d32bb1f6cf8347656864ce761a841dbc1c9db3907841b5f2de12	2408000000000000000
0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	0x70298f618a4947a5513077dd0683b290dffb827c	0x9206d9d8f7f1b212a4183827d20de32af3a23c59	73	18282	2017281262	9725900	88000000000000000000	5	2024-01-26T03:52:27.000Z	0x60047d0f4457b530896c9d029d6ccf4e838b58fd5dcdf72fac7c92b010ebfe85	6000000000000000000

Example Query

Query with partition filter

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

SymmioDiamond_SendQuote_event

Quote submission events from Symmio perpetual futures protocol on Base, capturing order details including price, quantity, collateral requirements (CVA, liquidation fees, maintenance margins), and counterparty whitelists for derivatives trading.

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_partyA`	`STRING`	Address of the party initiating or holding the primary position in the trading or liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteId`	`STRING`	Unique identifier assigned to this specific quote in the Symmio protocol. Numeric string that increments sequentially across all quotes on the platform.
`in_partyBsWhiteList`	`ARRAY<STRING>`	Whitelist of eligible Party B addresses authorized to accept this quote. Array of hex-encoded Ethereum addresses that can act as counterparties to the requesting Party A.
`in_symbolId`	`STRING`	Trading pair or market identifier on the Symmio platform. Numeric ID that maps to a specific trading symbol (e.g., 121, 81, 183, 230).
`in_positionType`	`INT64`	Position direction indicator for the quote, where 0 represents a long position and 1 represents a short position. All sample values show 0, indicating long positions.
`in_orderType`	`INT64`	Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
`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_marketPrice`	`STRING`	Market price of the symbol at the time the quote was sent, denominated in wei (18 decimal places). Used as a reference price point for the trading pair being quoted.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_cva`	`STRING`	Credit Valuation Adjustment (CVA) amount required for this quote, denominated in wei (10^-18 token units). Represents collateral allocated to cover counterparty credit risk in the derivatives position.
`in_lf`	`STRING`	Liquidation fee (LF) for the quote, denominated in the smallest unit of the settlement currency. Represents the collateral reserved to cover potential liquidation costs if the position moves against the trader.
`in_partyAmm`	`STRING`	Maintenance margin required from Party A to open this position, denominated in wei (10^-18 units). This collateral requirement is calculated based on the position size and leverage.
`in_partyBmm`	`STRING`	Maintenance margin requirement for Party B (liquidity provider) in the Symmio protocol quote. Typically zero in these samples, indicating Party B may not need to post collateral upfront for this quote type.
`in_tradingFee`	`STRING`	Trading fee amount for this quote expressed in the protocol’s base unit (wei for EVM chains). Typically consistent across quotes, indicating the fee charged for executing this trade.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

in_lf	in_cva	address	removed	in_price	in_partyA	log_index	in_quoteId	in_deadline	in_partyAmm	in_quantity	in_symbolId	block_number	in_tradingFee	in_marketPrice	block_timestamp	transaction_hash	in_partyBsWhiteList
51999885600000000000	77999828400000000000	0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	15300000000000000	0xb93ac7ca2052831a95369ae05b761a8f4698765c	50	80558	2028261446	69999846000000000000	196078000000000000000000	121	15215995	600000000000000	15295300000000000	2024-06-01T05:55:37.000Z	0x2c222be52c950f8fefa744b168d206a5d4692c43f3edccd1541e63d361157a43	[“0x9206d9d8f7f1b212a4183827d20de32af3a23c59”]
6586535650933333025	9879803476399999538	0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	15546700000000000	0x19e4cd2542a5353953f681fd363e938de1fcc023	66	80632	2028306994	33532666320035088489	24442000000000000000000	121	15238770	600000000000000	15177100000000000	2024-06-01T18:34:47.000Z	0xd563acec634ef74ef74032d9f43ee3a8fbd28bfe8ce414c251cf85f505e21d92	[“0x9206d9d8f7f1b212a4183827d20de32af3a23c59”]
19093646000000000000	28640469000000000000	0x91cf2d8ed503ec52768999aa6d8dbea6e52dbe43	false	25250000000000000	0xc9e6e6570121883ce9148284b4904ad523e4cb4a	208	80618	2028294670	77265204148936170213	116336000000000000000000	81	15232607	600000000000000	25436000000000000	2024-06-01T15:09:21.000Z	0xc5962cbf03dd6656fe69d79c3f0cd61f2ba160a48e9af7fbb1f5f46323d651c1	[“0x9206d9d8f7f1b212a4183827d20de32af3a23c59”]

Example Query

Query with partition filter

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

Timelock_batchWithdrawFees_function

Timelock contract function calls for batch fee withdrawals from BMX protocol vault on Base, specifying multiple token addresses to withdraw in a single transaction. Used to analyze protocol fee collection patterns and token diversification across the platform’s liquidity pools.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in__tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	in__vault	signature	in__tokens	to_address	block_number	from_address	block_timestamp	transaction_hash
555372	true	333703	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	0xe8ae2271	[“0x4200000000000000000000000000000000000006”,“0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22”,“0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”,“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239”]	0x4b7a40d74191a6acaa4af8b339ee2bca5b6aa403	12676598	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	2024-04-03T11:09:03.000Z	0xd5a1e599ba136380c65e5768cb23e0438a7dc90a948d8a940438e44d07377fd2
823059	true	497092	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	0xe8ae2271	[“0x4200000000000000000000000000000000000006”,“0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22”,“0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”,“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239”,“0x940181a94a35a4569e4529a3cdfb74e38fd98631”,“0x2da56acb9ea78330f947bd57c54119debda7af71”,“0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42”,“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”]	0x4b7a40d74191a6acaa4af8b339ee2bca5b6aa403	22921478	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	2024-11-26T14:45:03.000Z	0x79adc72f6c10c77a59a65e8bf16adb20a2f2a0b305fedcf2a93ff7dfffdb2f08
556917	true	337044	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	0xe8ae2271	[“0x4200000000000000000000000000000000000006”,“0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22”,“0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”,“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239”]	0x4b7a40d74191a6acaa4af8b339ee2bca5b6aa403	7841275	0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce	2023-12-13T12:51:37.000Z	0xee346f3e61a8b1c3932e3a5ef86988eb509c387537bcc361174867fc4c69b35b

Example Query

Query with partition filter

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

Vault_BuyUSDG_event

USDG stablecoin purchase events emitted by vault contracts, recording the deposited token type, amount, receiving account, minted USDG quantity, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash	in_feeBasisPoints
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	50	0x9fac7b75f367d5b35a6d6d0a09572efcc3d406c5	11738647	640706014681645740435	162072398968302231	2024-03-12T18:04:01.000Z	0xb0dffdd8266325b2874f9feb913e2674baf11d82d21b0d49b371d5d1fe682b94	11
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	24	0x9fac7b75f367d5b35a6d6d0a09572efcc3d406c5	11737144	112164358197907071986	28823064395412473	2024-03-12T17:13:55.000Z	0x04884fdd2cf8d16e6b965c6475caff8fab1339ce5eac0a0317a75c7563d6fbfb	14
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	18	0x9fac7b75f367d5b35a6d6d0a09572efcc3d406c5	11723268	1614929215887898400000	403242350000000000	2024-03-12T09:31:23.000Z	0x25d65c348646a530febb705a04f9d98d97076274b9377531a8254ff0f505529f	17

Example Query

Query with partition filter

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

Vault_ClosePosition_event

Position closure events from BMX perpetual futures Vault contract on Base. Records final position state including size, collateral, average entry price, realized profit/loss, and funding rates for analyzing trading outcomes and position management.

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_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_averagePrice`	`STRING`	Average entry price of the position being closed, stored as a high-precision integer with 30 decimal places. Represents the weighted average price at which the position was originally entered across all increases.
`in_entryFundingRate`	`STRING`	Funding rate value recorded when the position was originally opened. Used to calculate funding payments accrued during the position’s lifetime.
`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.

Sample Data

in_key	address	in_size	removed	log_index	block_number	in_realisedPnl	block_timestamp	in_averagePrice	transaction_hash	in_entryFundingRate
0xdb8c89892a80d86d8ae065ebef76f6d5f2e704d507b9869c565c004dd4bebcc0	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	19714899039404038421988442756800000	false	316	21238699	400854696693555993578574907920438	2024-10-18T15:52:25.000Z	2604933000000000000000000000000000	0x288fc5c9122d5d1ce1b234fc840330383d3f26a3fc4de69504db7d5ada15e6f5	109473
0x23c257670de04f47c1b1581136ae8baef6c86c66606534ce92ed3766e99d8ac1	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	64145202987997350000000000000000000	false	356	21237040	3386675793647219160959094655258807	2024-10-18T14:57:07.000Z	65908588739072323485022857056502877	0x5d60662b86de4009b991429a9c46c2670436da82c2c1c8a0f98e869b39246f9f	143379
0x170b5c30c51610794853e66752359b8d8021a657b521e118f54446ae04a461cd	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	332053797463414634145787938320000	false	141	21215604	-2848209842431004724624342573152	2024-10-18T03:02:35.000Z	1399000000000000000000000000000	0x473dce63c7394ab231c14d2f9d0e3e1d19cf8b7d6b6fec7460a7d8ede3e12c4b	267281

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.Vault_ClosePosition_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
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	2568454474684452426484800000000	364	16679492	4584	2024-07-05T02:58:51.000Z	0x98686a133c86388d4f28aec8ee8253f1d1980c36d72574c66d888aaf45b2b426
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	22044930877269439705800000000000	279	16683478	40606	2024-07-05T05:11:43.000Z	0xe972a6492db1015aaf51f4c53147c1c30cce381d035022ff0503e6923311ca10
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	27052409668997542462902800000000	170	16681935	50273	2024-07-05T04:20:17.000Z	0x222ec04f2e64c8ff2df18d63ee6849b28d9bd80b4990991047e93d96e89e7b4b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.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
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	7167858000000000000000000000000	1	9450627	7167858	2024-01-19T18:56:41.000Z	0x51ea7c9ef40c1e60d8b1b838236fa44940365089de173350f5c1402e185c0029
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	29778715530000000000000000000	2	9444512	73	2024-01-19T15:32:51.000Z	0xe6983474b20e251752a2d09f3f7ed48b904b4aaa0d95db847ade32b72f137a8f
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	0	2	9420897	0	2024-01-19T02:25:41.000Z	0x92274f6d3539730bb33781a1ac4ca18c66ff2d6db802f10b97c9b139042c0053

Example Query

Query with partition filter

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

Vault_DecreaseGuaranteedUsd_event

Vault events from BMX perpetual futures protocol on Base recording reductions in guaranteed USD reserves for specific tokens. Used for tracking collateral adjustments and position closures in the protocol’s vault system.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	1195148648519809824155695289280000	6	9269931	2024-01-15T14:33:29.000Z	0x3177ba1703ae3b26b41c111588b0c51ff0a48760361c1d207e2d740cbc67aab1
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	2417361759180952378535019193200000	7	9269779	2024-01-15T14:28:25.000Z	0xeb005baa713d397a1d779c57b6e6bcf584c5075bd143061d36cf19cb8c385213
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	50773000000000000000000000000000	15	9268948	2024-01-15T14:00:43.000Z	0x4402e04909428bc21c11f468868f1802b3b9a47034ef9e459d12bd52d53f45df

Example Query

Query with partition filter

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

Vault_DecreasePoolAmount_event

Vault liquidity withdrawal events from BMX protocol on Base showing token amounts removed from liquidity pools. Tracks pool balance reductions with token addresses and amounts for monitoring vault inventory and withdrawal 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	24011	40	18730743	2024-08-21T14:33:53.000Z	0xbc8013b7a5dfabb4bd70662cf1741893cf4352a3674690bf040daab35e5cc13f
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	2861	599	18730689	2024-08-21T14:32:05.000Z	0xa5facc09cbc38a3a4c52a57742001815d4c268936c07c220145aa2cf6fcdd16c
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	3499	85	18731589	2024-08-21T15:02:05.000Z	0x0597c3d4e61e48b01e42c71d7add9e3f5860e0adb60680a84ddc4f5761f5a509

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.Vault_DecreasePoolAmount_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
0	0xd4b51ab14b161ae034ce4c06a9c4602520c5c6c7657a85b060441bca23844529	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	688000000000000000000000000000	true	211	0xfe9356d85f698ce150d746a523a2ebbbb5fbcf19	16074609	0	0x940181a94a35a4569e4529a3cdfb74e38fd98631	2024-06-21T02:56:05.000Z	0xb82a8daba1b5cfb4053fd767309cbb48d59a8a081b8c1af4c187aac5ddfa54c0	500000000000000000000000000000000	0x940181a94a35a4569e4529a3cdfb74e38fd98631
1871800838447178503664000000000	0x0650efc373e74b0baf23c6e80061e22fa3a3fa7b1e53a21ae616cf299ffac84c	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	64446134000000000000000000000000000	true	178	0x29930c405817b40d802d4a806302aac60e99ced6	16076496	1529249051018936686000000000000000	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	2024-06-21T03:58:59.000Z	0x230aaf247906f062d629616291e0e1db39ccd55f38218ee57f2208e788f97085	0	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad
1655519032844128184173233002500	0xf0b3c5414ce03d263a692b7c24af5b615127a8d85b0a0dfcfe798f33b257da06	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	675491100000000000000000000000	false	169	0x6476d5c547d2bd26f827acb38faa1a0529bf9e36	16084684	1655519032844128184173233002500000	0x940181a94a35a4569e4529a3cdfb74e38fd98631	2024-06-21T08:31:55.000Z	0x397d10e288cfcc83791ddc1bbaaa3d816df14de6dcb4824a7a55837fb5e25f54	0	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913

Example Query

Query with partition filter

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

Vault_DecreaseReservedAmount_event

Vault reserve reduction events from BMX perpetual futures protocol on Base, tracking when collateral reserved for open positions is decreased upon position closure or partial reduction. Used to analyze position exit patterns and vault liquidity management across different collateral tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2da56acb9ea78330f947bd57c54119debda7af71	1718944645645599753728692878	207	22054299	2024-11-06T12:59:05.000Z	0xd1d317cc44c57aa5ca10a4e87cdc9fc0b40c2fe5a98d1a6ce2708ab1afa4d548
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	4767708786168410289	157	22049356	2024-11-06T10:14:19.000Z	0x6544ccaddc6493a1a224aab0becfbeb6a136d306f50f9771d4d55e25c47e9c18
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	16280563969198352872	371	22071820	2024-11-06T22:43:07.000Z	0x9356ae84b5461a5f97a02fc5c00d6b56df4328ecbcd96347b64053757157f5bd

Example Query

Query with partition filter

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

Vault_DecreaseUsdgAmount_event

USDG stablecoin burn events from BMX protocol vault on Base, tracking when synthetic dollar tokens are decreased through withdrawals or position closures. Used for analyzing vault liquidity changes and stablecoin supply dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	700301324000000000000	59	7302058	2023-12-01T01:17:43.000Z	0x81e9eee7c2550b378d1e01e6a8e3946eaadd2f16e08e815d5bd98281f643e8d5
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	1127493108000000000000	9	7316984	2023-12-01T09:35:15.000Z	0xacb086b676a323e9b3717906758d69a283586064383e11ca6e08314b2f5fa5dc
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	566789643000000000000	7	7302052	2023-12-01T01:17:31.000Z	0x85a051bdfc4ff366c79e383f9398973fa88b13c190b7587db2b89cacea2b583b

Example Query

Query with partition filter

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

Vault_DirectPoolDeposit_event

Direct deposit events into BMX protocol vault pools on Base, recording deposited token addresses and amounts. Used for tracking liquidity provision and vault funding 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	500000	12	3517172	2023-09-04T10:34:51.000Z	0xc746cbb1cd9c5c7edf9b1187ece553d23a945f016fa00fdb2e8c76f429c70fb8
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	55000000000000000	6	7457411	2023-12-04T15:36:09.000Z	0x658afd1aa13f7bd2a43bbb7a7793b0425a3db46ce5ab62c28fe9c6a60aeda59d
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	25570000	11	8567640	2023-12-30T08:23:47.000Z	0xeb362f2fb365543a3a1011ea519d51cbabcf8bf700ed1d244e9420760add3b85

Example Query

Query with partition filter

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

Vault_IncreaseGuaranteedUsd_event

Vault events tracking increases in guaranteed USD liquidity for specific tokens on BMX (Base) perpetual futures protocol. Records collateral additions to the vault with token addresses and amounts denominated in USD value for analyzing liquidity depth and reserve management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	1390294790085333545852076000000000	98	15905192	2024-06-17T04:48:51.000Z	0x5bc05dcddd3df5adff98af1b0db942d9ce002417f9e031d1a580e45edebe5090
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	535283988295495690001964239444051	105	15313371	2024-06-03T12:01:29.000Z	0x4578409336732da2a9646580d1fe0012a52a061c5a762135406186c279fb45a3
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x4200000000000000000000000000000000000006	14414688176132413633709751610462260	228	15318209	2024-06-03T14:42:45.000Z	0xdd7a9e090d9505e6f50f00ec66e39fe3f34dbbbb8f45bf67378566c53b967fdd

Example Query

Query with partition filter

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

Vault_IncreasePoolAmount_event

Pool liquidity additions on BMX perpetual exchange vault on Base. Records token deposits into the vault’s liquidity pool with amounts and token addresses for tracking pool growth and composition.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	885882	7	15772245	2024-06-14T02:57:17.000Z	0xe3475bc274ba8ea7a68b97cff172d4e379316e492bbce7e77e83d0a0dcd74346
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	112274	32	15778656	2024-06-14T06:30:59.000Z	0xd0eefb638a00fdf2916ed21afd804d2ede360bac023c26baa7c74d909457acf7
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	26865	45	15805852	2024-06-14T21:37:31.000Z	0x8fd1bb6988d34dd372128714c1a5eca45871eac34997911bf46f34c7845a9d68

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.Vault_IncreasePoolAmount_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
122458823529411764704106700000000	0x0ef97bcf01148d6394ee76a61365e7cf5e12aa0afd2a71bcb2a06051fbb07a3b	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	3125733000000000000000000000000000	true	254	0x962ee88dcf981354f616d6ae6325b8a8dbfc3410	16961611	122458823529411764704106700000000000	0x4200000000000000000000000000000000000006	2024-07-11T15:42:49.000Z	0xa427f672c1eabb94668d5b8d4416cccd67f0aa9827e3f4af47d78639970337c9	6251466000000000000000000000000000	0x4200000000000000000000000000000000000006
70984095557219103084118071859170	0x0ef97bcf01148d6394ee76a61365e7cf5e12aa0afd2a71bcb2a06051fbb07a3b	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	3097352000000000000000000000000000	true	404	0x962ee88dcf981354f616d6ae6325b8a8dbfc3410	16969861	50288554380748514849124039559170000	0x4200000000000000000000000000000000000006	2024-07-11T20:17:49.000Z	0x933d3ba3e673909f870e0e7848888a3031c08f9994b6376262c251117d78a772	5079657280000000000000000000000000	0x4200000000000000000000000000000000000006
123087430865882352939391702840680	0x0ef97bcf01148d6394ee76a61365e7cf5e12aa0afd2a71bcb2a06051fbb07a3b	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	3136748000000000000000000000000000	true	154	0x962ee88dcf981354f616d6ae6325b8a8dbfc3410	16959318	123087430865882352939391702840680000	0x4200000000000000000000000000000000000006	2024-07-11T14:26:23.000Z	0xd54be4dd4dd1cd37d16d2fa37308e22705bb92fd21889fe749bb55fc6a888bc3	6273496000000000000000000000000000	0x4200000000000000000000000000000000000006

Example Query

Query with partition filter

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

Vault_IncreaseReservedAmount_event

Vault reserve allocation events from BMX perpetual futures protocol on Base, recording when collateral tokens are reserved for open positions. Used for tracking vault liquidity management and position collateralization over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	1187296669	11	7409905	2023-12-03T13:12:37.000Z	0x92bd77561a173c43cedd78534c25ac417b018e9fd23da11e382ba237342575f3
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0	12	7426592	2023-12-03T22:28:51.000Z	0xbec7f69b3daad1b2d34919f396604680f342255a56478acdef04d2e6ded31ffc
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0	12	7390840	2023-12-03T02:37:07.000Z	0x3c037ec034496083e8b9cf2361bb9cb5058ef7b4d5ee9e918ae83e76af031502

Example Query

Query with partition filter

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

Vault_IncreaseUsdgAmount_event

USDG stablecoin mint events from BMX protocol vault on Base, recording token deposits and corresponding USDG amounts issued. Used for tracking liquidity provision and vault token composition over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	37886892020000000000	4	8682350	2024-01-02T00:07:27.000Z	0x506faebc5bd71cdbc1847e684945b9370fce0217485928dd1204c113b1068527
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	55158351250000000000	5	8682587	2024-01-02T00:15:21.000Z	0x551d55aa049caf2301d5401be516aa95f3f0cd9f3e900d8da2db04a914df485c
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	68318856410000000000	8	8697169	2024-01-02T08:21:25.000Z	0x2de773a1ff41561b7f27ec51d0b77a17d5c9defa9666fc5eafa6bb1962a4be31

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.Vault_IncreaseUsdgAmount_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
0x31c7e461e9f354e0d168e0abd5d5142c6be99589f47157609d25d3a0cec18acc	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	503817904761904759916760000000000	false	false	15	0xced3fc4610761f79242d7d8a72fe86f3a1c626b4	7505076	2300345000000000000000000000000000	10076358095238095240083240000000	0x4200000000000000000000000000000000000006	2023-12-05T18:04:59.000Z	503817904	0x743401d8f42977469d8db2e52e08092bf703e24a629a523fde8be943ad79bc64	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913
0x1869bd8853cf139d1e01cda1c5c2bdd26bc039f38ee401846591b36e76338038	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	5774642151116881146500382000000000	false	true	4	0x3cbde0a28a1ffdd95f0b2629e6f955e1b922d12e	6750175	9414260000000000000000000000000000	115733992186347726615579618000000	0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239	2023-11-18T06:41:37.000Z	394064855228788862	0x8267079a10878ebe5a67fc8a8c9654bdadeadb622a384001fcd998df3bce71e1	0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239
0x1baccaac6b686bcf24ec7e355a4476b68479f109de92dfaffe4d78d901265332	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	629427976190476189846762500000000	false	true	743	0xdb24e409a0a66e872786d659156364d2fe5d26fc	21383922	2618110000000000000000000000000000	12587997023809523810153237500000	0x4200000000000000000000000000000000000006	2024-10-22T00:33:11.000Z	238105370823165703	0x9b218644c7786d26a1e90a4f08a08693ec69b992e3b4493e72b48e91d1b6d55c	0x4200000000000000000000000000000000000006

Example Query

Query with partition filter

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

Vault_SellUSDG_event

USDG stablecoin redemption events emitted when users sell USDG tokens back to the vault for an underlying collateral token. Records the account address, USDG amount burned, output token and amount received, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash	in_feeBasisPoints
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x940181a94a35a4569e4529a3cdfb74e38fd98631	174	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	15897502	199234357463248670184	229165417616713677778	2024-06-17T00:32:31.000Z	0x8367d9fbb661cdc818882d99df8e60dfdb2e1a06961c3b7d0a0bb4a977fbc44b	16
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x940181a94a35a4569e4529a3cdfb74e38fd98631	169	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	15897650	185183319803704886361	212960817774260619314	2024-06-17T00:37:27.000Z	0x3e5b6010750f47e3f217aa5d250c25eda8d73c4c2a41570a5decbfcaedf8b7f0	18
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x940181a94a35a4569e4529a3cdfb74e38fd98631	153	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	15897622	226364298042167341947	260318942748492443238	2024-06-17T00:36:31.000Z	0xac8ac03537ad983c9784a0bcbd65795f3d17875c6a3168fa10ff5b73f9805164	18

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bmx_v1_base.Vault_SellUSDG_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
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	310	0x19ceead7105607cd444f5ad10dd51356436095a1	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	6283	0x940181a94a35a4569e4529a3cdfb74e38fd98631	18485608	5690754730000000000	2024-08-15T22:22:43.000Z	0xd48c822babb0507a708f34830a6473e2cd0959adb38efc24b04c4832c5cb3978	31	5673113390337000000
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	108	0x19ceead7105607cd444f5ad10dd51356436095a1	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	5258	0x940181a94a35a4569e4529a3cdfb74e38fd98631	18474733	4746364350000000000	2024-08-15T16:20:13.000Z	0x07cc95697c6e067364cc4e82e46f80f65e2e7b3f8b322df0459bfcd773910f64	31	4731650620515000000
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	101	0x19ceead7105607cd444f5ad10dd51356436095a1	0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad	5895	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	18484884	3392933	2024-08-15T21:58:35.000Z	0x5aabb8d2818fa4350fedcb96683578b18f345cb4f695911e442f5a0ab45020dd	47	3376986

Example Query

Query with partition filter

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

Vault_UpdateFundingRate_event

Funding rate update events from BMX perpetual futures vault on Base, recording periodic rate adjustments for individual tokens. Used for analyzing funding rate dynamics and borrowing costs across different perpetual markets.

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_fundingRate`	`STRING`	New funding rate applied to the specified token in the vault. Stored as a string-encoded integer representing basis points or a similar scaled rate metric.

Sample Data

address	removed	in_token	log_index	block_number	in_fundingRate	block_timestamp	transaction_hash
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	49	7507263	253	2023-12-05T19:17:53.000Z	0x211e6209594740504e6350fc7f99f5b1a2cc1b7340011017b4162bac5c3a3d02
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	9	7490481	253	2023-12-05T09:58:29.000Z	0x4b7e9a6ea44f84ecd1d8a9d4bebedc6fb56f3ddabcceb064a3858d71d3e25567
0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	58	7504286	253	2023-12-05T17:38:39.000Z	0xc23294e5a05fc80dca40ae836cc3df78efcb7506ab5a2798d781d3a7d4655ff5

Example Query

Query with partition filter

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

Vault_UpdatePnl_event

Profit and loss (PnL) update events from BMX protocol vault contracts on Base, tracking position-level unrealized gains and losses. Each event records the delta amount and profit/loss direction for a specific position key, enabling analysis of position performance and vault mark-to-market changes.

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_hasProfit`	`BOOL`	Indicates whether the PnL (profit and loss) update for the position represents a profit or loss. Returns true for profitable positions and false for losing positions.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

in_key	address	removed	in_delta	log_index	block_number	in_hasProfit	block_timestamp	transaction_hash
0x185524dbb76b6682c0a6f1d75000137efc6c9d7fe4547da2b8d5609977734dc6	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	7764472844316861590891487878553	21	17922463	false	2024-08-02T21:31:13.000Z	0x81c8a3a8ed21ac76612f3493424f9fa375665ec2dec406b398dcbe92e64cc147
0xb2fca4c2557501a8d72cd85329ecb1af1c395f5ea1aecd32fecdd4485ac4cf02	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	34670623040859530304330560820357	257	17922239	false	2024-08-02T21:23:45.000Z	0x7f82e5e33f2cc9fd428375173a33834f77760ad750c1bb02c0d3cfc06b0b8fc2
0x53dce61e345ed603fb376114e33cf09735e2233f72f92b66becbbb6155b5a794	0xec8d8d4b215727f3476ff0ab41c406fa99b4272c	false	2910128795534416659124288579153	334	17922217	false	2024-08-02T21:23:01.000Z	0x5d4ddeb5225b99b49800c4c5cdc96a09424378c7f3810b92d3bffca58403279d

Example Query

Query with partition filter

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

VolumeRewardDistributor_DistributeVolumeRewards_event

Volume-based reward distribution events from BMX protocol on Base. Records batch payouts to trading participants with recipient addresses and token amounts for analyzing reward allocation patterns and trader incentive programs.

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_to`	`ARRAY<STRING>`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

in_to	address	removed	log_index	in_amounts	block_number	block_timestamp	transaction_hash
[“0x14dbbeb5a9bccda3aed04ba62b14a2216ea5bcab”,“0xa983723ed60b541ddf896711f271b5bf462c0c23”,“0x779c1305d19a61ce5c460eb8e854e27491013a56”,“0x766d5acdbf819dd67dd4afe60d5a2d691484f778”,“0xc1a2d8a1182bc200f3bf9529a89fe9249373d709”,“0xe073182d644ebb5290cfa6915ba94312fc73a679”,“0xbab85e9d114716ca8bb5f49e1a1479fd4bd1d2c4”,“0xf3a8219f3b7f02c730999d4186c339ece131b217”,“0xe8415acbef52f35e06590abed9de87cc42313972”,“0xab2dcf4a68fc91d099fee8818141fc748da5381d”,“0x9f12a50f7e2e11c3cd5d1874eb9644fde6b0ec2e”,“0x7e6f8b98b2e097d23667a59a9f872caef015a036”,“0xc88291a6491e951b14568a97afcedd576dcb87ba”,“0xbcb49dce0b4e680b5609ec117bb1408035bd7f2f”,“0x57db7006d54e2e560d9bfa56e7b09eb526bcf071”,“0x9e1b7fa62606901c46038a5629a82544b24b07f6”,“0x0cf30daf2fb962ed1d5d19c97f5f6651f3b691c1”,“0xb29de9ca75ca627b73872516ee9e6e0a280b0aca”,“0x2d45eb0dd68675e899578be4ca65997e7200fa9a”,“0x1ac805822a880cf46b2452de3a654ead24a74693”,“0xcd8e3fc83cb1ea9fee19f365820a405a275add45”,“0xc46971b9abce40708323dabf8664653a3f14bc81”,“0x501c55d242422811440b6866c7d9a7e74a73bcd7”,“0xcd2fb8a5a9a89bf9166e7d2ba5d5e887e7e8f0e2”,“0xb1dd2fdb023cb54b7cc2a0f5d9e8d47a9f7723ce”]	0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	779	[“431920021287226440000”,“305092067310215100000”,“97633357238020490000”,“43914580549941560000”,“39371665320887845000”,“17130985475123778000”,“16375999886045745000”,“14978254576682668000”,“7493561235980155000”,“4301355489771748000”,“4192120832478226000”,“3871553955887373000”,“3636442496399836000”,“2780471117696345000”,“2296229292831979000”,“1188009752299328300”,“1022122437415309200”,“943874507711533600”,“596879774506289900”,“540575452120205600”,“474487834916697000”,“164136877612235870”,“46678427951573040”,“28210015652404640”,“6358854624869483”]	22874689	2024-11-25T12:45:25.000Z	0xcd2bad741fcd8e4a79254584c61826d58648e925cd6924ee5bfdb74f09309e3b
[“0x766d5acdbf819dd67dd4afe60d5a2d691484f778”,“0xa983723ed60b541ddf896711f271b5bf462c0c23”,“0x14dbbeb5a9bccda3aed04ba62b14a2216ea5bcab”,“0xe8415acbef52f35e06590abed9de87cc42313972”,“0xe073182d644ebb5290cfa6915ba94312fc73a679”,“0xc1a2d8a1182bc200f3bf9529a89fe9249373d709”,“0xfb73040cf9c20611f2c77a68972081efe995ceb9”,“0xbcb49dce0b4e680b5609ec117bb1408035bd7f2f”,“0xf3a8219f3b7f02c730999d4186c339ece131b217”,“0x2ae4afa2dd52c7a9d34e75dd8900bd44e5315a03”,“0xec280b396c67ea915995b900fd1c5e665681ff37”,“0x2cc39cefba8765be0879e752aa97e2d3d41e7bc5”,“0x1bb846dad2b5a04c1e822f16c2757b22991a3dce”,“0xbb697e9c6ecb9345a1741a02e80aa3424a584ad2”,“0x78c9bd2d9ba9d1992d9a945b1ea2e17b58c36b80”,“0x7e6949e70627f746f87577bbbb3bb03f89c23b4f”,“0x9f12a50f7e2e11c3cd5d1874eb9644fde6b0ec2e”,“0x1a49d5238a1dbc9df764fec35f003a2691cf8dd1”,“0xdc18517d7f2effc6cce195f5a2bf64ab52367ad3”,“0xe6dbfdca9357e2bf1962622fcc39364b8e4059c2”,“0x779c1305d19a61ce5c460eb8e854e27491013a56”,“0xd50c2757045ca76495e95d2bb01ead736259ed19”,“0xe62776c1462fa66bd2e70e0db89ef8b62df84414”,“0xd1a0b66835d830e9ada42eef436f3aa8005b20b5”,“0x99f1313a485e50debc8bc36274e95cc0efb05531”]	0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	108	[“299401823877439160000”,“172954203289055260000”,“124781268556667370000”,“119602589121152880000”,“95974378310130660000”,“44655365388524240000”,“32450493222869213000”,“27249073945329283000”,“21711792377996575000”,“16234680930312626000”,“10052915468671263000”,“8593887470579420000”,“7168044331058295000”,“4861937052450408000”,“4110291340954892300”,“2114345300383083000”,“1818086471517020700”,“1571670069788371200”,“1470330946635198200”,“779312918520753500”,“775364231503952900”,“542869792950971600”,“456930426950785300”,“345824322398396800”,“322520836159971840”]	22568355	2024-11-18T10:34:17.000Z	0x5539f6d24d311f263098b527d1e5e634416d282c41e2d0149433e4fa8f5ffa37
[“0xa983723ed60b541ddf896711f271b5bf462c0c23”,“0x14dbbeb5a9bccda3aed04ba62b14a2216ea5bcab”,“0xe073182d644ebb5290cfa6915ba94312fc73a679”,“0xe8415acbef52f35e06590abed9de87cc42313972”,“0xbcb49dce0b4e680b5609ec117bb1408035bd7f2f”,“0xc1a2d8a1182bc200f3bf9529a89fe9249373d709”,“0x962ee88dcf981354f616d6ae6325b8a8dbfc3410”,“0xfb73040cf9c20611f2c77a68972081efe995ceb9”,“0xf3a8219f3b7f02c730999d4186c339ece131b217”,“0x57db7006d54e2e560d9bfa56e7b09eb526bcf071”,“0xd2476321e3c0d862cfa9647c1019d2eddc761c40”,“0x2ae4afa2dd52c7a9d34e75dd8900bd44e5315a03”,“0xdc18517d7f2effc6cce195f5a2bf64ab52367ad3”,“0xbb697e9c6ecb9345a1741a02e80aa3424a584ad2”,“0xcf0dcc80f6e15604e258138cca455a040ecb4605”,“0x7e6f8b98b2e097d23667a59a9f872caef015a036”,“0x9f12a50f7e2e11c3cd5d1874eb9644fde6b0ec2e”,“0xb9c0aba138b98656ffea4309bfe2881b0b7c1d96”,“0xab2dcf4a68fc91d099fee8818141fc748da5381d”,“0x27ab111c7348081f404fd66729fa10a29f6d7ba7”,“0xd1a0b66835d830e9ada42eef436f3aa8005b20b5”,“0x12f0a98012630ebddd2beb61b2289b28e470a18f”,“0xad6d352ec2a960c440b035b7a51161de7159a849”,“0x1f0d890b5a26a87e5796b19cf4e6626ab489ce71”,“0x7e6949e70627f746f87577bbbb3bb03f89c23b4f”]	0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	504	[“262640599455501400000”,“202502452971796800000”,“177206661533368030000”,“126354482123465470000”,“63142945902274170000”,“49026507047675820000”,“39708701595476080000”,“20474925170196726000”,“11102907334200873000”,“8606447755009735000”,“6729374769841918000”,“6407710180381132000”,“3798780166989504000”,“3435719819420234000”,“2878609115603647000”,“2674607291907990000”,“2617072989148805000”,“2387542452618942500”,“2379263351135635000”,“2223102074070274800”,“1327382762922945300”,“846491184601511400”,“751575453848974300”,“433890599014910300”,“342246899528387700”]	22265496	2024-11-11T10:18:59.000Z	0x122079efe3f88cf1afe9d0f39a598df96bc48f635b46056cb92a3bf7768eb84e

Example Query

Query with partition filter

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

VolumeRewardDistributor_TotalRewardsChanged_event

TotalRewardsChanged events from BMX volume reward distributor contract on Base, tracking cumulative reward pool updates over time. Used for monitoring reward program funding and analyzing incentive 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_totalReward`	`STRING`	Cumulative total rewards available in the VolumeRewardDistributor contract at the time of this event, denominated in the smallest token unit (wei). Values incrementally increase over time as new rewards are added to the distribution pool.

Sample Data

address	removed	log_index	block_number	in_totalReward	block_timestamp	transaction_hash
0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	780	22874689	3999999999999999907413	2024-11-25T12:45:25.000Z	0xcd2bad741fcd8e4a79254584c61826d58648e925cd6924ee5bfdb74f09309e3b
0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	109	22568355	3000000000000000172780	2024-11-18T10:34:17.000Z	0x5539f6d24d311f263098b527d1e5e634416d282c41e2d0149433e4fa8f5ffa37
0xf491a98f31f6adc12b8a1f421d70df977ad5fc9b	false	505	22265496	2000000000000000122440	2024-11-11T10:18:59.000Z	0x122079efe3f88cf1afe9d0f39a598df96bc48f635b46056cb92a3bf7768eb84e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​DibsRewarder_Claim_event

​DibsRewarder_Reward_event

​LSSVMPairERC721ERC20_SwapNFTInPair_event

​LSSVMPairERC721ERC20_SwapNFTOutPair_event

​LSSVMPairERC721ERC20_swapNFTsForToken_function

​LSSVMPairERC721ERC20_swapNFTsForToken2_function

​LSSVMPairERC721ERC20_swapTokenForSpecificNFTs_function

​MultiAccount_AddAccount_event

​MultiAccount_Call_event

​MultiAccount_DepositForAccount_event

​MultiAccount_WithdrawFromAccount_event

​RewardDistributor_Distribute_event

​SudoFactoryWrapper_createPair_function

​SudoFactoryWrapper_PairCreated_event

​SudoVRFRouter_AllowListHookUpdated_event

​SudoVRFRouter_FeeConfigUpdated_event

​SudoVRFRouter_FeeTransferred_event

​SudoVRFRouter_NFTsBought_event

​SudoVRFRouter_NFTsSold_event

​SudoVRFRouter_Refunded_event

​SudoVRFRouter_RequestCancelled_event

​SudoVRFRouter_RequestFailed_event

​SudoVRFRouter_RequestSubmitted_event

​SudoVRFRouter_VRFConsumerUpdated_event

​SymmioDiamond_LiquidatePartyA_event

​SymmioDiamond_LiquidatePositionsPartyA_event

​SymmioDiamond_RequestToClosePosition_event

​SymmioDiamond_SendQuote_event

​Timelock_batchWithdrawFees_function

​Vault_BuyUSDG_event

​Vault_ClosePosition_event

​Vault_CollectMarginFees_event

​Vault_CollectSwapFees_event

​Vault_DecreaseGuaranteedUsd_event

​Vault_DecreasePoolAmount_event

​Vault_DecreasePosition_event

​Vault_DecreaseReservedAmount_event

​Vault_DecreaseUsdgAmount_event

​Vault_DirectPoolDeposit_event

​Vault_IncreaseGuaranteedUsd_event

​Vault_IncreasePoolAmount_event

​Vault_IncreasePosition_event

​Vault_IncreaseReservedAmount_event

​Vault_IncreaseUsdgAmount_event

​Vault_LiquidatePosition_event

​Vault_SellUSDG_event

​Vault_Swap_event

​Vault_UpdateFundingRate_event

​Vault_UpdatePnl_event

​VolumeRewardDistributor_DistributeVolumeRewards_event

​VolumeRewardDistributor_TotalRewardsChanged_event

Tables

DibsRewarder_Claim_event

DibsRewarder_Reward_event

LSSVMPairERC721ERC20_SwapNFTInPair_event

LSSVMPairERC721ERC20_SwapNFTOutPair_event

LSSVMPairERC721ERC20_swapNFTsForToken_function

LSSVMPairERC721ERC20_swapNFTsForToken2_function

LSSVMPairERC721ERC20_swapTokenForSpecificNFTs_function

MultiAccount_AddAccount_event

MultiAccount_Call_event

MultiAccount_DepositForAccount_event

MultiAccount_WithdrawFromAccount_event

RewardDistributor_Distribute_event

SudoFactoryWrapper_createPair_function

SudoFactoryWrapper_PairCreated_event

SudoVRFRouter_AllowListHookUpdated_event

SudoVRFRouter_FeeConfigUpdated_event

SudoVRFRouter_FeeTransferred_event

SudoVRFRouter_NFTsBought_event

SudoVRFRouter_NFTsSold_event

SudoVRFRouter_Refunded_event

SudoVRFRouter_RequestCancelled_event

SudoVRFRouter_RequestFailed_event

SudoVRFRouter_RequestSubmitted_event

SudoVRFRouter_VRFConsumerUpdated_event

SymmioDiamond_LiquidatePartyA_event

SymmioDiamond_LiquidatePositionsPartyA_event

SymmioDiamond_RequestToClosePosition_event

SymmioDiamond_SendQuote_event

Timelock_batchWithdrawFees_function

Vault_BuyUSDG_event

Vault_ClosePosition_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreaseGuaranteedUsd_event

Vault_DecreasePoolAmount_event

Vault_DecreasePosition_event

Vault_DecreaseReservedAmount_event

Vault_DecreaseUsdgAmount_event

Vault_DirectPoolDeposit_event

Vault_IncreaseGuaranteedUsd_event

Vault_IncreasePoolAmount_event

Vault_IncreasePosition_event

Vault_IncreaseReservedAmount_event

Vault_IncreaseUsdgAmount_event

Vault_LiquidatePosition_event

Vault_SellUSDG_event

Vault_Swap_event

Vault_UpdateFundingRate_event

Vault_UpdatePnl_event

VolumeRewardDistributor_DistributeVolumeRewards_event

VolumeRewardDistributor_TotalRewardsChanged_event