PREVIEW / etf_daily / 2000-06-22
file: by_date/etf_daily/2000/2000-06-22.parquet size: 7 KB rows: 68
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-22 | SPY | ETF | 147.5625 | 147.6875 | 145.0 | 145.625 | 7490500.0 |
| 2000-06-22 | QQQ | ETF | 98.625 | 99.0 | 94.5 | 95.25 | 21526700.0 |
| 2000-06-22 | IWM | ETF | 53.0 | 53.0 | 51.25 | 51.25 | 139600.0 |
| 2000-06-22 | DIA | ETF | 104.5938 | 105.0312 | 103.375 | 104.0 | 888200.0 |
| 2000-06-22 | BBH | ETF | 60.9167 | 60.9167 | 58.3333 | 58.3333 | 2025000.0 |
| 2000-06-22 | BITS | ETF | 29.75 | 30.0 | 27.0 | 29.25 | 12450.0 |
| 2000-06-22 | CEF | ETF | 3.4375 | 3.5 | 3.375 | 3.4375 | 52200.0 |
| 2000-06-22 | CHB | ETF | 4.94 | 4.94 | 4.63 | 4.75 | 105900.0 |
| 2000-06-22 | CNXT | ETF | 57.88 | 60.81 | 56.88 | 57.13 | 7011640.0 |
| 2000-06-22 | EWA | ETF | 10.3125 | 10.3125 | 10.25 | 10.25 | 14400.0 |
| 2000-06-22 | EWC | ETF | 19.75 | 19.875 | 19.625 | 19.75 | 7700.0 |
| 2000-06-22 | EWD | ETF | 31.625 | 31.625 | 31.0 | 31.0 | 2300.0 |
| 2000-06-22 | EWG | ETF | 24.5 | 24.5 | 24.25 | 24.375 | 127400.0 |
| 2000-06-22 | EWH | ETF | 12.3125 | 12.3125 | 12.0625 | 12.0625 | 27700.0 |
| 2000-06-22 | EWI | ETF | 49.875 | 49.875 | 49.375 | 49.375 | 1600.0 |
| 2000-06-22 | EWJ | ETF | 60.75 | 60.75 | 60.25 | 60.5 | 42175.0 |
| 2000-06-22 | EWK | ETF | 13.125 | 13.125 | 13.125 | 13.125 | 1600.0 |
| 2000-06-22 | EWL | ETF | 16.0 | 16.0 | 15.5625 | 15.5625 | 4300.0 |
| 2000-06-22 | EWM | ETF | 25.0 | 25.25 | 24.75 | 25.0 | 10125.0 |
| 2000-06-22 | EWN | ETF | 24.8125 | 24.8125 | 24.625 | 24.75 | 16000.0 |
| 2000-06-22 | EWO | ETF | 7.8125 | 7.9375 | 7.8125 | 7.9375 | 2200.0 |
| 2000-06-22 | EWP | ETF | 25.75 | 25.75 | 25.1875 | 25.1875 | 78300.0 |
| 2000-06-22 | EWQ | ETF | 28.75 | 28.8125 | 28.5 | 28.625 | 113600.0 |
| 2000-06-22 | EWS | ETF | 14.625 | 14.625 | 14.5 | 14.5 | 13300.0 |
| 2000-06-22 | EWU | ETF | 39.25 | 39.25 | 38.375 | 38.8438 | 11750.0 |
| 2000-06-22 | EWW | ETF | 15.9375 | 15.9375 | 15.375 | 15.5 | 18200.0 |
| 2000-06-22 | EWY | ETF | 20.375 | 20.5 | 20.125 | 20.125 | 17000.0 |
| 2000-06-22 | FCTR | ETF | 16.9375 | 17.0 | 16.8125 | 16.8125 | 31500.0 |
| 2000-06-22 | FMAR | ETF | 5.75 | 5.88 | 5.75 | 5.88 | 6400.0 |
| 2000-06-22 | GLDB | ETF | 6.375 | 6.6875 | 6.25 | 6.5625 | 73700.0 |
| 2000-06-22 | GSIG | ETF | 28.69 | 30.25 | 28.06 | 28.25 | 1276200.0 |
| 2000-06-22 | IDU | ETF | 34.25 | 34.25 | 34.25 | 34.25 | 400.0 |
| 2000-06-22 | IGLD | ETF | 881.25 | 912.5 | 881.25 | 893.75 | 456.0 |
| 2000-06-22 | IJH | ETF | 9.9719 | 10.0078 | 9.8312 | 9.8312 | 2304000.0 |
| 2000-06-22 | IJR | ETF | 17.5625 | 17.5625 | 17.4323 | 17.4323 | 2400.0 |
| 2000-06-22 | IVE | ETF | 59.8281 | 59.8281 | 59.1875 | 59.3438 | 4900.0 |
| 2000-06-22 | IVV | ETF | 147.4375 | 147.4375 | 145.0 | 145.4375 | 182900.0 |
| 2000-06-22 | IVW | ETF | 22.7344 | 22.7344 | 22.2656 | 22.2891 | 45200.0 |
| 2000-06-22 | IWB | ETF | 78.3281 | 78.3281 | 77.0 | 77.0 | 13600.0 |
| 2000-06-22 | IWD | ETF | 56.0625 | 56.0625 | 55.5469 | 55.5938 | 8200.0 |
| 2000-06-22 | IWF | ETF | 21.89845 | 21.89845 | 21.480475 | 21.480475 | 29200.0 |
| 2000-06-22 | IWV | ETF | 80.4062 | 80.4375 | 80.0 | 80.0 | 1900.0 |
| 2000-06-22 | IYE | ETF | 17.3073 | 17.3073 | 16.8385 | 16.8438 | 6300.0 |
| 2000-06-22 | IYF | ETF | 35.4844 | 35.4844 | 35.2344 | 35.3906 | 600.0 |
| 2000-06-22 | IYG | ETF | 27.0 | 27.0 | 27.0 | 27.0 | 300.0 |
| 2000-06-22 | IYH | ETF | 12.7875 | 12.7875 | 12.5125 | 12.5125 | 22000.0 |
| 2000-06-22 | IYM | ETF | 34.5625 | 34.5625 | 34.5625 | 34.5625 | 30000.0 |
| 2000-06-22 | IYR | ETF | 35.3672 | 35.3672 | 35.3672 | 35.3672 | 400.0 |
| 2000-06-22 | IYW | ETF | 33.3125 | 33.3125 | 32.5234 | 32.5234 | 17200.0 |
| 2000-06-22 | IYY | ETF | 34.5 | 34.5 | 34.0625 | 34.0625 | 6600.0 |
> showing 50 of 68 rows — these rows as CSV