> ## Documentation Index
> Fetch the complete documentation index at: https://docs.minaexplorer.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Transactions

A query dedicated to returning user commands, otherwise known as transactions (excludes coinbase and fee transfers). This data is the same as that obtained via the `block` query but separated out into its own query for ease of use.

## Get the last 25 transactions for a public key

Get all transactions to, or from, a public key. Only includes those on the canonical chain.

```json theme={null}
{
  transactions(limit: 25, sortBy: DATETIME_DESC, query: {
    canonical: true,
    OR: [{
      to: "B62qpge4uMq4Vv5Rvc8Gw9qSquUYd6xoW1pz7HQkMSHm6h1o7pvLPAN"
    }, {
      from: "B62qpge4uMq4Vv5Rvc8Gw9qSquUYd6xoW1pz7HQkMSHm6h1o7pvLPAN"
    }]
  }) {
    fee
    from
    to
    nonce
    amount
    memo
    hash
    kind
    dateTime
    block {
      blockHeight
      stateHash
    }
    failureReason
  }
}
```

## Return associated block data for a transaction

The `block` relationship may be used to extract information about the block the transaction was contained in.

```json theme={null}
{
  transactions(
    limit: 1
    sortBy: DATETIME_DESC
    query: {from: "B62qqHM1bihHNvju89PFYugLw73PYRb7pGwp82CpEmWfSYVJiQAppaC"}
  ) {
     from
     to
     nonce
     amount  
  	 hash
     block {
      protocolState {
        consensusState {
          blockHeight
        }
      }
    }
    failureReason
  }
}
```

## Get all transactions sent from a public key after a date

```json theme={null}
{
  transactions(
    limit: 10
    sortBy: NONCE_DESC
    query: {
      from: "B62qqHM1bihHNvju89PFYugLw73PYRb7pGwp82CpEmWfSYVJiQAppaC"
      dateTime_gte: "2021-01-26T00:00:00Z"
    }
  ) {
    from
    to
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}
```

## Find the largest fees sent in a period

This query demonstrates additional sorting options by sorting the transactions by largest fee.

```json theme={null}
{
  transactions(
    limit: 10
    sortBy: FEE_DESC
    query: { AND: [{dateTime_gte: "2021-01-26T00:00:00Z"}, {dateTime_lte: "2021-01-27T00:00:00Z"}] }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}
```

## Determine the largest transfers made in a period

This query finds the largest transfers made over a period.

```json theme={null}
{
  transactions(
    limit: 10
    sortBy: AMOUNT_DESC
    query: { AND: [{dateTime_gte: "2021-01-26T00:00:00Z"}, {dateTime_lte: "2021-01-27T00:00:00Z"}] }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}
```

## Find where the memo field is not empty

Memos are returned in base58 check encoding. The default memo is `E4YM2vTHhWEg66xpj52JErHUBU4pZ1yageL4TVDDpTTSsv8mK6YaH` so this query simply returns all results who memo is no that value so they can be decoded.

```json theme={null}
{
  transactions(
    limit: 10
    sortBy: AMOUNT_DESC
    query: {
      AND: [
        { dateTime_gte: "2021-01-26T00:00:00Z" }
        { dateTime_lte: "2021-01-27T00:00:00Z" }
        { memo_ne: "E4YM2vTHhWEg66xpj52JErHUBU4pZ1yageL4TVDDpTTSsv8mK6YaH" }
      ]
    }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    memo
    failureReason
  }
}
```

> Using the dateTime query filters you can greatly improve the performance of your queries by more specifically targeting your date range of returned results.