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

This version

4.0.5

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

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.0.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.3 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-4.0.5-cp310-cp310-win_amd64.whl (6.7 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.0.5-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.5-cp39-cp39-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.0.5-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.5-cp38-cp38-win_amd64.whl (6.7 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.0.5-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.5-cp37-cp37m-win_amd64.whl (6.7 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.0.5-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

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

arcticdb-4.0.5-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

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

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 db9cc24312edd5af80761100505f264bd16bec04815fb02a296da56245601218
MD5 6a84d92b2df12047fe909a6ad241958a
BLAKE2b-256 9ee7dd737ea9786c41422c278c5599743317be4eba591367a1778e0cf8748d10

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 cdcd27bc36e5fd3a9c9334aed812ff8b7deeac57ae1a839fd2f7c68d45957872
MD5 62c092d412bebf1d4d9a9478e7900564
BLAKE2b-256 8f65c402aee14a3d131440f6470f8c5867027ff04e3415fb83ebaba739937973

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 acd55037bee1364d8e4df6364ebf49deb9ad399e848d37542aebc160214afc4a
MD5 7bb171b0bc400fe13e095698bd997d13
BLAKE2b-256 ac284ba42087ae45ba309007a15990e89a9eaba5f8243164f06584769aa92251

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 254250c2a550a374cc7fe8aae7b44bc07228f521414fb620215985045681c94a
MD5 042d647a540d2d5502b994b496c101f2
BLAKE2b-256 19edd37b0e57c4a337cfa10a958194d24e9ba2f77a477867486e8dcd6942193a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.0.5-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/5.1.0 CPython/3.10.12

File hashes

Hashes for arcticdb-4.0.5-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 7ec610bd79ecd04b6c8a14003a85f6b799ddb36a630bc36cb466957a41283c64
MD5 0cdd060fc9a95f9370310ba447827e67
BLAKE2b-256 200716114282e175f029ab2c03ed6de59264b64408a7fb0d354f29ca04dfcccf

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 575d3aab0b46676117d745b692d30255ad5985429559b41aaf705c683b7a0fae
MD5 85553418d317b85afa41e74ed3b41ddb
BLAKE2b-256 cac2b3f615d0a676acbab9c4750fee65dd23d2f53f0909c6d7da35c669413704

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.0.5-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 1a308383bc3920af661dcd092d98a784b4b71435b8ce12640166c9405e080e0f
MD5 50d8065f4e6ef0212aa5de287f871ae6
BLAKE2b-256 6b45ff3f664048f3fc1ab6955de56855449986f50ffe08492157ebc61a8322f8

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 464d832fd78cdb6c91408565d99f407948b5baf9c3d307d2d992e260776d06cd
MD5 7a219af26f1e6d22f55618f9e4e4463c
BLAKE2b-256 1f43ae433ffdeaf623b2e5bb2892b393b4ad603549b53005bff33135a8316aec

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.0.5-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 f8fb32445fba28c68e08e8cb7c6753cea358f363ce7f41018ae8125b43a8d89f
MD5 b78ac193868e0f4405af8f9d25a45f93
BLAKE2b-256 edbd9e6f93fdc406461138f21a10812bff2961b993bc2600fd1051e46d66c6e4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 279df2fbe4827f7dadcb0f26243e702b79aa599745a0ae9caad05eb8288955ec
MD5 874c20a298ddfc877c58fafc83abf340
BLAKE2b-256 13b693a6503ddccbdf0a927d613d9d10af9cf10743ad842cbae36e363ddc227d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.0.5-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 4ae21e345bc3593a33c1ada53c43564a9d615dd75aa0ec5c38b4633ca0e903f4
MD5 b54a56cdd7edd53b6ada625a3c215a10
BLAKE2b-256 4435ba0c671d97c16cac188c1c8428ad326847b4d5f672caccdd67f10765f092

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