PREVIEW / etf_daily / 2000-12-19
file: by_date/etf_daily/2000/2000-12-19.parquet size: 8 KB rows: 92
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-12-19 | SPY | ETF | 132.4688 | 134.9688 | 130.0156 | 130.0156 | 9616600.0 |
| 2000-12-19 | QQQ | ETF | 63.4531 | 65.8594 | 58.7656 | 59.125 | 80498200.0 |
| 2000-12-19 | IWM | ETF | 46.25 | 46.75 | 45.5 | 45.5 | 453800.0 |
| 2000-12-19 | DIA | ETF | 106.5312 | 107.9062 | 105.5625 | 105.6094 | 1554800.0 |
| 2000-12-19 | BBH | ETF | 58.2083 | 60.3125 | 56.6667 | 56.9167 | 4720200.0 |
| 2000-12-19 | BITS | ETF | 12.0 | 13.0 | 11.5 | 12.0 | 9825.0 |
| 2000-12-19 | CEF | ETF | 3.0 | 3.125 | 3.0 | 3.0625 | 20200.0 |
| 2000-12-19 | CHB | ETF | 2.94 | 3.0 | 2.75 | 2.81 | 182300.0 |
| 2000-12-19 | CNXT | ETF | 23.5 | 24.37 | 21.12 | 21.44 | 6176200.0 |
| 2000-12-19 | CSB | ETF | 1.00999999046326 | 1.00999999046326 | 1.00999999046326 | 1.00999999046326 | 50000.0 |
| 2000-12-19 | DGT | ETF | 77.875 | 78.0 | 77.875 | 78.0 | 20400.0 |
| 2000-12-19 | EWA | ETF | 9.3125 | 9.5 | 9.3125 | 9.3125 | 3100.0 |
| 2000-12-19 | EWC | ETF | 13.4375 | 13.625 | 13.3125 | 13.3125 | 29400.0 |
| 2000-12-19 | EWD | ETF | 18.0 | 18.375 | 18.0 | 18.3125 | 14900.0 |
| 2000-12-19 | EWG | ETF | 18.4375 | 18.625 | 18.375 | 18.375 | 250500.0 |
| 2000-12-19 | EWH | ETF | 11.375 | 11.5625 | 11.25 | 11.25 | 43100.0 |
| 2000-12-19 | EWI | ETF | 42.75 | 43.25 | 42.75 | 42.75 | 15750.0 |
| 2000-12-19 | EWJ | ETF | 45.75 | 46.25 | 45.25 | 45.25 | 231025.0 |
| 2000-12-19 | EWL | ETF | 16.0625 | 16.0625 | 15.6875 | 15.6875 | 27500.0 |
| 2000-12-19 | EWM | ETF | 21.25 | 21.25 | 21.25 | 21.25 | 4875.0 |
| 2000-12-19 | EWN | ETF | 21.375 | 21.75 | 21.375 | 21.625 | 17100.0 |
| 2000-12-19 | EWO | ETF | 7.25 | 7.25 | 7.1875 | 7.1875 | 1600.0 |
| 2000-12-19 | EWP | ETF | 22.375 | 22.4375 | 22.25 | 22.3125 | 6400.0 |
| 2000-12-19 | EWQ | ETF | 23.5625 | 23.6875 | 23.5 | 23.6875 | 40200.0 |
| 2000-12-19 | EWS | ETF | 13.5 | 13.75 | 13.375 | 13.375 | 11250.0 |
| 2000-12-19 | EWT | ETF | 21.875 | 21.875 | 21.875 | 21.875 | 1150.0 |
| 2000-12-19 | EWU | ETF | 35.125 | 35.25 | 34.625 | 34.625 | 100000.0 |
| 2000-12-19 | EWW | ETF | 13.875 | 14.0 | 13.375 | 13.4375 | 24700.0 |
| 2000-12-19 | EWY | ETF | 13.5 | 13.5 | 13.25 | 13.25 | 17800.0 |
| 2000-12-19 | EWZ | ETF | 16.375 | 16.375 | 16.375 | 16.375 | 600.0 |
| 2000-12-19 | EZU | ETF | 34.9688 | 35.5938 | 34.9688 | 35.25 | 19200.0 |
| 2000-12-19 | FCTR | ETF | 13.2813 | 13.8906 | 13.25 | 13.8906 | 34800.0 |
| 2000-12-19 | FMAR | ETF | 3.81 | 3.81 | 3.81 | 3.81 | 1700.0 |
| 2000-12-19 | GLDB | ETF | 4.375 | 4.4063 | 4.125 | 4.125 | 59100.0 |
| 2000-12-19 | GSIG | ETF | 7.87 | 8.44 | 7.5 | 8.12 | 1767100.0 |
| 2000-12-19 | IDU | ETF | 42.7188 | 43.0312 | 42.7188 | 42.9375 | 28400.0 |
| 2000-12-19 | IEV | ETF | 36.9688 | 37.5 | 36.9688 | 37.25 | 230600.0 |
| 2000-12-19 | IGLD | ETF | 193.75 | 203.125 | 190.625 | 193.75 | 485.0 |
| 2000-12-19 | IJH | ETF | 9.9844 | 10.1469 | 9.8875 | 9.9031 | 796000.0 |
| 2000-12-19 | IJJ | ETF | 20.0469 | 20.125 | 19.9531 | 19.9531 | 446800.0 |
| 2000-12-19 | IJK | ETF | 15.7226 | 15.9394 | 15.2949 | 15.2949 | 245600.0 |
| 2000-12-19 | IJR | ETF | 17.2292 | 17.4037 | 17.0156 | 17.0156 | 186600.0 |
| 2000-12-19 | IJS | ETF | 17.8594 | 17.9375 | 17.836 | 17.9219 | 8400.0 |
| 2000-12-19 | IJT | ETF | 19.2539 | 19.4922 | 18.9961 | 19.0156 | 140800.0 |
| 2000-12-19 | IOO | ETF | 34.6719 | 34.6719 | 34.6719 | 34.6719 | 400.0 |
| 2000-12-19 | IUSG | ETF | 26.5 | 26.5 | 26.5 | 26.5 | 3000.0 |
| 2000-12-19 | IUSV | ETF | 24.651 | 24.651 | 24.651 | 24.651 | 600.0 |
| 2000-12-19 | IVE | ETF | 62.125 | 62.7188 | 61.4688 | 61.4688 | 238300.0 |
| 2000-12-19 | IVV | ETF | 132.1562 | 134.7812 | 130.0 | 130.0 | 115200.0 |
| 2000-12-19 | IVW | ETF | 17.75 | 18.211 | 17.3828 | 17.3828 | 552000.0 |
> showing 50 of 92 rows — these rows as CSV