PREVIEW / etf_daily / 2001-11-12
file: by_date/etf_daily/2001/2001-11-12.parquet size: 9 KB rows: 114
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-12 | SPY | ETF | 111.0 | 112.65 | 110.0 | 112.03 | 26068800.0 |
| 2001-11-12 | QQQ | ETF | 37.0 | 38.35 | 36.3 | 38.0 | 112994400.0 |
| 2001-11-12 | IWM | ETF | 43.35 | 43.89 | 42.53 | 43.875 | 230200.0 |
| 2001-11-12 | DIA | ETF | 95.2 | 96.12 | 94.0 | 95.53 | 4122500.0 |
| 2001-11-12 | ARB | ETF | 28.8 | 29.3 | 28.55 | 29.13 | 52100.0 |
| 2001-11-12 | BBH | ETF | 41.3667 | 42.9667 | 41.2667 | 42.65 | 7316700.0 |
| 2001-11-12 | BITS | ETF | 16.44 | 17.6 | 16.4 | 17.6 | 7100.0 |
| 2001-11-12 | CEF | ETF | 3.39 | 3.39 | 3.3 | 3.32 | 19800.0 |
| 2001-11-12 | CHB | ETF | 9.61 | 9.98 | 9.61 | 9.98 | 43900.0 |
| 2001-11-12 | CNXT | ETF | 13.2 | 13.58 | 12.0 | 13.38 | 4469510.0 |
| 2001-11-12 | CSB | ETF | 3.95000004768372 | 3.95000004768372 | 3.95000004768372 | 3.95000004768372 | 1000.0 |
| 2001-11-12 | DGT | ETF | 65.45 | 66.43 | 65.15 | 66.43 | 2600.0 |
| 2001-11-12 | EFA | ETF | 39.1667 | 39.26 | 38.9167 | 39.2 | 512700.0 |
| 2001-11-12 | ELV | ETF | 21.0 | 21.425 | 20.85 | 21.425 | 486800.0 |
| 2001-11-12 | EPP | ETF | 17.1333 | 17.1333 | 17.1333 | 17.1333 | 600.0 |
| 2001-11-12 | EWA | ETF | 9.15 | 9.3 | 9.03 | 9.29 | 13900.0 |
| 2001-11-12 | EWC | ETF | 10.05 | 10.05 | 10.0 | 10.0 | 5800.0 |
| 2001-11-12 | EWD | ETF | 12.4 | 12.4 | 12.15 | 12.2 | 3900.0 |
| 2001-11-12 | EWG | ETF | 14.08 | 14.08 | 13.6 | 13.9 | 72400.0 |
| 2001-11-12 | EWH | ETF | 8.05 | 8.43 | 8.05 | 8.43 | 45500.0 |
| 2001-11-12 | EWI | ETF | 31.6 | 31.98 | 30.72 | 30.82 | 8800.0 |
| 2001-11-12 | EWJ | ETF | 33.08 | 33.24 | 32.68 | 32.96 | 86175.0 |
| 2001-11-12 | EWK | ETF | 10.6 | 10.69 | 10.56 | 10.56 | 30800.0 |
| 2001-11-12 | EWL | ETF | 12.4 | 12.54 | 12.3 | 12.31 | 26400.0 |
| 2001-11-12 | EWM | ETF | 17.6 | 17.6 | 17.0 | 17.2 | 2375.0 |
| 2001-11-12 | EWN | ETF | 16.45 | 16.65 | 16.4 | 16.41 | 2400.0 |
| 2001-11-12 | EWO | ETF | 6.88 | 6.99 | 6.88 | 6.95 | 3100.0 |
| 2001-11-12 | EWP | ETF | 20.07 | 20.07 | 19.75 | 20.04 | 3200.0 |
| 2001-11-12 | EWQ | ETF | 18.3 | 18.3 | 17.25 | 17.95 | 40600.0 |
| 2001-11-12 | EWS | ETF | 8.42 | 8.66 | 8.3 | 8.62 | 21400.0 |
| 2001-11-12 | EWT | ETF | 16.5 | 16.78 | 16.4 | 16.52 | 8950.0 |
| 2001-11-12 | EWU | ETF | 29.44 | 29.46 | 28.78 | 29.46 | 6550.0 |
| 2001-11-12 | EWW | ETF | 13.2 | 13.35 | 13.0 | 13.35 | 11500.0 |
| 2001-11-12 | EWY | ETF | 14.8 | 14.8 | 14.4 | 14.63 | 18600.0 |
| 2001-11-12 | EWZ | ETF | 10.7 | 10.99 | 10.59 | 10.87 | 14800.0 |
| 2001-11-12 | EZU | ETF | 26.75 | 26.75 | 26.0 | 26.37 | 19200.0 |
| 2001-11-12 | FCTR | ETF | 16.46 | 17.0 | 16.3 | 16.8 | 47300.0 |
| 2001-11-12 | FMAR | ETF | 8.18 | 8.34 | 8.15 | 8.15 | 14500.0 |
| 2001-11-12 | GLDB | ETF | 7.51 | 7.55 | 7.4 | 7.52 | 36800.0 |
| 2001-11-12 | GRNB | ETF | 16.1974 | 16.1974 | 16.1974 | 16.1974 | 101.0 |
| 2001-11-12 | GSIG | ETF | 8.22 | 8.69 | 8.22 | 8.6 | 84600.0 |
| 2001-11-12 | IBB | ETF | 27.7667 | 28.8167 | 27.5167 | 28.7633 | 775200.0 |
| 2001-11-12 | ICF | ETF | 20.3 | 20.3975 | 20.1 | 20.3375 | 17200.0 |
| 2001-11-12 | IDU | ETF | 32.85 | 33.12 | 32.58 | 33.1 | 208400.0 |
| 2001-11-12 | IEV | ETF | 29.25 | 29.25 | 28.335 | 28.525 | 127200.0 |
| 2001-11-12 | IGLD | ETF | 90.0 | 93.0 | 90.0 | 90.0 | 499.0 |
| 2001-11-12 | IGM | ETF | 8.0 | 8.2667 | 8.0 | 8.225 | 2947800.0 |
| 2001-11-12 | IGN | ETF | 30.75 | 31.35 | 30.7 | 31.35 | 6700.0 |
| 2001-11-12 | IGV | ETF | 7.95 | 8.238 | 7.892 | 8.238 | 42500.0 |
| 2001-11-12 | IJH | ETF | 9.285 | 9.444 | 9.23 | 9.429 | 188000.0 |
> showing 50 of 114 rows — these rows as CSV