PREVIEW / etf_daily / 2000-01-04
file: by_date/etf_daily/2000/2000-01-04.parquet size: 6 KB rows: 45
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-04 | SPY | ETF | 143.5312 | 144.0625 | 139.6406 | 139.75 | 8089800.0 |
| 2000-01-04 | DIA | ETF | 112.2812 | 112.9688 | 109.7656 | 109.7656 | 1535700.0 |
| 2000-01-04 | BBH | ETF | 46.5417 | 47.6667 | 43.9375 | 44.0 | 1292100.0 |
| 2000-01-04 | BITS | ETF | 20.875 | 23.75 | 20.25 | 22.25 | 50600.0 |
| 2000-01-04 | BOSS | ETF | 11.5 | 11.5 | 11.5 | 11.5 | 500.0 |
| 2000-01-04 | CEF | ETF | 3.875 | 3.875 | 3.8125 | 3.8125 | 69300.0 |
| 2000-01-04 | CHB | ETF | 8.06 | 8.06 | 7.81 | 8.0 | 125700.0 |
| 2000-01-04 | CNXT | ETF | 62.69 | 64.62 | 62.25 | 63.25 | 3144000.0 |
| 2000-01-04 | EWA | ETF | 10.75 | 10.8125 | 10.5625 | 10.75 | 9700.0 |
| 2000-01-04 | EWC | ETF | 16.375 | 16.375 | 15.875 | 15.875 | 8300.0 |
| 2000-01-04 | EWD | ETF | 29.5 | 29.5 | 28.9375 | 29.25 | 7400.0 |
| 2000-01-04 | EWG | ETF | 25.5625 | 25.6875 | 25.0 | 25.0 | 84400.0 |
| 2000-01-04 | EWH | ETF | 14.0 | 14.0625 | 13.6875 | 13.75 | 85200.0 |
| 2000-01-04 | EWI | ETF | 48.25 | 48.875 | 47.875 | 48.375 | 9650.0 |
| 2000-01-04 | EWJ | ETF | 63.5 | 63.75 | 62.5 | 63.0 | 298000.0 |
| 2000-01-04 | EWK | ETF | 15.625 | 15.875 | 15.375 | 15.625 | 5100.0 |
| 2000-01-04 | EWL | ETF | 16.125 | 16.125 | 15.875 | 15.9375 | 17100.0 |
| 2000-01-04 | EWM | ETF | 28.0 | 28.0 | 26.0 | 26.25 | 68200.0 |
| 2000-01-04 | EWN | ETF | 24.8125 | 24.8125 | 24.25 | 24.5 | 16500.0 |
| 2000-01-04 | EWO | ETF | 8.875 | 8.875 | 8.625 | 8.8125 | 400.0 |
| 2000-01-04 | EWP | ETF | 28.0 | 28.25 | 27.625 | 27.9375 | 11000.0 |
| 2000-01-04 | EWQ | ETF | 26.75 | 26.8125 | 26.1875 | 26.1875 | 52200.0 |
| 2000-01-04 | EWS | ETF | 18.625 | 19.0 | 18.375 | 18.375 | 80200.0 |
| 2000-01-04 | EWU | ETF | 41.875 | 42.375 | 41.625 | 42.0 | 41300.0 |
| 2000-01-04 | EWW | ETF | 17.75 | 17.75 | 16.625 | 16.625 | 37400.0 |
| 2000-01-04 | FCTR | ETF | 14.375 | 14.5 | 13.75 | 14.3125 | 34400.0 |
| 2000-01-04 | FMAR | ETF | 7.73 | 8.23 | 7.73 | 7.73 | 1400.0 |
| 2000-01-04 | GLDB | ETF | 9.25 | 9.75 | 9.25 | 9.5 | 51300.0 |
| 2000-01-04 | GSIG | ETF | 8.62 | 9.06 | 8.37 | 8.62 | 57600.0 |
| 2000-01-04 | IGLD | ETF | 2425.0 | 2425.0 | 2200.0 | 2225.0 | 2607.0 |
| 2000-01-04 | KTEC | ETF | 8.9375 | 9.25 | 8.625 | 8.9375 | 19200.0 |
| 2000-01-04 | MDY | ETF | 79.4375 | 79.5469 | 76.9375 | 77.375 | 1959700.0 |
| 2000-01-04 | MIG | ETF | 7.125 | 7.125 | 6.8125 | 6.875 | 34000.0 |
| 2000-01-04 | SFY | ETF | 10.125 | 10.125 | 9.8125 | 9.9375 | 113100.0 |
| 2000-01-04 | TDSC | ETF | 4.03 | 4.125 | 3.94 | 3.94 | 96800.0 |
| 2000-01-04 | TINY | ETF | 11.25 | 11.56 | 10.56 | 11.19 | 290500.0 |
| 2000-01-04 | XLB | ETF | 13.0 | 13.0234 | 12.8047 | 12.8594 | 516000.0 |
| 2000-01-04 | XLE | ETF | 13.1562 | 13.1562 | 12.9375 | 13.0312 | 1444400.0 |
| 2000-01-04 | XLF | ETF | 18.1763 | 18.2017 | 17.6051 | 17.7701 | 885705.0 |
| 2000-01-04 | XLI | ETF | 28.4688 | 28.6094 | 27.9375 | 28.0469 | 146900.0 |
| 2000-01-04 | XLK | ETF | 27.0 | 27.375 | 26.1562 | 26.3125 | 1091000.0 |
| 2000-01-04 | XLP | ETF | 22.3125 | 22.6562 | 22.0781 | 22.1094 | 172000.0 |
| 2000-01-04 | XLU | ETF | 13.7344 | 13.7344 | 13.3125 | 13.3125 | 187000.0 |
| 2000-01-04 | XLV | ETF | 30.1875 | 30.2031 | 29.5312 | 29.6094 | 35300.0 |
| 2000-01-04 | XLY | ETF | 14.8438 | 14.9062 | 14.5156 | 14.6094 | 354400.0 |
> showing 45 of 45 rows — these rows as CSV