PREVIEW / etf_daily / 2000-07-24
file: by_date/etf_daily/2000/2000-07-24.parquet size: 7 KB rows: 68
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-24 | SPY | ETF | 148.125 | 148.8594 | 146.5625 | 146.8438 | 5628500.0 |
| 2000-07-24 | QQQ | ETF | 97.9375 | 99.0 | 94.25 | 95.0 | 18579200.0 |
| 2000-07-24 | IWM | ETF | 52.3125 | 52.3125 | 51.1641 | 51.2734 | 37000.0 |
| 2000-07-24 | DIA | ETF | 107.375 | 107.75 | 106.6875 | 106.8125 | 414300.0 |
| 2000-07-24 | BBH | ETF | 63.0 | 64.1667 | 60.375 | 60.6667 | 3273000.0 |
| 2000-07-24 | BITS | ETF | 19.375 | 20.0 | 18.0 | 18.25 | 13550.0 |
| 2000-07-24 | CEF | ETF | 3.3125 | 3.3125 | 3.25 | 3.3125 | 24100.0 |
| 2000-07-24 | CHB | ETF | 5.0 | 5.31 | 5.0 | 5.31 | 93100.0 |
| 2000-07-24 | CNXT | ETF | 40.5 | 40.62 | 36.0 | 36.5 | 5938700.0 |
| 2000-07-24 | CSB | ETF | 3.09999990463257 | 3.09999990463257 | 3.09999990463257 | 3.09999990463257 | 3000.0 |
| 2000-07-24 | EWA | ETF | 10.4375 | 10.5625 | 10.4375 | 10.4375 | 10400.0 |
| 2000-07-24 | EWC | ETF | 21.3125 | 21.5 | 21.1875 | 21.1875 | 54300.0 |
| 2000-07-24 | EWD | ETF | 31.3125 | 31.5625 | 31.3125 | 31.5625 | 600.0 |
| 2000-07-24 | EWG | ETF | 24.9375 | 24.9375 | 24.4375 | 24.5625 | 40600.0 |
| 2000-07-24 | EWH | ETF | 13.75 | 13.75 | 13.5 | 13.5625 | 97000.0 |
| 2000-07-24 | EWI | ETF | 52.25 | 52.25 | 51.875 | 51.875 | 1150.0 |
| 2000-07-24 | EWJ | ETF | 56.0 | 56.0 | 55.0 | 55.0 | 68475.0 |
| 2000-07-24 | EWK | ETF | 13.9375 | 13.9375 | 13.6875 | 13.6875 | 29400.0 |
| 2000-07-24 | EWL | ETF | 16.25 | 16.25 | 16.0 | 16.0 | 2100.0 |
| 2000-07-24 | EWM | ETF | 24.5 | 25.0 | 24.5 | 24.5 | 24100.0 |
| 2000-07-24 | EWN | ETF | 24.5625 | 24.5625 | 24.375 | 24.375 | 700.0 |
| 2000-07-24 | EWO | ETF | 8.0 | 8.125 | 8.0 | 8.125 | 12200.0 |
| 2000-07-24 | EWP | ETF | 26.4375 | 26.4375 | 26.4375 | 26.4375 | 600.0 |
| 2000-07-24 | EWQ | ETF | 28.375 | 28.5 | 28.375 | 28.4375 | 2300.0 |
| 2000-07-24 | EWS | ETF | 15.25 | 15.25 | 15.0 | 15.125 | 12750.0 |
| 2000-07-24 | EWU | ETF | 39.0 | 39.0 | 38.375 | 38.625 | 4650.0 |
| 2000-07-24 | EWW | ETF | 17.0625 | 17.1875 | 16.8125 | 16.9375 | 21200.0 |
| 2000-07-24 | EWY | ETF | 19.25 | 19.5 | 19.1875 | 19.5 | 17200.0 |
| 2000-07-24 | FCTR | ETF | 16.0313 | 16.0313 | 14.5 | 14.5625 | 40800.0 |
| 2000-07-24 | FMAR | ETF | 5.38 | 5.38 | 5.03 | 5.03 | 3300.0 |
| 2000-07-24 | GLDB | ETF | 5.0 | 5.0 | 4.8125 | 4.875 | 34500.0 |
| 2000-07-24 | GSIG | ETF | 39.87 | 40.56 | 34.37 | 36.5 | 846900.0 |
| 2000-07-24 | IGLD | ETF | 806.25 | 812.5 | 775.0 | 793.75 | 974.0 |
| 2000-07-24 | IJH | ETF | 10.1094 | 10.1109 | 10.0 | 10.0125 | 516000.0 |
| 2000-07-24 | IJR | ETF | 17.6771 | 17.724 | 17.4688 | 17.4792 | 645600.0 |
| 2000-07-24 | IVE | ETF | 60.2031 | 60.2031 | 59.75 | 59.75 | 2300.0 |
| 2000-07-24 | IVV | ETF | 148.25 | 148.5938 | 146.5938 | 146.5938 | 251700.0 |
| 2000-07-24 | IVW | ETF | 22.9023 | 22.9375 | 22.4531 | 22.4648 | 104000.0 |
| 2000-07-24 | IWB | ETF | 78.7344 | 78.7344 | 77.9219 | 77.9219 | 400.0 |
| 2000-07-24 | IWD | ETF | 55.3125 | 55.4062 | 55.0 | 55.0 | 4300.0 |
| 2000-07-24 | IWF | ETF | 22.140625 | 22.27345 | 21.78905 | 21.78905 | 26800.0 |
| 2000-07-24 | IWV | ETF | 81.5625 | 81.6406 | 80.5312 | 80.5312 | 1900.0 |
| 2000-07-24 | IYE | ETF | 15.5208 | 15.5208 | 15.125 | 15.1979 | 156900.0 |
| 2000-07-24 | IYF | ETF | 38.0625 | 38.0625 | 38.0625 | 38.0625 | 600.0 |
| 2000-07-24 | IYG | ETF | 29.3281 | 29.3281 | 29.2917 | 29.2917 | 900.0 |
| 2000-07-24 | IYH | ETF | 12.8625 | 13.0062 | 12.8625 | 12.95 | 11000.0 |
| 2000-07-24 | IYR | ETF | 36.5 | 36.6406 | 36.4375 | 36.6406 | 5200.0 |
| 2000-07-24 | IYW | ETF | 32.1719 | 32.1719 | 31.5274 | 31.5274 | 4000.0 |
| 2000-07-24 | IYY | ETF | 34.3438 | 34.4062 | 34.2188 | 34.2656 | 204600.0 |
| 2000-07-24 | IYZ | ETF | 59.375 | 59.375 | 59.125 | 59.125 | 300.0 |
> showing 50 of 68 rows — these rows as CSV