PREVIEW / etf_daily / 2002-11-20
file: by_date/etf_daily/2002/2002-11-20.parquet size: 10 KB rows: 129
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-11-20 | SPY | ETF | 89.98 | 92.42 | 89.95 | 92.37 | 36688400.0 |
| 2002-11-20 | QQQ | ETF | 25.56 | 26.75 | 25.54 | 26.74 | 75612500.0 |
| 2002-11-20 | IWM | ETF | 37.85 | 38.975 | 37.76 | 38.975 | 2492400.0 |
| 2002-11-20 | DIA | ETF | 84.7 | 86.97 | 84.56 | 86.93 | 8535000.0 |
| 2002-11-20 | TLT | ETF | 88.2 | 88.22 | 86.81 | 86.96 | 307400.0 |
| 2002-11-20 | AAA | ETF | 46.5 | 46.99 | 46.5 | 46.99 | 8000.0 |
| 2002-11-20 | ADRE | ETF | 50.59 | 50.85 | 50.59 | 50.85 | 3200.0 |
| 2002-11-20 | ARB | ETF | 32.2 | 32.75 | 32.0 | 32.5 | 46900.0 |
| 2002-11-20 | BBH | ETF | 29.0 | 29.6733 | 28.9267 | 29.5967 | 2446800.0 |
| 2002-11-20 | BITS | ETF | 7.92 | 8.04 | 7.6 | 7.996 | 1975.0 |
| 2002-11-20 | CEF | ETF | 4.25 | 4.32 | 4.15 | 4.24 | 88000.0 |
| 2002-11-20 | CHB | ETF | 3.45 | 3.45 | 3.17 | 3.3 | 359900.0 |
| 2002-11-20 | CNXT | ETF | 1.825 | 1.8549 | 1.7343 | 1.845 | 3593200.0 |
| 2002-11-20 | CSB | ETF | 8.5 | 8.64999961853027 | 8.5 | 8.64999961853027 | 53400.0 |
| 2002-11-20 | DGT | ETF | 52.32 | 52.56 | 52.04 | 52.56 | 400.0 |
| 2002-11-20 | EFA | ETF | 33.5167 | 34.1 | 33.4667 | 34.1 | 515400.0 |
| 2002-11-20 | ELV | ETF | 30.375 | 31.125 | 30.3 | 31.125 | 2280600.0 |
| 2002-11-20 | EPP | ETF | 17.5267 | 17.7 | 17.5267 | 17.6833 | 46800.0 |
| 2002-11-20 | EWA | ETF | 9.35 | 9.44 | 9.35 | 9.35 | 7100.0 |
| 2002-11-20 | EWC | ETF | 9.06 | 9.36 | 9.06 | 9.36 | 12300.0 |
| 2002-11-20 | EWD | ETF | 10.28 | 10.44 | 10.25 | 10.44 | 1500.0 |
| 2002-11-20 | EWG | ETF | 10.45 | 10.75 | 10.4 | 10.69 | 64200.0 |
| 2002-11-20 | EWH | ETF | 7.86 | 8.15 | 7.86 | 8.12 | 36500.0 |
| 2002-11-20 | EWI | ETF | 29.24 | 29.78 | 29.24 | 29.78 | 5700.0 |
| 2002-11-20 | EWJ | ETF | 26.68 | 27.24 | 26.68 | 27.24 | 151400.0 |
| 2002-11-20 | EWK | ETF | 9.81 | 10.05 | 9.81 | 10.05 | 13900.0 |
| 2002-11-20 | EWL | ETF | 11.11 | 11.36 | 11.11 | 11.36 | 23900.0 |
| 2002-11-20 | EWM | ETF | 20.68 | 20.88 | 20.6 | 20.88 | 11075.0 |
| 2002-11-20 | EWN | ETF | 13.41 | 13.85 | 13.41 | 13.8 | 120300.0 |
| 2002-11-20 | EWO | ETF | 8.0 | 8.14 | 8.0 | 8.14 | 25700.0 |
| 2002-11-20 | EWP | ETF | 17.94 | 17.94 | 17.87 | 17.87 | 2200.0 |
| 2002-11-20 | EWQ | ETF | 14.76 | 15.1 | 14.76 | 15.1 | 60900.0 |
| 2002-11-20 | EWS | ETF | 8.98 | 9.12 | 8.92 | 9.1 | 17050.0 |
| 2002-11-20 | EWT | ETF | 17.46 | 17.5 | 17.08 | 17.5 | 120650.0 |
| 2002-11-20 | EWU | ETF | 25.34 | 25.56 | 25.2 | 25.44 | 56700.0 |
| 2002-11-20 | EWW | ETF | 12.16 | 12.54 | 12.16 | 12.38 | 99900.0 |
| 2002-11-20 | EWY | ETF | 19.53 | 19.99 | 19.53 | 19.99 | 397400.0 |
| 2002-11-20 | EWZ | ETF | 7.39 | 7.54 | 7.21 | 7.54 | 123500.0 |
| 2002-11-20 | EZU | ETF | 21.965 | 22.47 | 21.95 | 22.445 | 103000.0 |
| 2002-11-20 | FCTR | ETF | 17.25 | 17.55 | 17.13 | 17.5 | 26700.0 |
| 2002-11-20 | FEZ | ETF | 25.1 | 25.81 | 25.1 | 25.81 | 27100.0 |
| 2002-11-20 | FMAR | ETF | 10.72 | 11.0 | 10.72 | 10.73 | 7700.0 |
| 2002-11-20 | GLDB | ETF | 9.6 | 9.79 | 9.58 | 9.58 | 111254.0 |
| 2002-11-20 | GRNB | ETF | 17.179 | 17.7876 | 17.179 | 17.7876 | 303.0 |
| 2002-11-20 | GSIG | ETF | 6.0 | 6.49 | 6.0 | 6.33 | 47400.0 |
| 2002-11-20 | IBB | ETF | 17.4167 | 17.9667 | 17.4167 | 17.9167 | 886500.0 |
| 2002-11-20 | ICF | ETF | 20.3 | 20.42 | 20.175 | 20.3 | 67200.0 |
| 2002-11-20 | IDU | ETF | 22.8 | 22.995 | 22.6 | 22.88 | 93200.0 |
| 2002-11-20 | IEF | ETF | 85.59 | 85.6 | 84.81 | 84.93 | 251800.0 |
| 2002-11-20 | IEV | ETF | 24.475 | 24.85 | 24.375 | 24.85 | 62600.0 |
> showing 50 of 129 rows — these rows as CSV