---
title: "Api Whale Flips"
method: GET
path: "/api/v2/whale-flips"
---

# Api Whale Flips

`GET /api/v2/whale-flips`

## Request

- Base URL: `https://orcalayer.com` (the document declares no server; this is the origin it was published from)
- URL: `https://orcalayer.com/api/v2/whale-flips`
- Auth: none declared

List recent whale flips (sign reversal, $200K+ swing, smart non-farmer whales).

Served from the precomputed whale_flips_cache (rebuilt hourly via
build_whale_flips_cache.sql); NEVER computed live — the live aggregate scans
~38M rows of wallet_market_position and took ~125s, exceeding the 60s gateway
timeout (the 504 that churned a paying dev). comparison_date is the actual
snapshot used; when CURRENT_DATE - days has no snapshot it is clamped backward
to the nearest available date strictly before today.

## Query parameters

- `days` integer
- `limit` integer

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

---

[API](https://skmtc.dev/orcalayer/apis/orcalayer-api.md) · [All operations](https://skmtc.dev/orcalayer/apis/orcalayer-api/llms.txt) · [OpenAPI document](https://skmtc.dev/orcalayer/apis/orcalayer-api/revisions/5d1d509daba6?raw)