PREVIEW / etf_daily / 2000-06-14
file: by_date/etf_daily/2000/2000-06-14.parquet size: 7 KB rows: 61
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-14 | SPY | ETF | 148.25 | 148.875 | 147.1875 | 147.8438 | 6420500.0 |
| 2000-06-14 | QQQ | ETF | 94.875 | 94.875 | 91.5 | 92.125 | 20274500.0 |
| 2000-06-14 | IWM | ETF | 51.8594 | 51.8594 | 51.1875 | 51.1875 | 43200.0 |
| 2000-06-14 | DIA | ETF | 106.9219 | 107.4844 | 106.4062 | 107.25 | 614900.0 |
| 2000-06-14 | BBH | ETF | 53.3333 | 53.3333 | 51.6875 | 51.9792 | 1261200.0 |
| 2000-06-14 | BITS | ETF | 31.0 | 31.0 | 28.0 | 29.5 | 21450.0 |
| 2000-06-14 | CEF | ETF | 3.4375 | 3.5625 | 3.375 | 3.5 | 105900.0 |
| 2000-06-14 | CHB | ETF | 6.13 | 6.19 | 6.06 | 6.19 | 43400.0 |
| 2000-06-14 | CNXT | ETF | 43.25 | 44.44 | 40.69 | 41.5 | 7490660.0 |
| 2000-06-14 | CSB | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 11000.0 |
| 2000-06-14 | EWA | ETF | 10.0625 | 10.0625 | 10.0625 | 10.0625 | 100.0 |
| 2000-06-14 | EWC | ETF | 19.5625 | 19.8125 | 19.5625 | 19.8125 | 1100.0 |
| 2000-06-14 | EWD | ETF | 32.6875 | 32.75 | 32.375 | 32.375 | 2900.0 |
| 2000-06-14 | EWG | ETF | 25.875 | 25.875 | 25.75 | 25.875 | 21500.0 |
| 2000-06-14 | EWH | ETF | 12.5 | 12.5 | 12.1875 | 12.3125 | 40900.0 |
| 2000-06-14 | EWI | ETF | 52.25 | 52.625 | 52.25 | 52.5 | 1900.0 |
| 2000-06-14 | EWJ | ETF | 58.5 | 58.75 | 58.0 | 58.5 | 68800.0 |
| 2000-06-14 | EWK | ETF | 13.6875 | 13.6875 | 13.6875 | 13.6875 | 500.0 |
| 2000-06-14 | EWL | ETF | 16.1875 | 16.4375 | 16.1875 | 16.4375 | 6600.0 |
| 2000-06-14 | EWM | ETF | 26.25 | 26.25 | 26.0 | 26.0 | 7125.0 |
| 2000-06-14 | EWN | ETF | 25.4375 | 25.5 | 25.25 | 25.4375 | 5100.0 |
| 2000-06-14 | EWO | ETF | 8.375 | 8.375 | 8.375 | 8.375 | 800.0 |
| 2000-06-14 | EWP | ETF | 26.875 | 27.125 | 26.875 | 27.0 | 800.0 |
| 2000-06-14 | EWQ | ETF | 29.5 | 29.75 | 29.4375 | 29.6875 | 19800.0 |
| 2000-06-14 | EWS | ETF | 14.875 | 14.875 | 14.625 | 14.875 | 16500.0 |
| 2000-06-14 | EWU | ETF | 39.0 | 39.25 | 38.75 | 39.25 | 11000.0 |
| 2000-06-14 | EWW | ETF | 16.0625 | 16.25 | 16.0 | 16.25 | 13200.0 |
| 2000-06-14 | EWY | ETF | 21.5 | 22.375 | 21.3125 | 21.625 | 67500.0 |
| 2000-06-14 | FCTR | ETF | 16.875 | 16.875 | 16.625 | 16.8125 | 58700.0 |
| 2000-06-14 | GLDB | ETF | 6.875 | 7.0 | 6.875 | 6.875 | 83800.0 |
| 2000-06-14 | GSIG | ETF | 29.75 | 30.25 | 25.25 | 26.0 | 1314900.0 |
| 2000-06-14 | IGLD | ETF | 928.125 | 956.25 | 906.25 | 912.5 | 323.0 |
| 2000-06-14 | IJH | ETF | 9.9281 | 9.9281 | 9.8 | 9.8 | 358000.0 |
| 2000-06-14 | IJR | ETF | 17.4583 | 17.4583 | 17.3802 | 17.4193 | 6600.0 |
| 2000-06-14 | IVE | ETF | 61.6875 | 61.9844 | 61.6875 | 61.7969 | 4500.0 |
| 2000-06-14 | IVV | ETF | 147.75 | 148.375 | 147.125 | 147.6562 | 353900.0 |
| 2000-06-14 | IVW | ETF | 22.1953 | 22.3594 | 22.1484 | 22.1836 | 119600.0 |
| 2000-06-14 | IWB | ETF | 78.7031 | 78.7031 | 78.0156 | 78.0156 | 1000.0 |
| 2000-06-14 | IWD | ETF | 57.7812 | 57.9219 | 57.625 | 57.6562 | 115000.0 |
| 2000-06-14 | IWF | ETF | 21.484375 | 21.484375 | 21.390625 | 21.390625 | 2400.0 |
| 2000-06-14 | IWV | ETF | 80.875 | 81.2656 | 80.875 | 80.9219 | 600.0 |
| 2000-06-14 | IYF | ETF | 37.7031 | 38.1875 | 37.7031 | 38.1875 | 2600.0 |
| 2000-06-14 | IYW | ETF | 31.6406 | 31.6875 | 31.0 | 31.0 | 22000.0 |
| 2000-06-14 | IYZ | ETF | 63.6875 | 63.6875 | 63.1875 | 63.1875 | 1100.0 |
| 2000-06-14 | KTEC | ETF | 8.84375 | 8.84375 | 8.6875 | 8.75 | 8700.0 |
| 2000-06-14 | MDY | ETF | 91.5 | 91.5312 | 89.75 | 89.75 | 1103300.0 |
| 2000-06-14 | MIG | ETF | 5.375 | 5.375 | 4.875 | 5.0625 | 28300.0 |
| 2000-06-14 | PPH | ETF | 48.7812 | 49.4375 | 48.7812 | 49.3438 | 159200.0 |
| 2000-06-14 | SFY | ETF | 29.0 | 29.3125 | 28.6875 | 29.25 | 150000.0 |
| 2000-06-14 | SMH | ETF | 49.4062 | 49.4375 | 47.2812 | 47.2812 | 195000.0 |
> showing 50 of 61 rows — these rows as CSV