PREVIEW / etf_daily / 2000-06-08
file: by_date/etf_daily/2000/2000-06-08.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-08 | SPY | ETF | 147.5 | 147.75 | 146.0625 | 146.9062 | 5723100.0 |
| 2000-06-08 | QQQ | ETF | 94.625 | 94.875 | 91.625 | 93.25 | 19313800.0 |
| 2000-06-08 | IWM | ETF | 52.125 | 52.125 | 51.4375 | 51.4375 | 91400.0 |
| 2000-06-08 | DIA | ETF | 107.7188 | 107.7188 | 106.375 | 106.7812 | 847900.0 |
| 2000-06-08 | BBH | ETF | 53.5 | 53.5 | 50.8333 | 51.2917 | 1201200.0 |
| 2000-06-08 | BITS | ETF | 31.25 | 31.25 | 29.0 | 29.5 | 20400.0 |
| 2000-06-08 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.4375 | 9800.0 |
| 2000-06-08 | CHB | ETF | 5.94 | 6.0 | 5.88 | 5.88 | 122600.0 |
| 2000-06-08 | CNXT | ETF | 48.25 | 48.5 | 43.88 | 45.44 | 4600290.0 |
| 2000-06-08 | EWA | ETF | 9.9375 | 10.0625 | 9.9375 | 10.0625 | 4700.0 |
| 2000-06-08 | EWC | ETF | 18.875 | 19.125 | 18.875 | 19.0 | 53200.0 |
| 2000-06-08 | EWD | ETF | 33.6875 | 33.75 | 33.5 | 33.5 | 800.0 |
| 2000-06-08 | EWG | ETF | 25.75 | 25.75 | 25.25 | 25.4375 | 76300.0 |
| 2000-06-08 | EWH | ETF | 12.25 | 12.3125 | 12.125 | 12.125 | 9500.0 |
| 2000-06-08 | EWI | ETF | 51.625 | 51.625 | 50.875 | 50.875 | 5450.0 |
| 2000-06-08 | EWJ | ETF | 60.5 | 60.5 | 60.0 | 60.0 | 72525.0 |
| 2000-06-08 | EWK | ETF | 13.375 | 13.375 | 13.125 | 13.125 | 900.0 |
| 2000-06-08 | EWL | ETF | 16.375 | 16.375 | 16.125 | 16.1875 | 11700.0 |
| 2000-06-08 | EWM | ETF | 25.75 | 26.25 | 25.5 | 26.25 | 22800.0 |
| 2000-06-08 | EWN | ETF | 25.0625 | 25.0625 | 24.8125 | 24.9375 | 1700.0 |
| 2000-06-08 | EWO | ETF | 8.25 | 8.375 | 8.25 | 8.375 | 7100.0 |
| 2000-06-08 | EWP | ETF | 26.8125 | 26.875 | 26.8125 | 26.875 | 600.0 |
| 2000-06-08 | EWQ | ETF | 29.1875 | 29.3125 | 28.8125 | 28.875 | 19300.0 |
| 2000-06-08 | EWS | ETF | 14.875 | 15.375 | 14.875 | 15.125 | 37600.0 |
| 2000-06-08 | EWU | ETF | 39.375 | 39.375 | 38.875 | 39.125 | 6050.0 |
| 2000-06-08 | EWW | ETF | 15.5625 | 15.625 | 15.1875 | 15.5625 | 15500.0 |
| 2000-06-08 | EWY | ETF | 20.4375 | 20.4375 | 20.25 | 20.25 | 12000.0 |
| 2000-06-08 | FCTR | ETF | 16.0 | 16.75 | 15.625 | 16.75 | 20400.0 |
| 2000-06-08 | FMAR | ETF | 6.75 | 6.7526 | 6.38 | 6.38 | 1400.0 |
| 2000-06-08 | GLDB | ETF | 6.125 | 6.125 | 5.75 | 6.0625 | 56700.0 |
| 2000-06-08 | GSIG | ETF | 23.09 | 25.12 | 22.94 | 24.56 | 1685600.0 |
| 2000-06-08 | IGLD | ETF | 959.375 | 987.5 | 950.0 | 975.0 | 532.0 |
| 2000-06-08 | IJH | ETF | 9.8906 | 9.9016 | 9.8312 | 9.8312 | 3017000.0 |
| 2000-06-08 | IJR | ETF | 17.4792 | 17.4792 | 17.3438 | 17.3438 | 1222200.0 |
| 2000-06-08 | IVE | ETF | 61.875 | 61.875 | 61.3125 | 61.4375 | 16000.0 |
| 2000-06-08 | IVV | ETF | 147.8125 | 147.8125 | 145.9375 | 146.6562 | 248400.0 |
| 2000-06-08 | IVW | ETF | 22.0938 | 22.0938 | 21.9219 | 21.9688 | 39200.0 |
| 2000-06-08 | IWB | ETF | 78.0312 | 78.0312 | 77.5 | 77.5 | 600.0 |
| 2000-06-08 | IWD | ETF | 57.7812 | 57.7812 | 57.3438 | 57.3438 | 19200.0 |
| 2000-06-08 | IWF | ETF | 21.40625 | 21.41015 | 21.1875 | 21.1875 | 53600.0 |
| 2000-06-08 | IWV | ETF | 80.875 | 80.875 | 80.4219 | 80.4531 | 1000.0 |
| 2000-06-08 | IYF | ETF | 38.1641 | 38.1641 | 37.7812 | 37.7812 | 2600.0 |
| 2000-06-08 | IYW | ETF | 31.9062 | 31.9062 | 31.4297 | 31.4297 | 9600.0 |
| 2000-06-08 | IYZ | ETF | 62.375 | 62.6875 | 62.3125 | 62.4375 | 1500.0 |
| 2000-06-08 | KTEC | ETF | 8.5 | 8.625 | 8.5 | 8.5625 | 7200.0 |
| 2000-06-08 | MDY | ETF | 91.75 | 91.75 | 90.0 | 90.375 | 721500.0 |
| 2000-06-08 | MIG | ETF | 5.5 | 5.5 | 5.4375 | 5.5 | 8300.0 |
| 2000-06-08 | PPH | ETF | 46.625 | 46.8125 | 46.25 | 46.625 | 162200.0 |
| 2000-06-08 | SFY | ETF | 24.4375 | 25.8125 | 24.3125 | 25.6875 | 254300.0 |
| 2000-06-08 | SMH | ETF | 49.4062 | 49.4375 | 47.9062 | 48.3125 | 390400.0 |
> showing 50 of 61 rows — these rows as CSV