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

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.0.2rc0-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.2rc0-cp310-cp310-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.0.2rc0-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.2rc0-cp39-cp39-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.0.2rc0-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.2rc0-cp38-cp38-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.0.2rc0-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.2rc0-cp37-cp37m-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.0.2rc0-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.2rc0-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.2rc0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 d46c92e45533590d3f50e0c237105b7e4587b4250dddc88581193adbce4cc475
MD5 4fe9ac84f63809f7f0bc34d4697c0396
BLAKE2b-256 b1f8d150a485cffef0acb84f632a6f15d6b6d4d37c977829b4f508ca3f361c04

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 5875b7723ce20f206ff1d011e8def06b3bc3ae57f0fd51087c94a4c88afeeae6
MD5 2aa4096d635194f6f90bed11383633cb
BLAKE2b-256 e63611e57bf81913a31ac00f60196c2f3eea5ddf23d426d3a256b0bda391eeae

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 26cfe7eb178c23c1a7aed586232a37966045b52c1bbdbb738125519493558008
MD5 c8e82cca3dac86856c7f6cc4178b1fef
BLAKE2b-256 4df3322cb03874decb8729a27dc3133c9a49f1319c64e1cfeb45817536c620b7

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 71bab843290d1cd3dde98a76dc9698d7db0c83974841b2d3f96ae4a50861569c
MD5 6647823ac2c3ba5eb6874a94223b8c33
BLAKE2b-256 08d6aeca6860fff988c24fc8f551a5529b28f99aaf0f0df0147b9d62f1c19ad6

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 3d5a7bb21bc7f5c262c9a1bb4554ac562d3614f2266e59c03f17921fed14a65e
MD5 159a4474d73d4891aedcdcf60cb9dea4
BLAKE2b-256 7ec7b5fd7bde2b180115cfe02fccd33f65fd88b51bba7631cea441f7f718be74

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 6730b88afe56586687edd02ed83afd845461f7f2ffb6c4a0501e609b7afe3cbf
MD5 9b984723811c4e29ad9cc2396309deb1
BLAKE2b-256 e3c8f0290964b9540ef7d4d85d71de5aff8e94c13348129ee984ad58f0c5cacc

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 2fe49787bace3b2b16df019e4447caf3417339a1ead12b07adaba7ecf3a175ec
MD5 8981348b934469f26a1ab3ea0473dcb1
BLAKE2b-256 567b03abdfded72014b174e41f71f25085643b0d46a8fd7c22b6c11c981b582c

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 df4997a9f83b921d23f55ad88159adc6a07c3869a092fa7db01ea57b1fb1737b
MD5 fde41b050ab481298b589ec88f8f244b
BLAKE2b-256 831104649fc71deda0c869c9c44ca9fc33c8458f2564fb8f34d1382ae37fdfac

See more details on using hashes here.

File details

Details for the file arcticdb-4.0.2rc0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 cbbf8c3790bab636b0790675d08fc3c9e5932f0e36a324350134a9de9ae66e95
MD5 3c6f36e0419e235721e410d525325405
BLAKE2b-256 a4ff5a61adadb8325a811b6085ca72953f7b00feaefd15f106217eda86404e3d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 80988c67a74c060e8de8dd5e15e0987ea17812896e4eaa13bd68d0dc459e4b91
MD5 a85f026e5995b79e5138051b63a56be0
BLAKE2b-256 fbd15be4d6f08c388115ffbb03c1cbc952a11832415b72ceb807f1c5c41faf5f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.2rc0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 b7ee9442fbb52f2c9a7a5d830abd60ae17c1e05085afa9a448658436df69d968
MD5 00a3fc941c3a85307f038ba793fa54a9
BLAKE2b-256 e1a6e4ef550da1ee2b5417603710418d9aeebfc84801fcec7e551a55c305d103

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