{"editable":true,"inventories":[{"table":"cryptocurrencies","columns":[{"name":"id","type":"uuid","description":null},{"name":"symbol","type":"string","description":"A symbol for the cryptocurrency, uniqueness isn't guaranteed"},{"name":"name","type":"string","description":null}],"description":"Popularly traded coins and tokens.","lastUpdatedAt":"2023-03-21T00:05:07Z","link":null,"updateFrequency":"daily"},{"table":"cryptocurrency_exchange_rates","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"base_asset_id","type":"uuid","description":"This references a specific cryptocurrency in the cryptocurrencies table. Use this column to join against cryptocurrencies.id."},{"name":"quote_asset_id","type":"uuid","description":"The id referencing a specific currency or cryptocurrency in the table indicated by quote_asset_table"},{"name":"quote_asset_table","type":"string","description":"One of currencies or cryptocurrencies, indicating the table containing id in quote_asset_id"},{"name":"symbol_pair","type":"string","description":"A friendly string representing the pair of currencies. e.g. BTC-USD"},{"name":"open","type":"numeric","description":"Opening trade price for the day."},{"name":"high","type":"numeric","description":"Highest trade price for the day."},{"name":"low","type":"numeric","description":"Lowest trade price for the day."},{"name":"close","type":"numeric","description":"Closing trade price for the day."}],"description":"Daily open, high, low, and close prices.","lastUpdatedAt":"2023-03-21T00:05:48Z","link":null,"updateFrequency":"daily"},{"table":"currencies","columns":[{"name":"id","type":"uuid","description":null},{"name":"symbol","type":"string","description":null},{"name":"name","type":"string","description":null},{"name":"country_code","type":"string","description":null},{"name":"decimals","type":"integer","description":"The number of decimal places needed to represent the minor unit of the currency"}],"description":"National currencies, as defined by ISO 4217.","lastUpdatedAt":null,"link":null,"updateFrequency":"daily"},{"table":"currency_exchange_rates","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"base_currency_id","type":"uuid","description":"This references a specific currency in the currencies table. Use this column to join against currencies.id."},{"name":"quote_currency_id","type":"uuid","description":"This references a specific currency in the currencies table. Use this column to join against currencies.id."},{"name":"symbol_pair","type":"string","description":"A six character string representing the pair of currencies. e.g. USDEUR"},{"name":"open","type":"numeric","description":"Opening trade price for the day."},{"name":"high","type":"numeric","description":"Highest trade price for the day."},{"name":"low","type":"numeric","description":"Lowest trade price for the day."},{"name":"close","type":"numeric","description":"Closing trade price for the day."}],"description":"Daily exchange rates between currency pairs.","lastUpdatedAt":"2023-03-21T00:01:01Z","link":null,"updateFrequency":"daily"},{"table":"energy_prices","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"crude_oil_brent","type":"numeric","description":"Brent Crude Oil futures, delivered in Europe. In US Dollars per barrel. (DCOILBRENTEU)"},{"name":"crude_oil_wti","type":"numeric","description":"West Texas Intermediate Crude Oil futures, delivered in Cushing, Oklahoma. In US Dollars per barrel. (DCOILWTICO)"},{"name":"heating_oil","type":"numeric","description":"Number 2 Heating Oil futures, delivered in New York Harbor. In US Dollars per gallon. (DHOILNYH)"},{"name":"jet_fuel","type":"numeric","description":"Jet Fuel futures, delivered in the US Gulf Coast. In US Dollars per gallon. (DJFUELUSGULF)"},{"name":"natural_gas","type":"numeric","description":"Natural Gas futures, delivered in Henry Hub. In US Dollars per million BTUs. (DHHNGSP)"},{"name":"propane","type":"numeric","description":"Propane futures, delivered in Mont Belvieu Texas. In US Dollars per Gallon. (DPROPANEMBTX)"}],"description":"Prices for energy commodity futures contracts","lastUpdatedAt":"2023-03-15T18:11:34Z","link":"https://fred.stlouisfed.org/categories/32217","updateFrequency":"daily"},{"table":"index_constituents","columns":[{"name":"id","type":"uuid","description":null},{"name":"index_id","type":"uuid","description":"This references a specific stock market index in the indices table. Use this column to join against indices.id."},{"name":"security_id","type":"uuid","description":"This references a specific security in the securities table. Use this column to join against securities.id."}],"description":"The member securities of each stock market index","lastUpdatedAt":"2023-03-20T01:10:28Z","link":null,"updateFrequency":"daily"},{"table":"indices","columns":[{"name":"id","type":"uuid","description":null},{"name":"symbol","type":"text","description":"Ticker Symbol"},{"name":"name","type":"text","description":null}],"description":"Common stock market indices of US equities.","lastUpdatedAt":"2023-03-20T01:10:28Z","link":null,"updateFrequency":"daily"},{"table":"market_holidays","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"status","type":"string","description":"One of early-close, indicating shortened trading hours, or closed, where the markets did not open at all."},{"name":"name","type":"string","description":null},{"name":"open","type":"timestamp","description":"The time the markets opened if this was an early-close holiday, or null if closed."},{"name":"close","type":"timestamp","description":"The time the markets closed if this was an early-close holiday, or null if closed."}],"description":"NYSE and Nasdaq market holidays.","lastUpdatedAt":"2022-02-16T21:42:28Z","link":null,"updateFrequency":"daily"},{"table":"recessions","columns":[{"name":"id","type":"uuid","description":null},{"name":"peak","type":"date","description":null},{"name":"trough","type":"date","description":null}],"description":"As defined by the National Bureau of Economic Research. A recession is ongoing if trough is null.","lastUpdatedAt":null,"link":"https://www.nber.org/research/data/us-business-cycle-expansions-and-contractions","updateFrequency":"daily"},{"table":"securities","columns":[{"name":"id","type":"uuid","description":null},{"name":"symbol","type":"string","description":"Ticker Symbol"},{"name":"name","type":"string","description":null},{"name":"security_type","type":"string","description":null},{"name":"exchange","type":"string","description":null},{"name":"region","type":"string","description":null},{"name":"currency","type":"string","description":null},{"name":"iex_id","type":"string","description":null},{"name":"figi_composite","type":"string","description":null}],"description":"Public Stocks, Funds, and Warrants.","lastUpdatedAt":"2022-05-18T21:36:56Z","link":null,"updateFrequency":"daily"},{"table":"security_price_daily","columns":[{"name":"id","type":"uuid","description":null},{"name":"security_id","type":"uuid","description":"This references a specific security in the securities table. Use this column to join against securities.id."},{"name":"date","type":"date","description":null},{"name":"open","type":"numeric","description":"Opening trade price for the day (split adjusted)."},{"name":"high","type":"numeric","description":"Highest trade price for the day (split adjusted)."},{"name":"low","type":"numeric","description":"Lowest trade price for the day (split adjusted)."},{"name":"close","type":"numeric","description":"Closing trade price for the day (split adjusted)."},{"name":"volume","type":"numeric","description":"The number of shares that were traded on the day."},{"name":"split_adjustment_ratio","type":"numeric","description":null}],"description":"Daily open, high, low, and close prices (split adjusted), and trading volume.","lastUpdatedAt":"2023-03-21T00:00:16Z","link":null,"updateFrequency":"daily"},{"table":"security_price_daily_unadjusted","columns":[{"name":"id","type":"uuid","description":null},{"name":"security_id","type":"uuid","description":"This references a specific security in the securities table. Use this column to join against securities.id."},{"name":"date","type":"date","description":null},{"name":"open","type":"numeric","description":"Opening trade price for the day."},{"name":"high","type":"numeric","description":"Highest trade price for the day."},{"name":"low","type":"numeric","description":"Lowest trade price for the day."},{"name":"close","type":"numeric","description":"Closing trade price for the day."},{"name":"volume","type":"numeric","description":"The number of shares that were traded on the day."},{"name":"split_adjustment_ratio","type":"numeric","description":null}],"description":"Daily open, high, low, and close prices, and trading volume.","lastUpdatedAt":"2023-03-21T00:00:16Z","link":null,"updateFrequency":"daily"},{"table":"security_splits","columns":[{"name":"id","type":"uuid","description":null},{"name":"security_id","type":"uuid","description":"This references a specific security in the securities table. Use this column to join against securities.id."},{"name":"date","type":"date","description":null},{"name":"old_shares","type":"integer","description":null},{"name":"new_shares","type":"integer","description":null},{"name":"ratio","type":"numeric","description":null}],"description":"Splits (forward and reverse) for shares of a security.","lastUpdatedAt":"2023-03-21T00:00:12Z","link":null,"updateFrequency":"daily"},{"table":"trading_days","columns":[{"name":"date","type":"date","description":null}],"description":"Every day that US markets were open for trading. Derived from market_holidays.","lastUpdatedAt":null,"link":null,"updateFrequency":"daily"},{"table":"us_cpi_values","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"adjusted_core_cpi","type":"numeric","description":"Seasonally adjusted, without food and energy"},{"name":"adjusted_cpi","type":"numeric","description":"Seasonally adjusted, everything"},{"name":"core_cpi","type":"numeric","description":"Unadjusted, without food and energy"},{"name":"cpi","type":"numeric","description":"Unadjusted, everything"}],"description":"All items, for all urban consumers, averaged for all US cities. This price index of a basket of goods and services is used as a standard indicator of inflation. The value is a price index relative to 1982-1984, so a value of 150 would mean a basket cost 50% higher than during that basline time period. (CPIAUCNS/CPILFENS/CPIAUCSL/CPILFESL) ","lastUpdatedAt":"2023-03-14T13:10:05Z","link":"https://www.bls.gov/cpi/questions-and-answers.htm","updateFrequency":"monthly"},{"table":"us_gas_prices","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"regular","type":"numeric","description":"US Dollars per Gallon. (GASREGCOVW)"},{"name":"midgrade","type":"numeric","description":"US Dollars per Gallon. (GASMIDCOVW)"},{"name":"premium","type":"numeric","description":"US Dollars per Gallon. (GASPRMCOVW)"},{"name":"diesel","type":"numeric","description":"US Dollars per Gallon. (GASDESW)"}],"description":"Weighted average based on sampling of retail outlets. Approximately 900 outlets for gasoline and 350 for diesel. ","lastUpdatedAt":"2023-03-20T23:10:06Z","link":"https://www.eia.gov/petroleum/gasdiesel/","updateFrequency":"weekly"},{"table":"us_gdp_values","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"nominal_gdp","type":"numeric","description":"US Dollars"},{"name":"real_gdp","type":"numeric","description":"US Dollars"},{"name":"real_gdp_per_capita","type":"numeric","description":"US Dollars"}],"description":"The value of real (inflation adjusted) gross domastic product in the US, as reported by the Bureau of Economic Analysis. In seasonally adjusted 2012 Dollars. (GDP/GDPC1/A939RX0Q048SBEA) ","lastUpdatedAt":"2023-02-23T14:10:05Z","link":"https://fred.stlouisfed.org/series/GDPC1","updateFrequency":"quarterly"},{"table":"us_money_stock_values","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"adjusted_m1","type":"numeric","description":"US Dollars"},{"name":"adjusted_m2","type":"numeric","description":"US Dollars"},{"name":"m1","type":"numeric","description":"US Dollars"},{"name":"m2","type":"numeric","description":"US Dollars"}],"description":"Measures of the total value of US Dollars. A change in definition contributed to the sharp jump in May 2020. (M1NS/M2NS/M1SL/M2SL) ","lastUpdatedAt":"2023-02-28T18:10:05Z","link":"https://fred.stlouisfed.org/release/tables?rid=21&eid=1217588#snid=1217590","updateFrequency":"monthly"},{"table":"us_mortgage_rates","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"30_fixed","type":"numeric","description":"Average rate for a 30 year fixed rate mortgage."},{"name":"15_fixed","type":"numeric","description":"Average rate for a 15 year fixed rate mortgage."},{"name":"5_1_arm","type":"numeric","description":"Average rate for a 5 year / 1 year adjustable rate mortgage."}],"description":"Average rates for common home mortgages.","lastUpdatedAt":"2023-03-16T16:10:08Z","link":"https://fred.stlouisfed.org/release/tables?rid=190&eid=147510","updateFrequency":"weekly"},{"table":"us_yield_curve_rates","columns":[{"name":"id","type":"uuid","description":null},{"name":"date","type":"date","description":null},{"name":"1_month","type":"numeric","description":null},{"name":"2_month","type":"numeric","description":null},{"name":"3_month","type":"numeric","description":null},{"name":"6_month","type":"numeric","description":null},{"name":"1_year","type":"numeric","description":null},{"name":"2_year","type":"numeric","description":null},{"name":"3_year","type":"numeric","description":null},{"name":"5_year","type":"numeric","description":null},{"name":"7_year","type":"numeric","description":null},{"name":"10_year","type":"numeric","description":null},{"name":"20_year","type":"numeric","description":null},{"name":"30_year","type":"numeric","description":null}],"description":"Daily Treasury Par Yield Curve Rates as reported by the US Treasury.","lastUpdatedAt":"2022-10-18T21:02:00Z","link":"https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treasury_yield_curve","updateFrequency":"daily"}],"currentUser":null}

Factor