PREVIEW / etf_daily / 2000-05-22
file: by_date/etf_daily/2000/2000-05-22.parquet size: 7 KB rows: 52
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-05-22 | SPY | ETF | 141.25 | 141.4688 | 137.0 | 140.0625 | 10839400.0 |
| 2000-05-22 | QQQ | ETF | 81.625 | 82.25 | 75.5781 | 81.625 | 43882000.0 |
| 2000-05-22 | DIA | ETF | 106.125 | 106.3438 | 103.625 | 105.5312 | 1233400.0 |
| 2000-05-22 | BBH | ETF | 44.8333 | 44.8333 | 41.7292 | 43.1667 | 1915500.0 |
| 2000-05-22 | BITS | ETF | 24.0 | 24.0 | 20.5 | 21.75 | 21925.0 |
| 2000-05-22 | BOSS | ETF | 14.7 | 14.7 | 14.66 | 14.7 | 300.0 |
| 2000-05-22 | CEF | ETF | 3.4375 | 3.5 | 3.375 | 3.4375 | 24700.0 |
| 2000-05-22 | CHB | ETF | 6.0 | 6.13 | 5.88 | 6.0 | 77200.0 |
| 2000-05-22 | CNXT | ETF | 39.56 | 39.88 | 34.44 | 36.13 | 10888030.0 |
| 2000-05-22 | CSB | ETF | 3.90000009536743 | 4.0 | 3.90000009536743 | 4.0 | 20000.0 |
| 2000-05-22 | EWA | ETF | 9.3125 | 9.3125 | 9.125 | 9.125 | 12200.0 |
| 2000-05-22 | EWC | ETF | 18.125 | 18.125 | 18.125 | 18.125 | 1800.0 |
| 2000-05-22 | EWD | ETF | 30.375 | 30.375 | 29.375 | 29.375 | 10900.0 |
| 2000-05-22 | EWG | ETF | 22.9375 | 23.0 | 22.5625 | 22.9375 | 49900.0 |
| 2000-05-22 | EWH | ETF | 11.75 | 11.75 | 11.1875 | 11.5 | 36000.0 |
| 2000-05-22 | EWI | ETF | 44.375 | 44.625 | 44.25 | 44.625 | 13600.0 |
| 2000-05-22 | EWJ | ETF | 57.0 | 57.0 | 55.25 | 56.5 | 759425.0 |
| 2000-05-22 | EWK | ETF | 12.5 | 12.625 | 12.375 | 12.375 | 14000.0 |
| 2000-05-22 | EWL | ETF | 15.0625 | 15.0625 | 14.9375 | 15.0625 | 42000.0 |
| 2000-05-22 | EWM | ETF | 28.5 | 28.5 | 27.5 | 28.0 | 61400.0 |
| 2000-05-22 | EWN | ETF | 22.875 | 22.875 | 22.875 | 22.875 | 200.0 |
| 2000-05-22 | EWO | ETF | 7.5 | 7.5 | 7.0 | 7.375 | 33500.0 |
| 2000-05-22 | EWP | ETF | 24.125 | 24.1875 | 24.125 | 24.1875 | 8800.0 |
| 2000-05-22 | EWQ | ETF | 25.875 | 25.875 | 25.375 | 25.5625 | 26100.0 |
| 2000-05-22 | EWS | ETF | 13.375 | 13.75 | 12.875 | 13.25 | 89550.0 |
| 2000-05-22 | EWU | ETF | 35.75 | 36.125 | 35.625 | 35.75 | 1550.0 |
| 2000-05-22 | EWW | ETF | 14.75 | 14.75 | 13.9375 | 14.1875 | 16100.0 |
| 2000-05-22 | EWY | ETF | 17.9375 | 17.9375 | 17.4375 | 17.4375 | 70500.0 |
| 2000-05-22 | FCTR | ETF | 15.125 | 15.25 | 14.75 | 14.9375 | 32600.0 |
| 2000-05-22 | FMAR | ETF | 6.0706 | 6.0706 | 6.0394 | 6.0394 | 200.0 |
| 2000-05-22 | GLDB | ETF | 5.875 | 6.0 | 5.75 | 6.0 | 9500.0 |
| 2000-05-22 | GSIG | ETF | 21.22 | 21.25 | 18.87 | 20.56 | 520000.0 |
| 2000-05-22 | IGLD | ETF | 937.5 | 937.5 | 862.5 | 925.0 | 1717.0 |
| 2000-05-22 | IVV | ETF | 140.5938 | 140.5938 | 136.8125 | 139.8125 | 1850600.0 |
| 2000-05-22 | IWB | ETF | 74.6094 | 74.6094 | 72.0781 | 74.0938 | 751300.0 |
| 2000-05-22 | IYW | ETF | 26.5 | 26.5 | 26.5 | 26.5 | 400.0 |
| 2000-05-22 | KTEC | ETF | 8.25 | 8.5 | 8.125 | 8.4375 | 1700.0 |
| 2000-05-22 | MDY | ETF | 86.4375 | 86.4375 | 83.5 | 84.9375 | 430200.0 |
| 2000-05-22 | MIG | ETF | 5.25 | 5.25 | 5.25 | 5.25 | 3000.0 |
| 2000-05-22 | PPH | ETF | 49.75 | 50.25 | 48.7812 | 49.375 | 247600.0 |
| 2000-05-22 | SFY | ETF | 24.25 | 24.25 | 23.75 | 24.0 | 72100.0 |
| 2000-05-22 | TDSC | ETF | 5.19 | 5.31 | 5.19 | 5.31 | 145400.0 |
| 2000-05-22 | TINY | ETF | 7.28 | 7.5 | 6.22 | 6.44 | 188900.0 |
| 2000-05-22 | XLB | ETF | 11.6719 | 11.6719 | 11.4688 | 11.5625 | 103600.0 |
| 2000-05-22 | XLE | ETF | 15.7812 | 15.961 | 15.7734 | 15.7734 | 216800.0 |
| 2000-05-22 | XLF | ETF | 19.7375 | 19.9025 | 19.3948 | 19.9025 | 179849.0 |
| 2000-05-22 | XLI | ETF | 29.0 | 29.2031 | 29.0 | 29.1719 | 5500.0 |
| 2000-05-22 | XLK | ETF | 24.0625 | 24.2188 | 23.0 | 24.1719 | 905200.0 |
| 2000-05-22 | XLP | ETF | 23.8438 | 24.1875 | 23.5625 | 23.9062 | 41400.0 |
| 2000-05-22 | XLU | ETF | 14.0156 | 14.039 | 13.8672 | 14.0156 | 29600.0 |
> showing 50 of 52 rows — these rows as CSV