PREVIEW / etf_daily / 2000-07-05
file: by_date/etf_daily/2000/2000-07-05.parquet size: 7 KB rows: 67
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-07-05 | SPY | ETF | 146.375 | 146.6562 | 144.375 | 144.625 | 2748200.0 |
| 2000-07-05 | QQQ | ETF | 93.625 | 93.9688 | 90.875 | 91.5625 | 16489000.0 |
| 2000-07-05 | IWM | ETF | 52.1094 | 52.125 | 51.6328 | 51.8125 | 138800.0 |
| 2000-07-05 | DIA | ETF | 105.3594 | 105.875 | 104.6406 | 105.0 | 785200.0 |
| 2000-07-05 | BBH | ETF | 60.9167 | 63.6458 | 60.1458 | 62.5 | 2639700.0 |
| 2000-07-05 | BITS | ETF | 25.25 | 27.75 | 23.0 | 24.0 | 7250.0 |
| 2000-07-05 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 8800.0 |
| 2000-07-05 | CHB | ETF | 5.38 | 5.75 | 5.38 | 5.69 | 67700.0 |
| 2000-07-05 | CNXT | ETF | 48.81 | 49.44 | 45.5 | 46.13 | 3605210.0 |
| 2000-07-05 | EWA | ETF | 10.6875 | 10.6875 | 10.4375 | 10.4375 | 10300.0 |
| 2000-07-05 | EWC | ETF | 20.0 | 20.0 | 19.8125 | 19.8125 | 21700.0 |
| 2000-07-05 | EWD | ETF | 31.5625 | 31.5625 | 31.1875 | 31.1875 | 17800.0 |
| 2000-07-05 | EWG | ETF | 24.5625 | 24.6875 | 24.25 | 24.25 | 29400.0 |
| 2000-07-05 | EWH | ETF | 12.5 | 12.5 | 12.375 | 12.375 | 60900.0 |
| 2000-07-05 | EWI | ETF | 51.75 | 52.25 | 51.375 | 51.875 | 28850.0 |
| 2000-07-05 | EWJ | ETF | 60.75 | 60.75 | 59.75 | 59.75 | 50400.0 |
| 2000-07-05 | EWK | ETF | 13.75 | 13.75 | 13.4375 | 13.4375 | 1700.0 |
| 2000-07-05 | EWL | ETF | 16.125 | 16.375 | 16.0625 | 16.3125 | 25100.0 |
| 2000-07-05 | EWM | ETF | 24.5 | 24.75 | 24.25 | 24.25 | 34425.0 |
| 2000-07-05 | EWN | ETF | 24.5 | 24.6875 | 24.3125 | 24.625 | 22900.0 |
| 2000-07-05 | EWO | ETF | 8.0 | 8.0 | 7.8125 | 7.8125 | 700.0 |
| 2000-07-05 | EWP | ETF | 26.625 | 26.6875 | 26.3125 | 26.3125 | 18900.0 |
| 2000-07-05 | EWQ | ETF | 28.9375 | 29.0 | 28.625 | 28.625 | 30400.0 |
| 2000-07-05 | EWS | ETF | 15.25 | 15.25 | 14.875 | 14.875 | 47800.0 |
| 2000-07-05 | EWT | ETF | 38.625 | 38.75 | 38.625 | 38.75 | 16150.0 |
| 2000-07-05 | EWU | ETF | 38.875 | 38.875 | 37.875 | 38.25 | 24900.0 |
| 2000-07-05 | EWW | ETF | 18.75 | 18.75 | 17.9062 | 17.9062 | 599100.0 |
| 2000-07-05 | EWY | ETF | 21.5 | 21.5 | 21.25 | 21.375 | 10700.0 |
| 2000-07-05 | FCTR | ETF | 15.6875 | 16.0 | 15.4375 | 15.9375 | 21000.0 |
| 2000-07-05 | FMAR | ETF | 5.5 | 5.5017 | 5.44 | 5.44 | 1300.0 |
| 2000-07-05 | GLDB | ETF | 5.375 | 5.5 | 5.0 | 5.0313 | 186900.0 |
| 2000-07-05 | GSIG | ETF | 39.19 | 41.0 | 36.06 | 37.12 | 1352200.0 |
| 2000-07-05 | IGLD | ETF | 828.125 | 837.5 | 825.0 | 825.0 | 271.0 |
| 2000-07-05 | IJH | ETF | 9.7406 | 9.7859 | 9.7094 | 9.7094 | 50000.0 |
| 2000-07-05 | IJR | ETF | 17.6823 | 17.6823 | 17.6016 | 17.6354 | 3600.0 |
| 2000-07-05 | IVE | ETF | 59.375 | 59.625 | 59.0469 | 59.0469 | 6100.0 |
| 2000-07-05 | IVV | ETF | 146.2656 | 146.3594 | 144.625 | 145.0938 | 27400.0 |
| 2000-07-05 | IVW | ETF | 22.375 | 22.4219 | 22.1719 | 22.2344 | 229600.0 |
| 2000-07-05 | IWB | ETF | 77.4688 | 77.4688 | 76.5312 | 76.5312 | 6200.0 |
| 2000-07-05 | IWD | ETF | 55.0 | 55.1719 | 54.9219 | 54.9219 | 1100.0 |
| 2000-07-05 | IWF | ETF | 21.6172 | 21.6172 | 21.1797 | 21.1797 | 91600.0 |
| 2000-07-05 | IWV | ETF | 80.0781 | 80.0938 | 79.9531 | 79.9531 | 900.0 |
| 2000-07-05 | IYE | ETF | 15.75 | 15.7917 | 15.6354 | 15.7708 | 3300.0 |
| 2000-07-05 | IYF | ETF | 36.0391 | 36.4219 | 36.0234 | 36.1562 | 5600.0 |
| 2000-07-05 | IYH | ETF | 13.25 | 13.45 | 13.25 | 13.3875 | 13000.0 |
| 2000-07-05 | IYR | ETF | 35.625 | 35.9062 | 35.5938 | 35.9062 | 32600.0 |
| 2000-07-05 | IYW | ETF | 31.5625 | 31.5625 | 30.6406 | 30.6797 | 112000.0 |
| 2000-07-05 | IYY | ETF | 34.0469 | 34.0469 | 33.7344 | 33.7344 | 1800.0 |
| 2000-07-05 | IYZ | ETF | 62.0 | 62.1562 | 61.625 | 61.625 | 2700.0 |
| 2000-07-05 | KTEC | ETF | 8.4375 | 8.625 | 8.4375 | 8.5625 | 21000.0 |
> showing 50 of 67 rows — these rows as CSV