> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# sushiswap_v1_ethereum

> Tables in tt-contracts.sushiswap_v1_ethereum

## Tables

### Factory\_PairCreated\_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

<Accordion title="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_pair`          | `STRING`    | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.                   |
  | `in_anon3`         | `STRING`    | Sequential counter tracking the total number of pairs created by the factory contract.                                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pair                                   | removed | in\_anon3 | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac | 0xe5dab4f3a526b6199fd7002765ed9aca41a3c47c | false   | 3251      | 0x396bd4f97ed0eee711ff237aed3ebf9a893e7fa5 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 249        | 15710389      | 2022-10-09T11:58:23.000Z | 0x184e8a90b830bedd76e8a2c9ac83ad4aee98a8f2f08ac44fcc38ee03b912cde6 |
  | 0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac | 0x0646583be34b133ce5d247f1d94e7effe32b58d0 | false   | 3253      | 0x0fd034abd916842c17c89bae7b1ec696e1c104a9 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 353        | 15713391      | 2022-10-09T22:02:11.000Z | 0xc6429f920351f390b392a64b76d847167a46ccd7b30eb1447ed3da0b8f77e373 |
  | 0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac | 0x1b2273311ab410d11168b8df242b8b79d8bfcdb5 | false   | 3252      | 0xca83bb94f7ec0e72e8b496ac236146a74a567c2f | 0xe0b9bcd54bf8a730ea5d3f1ffce0885e911a502c | 340        | 15710641      | 2022-10-09T12:48:59.000Z | 0x37ac1f9c6dbc68a35217edbab9e0d2c657fe2c9c73e725373a386a1a361fa191 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.sushiswap_v1_ethereum.Factory_PairCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### Pair\_Sync\_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

<Accordion title="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. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0             | in\_reserve1           | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------ | ---------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x001b6450083e531a5a7bf310bd2c1af4247e23d4 | false   | 81         | 354771809627638415873822 | 4620296900222598786786 | 11480431      | 2020-12-19T00:27:20.000Z | 0xb439e916622bf756c7f48516d8272f6b913d5c416a9e53d2b1049270a729f849 |
  | 0x001b6450083e531a5a7bf310bd2c1af4247e23d4 | false   | 35         | 352331310105486165263842 | 4652427695617434446276 | 11480783      | 2020-12-19T01:43:16.000Z | 0x3253d372d13d27d23fc6a9b943ccf53540b50b4d42170d7da61a425005074006 |
  | 0x001b6450083e531a5a7bf310bd2c1af4247e23d4 | false   | 2          | 370085607511366729280971 | 4436084317160775209504 | 11485493      | 2020-12-19T19:06:16.000Z | 0xe4be7809d031d3aa78fab95239d636fe521947d2ce91de3aa07e7267ff416696 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.sushiswap_v1_ethereum.Pair_Sync_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***