dodo_v2_polygon

Tables

Mine_Claim_event

Mining reward claim events recording user withdrawals from liquidity mining programs. Captures claimed reward amounts and user addresses for tracking incentive distributions across DODO protocol versions.

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_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x738aba1389c5e37d24b5b669f07cbea594c733e4	0x570cbfdc462d0b6d8e306e4b26f92644a1f0d89c	false	34287336662872446579	174	26281466	2022-03-23T21:25:35.000Z	0xce9ee064e60ac06242527f6d71ef5b4eb4d585a11df6e2081e9c1ad18b6b70fe
0x738aba1389c5e37d24b5b669f07cbea594c733e4	0x1c120ee927accabd06a21109bfed9467b45e3824	false	25348106079549958185	147	24834171	2022-02-12T01:11:57.000Z	0xc2bf87adcebf6798dfabb777f02220e5def7e59f22280b95d825a061519741d4
0x738aba1389c5e37d24b5b669f07cbea594c733e4	0x33b2ad24a6130e7a76f09ac9a79519b08576e17a	false	125160554117616489461	168	24833992	2022-02-12T01:05:51.000Z	0x2c3ecfd65f4e1fa44ebf11bc887673345df10c68a1de15deb62f49e9c2117617

Example Query

Query with partition filter

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

PrivatePool_DODOSwap_event

DODOSwap event logs from DODO v2 private pool contracts recording token exchanges. Contains trader address, source and destination token addresses with amounts, and receiver address for tracking decentralized exchange swaps.

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_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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	14	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x000010036c0190e009a000d0fc3541100a07380a	500153346	74507718	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2067824648469809725440	2025-07-28T09:02:57.000Z	0x34078c0695aba00306a9eab7cac312b1bf28c8276c9507b5f1ff730d3f4af188
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	79	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x000010036c0190e009a000d0fc3541100a07380a	1300738534	74507696	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	5376344086021506334720	2025-07-28T09:02:11.000Z	0x31a4a6eb6ca56aab9bc5ea7d5d9fb375319044e4658be91af87a9600e082282c
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	48	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x000010036c0190e009a000d0fc3541100a07380a	2502672998	74507663	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	10343400910219280121856	2025-07-28T09:00:59.000Z	0x43dac62bddf0cacc227f3e7c02f3d64372441eb6db526e948268930dfcdd2269

Example Query

Query with partition filter

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

PrivatePool_LpFeeRateChange_event

Liquidity provider (LP) fee rate adjustment events emitted by DODO V2 private pool contracts. Captures new fee rate values applied to LP positions within private pools for fee structure tracking.

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_newLpFeeRate`	`STRING`	New liquidity provider fee rate set by the pool update. String-encoded integer representing the fee rate in basis points or wei-denominated fractional units.

Sample Data

address	removed	block_number	block_timestamp	in_newLpFeeRate	transaction_hash
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	60720215	2024-08-18T00:46:33.000Z	1212875900000000	0x46a843866c18dfd9c4ab7ec2de5599b9b80e722a7153c072115a3755cf7e9c8a
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	60728143	2024-08-18T05:27:24.000Z	1064269500000000	0xdb46ca4e97dbc6588cc67d70f7be583c757f8180acc6fa13cf085b447ae904a3
0x1093ced81987bf532c2b7907b2a8525cd0c17295	false	60740594	2024-08-18T12:49:22.000Z	1448669700000000	0x02bc4bb6f66a742619d2fc6e93dbe5c1e0e6b9e886bc78c83d9bb29149bf180d

Example Query

Query with partition filter

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

PrivatePoolFactory_NewDPP_event

DODO V2 private pool creation events emitted when a new DPP (DODO Private Pool) is deployed via the PrivatePoolFactory contract. Records pool creator address, base/quote token pair, and deployed pool contract address for tracking custom liquidity pool instantiation.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. 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_dpp`	`STRING`	Contract address of the DODO Private Pool (DPP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_dpp	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0xa71415675f68f29259ddd63215e5518d2735bf0a	0xd24153244066f0afa9415563bfc7ba248bfb7a51	false	146	0xe56143c0949fa228f465d0e3164651e4efb3c0db	31191036	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	2022-07-27T09:03:37.000Z	0x873da9681190e11e2a553886907fcc26c6d0fbc20b2fa2ee8c0344ccd05d4f58
0x14edf2f755174c535f95cff4b5d135f36b511851	0xd24153244066f0afa9415563bfc7ba248bfb7a51	false	155	0xa67f4d6dd924cd89587fc742365970716f9a8f51	34606220	0x6ae7dfc73e0dde2aa99ac063dcf7e8a63265108c	0x6d389a2da049e16db256ebc15fa92f70125c8385	2022-10-21T05:39:26.000Z	0x497a6498425d6b510f8a36cab4802a97b67c80df008877ac5c13e46a06152c72
0x2deb87cf3d141ca9d5375a8da4a0855b1a23977a	0xd24153244066f0afa9415563bfc7ba248bfb7a51	false	173	0xa67f4d6dd924cd89587fc742365970716f9a8f51	24407828	0xed2f85f446281a31bcae074938e867422f5074c8	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2022-02-01T04:29:15.000Z	0x4837fa47756d2b817bd92459f5d281344cdb08f1d92946eb3e1d821b2d7b1e91

Example Query

Query with partition filter

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

StablePool_DODOSwap_event

Token swap events emitted by DODO StablePool contracts containing trader address, source and destination token addresses, input and output amounts, and receiver address. Used for tracking stableswap trades and liquidity pool activity across DODO’s decentralized exchange 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_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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0xc174a26c2dec8e311fe18896126bdcfda924230f	false	0x11431a89893025d2a48dca4eddc396f8c8117187	257	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x11431a89893025d2a48dca4eddc396f8c8117187	7275	18904874	0x725f2f4af4ed337906f9fa5119160f59a1641581	21300000000000000000	2021-09-09T03:48:39.000Z	0x87bb427d69b3c8e98ff94d3d59fc183dd6eaa2b0c036a8018f1b9878b1a9ee7c
0xc174a26c2dec8e311fe18896126bdcfda924230f	false	0x11431a89893025d2a48dca4eddc396f8c8117187	71	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x11431a89893025d2a48dca4eddc396f8c8117187	777000	18904626	0x725f2f4af4ed337906f9fa5119160f59a1641581	1050000000000000000000	2021-09-09T03:40:07.000Z	0xb5e18a2cbff7a9fb7bf122770f8ea0b3d57f8bfae660caceea041f03cb4b94b1
0xc174a26c2dec8e311fe18896126bdcfda924230f	false	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	889	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xcad35e672310294ce34dab143da7e48ea0140837	468695	18905033	0x725f2f4af4ed337906f9fa5119160f59a1641581	2700000000000000000000	2021-09-09T03:56:17.000Z	0x4f268c253c155930b668e58c2eaf1a3809df522c29155a63f90fc616cc3f89f5

Example Query

Query with partition filter

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

StablePoolFactory_createDODOStablePool_function

Function call records for creating DODO v2 stable pools with base/quote token pairs, liquidity provider fee rates, and price curve parameters (k, i). Returns the deployed stable pool contract address for tracking new pool deployments on the DODO decentralized exchange.

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`	`NUMERIC`	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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpFeeRate`	`STRING`	Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.
`in_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_k`	`STRING`	K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.
`in_isOpenTWAP`	`BOOL`	Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.
`out_newStablePool`	`STRING`	Contract address of the newly created stable pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_i	in_k	status	gas_used	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_isOpenTWAP	in_quoteToken	block_timestamp	transaction_hash	out_newStablePool
642817	200000	1000000000000	true	399035	0xcf5c2f10	0x43c49f8dd240e1545f147211ec9f917376ac1e87	30761192	0xa3dff6ae0f73f0970e31da63b3736f7d3cef683e	0x712502daee557e04c6063b451ff97c3635de86bb	8000000000000000	false	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2022-07-15T18:58:41.000Z	0x048941bcb85ecf7411f9e31c150f17e885c6ffef508ed2c3bf70195a903c528c	0xc5f101b24b26bbd4a1bc5beefa97f7ec90cdc93a
665658	1000000000	100000000000000000	true	399113	0xcf5c2f10	0x43c49f8dd240e1545f147211ec9f917376ac1e87	30748584	0xa3dff6ae0f73f0970e31da63b3736f7d3cef683e	0x706bd88a1744d318b9f4787cf6dad1ea1cf0c969	4000000000000000	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2022-07-15T10:16:31.000Z	0xf33a8f5ec6de8c43bd12f9868902faab52b4d7c158cb1111e5837d0887e3374e	0x6780f998c30cbf39dff398cccf5fbbb20ddfe4d9
641100	763420000000000000000000000000000	100000000000000000	true	367636	0xcf5c2f10	0x43c49f8dd240e1545f147211ec9f917376ac1e87	67474413	0xa3dff6ae0f73f0970e31da63b3736f7d3cef683e	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	4000000000000000	false	0x28e977157727273243cb072f9c9de494a1387d5d	2025-02-03T04:06:51.000Z	0x868893562887861b0813a888bf5f18b062dc40925a87f5d4739a26960c144c7a	0xb40f65aeec359a59c34482e3579c679c629c886b

Example Query

Query with partition filter

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

StablePoolFactory_NewDSP_event

DODO v2 StablePoolFactory event emitted when a new DSP (DODO Stable Pool) is created, containing the deployed pool contract address, base and quote token addresses, and creator address. Used for tracking stable swap pool deployments across DODO DEX instances.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. 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_DSP`	`STRING`	Contract address of the DODO Stable Pool (DSP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_DSP	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0xbfb5fe8704b6fe5cf990bf3c690d0bc2b372a35f	0x43c49f8dd240e1545f147211ec9f917376ac1e87	false	177	0x7b861609f4f5977997a6478b09d81a7256d6c748	42788145	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x126f94cac36945103ee322eb879c9d105bc8f2d3	2023-05-16T20:25:54.000Z	0x8569ca6ece03cc7154731e8b518ff78aef8f609e54f2ce6c447e190e16632560
0x38ef7bfd22608d5a6ae30e5fdc8dcf49a224f0d9	0x43c49f8dd240e1545f147211ec9f917376ac1e87	false	184	0x40cb94c39bdec49fd4376c31ea3fb2ad143fbba1	70098154	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xb355f4f4cc84a9429a59d5c2b98d77016f7ec482	2025-04-09T18:27:19.000Z	0x05155972955e7979ac495cb07b9566e10ae7da74697814a381c2533a9d047ea7
0xc37e6fe4b5468bb898c8f454651d5ec1de6b6200	0x43c49f8dd240e1545f147211ec9f917376ac1e87	false	79	0x2aca189767cecf31087aafc0c50a59a7d83b6376	66046657	0xa1e54bda3052937f76cb28b16b340cb254a1f824	0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39	2024-12-29T02:18:37.000Z	0xbc3618276658c3b987a5c88c426c49e7b788b483cfcfa3bc6745b886395399dc

Example Query

Query with partition filter

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

VendingMachine_DODOSwap_event

DODOSwap token swap events from DODO V2 vending machine contracts containing trader address, source and destination token addresses, swap amounts, and recipient. Used for DEX trade volume analysis and liquidity tracking across token 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_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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x4b658c395804f90d76aa1995391e4730c7208de7	false	0x13927a60c7bf4d3d00e3c1593e0ec713e35d2106	11	0xf0059cc2b3e980065a906940fbce5f9db7ae40a7	0x13927a60c7bf4d3d00e3c1593e0ec713e35d2106	1624726376099124242633	34939703	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	525955050098000366736	2022-10-29T09:11:01.000Z	0x127ea4552fb5ee09b6d1c5a08b2c0305a4a3220a3916d24ff88ef192908a81a6
0x4b658c395804f90d76aa1995391e4730c7208de7	false	0xe011a666a0f63558edecf942218ec6e82efffb66	233	0xf0059cc2b3e980065a906940fbce5f9db7ae40a7	0x2a35f755c9938c63141fb8d26a9045abe6917d71	211933008425397890653	34943758	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	68819378202015520246	2022-10-29T11:34:45.000Z	0x8e6c0fdd7bb8b6cc042b052faae1b3b6a3248e4af2560276aed44dfdd445fcc9
0x4b658c395804f90d76aa1995391e4730c7208de7	false	0xe011a666a0f63558edecf942218ec6e82efffb66	179	0xf0059cc2b3e980065a906940fbce5f9db7ae40a7	0x2a35f755c9938c63141fb8d26a9045abe6917d71	171362816068324606598	34943714	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	55614934625144511224	2022-10-29T11:33:13.000Z	0x55abaf706fada0d4d4d6f6f65aaced290940df4126aa373f381bb708e73724dc

Example Query

Query with partition filter

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

VendingMachineFactory_createDODOVendingMachine_function

Factory function calls for creating DODO V2 vending machine liquidity pools. Records pool deployment parameters including base/quote token pairs, pricing curve configuration (k parameter), LP fee rates, and TWAP oracle settings, returning the deployed pool contract address.

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`	`NUMERIC`	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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpFeeRate`	`STRING`	Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.
`in_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_k`	`STRING`	K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.
`in_isOpenTWAP`	`BOOL`	Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.
`out_newVendingMachine`	`STRING`	Contract address of the newly created DODO vending machine pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_i	in_k	status	gas_used	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_isOpenTWAP	in_quoteToken	block_timestamp	transaction_hash	out_newVendingMachine
572076	1000000000000	1000000000000000000	true	362480	0xe18c40c7	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	26369689	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	0x1fc47370b597866cb15dd5c54f52ae67be667b8d	2400000000000000	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2022-03-26T04:13:41.000Z	0xd279ed1af4b72017c2f7dd2767585d7fe1ca73a58a43e9c1aeb8c4b583587184	0x5fb1434e712ec1ad6136070d3c13a50169e97c74
588909	1000000000000	1000000000000000000	true	379580	0xe18c40c7	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	26369629	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	0x1fc47370b597866cb15dd5c54f52ae67be667b8d	72000000000000000	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2022-03-26T04:11:37.000Z	0x0b5dfd66a129320548f272ed6a26d389c1ecb64613b8ac079c6a5d92d59dda8b	0x6af092dad99f64cf6c5eda731ebaea547780ed41
607997	1000000000000	1000000000000000000	true	394571	0xe18c40c7	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	26399542	0xa222e6a71d1a1dd5f279805fbe38d5329c1d0e70	0x4f8090da25de0f92591c125b064ff187d1e8daea	72000000000000000	false	0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb	2022-03-26T22:52:27.000Z	0x9a30c08109685a057ed49278e2fe0d06acf36ed3e13a11efa0073edf1bc61e1e	0x75807caf4edc2b2bb1e21028e44396a6224b9c32

Example Query

Query with partition filter

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

VendingMachineFactory_NewDVM_event

DODO Vending Machine (DVM) liquidity pool creation events emitted when a new trading pair is deployed. Records creator address, base/quote token addresses, and deployed DVM contract address for tracking pool deployments across DODO V2 exchanges.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. 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_dvm`	`STRING`	Contract address of the DVM (DODO Vending Machine) pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_dvm	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0x3c34a8472ee0d562fdf91745f680d19f9eed8d9f	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	false	120	0x18dd54caf780017b39bc0b99c8a6ae22beb7c3c5	21064647	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x7584bf83998deb33d4dc5142fd642b336ebc0b93	2021-11-06T21:11:39.000Z	0x2b97e338d6ce4fd85d65ce9999cf99fd19133d2adbb765b40b0cb7ad713632fb
0x741c6dfea4c2dabc34e64a93865f53e000fca1e6	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	false	192	0x6c25b8c7050b267342b77d9657a2e2bf09d209ee	21067479	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x398a2d1b343d09261df990c2fcc97b5d5d62c1b5	2021-11-06T22:55:23.000Z	0x1484eeb1a36fcf100d1d5f9915028471db70f544cb0ddfd99915e9e22b9fbc8c
0x6cd45f7e2aefdc36c36c53a24ae3642fb6572685	0x79887f65f83bdf15bcc8736b5e5bcdb48fb8fe13	false	233	0x6c25b8c7050b267342b77d9657a2e2bf09d209ee	21063684	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x34965ba0ac2451a34a0471f04cca3f990b8dea27	2021-11-06T20:34:17.000Z	0x61f9acf79bc8fac9cb3b65d35be2582b560599ee8ef6af17c6ffa0fcd8638c7d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_NewDPP_event

StablePool_DODOSwap_event

StablePoolFactory_createDODOStablePool_function

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_createDODOVendingMachine_function

VendingMachineFactory_NewDVM_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Mine_Claim_event

​PrivatePool_DODOSwap_event

​PrivatePool_LpFeeRateChange_event

​PrivatePoolFactory_NewDPP_event

​StablePool_DODOSwap_event

​StablePoolFactory_createDODOStablePool_function

​StablePoolFactory_NewDSP_event

​VendingMachine_DODOSwap_event

​VendingMachineFactory_createDODOVendingMachine_function

​VendingMachineFactory_NewDVM_event

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_NewDPP_event

StablePool_DODOSwap_event

StablePoolFactory_createDODOStablePool_function

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_createDODOVendingMachine_function

VendingMachineFactory_NewDVM_event