PREVIEW / etf_daily / 2002-07-22
file: by_date/etf_daily/2002/2002-07-22.parquet size: 9 KB rows: 120
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-07-22 | SPY | ETF | 84.1 | 85.91 | 81.45 | 82.2 | 78134000.0 |
| 2002-07-22 | QQQ | ETF | 23.855 | 24.5 | 23.09 | 23.4 | 150034800.0 |
| 2002-07-22 | IWM | ETF | 38.3 | 38.895 | 37.3 | 37.855 | 3325800.0 |
| 2002-07-22 | DIA | ETF | 79.37 | 81.49 | 77.1 | 78.06 | 24645000.0 |
| 2002-07-22 | AAA | ETF | 46.0 | 46.0 | 46.0 | 46.0 | 300.0 |
| 2002-07-22 | ARB | ETF | 32.1 | 32.22 | 30.64 | 31.2 | 174200.0 |
| 2002-07-22 | BBH | ETF | 23.9 | 24.3467 | 23.1833 | 23.47 | 6262200.0 |
| 2002-07-22 | BITS | ETF | 8.76 | 9.2 | 8.6 | 9.2 | 1075.0 |
| 2002-07-22 | CEF | ETF | 4.48 | 4.48 | 4.35 | 4.4 | 169900.0 |
| 2002-07-22 | CHB | ETF | 3.2 | 3.36 | 3.15 | 3.15 | 463200.0 |
| 2002-07-22 | CNXT | ETF | 2.03 | 2.17 | 1.77 | 1.88 | 9196920.0 |
| 2002-07-22 | DGT | ETF | 48.96 | 48.96 | 46.13 | 46.65 | 7500.0 |
| 2002-07-22 | EFA | ETF | 35.5333 | 35.8 | 34.5 | 34.6167 | 1177800.0 |
| 2002-07-22 | ELV | ETF | 31.375 | 31.375 | 28.375 | 29.3 | 2502000.0 |
| 2002-07-22 | EPP | ETF | 17.85 | 17.9167 | 17.42 | 17.42 | 237900.0 |
| 2002-07-22 | EWA | ETF | 9.18 | 9.18 | 9.01 | 9.03 | 8300.0 |
| 2002-07-22 | EWC | ETF | 9.6 | 9.6 | 9.1 | 9.12 | 11600.0 |
| 2002-07-22 | EWD | ETF | 9.86 | 9.94 | 9.66 | 9.9 | 3500.0 |
| 2002-07-22 | EWG | ETF | 12.62 | 12.62 | 12.16 | 12.25 | 30300.0 |
| 2002-07-22 | EWH | ETF | 8.45 | 8.47 | 8.11 | 8.13 | 98000.0 |
| 2002-07-22 | EWI | ETF | 29.42 | 29.42 | 28.7 | 29.22 | 7600.0 |
| 2002-07-22 | EWJ | ETF | 32.92 | 33.32 | 32.32 | 32.8 | 394425.0 |
| 2002-07-22 | EWK | ETF | 10.11 | 10.11 | 9.81 | 9.96 | 9300.0 |
| 2002-07-22 | EWL | ETF | 11.17 | 11.3 | 10.95 | 11.0 | 30100.0 |
| 2002-07-22 | EWM | ETF | 22.8 | 23.04 | 22.0 | 22.16 | 66200.0 |
| 2002-07-22 | EWN | ETF | 14.4 | 14.4 | 13.75 | 14.19 | 7800.0 |
| 2002-07-22 | EWO | ETF | 8.94 | 8.95 | 8.94 | 8.95 | 2500.0 |
| 2002-07-22 | EWP | ETF | 18.21 | 18.31 | 17.81 | 18.22 | 4500.0 |
| 2002-07-22 | EWQ | ETF | 15.29 | 15.47 | 14.8 | 14.85 | 101900.0 |
| 2002-07-22 | EWS | ETF | 10.52 | 10.8 | 10.02 | 10.04 | 202550.0 |
| 2002-07-22 | EWT | ETF | 19.12 | 19.6 | 19.06 | 19.24 | 21300.0 |
| 2002-07-22 | EWU | ETF | 25.04 | 25.18 | 24.02 | 24.38 | 52800.0 |
| 2002-07-22 | EWW | ETF | 14.44 | 14.44 | 13.7 | 13.7 | 10600.0 |
| 2002-07-22 | EWY | ETF | 21.68 | 21.68 | 20.81 | 21.0 | 134600.0 |
| 2002-07-22 | EWZ | ETF | 8.82 | 9.1 | 8.52 | 8.59 | 37500.0 |
| 2002-07-22 | EZU | ETF | 23.0 | 23.225 | 22.43 | 22.685 | 114600.0 |
| 2002-07-22 | FCTR | ETF | 17.351 | 17.4 | 16.84 | 16.84 | 268900.0 |
| 2002-07-22 | FMAR | ETF | 10.3 | 10.51 | 10.25 | 10.3 | 12200.0 |
| 2002-07-22 | GLDB | ETF | 10.499 | 10.499 | 9.45 | 10.0 | 70100.0 |
| 2002-07-22 | GSIG | ETF | 8.32 | 8.38 | 8.22 | 8.25 | 30600.0 |
| 2002-07-22 | IBB | ETF | 14.8333 | 15.3167 | 14.5067 | 14.8833 | 5469900.0 |
| 2002-07-22 | ICF | ETF | 20.45 | 20.76 | 19.45 | 20.01 | 397200.0 |
| 2002-07-22 | IDU | ETF | 23.125 | 23.35 | 22.18 | 22.945 | 72800.0 |
| 2002-07-22 | IEV | ETF | 24.5 | 25.0 | 23.88 | 24.07 | 367600.0 |
| 2002-07-22 | IGE | ETF | 12.6417 | 12.85 | 12.6367 | 12.85 | 1800.0 |
| 2002-07-22 | IGLD | ETF | 108.0 | 108.1 | 107.0 | 107.0 | 136.0 |
| 2002-07-22 | IGM | ETF | 5.1083 | 5.2583 | 4.9933 | 5.0583 | 109800.0 |
| 2002-07-22 | IGN | ETF | 14.95 | 15.35 | 14.31 | 14.6 | 16800.0 |
| 2002-07-22 | IGV | ETF | 4.66 | 4.778 | 4.572 | 4.6 | 1528500.0 |
| 2002-07-22 | IJH | ETF | 8.4 | 8.499 | 8.044 | 8.16 | 1287000.0 |
> showing 50 of 120 rows — these rows as CSV