PREVIEW / etf_daily / 2000-06-06
file: by_date/etf_daily/2000/2000-06-06.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-06 | SPY | ETF | 146.625 | 147.7812 | 145.9062 | 146.4688 | 4858900.0 |
| 2000-06-06 | QQQ | ETF | 93.1875 | 95.0 | 90.875 | 91.25 | 23200500.0 |
| 2000-06-06 | IWM | ETF | 51.8047 | 52.4062 | 51.3438 | 51.5 | 151800.0 |
| 2000-06-06 | DIA | ETF | 107.5 | 107.9844 | 107.0625 | 107.6406 | 392700.0 |
| 2000-06-06 | BBH | ETF | 51.3333 | 54.8333 | 51.3333 | 52.7292 | 2622300.0 |
| 2000-06-06 | BITS | ETF | 27.875 | 27.875 | 25.5 | 26.75 | 30075.0 |
| 2000-06-06 | CEF | ETF | 3.5 | 3.5625 | 3.4375 | 3.5625 | 25200.0 |
| 2000-06-06 | CHB | ETF | 5.94 | 5.94 | 5.81 | 5.88 | 64000.0 |
| 2000-06-06 | CNXT | ETF | 47.32 | 50.07 | 46.06 | 46.06 | 3705960.0 |
| 2000-06-06 | EWA | ETF | 9.9375 | 10.0 | 9.875 | 9.875 | 5000.0 |
| 2000-06-06 | EWC | ETF | 18.875 | 18.875 | 18.8125 | 18.875 | 6700.0 |
| 2000-06-06 | EWD | ETF | 33.9375 | 34.0625 | 33.9375 | 34.0 | 6600.0 |
| 2000-06-06 | EWG | ETF | 26.0 | 26.0 | 25.6875 | 25.8125 | 80000.0 |
| 2000-06-06 | EWH | ETF | 12.25 | 12.25 | 12.0 | 12.0625 | 15000.0 |
| 2000-06-06 | EWI | ETF | 51.0 | 51.0 | 50.75 | 50.75 | 450.0 |
| 2000-06-06 | EWJ | ETF | 60.0 | 60.5 | 60.0 | 60.25 | 36200.0 |
| 2000-06-06 | EWK | ETF | 13.625 | 13.625 | 13.3125 | 13.3125 | 3300.0 |
| 2000-06-06 | EWL | ETF | 15.875 | 16.0625 | 15.8125 | 16.0625 | 20200.0 |
| 2000-06-06 | EWM | ETF | 26.5 | 26.5 | 26.0 | 26.25 | 30550.0 |
| 2000-06-06 | EWN | ETF | 24.75 | 24.75 | 24.5 | 24.5 | 4000.0 |
| 2000-06-06 | EWO | ETF | 8.0 | 8.25 | 8.0 | 8.25 | 5200.0 |
| 2000-06-06 | EWP | ETF | 27.0 | 27.0 | 26.8125 | 26.875 | 8100.0 |
| 2000-06-06 | EWQ | ETF | 29.5625 | 29.625 | 29.3125 | 29.3125 | 23500.0 |
| 2000-06-06 | EWS | ETF | 14.75 | 14.875 | 14.5 | 14.75 | 10200.0 |
| 2000-06-06 | EWU | ETF | 39.75 | 39.75 | 39.5 | 39.5 | 14200.0 |
| 2000-06-06 | EWW | ETF | 16.375 | 16.375 | 15.75 | 15.75 | 113700.0 |
| 2000-06-06 | EWY | ETF | 21.125 | 21.125 | 20.75 | 20.75 | 10200.0 |
| 2000-06-06 | FCTR | ETF | 16.0 | 16.125 | 16.0 | 16.0625 | 47500.0 |
| 2000-06-06 | FMAR | ETF | 6.12 | 6.12 | 6.12 | 6.12 | 2000.0 |
| 2000-06-06 | GLDB | ETF | 6.0 | 6.0625 | 5.875 | 6.0625 | 32300.0 |
| 2000-06-06 | GSIG | ETF | 22.0 | 23.5 | 21.37 | 22.87 | 352600.0 |
| 2000-06-06 | IGLD | ETF | 950.0 | 975.0 | 943.75 | 962.5 | 832.0 |
| 2000-06-06 | IJH | ETF | 9.9406 | 10.0125 | 9.8875 | 9.8875 | 1195000.0 |
| 2000-06-06 | IJR | ETF | 17.5052 | 17.6016 | 17.3516 | 17.3516 | 87600.0 |
| 2000-06-06 | IVE | ETF | 61.8594 | 61.9219 | 61.8594 | 61.9219 | 4100.0 |
| 2000-06-06 | IVV | ETF | 146.4375 | 147.1875 | 145.6875 | 146.2188 | 209300.0 |
| 2000-06-06 | IVW | ETF | 21.8125 | 22.0195 | 21.7578 | 21.7578 | 21600.0 |
| 2000-06-06 | IWB | ETF | 77.9531 | 78.0469 | 77.5312 | 77.5312 | 3200.0 |
| 2000-06-06 | IWD | ETF | 57.6406 | 57.6406 | 57.5156 | 57.625 | 2100.0 |
| 2000-06-06 | IWF | ETF | 21.34375 | 21.417975 | 21.34375 | 21.40235 | 1600.0 |
| 2000-06-06 | IWV | ETF | 80.375 | 80.75 | 80.0 | 80.125 | 4200.0 |
| 2000-06-06 | IYF | ETF | 37.6875 | 37.6875 | 37.625 | 37.6875 | 1600.0 |
| 2000-06-06 | IYW | ETF | 31.461 | 31.625 | 30.9922 | 31.1172 | 2800.0 |
| 2000-06-06 | IYZ | ETF | 61.6875 | 62.4375 | 61.6875 | 62.3125 | 500.0 |
| 2000-06-06 | KTEC | ETF | 8.625 | 8.625 | 8.5625 | 8.625 | 10000.0 |
| 2000-06-06 | MDY | ETF | 91.4375 | 92.4844 | 90.375 | 90.5625 | 382400.0 |
| 2000-06-06 | MIG | ETF | 5.3125 | 5.375 | 5.3125 | 5.375 | 9200.0 |
| 2000-06-06 | PPH | ETF | 45.75 | 46.75 | 45.5625 | 46.75 | 103000.0 |
| 2000-06-06 | SFY | ETF | 23.375 | 23.8125 | 22.8125 | 23.4375 | 295600.0 |
| 2000-06-06 | SMH | ETF | 49.25 | 50.125 | 47.3125 | 47.3125 | 445600.0 |
> showing 50 of 61 rows — these rows as CSV