PREVIEW / etf_daily / 2000-10-17
file: by_date/etf_daily/2000/2000-10-17.parquet size: 8 KB rows: 89
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-10-17 | SPY | ETF | 138.4375 | 138.5625 | 134.4062 | 134.75 | 7831700.0 |
| 2000-10-17 | QQQ | ETF | 83.125 | 83.1719 | 78.0 | 78.25 | 52106600.0 |
| 2000-10-17 | IWM | ETF | 48.125 | 48.2578 | 46.5703 | 46.9141 | 265800.0 |
| 2000-10-17 | DIA | ETF | 102.9688 | 103.1562 | 100.375 | 100.5938 | 906200.0 |
| 2000-10-17 | BBH | ETF | 58.6667 | 59.0 | 57.8125 | 58.9167 | 1866600.0 |
| 2000-10-17 | BITS | ETF | 9.0 | 10.0 | 8.5 | 9.5 | 30625.0 |
| 2000-10-17 | CEF | ETF | 3.25 | 3.25 | 3.125 | 3.1875 | 128100.0 |
| 2000-10-17 | CHB | ETF | 3.0 | 3.0 | 2.88 | 3.0 | 181200.0 |
| 2000-10-17 | CNXT | ETF | 35.13 | 37.0 | 32.19 | 33.63 | 4337430.0 |
| 2000-10-17 | CSB | ETF | 1.0 | 1.0 | 1.0 | 1.0 | 20000.0 |
| 2000-10-17 | EWA | ETF | 9.0 | 9.0625 | 8.9375 | 9.0 | 21000.0 |
| 2000-10-17 | EWC | ETF | 15.875 | 15.875 | 15.5625 | 15.5625 | 14500.0 |
| 2000-10-17 | EWD | ETF | 19.875 | 19.875 | 19.1875 | 19.1875 | 16100.0 |
| 2000-10-17 | EWG | ETF | 18.25 | 18.3125 | 17.875 | 18.125 | 66400.0 |
| 2000-10-17 | EWH | ETF | 11.125 | 11.125 | 10.6875 | 10.875 | 47400.0 |
| 2000-10-17 | EWI | ETF | 40.25 | 40.75 | 40.25 | 40.75 | 2350.0 |
| 2000-10-17 | EWJ | ETF | 51.75 | 52.0 | 50.75 | 50.75 | 64650.0 |
| 2000-10-17 | EWK | ETF | 12.0625 | 12.0625 | 12.0625 | 12.0625 | 400.0 |
| 2000-10-17 | EWL | ETF | 14.25 | 14.5 | 14.1875 | 14.1875 | 28600.0 |
| 2000-10-17 | EWM | ETF | 22.0 | 22.0 | 21.75 | 21.75 | 11675.0 |
| 2000-10-17 | EWN | ETF | 21.5625 | 21.5625 | 21.0625 | 21.0625 | 9400.0 |
| 2000-10-17 | EWO | ETF | 7.0 | 7.0625 | 7.0 | 7.0 | 13200.0 |
| 2000-10-17 | EWP | ETF | 22.9375 | 22.9375 | 22.6875 | 22.6875 | 4300.0 |
| 2000-10-17 | EWQ | ETF | 23.25 | 23.25 | 22.8125 | 23.0 | 24100.0 |
| 2000-10-17 | EWS | ETF | 12.625 | 12.625 | 12.0 | 12.0 | 40350.0 |
| 2000-10-17 | EWT | ETF | 24.875 | 25.25 | 24.25 | 24.875 | 34500.0 |
| 2000-10-17 | EWU | ETF | 34.0 | 34.625 | 34.0 | 34.375 | 32750.0 |
| 2000-10-17 | EWW | ETF | 14.0 | 14.125 | 13.5 | 13.75 | 56600.0 |
| 2000-10-17 | EWY | ETF | 13.5 | 13.5 | 13.3125 | 13.3125 | 28800.0 |
| 2000-10-17 | EWZ | ETF | 17.1875 | 17.1875 | 17.0 | 17.0 | 300.0 |
| 2000-10-17 | EZU | ETF | 33.8125 | 33.8125 | 33.8125 | 33.8125 | 1400.0 |
| 2000-10-17 | FCTR | ETF | 14.0 | 14.125 | 14.0 | 14.125 | 24300.0 |
| 2000-10-17 | FMAR | ETF | 5.03 | 5.34 | 5.03 | 5.03 | 3100.0 |
| 2000-10-17 | GLDB | ETF | 4.375 | 4.375 | 4.0 | 4.1875 | 45400.0 |
| 2000-10-17 | GSIG | ETF | 14.08 | 14.19 | 13.12 | 13.12 | 321400.0 |
| 2000-10-17 | IDU | ETF | 42.3438 | 42.3594 | 41.8438 | 41.8594 | 6200.0 |
| 2000-10-17 | IEV | ETF | 35.9375 | 35.9688 | 35.7266 | 35.9688 | 12600.0 |
| 2000-10-17 | IGLD | ETF | 306.25 | 343.75 | 300.0 | 318.75 | 714.0 |
| 2000-10-17 | IJH | ETF | 10.1281 | 10.1281 | 9.7969 | 9.8578 | 1362000.0 |
| 2000-10-17 | IJJ | ETF | 18.6992 | 18.6992 | 18.4922 | 18.5156 | 8800.0 |
| 2000-10-17 | IJK | ETF | 16.7812 | 16.7812 | 16.207 | 16.3828 | 2496800.0 |
| 2000-10-17 | IJR | ETF | 17.2708 | 17.2708 | 16.737 | 16.8281 | 61800.0 |
| 2000-10-17 | IJS | ETF | 17.211 | 17.211 | 16.7656 | 16.8438 | 23600.0 |
| 2000-10-17 | IJT | ETF | 20.0664 | 20.0664 | 19.3516 | 19.3984 | 8400.0 |
| 2000-10-17 | IUSG | ETF | 29.6875 | 29.6875 | 29.6875 | 29.6875 | 400.0 |
| 2000-10-17 | IUSV | ETF | 23.4792 | 23.4792 | 23.4792 | 23.4792 | 1200.0 |
| 2000-10-17 | IVE | ETF | 60.625 | 60.625 | 59.0938 | 59.75 | 186700.0 |
| 2000-10-17 | IVV | ETF | 138.2188 | 138.3438 | 134.5781 | 135.0 | 157600.0 |
| 2000-10-17 | IVW | ETF | 19.8281 | 19.8594 | 19.2969 | 19.3438 | 61600.0 |
| 2000-10-17 | IWB | ETF | 73.84 | 73.84 | 72.0 | 72.24 | 12000.0 |
> showing 50 of 89 rows — these rows as CSV