syncswap_v1_zksyncera

Tables

ClassicPool_Swap_event

Swap event logs from SyncSwap V1 ClassicPool automated market maker (AMM) contracts on zkSync Era, recording token exchanges with input/output amounts and participant addresses. Used for analyzing DEX (decentralized exchange) trading volume, liquidity utilization, and swap routing 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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing 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	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x0e093c7c81f290df7dc83ddecf1db0e2fce8d307	0x80115c708e12edd42e504c1cd52aea96c547c05c	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	256	2575550	39952822	21161707896712310	2023-05-01T00:43:03.000Z	0x511d47be8e134564a4820982f1d31dd21d846e8890e596d06e77149b29fb49d4
0xdf590766723de8e5f535159d2a8bf935772fcd9b	0x0e093c7c81f290df7dc83ddecf1db0e2fce8d307	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	256	2594617	17818950000000000	2740843671479367088537965236	2023-05-01T08:35:08.000Z	0x981fc5d825f2d0cd36bc0421e0532c6bc6167599d7c006d39ce4f6b6b8963bb2
0x0a582d542df76065c30079255f5fe16bb0d75b90	0x80115c708e12edd42e504c1cd52aea96c547c05c	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	256	2580003	215490822	116180542572217906	2023-05-01T02:37:17.000Z	0x8abe434f312d56d8ceac0c2c7d265f49d18a03ae046732bf1b975cafa38fcabf

Example Query

Query with partition filter

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

ClassicPool_Sync_event

Reserve balance updates from SyncSwap v1 liquidity pools on zkSync Era. Tracks token0 and token1 reserve changes per pool for monitoring liquidity depth and pool state transitions.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x00f5d72d77f34adf925045c5fd9a97ff4ded51cb	false	9	68	187255593151523442283777365	13942264	2023-09-15T19:29:56.000Z	0xf73c018f19705d5db4911cb2ca5d9d354a904e5314d8f2fc75f7d30f0be98080
0x0553d4151daaf8336e34d8e0927f3d8b3ae6b3d9	false	51	2823225203013579655736	1599515550463201370662	13923890	2023-09-15T14:18:37.000Z	0x99f58b50db5fb19edf20d1834217f74bbb654ba6afb4c965c9b8390cbf8d9a54
0x076139c5bbd0c41641f6dda1e3d2b777d61840ae	false	63	57023017	33617945375677751474153	13897472	2023-09-15T06:43:34.000Z	0xdc3bfd27440e2c87f59fb1a3b4da2cb90b65b2973b3a81c6eb8653fbee1edf42

Example Query

Query with partition filter

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

ClassicPoolFactory_PoolCreated_event

Liquidity pool creation events from SyncSwap v1 decentralized exchange (DEX) on zkSync Era, recording new token pair pools deployed through the ClassicPoolFactory contract. Used for tracking DEX liquidity expansion and identifying newly tradable 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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xf2dad89f2788a8cd54625c60b55cd3d2d0aca7cb	0x0804594969aed4924567a777504fd4c819f83a8a	false	0x06c1b06c48f99eaa1dcf4a671cfccc61ee1e1e51	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	47	11205971	2023-08-14T09:56:09.000Z	0xf4365ef9c236420085f1b6ee5085e11da152645706d0bed0d426bf9773b65e79
0xf2dad89f2788a8cd54625c60b55cd3d2d0aca7cb	0xb34055c8beb1a1930244cc2c3ea5f309116fac0b	false	0x061d3de6ad832d0f390ad606051fa66f54d9d4b2	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	59	11199926	2023-08-14T08:11:43.000Z	0x4e9b69804d9aa67506c857c4210f8f378ef0733be05c469663f76ec3bd08a271
0xf2dad89f2788a8cd54625c60b55cd3d2d0aca7cb	0x31e52c0bde33376cafd3a960638ea46745fd50e0	false	0x4ebfb78c4780c304dff7de518db630b67e3f044b	0x81e7186947fb59aaaaeb476a47daac60680cbbaf	111	11197303	2023-08-14T07:25:25.000Z	0x86be2cc218bf428472b9d1de9f66b24e9f43d65c2079b40efda3abf8496495bb

Example Query

Query with partition filter

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

FeeManager_SetPoolProtocolFee_event

Protocol fee configuration events from SyncSwap V1 DEX on zkSync Era, capturing when fee rates are set or removed for specific liquidity pools. Used for tracking fee structure changes and revenue distribution across trading 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`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	address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
30000	0xfd43b4db521da13490e79eb6cfba19c9b012811c	0x80115c708e12edd42e504c1cd52aea96c547c05c	false	1	293683	2023-03-28T07:21:28.000Z	0xf2eb3936bd12e4332a8019a518dd2db5a45bcdece24e5d32db2c2535c6bcfa4e

Example Query

Query with partition filter

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

FeeManager_SetPoolSwapFee_event

Fee configuration events from SyncSwap V1 DEX on zkSync Era recording swap fee updates for liquidity pools. Tracks fee tier changes (in basis points) by pool address for analyzing fee structure evolution and protocol economics.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`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	address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
400	0xfd43b4db521da13490e79eb6cfba19c9b012811c	0x80115c708e12edd42e504c1cd52aea96c547c05c	false	10	289467	2023-03-28T06:03:44.000Z	0x891f5d5ac772fbe3d61b48723a4d29a1522bf8e3f5b5bd22f2515cab11555129
300	0xfd43b4db521da13490e79eb6cfba19c9b012811c	0x80115c708e12edd42e504c1cd52aea96c547c05c	false	21	293488	2023-03-28T07:17:50.000Z	0x18228f3b145f09ca3343af050ecd473f56a6bcc7c33e893bb09c3febff546c4f

Example Query

Query with partition filter

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

FeeRecipient_NotifyFees_event

Fee collection events from SyncSwap V1 decentralized exchange on zkSync Era, recording token amounts, fee rates, and fee types when liquidity providers or protocol treasuries receive trading fees. Used for analyzing fee revenue distribution and DEX economics across different fee types.

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_feeType`	`STRING`	Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.
`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.
`in_feeRate`	`STRING`	Fee rate applied to the transaction, represented in basis points where 50000 equals 5%. This rate determines the percentage of the transaction amount collected as protocol fees.

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	in_feeRate	in_feeType	block_number	block_timestamp	transaction_hash
0x432bcc3bc62de9186f9e8763c82d43e418681e6c	false	0x0ab03093438b5263bf8ac18368845e452fffb8b5	11528698644	0x0ab03093438b5263bf8ac18368845e452fffb8b5	6	50000	1	490219	2023-03-30T23:04:16.000Z	0x4bd2d8c364466ffbf1ef6493d509c541aa2bfa5c3108f9657e42f69e3bcb8566
0x432bcc3bc62de9186f9e8763c82d43e418681e6c	false	0x0ab03093438b5263bf8ac18368845e452fffb8b5	6152723390	0x0ab03093438b5263bf8ac18368845e452fffb8b5	7	50000	1	475128	2023-03-30T18:18:47.000Z	0x51edf6b3e362eff936b0ffd9384f243bc81241aa7b92bf167c4c95b5b672763e
0x432bcc3bc62de9186f9e8763c82d43e418681e6c	false	0x0ab03093438b5263bf8ac18368845e452fffb8b5	31344622091	0x0ab03093438b5263bf8ac18368845e452fffb8b5	16	50000	1	483501	2023-03-30T20:56:47.000Z	0x4347d3d54a83a1319d9b0980fb70336d7b7a8c8e375ab436c498238250c14b0f

Example Query

Query with partition filter

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

StablePool_Swap_event

Swap events from SyncSwap V1 stableswap pools on zkSync Era, recording token exchanges with input/output amounts, sender and recipient addresses. Used for analyzing trading volume, liquidity depth, and price impact in stable-to-stable pair 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing 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	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x80115c708e12edd42e504c1cd52aea96c547c05c	0x69b9a2eface47419d496d9a550a162185999ace5	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	101	4081273	63477492329645391230	63436747	2023-05-22T06:13:17.000Z	0x1fc140f26bbff3e91d29cc69b7c386da14c03d07ec2641b2a68204309f34b3a0
0x84edf74b36ff22cfb65c3a772a7be9ccda282c59	0x69b9a2eface47419d496d9a550a162185999ace5	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	105	4085307	393688419639515793168	393443950	2023-05-22T07:28:24.000Z	0xa8e9e7da517274cf113ae4bfa9d540a82294cc3e6f22562e9798c13c275d5fc5
0x80115c708e12edd42e504c1cd52aea96c547c05c	0x69b9a2eface47419d496d9a550a162185999ace5	false	0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295	69	4105374	5398731832773593475	5395519	2023-05-22T13:27:30.000Z	0xaf9c1b245609320e1abf6a452cf38eb751a414bda32d4cc2517d2986f1110245

Example Query

Query with partition filter

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

StablePool_Sync_event

Reserve balance updates for SyncSwap V1 stableswap pools on zkSync Era. Used for tracking liquidity changes and calculating pool 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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x06d01eb27881d9d7f1110e85df415bf00c204947	false	9	38584145821313809	4761923071825708	19241365	2023-11-17T21:12:29.000Z	0x09839564b9b052a4c8c7e19297a3f62b6a77c6534f44b45616da99713a3a843c
0x06d01eb27881d9d7f1110e85df415bf00c204947	false	10	41095786926003945	2301005261525148	19185110	2023-11-17T05:15:02.000Z	0xbbf96bbe73d23c7c3d824ddad74cf523c743442c75c0509b5696bb95ee35f43e
0x06d01eb27881d9d7f1110e85df415bf00c204947	false	21	41300363342029077	2106112746364939	19233308	2023-11-17T18:55:47.000Z	0x835e19f6cd0820f79479756efd5342a0c9d7c2be0867d87a0ec048155b0f0239

Example Query

Query with partition filter

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

StablePoolFactory_PoolCreated_event

Pool creation events emitted by StablePoolFactory contracts on decentralized exchange (DEX) platforms. Records the deployment of new stable swap pools with their contract addresses and constituent token pairs for tracking liquidity pool initialization.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x5b9f21d407f35b10cbfddca17d5d84b129356ea3	0xc58f3440b641e815ea6d3173545b97db32bdc627	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x43cd37cc4b9ec54833c8ac362dd55e58bfd62b86	23	6738484	2023-06-22T20:04:40.000Z	0xc2837472336ca332f5543564a4e7e56e099fd470833565ced22193e5451b0390
0x5b9f21d407f35b10cbfddca17d5d84b129356ea3	0x7cbbc040bccb2817cec24f5cddd13edba7d27bcf	false	0x43cd37cc4b9ec54833c8ac362dd55e58bfd62b86	0x4b9eb6c0b6ea15176bbf62841c6b2a8a398cb656	10	20011541	2023-11-27T00:06:45.000Z	0xedc038422e6e40893e7be81d660056d45460de0faf32e90cd6cde70d53fc01d5
0x5b9f21d407f35b10cbfddca17d5d84b129356ea3	0xf89f4f65ac8dea084daa0ae559fe3b6791773740	false	0x32fd44bb869620c0ef993754c8a00be67c464806	0xb54aae4a0743aeec1d584f2b2abc1ebdc12f1b0f	54	9301222	2023-07-23T00:59:28.000Z	0x361e134be5d877fd3b417996dee57508c06beb13d4ebf484d0bf2882bb78a0fe

Example Query

Query with partition filter

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

Vault_FlashLoan_event

Flash loan events emitted by decentralized exchange (DEX) vault contracts, recording uncollateralized borrows of tokens with borrowed amount, fee charged, and recipient address. Used for arbitrage tracking and flash loan analytics across Balancer V2, Beethoven X, BEX, and SyncSwap 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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	in_feeAmount	in_recipient	block_timestamp	transaction_hash
0x621425a1ef6abe91058e9712575dcc4258f8d091	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	42589687	175	3613665	21294	0x5ced67390128a1c382608354c1d139c0acd7cf8d	2023-05-16T07:59:31.000Z	0xcf42ca8c08d4351cf67030c12337b655d324359b95131b026ad1fda0cfc83dfa
0x621425a1ef6abe91058e9712575dcc4258f8d091	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	214921759	126	3611129	107460	0xf855d644d3712bc11b62203656e5f061b37ddc00	2023-05-16T07:14:14.000Z	0x45479dc4b852d63df3fd3a86ced4dc195152d0886e2ebc21b59d25fdd06e85d6
0x621425a1ef6abe91058e9712575dcc4258f8d091	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	267067088	88	3611897	133533	0xf855d644d3712bc11b62203656e5f061b37ddc00	2023-05-16T07:27:48.000Z	0xf97468e3fa99aa42a150e29f7c45381c62b7c809cf3e37c50be112c1d741c940

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ClassicPool_Swap_event

ClassicPool_Sync_event

ClassicPoolFactory_PoolCreated_event

FeeManager_SetPoolProtocolFee_event

FeeManager_SetPoolSwapFee_event

FeeRecipient_NotifyFees_event

StablePool_Swap_event

StablePool_Sync_event

StablePoolFactory_PoolCreated_event

Vault_FlashLoan_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ClassicPool_Swap_event

​ClassicPool_Sync_event

​ClassicPoolFactory_PoolCreated_event

​FeeManager_SetPoolProtocolFee_event

​FeeManager_SetPoolSwapFee_event

​FeeRecipient_NotifyFees_event

​StablePool_Swap_event

​StablePool_Sync_event

​StablePoolFactory_PoolCreated_event

​Vault_FlashLoan_event

Tables

ClassicPool_Swap_event

ClassicPool_Sync_event

ClassicPoolFactory_PoolCreated_event

FeeManager_SetPoolProtocolFee_event

FeeManager_SetPoolSwapFee_event

FeeRecipient_NotifyFees_event

StablePool_Swap_event

StablePool_Sync_event

StablePoolFactory_PoolCreated_event

Vault_FlashLoan_event