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 (Intel/AMD) ✔️ ✔️
Windows (Intel/AMD) ✔️
MacOS Beta️

For conda-forge see the release-info.

Storage compatibility

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

We have tested against the following S3 backends:

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

Installation

Install ArcticDB:

$ pip install arcticdb

or using conda-forge

$ conda install -c conda-forge arcticdb

Import ArcticDB:

>>> import arcticdb as adb

Create an instance on your S3 storage (with or without explicit credentials):

# Leave AWS to derive credential information
>>> ac = adb.Arctic('s3://MY_ENDPOINT:MY_BUCKET?aws_auth=true')

# Manually specify creds
>>> ac = adb.Arctic('s3://MY_ENDPOINT:MY_BUCKET?region=YOUR_REGION&access=ABCD&secret=DCBA')

Or create an instance on your local disk:

>>> ac = adb.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 License 1.1 Nov 1, 2025
4.2 Business Source License 1.1 Nov 12, 2025
4.3 Business Source License 1.1 Feb 7, 2026

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.4.6

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

Uploaded CPython 3.11 Windows x86-64

arcticdb-4.4.6-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.6-cp310-cp310-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-4.4.6-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.6-cp39-cp39-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-4.4.6-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.6-cp38-cp38-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-4.4.6-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.4 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

arcticdb-4.4.6-cp37-cp37m-win_amd64.whl (6.3 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-4.4.6-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.5 MB view details)

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

arcticdb-4.4.6-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (14.5 MB view details)

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

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 39791becc1fc8406a9f6c4a0dd0adf60c08de6d6fcdc5c8972b50c27910a89e2
MD5 44c355f1266ac5c5d2d43868e1efe219
BLAKE2b-256 20bb31b2c33f3159590a57e4604c89e9aa2e43006eba3c1ba91b8bc993d8e33b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 a74a7bc832898026ee0d894deb0c8443b6e9d63c0c5357e407e8e1c955cef6f2
MD5 809b3a9a428573508571aed55a47f522
BLAKE2b-256 c071a974f10c5db8850abcb7538b6aeafacef57b7d30c29208e30afdef04f48d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 f8cdf953014950d2e7c4a4124d988b20af019fedae44934438077bf7a1aa35c6
MD5 7916dfcd2c96ee7b3d36e70240cc68a0
BLAKE2b-256 9301ff6d8a772ee64111ce5484070c58a4501a06112ad1770c2c0f2cafe8d471

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 d5aa16e5f33ea3d570f7370d5e51d3a18ef826a66b73cae3b91f47442dc48d2b
MD5 4ad49597ad3a18b8247f2c5e903a204e
BLAKE2b-256 4ca6ed915ef8af1b8c5bb2ae33cf6ecdd8a63de9a0fb7c2a6d9fb66010f7d71a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-4.4.6-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 6.3 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.10.12

File hashes

Hashes for arcticdb-4.4.6-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 6eea7f710089f1c4f89474dc93113c1d933d6077e5e5021bae206ccdd94a8c4c
MD5 6fde5788ac5c67f08acde9192d6fde6c
BLAKE2b-256 e7359ddd53fa0a5105017668c9a39b59ce1e88692e24ba8dfb2e1ee9b221d556

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 90afe4a8c338d2d3d6f1f6f23e6938bf3e95f65a91f62a07c58ba17375fa68c2
MD5 98fd9cdb58d86342e329285ace907b05
BLAKE2b-256 cc00d4fc648e6d1c3af689691ed9995df6c960d0ca480c38fce08a9d9de4bfd4

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.4.6-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 e175fa3f3b22625a5b5c12ac308b6bab0a697800bbfed9ba3cea0a4a00a1c53a
MD5 288fa5a63aaa1c081330461a4fa6363a
BLAKE2b-256 d2b1d2992a16b68ca57204496487ee27510c168e0a2123117e2285e15cafda25

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 a004afb6e1647187d91bc84752771cb10c3170e40255ff3d5c0571c19eb65288
MD5 38deb5f0a0192855ea870d6ac5fb1b43
BLAKE2b-256 77d8bfa25a357bbf1f83196530eb937548a68227256787854ee1298470a848b7

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-4.4.6-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 377a0195634bf645c44b8859e35db500ec57796d94fe538976e421255933dc44
MD5 f428575c54e035020b33d7accf65f513
BLAKE2b-256 71236bc37efc3159d9cf80aa8db6eceeca43e5c11478439ff7afdb16073ed677

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 0193050ce90197a9c7f2306ef9ea008dff20a264827ba9649f0c9c0dea1848e7
MD5 1a13aab8a9866ec161e4943edefc63be
BLAKE2b-256 594d4be37084cbd2f3cb153c879e638676b456e0718d38a6f358e73d43c2f168

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-4.4.6-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 572875465f6b839f768b7c61ce2d9373ae1c7bbecb7151782598cb321f1d49be
MD5 d31b4cb0ff990a35c0f4103825019571
BLAKE2b-256 b0bc584f77d5d8367b654c551cf8ebd68ed0ca207d57febabe0c98e214dde02f

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