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

⚠️ Pre-built binaries only available for Linux and Windows: MacOS binaries are coming soon!

Install ArcticDB:

$ pip install 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 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.

For each BSL release all associated alpha, beta, major, and minor (point) releases will become Apache Licensed, version 2.0 on the same day two years after the major release date. For the license conversion dates, see the table below.

ArcticDB Version License Converts to Apache 2.0
1.0 Business Source License 1.1 Mar 16, 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!

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

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

Uploaded CPython 3.11 Windows x86-64

arcticdb-1.3.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.4 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.17+ x86-64

arcticdb-1.3.0-cp310-cp310-win_amd64.whl (6.2 MB view details)

Uploaded CPython 3.10 Windows x86-64

arcticdb-1.3.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.5 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

arcticdb-1.3.0-cp39-cp39-win_amd64.whl (6.2 MB view details)

Uploaded CPython 3.9 Windows x86-64

arcticdb-1.3.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.5 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

arcticdb-1.3.0-cp38-cp38-win_amd64.whl (6.2 MB view details)

Uploaded CPython 3.8 Windows x86-64

arcticdb-1.3.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.5 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

arcticdb-1.3.0-cp37-cp37m-win_amd64.whl (6.2 MB view details)

Uploaded CPython 3.7m Windows x86-64

arcticdb-1.3.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.5 MB view details)

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

arcticdb-1.3.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.5 MB view details)

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

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 16576e878d05a10f2b92fa3cb4377151ebdf53471b670955bc75876200388a04
MD5 6ef1eaf2cb83e8b70ce6ef4b37d30b9e
BLAKE2b-256 06948e77b460663df7c37bce2f013d7e08d3e44c0b1d423ee829486675c38239

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 aaf24b19e3a0ded35a99db9990498f8f0ef87b794f5b35751441b751404fce12
MD5 3f296a2d6a995a3c76e949cf4fd233a7
BLAKE2b-256 49289a330f01fe3b1096afcd2f0507b05e90ec4dd0aaa27f476cd803ef6f11fb

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 ea3a427d020a6cd929ac9ddda3469bc32776d92ba72236219928a07594fd9d6e
MD5 64936ff0a8a2c050d77ebb4017682527
BLAKE2b-256 77703f51d83c2961c1ea41aca736e1c6a80f0eeb301e8cc0bc7485a07938e3b1

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 d1e246dd2e3bc376efaeebb9dec1a020fc77af1d06de887483fb7714ef480934
MD5 25a004064b26fc3e1afb42a3435d6b65
BLAKE2b-256 da3b1797780b52a24361e57709a092a9942be22b16bb33eee86d3619221068a7

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-1.3.0-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 6.2 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.6

File hashes

Hashes for arcticdb-1.3.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 c62f187afbde0631eb4d568b4d39c6ca8720ee31e4737c11a1786372129c8aff
MD5 e8775060b26494cc5c7dc42666a13967
BLAKE2b-256 21ed90781b057053c3b8bac5abeaa33ca1a90a6fd3d09161ef420e846d733a8b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 5f9b08252bce57826e7db55cf892365793829156daa7a9ae5459372a6557703b
MD5 0a752c5d2a8c7a59f98e7197a193bf61
BLAKE2b-256 02cce74728d4be97fb43ec6870183061a7146b11ee4b7845416a7934ffeff72c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: arcticdb-1.3.0-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 6.2 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.6

File hashes

Hashes for arcticdb-1.3.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 1f1a1d7498bd40b4fd08a6d654344c9b00cbb7d7ac991fa3ddfab44e10f58f69
MD5 5a83c2ea45a0c54fe33fab701e1fd8f0
BLAKE2b-256 37a17bd3f22fbc5c7b794ffe0ec85f69255e8763480e8e0bf7840183fe07a4f8

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 43b42103f43a7973c35951a596752242854f9d9a2284dc0e24eb517b932048a7
MD5 1bd3f30c260172ba0eecb797b3292581
BLAKE2b-256 a20c623e97b35010421709a0938ff9f57bd579d091069f434da7496d5d86f731

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for arcticdb-1.3.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 babe7389da6701cc99fbed85df4a340b3e9150d747b5d19338edc8cae2000ffe
MD5 4abbbd89ac706947943fb31abefb2bef
BLAKE2b-256 52beb6ab90f2d880600f077b4e4229a00d8c91a44cf3b53cfb62dc3f842b82ed

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 7f99cefeca20c2cce9c01cee226078c819503167a6cf1cf533d0a3617c59133f
MD5 e7e93b2174c3edc64f04bc04266f408b
BLAKE2b-256 6851e319353ed37582d1a0c16dc355fc4c67768d8a1b2f2ecf9b7fc443b60951

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for arcticdb-1.3.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 51ec925dafb59e7f01509844da5002cc639baef55410d923726453332f319fb1
MD5 513a12710ab095834deef7144f2b462e
BLAKE2b-256 242a371d895b3d6dc994f752c638648711468ffa4018b9df00558528aa37631b

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