> For the complete documentation index, see [llms.txt](https://docs.hydromancer.xyz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hydromancer.xyz/reservoir/felix.md).

# Felix

Indices, equities, and commodities perpetual markets. USDH-margined.

**Launch date:** November 2025\
**Data available from:** 2025-11-13 (complete history since launch)\
**Collateral token:** USDH\
**Dex identifier:** `flx`\
**Example markets:** `flx:NVDA`, `flx:TSLA`, `flx:AMZN`

## Datasets

**Bucket:** `s3://hydromancer-reservoir` (requester pays)

| Dataset                        | Path                                                                |
| ------------------------------ | ------------------------------------------------------------------- |
| **All fills**                  | `by_dex/flx/fills/perp/all/date=YYYY-MM-DD/fills.parquet`           |
| **Liquidations**               | `by_dex/flx/fills/perp/liquidations/date=YYYY-MM-DD/fills.parquet`  |
| **ADL**                        | `by_dex/flx/fills/perp/adl/date=YYYY-MM-DD/fills.parquet`           |
| **Builder fills**              | `by_dex/flx/fills/perp/builder_fills/date=YYYY-MM-DD/fills.parquet` |
| **TWAP fills**                 | `by_dex/flx/fills/perp/twap_fills/date=YYYY-MM-DD/fills.parquet`    |
| **Candles**                    | `by_dex/flx/candles/1s/date=YYYY-MM-DD/candles.parquet`             |
| **Perp positioning snapshots** | `by_dex/flx/snapshots/perp/date=YYYY-MM-DD/*.parquet`               |

Sub-dataset files are only created for dates with data. If a file is missing, there were no events of that type on that date.

## Quick Start

```sql
INSTALL httpfs;
LOAD httpfs;
SET s3_region = 'ap-northeast-1';

-- All Felix fills for a day
SELECT timestamp, coin, base_symbol, side, price, size, direction
FROM read_parquet('s3://hydromancer-reservoir/by_dex/flx/fills/perp/all/date=2026-03-22/fills.parquet')
ORDER BY timestamp;

-- Volume by market
SELECT base_symbol, sum(price * size) as volume_usd, count(*) as trades
FROM read_parquet('s3://hydromancer-reservoir/by_dex/flx/fills/perp/all/date=2026-03-22/fills.parquet')
GROUP BY base_symbol ORDER BY volume_usd DESC;
```

For schema details see: [Fills](/reservoir/schema-reference/fills.md) · [Candles](/reservoir/schema-reference/candles.md) · [Snapshots](/reservoir/schema-reference/snapshots.md)