Ticks

Name: Ticks
Author: alsk1992

ASecurity

Query historical tick, OHLC, and orderbook data from TimescaleDB.

2,496 stars
0 votes
0 copies
1 view
Added February 10, 2026

databasesdatabase

Security analysis

A100/100

Pro scans all 2 files and shows the line behind each finding

Scanned February 12, 2026

npx -y skills add alsk1992/CloddsBot --skill ticks --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Ticks?

Add the live security badge to your README. It updates with every re-scan.

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/alsk1992-ticks/badge)](https://www.skillsdirectory.com/skills/alsk1992-ticks)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

# Tick Data Skill

Query historical tick, OHLC, and orderbook data from TimescaleDB.

## Commands

| Command | Description |
|---------|-------------|
| `/ticks <platform> <marketId>` | Get recent ticks (last 24h) |
| `/ticks ohlc <platform> <marketId> --outcome <id>` | Get OHLC candles |
| `/ticks spread <platform> <marketId>` | Get spread history |
| `/ticks stats` | Get tick recorder stats |

## Options

| Option | Description |
|--------|-------------|
| `--outcome <id>` | Filter by outcome ID |
| `--interval <int>` | OHLC interval: `1m`, `5m`, `15m`, `1h`, `4h`, `1d` |
| `--limit <n>` | Limit number of results |

## Examples

```
/ticks polymarket 0x1234abcd
/ticks ohlc polymarket 0x1234 --outcome 0x5678 --interval 1h
/ticks spread polymarket 0x1234 --limit 50
/ticks stats
```

## Requirements

- TimescaleDB tick recorder must be enabled
- Configure in `clodds.config.yaml`:

```yaml
tickRecorder:
  enabled: true
  connectionString: postgres://user:pass@localhost:5432/clodds
```

## Output

### Ticks
Shows price history with timestamps and price changes.

### OHLC
Shows candlestick data with open, high, low, close, and tick count.
Includes period change summary.

### Spread
Shows orderbook spread history with mid price and depth.
Includes spread statistics (avg, min, max).

### Stats
Shows recorder status including:
- Database connection status
- Total ticks/orderbooks recorded
- Buffer pending counts
- Last flush time
- Active platforms