PREVIEW / etf_daily / 2000-04-28
file: by_date/etf_daily/2000/2000-04-28.parquet size: 6 KB rows: 47
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-28 | SPY | ETF | 147.0 | 147.8594 | 145.0625 | 145.0938 | 8743400.0 |
| 2000-04-28 | QQQ | ETF | 93.5625 | 94.75 | 92.125 | 94.75 | 24828400.0 |
| 2000-04-28 | DIA | ETF | 109.375 | 109.5 | 107.0 | 107.5625 | 1166000.0 |
| 2000-04-28 | BBH | ETF | 44.0 | 46.375 | 42.6875 | 45.9792 | 2327700.0 |
| 2000-04-28 | BITS | ETF | 23.125 | 25.0 | 23.125 | 23.75 | 11875.0 |
| 2000-04-28 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 29000.0 |
| 2000-04-28 | CHB | ETF | 7.0 | 7.25 | 7.0 | 7.06 | 66100.0 |
| 2000-04-28 | CNXT | ETF | 62.0 | 62.75 | 58.38 | 59.88 | 2683960.0 |
| 2000-04-28 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 200.0 |
| 2000-04-28 | EWA | ETF | 9.9375 | 9.9375 | 9.75 | 9.9375 | 5000.0 |
| 2000-04-28 | EWC | ETF | 18.0 | 18.0625 | 18.0 | 18.0625 | 2800.0 |
| 2000-04-28 | EWD | ETF | 33.375 | 33.375 | 33.0 | 33.125 | 1500.0 |
| 2000-04-28 | EWG | ETF | 24.6875 | 24.75 | 24.375 | 24.625 | 36800.0 |
| 2000-04-28 | EWH | ETF | 12.625 | 12.75 | 12.5 | 12.5625 | 90800.0 |
| 2000-04-28 | EWI | ETF | 46.25 | 46.75 | 46.25 | 46.75 | 450.0 |
| 2000-04-28 | EWJ | ETF | 61.25 | 61.25 | 60.5 | 61.0 | 64750.0 |
| 2000-04-28 | EWK | ETF | 12.25 | 12.4375 | 12.25 | 12.3125 | 23500.0 |
| 2000-04-28 | EWL | ETF | 14.75 | 14.875 | 14.625 | 14.875 | 3900.0 |
| 2000-04-28 | EWM | ETF | 24.75 | 25.0 | 24.25 | 25.0 | 47150.0 |
| 2000-04-28 | EWN | ETF | 22.8125 | 23.0625 | 22.8125 | 23.0625 | 4500.0 |
| 2000-04-28 | EWO | ETF | 7.5 | 7.5625 | 7.5 | 7.5625 | 10700.0 |
| 2000-04-28 | EWP | ETF | 26.375 | 26.625 | 26.3125 | 26.625 | 1300.0 |
| 2000-04-28 | EWQ | ETF | 26.875 | 27.125 | 26.875 | 27.0625 | 8800.0 |
| 2000-04-28 | EWS | ETF | 15.0 | 15.25 | 15.0 | 15.0 | 37250.0 |
| 2000-04-28 | EWU | ETF | 39.0 | 39.375 | 39.0 | 39.25 | 10400.0 |
| 2000-04-28 | EWW | ETF | 16.6875 | 16.75 | 16.5625 | 16.6875 | 6900.0 |
| 2000-04-28 | FCTR | ETF | 13.8125 | 14.0 | 13.8125 | 13.875 | 20500.0 |
| 2000-04-28 | FMAR | ETF | 5.72 | 5.75 | 5.5 | 5.5 | 10600.0 |
| 2000-04-28 | GLDB | ETF | 6.2813 | 6.375 | 6.125 | 6.1875 | 62000.0 |
| 2000-04-28 | GSIG | ETF | 18.37 | 19.12 | 18.06 | 18.81 | 415000.0 |
| 2000-04-28 | IGLD | ETF | 1175.0 | 1175.0 | 1125.0 | 1150.0 | 357.0 |
| 2000-04-28 | KTEC | ETF | 8.375 | 8.9375 | 7.625 | 7.75 | 21600.0 |
| 2000-04-28 | MDY | ETF | 88.125 | 89.125 | 87.25 | 88.375 | 650800.0 |
| 2000-04-28 | MIG | ETF | 5.5625 | 5.5625 | 5.375 | 5.375 | 5300.0 |
| 2000-04-28 | PPH | ETF | 47.0 | 47.125 | 46.2812 | 46.8125 | 186600.0 |
| 2000-04-28 | SFY | ETF | 20.3125 | 20.4375 | 20.0625 | 20.4375 | 52900.0 |
| 2000-04-28 | TDSC | ETF | 5.19 | 5.5 | 5.19 | 5.44 | 113600.0 |
| 2000-04-28 | TINY | ETF | 10.62 | 11.75 | 10.38 | 10.75 | 75300.0 |
| 2000-04-28 | XLB | ETF | 11.0156 | 11.2344 | 11.0156 | 11.1406 | 62400.0 |
| 2000-04-28 | XLE | ETF | 14.8438 | 14.8438 | 14.4375 | 14.4375 | 106000.0 |
| 2000-04-28 | XLF | ETF | 19.4963 | 19.9025 | 18.9379 | 19.9025 | 436143.0 |
| 2000-04-28 | XLI | ETF | 29.8438 | 29.8594 | 29.5 | 29.625 | 9600.0 |
| 2000-04-28 | XLK | ETF | 27.7188 | 27.8438 | 27.25 | 27.5 | 1293000.0 |
| 2000-04-28 | XLP | ETF | 22.9375 | 22.9375 | 22.2812 | 22.3438 | 56400.0 |
| 2000-04-28 | XLU | ETF | 14.25 | 14.3281 | 14.1562 | 14.2422 | 19400.0 |
| 2000-04-28 | XLV | ETF | 30.5781 | 30.5781 | 30.1875 | 30.3125 | 4900.0 |
| 2000-04-28 | XLY | ETF | 14.5938 | 14.6875 | 14.3281 | 14.3281 | 8600.0 |
> showing 47 of 47 rows — these rows as CSV