---
title: "Get value by table and function"
method: GET
path: "/stats/summary/{table}/{function}"
tags: ["stats"]
---

# Get value by table and function

`GET /stats/summary/{table}/{function}`

Returns string value by passed table and function.

### Availiable tables
* `block`
* `block_stats`
* `tx`
* `message`
* `event`


### Availiable functions
* `sum`
* `min`
* `max`
* `avg`
* `count`


`Column` query parameter is required for functions `sum`, `min`, `max` and `avg` and should not pass for `count`.


###  Availiable columns and functions for tables:

#### Block
* `height`         -- min max
* `time`           -- min max

#### Block stats
* `height`         -- min max
* `time`           -- min max
* `tx_count`       -- min max sum avg
* `events_count`   -- min max sum avg
* `blobs_size`     -- min max sum avg
* `block_time`     -- min max sum avg
* `supply_chnge`   -- min max sum avg
* `inflation_rate` -- min max avg
* `fee`            -- min max sum avg
* `gas_used`       -- min max sum avg
* `gas_limit`      -- min max sum avg

#### Tx
* `height`         -- min max
* `time`           -- min max
* `gas_wanted`     -- min max sum avg
* `gas_used`       -- min max sum avg
* `timeout_height` -- min max avg
* `events_count`   -- min max sum avg
* `messages_count` -- min max sum avg
* `fee`            -- min max sum avg

#### Event
* `height`         -- min max
* `time`           -- min max

#### Message
* `height`         -- min max
* `time`           -- min max

## Path parameters

- `table` 'block' | 'block_stats' | 'tx' | 'event' | 'message' | 'validator', required
- `function` 'min' | 'max' | 'avg' | 'sum' | 'count', required

## Query parameters

- `column` string
- `from` integer
- `to` integer

## Response `200`

OK

- string

## Other responses

- `400` — Bad Request
- `500` — Internal Server Error

---

[API](https://skmtc.dev/celenium-io/apis/celenium-api.md) · [All operations](https://skmtc.dev/celenium-io/apis/celenium-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/celenium-io/celenium-api/revisions/117307f84924/schema)