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 ✔️ Beta ✔️
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
4.0 Business Source License 1.1 Sep 27, 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.1.0

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

Uploaded CPython 3.11 Windows x86-64

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

Uploaded CPython 3.10 Windows x86-64

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

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.1.0-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.1.0-cp38-cp38-win_amd64.whl (6.6 MB view details)

Uploaded CPython 3.8 Windows x86-64

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

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.1.0-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.1.0-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.1.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 c620df9e3f8fb4a163373e8a127b046553c74bf8fb3c3d0cddcc08d69987bc13
MD5 64a7d18e53653645ba4ff3cd3033adbd
BLAKE2b-256 9cdbbbf4380e72facc196965aefe0e56703966972d2734941209b504ae109853

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 93d301cfb57eb2e6e356b80b7d5b66cfed3e905dd6539ccb884243752b38912a
MD5 96eb002ea53ae4e9ec9aaa8331f8f5ce
BLAKE2b-256 39e2f07e6f71b012b577afb8828c526518cde8d594d5526b454edd2b0e8e104c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 a8454189a54f2c48b78446ff38a95e18a422c5fb250916c09e871d13bee27beb
MD5 41643f52e7ca4b6795f31cb465ff11c1
BLAKE2b-256 cfdad4d9b50557828ec0d4a3f3c8af4f9a6c675c0898d22c9fa814f6c2a8ae83

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 95251aa997dd33aeb6b5396761033e7a1d2a7049fe8257f2f8b8892a258f9de4
MD5 d35c2f02e97572ca8b743b857470b0e0
BLAKE2b-256 478574e06432f2d5d8c99eb4f067ed116e9e00037f978e858ab4efc921f8bd97

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.1.0-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.1.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 f383d0549e3cc09a9b7f0bb0f6ea8efead90be58967e4bda1a8eae5a4291c176
MD5 898ca14102db31674e6d885debf4e669
BLAKE2b-256 e4115a0e1d8c12991dce10f15fa2cdf7fc3214ceeb5851ac7e84d91d56ed191f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 909bc26ac15d00682dc2bf5da37628dfaa1b47d447e3a7d146b041dd9a2e21f2
MD5 7e584780e2bfc4f5c36aec382771d16a
BLAKE2b-256 cad254df399b6c177257ad5ad83f0a0e5111eede954c9494db2ca4d73f906d0b

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.1.0-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.1.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 895769f08f979d8abe4a5d32aee04dda96c25cb593514c50b61225a0b11827b9
MD5 d5480f0cef2e9200876769bdcafce891
BLAKE2b-256 4e9c0285c57f67392bdf5c6024552d63b2aa13153e3490b92e3dd04219b42567

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 8579f3fc9ab03aa972459a84604e9cabcf9be0d42bc7d5650ea6da8176d013b1
MD5 a7af7af0332d33de2a54ffb162522fe3
BLAKE2b-256 ea82d8b33112650558f0d7abb09739bf3c8eafe4f471debb9e8b4c4e735539cd

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.1.0-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.1.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 40b170ac1ea11a05c92a15d865e8de73d9f11296464face81a289d6dcfad01a4
MD5 1192e9ddc80e1ba8707017dd39aee086
BLAKE2b-256 7f368365a130c0534542315742a33882c7f99735dff55207f2510d42399c6ec5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 9786c8acca9e9d6d564e45df62220359b19ea8e9695b426771aa65c618eb1209
MD5 f3b2ff9c203f076b015fdf7c48b73f4b
BLAKE2b-256 62cfa4344ae5b352250e9affe68eb44ebc19738daa8bee8a2d846fcc1b6e0561

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.1.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 cb46793bfa9b93895800dae40c8d542f4a3815ba8b0acd6304d36673578d5f2a
MD5 14cb1f07476db07dedafaf34cc9cd1c9
BLAKE2b-256 f0e0eff04f07a71bc19b626d71febcd78abb328ee223cf0050a32fc47be67bc3

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