Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Airline Index Weighting
| Ticker           | Name                                     |   Weight |    Shares |   Price | Identifier   |
|:-----------------|:-----------------------------------------|---------:|----------:|--------:|:-------------|
| LUV US Equity    | Southwest Airlines Co                    | 11.5553  |   590.678 |   51.78 | BWAIRL Index |
| DAL US Equity    | Delta Air Lines Inc                      | 10.0465  |   638.147 |   41.67 | BWAIRL Index |
| RYA ID Equity    | Ryanair Holdings PLC                     |  8.23999 |  1127.47  |   16.39 | BWAIRL Index |
| UAL US Equity    | United Airlines Holdings Inc             |  5.82724 |   311.845 |   49.46 | BWAIRL Index |
| AAL US Equity    | American Airlines Group Inc              |  5.33616 |   639.676 |   22.08 | BWAIRL Index |
| IAG LN Equity    | International Consolidated Airlines Grou |  4.57032 |  4967.43  |  176.2  | BWAIRL Index |
| 9202 JP Equity   | ANA Holdings Inc                         |  4.26733 |   484.294 | 2574    | BWAIRL Index |
| SIA SP Equity    | Singapore Airlines Ltd                   |  4.12213 |  2964.97  |    5    | BWAIRL Index |
| 601111 CH Equity | Air China Ltd                            |  4.08139 |  9962.13  |    7.03 | BWAIRL Index |
| 600029 CH Equity | China Southern Airlines Co Ltd           |  3.69776 | 11054.2   |    5.74 | BWAIRL Index |


Table: Brent
| Date   | PX_LAST   | Identifier   |
|:-------|:----------|:-------------|
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |
|        |           | CO1 Comdty   |


Table: Commodity Index
| Security   | BCOM Index   |
|:-----------|:-------------|
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |


Table: Dates
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | Month Name   | Month & Year   | Quarter & Year   |   DayOfWeek | DayOfWeekName   | WeekEnding              | MonthEnding             |   ISO Weeknumber |   ISO Year |   ISO Day of Year | Week & Year   |   WeeknYear |   MonthnYear |   QuarternYear | Fiscal Year   | Fiscal Quarter   |   Fiscal Period | IsAfterToday   | IsWorkingDay   | IsHoliday   | IsBusinessDay   | Day Type   |   WeekOffset |   MonthOffset |   QuarterOffset |   YearOffset |   FiscalYearOffset | WeekCompleted   | MonthCompleted   | QuarterCompleted   |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:-------------|:---------------|:-----------------|------------:|:----------------|:------------------------|:------------------------|-----------------:|-----------:|------------------:|:--------------|------------:|-------------:|---------------:|:--------------|:-----------------|----------------:|:---------------|:---------------|:------------|:----------------|:-----------|-------------:|--------------:|----------------:|-------------:|-------------------:|:----------------|:-----------------|:-------------------|
| 2006-04-03 00:00:00.000 |   2006 |               2 |             4 |            3 |  20060403 | April        | Apr 2006       | Q2 2006          |           0 | Monday          | 2006-04-09 00:00:00.000 | 2006-04-30 00:00:00.000 |               14 |       2006 |                92 | 2006-14       |    20061400 |     20060400 |       20060200 | FY07          | FQ2              |               4 | False          | True           | Unknown     | True            | Weekday    |         -804 |          -184 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-04-10 00:00:00.000 |   2006 |               2 |             4 |           10 |  20060410 | April        | Apr 2006       | Q2 2006          |           0 | Monday          | 2006-04-16 00:00:00.000 | 2006-04-30 00:00:00.000 |               15 |       2006 |                99 | 2006-15       |    20061500 |     20060400 |       20060200 | FY07          | FQ2              |               4 | False          | True           | Unknown     | True            | Weekday    |         -803 |          -184 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-04-17 00:00:00.000 |   2006 |               2 |             4 |           17 |  20060417 | April        | Apr 2006       | Q2 2006          |           0 | Monday          | 2006-04-23 00:00:00.000 | 2006-04-30 00:00:00.000 |               16 |       2006 |               106 | 2006-16       |    20061600 |     20060400 |       20060200 | FY07          | FQ2              |               4 | False          | True           | Unknown     | True            | Weekday    |         -802 |          -184 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-04-24 00:00:00.000 |   2006 |               2 |             4 |           24 |  20060424 | April        | Apr 2006       | Q2 2006          |           0 | Monday          | 2006-04-30 00:00:00.000 | 2006-04-30 00:00:00.000 |               17 |       2006 |               113 | 2006-17       |    20061700 |     20060400 |       20060200 | FY07          | FQ2              |               4 | False          | True           | Unknown     | True            | Weekday    |         -801 |          -184 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-05-01 00:00:00.000 |   2006 |               2 |             5 |            1 |  20060501 | May          | May 2006       | Q2 2006          |           0 | Monday          | 2006-05-07 00:00:00.000 | 2006-05-31 00:00:00.000 |               18 |       2006 |               120 | 2006-18       |    20061800 |     20060500 |       20060200 | FY07          | FQ2              |               5 | False          | True           | Unknown     | True            | Weekday    |         -800 |          -183 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-05-08 00:00:00.000 |   2006 |               2 |             5 |            8 |  20060508 | May          | May 2006       | Q2 2006          |           0 | Monday          | 2006-05-14 00:00:00.000 | 2006-05-31 00:00:00.000 |               19 |       2006 |               127 | 2006-19       |    20061900 |     20060500 |       20060200 | FY07          | FQ2              |               5 | False          | True           | Unknown     | True            | Weekday    |         -799 |          -183 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-05-15 00:00:00.000 |   2006 |               2 |             5 |           15 |  20060515 | May          | May 2006       | Q2 2006          |           0 | Monday          | 2006-05-21 00:00:00.000 | 2006-05-31 00:00:00.000 |               20 |       2006 |               134 | 2006-20       |    20062000 |     20060500 |       20060200 | FY07          | FQ2              |               5 | False          | True           | Unknown     | True            | Weekday    |         -798 |          -183 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-05-22 00:00:00.000 |   2006 |               2 |             5 |           22 |  20060522 | May          | May 2006       | Q2 2006          |           0 | Monday          | 2006-05-28 00:00:00.000 | 2006-05-31 00:00:00.000 |               21 |       2006 |               141 | 2006-21       |    20062100 |     20060500 |       20060200 | FY07          | FQ2              |               5 | False          | True           | Unknown     | True            | Weekday    |         -797 |          -183 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-05-29 00:00:00.000 |   2006 |               2 |             5 |           29 |  20060529 | May          | May 2006       | Q2 2006          |           0 | Monday          | 2006-06-04 00:00:00.000 | 2006-05-31 00:00:00.000 |               22 |       2006 |               148 | 2006-22       |    20062200 |     20060500 |       20060200 | FY07          | FQ2              |               5 | False          | True           | Unknown     | True            | Weekday    |         -796 |          -183 |             -61 |          -15 |                -15 | True            | True             | True               |
| 2006-06-05 00:00:00.000 |   2006 |               2 |             6 |            5 |  20060605 | June         | Jun 2006       | Q2 2006          |           0 | Monday          | 2006-06-11 00:00:00.000 | 2006-06-30 00:00:00.000 |               23 |       2006 |               155 | 2006-23       |    20062300 |     20060600 |       20060200 | FY07          | FQ2              |               6 | False          | True           | Unknown     | True            | Weekday    |         -795 |          -182 |             -61 |          -15 |                -15 | True            | True             | True               |


Table: EM High Yield
| Date                    |   PX_BID | Identifier    |
|:------------------------|---------:|:--------------|
| 2021-08-31 00:00:00.000 |     5.42 | BEBGOAS Index |
| 2021-08-30 00:00:00.000 |     5.47 | BEBGOAS Index |
| 2021-08-27 00:00:00.000 |     5.47 | BEBGOAS Index |
| 2021-08-26 00:00:00.000 |     5.46 | BEBGOAS Index |
| 2021-08-25 00:00:00.000 |     5.48 | BEBGOAS Index |
| 2021-08-24 00:00:00.000 |     5.54 | BEBGOAS Index |
| 2021-08-23 00:00:00.000 |     5.6  | BEBGOAS Index |
| 2021-08-20 00:00:00.000 |     5.61 | BEBGOAS Index |
| 2021-08-19 00:00:00.000 |     5.6  | BEBGOAS Index |
| 2021-08-18 00:00:00.000 |     5.55 | BEBGOAS Index |


Table: EndOfYear
| EndOfYear               |
|:------------------------|
| 2021-12-31 00:00:00.000 |


Table: Fed Funds Index
| Date                    |   PX_BID | Identifier   |
|:------------------------|---------:|:-------------|
| 2021-08-30 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-27 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-26 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-25 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-24 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-23 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-20 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-19 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-18 00:00:00.000 |     0.08 | FDFD Index   |
| 2021-08-17 00:00:00.000 |     0.08 | FDFD Index   |


Table: FirstDate
| FirstDate               |
|:------------------------|
| 2006-05-31 00:00:00.000 |


Table: Gold
| Security   | XAU Curncy   |
|:-----------|:-------------|
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |


Table: High Yield Index
| Date                    |   PX_BID | Identifier     |
|:------------------------|---------:|:---------------|
| 2021-08-30 00:00:00.000 |     2.88 | LF98OAS  Index |
| 2021-08-27 00:00:00.000 |     2.94 | LF98OAS  Index |
| 2021-08-26 00:00:00.000 |     2.96 | LF98OAS  Index |
| 2021-08-25 00:00:00.000 |     2.97 | LF98OAS  Index |
| 2021-08-24 00:00:00.000 |     3.02 | LF98OAS  Index |
| 2021-08-23 00:00:00.000 |     3.07 | LF98OAS  Index |
| 2021-08-20 00:00:00.000 |     3.12 | LF98OAS  Index |
| 2021-08-19 00:00:00.000 |     3.14 | LF98OAS  Index |
| 2021-08-18 00:00:00.000 |     3.09 | LF98OAS  Index |
| 2021-08-17 00:00:00.000 |     3.09 | LF98OAS  Index |


Table: Identifier
| Ticker             | Group   | Category   | Security       | Region        |
|:-------------------|:--------|:-----------|:---------------|:--------------|
| FDFD Index         | Credit  | Rates      | Fed Funds Rate | North America |
| BLQCOAS  Index     | Credit  | Spreads    | IG Spreads     | North America |
| LF98OAS  Index     | Credit  | Spreads    | HY Spreads     | North America |
| USSW30 CMPN Curncy | Credit  | Rates      | 30yr US SWAP   | North America |
| USSW20 CMPN Curncy | Credit  | Rates      | 20yr US SWAP   | North America |
| USSW10 CMPN Curncy | Credit  | Rates      | 10yr US SWAP   | North America |
| USSW9 CMPN Curncy  | Credit  | Rates      | 9yr US SWAP    | North America |
| USSW8 CMPN Curncy  | Credit  | Rates      | 8yr US SWAP    | North America |
| USSW7 CMPN Curncy  | Credit  | Rates      | 7yr US SWAP    | North America |
| USSW6 CMPN Curncy  | Credit  | Rates      | 6yr US SWAP    | North America |


Table: Investment Grade OAS
| Date                    |   PX_BID | Identifier     |
|:------------------------|---------:|:---------------|
| 2021-08-30 00:00:00.000 |     0.96 | BLQCOAS  Index |
| 2021-08-27 00:00:00.000 |     0.97 | BLQCOAS  Index |
| 2021-08-26 00:00:00.000 |     0.96 | BLQCOAS  Index |
| 2021-08-25 00:00:00.000 |     0.97 | BLQCOAS  Index |
| 2021-08-24 00:00:00.000 |     0.98 | BLQCOAS  Index |
| 2021-08-23 00:00:00.000 |     0.99 | BLQCOAS  Index |
| 2021-08-20 00:00:00.000 |     1    | BLQCOAS  Index |
| 2021-08-19 00:00:00.000 |     1    | BLQCOAS  Index |
| 2021-08-18 00:00:00.000 |     0.99 | BLQCOAS  Index |
| 2021-08-17 00:00:00.000 |     0.99 | BLQCOAS  Index |


Table: LastDate for Data
| LastDate for Data       |
|:------------------------|
| 2021-08-31 00:00:00.000 |


Table: Lessor Bond (HP)
| Date   | PX_LAST   | YLD_YTM_MID   | Identifier         |
|:-------|:----------|:--------------|:-------------------|
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |
|        |           |               | BQ0095126     Corp |


Table: Lessor Bond Summary (spot)
| Issuer Name                      | Ticker   | Security Name      | ISIN         | Currency   | Issue Date              | Maturity   |   Mty (Years Frm Tdy) | Amt Issued   |   Amt Out |   Cpn | Yld to Mty (Mid)   | Yld to Worst(Mid)   | Series   | Mty Type    | Bloomberg ID   | S&P Rating   | Moody Rtg   | Fitch Rating   | Pricing Source   | Security Ticker    |
|:---------------------------------|:---------|:-------------------|:-------------|:-----------|:------------------------|:-----------|----------------------:|:-------------|----------:|------:|:-------------------|:--------------------|:---------|:------------|:---------------|:-------------|:------------|:---------------|:-----------------|:-------------------|
| International Lease Finance Corp | AER      | AER 5.45 05/15/09  | US45974EMK90 | USD        | 2006-07-27 00:00:00.000 | 15/05/2009 |             -12.3039  |              |         0 |  5.45 | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF5683612      | NR           | WR          | NR             | BGN              | EF5683612     Corp |
| International Lease Finance Corp | AER      | AER 3.6 06/15/08   | US45974EHT64 | USD        | 2005-01-06 00:00:00.000 | 15/06/2008 |             -13.2183  |              |         0 |  3.6  | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | ED7353292      | NR           | WR          | NR             | BGN              | ED7353292     Corp |
| International Lease Finance Corp | AER      | AER 3 1/4 03/15/07 | US45974EHR09 | USD        | 2005-01-06 00:00:00.000 | 15/03/2007 |             -14.4723  |              |         0 |  3.25 | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | ED7353219      | NR           | WR          | NR             | BGN              | ED7353219     Corp |
| International Lease Finance Corp | AER      | AER 3 3/4 02/15/09 | US45974EHU38 | USD        | 2005-01-06 00:00:00.000 | 15/02/2009 |             -12.5476  |              |         0 |  3.75 | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | ED7353458      | NR           | WR          | NR             | BGN              | ED7353458     Corp |
| International Lease Finance Corp | AER      | AER 5.4 03/15/10   | US45974ELV64 | USD        | 2006-06-08 00:00:00.000 | 15/03/2010 |             -11.4716  |              |         0 |  5.4  | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF4638948      | NR           | WR          | NR             | BGN              | EF4638948     Corp |
| International Lease Finance Corp | AER      | AER 5.05 05/15/09  | US45974ELK00 | USD        | 2006-04-06 00:00:00.000 | 15/05/2009 |             -12.3039  |              |         0 |  5.05 | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF3379759      | NR           | WR          | NR             | BGN              | EF3379759     Corp |
| International Lease Finance Corp | AER      | AER 5.1 10/15/12   | US45974ENK81 | USD        | 2006-11-30 00:00:00.000 | 15/10/2012 |              -8.88433 |              |         0 |  5.1  | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF8497887      | NR           | WR          | NR             | BGN              | EF8497887     Corp |
| International Lease Finance Corp | AER      | AER 5.35 05/15/09  | US45974EMA19 | USD        | 2006-06-22 00:00:00.000 | 15/05/2009 |             -12.3039  |              |         0 |  5.35 | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF4858090      | NR           | WR          | NR             | BGN              | EF4858090     Corp |
| International Lease Finance Corp | AER      | AER 5.4 03/15/10   | US45974EMB91 | USD        | 2006-06-22 00:00:00.000 | 15/03/2010 |             -11.4716  |              |         0 |  5.4  | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF4858132      | NR           | WR          | NR             | BGN              | EF4858132     Corp |
| International Lease Finance Corp | AER      | AER 5 1/2 04/15/08 | US45974EMC74 | USD        | 2006-06-29 00:00:00.000 | 15/04/2008 |             -13.3854  |              |         0 |  5.5  | #N/A N/A           | #N/A N/A            | ILFC     | AT MATURITY | EF4990075      | NR           | WR          | NR             | BGN              | EF4990075     Corp |


Table: Lessor Master Data
| Lessor Code   | Lessor Name            | Ascend Name                | Primary aircraft exposure   | Bloomberg Ticker   | Bloomberg Bond Ticker   | Region         | Country       | Ownership         | Ultimate Majority Owner   | UMO Country   | ABS 1                      | ABS 2                      | ABS 3                      | ABS 4                      | ABS 5                      | ABS 6                      | ABS 7   | ABS 8   | ABS 9   | ABS 10   | ABS 11   | Managed Vehicle 1   | Managed Vehicle 2                 | Managed Vehicle 3       | Managed Vehicle 4            | Managed Vehicle 5       | Managed Vehicle 6   | Managed Vehicle 7   | Managed Vehicle 8   | Managed Vehicle 9   |
|:--------------|:-----------------------|:---------------------------|:----------------------------|:-------------------|:------------------------|:---------------|:--------------|:------------------|:--------------------------|:--------------|:---------------------------|:---------------------------|:---------------------------|:---------------------------|:---------------------------|:---------------------------|:--------|:--------|:--------|:---------|:---------|:--------------------|:----------------------------------|:------------------------|:-----------------------------|:------------------------|:--------------------|:--------------------|:--------------------|:--------------------|
| AER           | AerCap                 | AerCap                     | On balance sheet            | AER Equity         | AER                     | Western Europe | Ireland       | Listed            | Public                    | Public        | AERLS 2017-1 ABS Portfolio | AERLS 2018-1 ABS Portfolio |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| GECAS         | GECAS                  | GECAS                      | On balance sheet            |                    |                         | North America  | United States | Listed subsidiary | GE                        | Public        | LAFL 2016-1 ABS Portfolio  | LIFT 2001-1 ABS Portfolio  | RISE 2014-1 ABS Portfolio  | STARR 2018-1 ABS Portfolio | STARR 2019-1 ABS Portfolio | STARR 2019-2 ABS Portfolio |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| BBAM          | BBAM                   | BBAM                       | On balance sheet            |                    |                         | North America  | United States | Private           | Private                   | United States | HORZN 2018-1 ABS Portfolio | HORZN 2019-1 ABS Portfolio | HORZN 2019-2 ABS Portfolio | ECAF 2015-1 ABS Portfolio  |                            |                            |         |         |         |          |          | FLY Leasing         | BBAM/NBB                          | Incline Aviation I Fund | Incline Aviation Funding LLC | Incline Aviation 10 LLC |                     |                     |                     |                     |
| AVOL          | Avolon                 | Avolon                     | On balance sheet            |                    |                         | Western Europe | Ireland       | Listed subsidiary | HNA Group                 | China         | SAPA 2018-1 ABS Portfolio  | SAPA 2020-1 ABS Portfolio  |                            |                            |                            |                            |         |         |         |          |          | Jade leasing        | Jade Aviation (Ireland) AOE 2 Ltd |                         |                              |                         |                     |                     |                     |                     |
| ALC           | Air Lease Corp         | Air Lease Corporation      | On balance sheet            | AL equity          |                         | North America  | United States | Listed            | Public                    | Public        |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| AYR           | Aircastle              | Aircastle                  | On balance sheet            | AYR Equity         |                         | North America  | United States | Listed subsidiary | Marubeni Corporation      | Japan         |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| CDB           | CDB Aviation           | CDB Aviation               | On balance sheet            |                    |                         | N.E. Asia      | China         | Listed subsidiary | China Development Bank    | China         |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| AVIC          | AVIC                   | AVIC International Leasing | On balance sheet            |                    | AVIILC                  | N.E. Asia      | China         | SOE               | AVIC                      | China         |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| ACG           | Aviation Capital Group | Aviation Capital Group     | On balance sheet            |                    | ACGCAP                  | North America  | United States | Listed subsidiary | Tokyo Century Corporation | Japan         |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |
| AVAP          | Avation                | Avation PLC                | On balance sheet            |                    | AVTCAP                  | S.E. Asia      | Singapore     | Listed            | Public                    | Public        |                            |                            |                            |                            |                            |                            |         |         |         |          |          |                     |                                   |                         |                              |                         |                     |                     |                     |                     |


Table: S&P 500
| Date                    |   PX_LAST |   PX_TO_BOOK_RATIO |   CUR_MKT_CAP |   CURR_ENTP_VAL |   CURRENT_EV_TO_T12M_EBITDA |   PE_Ratio |   BEST_PE_RATIO |   IDX_EST_DVD_YLD |   EARN_YLD | Identifier   | Column11   |
|:------------------------|----------:|-------------------:|--------------:|----------------:|----------------------------:|-----------:|----------------:|------------------:|-----------:|:-------------|:-----------|
| 2016-05-30 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-27 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-26 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-25 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-24 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-23 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-20 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-19 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-18 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |
| 2016-05-17 00:00:00.000 |         0 |                  0 |             0 |               0 |                           0 |          0 |               0 |                 0 |          0 | BOCA         |            |


Table: Silver
| Security   | XAG Curncy   |
|:-----------|:-------------|
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |
|            |              |


Table: StartOfYear
| StartOfYear             |
|:------------------------|
| 2006-01-01 00:00:00.000 |


Table: Uranium
| Security   | UXA1 Comdty   |
|:-----------|:--------------|
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |
|            |               |


Table: US10 Year Breakeven
| Date                    |   PX_BID | Identifier     |
|:------------------------|---------:|:---------------|
| 2021-08-31 00:00:00.000 |   2.3364 | USGGBE10 Index |
| 2021-08-30 00:00:00.000 |   2.3681 | USGGBE10 Index |
| 2021-08-27 00:00:00.000 |   2.387  | USGGBE10 Index |
| 2021-08-26 00:00:00.000 |   2.3463 | USGGBE10 Index |
| 2021-08-25 00:00:00.000 |   2.3545 | USGGBE10 Index |
| 2021-08-24 00:00:00.000 |   2.3158 | USGGBE10 Index |
| 2021-08-23 00:00:00.000 |   2.2789 | USGGBE10 Index |
| 2021-08-20 00:00:00.000 |   2.2619 | USGGBE10 Index |
| 2021-08-19 00:00:00.000 |   2.293  | USGGBE10 Index |
| 2021-08-18 00:00:00.000 |   2.3185 | USGGBE10 Index |


Table: US10 Year Swap
| Date                    |   PX_BID | Identifier        |
|:------------------------|---------:|:------------------|
| 2021-08-31 00:00:00.000 |   1.1896 | USSW8 CMPN Curncy |
| 2021-08-30 00:00:00.000 |   1.1679 | USSW8 CMPN Curncy |
| 2021-08-27 00:00:00.000 |   1.1975 | USSW8 CMPN Curncy |
| 2021-08-26 00:00:00.000 |   1.2348 | USSW8 CMPN Curncy |
| 2021-08-25 00:00:00.000 |   1.2277 | USSW8 CMPN Curncy |
| 2021-08-24 00:00:00.000 |   1.1781 | USSW8 CMPN Curncy |
| 2021-08-23 00:00:00.000 |   1.1382 | USSW8 CMPN Curncy |
| 2021-08-20 00:00:00.000 |   1.1459 | USSW8 CMPN Curncy |
| 2021-08-19 00:00:00.000 |   1.135  | USSW8 CMPN Curncy |
| 2021-08-18 00:00:00.000 |   1.1475 | USSW8 CMPN Curncy |


Table: US10 Year TIPS
| Date                    |   PX_BID | Identifier   |
|:------------------------|---------:|:-------------|
| 2021-08-31 00:00:00.000 |   -1.024 | GTII10 Govt  |
| 2021-08-30 00:00:00.000 |   -1.085 | GTII10 Govt  |
| 2021-08-27 00:00:00.000 |   -1.077 | GTII10 Govt  |
| 2021-08-26 00:00:00.000 |   -0.994 | GTII10 Govt  |
| 2021-08-25 00:00:00.000 |   -1.01  | GTII10 Govt  |
| 2021-08-24 00:00:00.000 |   -1.017 | GTII10 Govt  |
| 2021-08-23 00:00:00.000 |   -1.024 | GTII10 Govt  |
| 2021-08-20 00:00:00.000 |   -1.005 | GTII10 Govt  |
| 2021-08-19 00:00:00.000 |   -1.048 | GTII10 Govt  |
| 2021-08-18 00:00:00.000 |   -1.058 | GTII10 Govt  |


Table: Value of Neg Yielding Bond
| Date   | PX_BID   | Identifier    |
|:-------|:---------|:--------------|
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |
|        |          | BNYDMVU Index |

 


tables: name: Airline Index Weighting
data: Airline Index Weighting.csv
name: Brent
data: Brent.csv
name: Commodity Index
data: Commodity Index.csv
name: Dates
data: Dates.csv
name: EM High Yield
data: EM High Yield.csv
name: EndOfYear
data: EndOfYear.csv
name: Fed Funds Index
data: Fed Funds Index.csv
name: FirstDate
data: FirstDate.csv
name: Gold
data: Gold.csv
name: High Yield Index
data: High Yield Index.csv
name: Identifier
data: Identifier.csv
name: Investment Grade OAS
data: Investment Grade OAS.csv
name: LastDate for Data
data: LastDate for Data.csv
name: Lessor Bond (HP)
data: Lessor Bond (HP).csv
name: Lessor Bond Summary (spot)
data: Lessor Bond Summary (spot).csv
name: Lessor Master Data
data: Lessor Master Data.csv
name: S&P 500
data: S&P 500.csv
name: Silver
data: Silver.csv
name: StartOfYear
data: StartOfYear.csv
name: Uranium
data: Uranium.csv
name: US10 Year Breakeven
data: US10 Year Breakeven.csv
name: US10 Year Swap
data: US10 Year Swap.csv
name: US10 Year TIPS
data: US10 Year TIPS.csv
name: Value of Neg Yielding Bond
data: Value of Neg Yielding Bond.csv
label: S&P 500
Date
Dates
Date
S&P 500
Identifier
Identifier
Security
Brent
Date
Dates
Date
Brent
Identifier
Identifier
Ticker
US10 Year Swap
Date
Dates
Date
US10 Year Swap
Identifier
Identifier
Ticker
High Yield Index
Identifier
Identifier
Ticker
High Yield Index
Date
Dates
Date
Dates
Date
Investment Grade OAS
Date
Airline Index Weighting
Identifier
Identifier
Ticker
Value of Neg Yielding Bond
Date
Dates
Date
Value of Neg Yielding Bond
Identifier
Identifier
Ticker
Lessor Bond (HP)
Identifier
Lessor Bond Summary (spot)
Security Ticker
Lessor Bond Summary (spot)
Ticker
Lessor Master Data
Bloomberg Bond Ticker
Lessor Bond (HP)
Date
Dates
Date
Lessor Master Data
Bloomberg Ticker
Identifier
Ticker
output: {
    "joins": [
        {
            "from_table": "S&P 500",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "S&P 500",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Security"
        },
        {
            "from_table": "Brent",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Brent",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Ticker"
        },
        {
            "from_table": "US10 Year Swap",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "US10 Year Swap",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Ticker"
        },
        {
            "from_table": "High Yield Index",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Ticker"
        },
        {
            "from_table": "High Yield Index",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Dates",
            "from_column": "Date",
            "to_table": "Investment Grade OAS",
            "to_column": "Date"
        },
        {
            "from_table": "Airline Index Weighting",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Ticker"
        },
        {
            "from_table": "Value of Neg Yielding Bond",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Value of Neg Yielding Bond",
            "from_column": "Identifier",
            "to_table": "Identifier",
            "to_column": "Ticker"
        },
        {
            "from_table": "Lessor Bond (HP)",
            "from_column": "Identifier",
            "to_table": "Lessor Bond Summary (spot)",
            "to_column": "Security Ticker"
        },
        {
            "from_table": "Lessor Bond Summary (spot)",
            "from_column": "Ticker",
            "to_table": "Lessor Master Data",
            "to_column": "Bloomberg Bond Ticker"
        },
        {
            "from_table": "Lessor Bond (HP)",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Lessor Master Data",
            "from_column": "Bloomberg Ticker",
            "to_table": "Identifier",
            "to_column": "Ticker"
        }
    ]
}