Skip to main content

ArcticDB DataFrame Database

Project description



ArcticDB Website | ArcticDB Blog | Press Release | Press Release | Community


ArcticDB is a high performance, serverless DataFrame database built for the Python Data Science ecosystem. Launched in March 2023, it is the successor to Arctic.

ArcticDB offers an intuitive Python-centric API enabling you to read and write Pandas DataFrames to S3 or LMDB utilising a fast C++ data-processing and compression engine.

ArcticDB allows you to:

  • Pandas in, Pandas out: Read and write Pandas DataFrames, NumPy arrays and native types to S3 and LMDB without leaving Python.
  • Built for time-series data: Efficiently index and query time-series data across billions of rows
  • Time travel: Travel back in time to see previous versions of your data and create customizable snapshots of the database
  • Schemaless Database: Append, update and modify data without being constrained by the existing schema
  • Optimised for streaming data: Built in support for efficient sparse data storage
  • Powerful processing: Filter, aggregate and create new columns on-the-fly with a Pandas-like syntax
  • C++ efficiency: Accelerate analytics though concurrency in the C++ data-processing engine

ArcticDB handles data that is big in both row count and column count, so a 20-year history of more than 400,000 unique securities can be stored in a single symbol. Each symbol is maintained as a separate entity with no shared data which means ArcticDB can scale horizontally across symbols, maximising the performance potential of your compute, storage and network.

ArcticDB is designed from the outset to be resilient; there is no single point of failure, and persistent data structures in the storage mean that once a version of a symbol has been written, it can never be corrupted by subsequent updates. Pulling compressed data directly from storage to the client means that there is no server to overload, so your data is always available when you need it.

Quickstart

Prebuilt binary availability

PyPI (Python 3.6 - 3.11) conda-forge (Python 3.8 - 3.11)
Linux ✔️ ✔️
Windows Beta
MacOS (Apple Silicon) ✔️

Storage compatibility

PyPI conda-forge
S3 ✔️ ✔️
LMDB ✔️ ✔️
Azure Blob Storage ✔️ ✔️

Installation

Install ArcticDB:

$ pip install arcticdb

or using conda-forge

$ conda install -c conda-forge arcticdb

Import ArcticDB:

>>> from arcticdb import Arctic

Create an instance on your S3 storage (with or without explicit credentials):

# Leave AWS to derive credential information
>>> ac = Arctic('s3://MY_ENDPOINT:MY_BUCKET?aws_auth=true')

# Manually specify creds
>>> ac = Arctic('s3://MY_ENDPOINT:MY_BUCKET?region=YOUR_REGION&access=ABCD&secret=DCBA')

Or create an instance on your local disk:

>>> ac = Arctic("lmdb:///<path>")

Create your first library and list the libraries in the instance:

>>> ac.create_library('travel_data')
>>> ac.list_libraries()

Create a test dataframe:

>>> import numpy as np
>>> import pandas as pd
>>> NUM_COLUMNS=10
>>> NUM_ROWS=100_000
>>> df = pd.DataFrame(np.random.randint(0,100,size=(NUM_ROWS, NUM_COLUMNS)), columns=[f"COL_{i}" for i in range(NUM_COLUMNS)], index=pd.date_range('2000', periods=NUM_ROWS, freq='h'))

Get the library, write some data to it, and read it back:

>>> lib = ac['travel_data']
>>> lib.write("my_data", df)
>>> data = lib.read("my_data")

To find out more about working with data, visit our docs


Documentation

The source code for the ArcticDB docs are located in the docs folder, and are hosted at docs.arcticdb.io.

License

ArcticDB is released under a Business Source License 1.1 (BSL)

BSL features are free to use and the source code is available, but users may not use ArcticDB for production use or for a Database Service, without agreement with Man Group Operations Limited.

Use of ArcticDB in production or for a Database Service requires a paid for license from Man Group Operations Limited and is licensed under the ArcticDB Software License Agreement. For more information please contact arcticdb@man.com.

The BSL is not certified as an open-source license, but most of the Open Source Initiative (OSI) criteria are met. Please see version conversion dates in the below table:

ArcticDB Version License Converts to Apache 2.0
1.0 Business Source License 1.1 Mar 16, 2025
1.2 Business Source License 1.1 May 22, 2025
1.3 Business Source License 1.1 Jun 9, 2025
1.4 Business Source License 1.1 Jun 23, 2025
1.5 Business Source License 1.1 Jul 11, 2025
1.6 Business Source License 1.1 Jul 25, 2025
2.0 Business Source License 1.1 Aug 29, 2025
3.0 Business Source License 1.1 Sep 13, 2025

Code of Conduct

Code of Conduct

This project has adopted a Code of Conduct. If you have any concerns about the Code, or behaviour that you have experienced in the project, please contact us at arcticdb@man.com.

Contributing/Building From Source

We welcome your contributions to help us improve and extend this project!

Please refer to the Contributing page and feel free to open issues on GitHub.

We are also always looking for feedback from our dedicated community! If you have used ArcticDB please let us know, we would love to hear about your experience!

Our release process is documented here.

Community

We would love to hear how your ArcticDB journey evolves, email us at arcticdb@man.com or come chat to us on Twitter!

Interested in learning more about ArcticDB? Head over to our blog!

Do you have any questions or issues? Chat to us and other users through our dedicated Slack Workspace - sign up for Slack access on our website.

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

arcticdb-4.0.0-cp311-cp311-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.0.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.2 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-4.0.0-cp310-cp310-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.0.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.2 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

arcticdb-4.0.0-cp39-cp39-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.0.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.2 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

arcticdb-4.0.0-cp38-cp38-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.0.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.2 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

arcticdb-4.0.0-cp37-cp37m-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.0.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.17+ x86-64

arcticdb-4.0.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.6m manylinux: glibc 2.17+ x86-64

File details

Details for the file arcticdb-4.0.0-cp311-cp311-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.0-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 6.6 MB
  • Tags: CPython 3.11, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 2b58af69127437985d41a169580cb6ce72ba8084022fb2497d5770ffb70ba646
MD5 7446c12d11ed46fca586854adc6e85ab
BLAKE2b-256 a65ce4b0027b19cb7108ef15c429f68390b8a037e62f53c4d4ad2823f7ff3f38

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 545571b09df1b0913fa4e4f9d9683c1994b2d5a4b84bf9f6d499ac7bfedff2fd
MD5 83699d5f43efb3eb8e1d7015a5685b12
BLAKE2b-256 82b0274f5203a8428d583b19e28a9e1f9ef5a33bd441373d5c8687d6b8b0900e

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp310-cp310-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.0-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 6.6 MB
  • Tags: CPython 3.10, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 c5b79ba082f38260ff0b710a7cfecbe6e06611525a8ccdbc102f31dbaf7f0863
MD5 cd144c2c56dae5986a2b3ff5fe93aaa7
BLAKE2b-256 79a2eacec64358d522954fdbb1bf72e003eb8fb698618f62b532896060767b73

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 19ea87284d824610ed683bcaf2af2aac2356c3249f0888d91769f07b24f3656b
MD5 3a005d56c3dde002bc4a1b8d53642a31
BLAKE2b-256 3dfa788b6dc99d493d18e30ceaf441b2d384202b5bd9703b55570a179aa585f7

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.0-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 6.6 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 cb4de97c7ec6db8a92e678c06955cbf14a9d3c7b084ef352178d7142cb1ce8ce
MD5 4cea5cc2e9cb24187790164260029056
BLAKE2b-256 83623f2215d7ea4eb52bfa4c8477cc94f1d86a1893121483c8dc999b9292ad51

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 d6152631434ff44493c13d3ae094ceeb51763a5acafa4bc85561b303474c0011
MD5 63a8d2361b2510e0a9b9289f439dc681
BLAKE2b-256 0d62d39f79af7c6ac0b3e2fc66d2237b5c2bd42faf37afb57ad3eaa277050f47

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp38-cp38-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.0-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 6.6 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 e82c04e9e91f0380950c5c584c457e1509e5fb83cf2116467eb321ed204472c3
MD5 e66ce193489435b1f7af0fc24c7b55d3
BLAKE2b-256 143783d7de5f20f11dd2c09c12175e4fde43a1b365ef9a332ad9fe74023d2726

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 2705da9a0ce4a9cc63f604999c1d5352b6cbbf6802946f8e828b20bd82604497
MD5 380222de99d84600699a422f111c065f
BLAKE2b-256 5cff6ddb6428386628ec86dd5f2fc9b3a0c0ca6c69715765e84a73f92fbe16aa

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp37-cp37m-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.0-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 6.6 MB
  • Tags: CPython 3.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 4fa2ada0f0b69fd1ad75f2ac68998982b9698b32168b658b5fe743016635a83a
MD5 4cffc2076e494a45976ccfc22a933829
BLAKE2b-256 0791bbaadf62586a8dc323239a762cd1138d15c4f60ffe2084ff5134cbe3ba5d

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 e9b1d15c9eb945aa64fb9becb6ffbde840e23b60428acb8df0db6b24749ca83e
MD5 fc3394e0ace4a9e1132aeaced91ecba8
BLAKE2b-256 7c017c9fbc676be024c94fc96eb7e6d296a98757f02246ccb0c7c8a1d59fcf39

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 25faac06a7a217c3bbd5bc3e3ab18f0f22b0d1564fc99d9515497dd568d99128
MD5 29ed65f486222eec3d4231fa460586ef
BLAKE2b-256 c05ae1095062eacd35f54ab7048378e6c634b2e57b09d12af79b1952d4bab59d

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page