PREVIEW / etf_daily / 2000-07-13
file: by_date/etf_daily/2000/2000-07-13.parquet size: 7 KB rows: 71
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-07-13 | SPY | ETF | 149.9844 | 150.375 | 149.1875 | 149.7812 | 5356000.0 |
| 2000-07-13 | QQQ | ETF | 97.9375 | 99.75 | 97.125 | 98.5 | 19566700.0 |
| 2000-07-13 | IWM | ETF | 54.1406 | 54.2656 | 54.0 | 54.2656 | 102600.0 |
| 2000-07-13 | DIA | ETF | 108.5312 | 108.6875 | 107.625 | 108.0 | 1176200.0 |
| 2000-07-13 | BBH | ETF | 64.875 | 65.1458 | 60.75 | 60.8542 | 2671200.0 |
| 2000-07-13 | BITS | ETF | 19.875 | 21.0 | 19.75 | 20.5 | 19950.0 |
| 2000-07-13 | CEF | ETF | 3.375 | 3.4375 | 3.375 | 3.4375 | 84700.0 |
| 2000-07-13 | CHB | ETF | 5.31 | 5.38 | 5.25 | 5.31 | 23000.0 |
| 2000-07-13 | CNXT | ETF | 54.0 | 56.38 | 50.56 | 52.06 | 5578980.0 |
| 2000-07-13 | CSB | ETF | 3.20000004768372 | 3.20000004768372 | 3.20000004768372 | 3.20000004768372 | 1400.0 |
| 2000-07-13 | EWA | ETF | 10.625 | 10.8125 | 10.5 | 10.625 | 45900.0 |
| 2000-07-13 | EWC | ETF | 20.5 | 20.75 | 20.5 | 20.625 | 29500.0 |
| 2000-07-13 | EWD | ETF | 32.375 | 32.375 | 31.8125 | 32.0625 | 3400.0 |
| 2000-07-13 | EWG | ETF | 24.4375 | 24.625 | 24.375 | 24.5625 | 47100.0 |
| 2000-07-13 | EWH | ETF | 13.5 | 13.5625 | 13.375 | 13.5 | 25500.0 |
| 2000-07-13 | EWI | ETF | 52.75 | 53.0 | 52.75 | 53.0 | 2200.0 |
| 2000-07-13 | EWJ | ETF | 59.25 | 59.5 | 58.25 | 59.0 | 171175.0 |
| 2000-07-13 | EWK | ETF | 13.9375 | 14.0625 | 13.75 | 14.0 | 8600.0 |
| 2000-07-13 | EWL | ETF | 16.375 | 16.375 | 16.0625 | 16.3125 | 4600.0 |
| 2000-07-13 | EWM | ETF | 26.25 | 27.0 | 26.0 | 26.75 | 32400.0 |
| 2000-07-13 | EWN | ETF | 25.0 | 25.0625 | 25.0 | 25.0 | 16400.0 |
| 2000-07-13 | EWO | ETF | 7.75 | 7.8125 | 7.6875 | 7.6875 | 4200.0 |
| 2000-07-13 | EWP | ETF | 26.5625 | 26.5625 | 26.375 | 26.5625 | 1100.0 |
| 2000-07-13 | EWQ | ETF | 29.0625 | 29.0625 | 28.6875 | 28.9375 | 164000.0 |
| 2000-07-13 | EWS | ETF | 15.375 | 15.375 | 15.125 | 15.25 | 37700.0 |
| 2000-07-13 | EWT | ETF | 36.75 | 37.375 | 36.75 | 37.375 | 700.0 |
| 2000-07-13 | EWU | ETF | 39.0 | 39.375 | 39.0 | 39.25 | 19600.0 |
| 2000-07-13 | EWW | ETF | 18.5625 | 18.6875 | 18.25 | 18.4375 | 26100.0 |
| 2000-07-13 | EWY | ETF | 22.0 | 22.0 | 21.6875 | 21.9375 | 13300.0 |
| 2000-07-13 | FCTR | ETF | 16.0 | 16.75 | 15.1875 | 16.3125 | 48100.0 |
| 2000-07-13 | FMAR | ETF | 5.5 | 5.6233 | 5.25 | 5.5 | 5600.0 |
| 2000-07-13 | GLDB | ETF | 5.0 | 5.125 | 4.875 | 5.0625 | 149400.0 |
| 2000-07-13 | GSIG | ETF | 37.62 | 38.37 | 35.62 | 36.25 | 952200.0 |
| 2000-07-13 | IDU | ETF | 34.8438 | 34.8438 | 34.8125 | 34.8125 | 1000.0 |
| 2000-07-13 | IGLD | ETF | 1037.5 | 1037.5 | 981.25 | 1012.5 | 1454.0 |
| 2000-07-13 | IJH | ETF | 10.325 | 10.325 | 10.2891 | 10.2953 | 463000.0 |
| 2000-07-13 | IJR | ETF | 18.4011 | 18.4011 | 18.2761 | 18.3203 | 205200.0 |
| 2000-07-13 | IVE | ETF | 60.9219 | 61.1094 | 60.8906 | 60.9531 | 3800.0 |
| 2000-07-13 | IVV | ETF | 149.7188 | 150.2812 | 149.1406 | 149.5938 | 971600.0 |
| 2000-07-13 | IVW | ETF | 22.957 | 23.0898 | 22.875 | 22.9492 | 12000.0 |
| 2000-07-13 | IWB | ETF | 79.5625 | 79.6875 | 79.5625 | 79.6719 | 29700.0 |
| 2000-07-13 | IWD | ETF | 56.125 | 56.125 | 55.6562 | 55.875 | 32300.0 |
| 2000-07-13 | IWF | ETF | 22.34375 | 22.542975 | 22.27735 | 22.41405 | 38800.0 |
| 2000-07-13 | IWV | ETF | 82.4375 | 82.5938 | 82.0469 | 82.0469 | 3300.0 |
| 2000-07-13 | IYE | ETF | 16.3021 | 16.3021 | 15.9896 | 16.0104 | 6000.0 |
| 2000-07-13 | IYF | ETF | 37.8906 | 37.8906 | 37.5 | 37.625 | 5000.0 |
| 2000-07-13 | IYG | ETF | 28.8333 | 28.8333 | 28.6042 | 28.8125 | 8700.0 |
| 2000-07-13 | IYH | ETF | 13.35 | 13.35 | 12.95 | 12.95 | 66500.0 |
| 2000-07-13 | IYK | ETF | 13.5104 | 13.5833 | 13.5104 | 13.5833 | 1800.0 |
| 2000-07-13 | IYR | ETF | 36.0312 | 36.0312 | 36.0312 | 36.0312 | 4000.0 |
> showing 50 of 71 rows — these rows as CSV