Assets by Currency

Purpose

Provide a currency-level aggregation of asset values, collapsing individual assets into total amounts per currency and time period.

This model is designed as a lightweight reporting layer, enabling:

• Currency exposure analysis
• Net worth calculations per currency
• Downstream currency conversion using reporting rates

It removes asset-level granularity while preserving temporal and currency dimensions.

Business Logic

• Start from Assets Values transformation
• Group asset values by:
  • Date
  • ISO week
  • Currency
• Aggregate asset amounts using SUM
• Produce one row per currency per date

Output Contract

Definitions

Sample & Implementation

{{config(materialized='view')}}

with assets_values as (
    select * from {{ref('assets_values')}}
)

select
    date,
    weeknum,
    currency,
    sum(amount) as total_amount
from assets_values
group by date, weeknum, currency
order by weeknum

Dependencies

• Transformations: Assets Values