PREVIEW / etf_daily / 2000-01-07
file: by_date/etf_daily/2000/2000-01-07.parquet size: 6 KB rows: 44
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-07 | SPY | ETF | 140.3125 | 145.75 | 140.0625 | 145.75 | 8066500.0 |
| 2000-01-07 | DIA | ETF | 113.3125 | 115.5625 | 113.2188 | 115.5 | 3767400.0 |
| 2000-01-07 | BBH | ETF | 46.6667 | 49.7083 | 46.25 | 49.5417 | 1663800.0 |
| 2000-01-07 | BITS | ETF | 26.875 | 28.0 | 24.0 | 25.0 | 101675.0 |
| 2000-01-07 | CEF | ETF | 3.75 | 3.8125 | 3.6875 | 3.6875 | 62900.0 |
| 2000-01-07 | CHB | ETF | 8.0 | 8.19 | 7.94 | 8.13 | 184800.0 |
| 2000-01-07 | CNXT | ETF | 53.38 | 63.51 | 53.0 | 63.2 | 5561250.0 |
| 2000-01-07 | EWA | ETF | 10.75 | 10.75 | 10.625 | 10.625 | 19300.0 |
| 2000-01-07 | EWC | ETF | 16.0625 | 16.25 | 16.0625 | 16.25 | 8000.0 |
| 2000-01-07 | EWD | ETF | 28.375 | 28.6875 | 28.375 | 28.6875 | 12600.0 |
| 2000-01-07 | EWG | ETF | 26.0 | 27.0 | 26.0 | 27.0 | 182100.0 |
| 2000-01-07 | EWH | ETF | 12.875 | 13.3125 | 12.875 | 13.3125 | 121200.0 |
| 2000-01-07 | EWI | ETF | 47.375 | 48.5 | 47.375 | 48.0 | 10150.0 |
| 2000-01-07 | EWJ | ETF | 59.25 | 60.0 | 59.25 | 60.0 | 122650.0 |
| 2000-01-07 | EWK | ETF | 15.5625 | 15.8125 | 15.5625 | 15.8125 | 11400.0 |
| 2000-01-07 | EWL | ETF | 16.0 | 16.625 | 16.0 | 16.625 | 51200.0 |
| 2000-01-07 | EWM | ETF | 25.5 | 27.0 | 25.5 | 27.0 | 51425.0 |
| 2000-01-07 | EWN | ETF | 24.625 | 25.125 | 24.625 | 25.125 | 30700.0 |
| 2000-01-07 | EWO | ETF | 8.9375 | 9.5 | 8.9375 | 9.5 | 27100.0 |
| 2000-01-07 | EWP | ETF | 27.75 | 28.25 | 27.75 | 28.25 | 3400.0 |
| 2000-01-07 | EWQ | ETF | 26.0 | 26.5 | 26.0 | 26.375 | 106100.0 |
| 2000-01-07 | EWS | ETF | 18.25 | 18.875 | 18.125 | 18.625 | 39450.0 |
| 2000-01-07 | EWU | ETF | 41.375 | 42.25 | 41.125 | 41.5 | 124950.0 |
| 2000-01-07 | EWW | ETF | 17.1875 | 17.6875 | 16.9375 | 17.5 | 57600.0 |
| 2000-01-07 | FCTR | ETF | 13.9688 | 14.5 | 13.875 | 14.5 | 31700.0 |
| 2000-01-07 | FMAR | ETF | 7.85 | 8.23 | 7.85 | 7.85 | 2300.0 |
| 2000-01-07 | GLDB | ETF | 9.75 | 9.8125 | 9.6875 | 9.75 | 56000.0 |
| 2000-01-07 | GSIG | ETF | 9.12 | 9.44 | 9.12 | 9.37 | 45900.0 |
| 2000-01-07 | IGLD | ETF | 1950.0 | 2112.5 | 1850.0 | 1906.25 | 4621.0 |
| 2000-01-07 | KTEC | ETF | 9.0625 | 9.5 | 8.875 | 9.5 | 8300.0 |
| 2000-01-07 | MDY | ETF | 78.0 | 81.0 | 77.875 | 81.0 | 416700.0 |
| 2000-01-07 | MIG | ETF | 7.0 | 7.25 | 6.9375 | 7.25 | 59500.0 |
| 2000-01-07 | SFY | ETF | 10.625 | 10.9375 | 10.4375 | 10.9375 | 56600.0 |
| 2000-01-07 | TDSC | ETF | 4.125 | 4.375 | 4.125 | 4.375 | 101400.0 |
| 2000-01-07 | TINY | ETF | 11.75 | 12.0 | 10.5 | 11.06 | 152900.0 |
| 2000-01-07 | XLB | ETF | 13.875 | 13.9688 | 13.7266 | 13.7266 | 1240200.0 |
| 2000-01-07 | XLE | ETF | 13.8438 | 14.2031 | 13.8438 | 14.039 | 936000.0 |
| 2000-01-07 | XLF | ETF | 18.5317 | 18.7348 | 18.2778 | 18.7094 | 468149.0 |
| 2000-01-07 | XLI | ETF | 28.625 | 29.375 | 28.625 | 29.375 | 32900.0 |
| 2000-01-07 | XLK | ETF | 24.8125 | 25.5 | 24.5625 | 25.5 | 1372000.0 |
| 2000-01-07 | XLP | ETF | 23.3281 | 24.4219 | 23.2656 | 24.375 | 337100.0 |
| 2000-01-07 | XLU | ETF | 13.6484 | 13.7422 | 13.586 | 13.7422 | 92400.0 |
| 2000-01-07 | XLV | ETF | 29.4688 | 29.7969 | 29.3594 | 29.7969 | 22100.0 |
| 2000-01-07 | XLY | ETF | 14.75 | 15.2812 | 14.75 | 15.2812 | 140000.0 |
> showing 44 of 44 rows — these rows as CSV