PREVIEW / etf_daily / 2000-06-02
file: by_date/etf_daily/2000/2000-06-02.parquet size: 7 KB rows: 60
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-02 | SPY | ETF | 148.9375 | 149.0938 | 147.4844 | 147.8438 | 8962200.0 |
| 2000-06-02 | QQQ | ETF | 92.625 | 94.1094 | 91.875 | 93.625 | 32244100.0 |
| 2000-06-02 | IWM | ETF | 50.8594 | 51.1875 | 50.8594 | 51.1875 | 29400.0 |
| 2000-06-02 | DIA | ETF | 108.75 | 108.9688 | 107.5156 | 107.5156 | 751000.0 |
| 2000-06-02 | BBH | ETF | 47.3333 | 48.2708 | 46.8542 | 48.2708 | 1630500.0 |
| 2000-06-02 | BITS | ETF | 21.5 | 23.0 | 20.5 | 23.0 | 21050.0 |
| 2000-06-02 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 56000.0 |
| 2000-06-02 | CHB | ETF | 5.69 | 5.94 | 5.63 | 5.94 | 372800.0 |
| 2000-06-02 | CNXT | ETF | 48.59 | 53.48 | 48.59 | 50.85 | 9647330.0 |
| 2000-06-02 | CSB | ETF | 3.5 | 3.90000009536743 | 3.5 | 3.90000009536743 | 6000.0 |
| 2000-06-02 | EWA | ETF | 9.6875 | 9.9375 | 9.6875 | 9.9375 | 7000.0 |
| 2000-06-02 | EWC | ETF | 18.8125 | 19.25 | 18.8125 | 19.25 | 2700.0 |
| 2000-06-02 | EWD | ETF | 34.3125 | 34.3125 | 34.0625 | 34.3125 | 6500.0 |
| 2000-06-02 | EWG | ETF | 25.8125 | 26.0 | 25.625 | 25.8906 | 31700.0 |
| 2000-06-02 | EWH | ETF | 12.3125 | 12.625 | 12.125 | 12.625 | 115300.0 |
| 2000-06-02 | EWI | ETF | 50.0 | 51.625 | 50.0 | 51.375 | 2250.0 |
| 2000-06-02 | EWJ | ETF | 59.0 | 60.0 | 59.0 | 60.0 | 71475.0 |
| 2000-06-02 | EWK | ETF | 13.375 | 13.375 | 13.375 | 13.375 | 12500.0 |
| 2000-06-02 | EWL | ETF | 16.0 | 16.1875 | 16.0 | 16.0625 | 8200.0 |
| 2000-06-02 | EWM | ETF | 27.5 | 27.75 | 26.75 | 27.75 | 12075.0 |
| 2000-06-02 | EWN | ETF | 24.5 | 24.8125 | 24.5 | 24.75 | 1500.0 |
| 2000-06-02 | EWO | ETF | 7.875 | 8.0625 | 7.875 | 8.0625 | 7900.0 |
| 2000-06-02 | EWP | ETF | 27.5 | 27.5 | 27.0 | 27.25 | 10500.0 |
| 2000-06-02 | EWQ | ETF | 29.8125 | 29.9375 | 29.375 | 29.5625 | 19000.0 |
| 2000-06-02 | EWS | ETF | 14.5 | 14.625 | 14.125 | 14.5 | 34650.0 |
| 2000-06-02 | EWU | ETF | 39.75 | 39.75 | 39.0 | 39.5 | 43700.0 |
| 2000-06-02 | EWW | ETF | 16.4375 | 16.75 | 16.1875 | 16.5 | 326100.0 |
| 2000-06-02 | EWY | ETF | 20.1875 | 20.5 | 20.1875 | 20.5 | 10400.0 |
| 2000-06-02 | FCTR | ETF | 15.9063 | 16.125 | 15.875 | 16.0625 | 50200.0 |
| 2000-06-02 | FMAR | ETF | 6.1274 | 6.1274 | 6.1274 | 6.1274 | 3200.0 |
| 2000-06-02 | GLDB | ETF | 5.9375 | 6.4063 | 5.9375 | 6.1563 | 94500.0 |
| 2000-06-02 | GSIG | ETF | 21.75 | 23.5 | 21.44 | 23.06 | 882700.0 |
| 2000-06-02 | IGLD | ETF | 1012.5 | 1012.5 | 887.5 | 918.75 | 1662.0 |
| 2000-06-02 | IJH | ETF | 10.0594 | 10.0656 | 10.0094 | 10.025 | 418000.0 |
| 2000-06-02 | IJR | ETF | 17.2448 | 17.4531 | 17.2448 | 17.4531 | 1552200.0 |
| 2000-06-02 | IVE | ETF | 62.4688 | 62.5938 | 62.2812 | 62.2812 | 10000.0 |
| 2000-06-02 | IVV | ETF | 148.3125 | 148.7812 | 147.4688 | 147.9375 | 108400.0 |
| 2000-06-02 | IVW | ETF | 22.043 | 22.0469 | 21.875 | 22.0469 | 56000.0 |
| 2000-06-02 | IWB | ETF | 78.5938 | 78.7031 | 78.375 | 78.375 | 5700.0 |
| 2000-06-02 | IWD | ETF | 58.375 | 58.5156 | 58.0938 | 58.0938 | 14200.0 |
| 2000-06-02 | IWF | ETF | 21.3789 | 21.47265 | 21.3086 | 21.47265 | 32000.0 |
| 2000-06-02 | IWV | ETF | 81.25 | 81.25 | 80.9688 | 80.9844 | 19100.0 |
| 2000-06-02 | IYF | ETF | 38.4531 | 39.2031 | 38.4531 | 39.1562 | 4400.0 |
| 2000-06-02 | IYW | ETF | 31.25 | 31.3125 | 31.1172 | 31.1875 | 13600.0 |
| 2000-06-02 | IYZ | ETF | 60.5625 | 60.5625 | 60.5625 | 60.5625 | 800.0 |
| 2000-06-02 | KTEC | ETF | 8.53125 | 8.53125 | 8.53125 | 8.53125 | 400.0 |
| 2000-06-02 | MDY | ETF | 92.4375 | 93.0 | 91.9375 | 92.5 | 1722600.0 |
| 2000-06-02 | MIG | ETF | 5.25 | 5.25 | 5.125 | 5.25 | 14500.0 |
| 2000-06-02 | PPH | ETF | 47.8125 | 47.875 | 45.875 | 46.25 | 287600.0 |
| 2000-06-02 | SFY | ETF | 25.125 | 25.1875 | 23.4375 | 23.5625 | 124200.0 |
> showing 50 of 60 rows — these rows as CSV