PREVIEW / etf_daily / 2000-11-09
file: by_date/etf_daily/2000/2000-11-09.parquet size: 8 KB rows: 94
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-11-09 | SPY | ETF | 140.0 | 141.2188 | 137.25 | 140.0312 | 10635300.0 |
| 2000-11-09 | QQQ | ETF | 74.75 | 76.9375 | 73.0 | 75.6875 | 64955900.0 |
| 2000-11-09 | IWM | ETF | 49.375 | 49.6875 | 48.5312 | 49.25 | 249000.0 |
| 2000-11-09 | DIA | ETF | 107.9375 | 108.9688 | 106.25 | 108.2188 | 3839200.0 |
| 2000-11-09 | BBH | ETF | 61.6875 | 62.1667 | 58.75 | 61.2292 | 3508200.0 |
| 2000-11-09 | BITS | ETF | 13.0 | 13.0 | 11.0 | 12.125 | 1800.0 |
| 2000-11-09 | BOSS | ETF | 25.7 | 26.2 | 25.7 | 26.2 | 300.0 |
| 2000-11-09 | CEF | ETF | 3.0 | 3.0 | 2.9375 | 3.0 | 8400.0 |
| 2000-11-09 | CHB | ETF | 3.25 | 3.5 | 3.19 | 3.5 | 36900.0 |
| 2000-11-09 | CNXT | ETF | 25.87 | 28.25 | 25.62 | 27.94 | 3460680.0 |
| 2000-11-09 | CSB | ETF | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 1300.0 |
| 2000-11-09 | DGT | ETF | 84.0625 | 84.0625 | 82.4375 | 83.9062 | 4700.0 |
| 2000-11-09 | EWA | ETF | 9.375 | 9.375 | 9.1875 | 9.3125 | 11800.0 |
| 2000-11-09 | EWC | ETF | 14.5 | 14.5 | 14.25 | 14.3125 | 22800.0 |
| 2000-11-09 | EWD | ETF | 19.1875 | 19.25 | 19.1875 | 19.25 | 3000.0 |
| 2000-11-09 | EWG | ETF | 19.25 | 19.5 | 19.1875 | 19.5 | 83900.0 |
| 2000-11-09 | EWH | ETF | 11.4375 | 11.625 | 11.25 | 11.5625 | 55500.0 |
| 2000-11-09 | EWI | ETF | 44.0 | 45.0 | 44.0 | 44.875 | 4350.0 |
| 2000-11-09 | EWJ | ETF | 51.25 | 51.5 | 50.75 | 51.0 | 42550.0 |
| 2000-11-09 | EWK | ETF | 12.6875 | 12.6875 | 12.6875 | 12.6875 | 400.0 |
| 2000-11-09 | EWL | ETF | 15.1875 | 15.375 | 15.1875 | 15.25 | 27300.0 |
| 2000-11-09 | EWM | ETF | 23.0 | 23.0 | 22.5 | 22.5 | 1125.0 |
| 2000-11-09 | EWN | ETF | 22.1875 | 22.6875 | 22.1875 | 22.6875 | 1800.0 |
| 2000-11-09 | EWO | ETF | 7.375 | 7.375 | 7.375 | 7.375 | 10000.0 |
| 2000-11-09 | EWP | ETF | 23.1875 | 23.5 | 23.125 | 23.3125 | 1700.0 |
| 2000-11-09 | EWQ | ETF | 24.0625 | 24.125 | 24.0 | 24.125 | 29500.0 |
| 2000-11-09 | EWS | ETF | 13.875 | 13.875 | 13.75 | 13.75 | 14300.0 |
| 2000-11-09 | EWT | ETF | 27.5 | 27.5 | 27.25 | 27.25 | 352500.0 |
| 2000-11-09 | EWU | ETF | 35.0 | 35.625 | 35.0 | 35.625 | 21900.0 |
| 2000-11-09 | EWW | ETF | 15.25 | 15.25 | 14.75 | 14.75 | 13500.0 |
| 2000-11-09 | EWY | ETF | 14.6875 | 14.875 | 14.6875 | 14.875 | 5200.0 |
| 2000-11-09 | EWZ | ETF | 15.5625 | 15.5625 | 15.5 | 15.5 | 1500.0 |
| 2000-11-09 | EZU | ETF | 36.0 | 36.1875 | 35.5 | 36.1875 | 4600.0 |
| 2000-11-09 | FCTR | ETF | 14.8125 | 15.0625 | 14.75 | 15.0 | 14900.0 |
| 2000-11-09 | FMAR | ETF | 4.0 | 4.66 | 4.0 | 4.66 | 5000.0 |
| 2000-11-09 | GLDB | ETF | 4.4375 | 4.5625 | 4.375 | 4.5625 | 49200.0 |
| 2000-11-09 | GSIG | ETF | 12.75 | 12.75 | 11.5 | 11.94 | 192800.0 |
| 2000-11-09 | IDU | ETF | 41.7656 | 41.7656 | 41.0938 | 41.5 | 4000.0 |
| 2000-11-09 | IEV | ETF | 36.6875 | 37.25 | 36.6562 | 37.25 | 67400.0 |
| 2000-11-09 | IGLD | ETF | 300.0 | 303.125 | 281.25 | 300.0 | 677.0 |
| 2000-11-09 | IJH | ETF | 10.3219 | 10.3656 | 10.1375 | 10.2875 | 1255000.0 |
| 2000-11-09 | IJJ | ETF | 19.4219 | 19.4766 | 19.2461 | 19.4219 | 302000.0 |
| 2000-11-09 | IJK | ETF | 16.9219 | 17.084 | 16.5859 | 16.9277 | 64000.0 |
| 2000-11-09 | IJR | ETF | 17.7917 | 17.9688 | 17.6693 | 17.9011 | 157800.0 |
| 2000-11-09 | IJS | ETF | 18.1172 | 18.1172 | 17.9062 | 17.9297 | 40800.0 |
| 2000-11-09 | IJT | ETF | 20.3984 | 20.5234 | 20.1562 | 20.461 | 16800.0 |
| 2000-11-09 | IUSG | ETF | 29.8672 | 29.8672 | 29.8672 | 29.8672 | 200.0 |
| 2000-11-09 | IUSV | ETF | 24.9271 | 24.9271 | 24.5052 | 24.8125 | 249000.0 |
| 2000-11-09 | IVE | ETF | 63.5 | 63.7188 | 62.6562 | 63.3125 | 116100.0 |
| 2000-11-09 | IVV | ETF | 139.9531 | 141.0156 | 137.4375 | 139.9219 | 95300.0 |
> showing 50 of 94 rows — these rows as CSV