PREVIEW / etf_daily / 2000-03-31
file: by_date/etf_daily/2000/2000-03-31.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-31 | SPY | ETF | 149.625 | 152.3125 | 148.4375 | 150.375 | 9249100.0 |
| 2000-03-31 | QQQ | ETF | 108.1406 | 110.625 | 104.0 | 109.5 | 31349900.0 |
| 2000-03-31 | DIA | ETF | 110.7969 | 111.25 | 109.0625 | 109.4375 | 1103400.0 |
| 2000-03-31 | BBH | ETF | 54.0 | 56.5833 | 53.4167 | 56.5 | 2771100.0 |
| 2000-03-31 | BITS | ETF | 52.25 | 53.0 | 46.25 | 50.0 | 39650.0 |
| 2000-03-31 | CEF | ETF | 3.5625 | 3.5625 | 3.5 | 3.5 | 48900.0 |
| 2000-03-31 | CHB | ETF | 6.19 | 6.19 | 6.0 | 6.0 | 448600.0 |
| 2000-03-31 | CNXT | ETF | 73.47 | 73.71 | 69.52 | 71.0 | 4158850.0 |
| 2000-03-31 | EWA | ETF | 10.125 | 10.125 | 9.875 | 9.875 | 3500.0 |
| 2000-03-31 | EWC | ETF | 18.1875 | 18.4375 | 18.1875 | 18.4375 | 12200.0 |
| 2000-03-31 | EWD | ETF | 33.75 | 34.1875 | 33.75 | 34.1875 | 7200.0 |
| 2000-03-31 | EWG | ETF | 27.1875 | 27.4375 | 27.0 | 27.0 | 47700.0 |
| 2000-03-31 | EWH | ETF | 13.5625 | 13.6875 | 13.5 | 13.6875 | 24500.0 |
| 2000-03-31 | EWI | ETF | 49.875 | 50.25 | 49.5 | 50.0 | 9650.0 |
| 2000-03-31 | EWJ | ETF | 65.25 | 66.0 | 65.0 | 66.0 | 88875.0 |
| 2000-03-31 | EWK | ETF | 12.875 | 12.875 | 12.875 | 12.875 | 100.0 |
| 2000-03-31 | EWL | ETF | 15.375 | 15.5 | 15.375 | 15.5 | 18200.0 |
| 2000-03-31 | EWM | ETF | 27.75 | 28.0 | 27.5 | 27.75 | 18100.0 |
| 2000-03-31 | EWN | ETF | 24.125 | 24.125 | 24.125 | 24.125 | 1600.0 |
| 2000-03-31 | EWO | ETF | 7.6875 | 7.75 | 7.6875 | 7.75 | 1500.0 |
| 2000-03-31 | EWP | ETF | 28.4375 | 28.75 | 28.4375 | 28.625 | 15100.0 |
| 2000-03-31 | EWQ | ETF | 28.125 | 28.125 | 27.75 | 27.75 | 16500.0 |
| 2000-03-31 | EWS | ETF | 14.75 | 14.875 | 14.5 | 14.75 | 74650.0 |
| 2000-03-31 | EWU | ETF | 41.125 | 41.125 | 40.625 | 40.875 | 12250.0 |
| 2000-03-31 | EWW | ETF | 18.875 | 18.875 | 18.4375 | 18.4375 | 7300.0 |
| 2000-03-31 | FCTR | ETF | 12.5 | 13.0 | 12.25 | 13.0 | 40900.0 |
| 2000-03-31 | FMAR | ETF | 5.87 | 6.5 | 5.75 | 6.38 | 2700.0 |
| 2000-03-31 | GLDB | ETF | 7.0 | 7.1094 | 6.625 | 6.625 | 92000.0 |
| 2000-03-31 | GSIG | ETF | 16.06 | 18.0 | 15.75 | 17.12 | 1024700.0 |
| 2000-03-31 | IGLD | ETF | 1781.25 | 2500.0 | 1700.0 | 2493.75 | 2309.0 |
| 2000-03-31 | KTEC | ETF | 8.875 | 9.5 | 8.875 | 9.5 | 46900.0 |
| 2000-03-31 | MDY | ETF | 90.25 | 91.8125 | 88.1875 | 91.25 | 2444300.0 |
| 2000-03-31 | MIG | ETF | 5.125 | 5.1875 | 5.0 | 5.0625 | 62200.0 |
| 2000-03-31 | PPH | ETF | 42.1562 | 43.5 | 42.0 | 42.6875 | 190000.0 |
| 2000-03-31 | SFY | ETF | 16.4375 | 17.875 | 16.25 | 17.8125 | 397400.0 |
| 2000-03-31 | TDSC | ETF | 5.0 | 5.25 | 5.0 | 5.19 | 113000.0 |
| 2000-03-31 | TINY | ETF | 17.25 | 18.0 | 14.62 | 16.56 | 276000.0 |
| 2000-03-31 | XLB | ETF | 11.5703 | 11.7422 | 11.4688 | 11.5234 | 305200.0 |
| 2000-03-31 | XLE | ETF | 14.6875 | 14.9922 | 14.6562 | 14.6562 | 1255800.0 |
| 2000-03-31 | XLF | ETF | 19.4202 | 19.8517 | 19.2933 | 19.7121 | 1533826.0 |
| 2000-03-31 | XLI | ETF | 29.2969 | 29.5156 | 29.1094 | 29.2031 | 23400.0 |
| 2000-03-31 | XLK | ETF | 30.125 | 30.5938 | 29.3125 | 30.2812 | 639200.0 |
| 2000-03-31 | XLP | ETF | 21.0 | 21.5 | 20.9375 | 21.2188 | 439800.0 |
| 2000-03-31 | XLU | ETF | 13.3906 | 13.4062 | 13.1719 | 13.3672 | 118800.0 |
| 2000-03-31 | XLV | ETF | 30.3438 | 30.6719 | 30.0625 | 30.6719 | 14400.0 |
| 2000-03-31 | XLY | ETF | 14.664 | 14.8516 | 14.586 | 14.6328 | 749200.0 |
> showing 46 of 46 rows — these rows as CSV