---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: quackfix
excerpt: |
  DuckDB Community Extensions
  Allows the consumption FIX protocol format logs, from all supported duckdb filesystems.

extension:
  name: quackfix
  description: Allows the consumption FIX protocol format logs, from all supported duckdb filesystems.
  version: 0.0.3
  language: c++
  build: cmake
  license: MIT
  maintainers:
    - hyehudai

repo:
  github: hyehudai/quackfix
  ref: faadfea6a8f4760c967f44902974cceabaa1bf8e

docs:
  hello_world: |
    -- Basic FIX parsing - from http location
    D SELECT OrderID, ExecID, LastQty FROM read_fix('https://raw.githubusercontent.com/hyehudai/QuackFIX/refs/heads/main/testdata/sample.fix') WHERE MsgType = '8' ORDER BY OrderID;
       ─────────┬──────────┬─────────┐
      │ OrderID │  ExecID  │ LastQty │
      │ varchar │ varchar  │ double  │
      ├─────────┼──────────┼─────────┤
      │ EXEC001 │ TRADE001 │   100.0 │
      │ EXEC002 │ TRADE002 │    50.0 │
      │ EXEC003 │ TRADE003 │   200.0 │
      └─────────┴──────────┴─────────┘

  extended_description: |
    
      QuackFIX is a DuckDB extension that lets you query FIX logs directly with SQL. It parses raw FIX messages into a structured, queryable format, making FIX log analysis faster and more intuitive for trading, compliance, and financial operations.

      
      **Native DuckDB Integration** 
      Query FIX logs directly in DuckDB—no pre-parsing, no pandas round-trips.
      No Glue code!

      **Dialect-Aware** 
      Supports custom FIX dialects via XML dictionaries, so venue-specific tags just work.

      **Fast and Scalable** 
      Built on DuckDB’s in-memory, columnar engine to efficiently handle large log volumes.
      
      **Support multiple FIX dialects**

      > For examples and instructions check out [User Guide](https://github.com/hyehudai/QuackFIX/blob/main/USERGUIDE.md) 
      

      


extension_star_count: 17
extension_star_count_pretty: 17
extension_download_count: 593
extension_download_count_pretty: 593
image: '/images/community_extensions/social_preview/preview_community_extension_quackfix.png'
layout: community_extension_doc
---

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|   function_name    | function_type | description | comment | examples |
|--------------------|---------------|-------------|---------|----------|
| fix_fields         | table         | NULL        | NULL    |          |
| fix_groups         | table         | NULL        | NULL    |          |
| fix_message_fields | table         | NULL        | NULL    |          |
| read_fix           | table         | NULL        | NULL    |          |