syncswap_v1_scroll

Tables

ClassicPool_Burn_event

Liquidity removal events from SyncSwap V1 ClassicPool contracts on Scroll, capturing LP token burns with withdrawn token amounts and recipient addresses. Used for analyzing liquidity provider withdrawals and pool reserves changes.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`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_amount0	in_amount1	block_number	in_liquidity	block_timestamp	transaction_hash
0x3aa964562fefa65434dfd6f5c0d52d3bb50615e3	0x054641825533d1bc3324df3c30cbc3baea812087	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	8	89008575838210634	587331305278789901770	15495461	5536563782894494997	2025-05-15T13:39:20.000Z	0x33a5f28707cd6b52b694a1139dd1522efee811ea6eee5d3113a318ed36cd929b
0x1bcb73c5ac7ea75d816fb96ebfaf0c8f21f42b71	0x054641825533d1bc3324df3c30cbc3baea812087	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	8	89762419060117085	587675056949412384621	15492394	5561624935922609706	2025-05-15T12:35:35.000Z	0x6638c6406592f8272a4b3d72c063830d866f7304bf84d5f98dc317c627a11940
0x1048d64052f227b2a68ec7ad825b14c949cfe013	0x1452b3bc70087599b22086009bb6c179b7f47b37	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	5	42106143813594589	40756945487922306	15479872	38616075048179632	2025-05-15T08:04:07.000Z	0xe8aac6f1ff3d45e7164ccfe30b5edc196c02d0b2f49075a0a8eaf7bf5229e537

Example Query

Query with partition filter

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

ClassicPool_Mint_event

Liquidity provision events from SyncSwap V1 ClassicPool contracts on Scroll, capturing mint operations where users add token pairs to pools. Records deposited token amounts, minted liquidity shares, and recipient addresses for tracking liquidity provider positions and pool growth.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`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_amount0	in_amount1	block_number	in_liquidity	block_timestamp	transaction_hash
0xeb2882ca0803c287d230264c7c585c849b099d63	0x1452b3bc70087599b22086009bb6c179b7f47b37	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	73	9799437020495664	9429937431348931	7903438	9136631371938355	2024-07-30T06:28:47.000Z	0x9ebfa9a074c6410d2d34db2ae0bb250ffd4a3dbdc80e941a32f9fc5264d30f9a
0x8e112776eff3ddb710458a27bd4c0a444a9024c4	0x1452b3bc70087599b22086009bb6c179b7f47b37	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	61	8237953444607771	7927331476547149	7910464	7680431360475214	2024-07-30T11:59:43.000Z	0x00df7b61934ae006c19f6afaab8371296dea59032a26d926c931c15e8d0b6e0c
0x7b536747adc6aed7e151996042feb24faf0e93c5	0x1452b3bc70087599b22086009bb6c179b7f47b37	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	5	7087441703253898	6820201167703084	7911450	6607750376878106	2024-07-30T12:45:50.000Z	0x933ed1effafb754bcd8dc7ef4d4ce02d16f04e05fe34814349c95e95fc4953b7

Example Query

Query with partition filter

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

ClassicPool_Swap_event

Swap event records from SyncSwap v1 ClassicPool automated market maker (AMM) on Scroll, capturing token exchange amounts and participant addresses. Used for analyzing DEX trading volume, price impact, and 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_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	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0xb450ceba37789006c5b1e09e9163c1ab04afcd18	0x78ea8e533c834049de625e05f0b4deffe9db5f6e	false	0x80e38291e06339d10aab483c65695d004dbd5c69	3229578	13439276702861170	33494591	2024-02-10T23:08:22.000Z	0x029fb871ce5c1a4ee9ea86f8c0174c6ffd9040f8d17aeb25523f07f5266dbe23
0xf2e8488c00736a9aa9c06231c0171620f8bf2fdb	0x78ea8e533c834049de625e05f0b4deffe9db5f6e	false	0x80e38291e06339d10aab483c65695d004dbd5c69	3218223	94160000000000000	233402886	2024-02-10T13:36:46.000Z	0x2a581c2278cee1a2d7e324025af4cde40c56d96074aadeabf8e8cd3b446b1f52
0x81c05d2746e07ab631e29c82a30ba8357110f988	0x78ea8e533c834049de625e05f0b4deffe9db5f6e	false	0x80e38291e06339d10aab483c65695d004dbd5c69	3212735	100000000000000	248601	2024-02-10T09:01:50.000Z	0x46dee129f3185711c57942ced3f3f5f63e20a14c0a4ffc627f2a62abf858a9ad

Example Query

Query with partition filter

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

ClassicPool_Sync_event

Reserve balance updates from SyncSwap V1 ClassicPool contracts on Scroll. Captures token pair reserves (reserve0/reserve1) after each liquidity or swap event for tracking automated market maker (AMM) pool state changes.

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
0x03fc29bc5f9398965264cf3fb76348dd414e0c67	false	2	8829435530005352	253021224461199120182	11739091	2024-12-08T07:11:04.000Z	0x3c8c1098c82fce3225b319eb09d2fa605720577dc9862f603aeb1ca02602d941
0x03fc29bc5f9398965264cf3fb76348dd414e0c67	false	3	8718920723247864	256101621349068056448	11734537	2024-12-08T02:13:30.000Z	0xeb54829bf38375c73142b09b172f3ed0f75381fe71c0981a21e2024359aac353
0x03fc29bc5f9398965264cf3fb76348dd414e0c67	false	3	8629066002156035	258776171349068056448	11734645	2024-12-08T02:20:26.000Z	0x04b19a93a21b3b6d83ea45e0f1650aaca77726d5bf1f99c52a98fe3d1b378acc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.syncswap_v1_scroll.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 Scroll, capturing new trading pairs deployed through the ClassicPoolFactory contract. Used to track pool deployments, token pair listings, and DEX ecosystem growth 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_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
0x37bac764494c8db4e54bde72f6965bea9fa0ac2d	0xbc7294c9d7f705e31c54a7a6cf16b8c71bb0175a	false	0x2b2e9a056ebaac66149789ee1da240aa62a28d71	0x5300000000000000000000000000000000000004	34	4772748	2024-04-11T00:28:32.000Z	0x87fa1b45e64b6a930fcea0bf3f8402b3afa6215cb60779bb54fcbc4fbaa9c3ae
0x37bac764494c8db4e54bde72f6965bea9fa0ac2d	0xee0e802b0f68023dc029d568d337f25e292cff8a	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x32f451f49f0833d68afa02c7d987bdeec4084be6	4	706077	2023-11-10T15:21:52.000Z	0xdbdcff7b0b71946423ad080951dc5e098c250cd54e4a7ad444bcaffe9a20bedb
0x37bac764494c8db4e54bde72f6965bea9fa0ac2d	0xd03e4c80cc9594740154210f3b14d8c9d463baa2	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x412b71691317ffbde8d539986d9d62ca93de8233	1	706081	2023-11-10T15:22:04.000Z	0x7285bd2857e5ffad4b0cc4153f412229de845799bef7671e61a2b45fc78bffce

Example Query

Query with partition filter

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

FeeRecipient_NotifyFees_event

Fee notification events from SyncSwap v1 decentralized exchange on Scroll, recording token amounts, fee rates, and fee types collected by the protocol. Used for analyzing fee revenue distribution and liquidity provider earnings 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_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 this transaction expressed in basis points, where 20000 represents 2% (20000/1000000). This value determines the percentage of the transaction amount collected as fees by the protocol.

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	in_feeRate	in_feeType	block_number	block_timestamp	transaction_hash
0xa2a09f15c2ec6af1b8f9413c148334b231410bd8	false	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	390433152615194175	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	94	20000	2	6293076	2024-06-05T10:06:28.000Z	0x8e99ebd0ada2a8d2fac9608e59b8d024fb60a0461ca6ae2771d035c6b89750d4
0xa2a09f15c2ec6af1b8f9413c148334b231410bd8	false	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	18540210215367640	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	69	20000	2	6289506	2024-06-05T07:06:00.000Z	0xaf287129bf9bf5defa831ade4b12fbd37963d42eaaea24d33eadb5cecb846e2e
0xa2a09f15c2ec6af1b8f9413c148334b231410bd8	false	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	414902203557043311	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	63	20000	2	6291250	2024-06-05T08:33:12.000Z	0xc730bb325a19de8ca31590798aa042d700d88358e851b537aa091d16f8ac75c4

Example Query

Query with partition filter

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

StablePool_Burn_event

Liquidity removal events from SyncSwap V1 stableswap pools on Scroll, recording LP token burns and withdrawn token amounts. Tracks liquidity provider exits with sender/recipient addresses and token pair withdrawal quantities for analyzing pool depth changes and exit 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`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_amount0	in_amount1	block_number	in_liquidity	block_timestamp	transaction_hash
0x200db8540e00b024357db9b48a004b467401eeb7	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	1499631228	0	8015432	1266000000000000000000	2024-08-03T01:30:00.000Z	0x673b17c150753ae604ef4b239fdad326246dbac3799122f69375b767940826b8
0x1ec700001faac176cc153b684a2c3400bad61131	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	68356667	128941532	8022853	166440979138511548918	2024-08-03T07:36:36.000Z	0x00105de40833377be55f9b662bcd682872ba97069b864f8cc7a44721c8f260f8
0xd47db5c36febd1c002f9e157e2b3cabde7c72c4d	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	0	35566589	8024748	30000000000000000000	2024-08-03T09:06:55.000Z	0x1e7819c9bd07999b878fc9dc6b932d646f55b83f262cf38d00edafe4a6d5dd83

Example Query

Query with partition filter

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

StablePool_Mint_event

Liquidity provision events from SyncSwap V1 StablePool on Scroll, recording deposits of token pairs with amounts and LP tokens minted. Used to track liquidity provider positions and pool growth 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`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_amount0	in_amount1	block_number	in_liquidity	block_timestamp	transaction_hash
0xebd96a948262f7faff8a7b35207d5dea343892c3	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	1000000	1000000	11867787	1675711218977084989	2024-12-13T02:55:30.000Z	0xe2c49cc52c98297fba548eb717102008f0bd577e1b9c2f2ec78258b472f1556d
0xa9f3cc299a4acd6b3e486aa28700144bc2734f34	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	7	555000000	555000000	11866258	930026255696992568471	2024-12-13T01:36:56.000Z	0x2f677d9607585d8d592ec0c0635ba3868629820e37086969d9757a8457bacac5
0x9326f2aa418f3647be2f861a46a1923009443c29	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	521467426	489037949	9430734	850689948376490964993	2024-09-19T15:26:30.000Z	0xc05f7f89c5cb1dab3b7ae7721a343c8098abb57c68951d8316f2e409b9fad685

Example Query

Query with partition filter

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

StablePool_Swap_event

Swap events from SyncSwap V1 stablecoin pools on Scroll, capturing token exchanges with input/output amounts, sender addresses, and recipient addresses. Used for analyzing stablecoin trading activity, slippage patterns, and liquidity depth in stable pair pools.

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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x000da32d6567a8e5dcc86f7164b1c9cbb57eb0e0	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	6	7109305	41354806	41279884	2024-07-03T18:37:44.000Z	0xaedb62d8a5eacd68fbbaa672e7c85a9b435070172ea77bb1e317230839aae880
0x0037d9231eb18662463b4b74c062bba786bd5b31	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0x80e38291e06339d10aab483c65695d004dbd5c69	7	7095343	50468186	50374387	2024-07-03T06:56:38.000Z	0x5900c44881dba6f6005d800a02d1ffc1510f4d9de0a716bec60735e3aa72551d
0x006e767bd3f7e51fe4408de1289ad1a24a67066a	0x2076d4632853fb165cf7c7e7fad592dac70f4fe1	false	0xfd541d0e2773a189450a70f06bc7edd3c1dc9115	9	7112556	60522563	60414035	2024-07-03T21:20:17.000Z	0x54fa2cb7b19fb1cdcc30622f3a76717d7c59f981169bc8711abac3c0ad957015

Example Query

Query with partition filter

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

StablePool_Sync_event

Reserve synchronization events from SyncSwap V1 stableswap pools on Scroll, capturing token pair reserve balances after each swap or liquidity operation. Used for tracking pool composition changes and analyzing stablecoin pair dynamics.

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
0x0b6ca169b7afafe418c2a49911410e57bf987a65	false	17	725347428722560971	3306329740793540495	7360082	2024-07-12T11:47:47.000Z	0x6bbba690a03e08fc790077afb5490ea5e1607af1b9817e866aafcef5f6c9e505
0x0b6ca169b7afafe418c2a49911410e57bf987a65	false	22	725348428465527454	3306329740793540495	7360574	2024-07-12T12:12:23.000Z	0x4663afda490aeea72bc101bc04853e8b526e5640692c159f764164087e77059b
0x0b6ca169b7afafe418c2a49911410e57bf987a65	false	22	726347428722560971	3305326579651896278	7360546	2024-07-12T12:10:59.000Z	0x16bc6ac2dad66978a7ed8b4717c3e17eba93a529f9b31e076a926f4dd687a70c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.syncswap_v1_scroll.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
0xe4cf807e351b56720b17a59094179e7ed9dd3727	0xab2569f58650a5489384bfe4cce88c0d2c8ad8b3	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0xd218db5f01f09e0f0391507d9252fd50966947ef	33	4973287	2024-04-20T11:58:31.000Z	0x33eff0bbb0b5c9a9987101e39c98da669387f3f9dd5e8c140d0798eaeb3c135e
0xe4cf807e351b56720b17a59094179e7ed9dd3727	0xdd85d453a0e4f762c80c773bef63eb4cf4cb9e3e	false	0x5300000000000000000000000000000000000004	0x76c5e7582149c9631021729e3f156b5fffcf1b60	2	219429	2023-10-22T18:35:31.000Z	0x58ff33783ccbb629a1d849e96007664c4be3ab74dbd4defdf53e3af9dbeeb6f2
0xe4cf807e351b56720b17a59094179e7ed9dd3727	0xf3beb3a99dde37a8dfb5e76506798bfb11dbf0fb	false	0x5300000000000000000000000000000000000004	0x53878b874283351d26d206fa512aece1bef6c0dd	13	1905929	2023-12-26T07:07:11.000Z	0x240c35aa7573e9b6465f18b9d52458434c502a5cda31cb8c18293ce811789cec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.syncswap_v1_scroll.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
0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	1075737098	16	8165946	537868	0x349f52094179fd10c5a4409721cdcca851502256	2024-08-07T18:46:45.000Z	0x428507f9867ec8c4dbfdb1426c131ba0ba135f8f6b4727ce164510f400ef09a9
0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	34167879	16	8166025	17083	0xb0229744362acc8346017ff9433671c808dda23c	2024-08-07T18:50:36.000Z	0xe9c0e70b3889b8ff6f7d905f5572076f773cec83450725cb093e788a24a89106
0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	81109818	33	8166395	40554	0xb0229744362acc8346017ff9433671c808dda23c	2024-08-07T19:08:52.000Z	0x6b0d12332a2f479bc7c24fcb7edd224f0cda686e2fe8cf965602f89b000aee6c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ClassicPool_Burn_event

ClassicPool_Mint_event

ClassicPool_Swap_event

ClassicPool_Sync_event

ClassicPoolFactory_PoolCreated_event

FeeRecipient_NotifyFees_event

StablePool_Burn_event

StablePool_Mint_event

StablePool_Swap_event

StablePool_Sync_event

StablePoolFactory_PoolCreated_event

Vault_FlashLoan_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ClassicPool_Burn_event

​ClassicPool_Mint_event

​ClassicPool_Swap_event

​ClassicPool_Sync_event

​ClassicPoolFactory_PoolCreated_event

​FeeRecipient_NotifyFees_event

​StablePool_Burn_event

​StablePool_Mint_event

​StablePool_Swap_event

​StablePool_Sync_event

​StablePoolFactory_PoolCreated_event

​Vault_FlashLoan_event

Tables

ClassicPool_Burn_event

ClassicPool_Mint_event

ClassicPool_Swap_event

ClassicPool_Sync_event

ClassicPoolFactory_PoolCreated_event

FeeRecipient_NotifyFees_event

StablePool_Burn_event

StablePool_Mint_event

StablePool_Swap_event

StablePool_Sync_event

StablePoolFactory_PoolCreated_event

Vault_FlashLoan_event