economic-data-project/dbt_project/models/agents_preprocess/schema.yml at 274818619f8554569e0463c47c40149f3ddc7657 · C00ldudeNoonan/economic-data-project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
version: 2

models:
  - name: agent_market_performance
    description: >
      Union of market summary models (us_sector, major_indicies, sp500, nasdaq)
      with standardized column names for agent consumption.
    columns:
      - name: symbol
        tests:
          - not_null
      - name: time_period
        tests:
          - not_null
          - accepted_values:
              arguments:
                values: ['12_weeks', '6_months', '1_year', '5_years']
      - name: market_category
        tests:
          - not_null
          - accepted_values:
              arguments:
                values: ['sector', 'major_index']

  - name: agent_commodity_performance
    description: >
      Union of commodity summary models (energy, agriculture, input)
      with standardized column names for agent consumption.
    columns:
      - name: commodity_name
        tests:
          - not_null
      - name: time_period
        tests:
          - not_null
          - accepted_values:
              arguments:
                values: ['12_weeks', '6_months', '1_year', '5_years']
      - name: commodity_category
        tests:
          - not_null
          - accepted_values:
              arguments:
                values: ['energy', 'agriculture', 'input']

  - name: agent_fred_series_latest_aggregates
    description: "Passthrough of fred_series_latest_aggregates for agent consumption"
    columns:
      - name: series_code
        tests:
          - not_null

  - name: agent_leading_econ_return_indicator
    description: "Passthrough of leading_econ_return_indicator for agent consumption"
    columns:
      - name: symbol
        tests:
          - not_null

  - name: agent_financial_conditions_index
    description: "Financial conditions index data for agent consumption"

  - name: agent_fred_monthly_diff
    description: "FRED monthly differences for agent consumption"

  - name: agent_housing_inventory_latest_aggregates
    description: "Housing inventory aggregates for agent consumption"

  - name: agent_housing_mortgage_rates
    description: "Housing mortgage rates for agent consumption"

  - name: agent_reddit_posts_daily
    description: "Daily Reddit post aggregates for agent consumption"

  - name: agent_reddit_sentiment_trends
    description: "Reddit sentiment trends for agent consumption"

  - name: agent_fred_series_latest_aggregates_snapshot
    description: "Snapshot view of FRED aggregates for agent consumption"

  - name: agent_leading_econ_return_indicator_snapshot
    description: "Snapshot view of leading economic return indicator for agent consumption"

  - name: agent_market_performance_snapshot
    description: "Incremental snapshot of market performance for agent consumption"

  - name: agent_commodity_performance_snapshot
    description: "Incremental snapshot of commodity performance for agent consumption"

  - name: agent_treasury_yield_curve_spreads
    description: "Incremental treasury yield curve spreads for agent consumption"
    tests:
      - unique_combination:
          arguments:
            combination_of_columns: ['date']
    columns:
      - name: date
        description: Treasury yield observation date.
        tests:
          - not_null
      - name: yield_3m
        description: Three-month Treasury yield.
      - name: yield_2y
        description: Two-year Treasury yield.
      - name: yield_10y
        description: Ten-year Treasury yield.
      - name: spread_10y_2y
        description: Ten-year minus two-year Treasury yield spread.
      - name: spread_10y_3m
        description: Ten-year minus three-month Treasury yield spread.
      - name: curve_shape
        description: Yield curve shape classification.
        tests:
          - accepted_values:
              arguments:
                values: ['Steep', 'Normal', 'Flat', 'Inverted']
      - name: inversion_status
        description: Yield curve inversion status.
        tests:
          - accepted_values:
              arguments:
                values: ['Normal', 'Inverted', 'Inverted (10Y-3M)']