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

Uploaded CPython 3.14Windows x86-64

arcticdb-6.16.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.0 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp314-cp314-macosx_15_0_arm64.whl (18.6 MB view details)

Uploaded CPython 3.14macOS 15.0+ ARM64

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

Uploaded CPython 3.13Windows x86-64

arcticdb-6.16.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.1 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp313-cp313-macosx_15_0_arm64.whl (18.6 MB view details)

Uploaded CPython 3.13macOS 15.0+ ARM64

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

Uploaded CPython 3.12Windows x86-64

arcticdb-6.16.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.1 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp312-cp312-macosx_15_0_arm64.whl (18.6 MB view details)

Uploaded CPython 3.12macOS 15.0+ ARM64

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

Uploaded CPython 3.11Windows x86-64

arcticdb-6.16.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.1 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp311-cp311-macosx_15_0_arm64.whl (18.6 MB view details)

Uploaded CPython 3.11macOS 15.0+ ARM64

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

Uploaded CPython 3.10Windows x86-64

arcticdb-6.16.0-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.1 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp310-cp310-macosx_15_0_arm64.whl (18.7 MB view details)

Uploaded CPython 3.10macOS 15.0+ ARM64

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

Uploaded CPython 3.9Windows x86-64

arcticdb-6.16.0-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (20.1 MB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

arcticdb-6.16.0-cp39-cp39-macosx_15_0_arm64.whl (18.7 MB view details)

Uploaded CPython 3.9macOS 15.0+ ARM64

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp314-cp314-win_amd64.whl
Algorithm Hash digest
SHA256 7ed1686dd05842d5a954fc71de3307b520de1a1dfecd0d36746f446d780858cd
MD5 b7759d8aab995a776bcb2691d78a7387
BLAKE2b-256 5103e77b4feacb45fd90b31f539e3233b911ec620b24d263bd0cfff23dd4b39a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 feda3241f50b43b5dd5556217cb90373e7cc34e59a09939a2fd79d215b72de7e
MD5 84c4ba7f8e6405246bbe26a3f2dd4420
BLAKE2b-256 9533bcabc488507740db290444ff9e9131c01c4f7d785cb2d42fb924f795c0ef

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp314-cp314-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 d0bcea86dc594ef05710af70e32bf597e22da9bb9781a3a65a7b6dd51ff32d31
MD5 857300686781e8fd1762c61c5af1501d
BLAKE2b-256 829c0f7e40da4821f79e722b0252c1a1027a3f1c192db4294a1b63e6182513a9

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 b025835b5cd1c238e1ab7c8edc4984c6b6af60d2a1fd2eb1362652f871810dbe
MD5 962595045148ad6fba0e82c77a6203c0
BLAKE2b-256 4b073036288acb25a63daeec369f1e77f9e6d180c218e2dcfd41a05fea5cea74

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 2e1f3d6f0f62e6f304b93d8b3bc432c5fe623c544b05588f5856e39814b2c5da
MD5 f443806fe6378e66c3a5d6eab7ba01f9
BLAKE2b-256 dcdb8251981fa3ee3099c160813f52b5d7dedbc8bbd3b2213a253b96b876b8a3

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp313-cp313-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 70e055a1b54dff167346c64e6ac3dba6040b6ee54cea49ff568eb045c60b7c0a
MD5 346c1a6206fc1f6daf21905aedf13b43
BLAKE2b-256 2cabad0725dfd54452ff901d43d91196a8d206ec660efce5d017181d4248c92a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 c6b348c64cf00de4d6fc7b0fef42e827d8dc708a60fc47d3dcd760404bcf4a14
MD5 7117038d0c70babcf663c4d886092d8d
BLAKE2b-256 3c128663ee7c19e2d21cf2773302c6d8436d83367277697a564b944db8013b31

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 a0086406ab2a193c49ad5e8208afceb22de9c8cb428f8567f5bec9e2b98d8fb7
MD5 bb2be1ae61b05fcf680b75d5399645a0
BLAKE2b-256 39b8ecddea2079de891c3f12bca21d82ed3e62b5369078f107046d7e7efab00e

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp312-cp312-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 cbf6ca7808b45a41fb2d1052a8cd666a0548080613b39809fb45e32d8b64df61
MD5 565ce14ff993591e4c5f8aa2124e2a55
BLAKE2b-256 deb93a25c24a887f00ff6c29d5e68d773f04cf6d7b8fbb9cc29d142e938886a4

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 dc120678a3f26f6aa99b6b4222b28e0dac53295e03a005a050eaa659f625d403
MD5 38381bf6cccb6871b9d90059de8bc1ca
BLAKE2b-256 daabbcc2f17cff9799c03ce592611e93cd266dbd44698571ae51b9cc27409b37

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 57ada5b7b96eccadbd3fcedaa53f8e37bcc218e7deb022bb41307061d06f1a73
MD5 74e40e8c05ec665e7f32051d1f2f1f02
BLAKE2b-256 2e1cfcfdaa3489352f9153660992572dc0a91fd86a85358533a481375f5e8c1f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp311-cp311-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 cb07195cc8df65d4bb8e47e3c6ed16e58b702a061de653692b47bf32ec49151c
MD5 ef72c99b1f20fd8060fdd5c8e785bdc6
BLAKE2b-256 019434530f79a17bb5713db6f52219755c6ee182c9f830493dde1ee643d2e10b

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 859e751aca1c6b2798004b7478f5b24e526b1ca232dadf96756651a5611bb77f
MD5 ba8d3d2e8c6ce04a93b9de94f6536c24
BLAKE2b-256 d8d9e5b3a3d115c5f8c69e4ad1982a3534a93c06bfccbba478d21740836c64e1

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 ad4c0f02eaa9cdeb68190c4794214c7efa680621c335185a4b38162c5f5405fa
MD5 4ba91dec6f982d244135b0116c64b34c
BLAKE2b-256 5b05a60d5adda852a6ba527bb7999064722a907a0067648333458b189c9c3618

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp310-cp310-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 9d6ca42fdc03dce8402bcb8a4fd305cb6f9c0d5cf948306c43b55882c595e16a
MD5 1b4bc48b2e10deb7df9618ca78c549e1
BLAKE2b-256 edb8937ab6e886c781f061155099af937846f8199f87b730addd314678609eac

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-6.16.0-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.16.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 3d9c21507e91313ead5805fb749fdfe023342abdffff5a81a643ce40f4a03392
MD5 95cce0932b8f94b52233a87c2cea0679
BLAKE2b-256 b0200e802a8cc555da17fc80b212c7ea54ef050587952948d68385844bf2771c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Algorithm Hash digest
SHA256 4fc50dedfc5a6cc9a3115dbae2b16ef7b272dc080ce8f0f00844d3304e674955
MD5 acdd20b424bd6966fd4458dd7be96a35
BLAKE2b-256 f6fa9ba795f34ca50e964aae77037e297d67c783c8e4e0614cc767c0e6646e07

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-6.16.0-cp39-cp39-macosx_15_0_arm64.whl
Algorithm Hash digest
SHA256 ff19772dc4768c23420dcf0be6118e86f037a46590d2ec2dceb05a41d108408f
MD5 1e06b1f9d4be222f6cee739934f70c4b
BLAKE2b-256 cfec4a1db6f9aeca1b1816debabfab13dc7752e40ad96e43413c0d97ada9cbce

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