PREVIEW / etf_daily / 2001-10-12
file: by_date/etf_daily/2001/2001-10-12.parquet size: 9 KB rows: 107
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2001-10-12 | SPY | ETF | 109.15 | 109.89 | 107.3 | 109.5 | 31360500.0 |
| 2001-10-12 | QQQ | ETF | 34.33 | 34.8 | 33.14 | 34.55 | 111902800.0 |
| 2001-10-12 | IWM | ETF | 42.56 | 42.89 | 41.9 | 42.54 | 573800.0 |
| 2001-10-12 | DIA | ETF | 93.2 | 93.99 | 92.0 | 93.59 | 6561400.0 |
| 2001-10-12 | ARB | ETF | 27.75 | 27.95 | 27.62 | 27.91 | 63200.0 |
| 2001-10-12 | BBH | ETF | 39.9167 | 40.3667 | 39.0833 | 40.2667 | 3500100.0 |
| 2001-10-12 | BITS | ETF | 14.0832 | 14.4 | 12.96 | 13.0 | 5950.0 |
| 2001-10-12 | CEF | ETF | 3.49 | 3.49 | 3.41 | 3.48 | 21700.0 |
| 2001-10-12 | CHB | ETF | 9.36 | 9.4 | 9.08 | 9.08 | 81100.0 |
| 2001-10-12 | CNXT | ETF | 9.94 | 10.59 | 9.19 | 10.15 | 4415060.0 |
| 2001-10-12 | DGT | ETF | 63.85 | 63.85 | 63.85 | 63.85 | 200.0 |
| 2001-10-12 | EFA | ETF | 38.6 | 39.0167 | 38.6 | 39.0167 | 83400.0 |
| 2001-10-12 | EWA | ETF | 8.66 | 8.67 | 8.6 | 8.64 | 12400.0 |
| 2001-10-12 | EWC | ETF | 10.01 | 10.01 | 9.9 | 9.9 | 1400.0 |
| 2001-10-12 | EWD | ETF | 11.85 | 11.86 | 11.85 | 11.86 | 500.0 |
| 2001-10-12 | EWG | ETF | 13.41 | 13.54 | 13.31 | 13.53 | 161400.0 |
| 2001-10-12 | EWH | ETF | 7.9 | 8.08 | 7.82 | 7.99 | 60600.0 |
| 2001-10-12 | EWI | ETF | 31.38 | 31.38 | 31.38 | 31.38 | 100.0 |
| 2001-10-12 | EWJ | ETF | 34.36 | 34.68 | 34.04 | 34.6 | 102850.0 |
| 2001-10-12 | EWK | ETF | 10.8 | 10.99 | 10.8 | 10.99 | 800.0 |
| 2001-10-12 | EWL | ETF | 12.2 | 12.2 | 11.96 | 12.0 | 3000.0 |
| 2001-10-12 | EWM | ETF | 17.64 | 17.72 | 17.6 | 17.6 | 4050.0 |
| 2001-10-12 | EWN | ETF | 16.68 | 16.95 | 16.67 | 16.95 | 1100.0 |
| 2001-10-12 | EWO | ETF | 7.24 | 7.25 | 7.15 | 7.15 | 4000.0 |
| 2001-10-12 | EWP | ETF | 18.83 | 18.83 | 18.83 | 18.83 | 1400.0 |
| 2001-10-12 | EWQ | ETF | 17.75 | 17.94 | 17.65 | 17.94 | 129600.0 |
| 2001-10-12 | EWS | ETF | 8.84 | 9.08 | 8.76 | 8.94 | 6650.0 |
| 2001-10-12 | EWT | ETF | 15.1 | 15.28 | 14.92 | 14.92 | 6300.0 |
| 2001-10-12 | EWU | ETF | 29.0 | 29.0 | 28.52 | 28.66 | 8700.0 |
| 2001-10-12 | EWW | ETF | 13.7 | 13.7 | 13.05 | 13.5 | 9100.0 |
| 2001-10-12 | EWY | ETF | 12.25 | 12.25 | 12.25 | 12.25 | 400.0 |
| 2001-10-12 | EZU | ETF | 25.85 | 26.075 | 25.75 | 25.75 | 84800.0 |
| 2001-10-12 | FCTR | ETF | 15.97 | 16.2 | 15.97 | 16.0 | 9900.0 |
| 2001-10-12 | FMAR | ETF | 8.11 | 8.11 | 7.7 | 7.99 | 41000.0 |
| 2001-10-12 | GLDB | ETF | 7.56 | 7.59 | 7.35 | 7.59 | 58400.0 |
| 2001-10-12 | GRNB | ETF | 15.2157 | 15.2157 | 14.7249 | 15.2157 | 1413.0 |
| 2001-10-12 | GSIG | ETF | 7.3 | 7.3 | 7.11 | 7.23 | 57000.0 |
| 2001-10-12 | IBB | ETF | 27.5 | 27.7833 | 26.8833 | 27.7833 | 264300.0 |
| 2001-10-12 | ICF | ETF | 20.5375 | 20.61 | 20.4875 | 20.61 | 29200.0 |
| 2001-10-12 | IDU | ETF | 34.725 | 34.725 | 34.28 | 34.28 | 5000.0 |
| 2001-10-12 | IEV | ETF | 28.15 | 28.3 | 27.975 | 28.23 | 25200.0 |
| 2001-10-12 | IGLD | ETF | 67.0 | 73.0 | 67.0 | 70.0 | 63.0 |
| 2001-10-12 | IGM | ETF | 7.4733 | 7.4733 | 7.1917 | 7.4433 | 28800.0 |
| 2001-10-12 | IGN | ETF | 28.95 | 29.7 | 28.7 | 28.7 | 2200.0 |
| 2001-10-12 | IGV | ETF | 7.33 | 7.44 | 7.174 | 7.174 | 16000.0 |
| 2001-10-12 | IJH | ETF | 9.08 | 9.133 | 8.949 | 9.095 | 825000.0 |
| 2001-10-12 | IJJ | ETF | 20.575 | 20.6975 | 20.2775 | 20.595 | 66400.0 |
| 2001-10-12 | IJK | ETF | 12.3875 | 12.5062 | 12.2162 | 12.5062 | 179200.0 |
| 2001-10-12 | IJR | ETF | 16.8 | 16.9033 | 16.5433 | 16.78 | 709200.0 |
| 2001-10-12 | IJS | ETF | 18.5375 | 18.64 | 18.305 | 18.5625 | 50800.0 |
> showing 50 of 107 rows — these rows as CSV