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 (Intel/AMD) ✔️ ✔️
Windows (Intel/AMD) ✔️
MacOS Beta️

For conda-forge see the release-info.

Storage compatibility

Linux Windows Mac
S3 ✔️ ✔️ ✔️
LMDB ✔️ ✔️ ✔️
Azure Blob Storage ✔️ ✔️

We have tested against the following S3 backends:

  • AWS S3
  • Ceph
  • MinIO on Linux
  • Pure Storage S3
  • Scality S3
  • VAST Data S3

Installation

Install ArcticDB:

$ pip install arcticdb

or using conda-forge

$ conda install -c conda-forge arcticdb

Import ArcticDB:

>>> import arcticdb as adb

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

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

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

Or create an instance on your local disk:

>>> ac = adb.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
4.0 Business Source License 1.1 Sep 27, 2025
4.1 Business Source License 1.1 Nov 1, 2025
4.2 Business Source License 1.1 Nov 12, 2025
4.3 Business Source License 1.1 Feb 7, 2026

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

This version

4.4.2

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.4.2-cp311-cp311-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.4.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.2-cp310-cp310-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.4.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.2-cp39-cp39-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.4.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.2-cp38-cp38-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.4.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.2-cp37-cp37m-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.4.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.5 MB view details)

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

arcticdb-4.4.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.5 MB view details)

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

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 0aa97e5069f7bb338f265bd692ef55928c413c39be059e333063d5219f71c9d1
MD5 257583ba1c77cd547a3af7835f391494
BLAKE2b-256 5bf56d02e8838acef528055142761f6659c25ed56ec85ae4a4ab85360dcd6af6

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 8e35fbff62f1388466b66f316db8ba6a4d83c8423d23cb232a1691aaf101afca
MD5 4af9b47612bb37f8923c23379084e37b
BLAKE2b-256 70b40591235c8c1e2c9ba7125a0c72be687c767678a54edd032a3c30b64c784a

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 97cbd4a2be0bfdc69d5687ab2352cc1ccabdf1d92268895860d6efd02133fa6d
MD5 d46655002aefade87023d666bc42e622
BLAKE2b-256 da25fa7dfc4e14c756818c7285931169ea0dce37f9cf11a4a46d6c6670ee363c

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 8a0cd12b564295eb6c1baaec63365cd3df9dddb7048dfc4ff40557571221896e
MD5 78905771a84144ed98d440ec8cfa76b4
BLAKE2b-256 10f779bbc4b9bc437ea1839599a90ff5257415abec275d69bfd33edaf913b180

See more details on using hashes here.

Provenance

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.4.2-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 409b9e803baf116b7830890459dca1b44b24f9f274ba13f6af997b0f96df6902
MD5 1f78f4f6c3b414d68889eef6691270b9
BLAKE2b-256 c29bd1b9410e4afc52959ee21daa2235c394392aacc835f92ee4dd24087da369

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 3805f74a0d9d2834bb9776e5f6692b0c4f5e5ad4232138a16951265e045062c5
MD5 5df0e3827fae8c5b82c1f743d070e508
BLAKE2b-256 24b4b6125925624f051a8c257129cf9e2446747a3833634e33608d6574df4a3d

See more details on using hashes here.

Provenance

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.4.2-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 69f21cac6466fb34d2407affbeff0a71698c30dd0ec3150b3cd7d5e0023b54f0
MD5 435e80eb18f60c73b0ad91ab0b66f86d
BLAKE2b-256 77e6fca06d767c36dc9d664d347a2c7a26610d4935e16f697b1ae81647fca65b

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 4f9a3228cc7a6c308ccc82261e4e7d6393421bf08785fd5900e707c6fc05b78e
MD5 d07beae8be50ee7f3dcd2ac1c7168da8
BLAKE2b-256 1ab05c7ac1d58c80cbba9992ffa2f161af761f9f540dc83a8d88432a69a24f26

See more details on using hashes here.

Provenance

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.4.2-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 d61f974e7505b61e30b05811467ab04bdadd9a0f79d2c249269c71c373c1bd4a
MD5 bfd3dd52d5361c2c9ff5fff6118694a6
BLAKE2b-256 de1b19a092712053ab24d338a6531dbf7f1726c1bc7203c99759a2c3d5242d13

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 ee63c7ac4b548ae971b8186f90bd04b378a56451b15fdaa5e399bf743348b47c
MD5 ba184cae5357b03ff9fa23cdb005598e
BLAKE2b-256 e51f7495cb942ce8a7d72ef7dd87875aeecd757ee6633c7e78b6968379f7c338

See more details on using hashes here.

Provenance

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 d6111bae1e5a2b64ca74ad00440b6dd7ca7894ccf0c835643b275ff582bcee35
MD5 3dfa403fcad6421b0f6d86895d280501
BLAKE2b-256 d4eea934427c70c08c9d7c969eb452d2cb2d2265433e8bb2c4593d3035352031

See more details on using hashes here.

Provenance

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