PREVIEW / etf_daily / 2000-07-03
file: by_date/etf_daily/2000/2000-07-03.parquet size: 7 KB rows: 66
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-07-03 | SPY | ETF | 145.4375 | 147.4375 | 145.1875 | 147.2812 | 1436600.0 |
| 2000-07-03 | QQQ | ETF | 93.5 | 95.25 | 93.25 | 95.25 | 5212000.0 |
| 2000-07-03 | IWM | ETF | 51.5625 | 52.4062 | 51.5 | 52.4062 | 15800.0 |
| 2000-07-03 | DIA | ETF | 104.75 | 105.9688 | 104.3438 | 105.9688 | 267700.0 |
| 2000-07-03 | BBH | ETF | 59.5 | 60.7917 | 59.5 | 60.75 | 444300.0 |
| 2000-07-03 | BITS | ETF | 24.75 | 26.0 | 24.5 | 24.5 | 4675.0 |
| 2000-07-03 | BOSS | ETF | 16.0 | 16.5 | 16.0 | 16.5 | 100.0 |
| 2000-07-03 | CEF | ETF | 3.5625 | 3.5625 | 3.5 | 3.5625 | 13800.0 |
| 2000-07-03 | CHB | ETF | 5.0 | 5.38 | 5.0 | 5.38 | 13800.0 |
| 2000-07-03 | CNXT | ETF | 48.25 | 51.25 | 47.88 | 50.13 | 1928700.0 |
| 2000-07-03 | CSB | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 3000.0 |
| 2000-07-03 | EWA | ETF | 10.5625 | 10.8125 | 10.5625 | 10.8125 | 4300.0 |
| 2000-07-03 | EWC | ETF | 19.6875 | 19.875 | 19.6875 | 19.75 | 6600.0 |
| 2000-07-03 | EWD | ETF | 31.375 | 31.375 | 31.375 | 31.375 | 4600.0 |
| 2000-07-03 | EWG | ETF | 24.0 | 24.125 | 23.625 | 24.0 | 187100.0 |
| 2000-07-03 | EWH | ETF | 12.25 | 12.625 | 12.25 | 12.5 | 9400.0 |
| 2000-07-03 | EWI | ETF | 51.375 | 51.75 | 51.375 | 51.5 | 2050.0 |
| 2000-07-03 | EWJ | ETF | 61.0 | 61.25 | 60.75 | 61.25 | 34175.0 |
| 2000-07-03 | EWK | ETF | 13.6875 | 13.75 | 13.6875 | 13.75 | 3200.0 |
| 2000-07-03 | EWL | ETF | 15.8125 | 15.8125 | 15.8125 | 15.8125 | 500.0 |
| 2000-07-03 | EWM | ETF | 24.0 | 24.25 | 23.75 | 24.0 | 13175.0 |
| 2000-07-03 | EWN | ETF | 24.625 | 24.75 | 24.4375 | 24.75 | 900.0 |
| 2000-07-03 | EWO | ETF | 8.0625 | 8.0625 | 8.0625 | 8.0625 | 200.0 |
| 2000-07-03 | EWP | ETF | 26.375 | 26.375 | 26.1875 | 26.1875 | 1600.0 |
| 2000-07-03 | EWQ | ETF | 28.8125 | 29.125 | 28.625 | 28.9375 | 12500.0 |
| 2000-07-03 | EWS | ETF | 15.0 | 15.125 | 14.875 | 15.125 | 11350.0 |
| 2000-07-03 | EWU | ETF | 38.0 | 39.25 | 38.0 | 39.25 | 7450.0 |
| 2000-07-03 | EWW | ETF | 17.875 | 18.125 | 17.75 | 18.0625 | 70600.0 |
| 2000-07-03 | EWY | ETF | 21.6875 | 21.6875 | 21.6875 | 21.6875 | 3000.0 |
| 2000-07-03 | FCTR | ETF | 15.5625 | 16.5 | 15.5 | 15.8125 | 25500.0 |
| 2000-07-03 | FMAR | ETF | 5.88 | 5.88 | 5.317 | 5.317 | 2100.0 |
| 2000-07-03 | GLDB | ETF | 5.3438 | 5.8125 | 5.25 | 5.5 | 105200.0 |
| 2000-07-03 | GSIG | ETF | 35.37 | 41.81 | 35.0 | 39.87 | 1587100.0 |
| 2000-07-03 | IGLD | ETF | 821.875 | 862.5 | 818.75 | 825.0 | 122.0 |
| 2000-07-03 | IJH | ETF | 9.7031 | 9.8328 | 9.7 | 9.8328 | 526000.0 |
| 2000-07-03 | IJR | ETF | 17.6042 | 17.7318 | 17.5625 | 17.7318 | 356400.0 |
| 2000-07-03 | IVE | ETF | 58.375 | 59.1406 | 58.375 | 59.1406 | 2500.0 |
| 2000-07-03 | IVV | ETF | 145.5 | 147.1406 | 145.4688 | 147.1406 | 7100.0 |
| 2000-07-03 | IVW | ETF | 22.5781 | 22.7031 | 22.5781 | 22.7031 | 4400.0 |
| 2000-07-03 | IWB | ETF | 77.0625 | 77.5312 | 77.0625 | 77.5312 | 1500.0 |
| 2000-07-03 | IWD | ETF | 54.375 | 54.4375 | 54.375 | 54.4375 | 800.0 |
| 2000-07-03 | IWF | ETF | 21.59765 | 21.8164 | 21.59765 | 21.8164 | 70400.0 |
| 2000-07-03 | IYE | ETF | 16.3333 | 16.4583 | 16.2604 | 16.4375 | 5100.0 |
| 2000-07-03 | IYF | ETF | 35.3281 | 35.5469 | 35.3281 | 35.4844 | 4400.0 |
| 2000-07-03 | IYH | ETF | 13.1625 | 13.2062 | 13.1 | 13.2 | 15000.0 |
| 2000-07-03 | IYM | ETF | 33.875 | 33.875 | 33.875 | 33.875 | 200.0 |
| 2000-07-03 | IYR | ETF | 35.4219 | 35.5781 | 35.4219 | 35.5781 | 45400.0 |
| 2000-07-03 | IYW | ETF | 32.0586 | 32.1406 | 32.0586 | 32.1406 | 800.0 |
| 2000-07-03 | IYY | ETF | 34.0625 | 34.1016 | 34.0625 | 34.1016 | 2400.0 |
| 2000-07-03 | IYZ | ETF | 60.5 | 60.9688 | 60.5 | 60.9688 | 700.0 |
> showing 50 of 66 rows — these rows as CSV