PREVIEW / etf_daily / 2002-10-24
file: by_date/etf_daily/2002/2002-10-24.parquet size: 9 KB rows: 126
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-10-24 | SPY | ETF | 90.75 | 90.9 | 88.1 | 88.36 | 54987400.0 |
| 2002-10-24 | QQQ | ETF | 24.68 | 24.86 | 23.92 | 23.98 | 89204100.0 |
| 2002-10-24 | IWM | ETF | 36.95 | 37.07 | 36.385 | 36.425 | 5630200.0 |
| 2002-10-24 | DIA | ETF | 85.68 | 85.89 | 82.78 | 83.03 | 12298300.0 |
| 2002-10-24 | TLT | ETF | 84.16 | 85.25 | 84.08 | 85.07 | 339600.0 |
| 2002-10-24 | AAA | ETF | 46.3 | 46.3 | 46.3 | 46.3 | 400.0 |
| 2002-10-24 | ARB | ETF | 34.8 | 34.8 | 33.75 | 33.76 | 80600.0 |
| 2002-10-24 | BBH | ETF | 29.3533 | 29.3533 | 28.37 | 28.4233 | 4944300.0 |
| 2002-10-24 | BITS | ETF | 8.0 | 8.4 | 7.24 | 7.96 | 7075.0 |
| 2002-10-24 | CEF | ETF | 4.1 | 4.1 | 4.01 | 4.07 | 36300.0 |
| 2002-10-24 | CHB | ETF | 2.5 | 2.5 | 2.37 | 2.37 | 165800.0 |
| 2002-10-24 | CNXT | ETF | 1.16 | 1.18 | 1.1 | 1.14 | 9129490.0 |
| 2002-10-24 | CSB | ETF | 7.5 | 7.59999990463257 | 7.48999977111816 | 7.5 | 172700.0 |
| 2002-10-24 | DGT | ETF | 50.5 | 50.5 | 49.88 | 49.88 | 400.0 |
| 2002-10-24 | EFA | ETF | 32.8933 | 32.8933 | 32.25 | 32.25 | 3072900.0 |
| 2002-10-24 | ELV | ETF | 36.05 | 36.055 | 34.26 | 34.625 | 1661700.0 |
| 2002-10-24 | EPP | ETF | 17.43 | 17.4333 | 17.1867 | 17.1867 | 12600.0 |
| 2002-10-24 | EWA | ETF | 9.2 | 9.37 | 9.11 | 9.16 | 32800.0 |
| 2002-10-24 | EWC | ETF | 9.15 | 9.38 | 9.1 | 9.38 | 57900.0 |
| 2002-10-24 | EWD | ETF | 8.75 | 8.75 | 8.7 | 8.7 | 52800.0 |
| 2002-10-24 | EWG | ETF | 9.91 | 10.03 | 9.79 | 9.79 | 49800.0 |
| 2002-10-24 | EWH | ETF | 7.65 | 7.81 | 7.61 | 7.61 | 15400.0 |
| 2002-10-24 | EWI | ETF | 27.56 | 27.74 | 27.56 | 27.74 | 100.0 |
| 2002-10-24 | EWJ | ETF | 27.12 | 27.36 | 26.92 | 26.96 | 70500.0 |
| 2002-10-24 | EWL | ETF | 10.89 | 10.89 | 10.7 | 10.74 | 800.0 |
| 2002-10-24 | EWM | ETF | 21.44 | 21.44 | 21.12 | 21.12 | 24350.0 |
| 2002-10-24 | EWN | ETF | 13.23 | 13.29 | 13.16 | 13.19 | 3000.0 |
| 2002-10-24 | EWP | ETF | 16.46 | 16.46 | 16.46 | 16.46 | 500.0 |
| 2002-10-24 | EWQ | ETF | 14.1 | 14.26 | 14.07 | 14.11 | 7300.0 |
| 2002-10-24 | EWS | ETF | 9.44 | 9.48 | 9.26 | 9.26 | 6350.0 |
| 2002-10-24 | EWT | ETF | 17.22 | 17.24 | 16.72 | 17.24 | 94700.0 |
| 2002-10-24 | EWU | ETF | 25.1 | 25.38 | 24.64 | 24.66 | 82700.0 |
| 2002-10-24 | EWW | ETF | 13.29 | 13.29 | 12.85 | 12.85 | 94000.0 |
| 2002-10-24 | EWY | ETF | 18.73 | 18.73 | 18.3 | 18.3 | 317900.0 |
| 2002-10-24 | EWZ | ETF | 6.5 | 6.8 | 6.5 | 6.7 | 377900.0 |
| 2002-10-24 | EZU | ETF | 20.87 | 20.92 | 20.455 | 20.5 | 47800.0 |
| 2002-10-24 | FCTR | ETF | 16.987 | 16.987 | 16.25 | 16.25 | 15195.0 |
| 2002-10-24 | FEZ | ETF | 24.22 | 24.22 | 23.74 | 23.78 | 61900.0 |
| 2002-10-24 | FMAR | ETF | 10.71 | 10.71 | 10.55 | 10.7 | 3400.0 |
| 2002-10-24 | GLDB | ETF | 8.92 | 9.1 | 8.82 | 9.0 | 148348.0 |
| 2002-10-24 | GRNB | ETF | 17.4245 | 17.6698 | 17.4245 | 17.6689 | 11405.0 |
| 2002-10-24 | GSIG | ETF | 4.55 | 4.65 | 4.52 | 4.64 | 20700.0 |
| 2002-10-24 | IBB | ETF | 16.95 | 16.95 | 16.42 | 16.45 | 1238100.0 |
| 2002-10-24 | ICF | ETF | 19.475 | 19.635 | 19.4025 | 19.575 | 135200.0 |
| 2002-10-24 | IDU | ETF | 22.25 | 22.645 | 21.905 | 22.025 | 722000.0 |
| 2002-10-24 | IEF | ETF | 84.05 | 84.71 | 83.92 | 84.54 | 41800.0 |
| 2002-10-24 | IEV | ETF | 23.575 | 23.575 | 23.175 | 23.195 | 128200.0 |
| 2002-10-24 | IGE | ETF | 13.2767 | 13.2767 | 13.05 | 13.0533 | 103200.0 |
| 2002-10-24 | IGLD | ETF | 91.0 | 94.0 | 86.1 | 91.0 | 96.0 |
| 2002-10-24 | IGM | ETF | 4.8583 | 4.9417 | 4.775 | 4.8 | 1404600.0 |
> showing 50 of 126 rows — these rows as CSV