Oracle (oracle)

Price feeds and oracle answer events.

6 queryable tables. Every table supports the standard Hasura query arguments — where, order_by, limit, offset, distinct_on — plus an _aggregate field.

Access: Team and Premium (Playground on lower plans)

Tables

• answer_event
• feed
• price
• supra_pair
• supra_price_event
• watermark

answer_event

Column	Postgres type	GraphQL type
consensus_timestamp	bigint	bigint
log_index	integer	Int
feed_id	bigint	bigint
round_id	numeric	numeric
answer	numeric	numeric
answer_decimal	numeric	numeric
answer_updated_seconds	numeric	numeric
payer_account_id	bigint	bigint
transaction_hash	bytea	bytea
inserted_at	timestamptz	timestamptz

query GetAnswerEvent {
  oracle_answer_event(limit: 10) {
    consensus_timestamp
    log_index
    feed_id
    round_id
  }
}

feed

Column	Postgres type	GraphQL type
feed_id	bigint	bigint
feed_evm_address	text	String
description	text	String
decimals	smallint	smallint
is_tracked	boolean	Boolean
first_seen_timestamp	bigint	bigint
inserted_at	timestamptz	timestamptz

query GetFeed {
  oracle_feed(limit: 10) {
    feed_id
    feed_evm_address
    description
    decimals
  }
}

price

Column	Postgres type	GraphQL type
source	text	String
feed_key	text	String
name	text	String
price	numeric	numeric
decimals	smallint	smallint
price_decimal	numeric	numeric
round	numeric	numeric
observed_timestamp	bigint	bigint
updated_at	timestamptz	timestamptz

query GetPrice {
  oracle_price(limit: 10) {
    source
    feed_key
    name
    price
  }
}

supra_pair

Column	Postgres type	GraphQL type
slot	bytea	bytea
pair_index	bigint	bigint
pair_name	text	String
is_tracked	boolean	Boolean
inserted_at	timestamptz	timestamptz

query GetSupraPair {
  oracle_supra_pair(limit: 10) {
    slot
    pair_index
    pair_name
    is_tracked
  }
}

supra_price_event

Column	Postgres type	GraphQL type
consensus_timestamp	bigint	bigint
slot	bytea	bytea
pair_index	bigint	bigint
round_ms	numeric	numeric
decimals	smallint	smallint
timestamp_ms	numeric	numeric
price	numeric	numeric
price_decimal	numeric	numeric
payer_account_id	bigint	bigint
inserted_at	timestamptz	timestamptz

query GetSupraPriceEvent {
  oracle_supra_price_event(limit: 10) {
    consensus_timestamp
    slot
    pair_index
    round_ms
  }
}

watermark

Column	Postgres type	GraphQL type
job_name	text	String
last_processed_ns	bigint	bigint
updated_at	timestamptz	timestamptz

query GetWatermark {
  oracle_watermark(limit: 10) {
    job_name
    last_processed_ns
    updated_at
  }
}