PREVIEW / etf_daily / 2001-01-05
file: by_date/etf_daily/2001/2001-01-05.parquet size: 8 KB rows: 92
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-05 | SPY | ETF | 133.4688 | 133.625 | 129.1875 | 129.1875 | 12911400.0 |
| 2001-01-05 | QQQ | ETF | 61.3125 | 61.3125 | 56.0 | 56.625 | 68782900.0 |
| 2001-01-05 | IWM | ETF | 47.4375 | 47.4375 | 45.8125 | 46.0312 | 263200.0 |
| 2001-01-05 | DIA | ETF | 108.1875 | 108.4062 | 106.25 | 106.2812 | 1633900.0 |
| 2001-01-05 | BBH | ETF | 52.1667 | 52.1667 | 46.9167 | 48.0833 | 7683000.0 |
| 2001-01-05 | BITS | ETF | 9.5 | 11.25 | 9.5 | 11.0 | 15525.0 |
| 2001-01-05 | CEF | ETF | 3.125 | 3.125 | 3.0625 | 3.125 | 28100.0 |
| 2001-01-05 | CHB | ETF | 3.94 | 4.38 | 3.88 | 4.38 | 377300.0 |
| 2001-01-05 | CNXT | ETF | 17.44 | 17.628 | 15.688 | 15.75 | 3718080.0 |
| 2001-01-05 | DGT | ETF | 78.75 | 78.75 | 78.25 | 78.25 | 2800.0 |
| 2001-01-05 | EWA | ETF | 10.0 | 10.0625 | 10.0 | 10.0 | 7100.0 |
| 2001-01-05 | EWC | ETF | 13.3125 | 13.3125 | 13.125 | 13.1875 | 19100.0 |
| 2001-01-05 | EWD | ETF | 18.5625 | 18.75 | 18.5 | 18.5 | 2600.0 |
| 2001-01-05 | EWG | ETF | 19.9375 | 19.9375 | 19.625 | 19.625 | 88100.0 |
| 2001-01-05 | EWH | ETF | 12.0 | 12.0 | 11.5625 | 11.5625 | 63400.0 |
| 2001-01-05 | EWI | ETF | 45.0 | 45.25 | 44.75 | 44.75 | 11650.0 |
| 2001-01-05 | EWJ | ETF | 44.0 | 44.25 | 43.25 | 43.5 | 129725.0 |
| 2001-01-05 | EWK | ETF | 13.1875 | 13.1875 | 13.1875 | 13.1875 | 100.0 |
| 2001-01-05 | EWL | ETF | 16.9375 | 16.9375 | 16.6875 | 16.875 | 6600.0 |
| 2001-01-05 | EWM | ETF | 19.75 | 20.0 | 19.75 | 19.75 | 8625.0 |
| 2001-01-05 | EWN | ETF | 23.25 | 23.3125 | 23.0 | 23.0 | 3900.0 |
| 2001-01-05 | EWO | ETF | 7.9375 | 7.9375 | 7.8125 | 7.8125 | 3100.0 |
| 2001-01-05 | EWP | ETF | 25.3125 | 25.3125 | 24.875 | 24.875 | 6000.0 |
| 2001-01-05 | EWQ | ETF | 24.6875 | 24.6875 | 24.375 | 24.4375 | 51500.0 |
| 2001-01-05 | EWS | ETF | 13.5 | 13.625 | 13.25 | 13.25 | 4950.0 |
| 2001-01-05 | EWT | ETF | 22.5 | 23.0 | 22.5 | 22.875 | 31300.0 |
| 2001-01-05 | EWU | ETF | 36.375 | 36.375 | 35.375 | 35.375 | 20150.0 |
| 2001-01-05 | EWW | ETF | 14.125 | 14.125 | 13.875 | 14.125 | 3400.0 |
| 2001-01-05 | EWY | ETF | 14.125 | 14.1875 | 13.9375 | 13.9375 | 37500.0 |
| 2001-01-05 | EWZ | ETF | 17.375 | 17.375 | 17.375 | 17.375 | 500.0 |
| 2001-01-05 | EZU | ETF | 37.1562 | 37.1562 | 36.9375 | 36.9375 | 5400.0 |
| 2001-01-05 | FCTR | ETF | 14.3906 | 14.5 | 13.4375 | 13.75 | 43200.0 |
| 2001-01-05 | FMAR | ETF | 5.5 | 5.5 | 5.0 | 5.25 | 6300.0 |
| 2001-01-05 | GLDB | ETF | 5.2969 | 5.5 | 4.9375 | 4.9688 | 146900.0 |
| 2001-01-05 | GSIG | ETF | 9.56 | 9.56 | 8.62 | 8.75 | 81900.0 |
| 2001-01-05 | IDU | ETF | 38.2812 | 39.2031 | 38.2812 | 38.5 | 218800.0 |
| 2001-01-05 | IEV | ETF | 38.625 | 38.8125 | 38.4375 | 38.8125 | 250400.0 |
| 2001-01-05 | IGLD | ETF | 225.0 | 225.0 | 209.375 | 209.375 | 230.0 |
| 2001-01-05 | IJH | ETF | 10.05 | 10.05 | 9.7219 | 9.7625 | 1790000.0 |
| 2001-01-05 | IJJ | ETF | 21.1094 | 21.1094 | 20.711 | 20.7383 | 115600.0 |
| 2001-01-05 | IJK | ETF | 14.6777 | 14.6777 | 14.1543 | 14.2774 | 190400.0 |
| 2001-01-05 | IJR | ETF | 17.8542 | 17.8542 | 17.3464 | 17.3698 | 259800.0 |
| 2001-01-05 | IJS | ETF | 19.1719 | 19.1719 | 18.7812 | 18.7812 | 98800.0 |
| 2001-01-05 | IJT | ETF | 18.6875 | 18.6875 | 18.2422 | 18.2422 | 15600.0 |
| 2001-01-05 | IOO | ETF | 34.8828 | 35.0938 | 34.8125 | 34.8125 | 2800.0 |
| 2001-01-05 | IUSG | ETF | 26.1875 | 26.1875 | 24.9844 | 24.9844 | 600.0 |
| 2001-01-05 | IUSV | ETF | 24.9427 | 24.9427 | 24.8594 | 24.8594 | 3300.0 |
| 2001-01-05 | IVE | ETF | 65.2812 | 65.2812 | 63.6094 | 63.7031 | 71800.0 |
| 2001-01-05 | IVV | ETF | 133.7031 | 133.7031 | 129.5312 | 129.7031 | 68400.0 |
| 2001-01-05 | IVW | ETF | 16.9766 | 16.9766 | 16.5625 | 16.5703 | 44000.0 |
> showing 50 of 92 rows — these rows as CSV