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

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.0.3-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.3-cp310-cp310-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.0.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

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

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.0.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

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

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.0.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

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

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.0.3-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.3-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.3-cp311-cp311-win_amd64.whl.

File metadata

  • Download URL: arcticdb-4.0.3-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.3-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 426c8314c1aedab2c1849f7f85fc2977719d481a4d0c6a48a4cb1dc292cd05c1
MD5 ea75d38e3364376cc839cbcadb7cf260
BLAKE2b-256 ff343c978f969f465c505f5482c0ba2c5e90527379e1ddaa0bed2cb5025a664d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 835bf13f7176f7c8d001ccb70a9f02294ec81aa048f8af80332bec473d1512fe
MD5 22fb8238bd556972fabb8d0248a47f1f
BLAKE2b-256 9a56e4b094225ecd70244bfcd4b9d81b1b72b47f37fe79aad131278ae7c1bcdc

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.0.3-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.3-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 7c383cc935d39cb4277b78a550243ccbb4d91cae7d2229f4b7a323562250e774
MD5 5b4cd50c2447dfd12dcfd5865700397c
BLAKE2b-256 231ea99c9af3a2e51d75b981ca6ea7bc2198059d4c7d90db8dc78fa47d00b4b1

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 e53f7b4e5c25af8deb5b42e8e1bf6e877a657e9f6604da9c39ef7319380c1722
MD5 916a1799eac82544cfed693150d38187
BLAKE2b-256 50b98825907fd493a07d8f6240b343b0b72c9c272d37c46791c89e48860d7214

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.0.3-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.3-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 a9cf8f6604b39ffee22de2f5291f340333e99497c5dae396ea4fe0a3c6940383
MD5 e01c80452a75c6fcbc213c9b4a124ab5
BLAKE2b-256 b5cf94436281bf6603ae8e88c78755d3f798267f7ab765697adac979a0f7d0ad

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 91f24fd178fbd741042a197497b7633166f59b8c7c17223f0c84c8d91a009d3e
MD5 1f990a7bd13097f56d5549235af13412
BLAKE2b-256 a68eded1631f0786749857f626b729aa8fc1475825aa7e3ca61f834a5a939901

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.0.3-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.3-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 3681a6e71694d9020a0dba77794bc01519ef141ffdcf65d4a04647697f367140
MD5 2f66e54e8d258d4eaee6e607c3ea43c9
BLAKE2b-256 b5835563b3d57b7fc33d8ab4afb3c7d4bc4784882e18aecfdfcae47066a8c4a4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 d60efddbeba17e0ef29d9d81e6cfdcb7f689be311369b0195139ee86ba6ecc33
MD5 f56dfc04964f79f8968bdf480c3c86aa
BLAKE2b-256 d3f70329b86801a7279b050df620dda1d2abe5b03a02e0e62d00c6222c545364

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.0.3-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.3-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 3f697d48f871fecc15ffee66747c2a345c481289551aeb49441b04266b360e0c
MD5 2fa07dccf2f03d3de8f6c18b9af6b39b
BLAKE2b-256 f13dec143671849ec06d067d291e4c77a1b8166fb4f7aa39a2cc1109dd059545

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 186bed288ead4b20ed6656a60b4fbe48191d6d1ddbc29b7ccb07962b66bc8bb4
MD5 12e4df787a71180601e47cb79e79ddfb
BLAKE2b-256 54041b1199b92d7a6d3c8d39832bec5311df560d5dd8d8c469096ed9509128bd

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.3-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 974a6343b7884ac96bda195cfdaf3e8f8afb4fe7ce0e665cc2722d64b7ab1615
MD5 727b18f369b935ab564fdbb434235727
BLAKE2b-256 6a9102d056fb7829e5dd99591830278528e47417a5d696de5b38f2e1b0cbcc6b

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