PREVIEW / etf_daily / 2000-05-05
file: by_date/etf_daily/2000/2000-05-05.parquet size: 6 KB rows: 45
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-05 | SPY | ETF | 141.0625 | 144.0 | 140.9375 | 143.5312 | 7862400.0 |
| 2000-05-05 | QQQ | ETF | 88.125 | 92.3125 | 88.0313 | 91.4375 | 20571200.0 |
| 2000-05-05 | DIA | ETF | 103.3125 | 105.8906 | 103.3125 | 105.8438 | 1352100.0 |
| 2000-05-05 | BBH | ETF | 46.8333 | 48.5625 | 46.6667 | 48.0833 | 1468800.0 |
| 2000-05-05 | BITS | ETF | 23.5 | 25.0 | 22.25 | 22.25 | 21400.0 |
| 2000-05-05 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5 | 13200.0 |
| 2000-05-05 | CHB | ETF | 6.38 | 6.56 | 6.25 | 6.31 | 92400.0 |
| 2000-05-05 | CNXT | ETF | 48.31 | 53.25 | 48.31 | 51.19 | 3757140.0 |
| 2000-05-05 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 1000.0 |
| 2000-05-05 | EWA | ETF | 9.75 | 9.9375 | 9.625 | 9.8125 | 85300.0 |
| 2000-05-05 | EWC | ETF | 17.875 | 18.25 | 17.875 | 18.0625 | 12500.0 |
| 2000-05-05 | EWD | ETF | 33.125 | 33.1875 | 33.125 | 33.1875 | 1400.0 |
| 2000-05-05 | EWG | ETF | 24.0625 | 24.6875 | 24.0625 | 24.625 | 27500.0 |
| 2000-05-05 | EWH | ETF | 12.0625 | 12.375 | 12.0625 | 12.3125 | 38800.0 |
| 2000-05-05 | EWI | ETF | 46.25 | 47.0 | 46.25 | 46.75 | 26250.0 |
| 2000-05-05 | EWJ | ETF | 61.25 | 62.0 | 61.0 | 61.5 | 39100.0 |
| 2000-05-05 | EWK | ETF | 12.1875 | 12.1875 | 11.875 | 12.125 | 81500.0 |
| 2000-05-05 | EWL | ETF | 14.875 | 14.875 | 14.625 | 14.625 | 68300.0 |
| 2000-05-05 | EWM | ETF | 25.75 | 26.25 | 25.5 | 25.75 | 18750.0 |
| 2000-05-05 | EWN | ETF | 22.9375 | 23.25 | 22.6875 | 23.25 | 2700.0 |
| 2000-05-05 | EWP | ETF | 26.0 | 26.3125 | 26.0 | 26.3125 | 36100.0 |
| 2000-05-05 | EWQ | ETF | 26.625 | 27.1875 | 26.625 | 27.1875 | 56100.0 |
| 2000-05-05 | EWS | ETF | 14.625 | 15.0 | 14.5 | 14.75 | 38100.0 |
| 2000-05-05 | EWU | ETF | 37.875 | 38.125 | 37.625 | 38.0 | 3550.0 |
| 2000-05-05 | FCTR | ETF | 16.25 | 17.5 | 16.0 | 17.5 | 92500.0 |
| 2000-05-05 | FMAR | ETF | 6.88 | 6.88 | 6.5 | 6.69 | 3800.0 |
| 2000-05-05 | GLDB | ETF | 6.3438 | 6.375 | 6.25 | 6.25 | 100500.0 |
| 2000-05-05 | GSIG | ETF | 19.0 | 19.25 | 17.94 | 19.0 | 389100.0 |
| 2000-05-05 | IGLD | ETF | 1125.0 | 1200.0 | 1125.0 | 1175.0 | 403.0 |
| 2000-05-05 | KTEC | ETF | 7.125 | 7.5 | 7.125 | 7.5 | 1400.0 |
| 2000-05-05 | MDY | ETF | 87.8125 | 89.5 | 87.5625 | 89.4375 | 361300.0 |
| 2000-05-05 | MIG | ETF | 5.125 | 5.125 | 5.0625 | 5.0625 | 5000.0 |
| 2000-05-05 | PPH | ETF | 46.9375 | 48.4375 | 46.7188 | 48.2812 | 159400.0 |
| 2000-05-05 | SFY | ETF | 22.9375 | 23.5 | 22.5 | 22.5 | 178000.0 |
| 2000-05-05 | TDSC | ETF | 4.875 | 5.06 | 4.875 | 5.03 | 13600.0 |
| 2000-05-05 | TINY | ETF | 9.5 | 9.75 | 9.0 | 9.75 | 66600.0 |
| 2000-05-05 | XLB | ETF | 11.3906 | 11.5 | 11.3828 | 11.3906 | 20600.0 |
| 2000-05-05 | XLE | ETF | 14.875 | 15.0547 | 14.8125 | 15.0312 | 71200.0 |
| 2000-05-05 | XLF | ETF | 18.4301 | 18.8109 | 18.4048 | 18.7602 | 74476.0 |
| 2000-05-05 | XLI | ETF | 29.2812 | 29.7812 | 29.1719 | 29.5625 | 7200.0 |
| 2000-05-05 | XLK | ETF | 26.2812 | 26.8125 | 26.1875 | 26.711 | 600000.0 |
| 2000-05-05 | XLP | ETF | 22.625 | 23.2188 | 22.625 | 23.2188 | 11600.0 |
| 2000-05-05 | XLU | ETF | 13.664 | 13.7812 | 13.6562 | 13.7812 | 29800.0 |
| 2000-05-05 | XLV | ETF | 28.7812 | 29.0312 | 28.7812 | 28.8438 | 4700.0 |
| 2000-05-05 | XLY | ETF | 13.7656 | 13.9375 | 13.7656 | 13.914 | 30200.0 |
> showing 45 of 45 rows — these rows as CSV