PREVIEW / etf_daily / 2000-10-04
file: by_date/etf_daily/2000/2000-10-04.parquet size: 8 KB rows: 87
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-10-04 | SPY | ETF | 142.875 | 144.25 | 141.75 | 143.6875 | 6148900.0 |
| 2000-10-04 | QQQ | ETF | 83.5 | 86.8594 | 82.125 | 85.625 | 37677200.0 |
| 2000-10-04 | IWM | ETF | 50.4531 | 50.5781 | 49.8125 | 50.5781 | 99800.0 |
| 2000-10-04 | DIA | ETF | 107.5625 | 108.625 | 107.1562 | 107.8906 | 1312100.0 |
| 2000-10-04 | BBH | ETF | 60.6875 | 60.9583 | 58.6667 | 59.8542 | 4185000.0 |
| 2000-10-04 | BITS | ETF | 14.625 | 14.625 | 13.5 | 14.0 | 4025.0 |
| 2000-10-04 | CEF | ETF | 3.25 | 3.25 | 3.1875 | 3.1875 | 24500.0 |
| 2000-10-04 | CHB | ETF | 3.75 | 4.0 | 3.63 | 4.0 | 148200.0 |
| 2000-10-04 | CNXT | ETF | 36.06 | 36.06 | 33.06 | 33.25 | 9056090.0 |
| 2000-10-04 | CSB | ETF | 1.10000002384186 | 1.10000002384186 | 1.0 | 1.0900000333786 | 12000.0 |
| 2000-10-04 | DGT | ETF | 84.5938 | 85.4844 | 84.5938 | 85.4844 | 11000.0 |
| 2000-10-04 | EWA | ETF | 9.625 | 9.625 | 9.5625 | 9.625 | 11700.0 |
| 2000-10-04 | EWC | ETF | 16.0625 | 16.375 | 16.0625 | 16.375 | 12200.0 |
| 2000-10-04 | EWD | ETF | 21.625 | 21.875 | 21.625 | 21.875 | 2600.0 |
| 2000-10-04 | EWG | ETF | 19.1875 | 19.3125 | 19.0625 | 19.1875 | 468000.0 |
| 2000-10-04 | EWH | ETF | 11.9375 | 12.3125 | 11.9375 | 12.25 | 73600.0 |
| 2000-10-04 | EWI | ETF | 42.5 | 42.5 | 42.5 | 42.5 | 900.0 |
| 2000-10-04 | EWJ | ETF | 53.75 | 54.0 | 53.5 | 54.0 | 71550.0 |
| 2000-10-04 | EWK | ETF | 12.625 | 12.625 | 12.625 | 12.625 | 300.0 |
| 2000-10-04 | EWL | ETF | 15.125 | 15.375 | 15.125 | 15.3125 | 3200.0 |
| 2000-10-04 | EWM | ETF | 20.75 | 21.0 | 20.75 | 20.75 | 3775.0 |
| 2000-10-04 | EWN | ETF | 22.6875 | 22.6875 | 22.5625 | 22.5625 | 1100.0 |
| 2000-10-04 | EWO | ETF | 7.75 | 7.75 | 7.5625 | 7.625 | 3200.0 |
| 2000-10-04 | EWP | ETF | 24.625 | 24.6875 | 24.625 | 24.6875 | 800.0 |
| 2000-10-04 | EWQ | ETF | 24.75 | 24.75 | 24.5625 | 24.75 | 13200.0 |
| 2000-10-04 | EWS | ETF | 13.5 | 13.5 | 13.25 | 13.375 | 14150.0 |
| 2000-10-04 | EWT | ETF | 26.75 | 27.0 | 26.125 | 26.125 | 21500.0 |
| 2000-10-04 | EWU | ETF | 35.625 | 35.75 | 35.25 | 35.75 | 8850.0 |
| 2000-10-04 | EWW | ETF | 14.9375 | 15.3125 | 14.8125 | 15.3125 | 57800.0 |
| 2000-10-04 | EWY | ETF | 15.8125 | 15.8125 | 15.75 | 15.75 | 1500.0 |
| 2000-10-04 | EWZ | ETF | 17.5625 | 18.0 | 17.5625 | 18.0 | 200.0 |
| 2000-10-04 | EZU | ETF | 36.1875 | 36.1875 | 35.875 | 36.1875 | 3800.0 |
| 2000-10-04 | FCTR | ETF | 14.125 | 14.25 | 14.125 | 14.125 | 31400.0 |
| 2000-10-04 | FMAR | ETF | 5.0 | 5.0 | 5.0 | 5.0 | 4800.0 |
| 2000-10-04 | GLDB | ETF | 4.9531 | 5.0 | 4.9375 | 5.0 | 33100.0 |
| 2000-10-04 | GSIG | ETF | 15.97 | 17.06 | 15.94 | 17.06 | 502300.0 |
| 2000-10-04 | IDU | ETF | 42.8906 | 43.0625 | 41.3281 | 41.6719 | 144200.0 |
| 2000-10-04 | IEV | ETF | 37.8125 | 38.0312 | 37.8125 | 38.0312 | 10600.0 |
| 2000-10-04 | IGLD | ETF | 550.0 | 550.0 | 537.5 | 537.5 | 568.0 |
| 2000-10-04 | IJH | ETF | 10.4125 | 10.4766 | 10.35 | 10.4609 | 1120000.0 |
| 2000-10-04 | IJJ | ETF | 19.4336 | 19.5156 | 19.3516 | 19.3516 | 36800.0 |
| 2000-10-04 | IJK | ETF | 17.2422 | 17.377 | 17.2246 | 17.2246 | 8800.0 |
| 2000-10-04 | IJR | ETF | 17.5625 | 17.7969 | 17.5261 | 17.7969 | 44400.0 |
| 2000-10-04 | IJS | ETF | 17.6719 | 17.7812 | 17.6406 | 17.7812 | 224000.0 |
| 2000-10-04 | IJT | ETF | 20.1484 | 20.375 | 20.1484 | 20.375 | 5600.0 |
| 2000-10-04 | IUSV | ETF | 24.5729 | 24.6198 | 24.5729 | 24.6198 | 2700.0 |
| 2000-10-04 | IVE | ETF | 63.375 | 63.7656 | 63.2344 | 63.2344 | 8700.0 |
| 2000-10-04 | IVV | ETF | 142.625 | 144.125 | 142.0 | 143.6719 | 90000.0 |
| 2000-10-04 | IVW | ETF | 20.2266 | 20.5938 | 20.0508 | 20.5898 | 119200.0 |
| 2000-10-04 | IWB | ETF | 76.19 | 76.67 | 76.19 | 76.67 | 1500.0 |
> showing 50 of 87 rows — these rows as CSV