Skip to content

Reference

Reference data

Source Directory

macroeconomic_indices

Macroeconomic Indices

reference.macroeconomic_indices

Historical stock index and foreign exchange data pulled daily from https://site.financialmodelingprep.com/ Specifically, we pull - ^DJI (Dow Jones Industrial Average) - ^GSPC (SNP - SNP Real Time Price. Currency in USD) - ^IXIC (Nasdaq GIDS - Nasdaq GIDS Real Time Price. Currency in USD) - EURUSD=X (Euro to USD exchange rate) - GBPUSD=X (GB pound to USD exchange rate) We have a FinancialModelingPrep account that allows us to use this data for internal use. Contact the Search and Revenue team and/or the owners of this table for more information

Schema
Column Description Type Nullable
symbol String Yes
market_date Date Yes
open Numeric Yes
close Numeric Yes
adj_close Numeric Yes
high Numeric Yes
low Numeric Yes
volume Integer Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod reference_derived macroeconomic_indices_v1

Source Directory | View Definition | Metadata File