PREVIEW / etf_daily / 2001-11-28
file: by_date/etf_daily/2001/2001-11-28.parquet size: 9 KB rows: 117
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-28 | SPY | ETF | 114.74 | 115.17 | 113.25 | 113.34 | 20195500.0 |
| 2001-11-28 | QQQ | ETF | 39.73 | 40.37 | 38.69 | 38.75 | 101568200.0 |
| 2001-11-28 | IWM | ETF | 45.6 | 45.87 | 45.025 | 45.025 | 641400.0 |
| 2001-11-28 | DIA | ETF | 98.42 | 98.49 | 97.16 | 97.3 | 3206200.0 |
| 2001-11-28 | ARB | ETF | 29.73 | 29.95 | 29.26 | 29.26 | 31200.0 |
| 2001-11-28 | BBH | ETF | 45.5833 | 46.1633 | 44.9 | 44.94 | 3102600.0 |
| 2001-11-28 | BITS | ETF | 18.8 | 19.0 | 18.0 | 18.04 | 2675.0 |
| 2001-11-28 | CEF | ETF | 3.27 | 3.29 | 3.26 | 3.26 | 4600.0 |
| 2001-11-28 | CHB | ETF | 11.19 | 11.45 | 11.15 | 11.24 | 129300.0 |
| 2001-11-28 | CNXT | ETF | 15.35 | 15.6 | 14.779 | 15.07 | 8907970.0 |
| 2001-11-28 | CSB | ETF | 3.84999990463257 | 3.90000009536743 | 3.79999995231628 | 3.90000009536743 | 26000.0 |
| 2001-11-28 | DGT | ETF | 66.5 | 66.5 | 66.0 | 66.0 | 300.0 |
| 2001-11-28 | EFA | ETF | 39.3333 | 39.59 | 39.3 | 39.3167 | 534000.0 |
| 2001-11-28 | ELV | ETF | 24.275 | 24.6 | 23.755 | 24.475 | 312600.0 |
| 2001-11-28 | EPP | ETF | 17.7967 | 17.7967 | 17.7833 | 17.7833 | 4200.0 |
| 2001-11-28 | EWA | ETF | 9.45 | 9.5 | 9.35 | 9.35 | 19300.0 |
| 2001-11-28 | EWC | ETF | 10.5 | 10.51 | 10.5 | 10.5 | 2300.0 |
| 2001-11-28 | EWD | ETF | 13.39 | 13.4 | 13.16 | 13.24 | 5600.0 |
| 2001-11-28 | EWG | ETF | 14.32 | 14.33 | 14.2 | 14.2 | 15300.0 |
| 2001-11-28 | EWH | ETF | 8.63 | 8.75 | 8.51 | 8.51 | 52600.0 |
| 2001-11-28 | EWI | ETF | 31.6 | 31.9 | 31.3 | 31.8 | 5850.0 |
| 2001-11-28 | EWJ | ETF | 33.48 | 33.76 | 33.24 | 33.4 | 105300.0 |
| 2001-11-28 | EWK | ETF | 10.08 | 10.08 | 10.06 | 10.07 | 9600.0 |
| 2001-11-28 | EWL | ETF | 12.68 | 12.7 | 12.51 | 12.51 | 23100.0 |
| 2001-11-28 | EWM | ETF | 18.8 | 18.8 | 18.64 | 18.64 | 9225.0 |
| 2001-11-28 | EWN | ETF | 16.58 | 16.64 | 16.46 | 16.46 | 5300.0 |
| 2001-11-28 | EWO | ETF | 7.15 | 7.15 | 7.0 | 7.0 | 28800.0 |
| 2001-11-28 | EWP | ETF | 20.73 | 20.73 | 20.69 | 20.69 | 1900.0 |
| 2001-11-28 | EWQ | ETF | 17.95 | 17.99 | 17.81 | 17.83 | 6500.0 |
| 2001-11-28 | EWS | ETF | 9.26 | 9.28 | 9.02 | 9.18 | 11550.0 |
| 2001-11-28 | EWT | ETF | 17.9 | 18.0 | 17.32 | 17.32 | 9450.0 |
| 2001-11-28 | EWU | ETF | 29.1 | 29.28 | 28.72 | 28.72 | 9600.0 |
| 2001-11-28 | EWW | ETF | 13.81 | 14.05 | 13.81 | 13.95 | 8000.0 |
| 2001-11-28 | EWY | ETF | 16.1 | 16.14 | 15.76 | 15.76 | 22400.0 |
| 2001-11-28 | EWZ | ETF | 11.66 | 11.66 | 11.34 | 11.49 | 64800.0 |
| 2001-11-28 | EZU | ETF | 26.725 | 26.895 | 26.5 | 26.5 | 34600.0 |
| 2001-11-28 | FCTR | ETF | 17.7 | 17.7 | 17.4 | 17.46 | 21800.0 |
| 2001-11-28 | FMAR | ETF | 8.15 | 8.18 | 8.01 | 8.09 | 13000.0 |
| 2001-11-28 | GLDB | ETF | 7.24 | 7.39 | 7.22 | 7.27 | 12800.0 |
| 2001-11-28 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 2120.0 |
| 2001-11-28 | GSIG | ETF | 7.8 | 7.85 | 7.7 | 7.72 | 78300.0 |
| 2001-11-28 | IBB | ETF | 31.3333 | 31.65 | 30.7 | 30.7333 | 233700.0 |
| 2001-11-28 | ICF | ETF | 21.0975 | 21.0975 | 20.9975 | 20.9975 | 5600.0 |
| 2001-11-28 | IDU | ETF | 31.75 | 31.75 | 30.845 | 30.845 | 117600.0 |
| 2001-11-28 | IEV | ETF | 28.63 | 28.89 | 28.6 | 28.62 | 135600.0 |
| 2001-11-28 | IGLD | ETF | 77.0 | 77.0 | 72.0 | 72.0 | 644.0 |
| 2001-11-28 | IGM | ETF | 8.5333 | 8.6467 | 8.4167 | 8.4167 | 33600.0 |
| 2001-11-28 | IGN | ETF | 34.25 | 34.55 | 32.97 | 32.97 | 311700.0 |
| 2001-11-28 | IGV | ETF | 8.74 | 8.8 | 8.56 | 8.56 | 80000.0 |
| 2001-11-28 | IJH | ETF | 9.74 | 9.756 | 9.607 | 9.607 | 182000.0 |
> showing 50 of 117 rows — these rows as CSV