> For the complete documentation index, see [llms.txt](https://docs.glassnode.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.glassnode.com/integrations-and-tools/static-files.md).

# Static Files

{% hint style="warning" %}
**Beta Feature**: Static file delivery is currently in beta. Coverage, file layout, and delivery options may change as we expand this feature. [Contact our team](mailto:sales@glassnode.com) to discuss your requirements.
{% endhint %}

Glassnode can deliver its metrics data as static files in [Apache Parquet](https://parquet.apache.org/) format. Files are generated daily and delivered to a cloud storage bucket, so you can load the data into your data lake, warehouse, or analytics tools.

Static file delivery gives you full-history datasets and daily updates without building an API client or maintaining an ingestion pipeline. It is also an option if you don't use Snowflake or BigQuery.

## Why Parquet?

Parquet is an open, columnar file format that is widely supported across the modern data ecosystem:

* **Efficient**: Columnar storage and compression keep files small and queries fast.
* **Typed**: Column types are stored in the file, so no schema inference is needed.
* **Interoperable**: Parquet can be read by tools such as DuckDB, Apache Spark, Pandas, Polars, Trino, Databricks, Snowflake, BigQuery, Amazon Athena, and many more.
* **Vendor-independent**: You are not tied to any specific warehouse or cloud provider.

## How It Works

1. **Choose a delivery method**: Files are delivered either to a Glassnode-managed bucket or directly to a bucket you own (see [Delivery Options](#delivery-options)).
2. **Receive daily files**: We generate new Parquet files every day and deliver them to the agreed location.
3. **Consume the data**: Read the files with your preferred tools or load them into your own data platform.

## Delivery Options

You can choose between two delivery methods.

### Option A: Glassnode-Managed Bucket

We publish the files to a Glassnode-managed distribution bucket and give you read access.

* **Quick onboarding**: No infrastructure setup needed on your side.
* **Consistent file layout**: The same structure and naming conventions for every delivery.
* **Secure access**: Access is limited to your organization's location.
* **Pull at your own pace**: Download or sync the files whenever you need them.

### Option B: Your Own Bucket

We write the files directly into a cloud storage bucket that you own and control.

* **Data lands in your infrastructure**: Files are close to your own compute and analytics tools.
* **You stay in control**: You manage retention, lifecycle rules, and downstream access.
* **No extra transfer step**: No need to copy data from an external location.

{% hint style="info" %}
Support for other storage providers and regions can be discussed on request.
{% endhint %}

## Data Format

The Parquet files use the same schema conventions as our [Snowflake](https://docs.glassnode.com/integrations-and-tools/data-sharing.md#metrics-schema) and [BigQuery](https://docs.glassnode.com/integrations-and-tools/bigquery-data-sharing.md#metrics-schema) data shares, so you can use the same logic across delivery channels.

Each metric dataset contains three types of fields:

1. **Timestamp Field**
   * Always named `TIMESTAMP`
   * Represents the time of the data point
2. **Filter Fields**
   * Used to segment and filter data
   * Follow the same naming convention as query parameters in our API
   * Common filter fields include:
     * `A` - Asset (e.g., BTC, ETH)
     * `NETWORK` - Network
     * Additional filters vary by metric
3. **Value Fields**
   * Contain the actual metric measurements
   * Always prefixed with `V_` for metrics with multiple values
   * Single-value metrics use just `V` (without underscore)

### Example

Reading a delivered file with [DuckDB](https://duckdb.org/):

```sql
SELECT
  TIMESTAMP,
  A,
  V
FROM read_parquet('s3://your-bucket/glassnode/addresses__active_count_1month/*.parquet')
WHERE A = 'BTC'
ORDER BY TIMESTAMP DESC
LIMIT 100;
```

{% hint style="info" %}
The exact file paths and folder layout are shared with you during onboarding.
{% endhint %}

## Delivery Frequency

Files are generated and delivered **once per day**. If you need a different schedule, please contact our team.

## Getting Started

To request access to static file delivery, email us at <sales@glassnode.com> or contact your account representative. Please include:

* The metrics, assets, and resolutions you are interested in
* Your preferred delivery option (Glassnode-managed bucket or your own bucket)
* If you want delivery to your own bucket: the cloud provider and region of the bucket

{% hint style="info" %}
**Ready to get started?** Email <sales@glassnode.com> to learn more about static file delivery.
{% endhint %}
