PREVIEW / etf_daily / 2000-09-28
file: by_date/etf_daily/2000/2000-09-28.parquet size: 8 KB rows: 77
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-09-28 | SPY | ETF | 143.1875 | 146.3281 | 142.8906 | 145.0 | 7036400.0 |
| 2000-09-28 | QQQ | ETF | 88.7188 | 93.0 | 88.7188 | 91.5625 | 29050000.0 |
| 2000-09-28 | IWM | ETF | 50.8125 | 52.1562 | 50.7812 | 52.0625 | 121000.0 |
| 2000-09-28 | DIA | ETF | 106.3906 | 108.625 | 106.3281 | 108.3438 | 1042400.0 |
| 2000-09-28 | BBH | ETF | 64.6875 | 66.8958 | 64.6875 | 66.6042 | 2062200.0 |
| 2000-09-28 | BITS | ETF | 14.5 | 15.5 | 13.5 | 14.375 | 39600.0 |
| 2000-09-28 | CEF | ETF | 3.25 | 3.3125 | 3.25 | 3.3125 | 12300.0 |
| 2000-09-28 | CHB | ETF | 4.19 | 4.5 | 4.13 | 4.44 | 49800.0 |
| 2000-09-28 | CNXT | ETF | 41.25 | 43.0 | 40.38 | 42.63 | 3795780.0 |
| 2000-09-28 | EWA | ETF | 9.625 | 9.75 | 9.5625 | 9.5625 | 35400.0 |
| 2000-09-28 | EWC | ETF | 15.8125 | 16.1875 | 15.75 | 16.125 | 293800.0 |
| 2000-09-28 | EWD | ETF | 22.0 | 22.0625 | 21.75 | 22.0625 | 11700.0 |
| 2000-09-28 | EWG | ETF | 19.125 | 19.5 | 19.125 | 19.5 | 113500.0 |
| 2000-09-28 | EWH | ETF | 11.875 | 12.125 | 11.875 | 12.0625 | 53200.0 |
| 2000-09-28 | EWI | ETF | 42.375 | 42.75 | 42.375 | 42.75 | 15500.0 |
| 2000-09-28 | EWJ | ETF | 52.25 | 53.0 | 52.0 | 53.0 | 141550.0 |
| 2000-09-28 | EWL | ETF | 15.25 | 15.25 | 15.0625 | 15.125 | 7000.0 |
| 2000-09-28 | EWM | ETF | 21.0 | 21.5 | 20.75 | 21.0 | 23800.0 |
| 2000-09-28 | EWN | ETF | 22.625 | 22.625 | 22.3125 | 22.625 | 14900.0 |
| 2000-09-28 | EWO | ETF | 7.6875 | 7.6875 | 7.6875 | 7.6875 | 1600.0 |
| 2000-09-28 | EWP | ETF | 24.125 | 24.5625 | 24.125 | 24.5 | 20500.0 |
| 2000-09-28 | EWQ | ETF | 25.0 | 25.1875 | 24.8125 | 25.1875 | 102500.0 |
| 2000-09-28 | EWS | ETF | 13.375 | 13.75 | 13.375 | 13.75 | 17300.0 |
| 2000-09-28 | EWT | ETF | 27.75 | 29.5 | 27.75 | 28.625 | 8000.0 |
| 2000-09-28 | EWU | ETF | 35.5 | 35.875 | 35.125 | 35.625 | 78150.0 |
| 2000-09-28 | EWW | ETF | 15.3125 | 15.625 | 15.25 | 15.625 | 13000.0 |
| 2000-09-28 | EWY | ETF | 15.9375 | 16.5 | 15.9375 | 16.3125 | 15400.0 |
| 2000-09-28 | EZU | ETF | 36.2188 | 36.375 | 36.125 | 36.3125 | 55600.0 |
| 2000-09-28 | FCTR | ETF | 14.4375 | 15.0 | 14.4375 | 15.0 | 11800.0 |
| 2000-09-28 | GLDB | ETF | 5.0 | 5.25 | 4.9375 | 5.125 | 148100.0 |
| 2000-09-28 | GSIG | ETF | 16.41 | 18.0 | 16.25 | 17.12 | 479800.0 |
| 2000-09-28 | IDU | ETF | 43.1562 | 43.4375 | 43.125 | 43.2812 | 11600.0 |
| 2000-09-28 | IEV | ETF | 38.1875 | 38.4375 | 38.1875 | 38.375 | 24800.0 |
| 2000-09-28 | IGLD | ETF | 550.0 | 556.25 | 525.0 | 537.5 | 290.0 |
| 2000-09-28 | IJH | ETF | 10.6094 | 10.8688 | 10.6094 | 10.8688 | 2414000.0 |
| 2000-09-28 | IJJ | ETF | 19.3594 | 19.6836 | 19.3594 | 19.6836 | 95600.0 |
| 2000-09-28 | IJK | ETF | 18.1562 | 18.4356 | 18.1562 | 18.4356 | 204800.0 |
| 2000-09-28 | IJR | ETF | 17.6875 | 18.25 | 17.6875 | 18.25 | 232800.0 |
| 2000-09-28 | IJS | ETF | 17.6992 | 17.9805 | 17.6992 | 17.9805 | 2800.0 |
| 2000-09-28 | IJT | ETF | 20.8789 | 20.9062 | 20.8789 | 20.9062 | 1200.0 |
| 2000-09-28 | IVE | ETF | 62.1719 | 63.4375 | 62.1719 | 63.3906 | 9800.0 |
| 2000-09-28 | IVV | ETF | 142.9688 | 146.1719 | 142.9688 | 146.0312 | 99100.0 |
| 2000-09-28 | IVW | ETF | 20.9883 | 21.25 | 20.9883 | 21.25 | 129200.0 |
| 2000-09-28 | IWB | ETF | 77.29 | 78.46 | 77.29 | 78.46 | 1300.0 |
| 2000-09-28 | IWD | ETF | 57.0 | 58.3438 | 57.0 | 58.1562 | 73300.0 |
| 2000-09-28 | IWF | ETF | 20.578125 | 21.09375 | 20.578125 | 21.09375 | 48000.0 |
| 2000-09-28 | IWO | ETF | 79.1875 | 81.375 | 79.1875 | 81.375 | 29500.0 |
| 2000-09-28 | IWV | ETF | 80.2188 | 81.2656 | 80.2188 | 81.2656 | 600.0 |
| 2000-09-28 | IYC | ETF | 14.5234 | 14.7266 | 14.5234 | 14.7188 | 6000.0 |
| 2000-09-28 | IYE | ETF | 17.8542 | 17.8542 | 17.6354 | 17.7604 | 86100.0 |
> showing 50 of 77 rows — these rows as CSV