# SEC Fails-to-Deliver Data (`bb-tradetec/sec-market-structure-data-normalizer`) Actor

Normalize official SEC fails-to-deliver files into bounded security, settlement-date, quantity, and price observations.

- **URL**: https://apify.com/bb-tradetec/sec-market-structure-data-normalizer.md
- **Developed by:** [BB](https://apify.com/bb-tradetec) (community)
- **Categories:** Developer tools, Automation
- **Stats:** 1 total users, 0 monthly users, 0.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

Pay per usage

This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage, which gets cheaper the higher subscription plan you have.

Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-usage

## What's an Apify Actor?

Actors are web data automations that power AI and operations. They run on the Apify platform to scrape websites, process data, connect APIs, and automate workflows.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).

# README

## SEC Fails-to-Deliver Data

Normalize official SEC fails-to-deliver files into bounded
`secMarketStructureObservation` Dataset items with CUSIP, settlement date,
quantity, price, source period, and direct provenance.

### What this Actor gives you

- deterministic FTD observation IDs
- exact SEC-published security identifiers and values
- explicit settlement-date and methodology semantics
- source-period, retrieval, coverage, and warning metadata
- structured `SUMMARY` and bounded `ERRORS` records

Release 0.1's production-confirmed source is
`sec-market-structure-ftd`. Other market-structure source IDs remain in the
versioned contract but are not advertised as production-confirmed in this
release.

### Example input

```json
{
  "queries": [
    {
      "requestId": "ftd-example",
      "sourceId": "sec-market-structure-ftd",
      "securityIdentifier": "037833100",
      "periodFrom": "2026-06-15",
      "periodTo": "2026-06-30",
      "metricTypes": ["ftdQuantity"]
    }
  ],
  "maxResults": 1,
  "maxSourceRequests": 2,
  "maxDownloadBytes": 5242880
}
```

### Output

```json
{
  "schemaVersion": "1.0",
  "recordType": "secMarketStructureObservation",
  "recordId": "sec-market-structure:...",
  "requestIds": ["ftd-example"],
  "coverageStatus": "complete",
  "source": [],
  "warnings": [],
  "data": {
    "metricType": "ftdQuantity",
    "securityIdentifiers": [{"kind": "cusip", "value": "037833100"}],
    "period": {},
    "value": "120",
    "unit": "shares",
    "methodologyVersion": "ftd-v1"
  }
}
```

Successful observations go to the default Dataset. `SUMMARY` and `ERRORS` are
separate default Key-Value Store records.

### SEC Complete Data Suite

This Actor is the FTD/market-structure normalization layer above
`sec-official-dataset-rows` and an input to
`sec-market-integrity-aggregator` and `sec-fund-diligence-aggregator`. It does
not invoke another Actor.

### Limits, runtime, and cost

Runs are bounded to 20 queries, 50,000 observations, 500 SEC requests, and
104,857,600 downloaded bytes. Runtime and the price shown by Apify depend on
the selected source period, archive size, filters, and emitted observations.
Start with one CUSIP and one short period.

### Trust and limitations

- FTD values are aggregate settlement fails, not short-interest data.
- No causal inference, ticker enrichment, live prices, or trading signal.
- Public SEC sources only; no proxy, browser, LLM, or user secret.
- This independent community Actor is not affiliated with or endorsed by the
  U.S. Securities and Exchange Commission.
- Output is public-source processing, not trading or investment advice.

For support, use the Actor's Issues tab and include the run ID and bounded
input. Never post tokens or private data.

# Actor input Schema

## `queries` (type: `array`):

One to twenty exact, source-allowlisted SEC dataset requests.

## `maxResults` (type: `integer`):

Run-wide cap on emitted observations.

## `maxSourceRequests` (type: `integer`):

Run-wide cap on SEC source requests.

## `maxDownloadBytes` (type: `integer`):

Run-wide cap on downloaded SEC response bytes.

## `outputSchemaVersion` (type: `string`):

Public Dataset schema version.

## `outputMode` (type: `string`):

Full evidence-rich records or compact records.

## `cursor` (type: `string`):

Opaque stateless continuation cursor from a previous compatible run.

## Actor input object example

```json
{
  "maxResults": 100,
  "maxSourceRequests": 100,
  "maxDownloadBytes": 26214400,
  "outputSchemaVersion": "1.0",
  "outputMode": "full"
}
```

# Actor output Schema

## `observations` (type: `string`):

Default Dataset containing secMarketStructureObservation records only.

## `summary` (type: `string`):

No description

## `errors` (type: `string`):

No description

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {};

// Run the Actor and wait for it to finish
const run = await client.actor("bb-tradetec/sec-market-structure-data-normalizer").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {}

# Run the Actor and wait for it to finish
run = client.actor("bb-tradetec/sec-market-structure-data-normalizer").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{}' |
apify call bb-tradetec/sec-market-structure-data-normalizer --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=bb-tradetec/sec-market-structure-data-normalizer",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/acts/8HKoFwayGOMWTNAxP/builds/L5p80eAcHhHoOWbgJ/openapi.json