PREVIEW / etf_daily / 2001-11-27
file: by_date/etf_daily/2001/2001-11-27.parquet size: 9 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-27 | SPY | ETF | 115.62 | 116.9 | 114.09 | 115.43 | 19261400.0 |
| 2001-11-27 | QQQ | ETF | 40.05 | 40.97 | 39.2 | 40.2 | 100289700.0 |
| 2001-11-27 | IWM | ETF | 45.95 | 46.17 | 45.555 | 45.825 | 420800.0 |
| 2001-11-27 | DIA | ETF | 99.5 | 100.14 | 98.41 | 98.92 | 5033100.0 |
| 2001-11-27 | ARB | ETF | 30.15 | 30.15 | 29.75 | 29.75 | 189100.0 |
| 2001-11-27 | BBH | ETF | 46.2833 | 46.9833 | 45.67 | 46.2333 | 3897300.0 |
| 2001-11-27 | BITS | ETF | 19.4 | 19.6 | 18.28 | 19.0 | 8700.0 |
| 2001-11-27 | CEF | ETF | 3.22 | 3.29 | 3.21 | 3.29 | 9300.0 |
| 2001-11-27 | CHB | ETF | 11.25 | 11.25 | 10.99 | 11.19 | 180800.0 |
| 2001-11-27 | CNXT | ETF | 14.75 | 15.62 | 14.43 | 15.5 | 9984920.0 |
| 2001-11-27 | CSB | ETF | 3.90000009536743 | 3.90000009536743 | 3.84999990463257 | 3.84999990463257 | 17600.0 |
| 2001-11-27 | DGT | ETF | 67.0 | 67.77 | 66.79 | 67.76 | 1600.0 |
| 2001-11-27 | EFA | ETF | 40.0833 | 40.0867 | 39.6733 | 40.0133 | 443700.0 |
| 2001-11-27 | ELV | ETF | 24.4 | 24.925 | 24.135 | 24.3 | 574000.0 |
| 2001-11-27 | EPP | ETF | 17.9667 | 17.9667 | 17.9 | 17.9233 | 9900.0 |
| 2001-11-27 | EWA | ETF | 9.5 | 9.5 | 9.4 | 9.4 | 30800.0 |
| 2001-11-27 | EWC | ETF | 10.5 | 10.7 | 10.5 | 10.7 | 3300.0 |
| 2001-11-27 | EWD | ETF | 13.57 | 13.6 | 13.51 | 13.55 | 9200.0 |
| 2001-11-27 | EWG | ETF | 14.45 | 14.52 | 14.32 | 14.41 | 24200.0 |
| 2001-11-27 | EWH | ETF | 8.96 | 8.96 | 8.81 | 8.81 | 69600.0 |
| 2001-11-27 | EWI | ETF | 31.7 | 31.7 | 31.5 | 31.66 | 2550.0 |
| 2001-11-27 | EWJ | ETF | 34.32 | 34.4 | 34.08 | 34.2 | 124750.0 |
| 2001-11-27 | EWK | ETF | 10.27 | 10.32 | 10.26 | 10.26 | 72100.0 |
| 2001-11-27 | EWL | ETF | 12.66 | 12.79 | 12.66 | 12.66 | 2900.0 |
| 2001-11-27 | EWM | ETF | 18.8 | 18.92 | 18.6 | 18.92 | 6325.0 |
| 2001-11-27 | EWN | ETF | 16.74 | 16.84 | 16.67 | 16.67 | 9700.0 |
| 2001-11-27 | EWO | ETF | 6.99 | 6.99 | 6.99 | 6.99 | 200.0 |
| 2001-11-27 | EWP | ETF | 21.04 | 21.04 | 20.7 | 20.7 | 14700.0 |
| 2001-11-27 | EWQ | ETF | 18.2 | 18.2 | 17.9 | 17.9 | 25700.0 |
| 2001-11-27 | EWS | ETF | 9.38 | 9.52 | 9.12 | 9.44 | 25650.0 |
| 2001-11-27 | EWT | ETF | 18.4 | 18.46 | 18.16 | 18.26 | 33050.0 |
| 2001-11-27 | EWU | ETF | 29.1 | 29.3 | 28.82 | 29.2 | 10300.0 |
| 2001-11-27 | EWW | ETF | 13.66 | 14.09 | 13.66 | 14.09 | 12300.0 |
| 2001-11-27 | EWY | ETF | 17.32 | 17.34 | 16.85 | 17.18 | 58400.0 |
| 2001-11-27 | EWZ | ETF | 11.9 | 11.99 | 11.84 | 11.98 | 18900.0 |
| 2001-11-27 | EZU | ETF | 27.19 | 27.25 | 26.76 | 27.005 | 29400.0 |
| 2001-11-27 | FCTR | ETF | 17.74 | 17.75 | 17.5 | 17.64 | 13400.0 |
| 2001-11-27 | FMAR | ETF | 8.13 | 8.2 | 8.0 | 8.1 | 12300.0 |
| 2001-11-27 | GLDB | ETF | 7.23 | 7.47 | 7.22 | 7.4 | 37100.0 |
| 2001-11-27 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 404.0 |
| 2001-11-27 | GSIG | ETF | 8.08 | 8.14 | 7.8 | 8.01 | 102300.0 |
| 2001-11-27 | IBB | ETF | 31.9 | 32.1833 | 31.4833 | 31.6967 | 676500.0 |
| 2001-11-27 | ICF | ETF | 20.97 | 21.035 | 20.97 | 20.9975 | 5600.0 |
| 2001-11-27 | IDU | ETF | 31.95 | 32.125 | 31.72 | 31.92 | 63800.0 |
| 2001-11-27 | IEV | ETF | 29.175 | 29.28 | 28.855 | 28.98 | 125800.0 |
| 2001-11-27 | IGLD | ETF | 87.0 | 87.0 | 76.0 | 77.0 | 1212.0 |
| 2001-11-27 | IGM | ETF | 8.6333 | 8.7833 | 8.5283 | 8.635 | 175800.0 |
| 2001-11-27 | IGN | ETF | 34.7 | 35.48 | 34.49 | 34.7 | 613600.0 |
| 2001-11-27 | IGV | ETF | 8.7 | 8.976 | 8.6 | 8.85 | 1097500.0 |
| 2001-11-27 | IJH | ETF | 9.75 | 9.848 | 9.681 | 9.757 | 272000.0 |
> showing 50 of 116 rows — these rows as CSV