PREVIEW / etf_daily / 2000-01-25
file: by_date/etf_daily/2000/2000-01-25.parquet size: 6 KB rows: 44
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-01-25 | SPY | ETF | 140.5156 | 141.9375 | 139.0 | 141.9375 | 9942500.0 |
| 2000-01-25 | DIA | ETF | 110.5938 | 110.875 | 108.75 | 110.3438 | 1728200.0 |
| 2000-01-25 | BBH | ETF | 56.4167 | 56.75 | 54.5 | 56.6458 | 1956600.0 |
| 2000-01-25 | BITS | ETF | 21.75 | 22.25 | 21.0 | 21.25 | 33550.0 |
| 2000-01-25 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5625 | 25200.0 |
| 2000-01-25 | CHB | ETF | 8.13 | 8.25 | 8.06 | 8.13 | 75800.0 |
| 2000-01-25 | CNXT | ETF | 76.56 | 76.62 | 72.7 | 74.12 | 3024970.0 |
| 2000-01-25 | EWA | ETF | 10.75 | 10.75 | 10.5625 | 10.6875 | 13500.0 |
| 2000-01-25 | EWC | ETF | 16.5625 | 16.5625 | 16.25 | 16.25 | 8300.0 |
| 2000-01-25 | EWD | ETF | 30.25 | 30.3125 | 30.0625 | 30.0625 | 7000.0 |
| 2000-01-25 | EWG | ETF | 25.9375 | 26.0625 | 25.6875 | 25.9375 | 58600.0 |
| 2000-01-25 | EWH | ETF | 12.75 | 12.8125 | 12.625 | 12.6875 | 28400.0 |
| 2000-01-25 | EWI | ETF | 48.25 | 48.75 | 48.0 | 48.375 | 6350.0 |
| 2000-01-25 | EWJ | ETF | 60.25 | 60.25 | 59.25 | 60.25 | 92675.0 |
| 2000-01-25 | EWK | ETF | 14.0 | 14.0 | 14.0 | 14.0 | 2200.0 |
| 2000-01-25 | EWL | ETF | 15.0 | 15.125 | 14.875 | 15.125 | 28200.0 |
| 2000-01-25 | EWM | ETF | 29.75 | 30.0 | 29.25 | 29.5 | 10475.0 |
| 2000-01-25 | EWN | ETF | 23.6875 | 24.125 | 23.6875 | 24.125 | 12600.0 |
| 2000-01-25 | EWO | ETF | 8.1875 | 8.375 | 8.1875 | 8.375 | 1700.0 |
| 2000-01-25 | EWP | ETF | 26.25 | 26.625 | 26.25 | 26.5625 | 3400.0 |
| 2000-01-25 | EWQ | ETF | 25.875 | 26.0 | 25.625 | 25.9375 | 28800.0 |
| 2000-01-25 | EWS | ETF | 16.75 | 16.75 | 16.375 | 16.5 | 39100.0 |
| 2000-01-25 | EWU | ETF | 40.0 | 40.0 | 39.25 | 39.875 | 35450.0 |
| 2000-01-25 | EWW | ETF | 16.875 | 17.125 | 16.6875 | 16.875 | 21500.0 |
| 2000-01-25 | FCTR | ETF | 14.25 | 14.375 | 13.9375 | 14.0 | 29900.0 |
| 2000-01-25 | FMAR | ETF | 6.48 | 7.48 | 6.48 | 7.48 | 12710.0 |
| 2000-01-25 | GLDB | ETF | 8.25 | 9.0 | 8.1875 | 9.0 | 24600.0 |
| 2000-01-25 | GSIG | ETF | 14.0 | 14.12 | 12.56 | 12.87 | 268600.0 |
| 2000-01-25 | IGLD | ETF | 2062.5 | 2062.5 | 1937.5 | 2000.0 | 2024.0 |
| 2000-01-25 | KTEC | ETF | 10.1875 | 10.1875 | 10.0 | 10.0 | 1500.0 |
| 2000-01-25 | MDY | ETF | 81.6875 | 81.6875 | 79.75 | 81.0625 | 1236800.0 |
| 2000-01-25 | MIG | ETF | 6.25 | 6.25 | 6.0625 | 6.0625 | 19200.0 |
| 2000-01-25 | SFY | ETF | 12.3125 | 12.5625 | 12.0 | 12.1875 | 85100.0 |
| 2000-01-25 | TDSC | ETF | 5.235 | 5.44 | 4.81 | 5.125 | 479400.0 |
| 2000-01-25 | TINY | ETF | 11.56 | 11.56 | 10.5 | 11.0 | 99300.0 |
| 2000-01-25 | XLB | ETF | 12.0547 | 12.125 | 11.6953 | 11.875 | 126800.0 |
| 2000-01-25 | XLE | ETF | 14.0625 | 14.7344 | 13.9062 | 14.0 | 115600.0 |
| 2000-01-25 | XLF | ETF | 17.8209 | 18.1509 | 17.7955 | 18.0113 | 231674.0 |
| 2000-01-25 | XLI | ETF | 27.1562 | 27.3906 | 26.8125 | 27.3594 | 89700.0 |
| 2000-01-25 | XLK | ETF | 25.8828 | 26.5156 | 25.5312 | 26.4922 | 5964800.0 |
| 2000-01-25 | XLP | ETF | 22.5781 | 22.6562 | 22.3281 | 22.375 | 85000.0 |
| 2000-01-25 | XLU | ETF | 13.5781 | 13.7344 | 13.3125 | 13.4297 | 113800.0 |
| 2000-01-25 | XLV | ETF | 31.25 | 31.4375 | 31.0 | 31.2031 | 24400.0 |
| 2000-01-25 | XLY | ETF | 13.9531 | 14.0312 | 13.8125 | 13.9922 | 126000.0 |
> showing 44 of 44 rows — these rows as CSV