schema.graphql

# GENERATED, DO NOT MODIFY

type UtilCache @entity {
  id: ID! @index
  data: JSON!
}
"""
Any entity which has a price associated with it should have that price go in here.
Prices can change very frequently and we don't want those changes on the same track
as values which change less frequently.
"""
type ExchangeRate @entity {
  """
  Format: 'chainId:blockNumber:pair' ex '1:123456789:ETH_USD'
  """
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  pair: String!
  base: String!
  quote: String!
  rate: BigInt!
  decimals: Int!
}

"""
Daily historical exchange rates for selected FX pairs.
"""
type ExchangeRateDaily @entity {
  """
  Format: 'chainId:date:pair' ex '1:2026-04-17:ETH_USD'
  """
  id: ID!
  chainId: Int! @index
  date: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  pair: String! @index
  base: String!
  quote: String!
  rate: BigInt!
  decimals: Int!
}
type NativeBalance @entity {
  """
  Format: 'account:blockNumber'
  """
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  account: String!
  balance: BigInt!
}
type LegacyStaker @entity {
  id: ID! @index
  inputAmount: BigInt!
  outputAmount: BigInt!
  balance: BigInt!
  rewardAmount: BigInt!
}
type CurvePool @entity {
  id: ID!
  address: String! @index
  name: String!
  tokenCount: Int!
  token0: String!
  token1: String!
  token2: String
}

type CurvePoolBalance @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String!
  balance0: BigInt!
  balance1: BigInt!
  balance2: BigInt!
}

type CurvePoolRate @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String!
  name: String!
  rate: BigInt!
}
# Merkl reward campaigns created by Origin (filtered on-chain by `creator`).
#
# The on-chain NewCampaign event does NOT contain the targeted contract — that lives
# in Merkl's off-chain payload. So we capture our own campaigns trustlessly on-chain
# (by creator) and resolve `targetToken` (and `armAddress`, when the target is one of
# our ARMs) inline via the Merkl API at capture time, so each row is written complete.
type MerklCampaign @entity {
  id: ID! # `${chainId}:${campaignId}`
  chainId: Int! @index
  campaignId: String! @index
  # On-chain CampaignParameters.creator (msg.sender of createCampaign) — our filter key.
  creator: String! @index
  rewardToken: String! @index
  # Reward token decimals (Merkl API params.decimalsRewardToken), for valuing `amount`.
  rewardTokenDecimals: Int!
  # Gross budget including Merkl fees; immutable after creation.
  amount: BigInt!
  campaignType: Int! @index
  startTimestamp: DateTime!
  endTimestamp: DateTime!
  # Seconds; mutable via overrideCampaign.
  duration: Int!
  # Merkl distribution strategy (params.distributionMethodParameters.distributionMethod), e.g.
  # "MAX_APR". Determines actual emission vs the max (amount/duration). null if unknown.
  distributionMethod: String
  # APR cap for MAX_APR campaigns (params.distributionSettings.apr, e.g. 0.02 = 2%); null when
  # uncapped. Actual daily rewards = min(amount/duration, aprCap * TVL / 365).
  aprCap: Float
  # Raw 32-byte campaignData (off-chain payload pointer/hash), for reference.
  campaignData: String!
  # Resolved via Merkl API (params.targetToken) at capture time: the contract whose
  # holders earn rewards. null only if the campaign genuinely has no target.
  targetToken: String @index
  # = targetToken when it is one of our ARM LP tokens, else null. For ARM APY joins.
  armAddress: String @index
  createdBlockNumber: Int! @index
  createdTimestamp: DateTime! @index
  createdTxHash: String! @index
  lastUpdatedBlockNumber: Int!
  lastUpdatedTimestamp: DateTime!
}
type ProtocolDailyStat @entity {
  id: ID!
  date: String! @index
  timestamp: DateTime! @index
  rateUSD: BigInt!
  supply: BigInt!
  earningTvl: BigInt! # TVL of the product, including fees.
  tvl: BigInt!
  yield: BigInt! # Yield generated, including fees.
  revenue: BigInt! # Fees generated.
  apy: Float!
  meta: JSON!
}

type ProtocolDailyStatDetail @entity {
  id: ID!
  date: String! @index
  product: String! @index
  timestamp: DateTime! @index
  rateUSD: BigInt!
  rateETH: BigInt!
  supply: BigInt!
  earningTvl: BigInt!
  tvl: BigInt!
  yield: BigInt! # Yield generated by the product, including fees.
  revenue: BigInt! # Fees generated by the product.
  apy: Float!
  inheritedTvl: BigInt! # TVL of the product that is inherited from another product.
  inheritedYield: BigInt! # Yield of the product that is inherited from another product.
  inheritedRevenue: BigInt! # Fees of the product that is inherited from another product.
  bridgedTvl: BigInt! # TVL of the product that is bridged from another product.
}
type BeaconDepositEvent @entity {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  caller: String! @index
  # Event Data
  pubkey: BeaconDepositPubkey!
  withdrawalCredentials: String!
  amount: String!
  signature: String!
  index: String!
}

type BeaconDepositPubkey @entity {
  id: ID! # `pubkey`
  createDate: DateTime!
  lastUpdated: DateTime!
  count: Int!
  deposits: [BeaconDepositEvent!] @derivedFrom(field: "pubkey")
}

type AccountingConsensusRewards @entity {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  rewards: BigInt!
}

type ExecutionRewardsCollected @entity {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  strategy: String! @index
  amount: BigInt!
}
type CoinGeckoCoinData @entity {
  id: ID!
  product: String! @index
  date: String! @index
  vsCurrency: String!
  price: Float!
  marketCap: Float!
  tradingVolume: Float!
}
type OGNBuyback @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  operator: String! @index
  tokenSold: String!
  amountSold: BigInt!
  ognBought: BigInt!
  ognBoughtUSD: Float!
  txHash: String!
}
type WalletLabels @entity {
  id: ID! @index
  address: String!
  description: String!
  labels: [String!]!
  lastUpdated: DateTime!
}
type OGNDailyStat @entity {
  id: ID!
  blockNumber: Int! @index
  timestamp: DateTime! @index

  totalSupply: BigInt!
  totalSupplyUSD: Float!
  circulatingSupply: BigInt!
  totalStaked: BigInt!
  tradingVolumeUSD: Float!
  marketCapUSD: Float!
  priceUSD: Float!
  holdersOverThreshold: Int!
}
type OGV @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  circulating: BigInt!
  staked: BigInt!
  total: BigInt!
}

type OGVAddress @entity {
  id: ID! @index
  balance: BigInt!
  staked: BigInt!
  veogvBalance: BigInt!
  votingPower: BigInt!
  delegatee: OGVAddress
  lastUpdated: DateTime!
}

enum OGVLockupEventType {
  Staked
  Unstaked
  Extended
}

type OGVLockupTxLog @entity {
  id: ID!
  hash: String!
  event: OGVLockupEventType!
  timestamp: DateTime!
  blockNumber: Int!
  totalSupply: BigInt!
  ogvLockup: OGVLockup!
}

type OGVLockup @entity {
  id: ID!
  lockupId: String! @index
  address: OGVAddress! @index
  logs: [OGVLockupTxLog]! @derivedFrom(field: "ogvLockup")
  amount: BigInt!
  end: DateTime!
  veogv: BigInt! # Amount of veOGV received
  timestamp: DateTime!
  # active: Boolean
}

enum OGVProposalState {
  Pending
  Active
  Canceled
  Defeated
  Succeeded
  Queued
  Expired
  Executed
}

enum OGVProposalEvent {
  Created
  Queued
  Canceled
  Extended
  Executed
}

enum OGVVoteType {
  Against
  For
  Abstain
}

type OGVProposalTxLog @entity {
  id: ID!
  hash: String!
  event: OGVProposalEvent!
  timestamp: DateTime!
  proposal: OGVProposal! @index
}

type OGVProposal @entity {
  id: ID! @index
  description: String
  proposer: OGVAddress!
  timestamp: DateTime!
  startBlock: BigInt!
  endBlock: BigInt!
  lastUpdated: DateTime!
  status: OGVProposalState!
  logs: [OGVProposalTxLog]! @derivedFrom(field: "proposal")
  quorum: BigInt!
  choices: [String]!
  scores: [String]!
}

type OGVProposalVote @entity {
  id: ID!
  proposal: OGVProposal! @index
  voter: OGVAddress! @index
  weight: BigInt!
  type: OGVVoteType!
  txHash: String!
  timestamp: DateTime!
}

type OGVDailyStat @entity {
  id: ID!
  blockNumber: Int! @index
  timestamp: DateTime! @index

  totalSupply: BigInt!
  totalSupplyUSD: Float!
  totalStaked: BigInt!
  tradingVolumeUSD: Float!
  marketCapUSD: Float!
  priceUSD: Float!
  holdersOverThreshold: Int!
}
type TransactionDetails @entity {
  id: ID!
  chainId: Int! @index
  txHash: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  from: String! @index
  to: String! @index
  gasUsed: BigInt!
  effectiveGasPrice: BigInt!
  transactionFee: BigInt!
}
type Pool @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  exchange: String! @index
  name: String
  symbol: String
  tokens: [String!]!
  symbols: [String!]!
  decimals: [Int!]!
  type: String!
  createdAtBlock: Int!
  createdAt: DateTime!
}
# Pool Booster Events
type PoolBooster @entity {
  id: ID! @index # chainId-address
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  registryAddress: String! @index
  ammPoolAddress: String! @index
  factoryAddress: String! @index
  poolBoosterType: Int!
  active: Boolean!
}

type PoolBoosterBribeExecuted @entity {
  id: ID! @index # chainId-address-txHash
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String!
  amount: BigInt!
  fee: BigInt!
}
type OToken @entity {
  id: ID! @index
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  unallocatedSupply: BigInt!
  totalSupply: BigInt!
  rebasingSupply: BigInt!
  nonRebasingSupply: BigInt!
  creditsPerToken: BigInt!
  holderCount: Int!
}

type OTokenRawData @entity {
  id: ID! @index
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  type: String!
  data: JSON!
}

type WOToken @entity {
  id: ID! @index
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  totalAssets: BigInt!
  totalSupply: BigInt!
  assetsPerShare: BigInt!
}

type WOTokenAddressYield @entity {
  id: ID! # chainId:wotoken:address:date
  chainId: Int! @index
  wotoken: String! @index # wrapped ERC4626 token address (the ERC20 whose transfers are tracked)
  otoken: String! @index # underlying OToken address (denomination of value/yield; used for USD valuation)
  address: String! @index # holder
  date: String! @index
  timestamp: DateTime!
  blockNumber: Int! @index
  balance: BigInt! # wrapped-share balance
  value: BigInt! # balance * assetsPerShare / 1e18, in underlying OToken units
  costBasis: BigInt! # cost of the position, in underlying OToken units
  yield: BigInt! # yield accrued on this date, in underlying OToken units
  cumulativeYield: BigInt! # lifetime yield, in underlying OToken units
  roi: Float!
  lastR: BigInt! # last checkpointed assetsPerShare (previewRedeem(1e18))
  yieldRemainder: BigInt! # sub-wei accrual carry
}

type OTokenAsset @entity {
  id: ID! @index
  chainId: Int! @index
  otoken: String! @index
  address: String! @index
  symbol: String!
}

type OTokenAddress @entity {
  id: ID! @index
  chainId: Int! @index
  otoken: String! @index
  address: String! @index
  isContract: Boolean!
  rebasingOption: RebasingOption!
  credits: BigInt!
  creditsPerToken: BigInt!
  balance: BigInt!
  earned: BigInt!
  yieldTo: String # For delegation source
  yieldFrom: String # For delegation target
  blockNumber: Int!
  lastUpdated: DateTime!
  since: DateTime
  history: [OTokenHistory!]! @derivedFrom(field: "address")
}

type OTokenAddressYield @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  address: String! @index
  date: String! @index
  timestamp: DateTime!
  blockNumber: Int! @index
  balance: BigInt!
  costBasis: BigInt!
  yield: BigInt!
  cumulativeYield: BigInt!
  roi: Float!
}

type OTokenHistory @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  address: OTokenAddress! @index
  value: BigInt!
  balance: BigInt!
  timestamp: DateTime!
  blockNumber: Int! @index
  txHash: String! @index
  type: HistoryType!
}

type OTokenRebase @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  totalSupply: BigInt!
  rebasingCredits: BigInt!
  rebasingCreditsPerToken: BigInt!
  apy: OTokenAPY!
  fee: BigInt!
  feeETH: BigInt!
  feeUSD: BigInt!
  yield: BigInt!
  yieldETH: BigInt!
  yieldUSD: BigInt!
}

type OTokenRebaseOption @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  address: OTokenAddress!
  status: RebasingOption!
  delegatedTo: String
}

type OTokenAPY @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String @index
  date: String! @index
  apr: Float!
  apy: Float!
  apy7DayAvg: Float!
  apy14DayAvg: Float!
  apy30DayAvg: Float!
  rebasingCreditsPerToken: BigInt!
}

type OTokenVault @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  vaultBuffer: BigInt!
  totalValue: BigInt!
  claimable: BigInt!
}

type OTokenActivity @entity {
  id: ID!
  chainId: Int! @index
  otoken: String! @index
  account: String @index
  counterparty: String @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  type: OTokenActivityType
  data: JSON
}

enum OTokenActivityType {
  Approval
  Bridge
  ClaimRewards
  DelegateVote
  ExtendStake
  Migrate
  Stake
  Transfer
  Swap
  Wrap
  Unwrap
  Mint
  Redeem
  Zap
  Unstake
  Vote
}

type OTokenDailyStat @entity {
  id: ID! # chain-otokenAddress-YYYY-MM-DD
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  date: String! @index

  apr: Float!
  apy: Float!
  apy7: Float!
  apy14: Float!
  apy30: Float!

  peg: BigInt!
  rateUSD: BigInt!
  rateETH: BigInt!
  rateNative: BigInt!

  totalSupply: BigInt!
  rebasingSupply: BigInt!
  nonRebasingSupply: BigInt!
  wrappedSupply: BigInt!
  rateWrapped: BigInt!

  amoSupply: BigInt
  dripperWETH: BigInt!

  yield: BigInt!
  fees: BigInt!
  cumulativeYield: BigInt!
  cumulativeFees: BigInt!

  marketCapUSD: Float!
  accountsOverThreshold: Int!
}

type OTokenDripperState @entity {
  id: ID! # chain-otokenAddress-blockNumber
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  wethBalance: BigInt!
  availableFunds: BigInt!
  lastCollect: BigInt!
  perSecond: BigInt!
  perSecondTarget: BigInt
  perSecondMax: BigInt
  dripDuration: BigInt!
}

type OTokenHarvesterYieldSent @entity {
  id: ID! # log.id
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  txHash: String!
  yield: BigInt!
  fee: BigInt!
}

type OTokenRewardTokenCollected @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  strategy: String!
  recipient: String!
  rewardToken: String!
  amount: BigInt!
}

type OTokenWithdrawalRequest @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  requestId: BigInt!
  withdrawer: String!
  amount: BigInt!
  queued: BigInt!
  claimed: Boolean!
  claimedAt: DateTime
  claimableAt: DateTime
  queueWait: BigInt
  txHash: String! @index
}

type OTokenYieldForwarded @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  otoken: String! @index
  from: String!
  to: String!
  fromBalance: BigInt!
  amount: BigInt!
}

enum RebasingOption {
  OptIn
  OptOut
  YieldDelegationSource
  YieldDelegationTarget
}

enum HistoryType {
  Sent
  Received
  Yield
}
type MorphoVaultApy @entity {
  """
  Format: '{chainId}:{vaultAddress}:{blockNumber}'
  """
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  vaultAddress: String! @index
  apy: Float!
}
# - P1: For UI
#     - stETH ARM TVL
#     - stETH ARM APY 30 day trailing
#     - stETH ARM historical APY chart
#     - Deposited balance per wallet address
#     - stETH ARM deposits/ withdrawals (notification in bot channel)
# - Nice to Have (not launch blocking):
#     - Breakout of what is external liquidity vs. deposited by Origin
#     - stETH ARM # of external LPs
#     - stETH ARM size of holdings of external LPs
#     - stETH  redemption queue length
#     - Activity history (deposits/withdrawals per wallet address)
#     - Earnings per wallet address

type Arm @entity {
  id: ID!
  chainId: Int!
  address: String!
  name: String!
  symbol: String!
  decimals: Int!
  token0: String! # liquidity asset (WETH / USDe / wS)
  token1: String! # primary base asset; == baseAssets[0] (legacy, kept for back-compat)
  # Full asset registry (arm-oeth PR #221). Ordered and APPEND-ONLY: [0] = liquidity
  # asset (== token0); [1+] = base assets, appended on BaseAssetAdded. Index i is the
  # alignment key for every asset* array on ArmState / ArmDailyStat. Never reorder/remove.
  assets: [String!]! # asset addresses, e.g. [WETH, stETH, wstETH]
  assetSymbols: [String!]! # e.g. ["WETH", "stETH", "wstETH"]
  assetDecimals: [Int!]! # ERC20 decimals, aligned to assets
  assetPegged: [Boolean!]! # true = 1:1 with liquidity asset (rate 1.0); [0] is always true
  # IAssetAdapter address per asset (from BaseAssetAdded), used for the rate via
  # convertToAssets. Zero address for [0] (liquidity asset) and pre-upgrade base assets.
  assetAdapters: [String!]!
  # Block at which the first BaseAssetAdded was observed = the multi-base upgrade
  # (arm-oeth PR #221). Null pre-upgrade. Drives old-format vs new-format reads.
  upgradeBlock: Int
}

type ArmState @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  assets0: BigInt!
  assets1: BigInt!
  outstandingAssets1: BigInt!
  marketAssets: BigInt!
  feesAccrued: BigInt!
  totalAssets: BigInt!
  totalAssetsCap: BigInt!
  totalSupply: BigInt!
  assetsPerShare: BigInt!
  totalDeposits: BigInt!
  totalWithdrawals: BigInt!
  totalWithdrawalsClaimed: BigInt!
  totalYield: BigInt!
  totalFees: BigInt!
  claimable: BigInt!
  # Aligned to Arm.assets (append-only). Decimal strings (Subsquid can't codegen BigInt arrays).
  # assetBalances[i] = raw balanceOf(asset i); [0] = idle liquidity (== assets0).
  assetBalances: [String!]!
  # assetTotals[0] = assets0 + outstandingAssets1 + marketAssets (all liquidity-denominated value);
  # assetTotals[i>0] = balanceOf(asset i). assetTotals[i] x assetRates[i] = value in liquidity terms.
  assetTotals: [String!]!
  # Per-asset protocol redemptions in-flight (adapter withdrawal queues), aligned to Arm.assets.
  # [0] = liquidity asset (never redeems into itself) = 0; [i>0] = pendingRedeemAssets for base
  # asset i, liquidity-denominated. Per-asset form of outstandingAssets1 (== sum of [1+]).
  outstandingAssets: [String!]!
  # Lending-market position factors (for yield-source attribution). marketShares =
  # IERC4626(activeMarket).balanceOf(arm); marketPricePerShare = convertToAssets(1e18), 1e18-scaled
  # (== 1e18 when no market). marketAssets == marketShares x marketPricePerShare / 1e18.
  # activeMarket = current market address (ADDRESS_ZERO if none); a change signals a market switch.
  marketShares: BigInt!
  marketPricePerShare: BigInt!
  activeMarket: String!
}

type ArmDailyStat @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  date: String! @index
  address: String! @index
  assets0: BigInt!
  assets1: BigInt!
  outstandingAssets1: BigInt!
  marketAssets: BigInt!
  feesAccrued: BigInt!
  totalAssets: BigInt!
  totalAssetsCap: BigInt!
  totalSupply: BigInt!
  assetsPerShare: BigInt!
  totalDeposits: BigInt!
  totalWithdrawals: BigInt!
  totalWithdrawalsClaimed: BigInt!
  apr: Float!
  apy: Float!
  # External incentive rewards (currently Merkl campaigns) targeting this ARM. Kept separate from
  # the protocol numbers above — incentives are paid outside the pool, so they don't touch
  # `yield`/`apr`/`apy`. The frontend sums them for a holder's total. 0 when no campaigns active.
  incentiveYield: BigInt! # day's incentive reward value, in token0 units (parallel to `yield`)
  incentiveApr: Float!
  incentiveApy: Float!
  yield: BigInt!
  fees: BigInt!
  cumulativeYield: BigInt!
  cumulativeFees: BigInt!
  rateUSD: Float!
  rateETH: Float!
  rateNative: Float!
  rateAsset1: Float! # primary base->liquidity rate; == assetRates[1] (legacy)
  # Historical asset registry for this snapshot. All arrays below use the same indexes;
  # [0] = liquidity asset and [1+] = base assets active by the end of this day.
  assets: [String!]!
  assetSymbols: [String!]!
  assetDecimals: [Int!]!
  assetBalances: [String!]! # raw balanceOf(asset i); [0] = idle liquidity
  # assetTotals[0] = assets0 + outstandingAssets1 + marketAssets; [i>0] = balanceOf(asset i).
  assetTotals: [String!]!
  # Raw-unit asset->liquidity conversion factor, 1e18-scaled. This keeps
  # rawBalance * assetRates / 1e18 in raw liquidity units even when decimals differ.
  assetRates: [String!]!
  # Human-unit prices, all normalized to 1e18 and aligned to assets.
  # assetRatesLiquidity[0] = 1e18; the other arrays start with the liquidity asset's price.
  assetRatesLiquidity: [String!]!
  assetRatesUSD: [String!]!
  assetRatesETH: [String!]!
  assetRatesNative: [String!]!
  # Per-asset protocol redemptions in-flight, aligned to Arm.assets. [0] = 0 (liquidity asset);
  # [i>0] = liquidity-denominated pendingRedeemAssets for base asset i. == sum is outstandingAssets1.
  outstandingAssets: [String!]!
  # Lending-market position snapshot (informational; ArmDailyAssetYield.lendingYield is accrued
  # segment-by-segment, not derived from these). See ArmState for semantics.
  marketShares: BigInt!
  marketPricePerShare: BigInt!
  activeMarket: String!
}

type ArmAddressYield @entity {
  id: ID!
  chainId: Int! @index
  arm: String! @index
  address: String! @index
  date: String! @index
  timestamp: DateTime!
  blockNumber: Int! @index
  balance: BigInt!
  value: BigInt!
  costBasis: BigInt!
  yield: BigInt!
  cumulativeYield: BigInt!
  roi: Float!
  lastR: BigInt!
  yieldRemainder: BigInt!
}

type ArmWithdrawalRequest @entity {
  id: ID!
  chainId: Int! @index
  txHash: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  account: String! @index
  requestId: BigInt!
  amount: BigInt!
  queued: BigInt!
  claimed: Boolean!
  claimedAt: DateTime
  claimableAt: DateTime
}

type ArmSwap @entity {
  id: ID!
  chainId: Int! @index
  txHash: String! @index
  txFrom: String!
  txTo: String!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  from: String!
  # One row per (transaction, base asset, direction), paired from the tx's ERC20 Transfer logs.
  # Modeled as an explicit swap: tokenIn/amountIn = what the trader supplied (ARM received);
  # tokenOut/amountOut = what the trader received (ARM sent). amount* are RAW token units; rate*
  # is each token's raw-unit asset0 (liquidity) conversion factor at the swap block, 1e18-scaled.
  # Every swap has the liquidity asset on exactly one side (the contract forbids base<->base).
  # Derived: raw asset0 value = raw amount x rate / 1e18;
  # execution price = amountOut / amountIn; spread = valueOut / valueIn.
  tokenIn: String! @index
  tokenOut: String! @index
  amountIn: BigInt!
  amountOut: BigInt!
  rateIn: BigInt!
  rateOut: BigInt!
  # Legacy ARM-perspective signed deltas in asset0 terms (assets1 = base x rate). Kept for
  # back-compat; superseded by the token*/amount*/rate* fields above.
  assets0: BigInt!
  assets1: BigInt!
  # Realized trading profit in liquidity (token0) terms: (amountIn*rateIn - amountOut*rateOut)/1e18.
  # The redeemable-value delta this swap causes, valuing each leg at its redemption rate (liquidity
  # asset = 1e18, base asset = adapter rate). >0 when the ARM acquires base below redeemable value;
  # ~0 on rearm-to-liquidity legs. Summed per base asset per day into ArmDailyAssetYield.tradingYield.
  spread: BigInt!
}

type TraderateChanged @entity {
  id: ID!
  chainId: Int! @index
  txHash: String! @index
  txFee: BigInt!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  # One entity covers both event versions (arm-oeth PR #221 / withdraw-on-swap), dual-written:
  # the old event maps traderate0->buyPrice, traderate1->sellPrice (asset = token1); the new
  # event maps buyPrice->traderate0, sellPrice->traderate1. So traderate*/buy/sellPrice and asset
  # are always set (non-null). The liquidity-remaining fields only exist on the new event -> nullable.
  traderate0: BigInt!
  traderate1: BigInt!
  asset: String! @index
  buyPrice: BigInt!
  sellPrice: BigInt!
  buyLiquidityRemaining: BigInt # new event only (per-side remaining swap-liquidity cap)
  sellLiquidityRemaining: BigInt # new event only
}

# Per arm x day x asset yield-source attribution (star schema dimensioned by asset). Partitions
# the day's redeemable-value change into non-overlapping sources, so consumers can rank assets by
# yield. One row per entry in Arm.assets: the liquidity asset [0] carries lendingYield; each base
# asset carries tradingYield + appreciationYield. yield = trading + appreciation + lending.
# All amounts in liquidity (token0) terms. This is an economic (par-valued) attribution: the sum
# over assets converges to on-chain cumulative yield over time, not tick-for-tick per day.
type ArmDailyAssetYield @entity {
  id: ID! # chainId:date:arm:asset
  chainId: Int! @index
  address: String! @index # arm address
  asset: String! @index # the asset this row attributes (base asset, or the liquidity asset)
  assetSymbol: String!
  date: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  # Σ ArmSwap.spread for this asset over the day (redeemable-value delta from trading). 0 for the
  # liquidity asset (it is not a traded base asset).
  tradingYield: BigInt!
  # Held base inventory drift between events: prevBalance x (rateNow - ratePrev) / 1e18. 0 for the
  # liquidity asset and for pegged base assets (rate is constant). Captures wstETH/weETH/sUSDe-style
  # adapter-rate appreciation. Does NOT capture rebasing balance growth (e.g. stETH).
  appreciationYield: BigInt!
  # ERC4626 lending-market growth: prevMarketShares x (ppsNow - ppsPrev) / 1e18. Only nonzero on the
  # liquidity-asset row. Zeroed across a market switch (activeMarket changed day-over-day).
  lendingYield: BigInt!
  # tradingYield + appreciationYield + lendingYield.
  yield: BigInt!
  # Liquidity (token0) terms volume traded for this asset over the day (context for per-asset APY).
  swapVolume: BigInt!
}
type ERC20 @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  name: String!
  decimals: Int!
  symbol: String!
}

type ERC20Holder @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  account: String! @index
  since: DateTime! @index
  balance: BigInt!
}

type ERC20State @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  totalSupply: BigInt!
  holderCount: Int!
}

type ERC20StateByDay @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  date: String! @index
  address: String! @index
  totalSupply: BigInt!
  holderCount: Int!
}

type ERC20Balance @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  account: String! @index
  balance: BigInt!
}

type ERC20Transfer @entity {
  id: ID!
  chainId: Int! @index
  txHash: String!
  blockNumber: Int!
  timestamp: DateTime!
  address: String! @index
  from: String! @index
  fromBalance: BigInt!
  to: String! @index
  toBalance: BigInt!
  value: BigInt!
}
type ProcessingStatus @entity {
  id: ID!
  timestamp: DateTime!
  blockNumber: Int!
  startTimestamp: DateTime! # when we started processing
  headTimestamp: DateTime # when we first hit head block
}
type AeroCLGaugeNotifyReward @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  from: String! @index
  amount: BigInt!
}

type AeroGaugeNotifyReward @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  from: String! @index
  amount: BigInt!
}

type AeroPoolCreated @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  pool: String!
  token0: String!
  token1: String!
  stable: Boolean!
}

type AeroCLPoolCreated @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  pool: String!
  token0: String!
  token1: String!
  tickSpacing: Int!
}

type AeroVoterGaugeCreated @entity {
  id: ID!
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  poolFactory: String! @index
  votingRewardsFactory: String! @index
  gaugeFactory: String! @index
  pool: String!
  bribeVotingReward: String!
  feeVotingReward: String!
  gauge: String!
  creator: String!
}
type AeroPoolState @entity {
  id: ID! # chainId:poolAddress:blockNumber
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  totalUsd: BigInt!
  liquidity: BigInt!
  stakedLiquidity: BigInt!
  asset0: BigInt!
  asset1: BigInt!
  voteWeight: BigInt!
  votePercentage: BigInt!
}

type AeroCLPoolState @entity {
  id: ID! # chainId-poolAddress-blockNumber
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  totalUsd: BigInt!
  liquidity: BigInt!
  stakedLiquidity: BigInt!
  asset0: BigInt!
  asset1: BigInt!
  voteWeight: BigInt!
  votePercentage: BigInt!
  tick: AeroCLPoolTick!
  tickPrice: Float!
  sqrtPriceX96: BigInt!
}

type AeroCLPoolTick @entity {
  id: ID! # chainId-poolAddress-tick-blockNumber
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  tick: Int! @index
  tickPrice: Float!
  sqrtPriceX96: BigInt!
  liquidityGross: BigInt!
  liquidityNet: BigInt!
  stakedLiquidityNet: BigInt!
  feeGrowthOutside0X128: BigInt!
  feeGrowthOutside1X128: BigInt!
  rewardGrowthOutsideX128: BigInt!
  tickCumulativeOutside: BigInt!
  secondsPerLiquidityOutsideX128: BigInt!
  secondsOutside: Int!
}

type AeroPoolEpochState @entity {
  id: ID! # chainId-poolAddress-epochTs-blockNumber
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  address: String! @index
  epoch: BigInt! @index
  votes: BigInt!
  emissions: BigInt!
  bribes: [TokenAmount!]
  fees: [TokenAmount!]
}

type TokenAmount {
  token: String!
  amount: BigInt!
}

type AeroLP @entity {
  id: ID! # chainId-pool-blockNumber-positionId
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  pool: String! @index
  account: String! @index
  liquidity: BigInt!
  staked: BigInt!
  amount0: BigInt!
  amount1: BigInt!
  staked0: BigInt!
  staked1: BigInt!
  unstakedEarned0: BigInt!
  unstakedEarned1: BigInt!
  emissionsEarned: BigInt!
  tickLower: Int!
  tickUpper: Int!
  sqrtRatioLower: BigInt!
  sqrtRatioUpper: BigInt!
}

type AeroLPPosition @entity {
  id: ID! # chainId-pool-blockNumber-positionId
  chainId: Int! @index
  blockNumber: Int! @index
  timestamp: DateTime! @index
  pool: String! @index
  positionId: BigInt! @index
  account: String! @index
  liquidity: BigInt!
  staked: BigInt!
  amount0: BigInt!
  amount1: BigInt!
  staked0: BigInt!
  staked1: BigInt!
  unstakedEarned0: BigInt!
  unstakedEarned1: BigInt!
  emissionsEarned: BigInt!
  tickLower: Int!
  tickUpper: Int!
  sqrtRatioLower: BigInt!
  sqrtRatioUpper: BigInt!
}
enum GovernanceProposalState {
  Pending
  Active
  Canceled
  Defeated
  Succeeded
  Queued
  Expired
  Executed
}

enum GovernanceProposalEventType {
  Created
  Queued
  Canceled
  Extended
  Executed
}

enum GovernanceVoteType {
  Against
  For
  Abstain
}

type GovernanceProposalEvent @entity {
  id: ID!
  txHash: String! @index
  event: GovernanceProposalEventType!
  timestamp: DateTime!
  proposal: GovernanceProposal! @index
}

type GovernanceProposal @entity {
  id: ID! @index
  chainId: Int! @index
  address: String! @index
  proposalId: BigInt!
  description: String
  proposer: String!
  timestamp: DateTime!
  txHash: String! @index
  startBlock: BigInt!
  endBlock: BigInt!
  targets: [String]!
  values: [String]!
  signatures: [String]!
  calldatas: [String]!
  lastUpdated: DateTime!
  status: GovernanceProposalState!
  events: [GovernanceProposalEvent]! @derivedFrom(field: "proposal")
  quorum: BigInt!
  choices: [String]!
  scores: [String]!
}

type GovernanceProposalVote @entity {
  id: ID!
  chainId: Int!
  address: String!
  proposal: GovernanceProposal! @index
  voter: String! @index
  weight: BigInt!
  type: GovernanceVoteType!
  txHash: String!
  timestamp: DateTime!
}type BridgeTransfer @entity {
  id: ID! # chain + log id
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHashIn: String!
  txHashOut: String # Initially null
  messageId: String! @index
  bridge: String! @index
  transactor: String! @index
  sender: String! @index
  receiver: String! @index
  chainIn: Int! @index
  chainOut: Int!
  tokenIn: String!
  tokenOut: String!
  amountIn: BigInt!
  amountOut: BigInt!
  state: Int!
}

type BridgeTransferState @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  state: Int!
}
type FRRSRewardCollected @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  amountCollected: BigInt!
}
type FRRSRewardsPerSecondChanged @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  newRPS: BigInt!
  oldRPS: BigInt!
}
type FRRSRewardsTargetChange @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  target: String!
  previousTarget: String!
}
type FRRSStrategistUpdated @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  strategistAddress: String!
}# State

type ESToken @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  circulating: BigInt!
  staked: BigInt!
  total: BigInt!
}

type ESAccount @entity {
  id: ID! # `chainId:address:account`
  chainId: Int! @index
  address: String! @index
  account: String! @index
  assetBalance: BigInt!
  stakedBalance: BigInt!
  balance: BigInt!
  votingPower: BigInt!
  delegateTo: ESAccount
  delegatesFrom: [ESAccount]! @derivedFrom(field: "delegateTo")
}

type ESYield @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  assetBalance: BigInt!
  rewardsPerSecond: BigInt!
  apr: Float!
  apy: Float!
}

# Per-holder realized staking yield, one row per staker per day.
# xOGN is a MasterChef-style accumulator: rewards (OGN) accrue as points * d(accRewardPerShare)/1e12.
# `balance` is the reward-share basis (xOGN points); `stakedBalance` is the OGN principal, which is
# the position value and the APY/roi denominator. yield/cumulativeYield are denominated in OGN.
type ESAddressYield @entity {
  id: ID! # chainId:address:account:date
  chainId: Int! @index
  address: String! @index # xOGN staking contract
  account: String! @index # staker
  date: String! @index
  timestamp: DateTime!
  blockNumber: Int! @index
  balance: BigInt! # xOGN points held (reward-share basis)
  stakedBalance: BigInt! # OGN principal staked (position value / denominator)
  yield: BigInt! # OGN rewards accrued on this date
  cumulativeYield: BigInt! # lifetime OGN rewards accrued (claimed + pending)
  roi: Float! # cumulativeYield / stakedBalance
  lastR: BigInt! # last checkpointed accRewardPerShare
  yieldRemainder: BigInt! # sub-unit accrual carry
}

type ESLockup @entity  {
  id: ID! # `chainId:address:account:lockupId` or `lockupId`
  chainId: Int! @index
  address: String! @index
  account: String! @index
  lockupId: BigInt! @index
  timestamp: DateTime!
  txHash: String! @index
  lastUpdated: DateTime!
  amount: BigInt!
  end: DateTime!
  points: BigInt!
  withdrawAmount: BigInt!
  penalty: BigInt!
  state: ESLockupState
  events: [ESLockupEvent]! @derivedFrom(field: "lockup")
}

enum ESLockupState {
  Open
  Closed
}

enum ESLockupEventType {
  Staked
  Unstaked
  Extended
}

type ESLockupEvent @entity {
  id: ID!
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  event: ESLockupEventType!
  lockup: ESLockup!
}

# Events
type ESDelegateChanged @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  delegator: String! @index
  fromDelegate: String!
  toDelegate: String!
}

type ESDelegateVotesChanged @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  delegate: String! @index
  previousBalance: BigInt!
  newBalance: BigInt!
}

type ESPenalty @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  account: String! @index
  amount: BigInt!
}

type ESReward @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  account: String! @index
  amount: BigInt!
}

type ESStake @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  account: String! @index
  lockupId: BigInt! @index
  amount: BigInt!
  end: BigInt!
  points: BigInt!
}

type ESUnstake @entity  {
  id: ID! # `chainId:logId`
  chainId: Int! @index
  address: String! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  txHash: String! @index
  account: String! @index
  lockupId: BigInt! @index
  amount: BigInt!
  end: BigInt!
  points: BigInt!
}
type StrategyBalance @entity @index(fields: ["strategy", "timestamp"]) {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  otoken: String! @index
  strategy: String! @index
  asset: String!
  symbol: String!
  balance: BigInt!
  balanceETH: BigInt!
}

type StrategyYield @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  otoken: String! @index
  strategy: String! @index
  asset: String!
  balance: BigInt!
  balanceWeight: Float!
  earnings: BigInt!
  earningsChange: BigInt!
}

type StrategyDailyYield @entity {
  id: ID!
  timestamp: DateTime! @index
  blockNumber: Int! @index
  otoken: String! @index
  strategy: String! @index
  asset: String!
  balance: BigInt!
  balanceWeight: Float!
  earnings: BigInt!
  earningsChange: BigInt!
  apr: Float!
  apy: Float!
}
type SFCWithdrawal @entity {
  id: ID!
  chainId: Int! @index
  createdAt: DateTime!
  createdAtBlock: Int!
  delegator: String! @index
  toValidatorID: String! @index
  wrID: String! @index
  amount: BigInt!
  penalty: BigInt
  withdrawnAt: DateTime
  withdrawnAtBlock: Int
}
type MorphoMarketState @entity {
  id: ID!
  chainId: Int!
  timestamp: DateTime!
  blockNumber: Int!
  marketId: String!
  totalSupplyAssets: BigInt!
  totalSupplyShares: BigInt!
  totalBorrowAssets: BigInt!
  totalBorrowShares: BigInt!
  lastUpdate: BigInt!
  fee: BigInt!
}
type EventWOETHPriceUpdated @entity {
  id: ID!
  chainId: Int! @index
  timestamp: DateTime! @index
  blockNumber: Int! @index
  address: String! @index
  oldValue: BigInt!
  newValue: BigInt!
}