PREVIEW / etf_daily / 2000-01-06
file: by_date/etf_daily/2000/2000-01-06.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-06 | SPY | ETF | 139.625 | 141.5 | 137.75 | 137.75 | 6227200.0 |
| 2000-01-06 | DIA | ETF | 111.4062 | 113.1719 | 111.1875 | 111.75 | 2639500.0 |
| 2000-01-06 | BBH | ETF | 44.75 | 46.0 | 44.5417 | 45.4583 | 757500.0 |
| 2000-01-06 | BITS | ETF | 25.0 | 28.0 | 24.5 | 27.0 | 132225.0 |
| 2000-01-06 | CEF | ETF | 3.8125 | 3.8125 | 3.75 | 3.75 | 22400.0 |
| 2000-01-06 | CHB | ETF | 8.13 | 8.13 | 7.94 | 7.94 | 386100.0 |
| 2000-01-06 | CNXT | ETF | 61.5 | 62.63 | 54.13 | 55.19 | 2891210.0 |
| 2000-01-06 | EWA | ETF | 10.5 | 10.6875 | 10.5 | 10.6875 | 5800.0 |
| 2000-01-06 | EWC | ETF | 15.8125 | 16.0 | 15.8125 | 16.0 | 3600.0 |
| 2000-01-06 | EWD | ETF | 28.125 | 28.375 | 28.0 | 28.0 | 12800.0 |
| 2000-01-06 | EWG | ETF | 25.1875 | 25.6875 | 25.125 | 25.625 | 135100.0 |
| 2000-01-06 | EWH | ETF | 12.6875 | 12.75 | 12.3125 | 12.5625 | 208900.0 |
| 2000-01-06 | EWI | ETF | 46.875 | 47.25 | 46.75 | 46.75 | 5850.0 |
| 2000-01-06 | EWJ | ETF | 59.25 | 59.25 | 58.5 | 58.75 | 262875.0 |
| 2000-01-06 | EWK | ETF | 15.375 | 15.375 | 15.125 | 15.25 | 2400.0 |
| 2000-01-06 | EWL | ETF | 15.875 | 16.125 | 15.875 | 16.125 | 44000.0 |
| 2000-01-06 | EWM | ETF | 25.25 | 25.75 | 25.25 | 25.5 | 57550.0 |
| 2000-01-06 | EWN | ETF | 24.1875 | 24.4375 | 24.1875 | 24.3125 | 41900.0 |
| 2000-01-06 | EWO | ETF | 8.9375 | 8.9375 | 8.875 | 8.9375 | 7700.0 |
| 2000-01-06 | EWP | ETF | 27.375 | 27.6875 | 27.375 | 27.6875 | 6200.0 |
| 2000-01-06 | EWQ | ETF | 25.625 | 26.0 | 25.625 | 25.875 | 73400.0 |
| 2000-01-06 | EWS | ETF | 17.75 | 18.0 | 17.625 | 17.625 | 30900.0 |
| 2000-01-06 | EWU | ETF | 41.5 | 41.875 | 40.875 | 41.875 | 77700.0 |
| 2000-01-06 | EWW | ETF | 16.8125 | 17.125 | 16.8125 | 17.0 | 21300.0 |
| 2000-01-06 | FCTR | ETF | 14.0625 | 14.25 | 13.8125 | 13.9688 | 35600.0 |
| 2000-01-06 | FMAR | ETF | 7.85 | 7.98 | 7.85 | 7.85 | 4000.0 |
| 2000-01-06 | GLDB | ETF | 9.6875 | 9.8125 | 9.5 | 9.625 | 45100.0 |
| 2000-01-06 | GSIG | ETF | 9.03 | 9.31 | 9.0 | 9.06 | 72900.0 |
| 2000-01-06 | IGLD | ETF | 2065.625 | 2068.75 | 1950.0 | 1950.0 | 2682.0 |
| 2000-01-06 | KTEC | ETF | 8.96875 | 9.0625 | 8.875 | 8.875 | 6900.0 |
| 2000-01-06 | MDY | ETF | 77.375 | 78.75 | 77.375 | 77.4375 | 404900.0 |
| 2000-01-06 | MIG | ETF | 7.25 | 7.25 | 6.875 | 6.875 | 13100.0 |
| 2000-01-06 | SFY | ETF | 9.8125 | 10.5625 | 9.8125 | 10.5625 | 46400.0 |
| 2000-01-06 | TDSC | ETF | 4.095 | 4.22 | 3.97 | 4.125 | 104800.0 |
| 2000-01-06 | TINY | ETF | 11.81 | 12.19 | 11.12 | 11.38 | 195900.0 |
| 2000-01-06 | XLB | ETF | 13.3984 | 13.8672 | 13.3906 | 13.7344 | 2670000.0 |
| 2000-01-06 | XLE | ETF | 13.375 | 13.9219 | 13.375 | 13.8906 | 266200.0 |
| 2000-01-06 | XLF | ETF | 17.6812 | 18.519 | 17.6812 | 18.4048 | 415832.0 |
| 2000-01-06 | XLI | ETF | 27.9219 | 28.375 | 27.8125 | 28.2969 | 54000.0 |
| 2000-01-06 | XLK | ETF | 25.625 | 26.0469 | 24.8125 | 25.0625 | 3340000.0 |
| 2000-01-06 | XLP | ETF | 22.6562 | 23.0 | 22.4844 | 22.9219 | 420800.0 |
| 2000-01-06 | XLU | ETF | 13.625 | 13.625 | 13.4688 | 13.625 | 69000.0 |
| 2000-01-06 | XLV | ETF | 29.3125 | 29.5625 | 29.1562 | 29.4375 | 50000.0 |
| 2000-01-06 | XLY | ETF | 14.5234 | 14.7031 | 14.5 | 14.5938 | 271600.0 |
> showing 44 of 44 rows — these rows as CSV