PREVIEW / etf_daily / 2000-02-02
file: by_date/etf_daily/2000/2000-02-02.parquet size: 6 KB rows: 46
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-02-02 | SPY | ETF | 141.2812 | 142.25 | 140.375 | 141.0625 | 6205900.0 |
| 2000-02-02 | DIA | ETF | 110.375 | 111.1875 | 109.6562 | 109.6875 | 618100.0 |
| 2000-02-02 | BBH | ETF | 54.6667 | 55.25 | 53.5417 | 55.0833 | 1054500.0 |
| 2000-02-02 | BITS | ETF | 25.125 | 26.75 | 24.0 | 26.0 | 45875.0 |
| 2000-02-02 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.5 | 8400.0 |
| 2000-02-02 | CHB | ETF | 7.94 | 7.94 | 7.75 | 7.88 | 65800.0 |
| 2000-02-02 | CNXT | ETF | 85.06 | 88.25 | 85.0 | 86.0 | 5641650.0 |
| 2000-02-02 | CSB | ETF | 2.95000004768372 | 2.95000004768372 | 2.90000009536743 | 2.90000009536743 | 7600.0 |
| 2000-02-02 | EWA | ETF | 10.75 | 10.75 | 10.5 | 10.75 | 22700.0 |
| 2000-02-02 | EWC | ETF | 16.875 | 17.375 | 16.875 | 17.375 | 700.0 |
| 2000-02-02 | EWD | ETF | 30.8125 | 31.125 | 30.8125 | 31.125 | 2900.0 |
| 2000-02-02 | EWG | ETF | 26.0 | 26.3125 | 25.875 | 26.3125 | 128300.0 |
| 2000-02-02 | EWH | ETF | 13.1875 | 13.375 | 12.9375 | 13.125 | 288200.0 |
| 2000-02-02 | EWI | ETF | 48.125 | 49.25 | 47.875 | 48.875 | 15750.0 |
| 2000-02-02 | EWJ | ETF | 62.0 | 62.0 | 61.25 | 62.0 | 93650.0 |
| 2000-02-02 | EWK | ETF | 13.125 | 13.3125 | 13.125 | 13.3125 | 6600.0 |
| 2000-02-02 | EWL | ETF | 14.75 | 14.9375 | 14.5 | 14.9375 | 15400.0 |
| 2000-02-02 | EWM | ETF | 28.5 | 29.75 | 28.5 | 29.75 | 28350.0 |
| 2000-02-02 | EWN | ETF | 22.75 | 22.8125 | 22.375 | 22.8125 | 13300.0 |
| 2000-02-02 | EWO | ETF | 7.875 | 7.9375 | 7.6875 | 7.9375 | 20100.0 |
| 2000-02-02 | EWP | ETF | 26.5625 | 26.75 | 26.3125 | 26.4375 | 10000.0 |
| 2000-02-02 | EWQ | ETF | 26.375 | 26.75 | 26.3125 | 26.75 | 45400.0 |
| 2000-02-02 | EWS | ETF | 16.5 | 16.625 | 16.25 | 16.625 | 54350.0 |
| 2000-02-02 | EWU | ETF | 39.25 | 39.375 | 38.375 | 39.25 | 53150.0 |
| 2000-02-02 | EWW | ETF | 16.3125 | 16.75 | 16.3125 | 16.75 | 27300.0 |
| 2000-02-02 | FCTR | ETF | 13.875 | 13.875 | 13.125 | 13.375 | 67100.0 |
| 2000-02-02 | FMAR | ETF | 6.98 | 7.35 | 6.791 | 7.35 | 10020.0 |
| 2000-02-02 | GLDB | ETF | 8.6875 | 8.75 | 8.625 | 8.6875 | 13700.0 |
| 2000-02-02 | GSIG | ETF | 11.94 | 12.75 | 11.75 | 12.5 | 149400.0 |
| 2000-02-02 | IGLD | ETF | 1968.75 | 2037.5 | 1962.5 | 2006.25 | 802.0 |
| 2000-02-02 | KTEC | ETF | 9.0 | 9.0625 | 8.875 | 8.90625 | 26000.0 |
| 2000-02-02 | MDY | ETF | 80.4688 | 81.6562 | 80.4375 | 81.0 | 683700.0 |
| 2000-02-02 | MIG | ETF | 6.0 | 6.0 | 6.0 | 6.0 | 200.0 |
| 2000-02-02 | PPH | ETF | 45.875 | 46.1562 | 45.5312 | 45.5625 | 312400.0 |
| 2000-02-02 | SFY | ETF | 10.875 | 11.25 | 10.875 | 10.9375 | 37200.0 |
| 2000-02-02 | TDSC | ETF | 5.0 | 5.015 | 4.845 | 4.955 | 54000.0 |
| 2000-02-02 | TINY | ETF | 11.69 | 11.75 | 11.56 | 11.62 | 100800.0 |
| 2000-02-02 | XLB | ETF | 11.9375 | 11.9375 | 11.7812 | 11.9297 | 98000.0 |
| 2000-02-02 | XLE | ETF | 13.6562 | 13.8047 | 13.625 | 13.711 | 58800.0 |
| 2000-02-02 | XLF | ETF | 18.7855 | 18.8109 | 18.4809 | 18.6459 | 399829.0 |
| 2000-02-02 | XLI | ETF | 27.2344 | 27.2344 | 26.875 | 27.0156 | 3500.0 |
| 2000-02-02 | XLK | ETF | 25.7188 | 26.3281 | 25.7188 | 26.0 | 1069400.0 |
| 2000-02-02 | XLP | ETF | 23.1094 | 23.1719 | 22.8438 | 23.0469 | 72700.0 |
| 2000-02-02 | XLU | ETF | 13.75 | 13.7734 | 13.6484 | 13.6484 | 29000.0 |
| 2000-02-02 | XLV | ETF | 30.7188 | 31.25 | 30.7188 | 31.25 | 7700.0 |
| 2000-02-02 | XLY | ETF | 14.125 | 14.1406 | 14.0 | 14.0 | 10600.0 |
> showing 46 of 46 rows — these rows as CSV