PREVIEW / etf_daily / 2000-10-13
file: by_date/etf_daily/2000/2000-10-13.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-13 | SPY | ETF | 132.9375 | 137.6562 | 132.875 | 137.5625 | 11778800.0 |
| 2000-10-13 | QQQ | ETF | 74.6875 | 81.625 | 74.625 | 81.25 | 42410200.0 |
| 2000-10-13 | IWM | ETF | 46.0938 | 48.1406 | 46.0625 | 47.75 | 378800.0 |
| 2000-10-13 | DIA | ETF | 100.0781 | 102.25 | 100.0781 | 101.875 | 1456700.0 |
| 2000-10-13 | BBH | ETF | 52.6458 | 55.9167 | 52.5 | 55.6875 | 2611200.0 |
| 2000-10-13 | BITS | ETF | 9.625 | 9.75 | 8.25 | 8.25 | 17625.0 |
| 2000-10-13 | CEF | ETF | 3.1875 | 3.25 | 3.1875 | 3.1875 | 8700.0 |
| 2000-10-13 | CHB | ETF | 3.38 | 3.38 | 2.88 | 3.0 | 187500.0 |
| 2000-10-13 | CNXT | ETF | 32.31 | 35.5 | 31.25 | 34.75 | 4560550.0 |
| 2000-10-13 | EWA | ETF | 9.0 | 9.25 | 9.0 | 9.0625 | 7400.0 |
| 2000-10-13 | EWC | ETF | 15.3125 | 15.75 | 15.3125 | 15.75 | 48100.0 |
| 2000-10-13 | EWD | ETF | 19.4375 | 20.25 | 19.4375 | 20.25 | 1900.0 |
| 2000-10-13 | EWG | ETF | 17.9375 | 18.25 | 17.9375 | 18.25 | 41900.0 |
| 2000-10-13 | EWH | ETF | 11.0625 | 11.75 | 11.0625 | 11.75 | 99600.0 |
| 2000-10-13 | EWI | ETF | 40.125 | 41.0 | 40.125 | 40.625 | 3750.0 |
| 2000-10-13 | EWJ | ETF | 51.75 | 52.25 | 51.25 | 52.25 | 67275.0 |
| 2000-10-13 | EWK | ETF | 12.0 | 12.5 | 12.0 | 12.5 | 3400.0 |
| 2000-10-13 | EWL | ETF | 14.4375 | 14.6875 | 14.4375 | 14.5625 | 11400.0 |
| 2000-10-13 | EWM | ETF | 21.75 | 21.75 | 21.5 | 21.75 | 13950.0 |
| 2000-10-13 | EWN | ETF | 21.75 | 22.1875 | 21.75 | 22.1875 | 4100.0 |
| 2000-10-13 | EWO | ETF | 7.125 | 7.25 | 7.0625 | 7.0625 | 8400.0 |
| 2000-10-13 | EWP | ETF | 22.75 | 23.25 | 22.75 | 23.0 | 11100.0 |
| 2000-10-13 | EWQ | ETF | 22.75 | 23.375 | 22.75 | 23.125 | 19500.0 |
| 2000-10-13 | EWS | ETF | 12.25 | 12.75 | 12.25 | 12.625 | 48150.0 |
| 2000-10-13 | EWT | ETF | 25.75 | 26.75 | 25.75 | 26.0 | 56150.0 |
| 2000-10-13 | EWU | ETF | 33.875 | 34.875 | 33.875 | 34.75 | 16600.0 |
| 2000-10-13 | EWW | ETF | 13.75 | 14.25 | 13.75 | 14.125 | 33200.0 |
| 2000-10-13 | EWY | ETF | 13.6875 | 14.0 | 13.6875 | 14.0 | 71900.0 |
| 2000-10-13 | EWZ | ETF | 17.1875 | 17.25 | 17.125 | 17.25 | 12200.0 |
| 2000-10-13 | EZU | ETF | 33.4688 | 34.125 | 33.4688 | 34.125 | 4000.0 |
| 2000-10-13 | FCTR | ETF | 14.0 | 14.25 | 13.9375 | 14.0 | 90400.0 |
| 2000-10-13 | FMAR | ETF | 5.38 | 5.38 | 5.38 | 5.38 | 400.0 |
| 2000-10-13 | GLDB | ETF | 4.75 | 4.75 | 4.2188 | 4.25 | 55700.0 |
| 2000-10-13 | GSIG | ETF | 12.98 | 14.06 | 12.87 | 13.5 | 251700.0 |
| 2000-10-13 | IDU | ETF | 41.625 | 41.8438 | 41.5469 | 41.7031 | 24800.0 |
| 2000-10-13 | IEV | ETF | 35.5625 | 36.1875 | 35.5625 | 36.1875 | 26800.0 |
| 2000-10-13 | IGLD | ETF | 328.125 | 375.0 | 312.5 | 325.0 | 700.0 |
| 2000-10-13 | IJH | ETF | 9.7062 | 10.0125 | 9.7062 | 10.0125 | 599000.0 |
| 2000-10-13 | IJJ | ETF | 18.4141 | 18.707 | 18.4141 | 18.707 | 50000.0 |
| 2000-10-13 | IJK | ETF | 16.0781 | 16.5801 | 16.0781 | 16.5801 | 16000.0 |
| 2000-10-13 | IJR | ETF | 16.625 | 17.0886 | 16.625 | 17.0886 | 317400.0 |
| 2000-10-13 | IJS | ETF | 16.8672 | 17.1719 | 16.8594 | 17.1719 | 46800.0 |
| 2000-10-13 | IJT | ETF | 18.7891 | 19.1289 | 18.7891 | 19.125 | 8800.0 |
| 2000-10-13 | IUSG | ETF | 30.0547 | 30.0547 | 30.0547 | 30.0547 | 400.0 |
| 2000-10-13 | IUSV | ETF | 23.4531 | 23.5781 | 23.4531 | 23.5781 | 7200.0 |
| 2000-10-13 | IVE | ETF | 59.1562 | 60.3125 | 59.1562 | 60.0938 | 178100.0 |
| 2000-10-13 | IVV | ETF | 133.1562 | 137.5938 | 132.9375 | 137.375 | 322200.0 |
| 2000-10-13 | IVW | ETF | 18.8828 | 19.7734 | 18.8828 | 19.7734 | 119200.0 |
| 2000-10-13 | IWB | ETF | 70.77 | 73.37 | 70.77 | 73.37 | 18500.0 |
| 2000-10-13 | IWD | ETF | 54.875 | 55.7656 | 54.8438 | 55.7656 | 34200.0 |
> showing 50 of 87 rows — these rows as CSV