PREVIEW / etf_daily / 2002-10-23
file: by_date/etf_daily/2002/2002-10-23.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-10-23 | SPY | ETF | 88.77 | 90.27 | 87.68 | 90.2 | 54905800.0 |
| 2002-10-23 | QQQ | ETF | 23.85 | 24.63 | 23.67 | 24.6 | 88344300.0 |
| 2002-10-23 | IWM | ETF | 36.0 | 36.87 | 35.8 | 36.78 | 3649800.0 |
| 2002-10-23 | DIA | ETF | 84.0 | 85.24 | 83.0 | 85.23 | 12054500.0 |
| 2002-10-23 | TLT | ETF | 84.75 | 85.2 | 84.18 | 84.33 | 127800.0 |
| 2002-10-23 | AAA | ETF | 45.5 | 45.68 | 44.35 | 45.68 | 10600.0 |
| 2002-10-23 | ARB | ETF | 33.95 | 34.49 | 33.7 | 34.25 | 172900.0 |
| 2002-10-23 | BBH | ETF | 29.3367 | 29.5267 | 28.6333 | 29.5267 | 4666500.0 |
| 2002-10-23 | BITS | ETF | 6.48 | 8.0 | 6.48 | 7.76 | 7025.0 |
| 2002-10-23 | BOSS | ETF | 9.5 | 9.5 | 9.25 | 9.25 | 600.0 |
| 2002-10-23 | CEF | ETF | 4.19 | 4.19 | 4.06 | 4.12 | 46100.0 |
| 2002-10-23 | CHB | ETF | 2.32 | 2.5 | 2.3 | 2.5 | 279600.0 |
| 2002-10-23 | CNXT | ETF | 1.0 | 1.2 | 1.0 | 1.04 | 14733810.0 |
| 2002-10-23 | CSB | ETF | 7.5 | 7.5 | 7.40000009536743 | 7.5 | 9700.0 |
| 2002-10-23 | DGT | ETF | 50.0 | 50.5 | 50.0 | 50.5 | 800.0 |
| 2002-10-23 | EFA | ETF | 32.5 | 32.7 | 32.0667 | 32.5667 | 783000.0 |
| 2002-10-23 | ELV | ETF | 35.445 | 36.15 | 35.26 | 36.07 | 642400.0 |
| 2002-10-23 | EPP | ETF | 17.2867 | 17.3733 | 17.2167 | 17.3733 | 148800.0 |
| 2002-10-23 | EWA | ETF | 9.1 | 9.27 | 9.04 | 9.17 | 33100.0 |
| 2002-10-23 | EWC | ETF | 9.14 | 9.15 | 8.9 | 8.9 | 58800.0 |
| 2002-10-23 | EWD | ETF | 8.75 | 9.05 | 8.75 | 9.05 | 61000.0 |
| 2002-10-23 | EWG | ETF | 10.05 | 10.08 | 9.68 | 10.08 | 44900.0 |
| 2002-10-23 | EWH | ETF | 7.82 | 7.82 | 7.6 | 7.64 | 8200.0 |
| 2002-10-23 | EWI | ETF | 26.9 | 27.22 | 26.86 | 26.86 | 350.0 |
| 2002-10-23 | EWJ | ETF | 27.0 | 27.4 | 26.84 | 27.4 | 104675.0 |
| 2002-10-23 | EWK | ETF | 9.4 | 9.4 | 9.4 | 9.4 | 5000.0 |
| 2002-10-23 | EWL | ETF | 10.65 | 10.75 | 10.62 | 10.69 | 2600.0 |
| 2002-10-23 | EWM | ETF | 20.92 | 21.12 | 20.92 | 20.92 | 1250.0 |
| 2002-10-23 | EWN | ETF | 13.2 | 13.3 | 13.08 | 13.3 | 87600.0 |
| 2002-10-23 | EWO | ETF | 7.55 | 7.55 | 7.55 | 7.55 | 100.0 |
| 2002-10-23 | EWP | ETF | 16.48 | 16.69 | 16.41 | 16.65 | 11200.0 |
| 2002-10-23 | EWQ | ETF | 14.03 | 14.05 | 13.76 | 14.05 | 8700.0 |
| 2002-10-23 | EWS | ETF | 9.2 | 9.42 | 9.16 | 9.42 | 201900.0 |
| 2002-10-23 | EWT | ETF | 16.72 | 17.22 | 16.72 | 17.2 | 46450.0 |
| 2002-10-23 | EWU | ETF | 24.7 | 24.94 | 24.46 | 24.7 | 16750.0 |
| 2002-10-23 | EWW | ETF | 12.9 | 13.2 | 12.9 | 13.02 | 76100.0 |
| 2002-10-23 | EWY | ETF | 18.46 | 18.64 | 18.21 | 18.49 | 130500.0 |
| 2002-10-23 | EWZ | ETF | 6.2 | 6.45 | 6.19 | 6.41 | 396700.0 |
| 2002-10-23 | EZU | ETF | 20.61 | 20.77 | 20.225 | 20.77 | 104200.0 |
| 2002-10-23 | FCTR | ETF | 16.25 | 17.0 | 16.25 | 17.0 | 22638.0 |
| 2002-10-23 | FEZ | ETF | 23.83 | 23.88 | 23.33 | 23.88 | 87200.0 |
| 2002-10-23 | FMAR | ETF | 10.56 | 10.6 | 10.56 | 10.6 | 1600.0 |
| 2002-10-23 | GLDB | ETF | 8.7 | 8.95 | 8.65 | 8.94 | 206500.0 |
| 2002-10-23 | GSIG | ETF | 4.41 | 4.55 | 4.41 | 4.55 | 12000.0 |
| 2002-10-23 | IBB | ETF | 16.7 | 16.9167 | 16.4067 | 16.9167 | 1792500.0 |
| 2002-10-23 | ICF | ETF | 19.4125 | 19.4125 | 19.115 | 19.3625 | 104800.0 |
| 2002-10-23 | IDU | ETF | 21.6 | 22.15 | 21.6 | 22.15 | 477000.0 |
| 2002-10-23 | IEF | ETF | 84.2 | 84.5 | 84.05 | 84.14 | 64300.0 |
| 2002-10-23 | IEV | ETF | 23.35 | 23.42 | 22.9 | 23.355 | 144200.0 |
| 2002-10-23 | IGE | ETF | 13.0417 | 13.2617 | 13.0 | 13.2333 | 108000.0 |
> showing 50 of 129 rows — these rows as CSV