PREVIEW / etf_daily / 2000-06-15
file: by_date/etf_daily/2000/2000-06-15.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-15 | SPY | ETF | 148.125 | 148.75 | 146.8438 | 148.1562 | 5881200.0 |
| 2000-06-15 | QQQ | ETF | 91.875 | 93.875 | 90.875 | 93.75 | 18807800.0 |
| 2000-06-15 | IWM | ETF | 50.875 | 51.25 | 50.3828 | 51.25 | 26800.0 |
| 2000-06-15 | DIA | ETF | 107.125 | 107.75 | 106.6406 | 106.8438 | 647700.0 |
| 2000-06-15 | BBH | ETF | 51.6667 | 52.7083 | 51.25 | 52.6667 | 1107000.0 |
| 2000-06-15 | BITS | ETF | 28.75 | 30.0 | 27.5 | 30.0 | 10325.0 |
| 2000-06-15 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.4375 | 29300.0 |
| 2000-06-15 | CHB | ETF | 6.13 | 6.19 | 5.75 | 5.88 | 236600.0 |
| 2000-06-15 | CNXT | ETF | 46.13 | 50.25 | 45.0 | 48.0 | 22200840.0 |
| 2000-06-15 | CSB | ETF | 3.90000009536743 | 4.09999990463257 | 3.90000009536743 | 4.09999990463257 | 5900.0 |
| 2000-06-15 | EWA | ETF | 10.125 | 10.25 | 10.125 | 10.25 | 42300.0 |
| 2000-06-15 | EWC | ETF | 19.6875 | 19.75 | 19.625 | 19.75 | 14800.0 |
| 2000-06-15 | EWD | ETF | 32.125 | 32.125 | 31.5625 | 31.625 | 12000.0 |
| 2000-06-15 | EWG | ETF | 25.75 | 25.75 | 25.5 | 25.625 | 27300.0 |
| 2000-06-15 | EWH | ETF | 12.625 | 12.625 | 12.3125 | 12.375 | 62500.0 |
| 2000-06-15 | EWI | ETF | 52.125 | 52.125 | 51.625 | 51.875 | 3200.0 |
| 2000-06-15 | EWJ | ETF | 57.75 | 57.75 | 56.75 | 57.5 | 60250.0 |
| 2000-06-15 | EWK | ETF | 13.375 | 13.375 | 13.375 | 13.375 | 1700.0 |
| 2000-06-15 | EWL | ETF | 16.375 | 16.375 | 16.125 | 16.125 | 68400.0 |
| 2000-06-15 | EWM | ETF | 26.0 | 26.5 | 26.0 | 26.0 | 19950.0 |
| 2000-06-15 | EWN | ETF | 25.3125 | 25.5 | 25.1875 | 25.1875 | 108200.0 |
| 2000-06-15 | EWO | ETF | 8.25 | 8.25 | 8.0625 | 8.0625 | 2100.0 |
| 2000-06-15 | EWP | ETF | 26.8125 | 26.8125 | 26.5625 | 26.8125 | 7800.0 |
| 2000-06-15 | EWQ | ETF | 29.4375 | 29.4375 | 29.0 | 29.125 | 28200.0 |
| 2000-06-15 | EWS | ETF | 15.0 | 15.25 | 14.875 | 15.0 | 44900.0 |
| 2000-06-15 | EWU | ETF | 39.25 | 39.25 | 39.0 | 39.25 | 10200.0 |
| 2000-06-15 | EWW | ETF | 16.0 | 16.0625 | 15.9375 | 16.0 | 13200.0 |
| 2000-06-15 | EWY | ETF | 20.0 | 20.25 | 20.0 | 20.0 | 5300.0 |
| 2000-06-15 | FCTR | ETF | 16.625 | 16.75 | 16.5625 | 16.75 | 72900.0 |
| 2000-06-15 | FMAR | ETF | 6.38 | 6.7517 | 6.3783 | 6.38 | 2700.0 |
| 2000-06-15 | GLDB | ETF | 6.8125 | 6.875 | 6.6563 | 6.75 | 35400.0 |
| 2000-06-15 | GSIG | ETF | 25.31 | 28.5 | 25.12 | 27.5 | 868500.0 |
| 2000-06-15 | IGLD | ETF | 906.25 | 931.25 | 850.0 | 887.5 | 323.0 |
| 2000-06-15 | IJH | ETF | 9.8 | 9.95 | 9.775 | 9.95 | 2253000.0 |
| 2000-06-15 | IJR | ETF | 17.3333 | 17.3333 | 17.1667 | 17.3333 | 58200.0 |
| 2000-06-15 | IVE | ETF | 61.5938 | 61.5938 | 60.8906 | 61.0781 | 5000.0 |
| 2000-06-15 | IVV | ETF | 147.6875 | 148.25 | 146.6094 | 147.6562 | 338500.0 |
| 2000-06-15 | IVW | ETF | 22.1914 | 22.5078 | 22.1914 | 22.4219 | 223200.0 |
| 2000-06-15 | IWD | ETF | 57.8438 | 57.8438 | 57.0625 | 57.0938 | 30800.0 |
| 2000-06-15 | IWF | ETF | 21.375 | 21.375 | 21.375 | 21.375 | 10400.0 |
| 2000-06-15 | IWV | ETF | 80.5938 | 81.0469 | 80.5938 | 80.8906 | 1400.0 |
| 2000-06-15 | IYF | ETF | 37.4297 | 37.4297 | 36.9062 | 36.9375 | 4600.0 |
| 2000-06-15 | IYW | ETF | 31.0156 | 31.5039 | 30.875 | 31.4297 | 8800.0 |
| 2000-06-15 | IYZ | ETF | 63.0 | 63.0 | 62.4688 | 62.4688 | 2600.0 |
| 2000-06-15 | KTEC | ETF | 8.6875 | 8.75 | 8.6875 | 8.75 | 5200.0 |
| 2000-06-15 | MDY | ETF | 90.1562 | 91.4375 | 89.5312 | 91.2188 | 1283400.0 |
| 2000-06-15 | MIG | ETF | 5.0625 | 5.0625 | 5.0625 | 5.0625 | 12000.0 |
| 2000-06-15 | PPH | ETF | 49.125 | 49.9062 | 49.0938 | 49.4062 | 82800.0 |
| 2000-06-15 | SFY | ETF | 29.0 | 29.5625 | 28.5 | 28.5625 | 163700.0 |
| 2000-06-15 | SMH | ETF | 47.375 | 48.3438 | 46.625 | 47.6875 | 217800.0 |
> showing 50 of 61 rows — these rows as CSV