Skip to main content

ArcticDB DataFrame Database

Project description


Three minute ArcticDB demo from PyQuantNews

Options data in ArcticDB

ArcticDB Website | 📘 ArcticDB Docs | 📰: 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.

Use of ArcticDB in production (including business or commercial environments) or for a Database Service requires a paid for license from ArcticDB Limited . Please contact info@arcticdb.io for further details.

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 (for the current version)

PyPI (Python 3.9 - 3.14) conda-forge (Python 3.10 - 3.14)
Linux x86_64 ✔️ ✔️
Linux arm64 ✔️
Windows x86_64 ✔️ ✔️
MacOS x86_64 ✔️
MacOS arm64 ✔️ ✔️

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 ArcticDB Limited and is licensed under the ArcticDB Software License Agreement. For more information please contact info@arcticdb.io.

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
4.4 Business Source License 1.1 Apr 5, 2026
4.5 Business Source License 1.1 Aug 14, 2026
5.0 Business Source License 1.1 Oct 31, 2026
5.1 Business Source License 1.1 Nov 15, 2026
5.2 Business Source License 1.1 Jan 27, 2027
5.3 Business Source License 1.1 Mar 24, 2027
5.4 Business Source License 1.1 Apr 28, 2027
5.5 Business Source License 1.1 May 13, 2027
5.6 Business Source License 1.1 May 26, 2027
5.7 Business Source License 1.1 Jun 2, 2027
5.8 Business Source License 1.1 Jun 9, 2027
5.9 Business Source License 1.1 Jul 7, 2027
5.10 Business Source License 1.1 Jul 29, 2027
6.1 Business Source License 1.1 Aug 20, 2027
6.2 Business Source License 1.1 Sep 8, 2027
6.3 Business Source License 1.1 Nov 3, 2027
6.5 Business Source License 1.1 Dec 11, 2027
6.6 Business Source License 1.1 Jan 6, 2028

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 info@arcticdb.io.

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 info@arcticdb.io 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

If you're not sure about the file name format, learn more about wheel file names.

arcticdb-6.18.3-cp314-cp314-win_amd64.whl (9.7 MB view details)

Uploaded CPython 3.14Windows x86-64

arcticdb-6.18.3-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.2 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp314-cp314-macosx_15_0_arm64.whl (20.2 MB view details)

Uploaded CPython 3.14macOS 15.0+ ARM64

arcticdb-6.18.3-cp313-cp313-win_amd64.whl (9.4 MB view details)

Uploaded CPython 3.13Windows x86-64

arcticdb-6.18.3-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.2 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp313-cp313-macosx_15_0_arm64.whl (20.2 MB view details)

Uploaded CPython 3.13macOS 15.0+ ARM64

arcticdb-6.18.3-cp312-cp312-win_amd64.whl (9.4 MB view details)

Uploaded CPython 3.12Windows x86-64

arcticdb-6.18.3-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp312-cp312-macosx_15_0_arm64.whl (20.2 MB view details)

Uploaded CPython 3.12macOS 15.0+ ARM64

arcticdb-6.18.3-cp311-cp311-win_amd64.whl (9.4 MB view details)

Uploaded CPython 3.11Windows x86-64

arcticdb-6.18.3-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp311-cp311-macosx_15_0_arm64.whl (20.2 MB view details)

Uploaded CPython 3.11macOS 15.0+ ARM64

arcticdb-6.18.3-cp310-cp310-win_amd64.whl (9.5 MB view details)

Uploaded CPython 3.10Windows x86-64

arcticdb-6.18.3-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp310-cp310-macosx_15_0_arm64.whl (20.3 MB view details)

Uploaded CPython 3.10macOS 15.0+ ARM64

arcticdb-6.18.3-cp39-cp39-win_amd64.whl (9.4 MB view details)

Uploaded CPython 3.9Windows x86-64

arcticdb-6.18.3-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

arcticdb-6.18.3-cp39-cp39-macosx_15_0_arm64.whl (20.3 MB view details)

Uploaded CPython 3.9macOS 15.0+ ARM64

File details

Details for the file arcticdb-6.18.3-cp314-cp314-win_amd64.whl.

File metadata

  • Download URL: arcticdb-6.18.3-cp314-cp314-win_amd64.whl
  • Upload date:
  • Size: 9.7 MB
  • Tags: CPython 3.14, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.12

File hashes

Hashes for arcticdb-6.18.3-cp314-cp314-win_amd64.whl
Algorithm Hash digest
SHA256 e320d2c9848591fcc33eeafac2ed8003bd2d6a70ee0c1dc118e2e3808e902349
MD5 67f95181a215bd96eca8310951c7d9f7
BLAKE2b-256 5b047b5e1abe7d9dcbdfb52e3f4d41ca01d3f3843aece305d7559fa2fe7bcb55

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 5c851c89af8c6d52cb4c7da9255556aa39bde9f608e030d8d694d916c3950385
MD5 61d9344c878846b93ef7b675b835ee91
BLAKE2b-256 8210677acc0f5e9d6dccef41c904f687f72e51201aa180cc9a688af78ac74808

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp314-cp314-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp314-cp314-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 32fdb3804d7a3a25e9562c07fcca957bb4e140d3c727bd95a0e1175250b8c2ab
MD5 03e856d1a41491698f9a871fbebaad97
BLAKE2b-256 4438e34f0e6368b6b953d0479100d78d8582fc2b8b4c69027e7f1ce7138c448e

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp313-cp313-win_amd64.whl.

File metadata

  • Download URL: arcticdb-6.18.3-cp313-cp313-win_amd64.whl
  • Upload date:
  • Size: 9.4 MB
  • Tags: CPython 3.13, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.12

File hashes

Hashes for arcticdb-6.18.3-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 740355b1560dd3e461d7c8676ec84b5b838a505a2b27b14b4f949f71f3b89c89
MD5 7cf94c68d5367aeeff5fa5142e540193
BLAKE2b-256 b931a58afc2a2da31f54808e1361ed73a2093f62a47b78d451453b01d2d222af

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 1d919e8f4c441aa397263211d99f2bba1eb180e7abb3f57207274f15b1e3781d
MD5 c843c26135d146368ad4e664f0dce2d3
BLAKE2b-256 bc3f4915c6b9cc1c9b73748c926a7d4533cd2c626404a1664343277fa4d02475

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp313-cp313-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp313-cp313-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 cc97b46d2a8d2d52b10a934f1caeb1deefeb6928c59911013e82af432678c6a9
MD5 d6849012b4843a14ade758eb84fcca4a
BLAKE2b-256 4af35272ae67912b850dcc0e0262b5cb2c6c27bef6022b3d00332ebf3eb35492

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp312-cp312-win_amd64.whl.

File metadata

  • Download URL: arcticdb-6.18.3-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 9.4 MB
  • Tags: CPython 3.12, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.12

File hashes

Hashes for arcticdb-6.18.3-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 6c0053eb1e33459acfdfdbc8dfa417d2792ef2b2ea6c84029a861a0d996533aa
MD5 48b30b2d66f408b3168cc5acd1829a63
BLAKE2b-256 2bf79136193a3436aca32678748f053d417661047c2e010c520efd85bfd50362

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 24b83f3307c94a9764c04ee164194a0c9969244835d1f595201e442aefff1f0b
MD5 8d42a20584dc3832c82a60d76ab7c695
BLAKE2b-256 40acc24bf36fb33fffdd15f4d4c7cfa7e9756640a989aef04dc4b38a2ffc491e

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp312-cp312-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp312-cp312-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 d29a47618c9723186187395c77269d5e92e13a65dded1617b917824339657619
MD5 531c1875038e03d1d5dfcd6e35d0f9d1
BLAKE2b-256 6487cfb863d1748d9a9256ab662742b4c44cb53a84633843f0e3a174c1b02df1

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.3-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 9.4 MB
  • Tags: CPython 3.11, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.12

File hashes

Hashes for arcticdb-6.18.3-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 0f5ebc500fe6bb679d4273f8a5680088eb5caa97e96568623022c0e288965a3a
MD5 99d7f4f05e7cd9876f72a51e36c6f00f
BLAKE2b-256 bc425f629a6b59afe507ab5e48d23dd3a7f755d591cf2a3e2196251631e95c06

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 1988c281fb302c04feadc6f4fc5c22e4af2f370a7427bc969bc1b678895aa319
MD5 8984ca72cbc52717c4e550e28fbc0435
BLAKE2b-256 246f6e548849bf653a8bdc98cbdebe124540e99e0a6280dea607257cc695dd54

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp311-cp311-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp311-cp311-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 cebb177f1ad6a215d789f072bed82a9bfa8d16f6d1426ff848213c2a2d14bd6b
MD5 e06b3471405b955c56485332ecba8b1d
BLAKE2b-256 75d6fa7af3c261f0aadff6352ae3060fc3f586fe3f35c50e5764cbb439eb2dc1

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.3-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 9.5 MB
  • Tags: CPython 3.10, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.12

File hashes

Hashes for arcticdb-6.18.3-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 0b1f79999a316575586eda1b820c895e0ac7859e082c24c6d51e2bb875ce9b3e
MD5 da14ee2665a9810b096d5f13d2fec4aa
BLAKE2b-256 2818de75574ed9e757cd25b394ed77cd5aefcbead5a31e966edeba8a9746b724

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 55c50238ccf224ed983a463df61a2f179cbdfd66f48e20cd2f540654bf97d11f
MD5 9cfe9958d5c0512efd229a62d0266a2a
BLAKE2b-256 59c97a85334e8484fca53073f343aeb0c04df46993dcb96e29e537db57e50823

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp310-cp310-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp310-cp310-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 6679f5311a96c2982948de0ff5ae4cb86daef70934a728fa0b2446d77da02eb1
MD5 30f3302d65ef78f5bf57bf1f89bb9268
BLAKE2b-256 0ef66cd3f2aaaccd19ba5bd6d9a444bf32a4a23c9d141569ed089fb887b4ccd0

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-6.18.3-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 248919403ffac1572b2c0d144c662eb60f5a9127e77dd9165e445de2d46e7fb4
MD5 03253b5ec01b224fff1e57cfd5db74e3
BLAKE2b-256 7750216e635bc105997808d89e82fad239462f04abd494226af94da978bd2a97

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 c5769f52e7dc9ae21742e46ea6aa86b91e72c11ca0a130c9071a130c90748f67
MD5 9a578dbed147de3fe020ab2f70d06945
BLAKE2b-256 b2c688a8403628abc18eecadbfa9553fffc6b5fa332b08b598052c981bf5c4e8

See more details on using hashes here.

File details

Details for the file arcticdb-6.18.3-cp39-cp39-macosx_15_0_arm64.whl.

File metadata

File hashes

Hashes for arcticdb-6.18.3-cp39-cp39-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 e4ed2494704752ce615cb7c4525693efd098a29c0cf3ef6029a31f3647408af8
MD5 597f5f086b466d44e7ccd9efabb4cd86
BLAKE2b-256 744a20e79c365b7c3c540c7f8d79006c0fde6a41191c351b42d0d8c5403a23c5

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page