# Indexer Queries

After completing the steps in the Envio Indexer Setup Guide, you can access the Hasura console by navigating to <http://localhost:8080>.

The Hasura UI provides an intuitive way to test queries to the indexer. Below are examples of common queries:

### **Query 1: Get All Open Orders With BTC Amount Greater Than 0.00002 BTC**

This query retrieves all open orders where the amount of BTC exceeds 0.00002 (equivalent to 2000 satoshis):

```graphql
query GetOrderQuery {
  Order(where: {id: {}, amount: {_gt: "2000"}}) {
    price
    timestamp
    user
    market
    id
    asset
    amount
    status
    order_type
  }
}

```

### **Query 2: Get All Users Who Have Opened an Order**

This query retrieves all users who have opened at least one order:

```graphql
query GetAllUsersQuery {
  DepositEvent(distinct_on: user) {
    user
  }
  OpenOrderEvent(distinct_on: user) {
    id
  }
}
```

### Query 3: Get All Open Markets

This query returns all open markets:

```graphql
query GetOpenMarkets {
  MarketRegisterEvent(distinct_on: id) {
    base_asset
    quote_asset
    timestamp
    id
  }
}
```