wombat_v1_bsc

Tables

DynamicPool_Swap_event

Token swap events from Wombat Exchange’s DynamicPool contract on BNB Smart Chain, capturing trade details including input/output tokens, amounts, sender, and recipient addresses for analyzing liquidity pool activity and swap 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x7f9e3430880580713b03670046c7e89a0a91403b	220	0xe9e7cea3dedca5984780bafc599bd69add087d56	262313984285492974577	25061822	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	262363748009658783778	2023-01-24T10:47:43.000Z	0xf3ea0fac55939777c8ce4795ca3b3c18a1bd5241354801c8ed8eee7e18830240
0xe0a625e2865d3bb8092e50f45decded7e9283db2	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	168	0xe9e7cea3dedca5984780bafc599bd69add087d56	9998026877906896498	25057048	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	10000000000000000000	2023-01-24T06:46:02.000Z	0xa3f70cfedf083a9283ced14f0f9e94ca2af08e305593da2a3cb8a4505744c958
0x631d000e8ae30d941a04a450fcb5cddb76173456	0x0520451b19ad0bb00ed35ef391086a692cfc74b2	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	184	0xe9e7cea3dedca5984780bafc599bd69add087d56	20129424213948749817	25067983	0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5	20132192187722274437	2023-01-24T16:02:04.000Z	0xd86809a910e2f5e0a8d18f9a6f0eed310e11e55b978d775ec74a8e8b3aa91231

Example Query

Query with partition filter

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

HighCovRatioFeePool_Swap_event

Token swap events from Wombat Exchange’s high coverage ratio fee pool on BNB Smart Chain. Records include token addresses, swap amounts, and participant accounts for analyzing stableswap liquidity pool 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	258	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	741118776282268572	21724517	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	719989725813115767	2022-09-28T12:02:46.000Z	0x3df48e6fb19d2ab606ce98451b2f0c176b9eab4f60ea7054f6f9f633c571ee43
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	546	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	741122518233885593	21724440	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	719989755911669832	2022-09-28T11:58:49.000Z	0xc94011992606cbaafe2a02b352aaad139d95c5e2e25af58d1ced3458573e6a34
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x0029b7e8e9ed8001c868aa09c74a1ac6269d4183	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	329	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	100514592623468012847	21713481	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	97717444443207051925	2022-09-28T02:41:30.000Z	0x19f4e90a5858bdf05a4394376ae0d36ac8c7a12b5b3086ba1d93e3ad033a76fe

Example Query

Query with partition filter

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

MasterWombat_Harvest_event

Reward harvest events from Wombat Exchange staking pools on BNB Smart Chain, tracking user reward claims by pool ID and harvest amounts. Used for analyzing yield farming activity and reward distribution patterns across liquidity providers.

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_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`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	block_number	block_timestamp	transaction_hash
0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0x084924a46f21dced2153bc64907c74e5b1dc91fa	false	29201541077834301566	183	23889118	2022-12-14T05:49:02.000Z	0x807b585b4cda6da9b6787d171c10a8af175bb124fc8dd4529cb1910717d67ed5
0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0x2c3e0099045c5802cbf7182a22047c3cb8fc51e0	false	20216340134475964917	141	23902954	2022-12-14T17:28:03.000Z	0xbbb817ef11e8d5abb21af743148b463cbed3b0fd2fe4e11f38d960171a9d4fcf
0xe2c07d20af0fb50cae6cdd615ca44abaaa31f9c8	0x38fee735744655f4eb3b3dd827a9eeb9ae167e2e	false	134714509637445422036	127	23895479	2022-12-14T11:09:48.000Z	0x57c9a74e9ef8790708113bcec3c602a470cf40712c7714a6d58f6815b07b28af

Example Query

Query with partition filter

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

MWOMPool_Swap_event

Swap events from Wombat Exchange’s mWOM pool on BNB Smart Chain (BSC), capturing token exchanges with input/output amounts and participant addresses. Used for analyzing liquidity pool activity, swap volumes, and price discovery in the Wombat stablecoin AMM.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x19609b03c976cca288fbdae5c21d4290e9a4add7	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	270	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	1733125890970972288354	23475651	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	2000000000000000000000	2022-11-29T14:00:50.000Z	0x10fed4a52824092ec967746760946c79cc17e572b30d72e771bce1bbe1591034
0x6f8adc605edf0da9f3970d12405e8e47e9ac7454	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	99	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	3447087057682450352805	23475157	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	3000000000000000000000	2022-11-29T13:36:05.000Z	0xf79b18febabedc2b4ca79a2b19795aac085f914fbff972d6e7ab4acd1923849b
0xe791b5cd18462be5398be681da780d0def917764	0x083640c5dbd5a8ddc30100fb09b45901e12f9f55	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	137	0x027a9d301fb747cd972cfb29a63f3bda551dfc5c	960589858448490204496	23473913	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	834002521399719184847	2022-11-29T12:33:51.000Z	0xf1ba5c99d05a9deb45b263b8951da4d66beb5de64ec6f804ad6819fe64a41534

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x0956d6a17cde63985f60bfd82f6c09969489bf40	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x0956d6a17cde63985f60bfd82f6c09969489bf40	306	0x55d398326f99059ff775485246999027b3197955	299795318492756320956229	21357378	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	299882984151825445800292	2022-09-15T15:24:09.000Z	0x9e17e04dc8350c9ca1e48b1a9311500ab719f38bdfd5c0c31e4c897a832407b2
0x66fdb2eccfb58cf098eaa419e5efde841368e489	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x275f8cde216dab640ca2b125fe0a7b2d3fdf110d	4	0xe9e7cea3dedca5984780bafc599bd69add087d56	2293070185773164214876	21340529	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	2293521988450000000000	2022-09-15T01:03:26.000Z	0x0e53de0e1e4fa82f041f61df45b14e67ab793b5818fdda6c1e83a74d19cc4981
0x3c8c2a111eb1e47d55acb6d5d2b96d5936210e04	0x312bc7eaaf93f1c60dc5afc115fccde161055fb0	false	0x3c8c2a111eb1e47d55acb6d5d2b96d5936210e04	233	0x55d398326f99059ff775485246999027b3197955	9998344584847124840009	21345337	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	10000988288925377163847	2022-09-15T05:06:23.000Z	0xd79bc669e51c3c5633b7f0c5196f08f2cd3a823e5bc8bed66d00f7a5a3ad57a3

Example Query

Query with partition filter

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

QWOMPool_Swap_event

Token swap events from Wombat Exchange’s QWOM pool on BNB Smart Chain (BSC). Records include sender and recipient addresses, input/output token pairs, and exchanged amounts for analyzing stablecoin swap activity and liquidity 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x0178cde49dd90be5c4d3387d6b268ec8cff31911	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	99	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	27535881178542049037712	25019823	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	20000000000000000000000	2023-01-22T23:21:55.000Z	0xc1c34f601a2a50262e61a8266ac921dde5b6eaf0230325306ef95cd54d709d08
0x3479667788b1bf5dc2c6582c41226efdbd78dd63	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	190	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	8105735817835849959	25012331	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	11307753754867043478	2023-01-22T17:03:38.000Z	0xcd770195bdec48ac042e7643897622de53762c7d51e51453b9d839b320d72a22
0x4fe6b3c5f964ae3cd6f9771254364718892b2253	0x2c5464b9052319e3d76f8279031f04e4b7fd7955	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	294	0x0fe34b8aaaf3f522a6088e278936d10f934c0b19	690356754733970318049	25006378	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	500301070581061858436	2023-01-22T12:01:35.000Z	0xce9ff656377373db4e0d1fd8bb4e8a6aa1f9fdb327b6503864115e269caba374

Example Query

Query with partition filter

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

WmxWOMPool_Swap_event

Token swap events from Wombat Exchange’s WMX-WOM pool on BNB Smart Chain. Records token pair exchanges with sender, recipient addresses, input/output amounts, and token addresses for tracking liquidity pool 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x5d881e58fd2067522be2599e9faa30e356c22582	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	151	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	1992661049298324944	22604154	0x0415023846ff1c6016c4d9621de12b24b2402979	2370804953522765685	2022-10-29T20:25:18.000Z	0x33ea6a0c21881a80fbdedfdf89aa9668ae9d25cc3707e213812c7b5e4ee7f93a
0x2ee42b83fc842d2af1f712262646348198a69b77	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	275	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	17416385107053593059797	22589315	0x0415023846ff1c6016c4d9621de12b24b2402979	17940930624391041875093	2022-10-29T07:49:07.000Z	0x4e36ee59b12451698677f909a2b4bf4b8d9acd6ae084cf7612b5ad23aa7c53bb
0xc4b43c0bbea06b98a0c42c18409da120b49161e1	0xeeb5a751e0f5231fc21c7415c4a4c6764f67ce2e	false	0x19609b03c976cca288fbdae5c21d4290e9a4add7	181	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	303023179070692813650	22598152	0x0415023846ff1c6016c4d9621de12b24b2402979	344831414118178794383	2022-10-29T15:18:17.000Z	0xc560511e0512a819e09204604768691f214de98c3c8c303ccd514de2fceca5aa

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DynamicPool_Swap_event

HighCovRatioFeePool_Swap_event

MasterWombat_Harvest_event

MWOMPool_Swap_event

Pool_Swap_event

QWOMPool_Swap_event

WmxWOMPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DynamicPool_Swap_event

​HighCovRatioFeePool_Swap_event

​MasterWombat_Harvest_event

​MWOMPool_Swap_event

​Pool_Swap_event

​QWOMPool_Swap_event

​WmxWOMPool_Swap_event

Tables

DynamicPool_Swap_event

HighCovRatioFeePool_Swap_event

MasterWombat_Harvest_event

MWOMPool_Swap_event

Pool_Swap_event

QWOMPool_Swap_event

WmxWOMPool_Swap_event