PREVIEW / etf_daily / 2002-01-04
file: by_date/etf_daily/2002/2002-01-04.parquet size: 9 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-04 | SPY | ETF | 117.17 | 117.98 | 116.55 | 117.62 | 20140700.0 |
| 2002-01-04 | QQQ | ETF | 41.95 | 42.29 | 40.93 | 41.67 | 86876900.0 |
| 2002-01-04 | IWM | ETF | 49.375 | 49.92 | 49.15 | 49.725 | 1304400.0 |
| 2002-01-04 | DIA | ETF | 102.36 | 102.95 | 102.02 | 102.82 | 2288900.0 |
| 2002-01-04 | ARB | ETF | 32.53 | 32.98 | 32.52 | 32.54 | 44000.0 |
| 2002-01-04 | BBH | ETF | 42.5 | 43.5333 | 41.3333 | 43.2567 | 10707600.0 |
| 2002-01-04 | BITS | ETF | 27.76 | 27.88 | 25.84 | 26.52 | 6750.0 |
| 2002-01-04 | CEF | ETF | 3.39 | 3.45 | 3.33 | 3.4 | 30200.0 |
| 2002-01-04 | CHB | ETF | 11.88 | 11.88 | 10.75 | 11.8 | 957900.0 |
| 2002-01-04 | CNXT | ETF | 16.25 | 16.51 | 15.15 | 15.27 | 6537960.0 |
| 2002-01-04 | CSB | ETF | 4.19999980926514 | 4.25 | 4.19999980926514 | 4.25 | 4000.0 |
| 2002-01-04 | DGT | ETF | 67.59 | 67.69 | 67.59 | 67.69 | 400.0 |
| 2002-01-04 | EFA | ETF | 40.6667 | 40.69 | 40.3333 | 40.6133 | 377400.0 |
| 2002-01-04 | ELV | ETF | 24.25 | 24.4 | 23.45 | 23.93 | 1159300.0 |
| 2002-01-04 | EPP | ETF | 18.5433 | 18.5533 | 18.47 | 18.5533 | 10800.0 |
| 2002-01-04 | EWA | ETF | 9.5 | 9.8 | 9.5 | 9.8 | 44600.0 |
| 2002-01-04 | EWC | ETF | 11.0 | 11.35 | 10.86 | 11.35 | 53200.0 |
| 2002-01-04 | EWD | ETF | 14.7 | 14.7 | 14.5 | 14.63 | 1900.0 |
| 2002-01-04 | EWG | ETF | 15.55 | 15.57 | 15.37 | 15.45 | 19900.0 |
| 2002-01-04 | EWH | ETF | 9.53 | 9.6 | 9.45 | 9.59 | 164700.0 |
| 2002-01-04 | EWI | ETF | 32.5 | 32.54 | 32.5 | 32.54 | 3550.0 |
| 2002-01-04 | EWJ | ETF | 32.04 | 32.28 | 32.0 | 32.28 | 157700.0 |
| 2002-01-04 | EWK | ETF | 10.98 | 10.98 | 10.76 | 10.76 | 1000.0 |
| 2002-01-04 | EWL | ETF | 12.56 | 12.82 | 12.56 | 12.82 | 3300.0 |
| 2002-01-04 | EWM | ETF | 20.48 | 20.52 | 20.48 | 20.52 | 12625.0 |
| 2002-01-04 | EWN | ETF | 17.38 | 17.38 | 17.01 | 17.01 | 2400.0 |
| 2002-01-04 | EWO | ETF | 7.4 | 7.49 | 7.4 | 7.49 | 1700.0 |
| 2002-01-04 | EWP | ETF | 20.96 | 21.21 | 20.96 | 21.09 | 9300.0 |
| 2002-01-04 | EWQ | ETF | 19.09 | 19.2 | 18.96 | 19.1 | 5900.0 |
| 2002-01-04 | EWS | ETF | 10.6 | 10.72 | 10.44 | 10.7 | 36900.0 |
| 2002-01-04 | EWT | ETF | 22.5 | 22.54 | 22.24 | 22.48 | 50450.0 |
| 2002-01-04 | EWU | ETF | 29.92 | 29.92 | 29.52 | 29.66 | 31250.0 |
| 2002-01-04 | EWW | ETF | 15.94 | 15.99 | 15.71 | 15.83 | 37300.0 |
| 2002-01-04 | EWY | ETF | 19.7 | 19.74 | 19.41 | 19.57 | 126400.0 |
| 2002-01-04 | EWZ | ETF | 13.3 | 13.35 | 13.19 | 13.19 | 16100.0 |
| 2002-01-04 | EZU | ETF | 28.65 | 28.65 | 28.38 | 28.5 | 110600.0 |
| 2002-01-04 | FCTR | ETF | 18.3 | 18.55 | 17.75 | 17.78 | 36100.0 |
| 2002-01-04 | FMAR | ETF | 9.33 | 9.79 | 9.315 | 9.79 | 22100.0 |
| 2002-01-04 | GLDB | ETF | 7.21 | 7.4 | 7.21 | 7.25 | 91100.0 |
| 2002-01-04 | GSIG | ETF | 9.24 | 10.5 | 9.11 | 10.4 | 383700.0 |
| 2002-01-04 | IBB | ETF | 29.3 | 29.75 | 28.2667 | 29.5167 | 3177900.0 |
| 2002-01-04 | ICF | ETF | 21.325 | 21.33 | 21.1325 | 21.19 | 19200.0 |
| 2002-01-04 | IDU | ETF | 31.995 | 32.0 | 31.6 | 31.865 | 73400.0 |
| 2002-01-04 | IEV | ETF | 30.325 | 30.35 | 30.0 | 30.18 | 266800.0 |
| 2002-01-04 | IGE | ETF | 15.7 | 15.73 | 15.7 | 15.73 | 1800.0 |
| 2002-01-04 | IGLD | ETF | 100.0 | 107.0 | 96.0 | 98.0 | 734.0 |
| 2002-01-04 | IGM | ETF | 9.1583 | 9.1667 | 8.96 | 9.1033 | 97800.0 |
| 2002-01-04 | IGN | ETF | 34.45 | 34.59 | 33.18 | 34.15 | 612900.0 |
| 2002-01-04 | IGV | ETF | 9.8 | 9.846 | 9.616 | 9.7 | 77500.0 |
| 2002-01-04 | IJH | ETF | 10.24 | 10.362 | 10.24 | 10.347 | 445000.0 |
> showing 50 of 119 rows — these rows as CSV