PREVIEW / etf_daily / 2000-01-19
file: by_date/etf_daily/2000/2000-01-19.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-19 | SPY | ETF | 145.3125 | 147.0 | 145.0 | 147.0 | 6157900.0 |
| 2000-01-19 | DIA | ETF | 115.625 | 115.7969 | 114.5938 | 115.5625 | 1003400.0 |
| 2000-01-19 | BBH | ETF | 54.5 | 56.125 | 53.6667 | 55.9167 | 841200.0 |
| 2000-01-19 | BITS | ETF | 24.0 | 24.75 | 22.75 | 24.0 | 86700.0 |
| 2000-01-19 | CEF | ETF | 3.5 | 3.625 | 3.4375 | 3.4375 | 185600.0 |
| 2000-01-19 | CHB | ETF | 8.25 | 8.25 | 8.06 | 8.19 | 162700.0 |
| 2000-01-19 | CNXT | ETF | 82.06 | 83.0 | 77.56 | 80.56 | 3461400.0 |
| 2000-01-19 | EWA | ETF | 11.0 | 11.0625 | 10.875 | 11.0 | 6300.0 |
| 2000-01-19 | EWC | ETF | 16.75 | 16.875 | 16.75 | 16.875 | 3300.0 |
| 2000-01-19 | EWD | ETF | 30.125 | 30.375 | 30.125 | 30.25 | 2600.0 |
| 2000-01-19 | EWG | ETF | 26.75 | 27.0 | 26.5625 | 26.9375 | 41900.0 |
| 2000-01-19 | EWH | ETF | 12.75 | 12.9375 | 12.625 | 12.75 | 146200.0 |
| 2000-01-19 | EWI | ETF | 48.375 | 49.25 | 48.375 | 48.75 | 3400.0 |
| 2000-01-19 | EWJ | ETF | 60.5 | 60.75 | 59.75 | 60.5 | 382075.0 |
| 2000-01-19 | EWK | ETF | 14.625 | 14.6875 | 14.5 | 14.6875 | 5100.0 |
| 2000-01-19 | EWL | ETF | 15.625 | 15.9375 | 15.625 | 15.9375 | 15700.0 |
| 2000-01-19 | EWM | ETF | 32.75 | 33.0 | 31.75 | 32.0 | 63925.0 |
| 2000-01-19 | EWN | ETF | 23.9375 | 24.3125 | 23.9375 | 24.125 | 22200.0 |
| 2000-01-19 | EWO | ETF | 8.5 | 8.625 | 8.375 | 8.625 | 13900.0 |
| 2000-01-19 | EWP | ETF | 26.8125 | 27.3125 | 26.8125 | 27.3125 | 7300.0 |
| 2000-01-19 | EWQ | ETF | 26.0 | 26.375 | 25.9375 | 26.375 | 22100.0 |
| 2000-01-19 | EWS | ETF | 17.0 | 17.25 | 16.75 | 16.875 | 44150.0 |
| 2000-01-19 | EWU | ETF | 41.0 | 41.125 | 40.375 | 41.125 | 24600.0 |
| 2000-01-19 | EWW | ETF | 18.625 | 18.625 | 18.0 | 18.25 | 11900.0 |
| 2000-01-19 | FCTR | ETF | 14.5 | 14.875 | 14.25 | 14.375 | 18300.0 |
| 2000-01-19 | FMAR | ETF | 7.6 | 7.6 | 7.35 | 7.48 | 9930.0 |
| 2000-01-19 | GLDB | ETF | 8.875 | 9.25 | 8.75 | 8.875 | 11900.0 |
| 2000-01-19 | GSIG | ETF | 11.37 | 11.87 | 11.12 | 11.75 | 257400.0 |
| 2000-01-19 | IGLD | ETF | 2018.75 | 2125.0 | 1993.75 | 2043.75 | 904.0 |
| 2000-01-19 | KTEC | ETF | 9.5625 | 9.5625 | 9.4375 | 9.5 | 15000.0 |
| 2000-01-19 | MDY | ETF | 82.5312 | 83.4062 | 82.0625 | 83.0 | 449200.0 |
| 2000-01-19 | MIG | ETF | 6.875 | 6.875 | 6.625 | 6.75 | 6200.0 |
| 2000-01-19 | SFY | ETF | 12.9375 | 12.9375 | 12.3125 | 12.4375 | 149800.0 |
| 2000-01-19 | TDSC | ETF | 3.75 | 4.045 | 3.75 | 4.015 | 114800.0 |
| 2000-01-19 | TINY | ETF | 11.12 | 11.38 | 10.06 | 10.5 | 143600.0 |
| 2000-01-19 | XLB | ETF | 12.8906 | 12.9766 | 12.711 | 12.711 | 251400.0 |
| 2000-01-19 | XLE | ETF | 14.1562 | 14.3125 | 14.1406 | 14.1562 | 380600.0 |
| 2000-01-19 | XLF | ETF | 18.7982 | 19.1663 | 18.684 | 18.7221 | 339510.0 |
| 2000-01-19 | XLI | ETF | 29.0 | 29.0312 | 28.875 | 28.875 | 62800.0 |
| 2000-01-19 | XLK | ETF | 26.4688 | 26.7344 | 26.2812 | 26.625 | 1580800.0 |
| 2000-01-19 | XLP | ETF | 23.8594 | 24.0312 | 23.7031 | 23.9219 | 137800.0 |
| 2000-01-19 | XLU | ETF | 13.3906 | 13.5234 | 13.3906 | 13.4375 | 52000.0 |
| 2000-01-19 | XLV | ETF | 31.5938 | 32.25 | 31.5 | 32.25 | 10400.0 |
| 2000-01-19 | XLY | ETF | 14.9766 | 15.1328 | 14.9531 | 14.9531 | 227600.0 |
> showing 44 of 44 rows — these rows as CSV