PREVIEW / etf_daily / 2000-05-09
file: by_date/etf_daily/2000/2000-05-09.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-05-09 | SPY | ETF | 143.0625 | 143.4062 | 140.2656 | 141.3125 | 5620300.0 |
| 2000-05-09 | QQQ | ETF | 88.5 | 89.125 | 84.3125 | 86.0 | 19805200.0 |
| 2000-05-09 | DIA | ETF | 106.0625 | 106.9375 | 105.0 | 105.375 | 1194600.0 |
| 2000-05-09 | BBH | ETF | 47.8333 | 48.4167 | 46.125 | 46.9167 | 1497000.0 |
| 2000-05-09 | BITS | ETF | 21.0 | 22.0 | 20.75 | 21.625 | 22875.0 |
| 2000-05-09 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.5 | 21400.0 |
| 2000-05-09 | CHB | ETF | 6.31 | 6.44 | 6.13 | 6.38 | 27100.0 |
| 2000-05-09 | CNXT | ETF | 48.69 | 49.13 | 43.0 | 43.63 | 5480600.0 |
| 2000-05-09 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 500.0 |
| 2000-05-09 | EWA | ETF | 9.625 | 9.75 | 9.625 | 9.75 | 10100.0 |
| 2000-05-09 | EWC | ETF | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 10400.0 |
| 2000-05-09 | EWD | ETF | 32.875 | 32.875 | 32.0 | 32.0 | 4700.0 |
| 2000-05-09 | EWG | ETF | 24.25 | 24.25 | 23.9375 | 24.125 | 22200.0 |
| 2000-05-09 | EWH | ETF | 11.9375 | 11.9375 | 11.5625 | 11.625 | 68900.0 |
| 2000-05-09 | EWI | ETF | 46.125 | 46.5 | 46.125 | 46.5 | 2400.0 |
| 2000-05-09 | EWJ | ETF | 60.5 | 60.75 | 60.0 | 60.25 | 71950.0 |
| 2000-05-09 | EWK | ETF | 12.0625 | 12.375 | 12.0625 | 12.375 | 2000.0 |
| 2000-05-09 | EWL | ETF | 14.875 | 15.125 | 14.875 | 15.0 | 2400.0 |
| 2000-05-09 | EWM | ETF | 26.25 | 26.5 | 26.0 | 26.25 | 13375.0 |
| 2000-05-09 | EWN | ETF | 22.75 | 23.0 | 22.75 | 23.0 | 1800.0 |
| 2000-05-09 | EWO | ETF | 7.3125 | 7.375 | 7.3125 | 7.375 | 13200.0 |
| 2000-05-09 | EWP | ETF | 25.9375 | 25.9375 | 25.5625 | 25.8125 | 7100.0 |
| 2000-05-09 | EWQ | ETF | 25.875 | 25.875 | 25.5625 | 25.75 | 5300.0 |
| 2000-05-09 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.25 | 20350.0 |
| 2000-05-09 | EWU | ETF | 37.625 | 37.875 | 37.25 | 37.375 | 6050.0 |
| 2000-05-09 | EWW | ETF | 15.625 | 15.625 | 15.125 | 15.25 | 16900.0 |
| 2000-05-09 | FCTR | ETF | 15.75 | 16.0 | 15.1875 | 16.0 | 16300.0 |
| 2000-05-09 | FMAR | ETF | 6.81 | 6.81 | 6.81 | 6.81 | 200.0 |
| 2000-05-09 | GLDB | ETF | 6.25 | 6.25 | 6.0 | 6.0 | 110400.0 |
| 2000-05-09 | GSIG | ETF | 19.94 | 20.5 | 19.5 | 20.25 | 482400.0 |
| 2000-05-09 | IGLD | ETF | 1181.25 | 1181.25 | 1087.5 | 1100.0 | 227.0 |
| 2000-05-09 | KTEC | ETF | 7.375 | 7.375 | 7.25 | 7.3125 | 104800.0 |
| 2000-05-09 | MDY | ETF | 89.0625 | 89.125 | 87.0 | 87.625 | 1032500.0 |
| 2000-05-09 | MIG | ETF | 5.125 | 5.375 | 5.125 | 5.375 | 6800.0 |
| 2000-05-09 | PPH | ETF | 49.5 | 49.5312 | 48.5312 | 49.0938 | 149600.0 |
| 2000-05-09 | SFY | ETF | 21.75 | 22.125 | 20.875 | 21.6875 | 134400.0 |
| 2000-05-09 | TDSC | ETF | 4.75 | 4.905 | 4.75 | 4.905 | 21600.0 |
| 2000-05-09 | TINY | ETF | 9.5 | 9.5 | 8.56 | 8.94 | 107500.0 |
| 2000-05-09 | XLB | ETF | 11.4844 | 11.5781 | 11.4297 | 11.5312 | 2156400.0 |
| 2000-05-09 | XLE | ETF | 15.375 | 15.3906 | 15.0938 | 15.2266 | 244800.0 |
| 2000-05-09 | XLF | ETF | 19.2425 | 19.471 | 18.8617 | 19.0775 | 701424.0 |
| 2000-05-09 | XLI | ETF | 29.5469 | 29.5469 | 29.1719 | 29.3125 | 10400.0 |
| 2000-05-09 | XLK | ETF | 25.9375 | 25.9688 | 25.0 | 25.289 | 2472400.0 |
| 2000-05-09 | XLP | ETF | 23.7656 | 23.8125 | 23.4688 | 23.8125 | 975200.0 |
| 2000-05-09 | XLU | ETF | 13.7969 | 13.8906 | 13.75 | 13.8281 | 20600.0 |
| 2000-05-09 | XLV | ETF | 28.9375 | 28.9375 | 28.6562 | 28.7031 | 6200.0 |
| 2000-05-09 | XLY | ETF | 14.0938 | 14.1875 | 14.0156 | 14.0156 | 35800.0 |
> showing 47 of 47 rows — these rows as CSV