PREVIEW / etf_daily / 2000-05-31
file: by_date/etf_daily/2000/2000-05-31.parquet size: 7 KB rows: 60
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-05-31 | SPY | ETF | 142.5625 | 144.0 | 142.0938 | 142.8125 | 6056500.0 |
| 2000-05-31 | QQQ | ETF | 84.4688 | 86.6719 | 82.75 | 83.125 | 29675400.0 |
| 2000-05-31 | IWM | ETF | 47.5625 | 48.1875 | 47.5625 | 47.5781 | 36000.0 |
| 2000-05-31 | DIA | ETF | 105.0312 | 106.0938 | 105.0 | 105.3125 | 476100.0 |
| 2000-05-31 | BBH | ETF | 43.6667 | 44.8125 | 43.2083 | 43.5 | 2030700.0 |
| 2000-05-31 | BITS | ETF | 21.75 | 22.0 | 20.0 | 21.0 | 15900.0 |
| 2000-05-31 | BOSS | ETF | 15.4 | 15.6 | 15.4 | 15.4 | 400.0 |
| 2000-05-31 | CEF | ETF | 3.4375 | 3.4375 | 3.375 | 3.4375 | 15100.0 |
| 2000-05-31 | CHB | ETF | 5.94 | 6.0 | 5.56 | 5.56 | 119400.0 |
| 2000-05-31 | CNXT | ETF | 39.0 | 39.75 | 37.44 | 37.63 | 6093070.0 |
| 2000-05-31 | EWA | ETF | 9.5 | 9.625 | 9.4375 | 9.4375 | 8700.0 |
| 2000-05-31 | EWC | ETF | 18.125 | 18.125 | 18.125 | 18.125 | 700.0 |
| 2000-05-31 | EWD | ETF | 32.1875 | 32.4375 | 32.125 | 32.4375 | 2100.0 |
| 2000-05-31 | EWG | ETF | 24.5 | 24.8125 | 24.375 | 24.75 | 178400.0 |
| 2000-05-31 | EWH | ETF | 11.5 | 11.6875 | 11.4375 | 11.625 | 42000.0 |
| 2000-05-31 | EWI | ETF | 49.125 | 49.25 | 48.75 | 49.25 | 2350.0 |
| 2000-05-31 | EWJ | ETF | 57.25 | 57.75 | 57.0 | 57.5 | 154750.0 |
| 2000-05-31 | EWK | ETF | 13.0625 | 13.125 | 12.8125 | 13.125 | 2800.0 |
| 2000-05-31 | EWL | ETF | 15.5 | 15.75 | 15.5 | 15.75 | 22500.0 |
| 2000-05-31 | EWM | ETF | 28.0 | 28.0 | 27.5 | 27.5 | 25700.0 |
| 2000-05-31 | EWN | ETF | 23.6875 | 23.9375 | 23.5 | 23.875 | 20400.0 |
| 2000-05-31 | EWO | ETF | 7.875 | 7.9375 | 7.875 | 7.9375 | 15600.0 |
| 2000-05-31 | EWP | ETF | 25.6875 | 26.125 | 25.6875 | 26.125 | 9700.0 |
| 2000-05-31 | EWQ | ETF | 27.75 | 28.125 | 27.625 | 28.125 | 104400.0 |
| 2000-05-31 | EWS | ETF | 13.0 | 13.375 | 13.0 | 13.25 | 34200.0 |
| 2000-05-31 | EWU | ETF | 37.75 | 38.0 | 37.5 | 37.875 | 74450.0 |
| 2000-05-31 | EWW | ETF | 15.375 | 15.375 | 15.0625 | 15.0625 | 5700.0 |
| 2000-05-31 | EWY | ETF | 19.125 | 19.25 | 19.125 | 19.25 | 55000.0 |
| 2000-05-31 | FCTR | ETF | 14.9375 | 16.0 | 14.9375 | 16.0 | 32700.0 |
| 2000-05-31 | FMAR | ETF | 6.75 | 6.75 | 6.75 | 6.75 | 1000.0 |
| 2000-05-31 | GLDB | ETF | 5.875 | 5.9375 | 5.5625 | 5.5625 | 18100.0 |
| 2000-05-31 | GSIG | ETF | 19.25 | 21.62 | 19.12 | 21.37 | 472600.0 |
| 2000-05-31 | IGLD | ETF | 837.5 | 887.5 | 806.25 | 856.25 | 826.0 |
| 2000-05-31 | IJH | ETF | 9.4781 | 9.4781 | 9.4781 | 9.4781 | 2000.0 |
| 2000-05-31 | IJR | ETF | 16.4583 | 16.6458 | 16.4583 | 16.5833 | 14400.0 |
| 2000-05-31 | IVE | ETF | 60.1875 | 60.7969 | 60.1875 | 60.6719 | 12200.0 |
| 2000-05-31 | IVV | ETF | 141.875 | 143.625 | 141.875 | 142.7812 | 216900.0 |
| 2000-05-31 | IVW | ETF | 21.082 | 21.3281 | 21.0312 | 21.0312 | 54000.0 |
| 2000-05-31 | IWD | ETF | 56.5156 | 56.8281 | 56.5156 | 56.5469 | 25500.0 |
| 2000-05-31 | IWF | ETF | 20.2422 | 20.52345 | 20.2422 | 20.52345 | 4000.0 |
| 2000-05-31 | IWV | ETF | 77.6875 | 78.2656 | 77.6875 | 78.2656 | 700.0 |
| 2000-05-31 | IYF | ETF | 36.81 | 36.81 | 36.81 | 36.81 | 400.0 |
| 2000-05-31 | IYW | ETF | 28.7734 | 28.8984 | 28.7734 | 28.8047 | 9600.0 |
| 2000-05-31 | IYZ | ETF | 58.1875 | 58.1875 | 57.625 | 57.625 | 1600.0 |
| 2000-05-31 | KTEC | ETF | 8.53125 | 8.6875 | 8.53125 | 8.6875 | 2700.0 |
| 2000-05-31 | MDY | ETF | 87.25 | 88.375 | 87.0 | 87.6875 | 490500.0 |
| 2000-05-31 | MIG | ETF | 5.375 | 5.375 | 5.375 | 5.375 | 200.0 |
| 2000-05-31 | PPH | ETF | 49.25 | 49.9688 | 49.25 | 49.75 | 163400.0 |
| 2000-05-31 | SFY | ETF | 25.125 | 25.875 | 25.125 | 25.75 | 158000.0 |
| 2000-05-31 | TDSC | ETF | 5.375 | 5.94 | 5.25 | 5.94 | 672600.0 |
> showing 50 of 60 rows — these rows as CSV