PREVIEW / etf_daily / 2000-10-10
file: by_date/etf_daily/2000/2000-10-10.parquet size: 8 KB rows: 86
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-10 | SPY | ETF | 140.0938 | 141.25 | 137.6875 | 137.6875 | 6104700.0 |
| 2000-10-10 | QQQ | ETF | 81.8125 | 83.3125 | 77.875 | 78.3125 | 35283200.0 |
| 2000-10-10 | IWM | ETF | 48.7969 | 49.0547 | 47.5625 | 47.5625 | 420400.0 |
| 2000-10-10 | DIA | ETF | 106.0 | 106.3906 | 104.875 | 104.9062 | 565500.0 |
| 2000-10-10 | BBH | ETF | 57.3333 | 59.6667 | 56.625 | 57.3125 | 2373900.0 |
| 2000-10-10 | BITS | ETF | 14.0 | 14.0 | 12.0 | 12.5 | 6725.0 |
| 2000-10-10 | CEF | ETF | 3.1875 | 3.25 | 3.1875 | 3.25 | 66200.0 |
| 2000-10-10 | CHB | ETF | 3.75 | 3.75 | 3.5 | 3.5 | 292800.0 |
| 2000-10-10 | CNXT | ETF | 37.06 | 37.12 | 33.06 | 34.06 | 5377520.0 |
| 2000-10-10 | CSB | ETF | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 41100.0 |
| 2000-10-10 | EWA | ETF | 9.1875 | 9.1875 | 9.125 | 9.125 | 5400.0 |
| 2000-10-10 | EWC | ETF | 16.125 | 16.25 | 16.0 | 16.0625 | 15500.0 |
| 2000-10-10 | EWD | ETF | 20.375 | 20.4375 | 20.375 | 20.4375 | 1900.0 |
| 2000-10-10 | EWG | ETF | 18.6875 | 18.875 | 18.625 | 18.625 | 65900.0 |
| 2000-10-10 | EWH | ETF | 11.6875 | 11.75 | 11.5 | 11.6875 | 25400.0 |
| 2000-10-10 | EWI | ETF | 41.875 | 41.875 | 41.375 | 41.375 | 6800.0 |
| 2000-10-10 | EWJ | ETF | 52.75 | 53.5 | 52.75 | 53.0 | 47925.0 |
| 2000-10-10 | EWK | ETF | 12.25 | 12.25 | 12.25 | 12.25 | 2500.0 |
| 2000-10-10 | EWL | ETF | 15.0625 | 15.0625 | 14.875 | 14.875 | 4100.0 |
| 2000-10-10 | EWM | ETF | 20.75 | 20.75 | 20.5 | 20.5 | 3525.0 |
| 2000-10-10 | EWN | ETF | 22.375 | 22.375 | 22.125 | 22.125 | 700.0 |
| 2000-10-10 | EWO | ETF | 7.375 | 7.5625 | 7.375 | 7.375 | 2100.0 |
| 2000-10-10 | EWP | ETF | 24.375 | 24.5625 | 24.25 | 24.25 | 4100.0 |
| 2000-10-10 | EWQ | ETF | 23.75 | 23.9375 | 23.5625 | 23.625 | 72900.0 |
| 2000-10-10 | EWS | ETF | 12.875 | 13.0 | 12.75 | 13.0 | 10700.0 |
| 2000-10-10 | EWT | ETF | 27.5 | 27.625 | 27.25 | 27.25 | 13550.0 |
| 2000-10-10 | EWU | ETF | 34.75 | 35.125 | 34.625 | 34.75 | 15300.0 |
| 2000-10-10 | EWW | ETF | 14.6875 | 14.8125 | 14.4375 | 14.8125 | 60500.0 |
| 2000-10-10 | EWY | ETF | 15.4375 | 15.4375 | 15.3125 | 15.3125 | 500.0 |
| 2000-10-10 | EWZ | ETF | 17.75 | 17.9375 | 17.5 | 17.5 | 900.0 |
| 2000-10-10 | EZU | ETF | 35.0 | 35.0 | 34.9062 | 34.9062 | 1400.0 |
| 2000-10-10 | FCTR | ETF | 14.0 | 14.1875 | 14.0 | 14.1875 | 42500.0 |
| 2000-10-10 | FMAR | ETF | 5.0 | 5.75 | 5.0 | 5.25 | 11800.0 |
| 2000-10-10 | GLDB | ETF | 5.25 | 5.25 | 5.0625 | 5.125 | 34700.0 |
| 2000-10-10 | GSIG | ETF | 15.0 | 15.12 | 14.0 | 14.37 | 923900.0 |
| 2000-10-10 | IDU | ETF | 42.1562 | 42.6406 | 42.1094 | 42.1094 | 15800.0 |
| 2000-10-10 | IEV | ETF | 36.5312 | 36.75 | 36.5 | 36.5938 | 31200.0 |
| 2000-10-10 | IGLD | ETF | 375.0 | 400.0 | 362.5 | 362.5 | 783.0 |
| 2000-10-10 | IJH | ETF | 10.2531 | 10.2828 | 10.0063 | 10.0125 | 1196000.0 |
| 2000-10-10 | IJJ | ETF | 19.1953 | 19.2812 | 18.9531 | 18.9688 | 42800.0 |
| 2000-10-10 | IJK | ETF | 17.0 | 17.0352 | 16.5664 | 16.5664 | 26400.0 |
| 2000-10-10 | IJR | ETF | 17.1979 | 17.2578 | 16.9922 | 16.9922 | 79800.0 |
| 2000-10-10 | IJS | ETF | 17.461 | 17.461 | 17.2422 | 17.25 | 90800.0 |
| 2000-10-10 | IUSG | ETF | 30.1875 | 30.1875 | 30.1875 | 30.1875 | 3000.0 |
| 2000-10-10 | IUSV | ETF | 24.0885 | 24.0885 | 24.0885 | 24.0885 | 300.0 |
| 2000-10-10 | IVE | ETF | 61.75 | 61.8125 | 61.4844 | 61.5156 | 16700.0 |
| 2000-10-10 | IVV | ETF | 140.2031 | 141.0938 | 138.0 | 138.0 | 123800.0 |
| 2000-10-10 | IVW | ETF | 19.9883 | 20.0508 | 19.8438 | 19.9414 | 54000.0 |
| 2000-10-10 | IWB | ETF | 74.65 | 74.74 | 73.31 | 73.31 | 2700.0 |
| 2000-10-10 | IWD | ETF | 57.3125 | 57.4062 | 56.6562 | 56.875 | 14200.0 |
> showing 50 of 86 rows — these rows as CSV