PREVIEW / etf_daily / 2000-03-28
file: by_date/etf_daily/2000/2000-03-28.parquet size: 6 KB rows: 46
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-28 | SPY | ETF | 151.25 | 152.9844 | 150.5938 | 151.0625 | 6334400.0 |
| 2000-03-28 | QQQ | ETF | 116.9844 | 117.8125 | 113.125 | 114.75 | 18336300.0 |
| 2000-03-28 | DIA | ETF | 109.125 | 110.9844 | 109.125 | 109.375 | 1575100.0 |
| 2000-03-28 | BBH | ETF | 59.25 | 59.6667 | 58.1667 | 58.1667 | 1368900.0 |
| 2000-03-28 | BITS | ETF | 51.0 | 53.5 | 47.75 | 50.5 | 203525.0 |
| 2000-03-28 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5625 | 46900.0 |
| 2000-03-28 | CHB | ETF | 6.31 | 6.5 | 6.31 | 6.38 | 142400.0 |
| 2000-03-28 | CNXT | ETF | 82.12 | 82.75 | 76.0 | 76.37 | 3411290.0 |
| 2000-03-28 | EWA | ETF | 10.625 | 10.625 | 10.625 | 10.625 | 3100.0 |
| 2000-03-28 | EWC | ETF | 19.0 | 19.0 | 18.9375 | 18.9375 | 1400.0 |
| 2000-03-28 | EWD | ETF | 34.9375 | 35.0625 | 34.8125 | 35.0625 | 3600.0 |
| 2000-03-28 | EWG | ETF | 28.1875 | 28.1875 | 28.0 | 28.0625 | 85500.0 |
| 2000-03-28 | EWH | ETF | 14.125 | 14.125 | 13.875 | 13.875 | 52000.0 |
| 2000-03-28 | EWI | ETF | 52.75 | 52.75 | 51.5 | 51.5 | 10700.0 |
| 2000-03-28 | EWJ | ETF | 62.0 | 62.75 | 62.0 | 62.0 | 112225.0 |
| 2000-03-28 | EWK | ETF | 13.1875 | 13.1875 | 12.875 | 12.875 | 11300.0 |
| 2000-03-28 | EWL | ETF | 15.5625 | 15.5625 | 15.1875 | 15.4375 | 47000.0 |
| 2000-03-28 | EWM | ETF | 28.5 | 28.5 | 28.25 | 28.5 | 6975.0 |
| 2000-03-28 | EWN | ETF | 24.5 | 24.5625 | 24.375 | 24.375 | 5900.0 |
| 2000-03-28 | EWO | ETF | 7.875 | 7.875 | 7.8125 | 7.875 | 5800.0 |
| 2000-03-28 | EWP | ETF | 29.25 | 29.25 | 28.8125 | 29.0625 | 4700.0 |
| 2000-03-28 | EWQ | ETF | 29.5 | 29.5 | 28.9375 | 28.9375 | 48300.0 |
| 2000-03-28 | EWS | ETF | 15.625 | 15.875 | 15.5 | 15.5 | 30000.0 |
| 2000-03-28 | EWU | ETF | 41.375 | 41.5 | 41.0 | 41.5 | 17350.0 |
| 2000-03-28 | EWW | ETF | 19.875 | 19.9375 | 19.6875 | 19.6875 | 4600.0 |
| 2000-03-28 | FCTR | ETF | 13.6875 | 13.6875 | 13.0 | 13.1875 | 19600.0 |
| 2000-03-28 | FMAR | ETF | 6.0 | 6.25 | 5.75 | 6.0 | 9400.0 |
| 2000-03-28 | GLDB | ETF | 6.9063 | 7.1875 | 6.9063 | 7.0 | 214700.0 |
| 2000-03-28 | GSIG | ETF | 19.31 | 19.87 | 18.62 | 18.81 | 292000.0 |
| 2000-03-28 | IGLD | ETF | 2312.5 | 2375.0 | 2218.75 | 2231.25 | 378.0 |
| 2000-03-28 | KTEC | ETF | 8.875 | 9.0 | 8.875 | 8.875 | 14600.0 |
| 2000-03-28 | MDY | ETF | 91.3125 | 91.75 | 89.5 | 89.5 | 275100.0 |
| 2000-03-28 | MIG | ETF | 6.0 | 6.0 | 5.6875 | 5.875 | 26900.0 |
| 2000-03-28 | PPH | ETF | 41.125 | 41.9688 | 40.6562 | 41.5938 | 126800.0 |
| 2000-03-28 | SFY | ETF | 15.0 | 15.25 | 15.0 | 15.0625 | 63900.0 |
| 2000-03-28 | TDSC | ETF | 5.25 | 5.47 | 5.25 | 5.44 | 67600.0 |
| 2000-03-28 | TINY | ETF | 20.62 | 21.75 | 19.5 | 20.88 | 158600.0 |
| 2000-03-28 | XLB | ETF | 11.0781 | 11.2812 | 10.9688 | 11.0 | 228000.0 |
| 2000-03-28 | XLE | ETF | 14.0938 | 14.1719 | 13.9062 | 14.0 | 138600.0 |
| 2000-03-28 | XLF | ETF | 19.344 | 19.9279 | 19.344 | 19.6994 | 371516.0 |
| 2000-03-28 | XLI | ETF | 28.7812 | 29.0 | 28.6094 | 28.6094 | 8900.0 |
| 2000-03-28 | XLK | ETF | 32.25 | 32.25 | 31.4688 | 31.4688 | 1251200.0 |
| 2000-03-28 | XLP | ETF | 20.2969 | 20.6562 | 20.25 | 20.5469 | 71600.0 |
| 2000-03-28 | XLU | ETF | 13.1719 | 13.1797 | 13.039 | 13.086 | 35200.0 |
| 2000-03-28 | XLV | ETF | 31.0 | 31.1719 | 30.875 | 31.0312 | 13700.0 |
| 2000-03-28 | XLY | ETF | 14.0625 | 14.3438 | 14.0625 | 14.1875 | 41600.0 |
> showing 46 of 46 rows — these rows as CSV