PREVIEW / etf_daily / 2002-08-27
file: by_date/etf_daily/2002/2002-08-27.parquet size: 9 KB rows: 124
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-08-27 | SPY | ETF | 95.7 | 96.25 | 93.5 | 94.16 | 35335700.0 |
| 2002-08-27 | QQQ | ETF | 25.431 | 25.518 | 24.15 | 24.37 | 92356100.0 |
| 2002-08-27 | IWM | ETF | 40.875 | 40.895 | 39.66 | 39.775 | 2726800.0 |
| 2002-08-27 | DIA | ETF | 89.98 | 90.44 | 87.95 | 88.5 | 9351100.0 |
| 2002-08-27 | TLT | ETF | 85.4 | 85.68 | 85.2 | 85.44 | 301800.0 |
| 2002-08-27 | AAA | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 100.0 |
| 2002-08-27 | ARB | ETF | 33.7 | 33.7 | 32.45 | 32.58 | 63400.0 |
| 2002-08-27 | BBH | ETF | 29.6667 | 29.6667 | 28.2967 | 28.3767 | 5512800.0 |
| 2002-08-27 | BITS | ETF | 10.6 | 11.0 | 10.4 | 10.4056 | 2025.0 |
| 2002-08-27 | CEF | ETF | 4.14 | 4.2 | 4.13 | 4.19 | 65900.0 |
| 2002-08-27 | CHB | ETF | 3.0 | 3.2 | 2.85 | 2.88 | 158600.0 |
| 2002-08-27 | CNXT | ETF | 1.6497 | 1.6596 | 1.5503 | 1.5503 | 2627410.0 |
| 2002-08-27 | CSB | ETF | 6.90000009536743 | 7.0 | 6.80000019073486 | 7.0 | 55000.0 |
| 2002-08-27 | DGT | ETF | 53.61 | 53.61 | 53.61 | 53.61 | 100.0 |
| 2002-08-27 | EFA | ETF | 36.8833 | 37.0833 | 36.5367 | 36.77 | 1427700.0 |
| 2002-08-27 | ELV | ETF | 32.19 | 32.405 | 31.0 | 31.16 | 1249600.0 |
| 2002-08-27 | EPP | ETF | 18.0267 | 18.0967 | 17.9033 | 17.9033 | 26700.0 |
| 2002-08-27 | EWA | ETF | 9.52 | 9.56 | 9.38 | 9.38 | 14500.0 |
| 2002-08-27 | EWC | ETF | 9.65 | 9.89 | 9.65 | 9.83 | 45400.0 |
| 2002-08-27 | EWD | ETF | 10.29 | 10.29 | 9.85 | 9.85 | 30800.0 |
| 2002-08-27 | EWG | ETF | 12.57 | 12.57 | 12.39 | 12.5 | 25200.0 |
| 2002-08-27 | EWH | ETF | 8.11 | 8.11 | 7.92 | 7.92 | 305000.0 |
| 2002-08-27 | EWI | ETF | 31.4 | 32.02 | 31.18 | 31.48 | 7800.0 |
| 2002-08-27 | EWJ | ETF | 31.92 | 32.12 | 31.84 | 31.92 | 142350.0 |
| 2002-08-27 | EWK | ETF | 10.89 | 10.96 | 10.89 | 10.96 | 2200.0 |
| 2002-08-27 | EWL | ETF | 12.2 | 12.33 | 12.01 | 12.2 | 21100.0 |
| 2002-08-27 | EWM | ETF | 23.12 | 23.2 | 23.12 | 23.2 | 16300.0 |
| 2002-08-27 | EWN | ETF | 15.53 | 15.53 | 15.21 | 15.21 | 11100.0 |
| 2002-08-27 | EWO | ETF | 8.04 | 8.23 | 8.03 | 8.2 | 9800.0 |
| 2002-08-27 | EWP | ETF | 18.46 | 18.6 | 18.46 | 18.6 | 2100.0 |
| 2002-08-27 | EWQ | ETF | 16.1 | 16.3 | 16.05 | 16.21 | 10200.0 |
| 2002-08-27 | EWS | ETF | 10.12 | 10.28 | 10.06 | 10.06 | 9700.0 |
| 2002-08-27 | EWT | ETF | 18.5 | 18.5 | 18.0 | 18.0 | 12050.0 |
| 2002-08-27 | EWU | ETF | 26.64 | 26.98 | 26.58 | 26.8 | 46450.0 |
| 2002-08-27 | EWW | ETF | 14.04 | 14.04 | 13.5 | 13.65 | 6300.0 |
| 2002-08-27 | EWY | ETF | 21.2 | 21.2 | 20.71 | 20.71 | 5800.0 |
| 2002-08-27 | EWZ | ETF | 8.1 | 8.24 | 7.88 | 7.92 | 245900.0 |
| 2002-08-27 | EZU | ETF | 24.1 | 24.35 | 23.825 | 24.125 | 117800.0 |
| 2002-08-27 | FCTR | ETF | 16.899 | 17.18 | 16.07 | 16.5 | 44800.0 |
| 2002-08-27 | FMAR | ETF | 10.69 | 10.74 | 10.52 | 10.52 | 4500.0 |
| 2002-08-27 | GLDB | ETF | 10.2 | 10.41 | 10.1 | 10.31 | 99200.0 |
| 2002-08-27 | GRNB | ETF | 15.7065 | 15.7065 | 15.4611 | 15.7065 | 1817.0 |
| 2002-08-27 | GSIG | ETF | 6.67 | 6.67 | 6.23 | 6.36 | 12000.0 |
| 2002-08-27 | IBB | ETF | 17.5 | 17.6367 | 16.7 | 16.7 | 2921400.0 |
| 2002-08-27 | ICF | ETF | 21.85 | 21.875 | 21.7425 | 21.825 | 71200.0 |
| 2002-08-27 | IDU | ETF | 27.85 | 27.85 | 27.075 | 27.075 | 289600.0 |
| 2002-08-27 | IEF | ETF | 83.75 | 83.93 | 83.57 | 83.74 | 38800.0 |
| 2002-08-27 | IEV | ETF | 26.28 | 26.62 | 26.055 | 26.355 | 135800.0 |
| 2002-08-27 | IGE | ETF | 14.6 | 14.6 | 14.4167 | 14.42 | 48600.0 |
| 2002-08-27 | IGM | ETF | 5.3083 | 5.3083 | 5.1583 | 5.1583 | 56400.0 |
> showing 50 of 124 rows — these rows as CSV