PREVIEW / etf_daily / 2000-05-26
file: by_date/etf_daily/2000/2000-05-26.parquet size: 7 KB rows: 51
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-05-26 | SPY | ETF | 138.8125 | 139.6875 | 137.3281 | 138.0 | 4814000.0 |
| 2000-05-26 | QQQ | ETF | 77.75 | 79.25 | 75.75 | 77.75 | 18203200.0 |
| 2000-05-26 | DIA | ETF | 103.4688 | 103.9844 | 102.5312 | 103.125 | 918800.0 |
| 2000-05-26 | BBH | ETF | 40.4167 | 41.3958 | 39.6875 | 40.9792 | 843600.0 |
| 2000-05-26 | BITS | ETF | 18.5 | 22.0 | 17.0 | 19.0 | 50750.0 |
| 2000-05-26 | BOSS | ETF | 14.2 | 14.5 | 14.2 | 14.5 | 100.0 |
| 2000-05-26 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.375 | 38800.0 |
| 2000-05-26 | CHB | ETF | 5.69 | 5.75 | 5.63 | 5.69 | 77000.0 |
| 2000-05-26 | CNXT | ETF | 34.25 | 35.13 | 33.56 | 34.44 | 4403080.0 |
| 2000-05-26 | EWA | ETF | 9.3125 | 9.3125 | 9.1875 | 9.1875 | 4600.0 |
| 2000-05-26 | EWC | ETF | 17.75 | 17.75 | 17.6875 | 17.6875 | 1700.0 |
| 2000-05-26 | EWD | ETF | 30.1875 | 30.75 | 30.1875 | 30.75 | 1000.0 |
| 2000-05-26 | EWG | ETF | 23.3125 | 23.9375 | 23.3125 | 23.9375 | 67900.0 |
| 2000-05-26 | EWH | ETF | 11.0 | 11.0 | 10.75 | 10.9375 | 17400.0 |
| 2000-05-26 | EWI | ETF | 47.25 | 48.25 | 47.25 | 48.0 | 21700.0 |
| 2000-05-26 | EWJ | ETF | 57.0 | 57.75 | 56.75 | 57.5 | 64875.0 |
| 2000-05-26 | EWK | ETF | 12.6875 | 13.0 | 12.6875 | 13.0 | 2100.0 |
| 2000-05-26 | EWL | ETF | 15.6875 | 15.875 | 15.5625 | 15.8125 | 26300.0 |
| 2000-05-26 | EWM | ETF | 26.5 | 26.75 | 26.25 | 26.5 | 33225.0 |
| 2000-05-26 | EWN | ETF | 23.0625 | 23.625 | 23.0625 | 23.625 | 5300.0 |
| 2000-05-26 | EWO | ETF | 7.625 | 7.75 | 7.5 | 7.75 | 8600.0 |
| 2000-05-26 | EWP | ETF | 25.25 | 25.5625 | 25.1875 | 25.3125 | 2100.0 |
| 2000-05-26 | EWQ | ETF | 26.0625 | 26.625 | 25.875 | 26.5625 | 35700.0 |
| 2000-05-26 | EWS | ETF | 12.875 | 13.25 | 12.875 | 12.875 | 11250.0 |
| 2000-05-26 | EWU | ETF | 36.75 | 37.25 | 36.75 | 37.25 | 14100.0 |
| 2000-05-26 | EWW | ETF | 14.1875 | 14.375 | 14.125 | 14.375 | 3700.0 |
| 2000-05-26 | EWY | ETF | 16.9375 | 17.0625 | 16.9375 | 16.9375 | 21000.0 |
| 2000-05-26 | FCTR | ETF | 14.875 | 15.125 | 14.875 | 15.0 | 9600.0 |
| 2000-05-26 | FMAR | ETF | 5.75 | 5.75 | 5.75 | 5.75 | 900.0 |
| 2000-05-26 | GLDB | ETF | 5.9375 | 6.0781 | 5.875 | 6.0 | 22100.0 |
| 2000-05-26 | GSIG | ETF | 17.81 | 18.5 | 17.31 | 18.19 | 117900.0 |
| 2000-05-26 | IGLD | ETF | 812.5 | 837.5 | 721.875 | 721.875 | 596.0 |
| 2000-05-26 | IVV | ETF | 138.4844 | 138.75 | 137.0 | 137.8438 | 237000.0 |
| 2000-05-26 | IWB | ETF | 73.125 | 73.125 | 72.4844 | 72.4844 | 1800.0 |
| 2000-05-26 | IYW | ETF | 26.5312 | 26.5312 | 26.4062 | 26.4062 | 1200.0 |
| 2000-05-26 | KTEC | ETF | 8.25 | 8.75 | 8.25 | 8.75 | 7300.0 |
| 2000-05-26 | MDY | ETF | 84.5625 | 84.9688 | 83.8125 | 84.375 | 310400.0 |
| 2000-05-26 | MIG | ETF | 5.125 | 5.125 | 5.125 | 5.125 | 400.0 |
| 2000-05-26 | PPH | ETF | 50.0312 | 50.3438 | 49.6562 | 50.0 | 61600.0 |
| 2000-05-26 | SFY | ETF | 23.125 | 24.8125 | 23.125 | 24.6875 | 230700.0 |
| 2000-05-26 | TDSC | ETF | 5.44 | 5.44 | 5.06 | 5.155 | 88000.0 |
| 2000-05-26 | TINY | ETF | 5.75 | 6.0 | 5.12 | 5.25 | 80900.0 |
| 2000-05-26 | XLB | ETF | 10.875 | 10.8828 | 10.75 | 10.7656 | 56000.0 |
| 2000-05-26 | XLE | ETF | 15.4688 | 15.6797 | 15.4453 | 15.4453 | 69200.0 |
| 2000-05-26 | XLF | ETF | 19.5979 | 19.8771 | 19.4963 | 19.6994 | 644675.0 |
| 2000-05-26 | XLI | ETF | 29.2344 | 29.2344 | 28.6719 | 28.7812 | 8900.0 |
| 2000-05-26 | XLK | ETF | 23.7812 | 23.8594 | 23.125 | 23.5938 | 287000.0 |
| 2000-05-26 | XLP | ETF | 24.2656 | 24.4531 | 24.0625 | 24.3125 | 35500.0 |
| 2000-05-26 | XLU | ETF | 13.9844 | 14.1094 | 13.8594 | 14.0312 | 229200.0 |
| 2000-05-26 | XLV | ETF | 28.5 | 28.5 | 27.9688 | 28.0312 | 139600.0 |
> showing 50 of 51 rows — these rows as CSV