PREVIEW / etf_daily / 2000-03-22
file: by_date/etf_daily/2000/2000-03-22.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-03-22 | SPY | ETF | 149.5625 | 150.8438 | 148.6875 | 150.0938 | 8260000.0 |
| 2000-03-22 | QQQ | ETF | 114.0 | 114.0 | 114.0 | 114.0 | 12765200.0 |
| 2000-03-22 | DIA | ETF | 109.1562 | 109.25 | 107.8125 | 108.5781 | 2434800.0 |
| 2000-03-22 | BBH | ETF | 59.9167 | 63.0 | 58.0833 | 62.0 | 2504400.0 |
| 2000-03-22 | BITS | ETF | 38.5 | 40.25 | 37.5 | 38.5 | 26650.0 |
| 2000-03-22 | CEF | ETF | 3.4375 | 3.625 | 3.4375 | 3.5625 | 73700.0 |
| 2000-03-22 | CHB | ETF | 6.69 | 6.88 | 6.5 | 6.69 | 87200.0 |
| 2000-03-22 | CNXT | ETF | 79.25 | 79.62 | 74.75 | 74.87 | 6433510.0 |
| 2000-03-22 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 2000.0 |
| 2000-03-22 | EWA | ETF | 10.375 | 10.625 | 10.375 | 10.375 | 6200.0 |
| 2000-03-22 | EWC | ETF | 18.0 | 18.375 | 18.0 | 18.3125 | 12000.0 |
| 2000-03-22 | EWD | ETF | 35.8125 | 35.875 | 35.6875 | 35.875 | 5100.0 |
| 2000-03-22 | EWG | ETF | 27.8125 | 28.25 | 27.8125 | 28.1875 | 185100.0 |
| 2000-03-22 | EWH | ETF | 13.4375 | 13.625 | 13.4375 | 13.5 | 32900.0 |
| 2000-03-22 | EWI | ETF | 50.875 | 50.875 | 50.625 | 50.75 | 47800.0 |
| 2000-03-22 | EWJ | ETF | 59.25 | 60.0 | 59.25 | 59.75 | 273825.0 |
| 2000-03-22 | EWK | ETF | 13.3125 | 13.4375 | 13.1875 | 13.1875 | 2200.0 |
| 2000-03-22 | EWL | ETF | 15.125 | 15.25 | 15.0625 | 15.25 | 4300.0 |
| 2000-03-22 | EWM | ETF | 27.5 | 27.75 | 27.5 | 27.5 | 10675.0 |
| 2000-03-22 | EWN | ETF | 23.9375 | 24.125 | 23.875 | 24.125 | 21500.0 |
| 2000-03-22 | EWO | ETF | 7.625 | 7.625 | 7.625 | 7.625 | 10000.0 |
| 2000-03-22 | EWP | ETF | 29.1875 | 29.3125 | 29.1875 | 29.3125 | 3700.0 |
| 2000-03-22 | EWQ | ETF | 28.25 | 28.25 | 27.9375 | 28.1875 | 295600.0 |
| 2000-03-22 | EWS | ETF | 14.75 | 15.0 | 14.75 | 14.75 | 35000.0 |
| 2000-03-22 | EWU | ETF | 40.75 | 41.25 | 40.375 | 40.875 | 107000.0 |
| 2000-03-22 | EWW | ETF | 19.5625 | 19.75 | 19.1875 | 19.4375 | 14500.0 |
| 2000-03-22 | FCTR | ETF | 13.6563 | 13.75 | 13.25 | 13.3125 | 30000.0 |
| 2000-03-22 | FMAR | ETF | 6.25 | 6.25 | 5.87 | 6.0 | 5700.0 |
| 2000-03-22 | GLDB | ETF | 6.875 | 6.875 | 6.375 | 6.375 | 82800.0 |
| 2000-03-22 | GSIG | ETF | 19.0 | 20.75 | 17.62 | 19.87 | 820000.0 |
| 2000-03-22 | IGLD | ETF | 2575.0 | 2587.5 | 2387.5 | 2437.5 | 772.0 |
| 2000-03-22 | KTEC | ETF | 9.0 | 9.125 | 8.875 | 9.125 | 3500.0 |
| 2000-03-22 | MDY | ETF | 89.1875 | 91.125 | 89.0 | 90.6875 | 602400.0 |
| 2000-03-22 | MIG | ETF | 5.125 | 5.25 | 5.0625 | 5.0625 | 4500.0 |
| 2000-03-22 | PPH | ETF | 42.75 | 43.4688 | 42.4062 | 43.25 | 160600.0 |
| 2000-03-22 | SFY | ETF | 12.9375 | 13.0 | 12.875 | 13.0 | 49800.0 |
| 2000-03-22 | TDSC | ETF | 5.06 | 5.25 | 4.845 | 5.25 | 60600.0 |
| 2000-03-22 | TINY | ETF | 22.0 | 24.75 | 21.38 | 23.44 | 214200.0 |
| 2000-03-22 | XLB | ETF | 11.164 | 11.2266 | 10.9219 | 10.9766 | 240800.0 |
| 2000-03-22 | XLE | ETF | 14.0781 | 14.1719 | 13.9375 | 14.0 | 83800.0 |
| 2000-03-22 | XLF | ETF | 19.1028 | 19.3948 | 18.9886 | 19.3059 | 830679.0 |
| 2000-03-22 | XLI | ETF | 28.0 | 28.3438 | 27.9688 | 28.2188 | 69100.0 |
| 2000-03-22 | XLK | ETF | 30.7812 | 31.375 | 30.625 | 31.125 | 1337000.0 |
| 2000-03-22 | XLP | ETF | 21.0469 | 21.1875 | 20.7969 | 21.125 | 132900.0 |
| 2000-03-22 | XLU | ETF | 13.0625 | 13.1562 | 12.8281 | 12.875 | 97000.0 |
| 2000-03-22 | XLV | ETF | 30.3125 | 31.0469 | 30.3125 | 30.8281 | 29900.0 |
| 2000-03-22 | XLY | ETF | 14.0312 | 14.1562 | 13.875 | 14.0938 | 266600.0 |
> showing 47 of 47 rows — these rows as CSV