PREVIEW / etf_daily / 2000-06-16
file: by_date/etf_daily/2000/2000-06-16.parquet size: 7 KB rows: 65
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-06-16 | SPY | ETF | 148.3125 | 148.3125 | 145.875 | 146.5938 | 5567900.0 |
| 2000-06-16 | QQQ | ETF | 94.75 | 95.3125 | 93.0625 | 94.25 | 21203400.0 |
| 2000-06-16 | IWM | ETF | 51.4688 | 51.5 | 50.9688 | 50.9688 | 30200.0 |
| 2000-06-16 | DIA | ETF | 107.0469 | 107.1562 | 104.5156 | 104.5156 | 3000700.0 |
| 2000-06-16 | BBH | ETF | 52.3333 | 54.6667 | 51.9375 | 54.6667 | 2305200.0 |
| 2000-06-16 | BITS | ETF | 29.5 | 30.0 | 29.0 | 29.5 | 20550.0 |
| 2000-06-16 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.4375 | 14800.0 |
| 2000-06-16 | CHB | ETF | 5.81 | 5.81 | 5.5 | 5.56 | 179800.0 |
| 2000-06-16 | CNXT | ETF | 49.5 | 55.5 | 47.94 | 53.88 | 15617780.0 |
| 2000-06-16 | EWA | ETF | 10.375 | 10.4375 | 10.125 | 10.125 | 33400.0 |
| 2000-06-16 | EWC | ETF | 19.75 | 19.8125 | 19.75 | 19.8125 | 6100.0 |
| 2000-06-16 | EWD | ETF | 31.5 | 31.6875 | 31.25 | 31.25 | 21300.0 |
| 2000-06-16 | EWG | ETF | 25.625 | 25.875 | 25.5625 | 25.6875 | 22100.0 |
| 2000-06-16 | EWH | ETF | 12.625 | 12.75 | 12.5 | 12.5625 | 80600.0 |
| 2000-06-16 | EWI | ETF | 51.75 | 52.125 | 51.5 | 51.625 | 6250.0 |
| 2000-06-16 | EWJ | ETF | 57.5 | 58.0 | 57.25 | 57.25 | 49125.0 |
| 2000-06-16 | EWK | ETF | 13.4375 | 13.75 | 13.4375 | 13.5 | 15200.0 |
| 2000-06-16 | EWL | ETF | 16.1875 | 16.5 | 16.1875 | 16.4375 | 8300.0 |
| 2000-06-16 | EWM | ETF | 25.5 | 25.75 | 25.5 | 25.5 | 4225.0 |
| 2000-06-16 | EWN | ETF | 25.0625 | 25.4375 | 25.0625 | 25.125 | 7700.0 |
| 2000-06-16 | EWO | ETF | 8.1875 | 8.1875 | 7.9375 | 8.125 | 800.0 |
| 2000-06-16 | EWP | ETF | 26.5 | 26.8125 | 26.5 | 26.6875 | 11500.0 |
| 2000-06-16 | EWQ | ETF | 29.125 | 29.25 | 28.875 | 28.875 | 28100.0 |
| 2000-06-16 | EWS | ETF | 15.0 | 15.0 | 14.5 | 14.75 | 51500.0 |
| 2000-06-16 | EWU | ETF | 38.5 | 39.375 | 38.5 | 39.0 | 15000.0 |
| 2000-06-16 | EWW | ETF | 15.875 | 15.875 | 15.4375 | 15.5 | 57000.0 |
| 2000-06-16 | EWY | ETF | 19.875 | 19.875 | 19.5 | 19.5 | 22400.0 |
| 2000-06-16 | FCTR | ETF | 16.9375 | 16.9688 | 16.625 | 16.8125 | 99500.0 |
| 2000-06-16 | FMAR | ETF | 6.25 | 6.25 | 5.75 | 6.0 | 7900.0 |
| 2000-06-16 | GLDB | ETF | 6.8594 | 6.8594 | 6.6563 | 6.8125 | 40200.0 |
| 2000-06-16 | GSIG | ETF | 27.72 | 28.06 | 26.56 | 28.0 | 244800.0 |
| 2000-06-16 | IGLD | ETF | 881.25 | 887.5 | 843.75 | 850.0 | 344.0 |
| 2000-06-16 | IJH | ETF | 9.9188 | 9.9781 | 9.8938 | 9.9125 | 3023000.0 |
| 2000-06-16 | IJR | ETF | 17.4479 | 17.4479 | 17.2917 | 17.2917 | 72000.0 |
| 2000-06-16 | IVE | ETF | 61.5781 | 61.625 | 59.9531 | 60.0469 | 25400.0 |
| 2000-06-16 | IVV | ETF | 148.625 | 148.625 | 146.4688 | 147.0625 | 855900.0 |
| 2000-06-16 | IVW | ETF | 22.4688 | 22.5273 | 22.4023 | 22.5039 | 10400.0 |
| 2000-06-16 | IWB | ETF | 78.3125 | 78.3125 | 78.1562 | 78.1562 | 20200.0 |
| 2000-06-16 | IWD | ETF | 57.25 | 57.25 | 56.25 | 56.25 | 2100.0 |
| 2000-06-16 | IWF | ETF | 21.6289 | 21.707025 | 21.47655 | 21.484375 | 1128400.0 |
| 2000-06-16 | IWV | ETF | 80.75 | 80.75 | 80.75 | 80.75 | 600.0 |
| 2000-06-16 | IYE | ETF | 17.2033 | 17.26 | 17.1833 | 17.2567 | 5100.0 |
| 2000-06-16 | IYF | ETF | 36.75 | 36.75 | 35.6875 | 35.6875 | 6000.0 |
| 2000-06-16 | IYH | ETF | 12.576 | 12.718 | 12.576 | 12.632 | 47500.0 |
| 2000-06-16 | IYK | ETF | 13.8233 | 13.8233 | 13.7933 | 13.7933 | 1500.0 |
| 2000-06-16 | IYW | ETF | 31.5312 | 31.5703 | 31.125 | 31.4805 | 3200.0 |
| 2000-06-16 | IYY | ETF | 34.375 | 34.375 | 33.915 | 33.97 | 5600.0 |
| 2000-06-16 | IYZ | ETF | 63.5 | 63.5 | 62.375 | 62.375 | 700.0 |
| 2000-06-16 | KTEC | ETF | 8.84375 | 8.84375 | 8.6875 | 8.6875 | 5900.0 |
| 2000-06-16 | MDY | ETF | 91.0625 | 91.6875 | 90.5 | 91.0 | 631900.0 |
> showing 50 of 65 rows — these rows as CSV