{ "cells": [ { "cell_type": "code", "execution_count": null, "id": "e7a9eafe", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "id": "ab2d3014", "metadata": {}, "source": [ "# Data Uploaders\n", "\n", "In this tutorial we are going to demonstrate the usage of the Bayesline Uploaders API. The Uploaders API provides a generalized mechanism to bring different types of data into the Bayesline ecosystem.\n", "\n", "Specifically, we will introduce and explore:\n", "* *Data Types*\n", "* *Datasets*\n", "* *Schemas* and *Parsers*\n", "* The *staging* concept\n", "* The *commit* concept\n", "* *Staging* Validation\n", "* Data filtering and downloading\n", "* Housekeeping" ] }, { "cell_type": "markdown", "id": "e83cb631", "metadata": {}, "source": [ "## Imports & Setup\n", "\n", "For this tutorial notebook, you will need to import the following packages." ] }, { "cell_type": "code", "execution_count": 2, "id": "278292ad", "metadata": {}, "outputs": [], "source": [ "import tempfile\n", "from pathlib import Path\n", "\n", "import polars as pl\n", "\n", "from bayesline.apiclient import BayeslineApiClient" ] }, { "cell_type": "markdown", "id": "e16ee68e", "metadata": {}, "source": [ "We will also need to have a Bayesline API client configured." ] }, { "cell_type": "code", "execution_count": null, "id": "6e5e823a", "metadata": { "tags": [ "skip-execution" ] }, "outputs": [], "source": [ "bln = BayeslineApiClient.new_client(\n", " endpoint=\"https://[ENDPOINT]\",\n", " api_key=\"[API-KEY]\",\n", ")" ] }, { "cell_type": "markdown", "id": "95f92839", "metadata": {}, "source": [ "The main entrypoint for the Uploaders API sits on `bln.equity.uploaders`. All upload functionality can be reached from here on out.\n", "\n", "See here for relevant docs:\n", "* [Uploaders API Summary](https://docs.bayesline.com/0.21.0/_autosummary/bayesline.api.equity.UploadersApi.html)" ] }, { "cell_type": "code", "execution_count": 3, "id": "c865adf9", "metadata": {}, "outputs": [], "source": [ "uploaders = bln.equity.uploaders" ] }, { "cell_type": "markdown", "id": "07d3ddcb", "metadata": {}, "source": [ "## Data Types\n", "\n", "A *data type* distinguishes distinct types of data that can be brought into the Bayesline ecosystem and are pre-configured by Bayesline.\n", "These include *portfolio holdings*, *factor exposures*, etc." ] }, { "cell_type": "code", "execution_count": 4, "id": "09b3b35d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['exchange_dates',\n", " 'exchange_rates',\n", " 'exposures',\n", " 'factors',\n", " 'hierarchies',\n", " 'idmap',\n", " 'mappings',\n", " 'market_cap',\n", " 'portfolios',\n", " 'price',\n", " 'series']" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "uploaders.get_data_types()" ] }, { "cell_type": "markdown", "id": "c5df98e7", "metadata": {}, "source": [ "Alternatively for ease we can just print the `uploaders` variable itself." ] }, { "cell_type": "code", "execution_count": 5, "id": "ffbe7c1b", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[exchange_dates, exchange_rates, exposures, factors, hierarchies, idmap, mappings, market_cap, portfolios, price, series]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "uploaders" ] }, { "cell_type": "markdown", "id": "d5bc4fac", "metadata": {}, "source": [ "We can obtain a specific uploader for a *data type*. In this tutorial, we will be working with the *exposure uploader*, but all other uploaders operate analogously.\n", "\n", "The `get_data_type` method (or simply the `[]` accessor) will return a `DataTypeUploaderApi` instance which distinguishes the concept of datasets (see below).\n", "\n", "See here for relevant docs:\n", "* [Data Type Uploader API Summary](https://docs.bayesline.com/0.21.0/_autosummary/bayesline.api.equity.DataTypeUploaderApi.html)" ] }, { "cell_type": "code", "execution_count": 6, "id": "05e03422", "metadata": {}, "outputs": [], "source": [ "exposure_uploader = uploaders.get_data_type(\"exposures\")\n", "\n", "# or alternatively uploaders['exposures']" ] }, { "cell_type": "markdown", "id": "7d3af70a", "metadata": {}, "source": [ "## Datasets\n", "\n", "For each data type (e.g. *exposures*) we can create isolated datasets. For instance, we might want to upload different sets of exposures. This can be achieved by creating a *dataset*. We can always retrieve existing datasets using the `get_datasets` method. Since we haven't created any datasets yet, this will be empty." ] }, { "cell_type": "code", "execution_count": 7, "id": "f41d06c1", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "exposure_uploader.get_datasets()" ] }, { "cell_type": "markdown", "id": "11c9476f", "metadata": {}, "source": [ "Alternatively for ease we can just print the `exposure_uploader` variable itself." ] }, { "cell_type": "code", "execution_count": 8, "id": "83290072", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "exposure_uploader" ] }, { "cell_type": "markdown", "id": "15aeaf21", "metadata": {}, "source": [ "Now, we start by creating a new dataset `\"tutorial\"`.\n", "\n", "See here for relevant docs:\n", "* [Uploader API Summary](https://docs.bayesline.com/0.21.0/_autosummary/bayesline.api.equity.UploaderApi.html)" ] }, { "cell_type": "code", "execution_count": 9, "id": "056173f8", "metadata": {}, "outputs": [], "source": [ "dataset = exposure_uploader.create_dataset(\"tutorial\")" ] }, { "cell_type": "markdown", "id": "1a13fe7d", "metadata": {}, "source": [ "Creating a new dataset logs a first version of an empty dataframe." ] }, { "cell_type": "code", "execution_count": 10, "id": "2f2f5058", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{0: datetime.datetime(2026, 9, 8, 13, 32, 37, 848165, tzinfo=datetime.timezone.utc)}" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.version_history()" ] }, { "cell_type": "code", "execution_count": 11, "id": "a73aef83", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (0, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
" ], "text/plain": [ "shape: (0, 6)\n", "┌──────┬──────────┬───────────────┬──────────────┬────────┬──────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞══════╪══════════╪═══════════════╪══════════════╪════════╪══════════╡\n", "└──────┴──────────┴───────────────┴──────────────┴────────┴──────────┘" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data().collect()" ] }, { "cell_type": "markdown", "id": "b07caec7", "metadata": {}, "source": [ "## Schemas and Parsers\n", "\n", "Every data type comes with its own dataframe schema. Every uploaded dataframe will be converted into this schema to ensure a uniform way to view the data for a specific data type." ] }, { "cell_type": "code", "execution_count": 12, "id": "5a6a32fc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'date': Date,\n", " 'asset_id': String,\n", " 'asset_id_type': String,\n", " 'factor_group': String,\n", " 'factor': String,\n", " 'exposure': Float32}" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_schema()" ] }, { "cell_type": "markdown", "id": "6292ac5a", "metadata": {}, "source": [ "We may have input data in a different format than what the exposures data type declares as its schema (e.g. a wide format).\n", "We can either convert it ourselves or use one of the predefined input data parsers.\n", "\n", "A *parser*:\n", "* Is defined for an input format and will convert it to the schema that the uploader expects.\n", "* Will add operations such as null-filtering.\n", "* Will record error messages if a given input cannot be parsed.\n", "* Provides access to example dataframes for the expected input.\n", "* Will ensure that the dataframe is valid if the parsing succeeds." ] }, { "cell_type": "code", "execution_count": 13, "id": "8f95ca74", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['Long-Format', 'Wide-Format', 'Windowed-Long-Format']" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_parser_names()" ] }, { "cell_type": "markdown", "id": "781742f2", "metadata": {}, "source": [ "For demonstration, we will use the `Wide-Format` parser. When uploading dataframes, we can simply pass the name of the parser." ] }, { "cell_type": "code", "execution_count": 14, "id": "62b68eaf", "metadata": {}, "outputs": [], "source": [ "parser = dataset.get_parser(\"Wide-Format\")" ] }, { "cell_type": "code", "execution_count": 15, "id": "33fd3c65", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (3, 9)
dateasset_idasset_id_typestyle^momentum_6style^momentum_12style^growthmarket^marketindustry^consumerindustry^tech
datestrstrf64f64f64f64f64f64
2025-01-06"GOOG""cusip9"-0.3-0.21.21.0null1.0
2025-01-06"AAPL""cusip9"0.10.51.11.01.0null
2025-01-07"GOOG""cusip9"-0.28-0.191.211.0null1.0
" ], "text/plain": [ "shape: (3, 9)\n", "┌───────────┬──────────┬───────────┬───────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_ ┆ style^mom ┆ … ┆ style^gro ┆ market^ma ┆ industry^ ┆ industry^ │\n", "│ --- ┆ --- ┆ type ┆ entum_6 ┆ ┆ wth ┆ rket ┆ consumer ┆ tech │\n", "│ date ┆ str ┆ --- ┆ --- ┆ ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ ┆ ┆ str ┆ f64 ┆ ┆ f64 ┆ f64 ┆ f64 ┆ f64 │\n", "╞═══════════╪══════════╪═══════════╪═══════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ 2025-01-0 ┆ GOOG ┆ cusip9 ┆ -0.3 ┆ … ┆ 1.2 ┆ 1.0 ┆ null ┆ 1.0 │\n", "│ 6 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "│ 2025-01-0 ┆ AAPL ┆ cusip9 ┆ 0.1 ┆ … ┆ 1.1 ┆ 1.0 ┆ 1.0 ┆ null │\n", "│ 6 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "│ 2025-01-0 ┆ GOOG ┆ cusip9 ┆ -0.28 ┆ … ┆ 1.21 ┆ 1.0 ┆ null ┆ 1.0 │\n", "│ 7 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "└───────────┴──────────┴───────────┴───────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "example_df = parser.get_examples()[0]\n", "example_df" ] }, { "cell_type": "markdown", "id": "a25e1caa", "metadata": {}, "source": [ "Before running the parser, we can check if the data can be successfully parsed with the `can_handle` method." ] }, { "cell_type": "code", "execution_count": 16, "id": "67d326a4", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadParserResult(parser='Wide-Format', success=True, messages=[])" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "parser.can_handle(example_df)" ] }, { "cell_type": "code", "execution_count": 17, "id": "2d77bdc5", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(shape: (15, 6)\n", " ┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬──────────┐\n", " │ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", " │ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", " │ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", " ╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪══════════╡\n", " │ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.3 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_6 ┆ 0.1 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.28 │\n", " │ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.2 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", " │ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ industry ┆ consumer ┆ 1.0 │\n", " │ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", " └────────────┴──────────┴───────────────┴──────────────┴─────────────┴──────────┘,\n", " UploadParserResult(parser='Wide-Format', success=True, messages=[]))" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "parser.parse(example_df)" ] }, { "cell_type": "markdown", "id": "e07b7ecf", "metadata": {}, "source": [ "## Staging Data\n", "\n", "*Staging* takes an input dataframe (or file), parses it, and keeps it in a separate area (stage). We can repeat this process of staging multiple times to stage multiple files (e.g. if we have daily files). The staging area can then be *committed* which concatenates all staged dataframes and writes them to versioned storage.\n", "\n", "### Adding to the Staging Area\n", "We use the example wide dataframe for staging. We define a name `example-1` to be able to tell the staged dataframes apart later on. We also specify a concrete parser we want to use. Note that the parser can be left blank in which case all available parsers will be tried and the first succeeding parser will be chosen." ] }, { "cell_type": "code", "execution_count": 18, "id": "5083e2d3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='example-1', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 38, 595139, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_df(name=\"example-1\", df=example_df, parser=\"Wide-Format\")" ] }, { "cell_type": "markdown", "id": "d154244c", "metadata": {}, "source": [ "Below we're adding a second dataframe for demonstration purposes. For this we use the existing example dataframe and roll the dates by one week." ] }, { "cell_type": "code", "execution_count": 19, "id": "8c7dfc72", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (3, 9)
dateasset_idasset_id_typestyle^momentum_6style^momentum_12style^growthmarket^marketindustry^consumerindustry^tech
datestrstrf64f64f64f64f64f64
2025-01-13"GOOG""cusip9"-0.3-0.21.21.0null1.0
2025-01-13"AAPL""cusip9"0.10.51.11.01.0null
2025-01-14"GOOG""cusip9"-0.28-0.191.211.0null1.0
" ], "text/plain": [ "shape: (3, 9)\n", "┌───────────┬──────────┬───────────┬───────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_ ┆ style^mom ┆ … ┆ style^gro ┆ market^ma ┆ industry^ ┆ industry^ │\n", "│ --- ┆ --- ┆ type ┆ entum_6 ┆ ┆ wth ┆ rket ┆ consumer ┆ tech │\n", "│ date ┆ str ┆ --- ┆ --- ┆ ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ ┆ ┆ str ┆ f64 ┆ ┆ f64 ┆ f64 ┆ f64 ┆ f64 │\n", "╞═══════════╪══════════╪═══════════╪═══════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ 2025-01-1 ┆ GOOG ┆ cusip9 ┆ -0.3 ┆ … ┆ 1.2 ┆ 1.0 ┆ null ┆ 1.0 │\n", "│ 3 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "│ 2025-01-1 ┆ AAPL ┆ cusip9 ┆ 0.1 ┆ … ┆ 1.1 ┆ 1.0 ┆ 1.0 ┆ null │\n", "│ 3 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "│ 2025-01-1 ┆ GOOG ┆ cusip9 ┆ -0.28 ┆ … ┆ 1.21 ┆ 1.0 ┆ null ┆ 1.0 │\n", "│ 4 ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │\n", "└───────────┴──────────┴───────────┴───────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "example_df2 = example_df.with_columns(pl.col(\"date\").dt.add_business_days(5))\n", "example_df2" ] }, { "cell_type": "code", "execution_count": 20, "id": "08bb16a1", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='example-2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 39, 132916, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# note that if we used the same name \"example-1\" this cell would fail\n", "dataset.stage_df(name=\"example-2\", df=example_df2, parser=\"Wide-Format\")" ] }, { "cell_type": "markdown", "id": "31909f0d", "metadata": {}, "source": [ "### Retrieving Staged Data\n", "\n", "Below we demonstrate how to obtain previously staged data. We can either obtain the staging results (as we saw above when calling the `stage_df` method) or the data itself." ] }, { "cell_type": "code", "execution_count": 21, "id": "5a1aeef4", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'example-1': UploadStagingResult(name='example-1', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 38, 595139, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])]),\n", " 'example-2': UploadStagingResult(name='example-2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 39, 132916, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])}" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_results()" ] }, { "cell_type": "code", "execution_count": 22, "id": "c5d44b2a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (30, 7)
_namedateasset_idasset_id_typefactor_groupfactorexposure
strdatestrstrstrstrf32
"example-2"2025-01-13"GOOG""cusip9""style""momentum_6"-0.3
"example-2"2025-01-13"GOOG""cusip9""style""momentum_12"-0.2
"example-2"2025-01-13"GOOG""cusip9""style""growth"1.2
"example-2"2025-01-13"GOOG""cusip9""market""market"1.0
"example-2"2025-01-13"GOOG""cusip9""industry""tech"1.0
…………………
"example-1"2025-01-07"GOOG""cusip9""style""momentum_6"-0.28
"example-1"2025-01-07"GOOG""cusip9""style""momentum_12"-0.19
"example-1"2025-01-07"GOOG""cusip9""style""growth"1.21
"example-1"2025-01-07"GOOG""cusip9""market""market"1.0
"example-1"2025-01-07"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (30, 7)\n", "┌───────────┬────────────┬──────────┬───────────────┬──────────────┬─────────────┬──────────┐\n", "│ _name ┆ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞═══════════╪════════════╪══════════╪═══════════════╪══════════════╪═════════════╪══════════╡\n", "│ example-2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.3 │\n", "│ example-2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.2 │\n", "│ example-2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.2 │\n", "│ example-2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example-2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.28 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.19 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.21 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└───────────┴────────────┴──────────┴───────────────┴──────────────┴─────────────┴──────────┘" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data().collect()" ] }, { "cell_type": "code", "execution_count": 23, "id": "96c0eefb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (15, 7)
_namedateasset_idasset_id_typefactor_groupfactorexposure
strdatestrstrstrstrf32
"example-1"2025-01-06"GOOG""cusip9""style""momentum_6"-0.3
"example-1"2025-01-06"GOOG""cusip9""style""momentum_12"-0.2
"example-1"2025-01-06"GOOG""cusip9""style""growth"1.2
"example-1"2025-01-06"GOOG""cusip9""market""market"1.0
"example-1"2025-01-06"GOOG""cusip9""industry""tech"1.0
…………………
"example-1"2025-01-07"GOOG""cusip9""style""momentum_6"-0.28
"example-1"2025-01-07"GOOG""cusip9""style""momentum_12"-0.19
"example-1"2025-01-07"GOOG""cusip9""style""growth"1.21
"example-1"2025-01-07"GOOG""cusip9""market""market"1.0
"example-1"2025-01-07"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (15, 7)\n", "┌───────────┬────────────┬──────────┬───────────────┬──────────────┬─────────────┬──────────┐\n", "│ _name ┆ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞═══════════╪════════════╪══════════╪═══════════════╪══════════════╪═════════════╪══════════╡\n", "│ example-1 ┆ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.3 │\n", "│ example-1 ┆ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.2 │\n", "│ example-1 ┆ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.2 │\n", "│ example-1 ┆ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example-1 ┆ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.28 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.19 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.21 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example-1 ┆ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└───────────┴────────────┴──────────┴───────────────┴──────────────┴─────────────┴──────────┘" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data(names=[\"example-1\"]).collect()" ] }, { "cell_type": "markdown", "id": "ac464b03", "metadata": {}, "source": [ "### Retrieving Summary Data\n", "\n", "We can also obtain predefined summary data for each staged file." ] }, { "cell_type": "code", "execution_count": 24, "id": "b872bc54", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (2, 11)
_namen_datesn_assetsmin_datemax_daten_factor_groupsn_factorsmin_exposuremax_exposuremean_exposurestd_exposure
stru32u32datedateu32u32f32f32f32f32
"example-1"222025-01-062025-01-0736-0.31.210.6093330.580189
"example-2"222025-01-132025-01-1436-0.31.210.6093330.580189
" ], "text/plain": [ "shape: (2, 11)\n", "┌───────────┬─────────┬──────────┬────────────┬───┬────────────┬───────────┬───────────┬───────────┐\n", "│ _name ┆ n_dates ┆ n_assets ┆ min_date ┆ … ┆ min_exposu ┆ max_expos ┆ mean_expo ┆ std_expos │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ ┆ re ┆ ure ┆ sure ┆ ure │\n", "│ str ┆ u32 ┆ u32 ┆ date ┆ ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ ┆ ┆ ┆ ┆ ┆ f32 ┆ f32 ┆ f32 ┆ f32 │\n", "╞═══════════╪═════════╪══════════╪════════════╪═══╪════════════╪═══════════╪═══════════╪═══════════╡\n", "│ example-1 ┆ 2 ┆ 2 ┆ 2025-01-06 ┆ … ┆ -0.3 ┆ 1.21 ┆ 0.609333 ┆ 0.580189 │\n", "│ example-2 ┆ 2 ┆ 2 ┆ 2025-01-13 ┆ … ┆ -0.3 ┆ 1.21 ┆ 0.609333 ┆ 0.580189 │\n", "└───────────┴─────────┴──────────┴────────────┴───┴────────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data_summary()" ] }, { "cell_type": "markdown", "id": "1ed2d387", "metadata": {}, "source": [ "Drilling down, we can obtain a more detailed summary as well." ] }, { "cell_type": "code", "execution_count": 25, "id": "011d2a77", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (4, 7)
_namedaten_assetsmin_exposuremax_exposuremean_exposurestd_exposure
strdateu32f32f32f32f32
"example-1"2025-01-062-0.31.20.640.542586
"example-1"2025-01-071-0.281.210.5480.644528
"example-2"2025-01-132-0.31.20.640.542586
"example-2"2025-01-141-0.281.210.5480.644528
" ], "text/plain": [ "shape: (4, 7)\n", "┌───────────┬────────────┬──────────┬──────────────┬──────────────┬───────────────┬──────────────┐\n", "│ _name ┆ date ┆ n_assets ┆ min_exposure ┆ max_exposure ┆ mean_exposure ┆ std_exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ u32 ┆ f32 ┆ f32 ┆ f32 ┆ f32 │\n", "╞═══════════╪════════════╪══════════╪══════════════╪══════════════╪═══════════════╪══════════════╡\n", "│ example-1 ┆ 2025-01-06 ┆ 2 ┆ -0.3 ┆ 1.2 ┆ 0.64 ┆ 0.542586 │\n", "│ example-1 ┆ 2025-01-07 ┆ 1 ┆ -0.28 ┆ 1.21 ┆ 0.548 ┆ 0.644528 │\n", "│ example-2 ┆ 2025-01-13 ┆ 2 ┆ -0.3 ┆ 1.2 ┆ 0.64 ┆ 0.542586 │\n", "│ example-2 ┆ 2025-01-14 ┆ 1 ┆ -0.28 ┆ 1.21 ┆ 0.548 ┆ 0.644528 │\n", "└───────────┴────────────┴──────────┴──────────────┴──────────────┴───────────────┴──────────────┘" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data_detail_summary()" ] }, { "cell_type": "markdown", "id": "88350fba", "metadata": {}, "source": [ "### Staging from a File\n", "\n", "Instead of passing a dataframe directly, we can also stage data from an existing `csv`, `csv.gz`, `parquet` or `zip` file.\n", "\n", "Below we'll demonstrate how to:\n", "\n", "1. Stage a file\n", "2. Obtain the staged data\n", "3. Remove the file from the staging area\n", "\n", "First, we define an output path where we will write our `example_df2` dataframe." ] }, { "cell_type": "code", "execution_count": 26, "id": "1a401fcd", "metadata": {}, "outputs": [], "source": [ "path = Path(tempfile.mkdtemp()) / \"example2.csv\"\n", "example_df2.write_csv(path)" ] }, { "cell_type": "markdown", "id": "30898258", "metadata": {}, "source": [ "We can then stage the output file with `stage_file`, retrieve back the data with `get_staging_data`, and wipe the staging area with `wipe_staging`." ] }, { "cell_type": "code", "execution_count": 27, "id": "6ad0c33d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='example2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 41, 821325, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_file(path, parser=\"Wide-Format\")" ] }, { "cell_type": "code", "execution_count": 28, "id": "b34b331c", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (15, 7)
_namedateasset_idasset_id_typefactor_groupfactorexposure
strdatestrstrstrstrf32
"example2"2025-01-13"GOOG""cusip9""style""momentum_6"-0.3
"example2"2025-01-13"GOOG""cusip9""style""momentum_12"-0.2
"example2"2025-01-13"GOOG""cusip9""style""growth"1.2
"example2"2025-01-13"GOOG""cusip9""market""market"1.0
"example2"2025-01-13"GOOG""cusip9""industry""tech"1.0
…………………
"example2"2025-01-14"GOOG""cusip9""style""momentum_6"-0.28
"example2"2025-01-14"GOOG""cusip9""style""momentum_12"-0.19
"example2"2025-01-14"GOOG""cusip9""style""growth"1.21
"example2"2025-01-14"GOOG""cusip9""market""market"1.0
"example2"2025-01-14"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (15, 7)\n", "┌──────────┬────────────┬──────────┬───────────────┬──────────────┬─────────────┬──────────┐\n", "│ _name ┆ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞══════════╪════════════╪══════════╪═══════════════╪══════════════╪═════════════╪══════════╡\n", "│ example2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.3 │\n", "│ example2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.2 │\n", "│ example2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.2 │\n", "│ example2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example2 ┆ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ example2 ┆ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.28 │\n", "│ example2 ┆ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.19 │\n", "│ example2 ┆ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.21 │\n", "│ example2 ┆ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ example2 ┆ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└──────────┴────────────┴──────────┴───────────────┴──────────────┴─────────────┴──────────┘" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data(names=[\"example2\"]).collect()" ] }, { "cell_type": "code", "execution_count": 29, "id": "9d6f3af3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'example2': UploadStagingResult(name='example2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 41, 821325, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])}" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.wipe_staging(names=[\"example2\"])" ] }, { "cell_type": "markdown", "id": "ab86e2d8", "metadata": {}, "source": [ "## Committing Data\n", "\n", "Once we're happy with the staged files, we can commit them into versioned storage. Versions are immutable so every commmit creates a new version, which allows for full time travel.\n", "\n", "When committing staged data, we need to choose a `mode` which defines how to write the data in the context of a versioned storage." ] }, { "cell_type": "code", "execution_count": 30, "id": "0911e8db", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'append': 'Appends data to the existing data, honoring primary key constraints. Primary keys that already existed will be ignored (not updated). The primary key is (date, asset_id, asset_id_type, factor_group, factor).',\n", " 'overwrite': 'Overwrites any existing data with the new data. If a primary key in the existing data is not present in the new data, it will be deleted. The primary key is (date, asset_id, asset_id_type, factor_group, factor).',\n", " 'append_from': 'Appends new records to the existing data but only after the last date in the existing data. Collisions will be ignored.',\n", " 'overwrite_from': 'Overwrites the entire dataset with the new data but only after the last date in the existing data.'}" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_commit_modes()" ] }, { "cell_type": "markdown", "id": "5d4b526e", "metadata": {}, "source": [ "We'll follow the steps below to demonstrate the commit and versioning process:\n", "\n", "1. Commit entire staging area.\n", "2. Show empty staging area (committed staged names are cleared from the staging area).\n", "3. Show version history.\n", "4. Get data at latest version.\n", "5. Re-stage the example-1 dataframe and commit in `append` mode.\n", "6. Re-stage the example-2 dataframe and commit in `append_from` mode.\n", "7. Get data at different versions.\n", "8. Using match columns to selectively append/overwrite data.\n", "\n", "We start by committing the entire staging area. When we do this, we see that the commit was created as version 1.\n" ] }, { "cell_type": "code", "execution_count": 31, "id": "574a4557", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=1, committed_names=['example-1', 'example-2'])" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.commit(mode=\"append\")" ] }, { "cell_type": "markdown", "id": "97cafc66", "metadata": {}, "source": [ "After committing, the staging area should now be empty." ] }, { "cell_type": "code", "execution_count": 32, "id": "9924aa2e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (0, 7)
_namedateasset_idasset_id_typefactor_groupfactorexposure
strdatestrstrstrstrf32
" ], "text/plain": [ "shape: (0, 7)\n", "┌───────┬──────┬──────────┬───────────────┬──────────────┬────────┬──────────┐\n", "│ _name ┆ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞═══════╪══════╪══════════╪═══════════════╪══════════════╪════════╪══════════╡\n", "└───────┴──────┴──────────┴───────────────┴──────────────┴────────┴──────────┘" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_staging_data().collect()" ] }, { "cell_type": "markdown", "id": "e40a69f3", "metadata": {}, "source": [ "We can get the list of all historical versions with the `version_history` method. We see below that there are 2 versions. Version 0 corresponds to the automatic creation of the dataset before it was overwritten with our commit changes in Version 1." ] }, { "cell_type": "code", "execution_count": 33, "id": "fccc4af3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{1: datetime.datetime(2026, 9, 8, 13, 32, 43, 45712, tzinfo=datetime.timezone.utc),\n", " 0: datetime.datetime(2026, 9, 8, 13, 32, 37, 848165, tzinfo=datetime.timezone.utc)}" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.version_history()" ] }, { "cell_type": "code", "execution_count": 34, "id": "a68b4604", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (30, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
………………
2025-01-14"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-14"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-14"GOOG""cusip9""style""growth"1.209961
2025-01-14"GOOG""cusip9""market""market"1.0
2025-01-14"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (30, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-14 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data().collect()" ] }, { "cell_type": "markdown", "id": "6c158916", "metadata": {}, "source": [ "Below we will append some more data to demonstrate the versioning." ] }, { "cell_type": "code", "execution_count": 35, "id": "b8c8a695", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='example-1', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 45, 24697, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_df(\n", " \"example-1\",\n", " example_df.with_columns(pl.col(\"date\").dt.add_business_days(10)),\n", " parser=\"Wide-Format\",\n", ")" ] }, { "cell_type": "code", "execution_count": 36, "id": "70a22fe7", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=2, committed_names=['example-1'])" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.commit(mode=\"append\")" ] }, { "cell_type": "code", "execution_count": 37, "id": "37bdd961", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{2: datetime.datetime(2026, 9, 8, 13, 32, 45, 710180, tzinfo=datetime.timezone.utc),\n", " 1: datetime.datetime(2026, 9, 8, 13, 32, 43, 45712, tzinfo=datetime.timezone.utc),\n", " 0: datetime.datetime(2026, 9, 8, 13, 32, 37, 848165, tzinfo=datetime.timezone.utc)}" ] }, "execution_count": 37, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.version_history()" ] }, { "cell_type": "code", "execution_count": 38, "id": "a2a5049f", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='example-2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 46, 599570, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_df(\n", " \"example-2\",\n", " example_df2.with_columns(pl.col(\"date\").dt.add_business_days(10)),\n", " parser=\"Wide-Format\",\n", ")" ] }, { "cell_type": "code", "execution_count": 39, "id": "afc08dee", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=3, committed_names=['example-2'])" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.commit(mode=\"append_from\")" ] }, { "cell_type": "code", "execution_count": 40, "id": "67c95523", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{3: datetime.datetime(2026, 9, 8, 13, 32, 47, 386740, tzinfo=datetime.timezone.utc),\n", " 2: datetime.datetime(2026, 9, 8, 13, 32, 45, 710180, tzinfo=datetime.timezone.utc),\n", " 1: datetime.datetime(2026, 9, 8, 13, 32, 43, 45712, tzinfo=datetime.timezone.utc),\n", " 0: datetime.datetime(2026, 9, 8, 13, 32, 37, 848165, tzinfo=datetime.timezone.utc)}" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.version_history()" ] }, { "cell_type": "code", "execution_count": 41, "id": "32623d84", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (60, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
………………
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (60, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# both example-1 and example-2 at this version\n", "dataset.get_data(version=3).collect()" ] }, { "cell_type": "code", "execution_count": 42, "id": "ca40b878", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (45, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
………………
2025-01-21"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-21"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-21"GOOG""cusip9""style""growth"1.209961
2025-01-21"GOOG""cusip9""market""market"1.0
2025-01-21"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (45, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 42, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# only example-1 at this version\n", "dataset.get_data(version=2).collect()" ] }, { "cell_type": "markdown", "id": "5e400d10", "metadata": {}, "source": [ "Note that if we append data that already exists as identified by their primary key (i.e. there is no data to append), then no new version will be recorded." ] }, { "cell_type": "code", "execution_count": 43, "id": "24ec0441", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadStagingResult(name='no-new-data', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 49, 244401, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])" ] }, "execution_count": 43, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_df(\"no-new-data\", example_df)" ] }, { "cell_type": "code", "execution_count": 44, "id": "f303c3d9", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=3, committed_names=['no-new-data'])" ] }, "execution_count": 44, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.commit(mode=\"append\")" ] }, { "cell_type": "code", "execution_count": 45, "id": "727b7cb0", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{3: datetime.datetime(2026, 9, 8, 13, 32, 47, 386740, tzinfo=datetime.timezone.utc),\n", " 2: datetime.datetime(2026, 9, 8, 13, 32, 45, 710180, tzinfo=datetime.timezone.utc),\n", " 1: datetime.datetime(2026, 9, 8, 13, 32, 43, 45712, tzinfo=datetime.timezone.utc),\n", " 0: datetime.datetime(2026, 9, 8, 13, 32, 37, 848165, tzinfo=datetime.timezone.utc)}" ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.version_history()" ] }, { "cell_type": "markdown", "id": "2626cf2b", "metadata": {}, "source": [ "### Selective Overwrites and Appends\n", "\n", "A common research workflow is to iterate over factor definitions and replace an entire factor that was already uploaded. To that end the `overwrite` or `append` modes fall short, as they act on the entire existing dataset including all existing factors. \n", "\n", "We use the concept of `match_columns` to narrow the scope of the `overwrite` and `append` modes. For example. if we specify `mode='overwrite'` and `match_columns=['factor']`, only factors incoming into the upload will be affected in the `overwrite` or `append`. \n", "\n", "We'll demonstrate this below by changing the definition of the `momentum_12` factor and introducing a new factor `abc`." ] }, { "cell_type": "code", "execution_count": 46, "id": "d7be60b0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (12, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"AAPL""cusip9""style""momentum_12"0.5
2025-01-07"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-13"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-13"AAPL""cusip9""style""momentum_12"0.5
………………
2025-01-20"AAPL""cusip9""style""momentum_12"0.5
2025-01-21"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-27"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-27"AAPL""cusip9""style""momentum_12"0.5
2025-01-28"GOOG""cusip9""style""momentum_12"-0.189941
" ], "text/plain": [ "shape: (12, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-13 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-20 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-27 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-27 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = dataset.get_data(filters=[[\"factor\", \"=\", \"momentum_12\"]]).collect()\n", "\n", "df" ] }, { "cell_type": "markdown", "id": "44a3b04b", "metadata": {}, "source": [ "We're only taking the top 5 rows of the `momentum_12` factor and inventing a single record for the `abc` factor." ] }, { "cell_type": "code", "execution_count": 47, "id": "1795aef3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (6, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"AAPL""cusip9""style""momentum_12"0.5
2025-01-07"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-13"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-13"AAPL""cusip9""style""momentum_12"0.5
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (6, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-13 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "new_records = pl.concat([\n", " df.head(5),\n", " df.tail(1).with_columns(pl.lit(\"abc\").alias(\"factor\"))\n", "])\n", "\n", "new_records" ] }, { "cell_type": "code", "execution_count": 48, "id": "772a0918", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=4, committed_names=[])" ] }, "execution_count": 48, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.fast_commit(new_records, mode=\"overwrite\", match_columns=[\"factor\"])" ] }, { "cell_type": "code", "execution_count": 49, "id": "6b972347", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (6, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"AAPL""cusip9""style""momentum_12"0.5
2025-01-07"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-13"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-13"AAPL""cusip9""style""momentum_12"0.5
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (6, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-13 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 0.5 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 49, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(filters=[[\"factor\", \"IN\", [\"momentum_12\", \"abc\"]]]).collect()" ] }, { "cell_type": "markdown", "id": "e5f46f2c", "metadata": {}, "source": [ "Confirming that the rest of the data is unmodified." ] }, { "cell_type": "code", "execution_count": 50, "id": "96c8558c", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (48, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
2025-01-06"AAPL""cusip9""style""momentum_6"0.099976
………………
2025-01-27"AAPL""cusip9""industry""consumer"1.0
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (48, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_6 ┆ 0.099976 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-27 ┆ AAPL ┆ cusip9 ┆ industry ┆ consumer ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴────────────┴───────────┘" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(filters=[[\"factor\", \"NOT IN\", [\"momentum_12\", \"abc\"]]]).collect()" ] }, { "cell_type": "code", "execution_count": 51, "id": "bb28b0d0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (48, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
2025-01-06"AAPL""cusip9""style""momentum_6"0.099976
………………
2025-01-27"AAPL""cusip9""industry""consumer"1.0
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (48, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_6 ┆ 0.099976 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-27 ┆ AAPL ┆ cusip9 ┆ industry ┆ consumer ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴────────────┴───────────┘" ] }, "execution_count": 51, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(filters=[[\"factor\", \"NOT IN\", [\"momentum_12\", \"abc\"]]], version=3).collect()" ] }, { "cell_type": "markdown", "id": "8d8a0be7", "metadata": {}, "source": [ "### Retrieving Summary Data\n", "\n", "Similar to the summary data we could obtain for the staging data, we can do the same for the committed data (at different versions)." ] }, { "cell_type": "code", "execution_count": 52, "id": "c510e2cc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (1, 10)
n_datesn_assetsmin_datemax_daten_factor_groupsn_factorsmin_exposuremax_exposuremean_exposurestd_exposure
u32u32datedateu32u32f32f32f32f32
822025-01-062025-01-2837-19948.015575.07356.81494114384.52832
" ], "text/plain": [ "shape: (1, 10)\n", "┌─────────┬──────────┬────────────┬────────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ n_dates ┆ n_assets ┆ min_date ┆ max_date ┆ … ┆ min_expos ┆ max_expos ┆ mean_expo ┆ std_expos │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ ┆ ure ┆ ure ┆ sure ┆ ure │\n", "│ u32 ┆ u32 ┆ date ┆ date ┆ ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ ┆ ┆ ┆ ┆ ┆ f32 ┆ f32 ┆ f32 ┆ f32 │\n", "╞═════════╪══════════╪════════════╪════════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ 8 ┆ 2 ┆ 2025-01-06 ┆ 2025-01-28 ┆ … ┆ -19948.0 ┆ 15575.0 ┆ 7356.8149 ┆ 14384.528 │\n", "│ ┆ ┆ ┆ ┆ ┆ ┆ ┆ 41 ┆ 32 │\n", "└─────────┴──────────┴────────────┴────────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 52, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data_summary()" ] }, { "cell_type": "code", "execution_count": 53, "id": "08411fff", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (1, 10)
n_datesn_assetsmin_datemax_daten_factor_groupsn_factorsmin_exposuremax_exposuremean_exposurestd_exposure
u32u32datedateu32u32f32f32f32f32
622025-01-062025-01-2136-19948.015575.05771.86669915326.09668
" ], "text/plain": [ "shape: (1, 10)\n", "┌─────────┬──────────┬────────────┬────────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ n_dates ┆ n_assets ┆ min_date ┆ max_date ┆ … ┆ min_expos ┆ max_expos ┆ mean_expo ┆ std_expos │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ ┆ ure ┆ ure ┆ sure ┆ ure │\n", "│ u32 ┆ u32 ┆ date ┆ date ┆ ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ ┆ ┆ ┆ ┆ ┆ f32 ┆ f32 ┆ f32 ┆ f32 │\n", "╞═════════╪══════════╪════════════╪════════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ 6 ┆ 2 ┆ 2025-01-06 ┆ 2025-01-21 ┆ … ┆ -19948.0 ┆ 15575.0 ┆ 5771.8666 ┆ 15326.096 │\n", "│ ┆ ┆ ┆ ┆ ┆ ┆ ┆ 99 ┆ 68 │\n", "└─────────┴──────────┴────────────┴────────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data_summary(version=2)" ] }, { "cell_type": "code", "execution_count": 54, "id": "c1c590f2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (8, 6)
daten_assetsmin_exposuremax_exposuremean_exposurestd_exposure
datei64f32f32f64f64
2025-01-062-0.3000491.2001950.6399780.542577
2025-01-071-0.2800291.2099610.5479980.644514
2025-01-132-0.3000491.2001950.6399780.542577
2025-01-141-0.2800291.2099610.7324830.590825
2025-01-202-0.3000491.2001950.7624660.5122
2025-01-211-0.2800291.2099610.7324830.590825
2025-01-272-0.3000491.2001950.7624660.5122
2025-01-281-0.2800291.2099610.5479980.644514
" ], "text/plain": [ "shape: (8, 6)\n", "┌────────────┬──────────┬──────────────┬──────────────┬───────────────┬──────────────┐\n", "│ date ┆ n_assets ┆ min_exposure ┆ max_exposure ┆ mean_exposure ┆ std_exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ i64 ┆ f32 ┆ f32 ┆ f64 ┆ f64 │\n", "╞════════════╪══════════╪══════════════╪══════════════╪═══════════════╪══════════════╡\n", "│ 2025-01-06 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.639978 ┆ 0.542577 │\n", "│ 2025-01-07 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.547998 ┆ 0.644514 │\n", "│ 2025-01-13 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.639978 ┆ 0.542577 │\n", "│ 2025-01-14 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.732483 ┆ 0.590825 │\n", "│ 2025-01-20 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.762466 ┆ 0.5122 │\n", "│ 2025-01-21 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.732483 ┆ 0.590825 │\n", "│ 2025-01-27 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.762466 ┆ 0.5122 │\n", "│ 2025-01-28 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.547998 ┆ 0.644514 │\n", "└────────────┴──────────┴──────────────┴──────────────┴───────────────┴──────────────┘" ] }, "execution_count": 54, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data_detail_summary()" ] }, { "cell_type": "code", "execution_count": 55, "id": "02ac63f3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (6, 6)
daten_assetsmin_exposuremax_exposuremean_exposurestd_exposure
datei64f32f32f64f64
2025-01-062-0.3000491.2001950.6399780.542577
2025-01-071-0.2800291.2099610.5479980.644514
2025-01-132-0.3000491.2001950.6399780.542577
2025-01-141-0.2800291.2099610.5479980.644514
2025-01-202-0.3000491.2001950.6399780.542577
2025-01-211-0.2800291.2099610.5479980.644514
" ], "text/plain": [ "shape: (6, 6)\n", "┌────────────┬──────────┬──────────────┬──────────────┬───────────────┬──────────────┐\n", "│ date ┆ n_assets ┆ min_exposure ┆ max_exposure ┆ mean_exposure ┆ std_exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ i64 ┆ f32 ┆ f32 ┆ f64 ┆ f64 │\n", "╞════════════╪══════════╪══════════════╪══════════════╪═══════════════╪══════════════╡\n", "│ 2025-01-06 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.639978 ┆ 0.542577 │\n", "│ 2025-01-07 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.547998 ┆ 0.644514 │\n", "│ 2025-01-13 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.639978 ┆ 0.542577 │\n", "│ 2025-01-14 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.547998 ┆ 0.644514 │\n", "│ 2025-01-20 ┆ 2 ┆ -0.300049 ┆ 1.200195 ┆ 0.639978 ┆ 0.542577 │\n", "│ 2025-01-21 ┆ 1 ┆ -0.280029 ┆ 1.209961 ┆ 0.547998 ┆ 0.644514 │\n", "└────────────┴──────────┴──────────────┴──────────────┴───────────────┴──────────────┘" ] }, "execution_count": 55, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data_detail_summary(version=2)" ] }, { "cell_type": "markdown", "id": "5b650c6c", "metadata": {}, "source": [ "### Validating Staging Data\n", "\n", "When staging multiple files, it's possible that their combined contents may not be valid and so cannot be committed. For example, if the files introduce duplicate entries, the `commit` method will fail.\n", "\n", "The example below illustrates how to validate the staging area before committing. To simulate a validation failure, we intentionally stage the same example dataframe twice, resulting in duplicate records." ] }, { "cell_type": "code", "execution_count": 56, "id": "c9d429ec", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'example-1': UploadStagingResult(name='example-1', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 56, 118937, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])]),\n", " 'example-2': UploadStagingResult(name='example-2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 56, 644574, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])}" ] }, "execution_count": 56, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.stage_df(\"example-1\", example_df, parser=\"Wide-Format\")\n", "dataset.stage_df(\"example-2\", example_df, parser=\"Wide-Format\")\n", "\n", "dataset.get_staging_results()" ] }, { "cell_type": "markdown", "id": "7fe3cb5c", "metadata": {}, "source": [ "The validation check below will produce **non-empty** dataframes if any validation errors occurred. In this case, it produces the duplicated records together with a `_name` column which indicates the names of the staged dataframes that introduced the duplication." ] }, { "cell_type": "code", "execution_count": 57, "id": "087a3cd4", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'Duplication Check': shape: (15, 7)\n", " ┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬─────────┬────────────┐\n", " │ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ n_dupes ┆ _name │\n", " │ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", " │ date ┆ str ┆ str ┆ str ┆ str ┆ u32 ┆ str │\n", " ╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═════════╪════════════╡\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ industry ┆ consumer ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ market ┆ market ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ growth ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_12 ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-06 ┆ AAPL ┆ cusip9 ┆ style ┆ momentum_6 ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " │ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ 2 ┆ example-2, │\n", " │ ┆ ┆ ┆ ┆ ┆ ┆ example-1 │\n", " └────────────┴──────────┴───────────────┴──────────────┴─────────────┴─────────┴────────────┘}" ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.validate_staging_data()" ] }, { "cell_type": "code", "execution_count": 58, "id": "c4a21ca2", "metadata": {}, "outputs": [], "source": [ "# this call would fail with: `UploadError: Staging data fails validation checks.`\n", "# dataset.commit(mode=\"append\")" ] }, { "cell_type": "markdown", "id": "521b0487", "metadata": {}, "source": [ "To resolve this error, we can delete one of the erroneously staged dataframes, after which the validation will produce an empty dataframe, indicating successful validation." ] }, { "cell_type": "code", "execution_count": 59, "id": "16493851", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'example-2': UploadStagingResult(name='example-2', timestamp=datetime.datetime(2026, 9, 8, 13, 32, 56, 644574, tzinfo=TzInfo(0)), success=True, results=[UploadParserResult(parser='Wide-Format', success=True, messages=[])])}" ] }, "execution_count": 59, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.wipe_staging(names=[\"example-2\"])" ] }, { "cell_type": "code", "execution_count": 60, "id": "0535a69a", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{}" ] }, "execution_count": 60, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.validate_staging_data()" ] }, { "cell_type": "markdown", "id": "a3f71d09", "metadata": {}, "source": [ "## Fast Commit\n", "\n", "We can skip the staging process and commit a dataframe straight into versioned storage as demonstrated below." ] }, { "cell_type": "code", "execution_count": 61, "id": "1eb2337f", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=4, committed_names=[])" ] }, "execution_count": 61, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.fast_commit(example_df, mode=\"append\", parser=\"Wide-Format\")" ] }, { "cell_type": "markdown", "id": "f789fa18", "metadata": {}, "source": [ "## Filtering Data\n", "\n", "`get_data` allows us to obtain committed data at different versions. We can further add filters and column selectors to minimize the payload that has to travel across the network.\n", "\n", "Filters follow a disjunctive normal form as outlined in the `filters` section of the [PyArrow Documentation](https://arrow.apache.org/docs/python/generated/pyarrow.parquet.ParquetDataset.html).\n", "That is, we specify triples of `(column_name, operator, value)` to express a filter. A list of such triples will create an *AND* expression, whereas a nested list of triples will create *AND* expressions on the inner lists and *OR* expressions on the outer.\n", "\n", "Examples:\n", "* `[(\"date\", \">=\", \"2025-01-15\"), (\"asset_id\", \"=\", \"GOOG\")]` produces `date >= 2025-01-15 AND asset_id = GOOG`.\n", "* `[[(\"date\", \">=\", \"2025-01-15\"), (\"asset_id\", \"=\", \"GOOG\")], [(\"exposure\", \"<\", 0)]]` produces `(date >= 2025-01-15 AND asset_id = GOOG) OR (exposure < 0)`" ] }, { "cell_type": "code", "execution_count": 62, "id": "bbf610a7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (5, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
" ], "text/plain": [ "shape: (5, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 62, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(head=5).collect()" ] }, { "cell_type": "code", "execution_count": 63, "id": "e9863054", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (17, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-27"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-27"GOOG""cusip9""style""growth"1.200195
2025-01-27"GOOG""cusip9""market""market"1.0
2025-01-27"GOOG""cusip9""industry""tech"1.0
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
………………
2025-01-21"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-21"GOOG""cusip9""style""growth"1.209961
2025-01-21"GOOG""cusip9""market""market"1.0
2025-01-21"GOOG""cusip9""industry""tech"1.0
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (17, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪════════════╪═══════════╡\n", "│ 2025-01-27 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-27 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-27 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-27 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-21 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴────────────┴───────────┘" ] }, "execution_count": 63, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(\n", " filters=[(\"date\", \">=\", \"2025-01-15\"), (\"asset_id\", \"=\", \"GOOG\")]\n", ").collect()" ] }, { "cell_type": "code", "execution_count": 64, "id": "6daa070d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (24, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-07"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-07"GOOG""cusip9""style""momentum_12"-0.189941
2025-01-13"GOOG""cusip9""style""momentum_6"-0.300049
………………
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (24, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-07 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.189941 │\n", "│ 2025-01-13 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 64, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(\n", " filters=[\n", " [(\"date\", \">=\", \"2025-01-15\"), (\"asset_id\", \"=\", \"GOOG\")],\n", " [(\"exposure\", \"<\", 0)],\n", " ]\n", ").collect()" ] }, { "cell_type": "markdown", "id": "0bf3bcd4", "metadata": {}, "source": [ "We can also add the parameters `columns` and `unique`. For instance, to obtain a list of all assets (by asset id type) covered in this upload we would run below." ] }, { "cell_type": "code", "execution_count": 65, "id": "804d8f91", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (2, 2)
asset_idasset_id_type
strstr
"GOOG""cusip9"
"AAPL""cusip9"
" ], "text/plain": [ "shape: (2, 2)\n", "┌──────────┬───────────────┐\n", "│ asset_id ┆ asset_id_type │\n", "│ --- ┆ --- │\n", "│ str ┆ str │\n", "╞══════════╪═══════════════╡\n", "│ GOOG ┆ cusip9 │\n", "│ AAPL ┆ cusip9 │\n", "└──────────┴───────────────┘" ] }, "execution_count": 65, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.get_data(columns=[\"asset_id\", \"asset_id_type\"], unique=True).collect()" ] }, { "cell_type": "markdown", "id": "cdb3aa3a", "metadata": {}, "source": [ "## Downloading Data\n", "\n", "For very large datasets it could become prohibitive to download the entire dataset into memory. For that purpose we can stream the data into a flat file and then use Polars' lazy capabilities to read it." ] }, { "cell_type": "code", "execution_count": 66, "id": "0a6f1b15", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[]" ] }, "execution_count": 66, "metadata": {}, "output_type": "execute_result" } ], "source": [ "out_dir = Path(tempfile.mkdtemp())\n", "list(out_dir.iterdir())" ] }, { "cell_type": "code", "execution_count": 67, "id": "5bc75bb7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (54, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
………………
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (54, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 67, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = dataset.get_data(download_to=out_dir)\n", "\n", "# this dataframe is reading from the flat files that were downloaded to the out_dir\n", "df.collect()" ] }, { "cell_type": "code", "execution_count": 68, "id": "0e7ee3f2", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[PosixPath('/tmp/tmpro2_1kcx/data-0.parquet')]" ] }, "execution_count": 68, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list(out_dir.iterdir())" ] }, { "cell_type": "code", "execution_count": 69, "id": "a7b344c4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (54, 6)
dateasset_idasset_id_typefactor_groupfactorexposure
datestrstrstrstrf32
2025-01-06"GOOG""cusip9""style""momentum_6"-0.300049
2025-01-06"GOOG""cusip9""style""momentum_12"-0.199951
2025-01-06"GOOG""cusip9""style""growth"1.200195
2025-01-06"GOOG""cusip9""market""market"1.0
2025-01-06"GOOG""cusip9""industry""tech"1.0
………………
2025-01-28"GOOG""cusip9""style""momentum_6"-0.280029
2025-01-28"GOOG""cusip9""style""growth"1.209961
2025-01-28"GOOG""cusip9""market""market"1.0
2025-01-28"GOOG""cusip9""industry""tech"1.0
2025-01-28"GOOG""cusip9""style""abc"-0.189941
" ], "text/plain": [ "shape: (54, 6)\n", "┌────────────┬──────────┬───────────────┬──────────────┬─────────────┬───────────┐\n", "│ date ┆ asset_id ┆ asset_id_type ┆ factor_group ┆ factor ┆ exposure │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪══════════╪═══════════════╪══════════════╪═════════════╪═══════════╡\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.300049 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_12 ┆ -0.199951 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.200195 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-06 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ momentum_6 ┆ -0.280029 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ growth ┆ 1.209961 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ market ┆ market ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ industry ┆ tech ┆ 1.0 │\n", "│ 2025-01-28 ┆ GOOG ┆ cusip9 ┆ style ┆ abc ┆ -0.189941 │\n", "└────────────┴──────────┴───────────────┴──────────────┴─────────────┴───────────┘" ] }, "execution_count": 69, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pl.scan_parquet(out_dir).collect()" ] }, { "cell_type": "markdown", "id": "ba163c6c", "metadata": {}, "source": [ "## Housekeeping\n", "\n", "To delete a dataset entirely we can call its `destroy` method. Warning: This cannot be undone, so exercise caution when deleting datasets." ] }, { "cell_type": "code", "execution_count": 70, "id": "b7be2aca", "metadata": {}, "outputs": [], "source": [ "dataset.destroy()" ] } ], "metadata": { "jupytext": { "text_representation": { "extension": ".py", "format_name": "percent", "format_version": "1.3", "jupytext_version": "1.19.3" } }, "kernelspec": { "display_name": ".venv", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.15" } }, "nbformat": 4, "nbformat_minor": 5 }