dodo_v2_arbitrum

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
0x38dbb42c4972116c88e27edfacd2451cf1b14255	0x03d45ed1f865e52af716deda00734795ab617f4b	false	19812286046520941504	1	271557	2021-09-04T09:25:16.000Z	0x99ca54c0246c4eee5ce327d8d3313d885f4002027dfe208b5072056ea2045154
0x38dbb42c4972116c88e27edfacd2451cf1b14255	0x0abc081c9afbe045b4605bd1bbc85fa879f7d0d0	false	18377839697383834277	1	269002	2021-09-04T01:14:54.000Z	0x0778ac73c3753ba41078e13d5472f52085748e7a9829b6fd91634a440dbcac9d
0x38dbb42c4972116c88e27edfacd2451cf1b14255	0x0abc081c9afbe045b4605bd1bbc85fa879f7d0d0	false	8308183954190073352	1	271645	2021-09-04T09:46:36.000Z	0x15900c22e2802202fe592ad61e575d74082ac9cabfcd03138a39115daf050407

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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
0x4c93609ba98675be8705383d9736f43c045460ef	false	0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391	10	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0xbce44767af0a53a108b3b7ba4f740e03d228ec0a	105643	86878535	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	55105156624441	2023-05-03T13:22:31.000Z	0x4a8b1c0a9f7b752a93366127fdcbee4b486ed33b506c15950d8f3d09d5e797be
0x4c93609ba98675be8705383d9736f43c045460ef	false	0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391	21	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5	177427	86914197	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	94452594713858	2023-05-03T15:50:47.000Z	0xbdc498131b7062689809a2c966785785fc908e895be4878a6ccb0401a84fc232
0x8f11519f4f7c498e1f940b9de187d9c390321016	false	0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391	18	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x3b6067d4caa8a14c63fdbe6318f27a0bbc9f9237	26310212671271	86914197	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	48550	2023-05-03T15:50:47.000Z	0xbdc498131b7062689809a2c966785785fc908e895be4878a6ccb0401a84fc232

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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	log_index	block_number	block_timestamp	in_newLpFeeRate	transaction_hash
0x1666ea6e83bcc3473111732ef086ba47e6eddeb7	false	79	240387510	2024-08-07T13:25:28.000Z	1000000000000000000	0x92420ff95c1459af16463d2fe7fc809751cedff01ead62ba99e82ec9be6b2bee
0x869f51989bbe4a49a03daf49ec57572fccef3b81	false	37	240387511	2024-08-07T13:25:28.000Z	1000000000000000000	0x2acc5fe82e030818dc7d52ce24a666b103a91bc7d3daf4c3f5cc4acf758da6e6
0x716aa091d30a88a3e1874d56e99fbf1487cbc65a	false	38	240387511	2024-08-07T13:25:28.000Z	1000000000000000000	0x3ddf744175669963c28dd87291d64e82a89c1e6334500d2ef9ae5889a777e133

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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
0x09caee5f8e2c24b09c48fea8ff802ae2af7490f6	0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d	false	34	0xc72ed51dbb7acf64871ab3eb2770870093d66b5f	85407049	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x390609e6e1e75743c882331d65a9f523c48f50e9	2023-04-29T05:47:31.000Z	0x20e61b070d4d642390eb308229a61502330a1fd9b2407ecfbe8a8c70b74a402f
0x95e5b46b4d350b2688d27d5a57cb43456a697065	0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d	false	8	0x968cd825522c50a9e1d393a546e560e49940d8e2	233651798	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2024-07-18T23:41:30.000Z	0x3cd8270956521f7578d548304fbd403a92c14769884ba3bddc93e45ae1ad8aee
0xa9733980d009578ba51cd100d75b7e6be4850691	0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d	false	30	0xcd152b4450acbfdd3bc1541514a624f5da45b5df	233463582	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2024-07-18T10:31:51.000Z	0x73b6b45ada0a7951622ff64e3d5f585aa1ace65df0a60d0ca27828fa5fd841c8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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
0xe6cecb7460c9e52aa483cb1f0e87d78d7085686f	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	3	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	60179880913855878	258667256	0x2416092f143378750bb29b79ed961ab195cceea5	59102036793517684	2024-09-29T18:44:55.000Z	0x99aa4fd670b4e9f84b03f9ee688ec0ac19986d3a69d92d9b0bdc0f19c83dcda0
0xe6cecb7460c9e52aa483cb1f0e87d78d7085686f	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	9	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	32176904985189051	258654200	0x2416092f143378750bb29b79ed961ab195cceea5	31577860049823027	2024-09-29T17:49:58.000Z	0x0437d954285002f0d393f9d5fcbb28d06eb358b99d5ab6296432f15f28f4bfb0
0x3a7bc5f9e41356728f037f17d88c642ee46d1aaa	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	28	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	104193195213044014	258737235	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	99720181954596217	2024-09-29T23:40:52.000Z	0x4c823826f24912242d94674f08c419be6c41f4a0e2fc479021929ba796de011e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.StablePool_DODOSwap_event`
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
0x798be01888b06b9c6d4d74e4d4cbb8019645a57c	0xc8fe2440744dcd733246a4db14093664defd5a53	false	31	0x12d23991bd8a25333036cf41f44af6894f2ca61c	233191801	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2024-07-17T15:19:14.000Z	0x4bd13bfa6fb284bdaba3324acf151be10594396d2cbb720f3c7ebd9321e71683
0xc1649de4ca3247a15835f41a38db28d1d737f5e7	0xc8fe2440744dcd733246a4db14093664defd5a53	false	2	0xd7016d27964e7a32a60c5c1d9b751bde39596b9a	233259969	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2024-07-17T20:04:03.000Z	0x7319dc94ca93ebd2f54cd56c5c28e31c675737406e3d6a53234f85066ef8f7df
0x8d80b391f87768310992e7e616899489fd23e1ff	0xc8fe2440744dcd733246a4db14093664defd5a53	false	2	0x17f80ece5b9b56ef9122c4fce4ad65af8342c41b	233314703	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2024-07-17T23:53:01.000Z	0x197f551b5234331141dd6811b372c438e12bddad8bc4af0cc976d61162eb4a74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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
0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5	false	0x0aacc6124269f9591a5fcb33d34654918c151221	29	0x69eb4fa4a2fbd498c257c57ea8b7655a2559a581	0x1087a3254c35a7809cd6112422ea195ecda6e993	13621399676902058336	82267012	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2333096	2023-04-20T00:59:19.000Z	0x8b3fd60c3716415ec43463efb5da8c948f5ef7c6da601fc03a1265d335ca6cb8
0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5	false	0x0aacc6124269f9591a5fcb33d34654918c151221	45	0x69eb4fa4a2fbd498c257c57ea8b7655a2559a581	0x1087a3254c35a7809cd6112422ea195ecda6e993	20038540272227156703	82572828	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	3239469	2023-04-20T22:14:15.000Z	0x8e6259963fe73adb116e44fc576b028937879c713477d1039f2df3a05b001465
0x34851ea13bde818b1efe26d31377906b47c9bbe2	false	0x0aacc6124269f9591a5fcb33d34654918c151221	22	0x4e352cf164e64adcbad318c3a1e222e9eba4ce42	0x0aacc6124269f9591a5fcb33d34654918c151221	13481404508221159247	82399855	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	196632957	2023-04-20T10:15:49.000Z	0x16c6e9cf8fe8bb959a726511eaf818d7f554b2177d4564fbc805bd0889765207

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.VendingMachine_DODOSwap_event`
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
0x78c73272e4657d1d7dc17dd334f04b40b6db53fc	0xda4c4411c55b0785e501332354a036c04833b72b	false	6	0x13add9bf8f578647432925e4f449aee7d81fadfc	123581310	0x97927626b089eb1de1f7f85ece3ee022d7432454	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2023-08-21T14:57:10.000Z	0x1fbb45f4bea9e166482e568c36bb2987c75447da7a720655c1fa6f71f405f57b
0xf26c525c3eada8ed9ebffc7045f3a571961b547a	0xda4c4411c55b0785e501332354a036c04833b72b	false	0	0x597dc4159a4b85c086c3c679a0b6c8fe2836886f	147201936	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2023-11-04T23:50:48.000Z	0x9ef979d3366a968b33fe99e3733fcc11e975c597e61823fdb7142790d8525f70
0xdb1bc79542d5ca6504b42286b238032e7c8d9c15	0xda4c4411c55b0785e501332354a036c04833b72b	false	2	0x8eda0bd868eb10604e9f773edb8fb0cf25c8a3d6	270812348	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2024-11-04T03:19:23.000Z	0x5b45347ce199290e783079dd3f40fc377a111fc3c594ab15c28be36e5911b4df

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_NewDPP_event

StablePool_DODOSwap_event

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_NewDVM_event

​Tables

​Mine_Claim_event

​PrivatePool_DODOSwap_event

​PrivatePool_LpFeeRateChange_event

​PrivatePoolFactory_NewDPP_event

​StablePool_DODOSwap_event

​StablePoolFactory_NewDSP_event

​VendingMachine_DODOSwap_event

​VendingMachineFactory_NewDVM_event

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_NewDPP_event

StablePool_DODOSwap_event

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_NewDVM_event