PREVIEW / etf_daily / 2000-11-01
file: by_date/etf_daily/2000/2000-11-01.parquet size: 8 KB rows: 85
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-01 | SPY | ETF | 142.25 | 143.25 | 141.2188 | 142.4688 | 6753600.0 |
| 2000-11-01 | QQQ | ETF | 80.3125 | 82.8125 | 79.1875 | 81.0 | 45186500.0 |
| 2000-11-01 | IWM | ETF | 49.3438 | 49.7188 | 49.2812 | 49.5312 | 528200.0 |
| 2000-11-01 | DIA | ETF | 109.1562 | 109.9219 | 108.4375 | 109.1562 | 3410300.0 |
| 2000-11-01 | BBH | ETF | 59.875 | 61.9375 | 59.3333 | 61.4792 | 2319000.0 |
| 2000-11-01 | BITS | ETF | 12.5 | 13.5 | 10.5 | 11.875 | 13800.0 |
| 2000-11-01 | CEF | ETF | 2.9375 | 2.9375 | 2.75 | 2.875 | 150900.0 |
| 2000-11-01 | CHB | ETF | 3.88 | 3.88 | 3.38 | 3.56 | 60600.0 |
| 2000-11-01 | CNXT | ETF | 25.19 | 27.69 | 24.62 | 25.37 | 5232870.0 |
| 2000-11-01 | CSB | ETF | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 1.20000004768372 | 5000.0 |
| 2000-11-01 | DGT | ETF | 84.4688 | 84.4688 | 84.4688 | 84.4688 | 100.0 |
| 2000-11-01 | EWA | ETF | 9.0625 | 9.1875 | 9.0 | 9.125 | 30400.0 |
| 2000-11-01 | EWC | ETF | 14.9375 | 14.9375 | 14.75 | 14.8125 | 39100.0 |
| 2000-11-01 | EWD | ETF | 20.0625 | 20.5 | 20.0625 | 20.5 | 5400.0 |
| 2000-11-01 | EWG | ETF | 19.5 | 19.8125 | 19.375 | 19.625 | 138200.0 |
| 2000-11-01 | EWH | ETF | 11.5625 | 11.625 | 11.375 | 11.5 | 48300.0 |
| 2000-11-01 | EWI | ETF | 43.25 | 44.125 | 43.25 | 43.625 | 16650.0 |
| 2000-11-01 | EWJ | ETF | 50.75 | 51.0 | 50.5 | 50.5 | 62175.0 |
| 2000-11-01 | EWL | ETF | 14.9375 | 15.25 | 14.9375 | 15.25 | 600.0 |
| 2000-11-01 | EWM | ETF | 22.5 | 23.5 | 22.5 | 23.0 | 31925.0 |
| 2000-11-01 | EWN | ETF | 22.125 | 22.6875 | 22.125 | 22.4375 | 26900.0 |
| 2000-11-01 | EWP | ETF | 23.3125 | 23.5625 | 23.3125 | 23.5 | 16500.0 |
| 2000-11-01 | EWQ | ETF | 24.125 | 24.5 | 24.0 | 24.375 | 35800.0 |
| 2000-11-01 | EWS | ETF | 14.0 | 14.25 | 14.0 | 14.125 | 22350.0 |
| 2000-11-01 | EWT | ETF | 24.125 | 24.5 | 24.0 | 24.5 | 28950.0 |
| 2000-11-01 | EWU | ETF | 35.375 | 36.125 | 35.375 | 35.75 | 88700.0 |
| 2000-11-01 | EWW | ETF | 15.25 | 15.625 | 15.25 | 15.375 | 10400.0 |
| 2000-11-01 | EWY | ETF | 14.375 | 14.6875 | 14.3125 | 14.3125 | 32800.0 |
| 2000-11-01 | EWZ | ETF | 16.3125 | 16.5 | 16.3125 | 16.5 | 1200.0 |
| 2000-11-01 | EZU | ETF | 35.8125 | 36.25 | 35.8125 | 36.0 | 105600.0 |
| 2000-11-01 | FCTR | ETF | 15.3125 | 15.4375 | 15.25 | 15.3125 | 25400.0 |
| 2000-11-01 | FMAR | ETF | 4.88 | 4.88 | 4.81 | 4.81 | 1500.0 |
| 2000-11-01 | GLDB | ETF | 4.5938 | 5.0 | 4.5 | 4.5625 | 123200.0 |
| 2000-11-01 | GSIG | ETF | 12.62 | 15.12 | 12.25 | 14.62 | 553000.0 |
| 2000-11-01 | IDU | ETF | 41.9375 | 42.1094 | 41.8125 | 42.0938 | 7200.0 |
| 2000-11-01 | IEV | ETF | 36.5938 | 37.0 | 36.4375 | 37.0 | 58200.0 |
| 2000-11-01 | IGLD | ETF | 334.375 | 337.5 | 287.5 | 287.5 | 857.0 |
| 2000-11-01 | IJH | ETF | 10.3875 | 10.475 | 10.3656 | 10.4406 | 1352000.0 |
| 2000-11-01 | IJJ | ETF | 19.4375 | 19.4375 | 19.3984 | 19.418 | 6400.0 |
| 2000-11-01 | IJK | ETF | 17.1094 | 17.3613 | 17.0762 | 17.2734 | 15200.0 |
| 2000-11-01 | IJR | ETF | 18.125 | 18.125 | 17.9662 | 18.0208 | 467400.0 |
| 2000-11-01 | IJS | ETF | 18.0 | 18.0273 | 18.0 | 18.0117 | 5200.0 |
| 2000-11-01 | IJT | ETF | 21.0312 | 21.0781 | 20.9375 | 20.9375 | 6400.0 |
| 2000-11-01 | IUSV | ETF | 25.0208 | 25.0208 | 24.9948 | 24.9948 | 600.0 |
| 2000-11-01 | IVE | ETF | 64.0 | 64.0938 | 63.4688 | 64.0938 | 63900.0 |
| 2000-11-01 | IVV | ETF | 142.7031 | 143.2031 | 141.5 | 142.4844 | 199300.0 |
| 2000-11-01 | IVW | ETF | 20.0469 | 20.25 | 19.9062 | 20.125 | 106400.0 |
| 2000-11-01 | IWB | ETF | 76.2 | 76.2 | 75.68 | 75.92 | 2500.0 |
| 2000-11-01 | IWD | ETF | 59.4219 | 59.4219 | 58.8438 | 59.0156 | 12500.0 |
| 2000-11-01 | IWF | ETF | 19.582025 | 19.699225 | 19.41015 | 19.52735 | 98800.0 |
> showing 50 of 85 rows — these rows as CSV