PREVIEW / etf_daily / 2001-01-12
file: by_date/etf_daily/2001/2001-01-12.parquet size: 8 KB rows: 93
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-12 | SPY | ETF | 132.6875 | 133.7188 | 131.2812 | 132.0 | 7244000.0 |
| 2001-01-12 | QQQ | ETF | 62.7539 | 64.625 | 61.5 | 62.7344 | 60794600.0 |
| 2001-01-12 | IWM | ETF | 48.0625 | 48.7266 | 47.8125 | 48.375 | 1014200.0 |
| 2001-01-12 | DIA | ETF | 105.5312 | 106.25 | 104.625 | 105.3438 | 1645800.0 |
| 2001-01-12 | BBH | ETF | 49.75 | 51.8333 | 48.875 | 51.0 | 3083100.0 |
| 2001-01-12 | BITS | ETF | 10.75 | 12.0 | 10.25 | 11.5 | 58775.0 |
| 2001-01-12 | BOSS | ETF | 22.5 | 23.2 | 22.5 | 23.2 | 100.0 |
| 2001-01-12 | CEF | ETF | 3.125 | 3.25 | 3.125 | 3.1875 | 35200.0 |
| 2001-01-12 | CHB | ETF | 5.63 | 6.31 | 5.38 | 5.44 | 309200.0 |
| 2001-01-12 | CNXT | ETF | 19.56 | 21.0 | 18.62 | 19.94 | 4254000.0 |
| 2001-01-12 | DGT | ETF | 78.4688 | 78.5312 | 77.5938 | 77.5938 | 1700.0 |
| 2001-01-12 | EWA | ETF | 9.5 | 9.6875 | 9.5 | 9.6875 | 7400.0 |
| 2001-01-12 | EWC | ETF | 13.375 | 13.375 | 12.9375 | 12.9375 | 4700.0 |
| 2001-01-12 | EWD | ETF | 19.0 | 19.125 | 18.875 | 19.0 | 18300.0 |
| 2001-01-12 | EWG | ETF | 19.8125 | 20.0 | 19.8125 | 19.875 | 28500.0 |
| 2001-01-12 | EWH | ETF | 11.8125 | 11.8125 | 11.625 | 11.6875 | 55500.0 |
| 2001-01-12 | EWI | ETF | 45.75 | 46.125 | 45.75 | 46.0 | 7200.0 |
| 2001-01-12 | EWJ | ETF | 42.0 | 42.5 | 41.75 | 42.0 | 153875.0 |
| 2001-01-12 | EWL | ETF | 16.1875 | 16.5625 | 16.1875 | 16.375 | 9000.0 |
| 2001-01-12 | EWM | ETF | 20.0 | 20.5 | 19.75 | 20.0 | 4375.0 |
| 2001-01-12 | EWN | ETF | 23.0 | 23.375 | 23.0 | 23.125 | 2600.0 |
| 2001-01-12 | EWO | ETF | 7.8125 | 7.8125 | 7.8125 | 7.8125 | 1000.0 |
| 2001-01-12 | EWP | ETF | 25.3125 | 25.6875 | 25.3125 | 25.6875 | 2800.0 |
| 2001-01-12 | EWQ | ETF | 24.3125 | 24.625 | 24.3125 | 24.625 | 32900.0 |
| 2001-01-12 | EWS | ETF | 13.125 | 13.375 | 13.125 | 13.125 | 11050.0 |
| 2001-01-12 | EWT | ETF | 23.625 | 23.875 | 23.5 | 23.875 | 1650.0 |
| 2001-01-12 | EWU | ETF | 35.25 | 35.375 | 35.0 | 35.125 | 7850.0 |
| 2001-01-12 | EWW | ETF | 14.0 | 14.0625 | 13.875 | 13.875 | 40400.0 |
| 2001-01-12 | EWY | ETF | 14.4375 | 14.875 | 14.25 | 14.5 | 42500.0 |
| 2001-01-12 | EWZ | ETF | 17.8125 | 17.9375 | 17.75 | 17.8125 | 13700.0 |
| 2001-01-12 | EZU | ETF | 37.0938 | 37.0938 | 36.8125 | 36.8438 | 5400.0 |
| 2001-01-12 | FCTR | ETF | 14.0625 | 14.375 | 14.0 | 14.2188 | 12400.0 |
| 2001-01-12 | FMAR | ETF | 4.97 | 5.0 | 4.5 | 5.0 | 5000.0 |
| 2001-01-12 | GLDB | ETF | 5.1875 | 5.375 | 5.125 | 5.375 | 82500.0 |
| 2001-01-12 | GSIG | ETF | 10.56 | 11.12 | 10.5 | 10.94 | 328700.0 |
| 2001-01-12 | IDU | ETF | 36.7812 | 37.7266 | 36.6875 | 37.7266 | 113600.0 |
| 2001-01-12 | IEV | ETF | 38.1875 | 39.0 | 38.0938 | 38.2734 | 115400.0 |
| 2001-01-12 | IGLD | ETF | 237.5 | 237.5 | 225.0 | 225.0 | 109.0 |
| 2001-01-12 | IJH | ETF | 10.1031 | 10.1969 | 10.025 | 10.1562 | 2355000.0 |
| 2001-01-12 | IJJ | ETF | 21.2812 | 21.4297 | 21.1328 | 21.4297 | 82400.0 |
| 2001-01-12 | IJK | ETF | 14.8516 | 15.0195 | 14.7363 | 14.9551 | 200000.0 |
| 2001-01-12 | IJR | ETF | 18.1354 | 18.2787 | 18.0443 | 18.2188 | 330600.0 |
| 2001-01-12 | IJS | ETF | 19.6406 | 19.8008 | 19.5625 | 19.7969 | 39600.0 |
| 2001-01-12 | IJT | ETF | 18.9531 | 19.1875 | 18.9531 | 19.1562 | 15600.0 |
| 2001-01-12 | IOO | ETF | 35.1562 | 35.1562 | 34.9062 | 34.9062 | 2200.0 |
| 2001-01-12 | IUSG | ETF | 26.4375 | 26.5234 | 26.2266 | 26.3125 | 21600.0 |
| 2001-01-12 | IUSV | ETF | 24.8229 | 24.8229 | 24.7917 | 24.7917 | 1200.0 |
| 2001-01-12 | IVE | ETF | 64.4375 | 64.5 | 63.875 | 64.2656 | 236500.0 |
| 2001-01-12 | IVV | ETF | 132.9375 | 133.5312 | 131.3125 | 132.125 | 103100.0 |
| 2001-01-12 | IVW | ETF | 17.0508 | 17.2031 | 16.8594 | 16.9219 | 100000.0 |
> showing 50 of 93 rows — these rows as CSV