Skip to main content

​
Tables

​
CurveFactoryV22_NewCurve_event

NewCurve event logs from DFX Finance (v2) Curve Factory on Arbitrum, recording the deployment of new liquidity pool contracts. Tracks curve pool creation with deployer addresses and unique pool identifiers for monitoring protocol expansion.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_curveSTRINGContract address of the newly created curve pool. Hex-encoded, 0x-prefixed, 42-character string.
in_idaddressremovedin_curvein_callerlog_indexblock_numberblock_timestamptransaction_hash
0xdde6031950d0065499d21e341763afc80db8c05977449bbb197c6602660720670x9544995b5312b26acdf09e66e699c34310b7c856false0xf32af5729304e75044e8f20c7688eede605139320x33af579f8fafada29d98922a825cfc0228d7ce3981112708362023-07-14T22:55:04.000Z0x25a31825a5251398f287f25fd8ada78905f81e77242e355999222fe956ee9b4b
0x677feb000fff154d1526fd15020f1df0b4cb73313b9fb5abb8473515c63d68170x9544995b5312b26acdf09e66e699c34310b7c856false0x6f4ce956044412bb9258a805012539d3437e4e990xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb9658321162023-03-01T19:37:44.000Z0xf049f275e1baaf6c545a5b11864ff491e5476d88cfa9773047a915a0c11faed1
0x5e68c24a920bc5f9407f115b5369cdeb8c504e71658cdc94bf19773334ff3ab20x9544995b5312b26acdf09e66e699c34310b7c856false0xcd8a5ea5c44a231cb42f13056f55c65af32cb5650xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb8701706382023-03-15T19:42:52.000Z0x3455ae754860a36cdda4d9cc707a8544cfca0bf54d02eb57faf3160a4eaca17c
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_arbitrum.CurveFactoryV22_NewCurve_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
CurveV22_Trade_event

Trade execution records from DFX Finance (Curve V2.2 implementation) on Arbitrum. Contains swap details including origin and target token addresses, amounts exchanged, trader addresses, and protocol fees for analyzing DEX trading activity and liquidity pool dynamics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_originSTRINGSource endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_originAmountSTRINGAmount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
in_targetAmountSTRINGAmount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination.
in_rawProtocolFeeSTRINGProtocol fee collected on the trade in raw token units (smallest denomination). String-encoded integer representing the fee amount before decimal adjustment based on the target token’s precision.
addressremovedin_originin_targetin_traderlog_indexblock_numberblock_timestampin_originAmountin_targetAmounttransaction_hashin_rawProtocolFee
0xcd8a5ea5c44a231cb42f13056f55c65af32cb565false0xff970a61a04b1ca14834a43f5de4533ebddb5cc80x2b28e826b55e399f4d4699b85f68666ac51e6f700x78b8d9ed56812cf932851edee4e1c2294cf462f571373543522023-10-04T07:33:38.000Z10000000136698145237256227260xac6689f7484afac74d7c05fc981804bd8fb6c0ddc65fcd21502437dde39bb9b9276516693664906178
0xcd8a5ea5c44a231cb42f13056f55c65af32cb565false0x2b28e826b55e399f4d4699b85f68666ac51e6f700xff970a61a04b1ca14834a43f5de4533ebddb5cc80x0c84e1265aec391ce7f867573d9cc2ae1314d0af9903001722023-05-13T14:18:30.000Z4542374184150136713073490737890x491a74fbea67c203576d2e788491b37244a502c9df0693c89559a7e6bc145b0f9688045520071519413
0xcd8a5ea5c44a231cb42f13056f55c65af32cb565false0x2b28e826b55e399f4d4699b85f68666ac51e6f700xff970a61a04b1ca14834a43f5de4533ebddb5cc80x0c84e1265aec391ce7f867573d9cc2ae1314d0af6901087302023-05-13T00:47:14.000Z1272653960126311519811005790520xc4a3aefe81154835785771c33fd570bb1202b901e107d9a9f376708affa60aa32790992378352255159
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_arbitrum.CurveV22_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100