PREVIEW / etf_daily / 2000-10-12
file: by_date/etf_daily/2000/2000-10-12.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-12 | SPY | ETF | 137.2812 | 137.5938 | 132.7812 | 133.125 | 12336900.0 |
| 2000-10-12 | QQQ | ETF | 79.25 | 79.5625 | 74.3125 | 75.125 | 53223900.0 |
| 2000-10-12 | IWM | ETF | 47.8438 | 47.8438 | 45.9688 | 45.9688 | 161400.0 |
| 2000-10-12 | DIA | ETF | 104.3906 | 104.3906 | 100.2656 | 100.375 | 2638900.0 |
| 2000-10-12 | BBH | ETF | 56.8125 | 56.8125 | 53.0833 | 53.5417 | 5291400.0 |
| 2000-10-12 | BITS | ETF | 10.625 | 10.625 | 8.5 | 9.25 | 17675.0 |
| 2000-10-12 | CEF | ETF | 3.1875 | 3.3125 | 3.1875 | 3.25 | 55100.0 |
| 2000-10-12 | CHB | ETF | 3.44 | 3.56 | 3.31 | 3.44 | 47100.0 |
| 2000-10-12 | CNXT | ETF | 33.63 | 34.69 | 31.25 | 32.19 | 4583600.0 |
| 2000-10-12 | EWA | ETF | 9.25 | 9.25 | 9.0 | 9.0 | 25700.0 |
| 2000-10-12 | EWC | ETF | 15.625 | 15.625 | 15.375 | 15.375 | 30800.0 |
| 2000-10-12 | EWD | ETF | 19.8125 | 19.9375 | 19.75 | 19.75 | 2500.0 |
| 2000-10-12 | EWG | ETF | 18.375 | 18.375 | 17.875 | 17.9375 | 71700.0 |
| 2000-10-12 | EWH | ETF | 11.375 | 11.5 | 11.125 | 11.125 | 58400.0 |
| 2000-10-12 | EWI | ETF | 41.125 | 41.125 | 40.25 | 40.625 | 15050.0 |
| 2000-10-12 | EWJ | ETF | 52.25 | 52.5 | 51.0 | 51.0 | 43700.0 |
| 2000-10-12 | EWK | ETF | 12.125 | 12.1875 | 11.9375 | 11.9375 | 7900.0 |
| 2000-10-12 | EWL | ETF | 14.625 | 14.75 | 14.5 | 14.75 | 17600.0 |
| 2000-10-12 | EWM | ETF | 21.0 | 21.25 | 20.75 | 20.75 | 56600.0 |
| 2000-10-12 | EWN | ETF | 22.0 | 22.0 | 21.6875 | 21.875 | 6700.0 |
| 2000-10-12 | EWO | ETF | 7.25 | 7.25 | 7.25 | 7.25 | 5100.0 |
| 2000-10-12 | EWP | ETF | 23.5 | 23.5625 | 23.375 | 23.375 | 16400.0 |
| 2000-10-12 | EWQ | ETF | 23.25 | 23.25 | 22.6875 | 22.75 | 91800.0 |
| 2000-10-12 | EWS | ETF | 12.75 | 12.75 | 12.25 | 12.375 | 17350.0 |
| 2000-10-12 | EWT | ETF | 26.0 | 26.0 | 25.75 | 25.75 | 39750.0 |
| 2000-10-12 | EWU | ETF | 35.0 | 35.0 | 34.0 | 34.375 | 108800.0 |
| 2000-10-12 | EWW | ETF | 14.5 | 14.5 | 13.75 | 13.75 | 20100.0 |
| 2000-10-12 | EWY | ETF | 14.0 | 14.0 | 13.5 | 13.75 | 2200.0 |
| 2000-10-12 | EWZ | ETF | 17.0625 | 17.0625 | 17.0625 | 17.0625 | 500.0 |
| 2000-10-12 | EZU | ETF | 34.2812 | 34.2812 | 33.75 | 33.875 | 39200.0 |
| 2000-10-12 | FCTR | ETF | 14.1875 | 14.4375 | 13.875 | 13.9375 | 142000.0 |
| 2000-10-12 | FMAR | ETF | 5.25 | 5.5 | 5.25 | 5.25 | 16600.0 |
| 2000-10-12 | GLDB | ETF | 4.75 | 4.8125 | 4.625 | 4.75 | 9600.0 |
| 2000-10-12 | GSIG | ETF | 14.06 | 14.06 | 12.87 | 13.19 | 570200.0 |
| 2000-10-12 | IDU | ETF | 41.7188 | 41.875 | 41.3906 | 41.5156 | 7200.0 |
| 2000-10-12 | IEV | ETF | 35.9062 | 36.0 | 35.7188 | 35.8125 | 22400.0 |
| 2000-10-12 | IGLD | ETF | 356.25 | 375.0 | 306.25 | 312.5 | 753.0 |
| 2000-10-12 | IJH | ETF | 9.8641 | 9.9031 | 9.6844 | 9.7047 | 1697000.0 |
| 2000-10-12 | IJJ | ETF | 18.4961 | 18.4961 | 18.3281 | 18.3555 | 31200.0 |
| 2000-10-12 | IJK | ETF | 16.5781 | 16.5781 | 15.9375 | 15.9375 | 48000.0 |
| 2000-10-12 | IJR | ETF | 16.7552 | 16.8464 | 16.5469 | 16.5781 | 41400.0 |
| 2000-10-12 | IJS | ETF | 17.0547 | 17.0547 | 16.75 | 16.75 | 66400.0 |
| 2000-10-12 | IJT | ETF | 19.125 | 19.125 | 18.8242 | 18.8516 | 7200.0 |
| 2000-10-12 | IUSG | ETF | 29.1875 | 29.3125 | 28.8438 | 28.8438 | 3200.0 |
| 2000-10-12 | IUSV | ETF | 23.3385 | 23.3385 | 23.2031 | 23.2396 | 3600.0 |
| 2000-10-12 | IVE | ETF | 60.3125 | 60.3125 | 59.0781 | 59.25 | 114100.0 |
| 2000-10-12 | IVV | ETF | 137.4062 | 137.5 | 132.8125 | 133.4062 | 155200.0 |
| 2000-10-12 | IVW | ETF | 19.5117 | 19.5117 | 18.8672 | 18.9141 | 45200.0 |
| 2000-10-12 | IWB | ETF | 72.7 | 72.7 | 70.79 | 70.79 | 5800.0 |
| 2000-10-12 | IWD | ETF | 56.125 | 56.125 | 54.875 | 54.875 | 132400.0 |
> showing 50 of 86 rows — these rows as CSV