PREVIEW / etf_daily / 2000-01-14
file: by_date/etf_daily/2000/2000-01-14.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-14 | SPY | ETF | 146.5312 | 147.4688 | 145.9688 | 146.9688 | 7437300.0 |
| 2000-01-14 | DIA | ETF | 117.4688 | 117.5 | 116.125 | 117.5 | 1935500.0 |
| 2000-01-14 | BBH | ETF | 51.8333 | 52.9167 | 51.1667 | 52.6875 | 1209900.0 |
| 2000-01-14 | BITS | ETF | 21.5 | 22.5 | 20.5 | 21.0 | 53425.0 |
| 2000-01-14 | BOSS | ETF | 11.1 | 11.1 | 11.1 | 11.1 | 200.0 |
| 2000-01-14 | CEF | ETF | 3.5625 | 3.625 | 3.5625 | 3.5625 | 9700.0 |
| 2000-01-14 | CHB | ETF | 8.25 | 8.25 | 8.13 | 8.25 | 109100.0 |
| 2000-01-14 | CNXT | ETF | 70.81 | 76.31 | 70.25 | 74.12 | 5640660.0 |
| 2000-01-14 | EWA | ETF | 11.0625 | 11.25 | 11.0625 | 11.25 | 13800.0 |
| 2000-01-14 | EWC | ETF | 16.5625 | 16.75 | 16.5625 | 16.75 | 1500.0 |
| 2000-01-14 | EWD | ETF | 29.875 | 30.5 | 29.875 | 30.5 | 8100.0 |
| 2000-01-14 | EWG | ETF | 27.4375 | 27.6875 | 27.25 | 27.6875 | 220600.0 |
| 2000-01-14 | EWH | ETF | 13.4375 | 13.4375 | 13.25 | 13.375 | 70100.0 |
| 2000-01-14 | EWI | ETF | 48.875 | 50.125 | 48.875 | 50.125 | 9850.0 |
| 2000-01-14 | EWJ | ETF | 61.25 | 61.5 | 61.0 | 61.5 | 130400.0 |
| 2000-01-14 | EWK | ETF | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 800.0 |
| 2000-01-14 | EWL | ETF | 16.375 | 16.375 | 16.1875 | 16.375 | 11000.0 |
| 2000-01-14 | EWM | ETF | 31.0 | 31.75 | 31.0 | 31.5 | 65325.0 |
| 2000-01-14 | EWN | ETF | 24.6875 | 25.0 | 24.6875 | 24.9375 | 11700.0 |
| 2000-01-14 | EWO | ETF | 8.875 | 9.0 | 8.875 | 8.875 | 12100.0 |
| 2000-01-14 | EWP | ETF | 27.8125 | 27.8125 | 27.5625 | 27.8125 | 9000.0 |
| 2000-01-14 | EWQ | ETF | 27.0 | 27.125 | 26.875 | 27.125 | 96800.0 |
| 2000-01-14 | EWS | ETF | 18.125 | 18.25 | 17.875 | 18.125 | 43400.0 |
| 2000-01-14 | EWU | ETF | 41.625 | 42.375 | 41.625 | 42.25 | 66000.0 |
| 2000-01-14 | EWW | ETF | 18.25 | 18.625 | 18.25 | 18.625 | 23700.0 |
| 2000-01-14 | FCTR | ETF | 15.0 | 15.125 | 14.375 | 14.375 | 34000.0 |
| 2000-01-14 | FMAR | ETF | 8.1 | 8.103 | 7.73 | 7.73 | 1700.0 |
| 2000-01-14 | GLDB | ETF | 8.625 | 9.375 | 8.625 | 9.375 | 73200.0 |
| 2000-01-14 | GSIG | ETF | 10.44 | 10.75 | 10.06 | 10.44 | 123900.0 |
| 2000-01-14 | IGLD | ETF | 2146.875 | 2287.5 | 2012.5 | 2075.0 | 2952.0 |
| 2000-01-14 | KTEC | ETF | 8.6875 | 9.5 | 8.6875 | 8.75 | 23000.0 |
| 2000-01-14 | MDY | ETF | 82.5625 | 83.1875 | 82.0625 | 82.5625 | 628000.0 |
| 2000-01-14 | MIG | ETF | 7.125 | 7.125 | 7.0 | 7.0 | 6300.0 |
| 2000-01-14 | SFY | ETF | 12.125 | 12.4375 | 11.6875 | 11.8125 | 122900.0 |
| 2000-01-14 | TDSC | ETF | 3.875 | 3.97 | 3.685 | 3.75 | 52400.0 |
| 2000-01-14 | TINY | ETF | 9.88 | 10.88 | 9.62 | 10.5 | 147800.0 |
| 2000-01-14 | XLB | ETF | 13.2578 | 13.3594 | 13.2188 | 13.2812 | 152000.0 |
| 2000-01-14 | XLE | ETF | 14.0469 | 14.0469 | 13.8438 | 14.0312 | 71400.0 |
| 2000-01-14 | XLF | ETF | 19.2171 | 19.5598 | 19.2044 | 19.4329 | 731583.0 |
| 2000-01-14 | XLI | ETF | 29.2812 | 29.2969 | 28.8906 | 29.0 | 5700.0 |
| 2000-01-14 | XLK | ETF | 26.625 | 26.8594 | 26.3906 | 26.4375 | 2767800.0 |
| 2000-01-14 | XLP | ETF | 24.4688 | 24.4844 | 23.875 | 24.1562 | 76100.0 |
| 2000-01-14 | XLU | ETF | 13.3906 | 13.4844 | 13.3281 | 13.4844 | 91400.0 |
| 2000-01-14 | XLV | ETF | 32.5938 | 32.5938 | 31.9062 | 32.0938 | 23600.0 |
| 2000-01-14 | XLY | ETF | 15.125 | 15.164 | 15.0703 | 15.0703 | 205200.0 |
> showing 45 of 45 rows — these rows as CSV