schema.graphql

type Swap
  @storage(postgres: true, clickhouse: true)
  @index(fields: ["pool", ["timestamp", "DESC"]]) {
  id: ID!
  transaction: String! # Instead of Transaction reference
  timestamp: BigInt! @index
  pool: String! # Instead of Pool reference
  token0: Token! # Changed from String to Token reference
  token1: Token! # Changed from String to Token reference
  sender: String! # Instead of Bytes
  origin: String! # Instead of Bytes
  amount0: BigDecimal!
  amount1: BigDecimal!
  amountUSD: BigDecimal!
  sqrtPriceX96: BigInt!
  tick: BigInt!
  logIndex: BigInt!
  # Fee paid for this swap in hundredths of a bip (i.e. raw PoolManager Swap.fee).
  # For dynamic-fee pools this captures the per-swap effective fee, which would
  # otherwise be lost when pool.feeTier is overwritten by the next swap.
  fee: BigInt!
}

type PoolManager @storage(postgres: true, clickhouse: true) {
  id: ID!
  poolCount: BigInt!
  txCount: BigInt!
  totalVolumeUSD: BigDecimal!
  totalVolumeETH: BigDecimal!
  totalFeesUSD: BigDecimal!
  totalFeesETH: BigDecimal!
  untrackedVolumeUSD: BigDecimal!
  totalValueLockedUSD: BigDecimal!
  totalValueLockedETH: BigDecimal!
  totalValueLockedUSDUntracked: BigDecimal!
  totalValueLockedETHUntracked: BigDecimal!
  owner: String!
  numberOfSwaps: BigInt! # total swaps on network
  hookedPools: BigInt! # number of pools with hooks
  hookedSwaps: BigInt! # number of swaps through hooked pools
}

type Pool
  @storage(postgres: true, clickhouse: true)
  @index(fields: ["hooks", ["totalValueLockedUSD", "DESC"]]) {
  id: ID!
  name: String!
  createdAtTimestamp: BigInt! @index
  createdAtBlockNumber: BigInt!
  token0: String! # Instead of Token reference
  token1: String! # Instead of Token reference
  feeTier: BigInt!
  liquidity: BigInt!
  sqrtPrice: BigInt!
  token0Price: BigDecimal!
  token1Price: BigDecimal!
  tick: BigInt
  tickSpacing: BigInt!
  observationIndex: BigInt!
  volumeToken0: BigDecimal!
  volumeToken1: BigDecimal!
  volumeUSD: BigDecimal! @index
  untrackedVolumeUSD: BigDecimal!
  feesUSD: BigDecimal!
  feesUSDUntracked: BigDecimal!
  txCount: BigInt! @index
  collectedFeesToken0: BigDecimal!
  collectedFeesToken1: BigDecimal!
  collectedFeesUSD: BigDecimal!
  totalValueLockedToken0: BigDecimal!
  totalValueLockedToken1: BigDecimal!
  totalValueLockedETH: BigDecimal!
  totalValueLockedUSD: BigDecimal! @index
  totalValueLockedUSDUntracked: BigDecimal!
  liquidityProviderCount: BigInt!
  hooks: String!
  # derived fields
  ticks: [Tick!]! @derivedFrom(field: "pool")
}

type Tick
  @storage(postgres: true, clickhouse: true)
  @index(fields: ["pool", "tickIdx"]) {
  id: ID! # <pool address>#<tickIdx>
  pool: Pool! # Pointer back to Pool
  tickIdx: BigInt!
  liquidityGross: BigInt! # abs liquidity at this boundary
  liquidityNet: BigInt! # delta when price crosses boundary
  price0: BigDecimal! # Optional – 1.0001^tickIdx
  price1: BigDecimal! # Optional inverse price
  createdAtTimestamp: BigInt!
  createdAtBlockNumber: BigInt!
}

type Token @storage(postgres: true, clickhouse: true) {
  id: ID!
  symbol: String!
  name: String!
  decimals: BigInt!
  totalSupply: BigInt!
  volume: BigDecimal!
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!
  feesUSD: BigDecimal!
  txCount: BigInt!
  poolCount: BigInt!
  totalValueLocked: BigDecimal!
  totalValueLockedUSD: BigDecimal!
  totalValueLockedUSDUntracked: BigDecimal!
  derivedETH: BigDecimal!
  whitelistPools: [String!]! # Changed from Pool reference to String for simplicity
}

# stores for USD calculations
type Bundle @storage(postgres: true, clickhouse: true) {
  id: ID!
  # price of ETH in usd
  ethPriceUSD: BigDecimal!
}

type HookStats @storage(postgres: true, clickhouse: true) {
  id: ID! # hook address
  numberOfPools: BigInt!
  numberOfSwaps: BigInt!
  firstPoolCreatedAt: BigInt!
  totalValueLockedUSD: BigDecimal! @index # Total TVL across all pools using this hook
  totalVolumeUSD: BigDecimal! # Total volume across all pools using this hook
  untrackedVolumeUSD: BigDecimal! # Untracked volume for non-whitelisted tokens
  totalFeesUSD: BigDecimal! # Total fees across all pools using this hook
}

type Position @storage(postgres: true, clickhouse: true) {
  id: ID! # <chainId>_<tokenId>
  tokenId: BigInt! @index
  owner: String! @index # address of current owner
  origin: String! # the EOA that minted the position
  createdAtTimestamp: BigInt!
  # derived fields
  subscriptions: [Subscribe!]! @derivedFrom(field: "position")
  unsubscriptions: [Unsubscribe!]! @derivedFrom(field: "position")
  transfers: [Transfer!]! @derivedFrom(field: "position")
}

type Transfer @storage(postgres: true, clickhouse: true) {
  id: ID!
  tokenId: BigInt! @index
  from: String! # address of previous owner
  to: String! # address of new owner
  transaction: String! # Instead of Transaction reference
  logIndex: BigInt!
  timestamp: BigInt! @index
  origin: String! # the EOA that initiated the tx
  position: Position!
}

type Subscribe @storage(postgres: true, clickhouse: true) {
  id: ID!
  tokenId: BigInt! @index
  address: String! # address of subscriber
  transaction: String! # Instead of Transaction reference
  logIndex: BigInt!
  timestamp: BigInt! @index
  origin: String! # the EOA that initiated the tx
  position: Position!
}

type Unsubscribe @storage(postgres: true, clickhouse: true) {
  id: ID!
  tokenId: BigInt! @index
  address: String! # address of unsubscriber
  transaction: String! # Instead of Transaction reference
  logIndex: BigInt!
  timestamp: BigInt! @index
  origin: String! # the EOA that initiated the tx
  position: Position!
}

type ModifyLiquidity
  @storage(postgres: true, clickhouse: true)
  @index(fields: ["pool", ["timestamp", "DESC"]])
  @index(fields: ["pool", "transaction"]) {
  id: ID!
  transaction: String! # Instead of Transaction reference
  timestamp: BigInt! @index
  pool: Pool! # Instead of Pool reference
  token0: Token! # Token reference like in Swap entity
  token1: Token! # Token reference like in Swap entity
  sender: String! # Instead of Bytes
  origin: String! # Instead of Bytes - the EOA that initiated the txn
  amount: BigInt! # amount of liquidity modified
  amount0: BigDecimal! # amount of token 0 modified
  amount1: BigDecimal! # amount of token 1 modified
  amountUSD: BigDecimal! @index # derived amount based on available prices of tokens
  tickLower: BigInt! # lower tick of the position
  tickUpper: BigInt! # upper tick of the position
  logIndex: BigInt! # index within the txn
}