schema.graphql

type Bundle @entity {
  id: ID!

  # price of AVAX usd
  avaxPriceUSD: BigDecimal!
}

type LBFactory @entity {
  # Contract address
  id: ID!

  # Pair count
  pairCount: BigInt!

  # Volume USD
  volumeUSD: BigDecimal!

  # Volume AVAX
  volumeAVAX: BigDecimal!

  # Untracked volume
  untrackedVolumeUSD: BigDecimal!

  # tvl USD
  totalValueLockedUSD: BigDecimal!

  # tvl AVAX
  totalValueLockedAVAX: BigDecimal!

  # Transaction count
  txCount: BigInt!

  # Token count
  tokenCount: BigInt!

  # User count
  userCount: BigInt!

  # flashloan fee
  flashloanFee: BigInt!

  # pairs not used in trade routing
  ignoredLbPairs: [LBPair!]!

  feesUSD: BigDecimal!
  feesAVAX: BigDecimal!

  # Pairs
  lbPairs: [LBPair!]! @derivedFrom(field: "factory")

  # Tokens
  tokens: [Token!]! @derivedFrom(field: "factory")

  # Hour data
  hourData: [TraderJoeHourData!]! @derivedFrom(field: "factory")

  # Day data
  dayData: [TraderJoeDayData!]! @derivedFrom(field: "factory")
}

type TraderJoeHourData @entity {
  # timestamp / 3600
  id: ID!

  # date - hour start timestamp
  date: Int!

  # factory
  factory: LBFactory!

  # volume
  volumeAVAX: BigDecimal!
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!

  # TVL
  totalValueLockedAVAX: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  feesUSD: BigDecimal!

  # tx count
  txCount: BigInt!
}

type TraderJoeDayData @entity {
  # timestamp / 86400
  id: ID!

  # date
  date: Int!

  # factory
  factory: LBFactory!

  # volume
  volumeAVAX: BigDecimal!
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!

  # TVL
  totalValueLockedAVAX: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  feesUSD: BigDecimal!

  # tx count
  txCount: BigInt!
}

type Token @entity {
  # token address
  id: ID!

  # factory
  factory: LBFactory!

  # mirrored from the smart contract
  symbol: String!
  name: String!
  decimals: BigInt!

  # used for other stats like marketcap
  totalSupply: BigInt!

  # token specific volume
  volume: BigDecimal!
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!

  # transactions across all pairs
  txCount: BigInt!

  # TVL across all pairs
  totalValueLocked: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  derivedAVAX: BigDecimal!

  feesUSD: BigDecimal!

  # Token hour data
  hourData: [TokenHourData!]! @derivedFrom(field: "token")

  # Token day data
  dayData: [TokenDayData!]! @derivedFrom(field: "token")

  # Base pairs
  basePairs: [LBPair!]! @derivedFrom(field: "tokenX")

  # Quote pairs
  quotePairs: [LBPair!]! @derivedFrom(field: "tokenY")

  # Base pairs hour data
  basePairsHourData: [LBPairHourData!]! @derivedFrom(field: "tokenX")

  # Quote pairs hour data
  quotePairsHourData: [LBPairHourData!]! @derivedFrom(field: "tokenY")

  # Base pairs day data
  basePairsDayData: [LBPairDayData!]! @derivedFrom(field: "tokenX")

  # Quote pairs day data
  quotePairsDayData: [LBPairDayData!]! @derivedFrom(field: "tokenY")
}

type TokenHourData @entity {
  # timestamp / 3600
  id: ID!

  # date - hour start timestamp
  date: Int!

  # token
  token: Token!

  # volume
  volume: BigDecimal!
  volumeAVAX: BigDecimal!
  volumeUSD: BigDecimal!

  # tx count
  txCount: BigInt!

  # TVL
  totalValueLocked: BigDecimal!
  totalValueLockedAVAX: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  # price usd
  priceUSD: BigDecimal!

  feesUSD: BigDecimal!

  # opening price USD
  open: BigDecimal!
  # high price USD
  high: BigDecimal!
  # low price USD
  low: BigDecimal!
  # close price USD
  close: BigDecimal!
}

type TokenDayData @entity {
  # timestamp / 86400
  id: ID!

  # date - day start timestamp
  date: Int!

  # token
  token: Token!

  # volume
  volume: BigDecimal!
  volumeAVAX: BigDecimal!
  volumeUSD: BigDecimal!

  # tx count
  txCount: BigInt!

  # TVL
  totalValueLocked: BigDecimal!
  totalValueLockedAVAX: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  # price usd
  priceUSD: BigDecimal!

  feesUSD: BigDecimal!

  # opening price USD
  open: BigDecimal!
  # high price USD
  high: BigDecimal!
  # low price USD
  low: BigDecimal!
  # close price USD
  close: BigDecimal!
}

type SJoeDayData @entity {
  # Timestmap / 86400
  id: ID!

  # date - day start timestamp
  date: Int!

  amountX: BigDecimal!
  amountY: BigDecimal!

  collectedAVAX: BigDecimal!
  collectedUSD: BigDecimal!
}

type LBPair @entity {
  # Contract address
  id: ID!

  # Factory
  factory: LBFactory!

  # Name
  name: String!

  # Base Fee
  baseFeePct: BigDecimal!

  # mirrored from the smart contract
  tokenX: Token!
  tokenY: Token!
  binStep: BigInt!
  activeId: BigInt!

  reserveX: BigDecimal!
  reserveY: BigDecimal!

  # tvl
  totalValueLockedAVAX: BigDecimal!
  totalValueLockedUSD: BigDecimal!

  # Price in terms of the asset pair
  tokenXPrice: BigDecimal!
  tokenYPrice: BigDecimal!

  # Price in terms of USDC
  tokenXPriceUSD: BigDecimal!
  tokenYPriceUSD: BigDecimal!

  # lifetime volume stats
  volumeTokenX: BigDecimal!
  volumeTokenY: BigDecimal!
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!
  txCount: BigInt!
  feesTokenX: BigDecimal!
  feesTokenY: BigDecimal!
  feesUSD: BigDecimal! # swap fees
  # Fields used to help derived relationship
  # used to detect new exchanges
  liquidityProviderCount: BigInt!

  bins: [Bin!]! @derivedFrom(field: "lbPair")
  liquidityPositions: [LiquidityPosition!]! @derivedFrom(field: "lbPair")
  dayData: [LBPairDayData!]! @derivedFrom(field: "lbPair")
  hourData: [LBPairHourData!]! @derivedFrom(field: "lbPair")

  # Transactions
  mints: [Mint!]! @derivedFrom(field: "lbPair")
  burns: [Burn!]! @derivedFrom(field: "lbPair")
  swaps: [Swap!]! @derivedFrom(field: "lbPair")
  flashed: [Flash!]! @derivedFrom(field: "lbPair")
  collects: [Collect!]! @derivedFrom(field: "lbPair")
  transfers: [Transfer!]! @derivedFrom(field: "lbPair")

  # Created at
  timestamp: BigInt!
  block: BigInt!
}

type LBPairParameterSet @entity {
  # LBPair address
  id: ID!
  sender: Bytes!
  lbPair: LBPair!
  binStep: BigInt!
  baseFactor: BigInt!
  filterPeriod: BigInt!
  decayPeriod: BigInt!
  reductionFactor: BigInt!
  variableFeeControl: BigInt!
  protocolShare: BigInt!
  protocolSharePct: BigDecimal!
  maxVolatilityAccumulated: BigInt!
}

type Bin @entity {
  id: ID! # lbPair address + # + binId
  lbPair: LBPair!

  priceX: BigDecimal!
  priceY: BigDecimal!

  totalSupply: BigInt!
  reserveX: BigDecimal!
  reserveY: BigDecimal!

  binId: BigInt!

  liquidityProviders: [String!]!
  liquidityProviderCount: BigInt!
}

type User @entity {
  # Address
  id: ID!

  # Approval for All
  lbTokenApprovals: [Bytes!]!

  # Liquidity Positions
  liquidityPositions: [LiquidityPosition!]! @derivedFrom(field: "user")

  # fees collected by user for providing liquidity
  collects: [Collect!]! @derivedFrom(field: "recipient")
}

type LBPairDayData @entity {
  # timestamp / 86400
  id: ID!

  # date - day start timestamp
  date: Int!

  # pair
  lbPair: LBPair!

  tokenX: Token!
  tokenY: Token!

  # reserves
  reserveX: BigDecimal!
  reserveY: BigDecimal!

  # tvl at end of day
  totalValueLockedUSD: BigDecimal!

  # volume
  volumeTokenX: BigDecimal!
  volumeTokenY: BigDecimal!

  # volume usd
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!

  # tx count
  txCount: BigInt!

  # swap fees
  feesUSD: BigDecimal!
}

type LBPairHourData @entity {
  # timestamp / 3600
  id: ID!

  # date - hour start timestamp
  date: Int!

  # pair
  lbPair: LBPair!

  tokenX: Token!
  tokenY: Token!

  # reserves
  reserveX: BigDecimal!
  reserveY: BigDecimal!

  # tvl at end of hour
  totalValueLockedUSD: BigDecimal!

  # volume
  volumeTokenX: BigDecimal!
  volumeTokenY: BigDecimal!

  # volume usd
  volumeUSD: BigDecimal!
  untrackedVolumeUSD: BigDecimal!

  # tx count
  txCount: BigInt!

  # swap fees
  feesUSD: BigDecimal!
}

type LiquidityPosition @entity {
  # lbPair address + user address
  id: ID!
  user: User!
  lbPair: LBPair!

  # user's bins liquidities
  userBinLiquidities: [UserBinLiquidity!]!
    @derivedFrom(field: "liquidityPosition")
  binsCount: BigInt!

  # block info
  block: Int!
  timestamp: Int!
}

type UserBinLiquidity @entity {
  # lbPair address + user + binId
  id: ID!

  # lbPair address + user address
  liquidityPosition: LiquidityPosition!

  # lbPair address + binId
  lbPairBinId: Bin!

  lbPair: LBPair!
  user: User!
  binId: BigInt!
  liquidity: BigInt!

  block: Int!
  timestamp: Int!
}

type UserFeesData @entity {
  # {lbPairAddress}-{userAddress}
  id: ID!

  user: User!
  lbPair: LBPair!

  accruedFeesX: BigDecimal!
  accruedFeesY: BigDecimal!
  accruedFeesL: BigDecimal!

  collectedFeesX: BigDecimal!
  collectedFeesY: BigDecimal!
}

type UserFeesHourData @entity {
  # {lbPairAddress}-{userAddress}-{hourId}
  id: ID!
  # hour start timestamp
  date: Int!

  user: User!
  lbPair: LBPair!

  accruedFeesX: BigDecimal!
  accruedFeesY: BigDecimal!
  accruedFeesL: BigDecimal!

  collectedFeesX: BigDecimal!
  collectedFeesY: BigDecimal!
}

type Transaction @entity {
  # transaction hash
  id: ID!

  # block info
  blockNumber: Int!
  timestamp: Int!

  mints: [Mint!]! @derivedFrom(field: "transaction")
  burns: [Burn!]! @derivedFrom(field: "transaction")
  swaps: [Swap!]! @derivedFrom(field: "transaction")
  flashed: [Flash!]! @derivedFrom(field: "transaction")
  collects: [Collect!]! @derivedFrom(field: "transaction")
  transfers: [Transfer!]! @derivedFrom(field: "transaction")
}

type Mint @entity {
  # transaction hash + "#" + index in mints Transaction array
  id: ID!
  transaction: Transaction!
  timestamp: Int! # need this to pull recent txns for specific token or pair
  # pair
  lbPair: LBPair!

  # populated from the primary Transfer event
  lbTokenAmount: BigInt!

  # populated from the Mint event
  sender: Bytes!
  recipient: Bytes!
  origin: Bytes!

  amountX: BigDecimal!
  amountY: BigDecimal!
  # derived amount based on available prices of tokens
  amountUSD: BigDecimal!

  logIndex: BigInt!
}

type Burn @entity {
  # transaction hash + "#" + index in burns Transaction array
  id: ID!
  transaction: Transaction!
  timestamp: Int! # need this to pull recent txns for specific token or pair
  # pair
  lbPair: LBPair!

  # populated from the primary Transfer event
  lbTokenAmount: BigInt!

  # populated from the Mint event
  sender: Bytes!
  recipient: Bytes!
  origin: Bytes!

  amountX: BigDecimal!
  amountY: BigDecimal!
  # derived amount based on available prices of tokens
  amountUSD: BigDecimal!

  logIndex: BigInt!
}

type Swap @entity {
  # transaction hash + "#" + index in swaps Transaction array
  id: ID!
  transaction: Transaction!
  timestamp: Int! # need this to pull recent txns for specific token or pair
  # pair
  lbPair: LBPair!

  # populated from the Swap event
  sender: Bytes!
  recipient: Bytes!
  origin: Bytes!
  activeId: BigInt!

  amountXIn: BigDecimal!
  amountYIn: BigDecimal!
  amountXOut: BigDecimal!
  amountYOut: BigDecimal!
  amountUSD: BigDecimal!

  feesTokenX: BigDecimal!
  feesTokenY: BigDecimal!
  feesUSD: BigDecimal!

  logIndex: BigInt!
}

type Flash @entity {
  # transaction hash + "#" + index in Flash Transaction array
  id: ID!
  transaction: Transaction!
  timestamp: Int! # need this to pull recent txns for specific token or pair
  # pair
  lbPair: LBPair!

  # populated from the FlashLoan event
  sender: Bytes!
  origin: Bytes!
  recipient: Bytes!

  token: Token!

  amount: BigDecimal!
  amountUSD: BigDecimal!

  fees: BigDecimal!
  feesUSD: BigDecimal!

  logIndex: BigInt!
}

type Collect @entity {
  # transaction hash + "#" + index in collect Transaction array
  id: ID!
  transaction: Transaction!
  timestamp: Int!

  lbPair: LBPair!

  amountX: BigDecimal!
  amountY: BigDecimal!

  recipient: User!
  origin: Bytes!

  collectedAVAX: BigDecimal!
  collectedUSD: BigDecimal!

  logIndex: BigInt!
}

# indexes both TransferSingle and TransferBatch events
type Transfer @entity {
  # transaction hash + "#" + index in transfer Transaction array + "#" + (optional: TransferBatch index)
  id: ID!
  transaction: Transaction!
  timestamp: Int!

  isBatch: Boolean!
  batchIndex: Int # optional only for TransferBatch event
  isMint: Boolean!
  isBurn: Boolean!

  lbPair: LBPair!

  binId: BigInt!
  amount: BigInt!

  sender: Bytes!
  from: Bytes!
  to: Bytes!

  origin: Bytes!
  logIndex: BigInt!
}