PREVIEW / etf_daily / 2000-06-05
file: by_date/etf_daily/2000/2000-06-05.parquet size: 7 KB rows: 62
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-05 | SPY | ETF | 147.4688 | 148.2188 | 146.875 | 147.125 | 6998100.0 |
| 2000-06-05 | QQQ | ETF | 92.25 | 95.3125 | 91.875 | 93.8594 | 23784300.0 |
| 2000-06-05 | IWM | ETF | 51.0625 | 51.5625 | 50.9375 | 51.0 | 48400.0 |
| 2000-06-05 | DIA | ETF | 107.375 | 108.7344 | 107.375 | 108.25 | 750600.0 |
| 2000-06-05 | BBH | ETF | 48.8333 | 51.4792 | 48.8333 | 51.0208 | 2729400.0 |
| 2000-06-05 | BITS | ETF | 23.0 | 28.0 | 22.875 | 27.25 | 40250.0 |
| 2000-06-05 | BOSS | ETF | 15.5 | 15.5 | 15.5 | 15.5 | 800.0 |
| 2000-06-05 | CEF | ETF | 3.5 | 3.625 | 3.4375 | 3.5 | 69500.0 |
| 2000-06-05 | CHB | ETF | 5.94 | 5.94 | 5.75 | 5.94 | 93700.0 |
| 2000-06-05 | CNXT | ETF | 50.38 | 51.38 | 46.88 | 47.38 | 4491350.0 |
| 2000-06-05 | EWA | ETF | 9.9375 | 9.9375 | 9.75 | 9.9375 | 8000.0 |
| 2000-06-05 | EWC | ETF | 19.25 | 19.25 | 18.875 | 19.0 | 9500.0 |
| 2000-06-05 | EWD | ETF | 33.875 | 34.0 | 33.875 | 33.9375 | 2100.0 |
| 2000-06-05 | EWG | ETF | 25.6875 | 25.9375 | 25.6875 | 25.75 | 65800.0 |
| 2000-06-05 | EWH | ETF | 12.375 | 12.375 | 12.125 | 12.3125 | 64600.0 |
| 2000-06-05 | EWI | ETF | 50.875 | 51.125 | 50.5 | 51.125 | 1150.0 |
| 2000-06-05 | EWJ | ETF | 60.25 | 60.25 | 59.75 | 60.0 | 74950.0 |
| 2000-06-05 | EWK | ETF | 13.4375 | 13.4375 | 13.1875 | 13.4375 | 2400.0 |
| 2000-06-05 | EWL | ETF | 15.875 | 15.875 | 15.875 | 15.875 | 3200.0 |
| 2000-06-05 | EWM | ETF | 27.0 | 27.0 | 26.5 | 26.5 | 4750.0 |
| 2000-06-05 | EWN | ETF | 24.75 | 24.75 | 24.25 | 24.625 | 4200.0 |
| 2000-06-05 | EWO | ETF | 8.0625 | 8.125 | 7.875 | 7.875 | 3100.0 |
| 2000-06-05 | EWP | ETF | 28.0625 | 28.0625 | 26.875 | 27.125 | 1400.0 |
| 2000-06-05 | EWQ | ETF | 29.1875 | 29.625 | 29.1875 | 29.625 | 40800.0 |
| 2000-06-05 | EWS | ETF | 14.625 | 14.75 | 14.375 | 14.625 | 41250.0 |
| 2000-06-05 | EWU | ETF | 39.5 | 39.875 | 39.25 | 39.875 | 24100.0 |
| 2000-06-05 | EWW | ETF | 16.4375 | 16.625 | 16.3125 | 16.4375 | 15600.0 |
| 2000-06-05 | EWY | ETF | 21.1875 | 21.1875 | 21.0 | 21.0 | 3100.0 |
| 2000-06-05 | FCTR | ETF | 16.0625 | 16.125 | 16.0 | 16.0 | 34600.0 |
| 2000-06-05 | FMAR | ETF | 6.0 | 6.5 | 6.0 | 6.25 | 3800.0 |
| 2000-06-05 | GLDB | ETF | 6.3438 | 6.3438 | 5.875 | 6.125 | 18900.0 |
| 2000-06-05 | GSIG | ETF | 22.75 | 23.0 | 21.25 | 22.37 | 358000.0 |
| 2000-06-05 | IGLD | ETF | 943.75 | 943.75 | 918.75 | 931.25 | 1316.0 |
| 2000-06-05 | IJH | ETF | 9.9688 | 9.9703 | 9.9406 | 9.9484 | 659000.0 |
| 2000-06-05 | IJR | ETF | 17.4688 | 17.513 | 17.4583 | 17.513 | 348000.0 |
| 2000-06-05 | IVE | ETF | 62.3438 | 62.3438 | 61.9219 | 62.0 | 15500.0 |
| 2000-06-05 | IVV | ETF | 147.0 | 147.6562 | 146.6875 | 146.9688 | 192100.0 |
| 2000-06-05 | IVW | ETF | 21.9727 | 22.0312 | 21.9336 | 21.9375 | 90800.0 |
| 2000-06-05 | IWB | ETF | 78.0781 | 78.3438 | 78.0 | 78.0 | 21000.0 |
| 2000-06-05 | IWD | ETF | 58.0 | 58.0 | 57.7188 | 57.7812 | 1600.0 |
| 2000-06-05 | IWF | ETF | 21.28125 | 21.5 | 21.28125 | 21.34765 | 81600.0 |
| 2000-06-05 | IWV | ETF | 80.7188 | 80.7188 | 80.5625 | 80.5625 | 500.0 |
| 2000-06-05 | IYF | ETF | 39.0625 | 39.0625 | 38.7422 | 38.7422 | 2400.0 |
| 2000-06-05 | IYW | ETF | 30.9375 | 31.9062 | 30.8906 | 31.5312 | 77200.0 |
| 2000-06-05 | IYZ | ETF | 61.5625 | 61.875 | 61.5 | 61.5 | 800.0 |
| 2000-06-05 | KTEC | ETF | 8.5625 | 8.625 | 8.53125 | 8.625 | 27700.0 |
| 2000-06-05 | MDY | ETF | 92.0625 | 93.125 | 90.75 | 91.25 | 966700.0 |
| 2000-06-05 | MIG | ETF | 5.25 | 5.3125 | 5.0625 | 5.3125 | 16200.0 |
| 2000-06-05 | PPH | ETF | 45.9375 | 46.5 | 45.375 | 46.0312 | 128000.0 |
| 2000-06-05 | SFY | ETF | 22.75 | 23.5 | 21.375 | 23.1875 | 212600.0 |
> showing 50 of 62 rows — these rows as CSV