PREVIEW / etf_daily / 2000-04-24
file: by_date/etf_daily/2000/2000-04-24.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-04-24 | SPY | ETF | 141.5 | 143.3125 | 140.5 | 142.25 | 12893100.0 |
| 2000-04-24 | QQQ | ETF | 83.4375 | 85.25 | 79.875 | 84.75 | 31246900.0 |
| 2000-04-24 | DIA | ETF | 107.0 | 109.25 | 106.75 | 108.875 | 1714200.0 |
| 2000-04-24 | BBH | ETF | 42.6667 | 43.3333 | 40.0 | 40.8542 | 2187000.0 |
| 2000-04-24 | BITS | ETF | 21.0 | 23.5 | 20.0 | 20.25 | 25350.0 |
| 2000-04-24 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 34600.0 |
| 2000-04-24 | CHB | ETF | 5.88 | 6.5 | 5.88 | 6.5 | 305700.0 |
| 2000-04-24 | CNXT | ETF | 55.06 | 60.13 | 54.38 | 58.13 | 3242490.0 |
| 2000-04-24 | EWA | ETF | 9.5 | 9.625 | 9.5 | 9.5 | 1900.0 |
| 2000-04-24 | EWC | ETF | 17.5625 | 17.5625 | 17.0 | 17.1875 | 8200.0 |
| 2000-04-24 | EWD | ETF | 32.125 | 32.25 | 32.125 | 32.25 | 1900.0 |
| 2000-04-24 | EWG | ETF | 24.6875 | 24.6875 | 24.375 | 24.5 | 52200.0 |
| 2000-04-24 | EWH | ETF | 12.1875 | 12.3125 | 12.0 | 12.0 | 105200.0 |
| 2000-04-24 | EWI | ETF | 46.5 | 47.0 | 46.5 | 46.625 | 550.0 |
| 2000-04-24 | EWJ | ETF | 61.75 | 61.75 | 60.75 | 61.0 | 70400.0 |
| 2000-04-24 | EWK | ETF | 12.8125 | 12.8125 | 12.5 | 12.75 | 2000.0 |
| 2000-04-24 | EWL | ETF | 14.9375 | 15.1875 | 14.9375 | 14.9375 | 9900.0 |
| 2000-04-24 | EWM | ETF | 24.5 | 24.5 | 24.0 | 24.25 | 13550.0 |
| 2000-04-24 | EWN | ETF | 23.5 | 23.5 | 23.25 | 23.25 | 600.0 |
| 2000-04-24 | EWO | ETF | 7.5625 | 7.625 | 7.375 | 7.5 | 4200.0 |
| 2000-04-24 | EWP | ETF | 27.6875 | 27.6875 | 27.0625 | 27.0625 | 6900.0 |
| 2000-04-24 | EWQ | ETF | 26.9375 | 26.9375 | 26.6875 | 26.6875 | 2100.0 |
| 2000-04-24 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.5 | 13250.0 |
| 2000-04-24 | EWU | ETF | 39.0 | 39.0 | 38.625 | 38.625 | 950.0 |
| 2000-04-24 | EWW | ETF | 15.5 | 15.9375 | 15.5 | 15.875 | 8700.0 |
| 2000-04-24 | FCTR | ETF | 13.0 | 13.25 | 12.5 | 13.125 | 19500.0 |
| 2000-04-24 | FMAR | ETF | 5.87 | 5.87 | 5.5 | 5.73 | 2400.0 |
| 2000-04-24 | GLDB | ETF | 6.75 | 7.0 | 6.5 | 6.8125 | 128900.0 |
| 2000-04-24 | GSIG | ETF | 16.87 | 17.0 | 15.25 | 15.94 | 372200.0 |
| 2000-04-24 | IGLD | ETF | 1112.5 | 1118.75 | 1006.25 | 1059.375 | 457.0 |
| 2000-04-24 | KTEC | ETF | 9.125 | 9.375 | 9.125 | 9.25 | 11100.0 |
| 2000-04-24 | MDY | ETF | 82.9375 | 84.0625 | 82.3438 | 83.3125 | 438000.0 |
| 2000-04-24 | MIG | ETF | 5.25 | 5.25 | 5.25 | 5.25 | 2100.0 |
| 2000-04-24 | PPH | ETF | 46.8125 | 48.4688 | 46.8125 | 48.125 | 732000.0 |
| 2000-04-24 | SFY | ETF | 19.875 | 20.3125 | 19.5 | 19.5625 | 79800.0 |
| 2000-04-24 | TDSC | ETF | 4.875 | 5.5 | 4.75 | 5.5 | 176400.0 |
| 2000-04-24 | TINY | ETF | 10.0 | 10.25 | 9.12 | 9.25 | 90700.0 |
| 2000-04-24 | XLB | ETF | 11.1562 | 11.3906 | 11.1562 | 11.2734 | 39800.0 |
| 2000-04-24 | XLE | ETF | 14.4062 | 14.5 | 14.2266 | 14.461 | 44000.0 |
| 2000-04-24 | XLF | ETF | 19.1409 | 19.6994 | 19.0394 | 19.6994 | 196468.0 |
| 2000-04-24 | XLI | ETF | 28.5 | 29.1094 | 28.5 | 28.75 | 8900.0 |
| 2000-04-24 | XLK | ETF | 25.3125 | 25.6875 | 24.6875 | 25.625 | 1222200.0 |
| 2000-04-24 | XLP | ETF | 22.75 | 23.4688 | 22.75 | 23.375 | 75300.0 |
| 2000-04-24 | XLU | ETF | 13.8906 | 14.2266 | 13.8906 | 14.1875 | 33400.0 |
| 2000-04-24 | XLV | ETF | 29.0 | 29.3125 | 28.875 | 29.1719 | 18000.0 |
| 2000-04-24 | XLY | ETF | 14.6094 | 15.0312 | 14.6094 | 14.7656 | 24600.0 |
> showing 46 of 46 rows — these rows as CSV