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 ✔️
MacOS Beta️

Storage compatibility

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

We have tested against the following S3 backends:

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

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
4.0 Business Source License 1.1 Sep 27, 2025
4.1 Business Source Licesne 1.1 Nov 1, 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.2.0-cp311-cp311-win_amd64.whl (6.8 MB view details)

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.2.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.6 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-4.2.0-cp310-cp310-win_amd64.whl (6.8 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.6 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

arcticdb-4.2.0-cp39-cp39-win_amd64.whl (6.8 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.2.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.6 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

arcticdb-4.2.0-cp38-cp38-win_amd64.whl (6.8 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.2.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.6 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

arcticdb-4.2.0-cp37-cp37m-win_amd64.whl (6.8 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.2.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.7 MB view details)

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

arcticdb-4.2.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.7 MB view details)

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

File details

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

File metadata

  • Download URL: arcticdb-4.2.0-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 6.8 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.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 acd5c2e9d29826639fd3607ca5243f5ad6ea039c7f8daf2a80ff21e1d7437e70
MD5 001ef56f0861656f0994be73c10e2112
BLAKE2b-256 5ce9309661345bd51a017a9c43f98ea94d9477704fae4d6c65af9f0c1ca10c02

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 59dc743d0e30703e7eafd6fa4f6bbeb97e94ec1323983c7401f9ffcbac2c0917
MD5 57eb7b10dd7230dedd3e39acb418169d
BLAKE2b-256 1d9c57e5678e391170ccf8348f584f7b9d1c881a8468881c5fc35788dccac0e0

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.2.0-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 6.8 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.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 e99b288df9d63d39cdbf311d1035c2f4060dfd52c45f04fc193b2ce500136874
MD5 774b2c3248fa0b52aa59591dcdb412e2
BLAKE2b-256 73518ff0d11b5983a0a715dc0efcd9211743010d60452eae747daaba1fdb2cf4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 96b3eec887c3156f146571ffd0ad45564b07d9fa1b863486e015f06e96f6c4cd
MD5 7af4f9099d75f1882f5c11ed9376ca5a
BLAKE2b-256 62fd94673cb71b81955c059e0f8868aca54b07fad5fe1750b3607b4bf25411d8

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.2.0-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 6.8 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.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 05b4afae707face5559fff75612ea77345f3a3fde31685c9987f2ea54b49468c
MD5 fafa9ba673b2a32ca189b955e4c4dd4d
BLAKE2b-256 42c833170ddbf4ac4bb504922bea9f5495be86dead234139120078bbb8ffd9ff

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 584fe1b2b8e04c790b6b81ea0dae513abe1ec593189a83f5c66ce06d69538658
MD5 b9c8ec5f083c4f936ed99d802ffbbf3e
BLAKE2b-256 43756221a2ddb0db68280b9126cc020dc34fc4ac1b2f12f5c3211e222f7840be

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.2.0-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 6.8 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.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 ed99b9ae8bf83b22ea23bfcda68ddd5089f0adb86d2c0e75135b14f5c713bc04
MD5 2d8358b0333862c919f025a59a4de137
BLAKE2b-256 4f04f5c68eba78c2ef74b87519b68d9af939ae46cf55c7c8716730f4e7ed2530

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 c7e49484af50f46ea7ad48afd3b2c5749b956a0653a0c3f5e20cdd21a04d1798
MD5 8cb32d950571fc8dcebdf4619bb98d90
BLAKE2b-256 800e6e5d9e75f8b9216a85885b4ffaae268fe5848a6d702cca9a9e665bd38bf9

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.2.0-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 6.8 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.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 684e2685bf125c13740a192f4a31c98dd175850d4d9ef8c29319bd07fc402905
MD5 542b078f9c3e8928d390d9608c44b6e5
BLAKE2b-256 e39e68db885d82947bcdbe5fe6477725a53a02e83f637e304c023219650afbdd

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 0c3f3e1e90b478df98c4bd6737cd64a9a336213fb9011f1d94a38690a3c6022e
MD5 f5726ec3290b83e207bd56e00fe173dc
BLAKE2b-256 aaafcf4c66d13d9c8ef567d7730a2b8ad336d4b480f7aa9d1d68075b7ba9e435

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.2.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 abca65d25f1a79780e5b001e7097815300bfe3139fa318833cbec589406c4580
MD5 cfc61f925f55a0b871e59b1459218aaf
BLAKE2b-256 125a162c9abcc10b14af3906036b567bc1dcb3218b6d9ea196e0d23b80d7cdcc

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