PREVIEW / etf_daily / 2000-04-12
file: by_date/etf_daily/2000/2000-04-12.parquet size: 6 KB rows: 47
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-04-12 | SPY | ETF | 150.375 | 151.1562 | 146.1562 | 146.2812 | 10779200.0 |
| 2000-04-12 | QQQ | ETF | 97.625 | 98.75 | 90.25 | 92.375 | 34831700.0 |
| 2000-04-12 | DIA | ETF | 113.875 | 114.5312 | 110.5 | 110.5156 | 3620700.0 |
| 2000-04-12 | BBH | ETF | 52.1667 | 52.9167 | 49.4375 | 49.4375 | 2849700.0 |
| 2000-04-12 | BITS | ETF | 30.0 | 32.0 | 24.25 | 26.0 | 81100.0 |
| 2000-04-12 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.5 | 13800.0 |
| 2000-04-12 | CHB | ETF | 6.25 | 6.5 | 6.19 | 6.38 | 86200.0 |
| 2000-04-12 | CNXT | ETF | 70.78 | 70.97 | 61.97 | 62.03 | 7473990.0 |
| 2000-04-12 | CSB | ETF | 4.0 | 4.0 | 3.99000000953674 | 4.0 | 89200.0 |
| 2000-04-12 | EWA | ETF | 10.0625 | 10.0625 | 9.9375 | 9.9375 | 10200.0 |
| 2000-04-12 | EWC | ETF | 18.0 | 18.0 | 18.0 | 18.0 | 10000.0 |
| 2000-04-12 | EWD | ETF | 33.3125 | 33.3125 | 32.1875 | 32.375 | 6600.0 |
| 2000-04-12 | EWG | ETF | 26.375 | 26.375 | 26.0 | 26.1875 | 37000.0 |
| 2000-04-12 | EWH | ETF | 13.375 | 13.5 | 13.125 | 13.125 | 77900.0 |
| 2000-04-12 | EWI | ETF | 48.875 | 49.0 | 48.625 | 48.875 | 8550.0 |
| 2000-04-12 | EWJ | ETF | 63.75 | 64.0 | 63.0 | 63.5 | 147125.0 |
| 2000-04-12 | EWK | ETF | 13.625 | 13.625 | 13.5 | 13.5 | 7400.0 |
| 2000-04-12 | EWL | ETF | 15.625 | 15.75 | 15.625 | 15.6875 | 1700.0 |
| 2000-04-12 | EWM | ETF | 28.0 | 28.0 | 26.75 | 26.75 | 28000.0 |
| 2000-04-12 | EWN | ETF | 23.6875 | 24.0625 | 23.6875 | 23.875 | 5700.0 |
| 2000-04-12 | EWO | ETF | 7.875 | 7.875 | 7.75 | 7.75 | 1400.0 |
| 2000-04-12 | EWP | ETF | 28.1875 | 28.1875 | 27.9375 | 27.9375 | 9000.0 |
| 2000-04-12 | EWQ | ETF | 27.875 | 27.875 | 27.375 | 27.375 | 50700.0 |
| 2000-04-12 | EWS | ETF | 14.625 | 14.625 | 14.5 | 14.5 | 32600.0 |
| 2000-04-12 | EWU | ETF | 40.5 | 40.5 | 39.625 | 39.75 | 10950.0 |
| 2000-04-12 | EWW | ETF | 18.25 | 18.25 | 17.75 | 17.75 | 11200.0 |
| 2000-04-12 | FCTR | ETF | 13.4063 | 13.75 | 13.375 | 13.375 | 54800.0 |
| 2000-04-12 | FMAR | ETF | 6.0 | 6.25 | 6.0 | 6.0 | 3600.0 |
| 2000-04-12 | GLDB | ETF | 6.25 | 6.25 | 6.0 | 6.0625 | 124500.0 |
| 2000-04-12 | GSIG | ETF | 17.0 | 17.25 | 16.75 | 17.0 | 1781100.0 |
| 2000-04-12 | IGLD | ETF | 1643.75 | 1643.75 | 1300.0 | 1300.0 | 1185.0 |
| 2000-04-12 | KTEC | ETF | 9.25 | 9.875 | 9.25 | 9.25 | 12800.0 |
| 2000-04-12 | MDY | ETF | 87.5 | 88.0 | 85.4375 | 85.5 | 525200.0 |
| 2000-04-12 | MIG | ETF | 5.375 | 5.375 | 5.25 | 5.25 | 20000.0 |
| 2000-04-12 | PPH | ETF | 46.0 | 47.4375 | 46.0 | 46.1875 | 926200.0 |
| 2000-04-12 | SFY | ETF | 17.9375 | 20.0 | 17.875 | 19.875 | 301600.0 |
| 2000-04-12 | TDSC | ETF | 5.0 | 5.08 | 4.69 | 4.875 | 30400.0 |
| 2000-04-12 | TINY | ETF | 13.19 | 13.56 | 11.0 | 11.5 | 292000.0 |
| 2000-04-12 | XLB | ETF | 12.0312 | 12.5781 | 12.0312 | 12.3125 | 481600.0 |
| 2000-04-12 | XLE | ETF | 14.5312 | 14.7812 | 14.4766 | 14.5938 | 484400.0 |
| 2000-04-12 | XLF | ETF | 20.3087 | 20.9561 | 20.3087 | 20.3976 | 1093128.0 |
| 2000-04-12 | XLI | ETF | 29.6875 | 30.125 | 29.3281 | 29.4531 | 157700.0 |
| 2000-04-12 | XLK | ETF | 28.4062 | 28.4062 | 26.5625 | 26.625 | 2676200.0 |
| 2000-04-12 | XLP | ETF | 22.8594 | 23.4688 | 22.6719 | 23.0156 | 76500.0 |
| 2000-04-12 | XLU | ETF | 14.3281 | 14.5 | 14.2656 | 14.3203 | 152000.0 |
| 2000-04-12 | XLV | ETF | 30.875 | 30.9375 | 30.2656 | 30.2656 | 13100.0 |
| 2000-04-12 | XLY | ETF | 15.6484 | 15.9688 | 15.4922 | 15.4922 | 214000.0 |
> showing 47 of 47 rows — these rows as CSV