PREVIEW / etf_daily / 2000-09-26
file: by_date/etf_daily/2000/2000-09-26.parquet size: 8 KB rows: 83
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-26 | SPY | ETF | 144.375 | 145.0 | 142.4062 | 142.4062 | 5302400.0 |
| 2000-09-26 | QQQ | ETF | 90.7656 | 92.5 | 88.9219 | 89.4375 | 26006200.0 |
| 2000-09-26 | IWM | ETF | 51.625 | 51.625 | 50.6562 | 50.9219 | 65200.0 |
| 2000-09-26 | DIA | ETF | 107.75 | 107.9062 | 106.1562 | 106.1562 | 711500.0 |
| 2000-09-26 | BBH | ETF | 66.3958 | 66.6667 | 63.7083 | 64.5 | 2318700.0 |
| 2000-09-26 | BITS | ETF | 14.625 | 16.0 | 14.5 | 15.875 | 11925.0 |
| 2000-09-26 | CEF | ETF | 3.3125 | 3.3125 | 3.25 | 3.25 | 29200.0 |
| 2000-09-26 | CHB | ETF | 4.38 | 4.38 | 4.31 | 4.38 | 46200.0 |
| 2000-09-26 | CNXT | ETF | 44.0 | 44.56 | 41.19 | 41.38 | 3734880.0 |
| 2000-09-26 | EWA | ETF | 9.4375 | 9.5625 | 9.375 | 9.375 | 13800.0 |
| 2000-09-26 | EWC | ETF | 16.3125 | 16.625 | 16.25 | 16.375 | 18500.0 |
| 2000-09-26 | EWD | ETF | 22.25 | 22.3125 | 22.125 | 22.125 | 4200.0 |
| 2000-09-26 | EWG | ETF | 19.125 | 19.3125 | 19.125 | 19.1875 | 34900.0 |
| 2000-09-26 | EWH | ETF | 11.6875 | 11.6875 | 11.5 | 11.5625 | 19800.0 |
| 2000-09-26 | EWI | ETF | 42.375 | 42.625 | 42.25 | 42.5 | 10350.0 |
| 2000-09-26 | EWJ | ETF | 53.0 | 53.25 | 52.5 | 53.0 | 36550.0 |
| 2000-09-26 | EWK | ETF | 12.3125 | 12.5 | 12.25 | 12.3125 | 10600.0 |
| 2000-09-26 | EWL | ETF | 15.125 | 15.1875 | 15.0625 | 15.0625 | 2700.0 |
| 2000-09-26 | EWM | ETF | 21.5 | 22.0 | 21.5 | 21.5 | 7325.0 |
| 2000-09-26 | EWN | ETF | 22.5 | 22.5 | 22.3125 | 22.375 | 2100.0 |
| 2000-09-26 | EWO | ETF | 7.5625 | 7.5625 | 7.5625 | 7.5625 | 600.0 |
| 2000-09-26 | EWP | ETF | 24.125 | 24.375 | 24.0625 | 24.25 | 6800.0 |
| 2000-09-26 | EWQ | ETF | 24.9375 | 25.0 | 24.75 | 24.9375 | 15000.0 |
| 2000-09-26 | EWS | ETF | 13.5 | 13.75 | 13.5 | 13.625 | 21850.0 |
| 2000-09-26 | EWT | ETF | 30.0 | 30.0 | 30.0 | 30.0 | 200.0 |
| 2000-09-26 | EWU | ETF | 35.25 | 35.25 | 34.75 | 35.0 | 18650.0 |
| 2000-09-26 | EWW | ETF | 15.625 | 15.8125 | 15.5 | 15.5625 | 13600.0 |
| 2000-09-26 | EWY | ETF | 15.5 | 15.5 | 15.5 | 15.5 | 600.0 |
| 2000-09-26 | EWZ | ETF | 17.75 | 18.25 | 17.75 | 18.25 | 10700.0 |
| 2000-09-26 | EZU | ETF | 36.125 | 36.25 | 36.0625 | 36.0938 | 14000.0 |
| 2000-09-26 | FCTR | ETF | 14.5 | 14.5 | 14.1875 | 14.1875 | 16600.0 |
| 2000-09-26 | FMAR | ETF | 5.0 | 5.0013 | 4.94 | 5.0 | 3600.0 |
| 2000-09-26 | GLDB | ETF | 4.875 | 5.0625 | 4.8125 | 4.9375 | 235200.0 |
| 2000-09-26 | GSIG | ETF | 18.72 | 18.87 | 16.87 | 17.0 | 491400.0 |
| 2000-09-26 | IDU | ETF | 41.8125 | 42.5312 | 41.8125 | 42.5312 | 8200.0 |
| 2000-09-26 | IEV | ETF | 38.6562 | 38.9219 | 38.5 | 38.7188 | 11200.0 |
| 2000-09-26 | IGLD | ETF | 593.75 | 612.5 | 581.25 | 581.25 | 396.0 |
| 2000-09-26 | IJH | ETF | 10.5891 | 10.6656 | 10.5375 | 10.5453 | 1343000.0 |
| 2000-09-26 | IJJ | ETF | 19.3594 | 19.3594 | 19.1875 | 19.2148 | 185200.0 |
| 2000-09-26 | IJK | ETF | 18.0078 | 18.1211 | 17.8496 | 17.8496 | 68800.0 |
| 2000-09-26 | IJR | ETF | 17.9193 | 17.9505 | 17.7162 | 17.7604 | 67800.0 |
| 2000-09-26 | IJS | ETF | 17.625 | 17.625 | 17.5898 | 17.5898 | 6000.0 |
| 2000-09-26 | IJT | ETF | 21.1562 | 21.1719 | 20.8828 | 20.8828 | 10000.0 |
| 2000-09-26 | IUSG | ETF | 33.125 | 33.125 | 32.7656 | 32.7656 | 400.0 |
| 2000-09-26 | IUSV | ETF | 24.1094 | 24.1094 | 24.1094 | 24.1094 | 600.0 |
| 2000-09-26 | IVE | ETF | 62.0312 | 62.0312 | 61.5312 | 61.5312 | 4300.0 |
| 2000-09-26 | IVV | ETF | 144.4688 | 144.875 | 142.625 | 142.625 | 10500.0 |
| 2000-09-26 | IVW | ETF | 21.2461 | 21.2461 | 20.836 | 20.8633 | 8400.0 |
| 2000-09-26 | IWB | ETF | 77.51 | 77.75 | 76.75 | 76.8 | 17200.0 |
| 2000-09-26 | IWD | ETF | 57.0 | 57.125 | 56.7812 | 56.8125 | 7900.0 |
> showing 50 of 83 rows — these rows as CSV