PREVIEW / etf_daily / 2002-04-18
file: by_date/etf_daily/2002/2002-04-18.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-04-18 | SPY | ETF | 112.9 | 113.46 | 111.15 | 112.47 | 25204800.0 |
| 2002-04-18 | QQQ | ETF | 34.785 | 35.15 | 34.0 | 34.35 | 91270100.0 |
| 2002-04-18 | IWM | ETF | 51.775 | 51.865 | 51.075 | 51.49 | 2359200.0 |
| 2002-04-18 | DIA | ETF | 102.4 | 102.75 | 100.62 | 101.98 | 5819200.0 |
| 2002-04-18 | ARB | ETF | 34.9 | 35.3 | 34.45 | 35.21 | 156000.0 |
| 2002-04-18 | BBH | ETF | 36.6667 | 37.3833 | 36.3 | 37.3333 | 3654900.0 |
| 2002-04-18 | BITS | ETF | 16.84 | 16.84 | 16.28 | 16.8 | 3025.0 |
| 2002-04-18 | CEF | ETF | 3.9 | 3.9 | 3.79 | 3.85 | 34900.0 |
| 2002-04-18 | CHB | ETF | 8.75 | 9.09 | 8.73 | 8.93 | 365900.0 |
| 2002-04-18 | CNXT | ETF | 12.66 | 12.77 | 12.132 | 12.59 | 3800880.0 |
| 2002-04-18 | CSB | ETF | 3.75999999046326 | 3.75999999046326 | 3.75 | 3.75 | 5000.0 |
| 2002-04-18 | DGT | ETF | 62.4 | 62.4 | 62.4 | 62.4 | 300.0 |
| 2002-04-18 | EFA | ETF | 40.9167 | 40.9267 | 40.3667 | 40.7633 | 127200.0 |
| 2002-04-18 | ELV | ETF | 32.95 | 34.125 | 32.875 | 34.125 | 2159500.0 |
| 2002-04-18 | EPP | ETF | 19.1433 | 19.1433 | 19.1 | 19.1267 | 19200.0 |
| 2002-04-18 | EWA | ETF | 9.99 | 10.1 | 9.99 | 10.1 | 64400.0 |
| 2002-04-18 | EWC | ETF | 11.35 | 11.45 | 11.15 | 11.3 | 87600.0 |
| 2002-04-18 | EWD | ETF | 13.04 | 13.19 | 13.04 | 13.19 | 17500.0 |
| 2002-04-18 | EWG | ETF | 15.31 | 15.39 | 15.1 | 15.1 | 6100.0 |
| 2002-04-18 | EWH | ETF | 9.35 | 9.45 | 9.26 | 9.43 | 182300.0 |
| 2002-04-18 | EWI | ETF | 34.2 | 34.2 | 33.5 | 33.98 | 20300.0 |
| 2002-04-18 | EWJ | ETF | 33.28 | 33.4 | 33.0 | 33.32 | 451825.0 |
| 2002-04-18 | EWK | ETF | 11.6 | 11.64 | 11.6 | 11.64 | 10500.0 |
| 2002-04-18 | EWL | ETF | 13.5 | 13.59 | 13.43 | 13.59 | 38600.0 |
| 2002-04-18 | EWM | ETF | 25.0 | 25.2 | 24.88 | 25.2 | 131550.0 |
| 2002-04-18 | EWN | ETF | 18.36 | 18.36 | 18.19 | 18.23 | 1900.0 |
| 2002-04-18 | EWO | ETF | 8.74 | 8.77 | 8.64 | 8.77 | 21000.0 |
| 2002-04-18 | EWP | ETF | 21.28 | 21.28 | 20.95 | 21.24 | 46400.0 |
| 2002-04-18 | EWQ | ETF | 18.75 | 18.89 | 18.6 | 18.6 | 27100.0 |
| 2002-04-18 | EWS | ETF | 11.0 | 11.16 | 10.8 | 10.86 | 117200.0 |
| 2002-04-18 | EWT | ETF | 24.7 | 24.7 | 24.48 | 24.7 | 80300.0 |
| 2002-04-18 | EWU | ETF | 29.58 | 29.8 | 29.2 | 29.42 | 18400.0 |
| 2002-04-18 | EWW | ETF | 18.15 | 18.18 | 17.6 | 17.95 | 145800.0 |
| 2002-04-18 | EWY | ETF | 24.49 | 24.6 | 23.76 | 24.0 | 108300.0 |
| 2002-04-18 | EWZ | ETF | 13.63 | 13.64 | 13.48 | 13.64 | 903000.0 |
| 2002-04-18 | EZU | ETF | 28.2 | 28.2 | 27.555 | 27.915 | 151200.0 |
| 2002-04-18 | FCTR | ETF | 20.1 | 20.1 | 19.87 | 20.02 | 58500.0 |
| 2002-04-18 | FMAR | ETF | 11.55 | 11.95 | 11.45 | 11.61 | 15800.0 |
| 2002-04-18 | GLDB | ETF | 10.08 | 10.17 | 10.05 | 10.15 | 87800.0 |
| 2002-04-18 | GSIG | ETF | 11.35 | 11.35 | 11.0 | 11.16 | 47700.0 |
| 2002-04-18 | IBB | ETF | 24.3667 | 24.8 | 24.0 | 24.75 | 1435200.0 |
| 2002-04-18 | ICF | ETF | 23.025 | 23.125 | 22.885 | 22.9375 | 284000.0 |
| 2002-04-18 | IDU | ETF | 33.225 | 33.355 | 32.985 | 33.35 | 118000.0 |
| 2002-04-18 | IEV | ETF | 30.125 | 30.15 | 29.625 | 30.12 | 69800.0 |
| 2002-04-18 | IGE | ETF | 17.2417 | 17.2667 | 17.2 | 17.2 | 45600.0 |
| 2002-04-18 | IGLD | ETF | 112.0 | 114.0 | 109.0 | 110.0 | 616.0 |
| 2002-04-18 | IGM | ETF | 7.4283 | 7.4383 | 7.32 | 7.3533 | 78600.0 |
| 2002-04-18 | IGN | ETF | 24.0 | 24.05 | 23.52 | 24.05 | 11800.0 |
| 2002-04-18 | IGV | ETF | 7.14 | 7.194 | 7.116 | 7.188 | 107500.0 |
| 2002-04-18 | IJH | ETF | 11.027 | 11.027 | 10.86 | 10.947 | 687000.0 |
> showing 50 of 119 rows — these rows as CSV