PREVIEW / etf_daily / 2002-11-18
file: by_date/etf_daily/2002/2002-11-18.parquet size: 9 KB rows: 125
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-18 | SPY | ETF | 92.15 | 92.15 | 90.35 | 90.48 | 28934800.0 |
| 2002-11-18 | QQQ | ETF | 26.715 | 26.77 | 25.99 | 26.05 | 76926700.0 |
| 2002-11-18 | IWM | ETF | 38.875 | 38.875 | 38.035 | 38.105 | 2844200.0 |
| 2002-11-18 | DIA | ETF | 86.5 | 86.76 | 84.9 | 84.91 | 5612900.0 |
| 2002-11-18 | TLT | ETF | 87.02 | 87.63 | 86.96 | 87.5 | 32200.0 |
| 2002-11-18 | AAA | ETF | 47.3 | 47.3 | 46.5 | 46.5 | 1400.0 |
| 2002-11-18 | ADRE | ETF | 50.75 | 50.93 | 50.75 | 50.93 | 400.0 |
| 2002-11-18 | ARB | ETF | 31.97 | 32.7 | 31.55 | 32.32 | 172900.0 |
| 2002-11-18 | BBH | ETF | 29.9333 | 29.9333 | 29.19 | 29.19 | 2073900.0 |
| 2002-11-18 | BITS | ETF | 7.28 | 7.44 | 7.28 | 7.44 | 275.0 |
| 2002-11-18 | CEF | ETF | 4.26 | 4.37 | 4.26 | 4.33 | 42000.0 |
| 2002-11-18 | CHB | ETF | 2.9 | 3.9 | 2.88 | 3.88 | 693800.0 |
| 2002-11-18 | CNXT | ETF | 1.9713 | 1.9815 | 1.829 | 1.89 | 5689650.0 |
| 2002-11-18 | CSB | ETF | 8.39000034332275 | 8.5 | 8.39000034332275 | 8.5 | 4900.0 |
| 2002-11-18 | DGT | ETF | 52.31 | 52.35 | 52.25 | 52.25 | 1200.0 |
| 2002-11-18 | EFA | ETF | 34.3167 | 34.3167 | 33.8867 | 33.95 | 499500.0 |
| 2002-11-18 | ELV | ETF | 32.5 | 32.775 | 32.21 | 32.21 | 1078900.0 |
| 2002-11-18 | EPP | ETF | 17.6167 | 17.6167 | 17.4367 | 17.48 | 63600.0 |
| 2002-11-18 | EWA | ETF | 9.28 | 9.47 | 9.25 | 9.4 | 29200.0 |
| 2002-11-18 | EWC | ETF | 9.18 | 9.27 | 9.11 | 9.22 | 23200.0 |
| 2002-11-18 | EWD | ETF | 10.64 | 10.65 | 10.56 | 10.64 | 8600.0 |
| 2002-11-18 | EWG | ETF | 10.81 | 10.96 | 10.6 | 10.6 | 52200.0 |
| 2002-11-18 | EWH | ETF | 7.99 | 8.05 | 7.86 | 7.96 | 72900.0 |
| 2002-11-18 | EWI | ETF | 29.64 | 29.78 | 29.4 | 29.72 | 600.0 |
| 2002-11-18 | EWJ | ETF | 27.28 | 27.28 | 26.84 | 26.96 | 139175.0 |
| 2002-11-18 | EWK | ETF | 10.03 | 10.03 | 9.98 | 9.98 | 146700.0 |
| 2002-11-18 | EWL | ETF | 11.64 | 11.64 | 11.35 | 11.42 | 6800.0 |
| 2002-11-18 | EWM | ETF | 20.92 | 21.0 | 20.76 | 20.92 | 47650.0 |
| 2002-11-18 | EWN | ETF | 13.81 | 13.81 | 13.65 | 13.65 | 66600.0 |
| 2002-11-18 | EWO | ETF | 7.98 | 8.1 | 7.98 | 8.1 | 27000.0 |
| 2002-11-18 | EWP | ETF | 18.39 | 18.4 | 18.2 | 18.2 | 8000.0 |
| 2002-11-18 | EWQ | ETF | 15.35 | 15.35 | 15.15 | 15.26 | 21500.0 |
| 2002-11-18 | EWS | ETF | 9.1 | 9.16 | 8.98 | 9.0 | 7950.0 |
| 2002-11-18 | EWT | ETF | 18.7 | 18.8 | 18.32 | 18.32 | 232150.0 |
| 2002-11-18 | EWU | ETF | 25.78 | 25.78 | 25.32 | 25.4 | 29600.0 |
| 2002-11-18 | EWW | ETF | 12.6 | 12.79 | 12.41 | 12.65 | 12300.0 |
| 2002-11-18 | EWY | ETF | 20.03 | 20.03 | 19.41 | 19.41 | 17500.0 |
| 2002-11-18 | EWZ | ETF | 7.3 | 7.52 | 7.26 | 7.48 | 37800.0 |
| 2002-11-18 | EZU | ETF | 22.665 | 22.665 | 22.3 | 22.3 | 49000.0 |
| 2002-11-18 | FCTR | ETF | 17.65 | 17.65 | 16.97 | 16.98 | 32190.0 |
| 2002-11-18 | FEZ | ETF | 26.1 | 26.1 | 25.68 | 25.68 | 60000.0 |
| 2002-11-18 | FMAR | ETF | 10.8 | 10.97 | 10.45 | 10.97 | 8000.0 |
| 2002-11-18 | GLDB | ETF | 10.1 | 10.16 | 9.71 | 9.71 | 109744.0 |
| 2002-11-18 | GSIG | ETF | 5.66 | 5.96 | 5.66 | 5.96 | 30000.0 |
| 2002-11-18 | IBB | ETF | 17.95 | 17.9967 | 17.6 | 17.6 | 443400.0 |
| 2002-11-18 | ICF | ETF | 20.4 | 20.41 | 20.305 | 20.305 | 23200.0 |
| 2002-11-18 | IDU | ETF | 22.855 | 23.095 | 22.685 | 22.8 | 99800.0 |
| 2002-11-18 | IEF | ETF | 85.13 | 85.44 | 85.05 | 85.33 | 35300.0 |
| 2002-11-18 | IEV | ETF | 25.125 | 25.125 | 24.73 | 24.75 | 194800.0 |
| 2002-11-18 | IGE | ETF | 13.2083 | 13.2083 | 13.1333 | 13.1333 | 140400.0 |
> showing 50 of 125 rows — these rows as CSV