PREVIEW / etf_daily / 2000-06-21
file: by_date/etf_daily/2000/2000-06-21.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-21 | SPY | ETF | 146.9375 | 148.4375 | 146.8906 | 147.875 | 3115000.0 |
| 2000-06-21 | QQQ | ETF | 96.8125 | 99.7188 | 96.6875 | 98.875 | 20880600.0 |
| 2000-06-21 | IWM | ETF | 52.125 | 52.9375 | 52.125 | 52.8438 | 66800.0 |
| 2000-06-21 | DIA | ETF | 104.3125 | 105.25 | 104.1406 | 104.9375 | 599800.0 |
| 2000-06-21 | BBH | ETF | 58.25 | 62.3125 | 57.9375 | 61.4792 | 2400300.0 |
| 2000-06-21 | BITS | ETF | 27.375 | 29.5 | 26.0 | 29.0 | 13500.0 |
| 2000-06-21 | BOSS | ETF | 16.6 | 16.6 | 16.4 | 16.4 | 200.0 |
| 2000-06-21 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.4375 | 65600.0 |
| 2000-06-21 | CHB | ETF | 5.06 | 5.25 | 4.88 | 4.94 | 60600.0 |
| 2000-06-21 | CNXT | ETF | 54.04 | 57.28 | 53.47 | 57.09 | 3787100.0 |
| 2000-06-21 | EWA | ETF | 10.375 | 10.4375 | 10.25 | 10.3125 | 2700.0 |
| 2000-06-21 | EWC | ETF | 20.0625 | 20.0625 | 19.6875 | 19.9375 | 10700.0 |
| 2000-06-21 | EWD | ETF | 31.5625 | 31.75 | 31.5625 | 31.6875 | 1100.0 |
| 2000-06-21 | EWG | ETF | 24.6875 | 24.75 | 24.4375 | 24.75 | 32900.0 |
| 2000-06-21 | EWH | ETF | 12.625 | 12.625 | 12.3125 | 12.5 | 46200.0 |
| 2000-06-21 | EWI | ETF | 50.625 | 50.625 | 50.25 | 50.625 | 3200.0 |
| 2000-06-21 | EWJ | ETF | 60.0 | 60.5 | 59.75 | 60.0 | 78275.0 |
| 2000-06-21 | EWK | ETF | 13.4375 | 13.4375 | 13.25 | 13.25 | 3800.0 |
| 2000-06-21 | EWL | ETF | 16.125 | 16.125 | 16.0 | 16.0625 | 3800.0 |
| 2000-06-21 | EWM | ETF | 25.25 | 25.5 | 25.0 | 25.5 | 24325.0 |
| 2000-06-21 | EWN | ETF | 24.875 | 25.0 | 24.75 | 25.0 | 5200.0 |
| 2000-06-21 | EWO | ETF | 8.0625 | 8.0625 | 8.0625 | 8.0625 | 300.0 |
| 2000-06-21 | EWP | ETF | 25.4375 | 25.75 | 25.3125 | 25.5 | 7900.0 |
| 2000-06-21 | EWQ | ETF | 28.75 | 28.8125 | 28.5625 | 28.75 | 29000.0 |
| 2000-06-21 | EWS | ETF | 14.25 | 14.5 | 14.25 | 14.5 | 31550.0 |
| 2000-06-21 | EWU | ETF | 38.75 | 39.0 | 38.125 | 39.0 | 23700.0 |
| 2000-06-21 | EWW | ETF | 15.5625 | 15.8125 | 15.5 | 15.6875 | 22900.0 |
| 2000-06-21 | EWY | ETF | 20.75 | 20.75 | 20.25 | 20.375 | 22200.0 |
| 2000-06-21 | FCTR | ETF | 16.875 | 17.0 | 16.875 | 17.0 | 41000.0 |
| 2000-06-21 | FMAR | ETF | 5.88 | 6.0025 | 5.8775 | 5.88 | 1400.0 |
| 2000-06-21 | GLDB | ETF | 6.6875 | 6.6875 | 6.3125 | 6.5625 | 12000.0 |
| 2000-06-21 | GSIG | ETF | 29.19 | 29.25 | 27.87 | 28.56 | 303900.0 |
| 2000-06-21 | IDU | ETF | 34.7969 | 34.7969 | 34.7969 | 34.7969 | 400.0 |
| 2000-06-21 | IGLD | ETF | 893.75 | 918.75 | 875.0 | 881.25 | 325.0 |
| 2000-06-21 | IJH | ETF | 10.1 | 10.1313 | 10.0922 | 10.1078 | 1006000.0 |
| 2000-06-21 | IJR | ETF | 17.5 | 17.5677 | 17.5 | 17.5208 | 6000.0 |
| 2000-06-21 | IVE | ETF | 59.9062 | 59.9531 | 59.6562 | 59.7812 | 5800.0 |
| 2000-06-21 | IVV | ETF | 146.875 | 148.1562 | 146.875 | 147.8594 | 137500.0 |
| 2000-06-21 | IVW | ETF | 22.7656 | 22.8281 | 22.6484 | 22.8281 | 20800.0 |
| 2000-06-21 | IWB | ETF | 78.3438 | 78.5938 | 78.3125 | 78.5938 | 1900.0 |
| 2000-06-21 | IWD | ETF | 56.0625 | 56.25 | 55.9688 | 55.9688 | 18000.0 |
| 2000-06-21 | IWF | ETF | 21.859375 | 22.0 | 21.8047 | 21.921875 | 64400.0 |
| 2000-06-21 | IWV | ETF | 80.6875 | 81.0469 | 80.6875 | 81.0469 | 2500.0 |
| 2000-06-21 | IYE | ETF | 16.8125 | 17.2344 | 16.8125 | 17.224 | 9600.0 |
| 2000-06-21 | IYF | ETF | 36.0 | 36.0 | 35.5 | 35.625 | 8800.0 |
| 2000-06-21 | IYG | ETF | 27.1467 | 27.1467 | 27.1467 | 27.1467 | 300.0 |
| 2000-06-21 | IYH | ETF | 12.8 | 12.8906 | 12.8 | 12.8906 | 44500.0 |
| 2000-06-21 | IYR | ETF | 35.3906 | 35.3906 | 35.3516 | 35.3516 | 20600.0 |
| 2000-06-21 | IYW | ETF | 32.7344 | 33.4844 | 32.7344 | 33.3906 | 13600.0 |
| 2000-06-21 | IYY | ETF | 34.5625 | 34.7031 | 34.375 | 34.5938 | 21400.0 |
> showing 50 of 68 rows — these rows as CSV