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.2-cp314-cp314-win_amd64.whl (9.7 MB view details)

Uploaded CPython 3.14Windows x86-64

arcticdb-6.18.2-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.17+ x86-64

arcticdb-6.18.2-cp314-cp314-macosx_15_0_arm64.whl (20.0 MB view details)

Uploaded CPython 3.14macOS 15.0+ ARM64

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

Uploaded CPython 3.13Windows x86-64

arcticdb-6.18.2-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.3 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

arcticdb-6.18.2-cp313-cp313-macosx_15_0_arm64.whl (20.0 MB view details)

Uploaded CPython 3.13macOS 15.0+ ARM64

arcticdb-6.18.2-cp312-cp312-win_amd64.whl (9.5 MB view details)

Uploaded CPython 3.12Windows x86-64

arcticdb-6.18.2-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.2-cp312-cp312-macosx_15_0_arm64.whl (20.1 MB view details)

Uploaded CPython 3.12macOS 15.0+ ARM64

arcticdb-6.18.2-cp311-cp311-win_amd64.whl (9.5 MB view details)

Uploaded CPython 3.11Windows x86-64

arcticdb-6.18.2-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.4 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

arcticdb-6.18.2-cp311-cp311-macosx_15_0_arm64.whl (20.1 MB view details)

Uploaded CPython 3.11macOS 15.0+ ARM64

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

Uploaded CPython 3.10Windows x86-64

arcticdb-6.18.2-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.4 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

arcticdb-6.18.2-cp310-cp310-macosx_15_0_arm64.whl (20.1 MB view details)

Uploaded CPython 3.10macOS 15.0+ ARM64

arcticdb-6.18.2-cp39-cp39-win_amd64.whl (9.5 MB view details)

Uploaded CPython 3.9Windows x86-64

arcticdb-6.18.2-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (21.4 MB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

arcticdb-6.18.2-cp39-cp39-macosx_15_0_arm64.whl (20.1 MB view details)

Uploaded CPython 3.9macOS 15.0+ ARM64

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-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.2-cp314-cp314-win_amd64.whl
Algorithm Hash digest
SHA256 575672ed31c7d033dff864e188faa76b3cb8cb8e26bf93242463191b2182c342
MD5 3c512ec844f6e84d4ca7f910641e304d
BLAKE2b-256 38009c59089b888fe86de331ba4175f8c2f3510536cec54ec252c6713a7919c3

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 7fc16dae62575d21fe96316edf05e78460a4876614771af8b470096b2d7fb9f3
MD5 2f7efa33f20e4ed27b633f1fc1832596
BLAKE2b-256 1faa90577958f5322e2eae2361ecfd9d63a4f2454e69e3a1c1276ade574f9f7f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp314-cp314-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 64ea35dc9599bbaff25fb993e0f6bec7d93b7d24730225c379652f8a37b5f047
MD5 cd7735062de5374db8c182abde9ff917
BLAKE2b-256 9f247086b71da9a3c869c0d21ef72e7062e10e61dd0c5da4934ab9b0464a640a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-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.2-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 e6b26da8d4dd1185a9bb7873f0d92247eb8cffba1805d2ea3b201966aba45519
MD5 c7130086d14aa5241086b8ec07acb136
BLAKE2b-256 1620d191f3b2aed47867f8dbcc9b469ba9c7d2cb7ff3b37df8b03d211bc824f7

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 e67b03f0dfe62bd65bc51e3afeadf022ad23021352f6609d56efbf5a403873a7
MD5 928f66c1245f3d606d0b998a9d8cdbff
BLAKE2b-256 80105373f4ae835d4a97bd63504bce8da58a0d6621bb940237f27be7877d5d65

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp313-cp313-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 c0d02689169440f2e4ba79405097cd3e287d43c8ffdfdd003af5979127850551
MD5 b3038209dfcaf23df824fe935b69944a
BLAKE2b-256 3bb63929d80420862613bd2e2529f0d97a78b764d6daf7e52f91c8c424bbd812

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 9.5 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.2-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 eddde563002af069d271bc003de64f803ed188e80ec22c7e2b7c2d6b2ac48674
MD5 091a179c9134e7aaf6f0c5e46da5e91c
BLAKE2b-256 be049275c8612874f7bfc55c87615cb0b038d0eeb83c251bae2194d57b03c7d7

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 875d0e13f1d1df739f70c1c0bab6d28af0bc750fbf28717db0e2df16ba837b1d
MD5 cbd9b0c0dc53572314ec63ac10911590
BLAKE2b-256 cac748a9fda9cbc255c34bc9ca357e6ca128db8d0fe1394bfb102a43e79dd750

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp312-cp312-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 09c997369aa88c7fc8753d3b19cb4437d33318395cbf44f9a0811504ab602b76
MD5 d01d46e32cfe6ed1deb2868d61c12d0c
BLAKE2b-256 c9a79127d74a01755b14117a5eb3230d70f2fc37e99810aa830d20819b1f7e45

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 9.5 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.2-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 3613669aec856dfbbcd4faa48c619083d59e7ebf08cbd1bb00a518d65eb99b08
MD5 f30ed4c7f8aee0006d0c20d3e6d304ee
BLAKE2b-256 ab45ca8e5503afa0f09825b54b446dcc54a33b6bc710110b00d7430027103e9c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 24bde24a72f0cada8b9d2ad43dc824be5dc3abb3956284d9c3fab8cc919eae23
MD5 1e3e2a4bfb75990b4d80eb6979c8e18b
BLAKE2b-256 9eda3a81dc82014d540d34a261e2260ef3769bc2f663a0cf014e08282d743298

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp311-cp311-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 53b6fd6d1f371f9ab258e8c375d2235eafbb2caa4585626181116f4bed16cf15
MD5 9d5c0ddd140cd6c96bed9bbf86dcedb7
BLAKE2b-256 4b2b53dbee5f8732262dc16f6776e6c2001798449b4c95c34ac39af417c33e9b

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-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.2-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 7f20905b20186a603e9a87db67c68c087b4debeaa8368bb68708e928555b7ab6
MD5 b5f3c452063afee129bc342a6245f73c
BLAKE2b-256 50a751e2b9f61cb9effc897f7bad9eb1b7bf65c28f274fc0ab419318d97eb4a6

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 e1eaa257ecbcecc0dca79a1e09abe1d5704be15a2f2bcd3463d21889c936e535
MD5 986e512ef4f5742ca631eb0295d006ba
BLAKE2b-256 2b7db9c0b208e2488ae78e5b2e1685dc86639d6f6028a570553e6790be884da4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp310-cp310-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 e95f8a580d2b8831346f5827e417abf0f25025b7f008bd7657c439d6d11b48ba
MD5 7ce491cd8aee38585a598d4d18f6b97d
BLAKE2b-256 4b11f57a7a51da34dad9c528e4904d824c609c450e997ffa0eda499002e561b8

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.18.2-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 9.5 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.2-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 c960b8d9270a722556542fea648c39b006b02e75838fc7c11ab9636535549fc0
MD5 85c1b9c57e566f824baf32a5ccb77bf9
BLAKE2b-256 1242fd82ebb1ec0ba2840e66ff2002f6ed0096e6416f24baefe23321d7bdbeb9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 a240a831994861a343fd35a3ad1720016c055a338449cff6035bf1c371b5e033
MD5 9d584c9bce7c09fe0d4f5156036725cd
BLAKE2b-256 b789c18673298fd9e2635d16869133a8ee8815d6f326abad36adf5230d9ed5dd

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.18.2-cp39-cp39-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 8536e0024e1374b1626d301a7e3cced3d7bfee5312c9c342e94f5672acf7cb53
MD5 1cc4d79a25a1a16aa8a8f258ab5215a3
BLAKE2b-256 bdd57cbf995a8c41af457009270be17ec6e4af27fcc3cefca488cbf6830959d1

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