PREVIEW / etf_daily / 2002-08-23
file: by_date/etf_daily/2002/2002-08-23.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-23 | SPY | ETF | 96.01 | 96.15 | 94.15 | 94.6 | 33716400.0 |
| 2002-08-23 | QQQ | ETF | 25.802 | 25.81 | 24.95 | 25.15 | 75248000.0 |
| 2002-08-23 | IWM | ETF | 40.6 | 40.85 | 39.825 | 39.825 | 3484600.0 |
| 2002-08-23 | DIA | ETF | 89.89 | 91.0 | 88.4 | 88.72 | 8041900.0 |
| 2002-08-23 | TLT | ETF | 85.2 | 85.95 | 85.2 | 85.9 | 20100.0 |
| 2002-08-23 | ARB | ETF | 34.0 | 34.3 | 33.51 | 33.64 | 127300.0 |
| 2002-08-23 | BBH | ETF | 30.2333 | 30.6633 | 29.71 | 29.7833 | 4070700.0 |
| 2002-08-23 | BITS | ETF | 9.96 | 10.56 | 9.8 | 10.56 | 3350.0 |
| 2002-08-23 | CEF | ETF | 4.0 | 4.1 | 4.0 | 4.08 | 65700.0 |
| 2002-08-23 | CHB | ETF | 3.0 | 3.04 | 2.73 | 2.82 | 128200.0 |
| 2002-08-23 | CNXT | ETF | 1.63 | 1.64 | 1.5 | 1.52 | 5364200.0 |
| 2002-08-23 | CSB | ETF | 6.0 | 6.34999990463257 | 6.0 | 6.34999990463257 | 36000.0 |
| 2002-08-23 | DGT | ETF | 54.2 | 54.2 | 54.2 | 54.2 | 100.0 |
| 2002-08-23 | EFA | ETF | 36.3933 | 36.5267 | 36.18 | 36.2833 | 1091100.0 |
| 2002-08-23 | ELV | ETF | 32.34 | 32.65 | 31.9 | 32.25 | 845000.0 |
| 2002-08-23 | EPP | ETF | 17.9467 | 17.95 | 17.7367 | 17.7367 | 32700.0 |
| 2002-08-23 | EWA | ETF | 9.45 | 9.47 | 9.23 | 9.23 | 11500.0 |
| 2002-08-23 | EWC | ETF | 9.72 | 9.83 | 9.63 | 9.64 | 30000.0 |
| 2002-08-23 | EWD | ETF | 9.91 | 10.09 | 9.85 | 9.85 | 58300.0 |
| 2002-08-23 | EWG | ETF | 12.44 | 12.44 | 12.21 | 12.23 | 9800.0 |
| 2002-08-23 | EWH | ETF | 8.2 | 8.2 | 8.0 | 8.12 | 179900.0 |
| 2002-08-23 | EWI | ETF | 30.82 | 30.82 | 30.6 | 30.6 | 1350.0 |
| 2002-08-23 | EWJ | ETF | 31.32 | 31.48 | 31.2 | 31.28 | 84500.0 |
| 2002-08-23 | EWL | ETF | 11.91 | 12.26 | 11.91 | 11.96 | 5900.0 |
| 2002-08-23 | EWM | ETF | 23.32 | 23.32 | 22.96 | 23.32 | 3925.0 |
| 2002-08-23 | EWN | ETF | 15.17 | 15.2 | 14.96 | 14.96 | 10400.0 |
| 2002-08-23 | EWO | ETF | 8.0 | 8.0 | 8.0 | 8.0 | 100.0 |
| 2002-08-23 | EWP | ETF | 18.12 | 18.15 | 17.96 | 17.96 | 7400.0 |
| 2002-08-23 | EWQ | ETF | 16.21 | 16.21 | 15.85 | 15.85 | 37900.0 |
| 2002-08-23 | EWS | ETF | 10.2 | 10.4 | 10.1 | 10.12 | 9650.0 |
| 2002-08-23 | EWT | ETF | 18.56 | 18.56 | 18.02 | 18.44 | 60650.0 |
| 2002-08-23 | EWU | ETF | 26.88 | 26.88 | 26.24 | 26.26 | 24250.0 |
| 2002-08-23 | EWW | ETF | 13.62 | 13.84 | 13.62 | 13.63 | 6100.0 |
| 2002-08-23 | EWY | ETF | 21.5 | 21.5 | 21.06 | 21.06 | 17400.0 |
| 2002-08-23 | EWZ | ETF | 7.65 | 7.8 | 7.56 | 7.72 | 237000.0 |
| 2002-08-23 | EZU | ETF | 23.775 | 23.95 | 23.58 | 23.615 | 17400.0 |
| 2002-08-23 | FCTR | ETF | 16.71 | 16.749 | 16.13 | 16.14 | 18800.0 |
| 2002-08-23 | FMAR | ETF | 10.67 | 10.7 | 10.48 | 10.68 | 5000.0 |
| 2002-08-23 | GLDB | ETF | 10.85 | 10.851 | 9.53 | 9.85 | 249600.0 |
| 2002-08-23 | GRNB | ETF | 16.6882 | 16.6882 | 15.2157 | 16.6882 | 202.0 |
| 2002-08-23 | GSIG | ETF | 6.6 | 6.84 | 6.38 | 6.38 | 40200.0 |
| 2002-08-23 | IBB | ETF | 18.0067 | 18.1333 | 17.5333 | 17.5333 | 1566600.0 |
| 2002-08-23 | ICF | ETF | 21.525 | 21.65 | 21.5125 | 21.5925 | 163200.0 |
| 2002-08-23 | IDU | ETF | 27.475 | 27.55 | 27.01 | 27.125 | 66800.0 |
| 2002-08-23 | IEF | ETF | 83.72 | 84.0 | 83.66 | 83.95 | 26500.0 |
| 2002-08-23 | IEV | ETF | 26.15 | 26.25 | 25.77 | 25.78 | 135000.0 |
| 2002-08-23 | IGE | ETF | 14.3833 | 14.3833 | 14.26 | 14.2883 | 92400.0 |
| 2002-08-23 | IGLD | ETF | 107.9 | 107.9 | 103.1 | 105.0 | 67.0 |
| 2002-08-23 | IGM | ETF | 5.4167 | 5.425 | 5.3017 | 5.315 | 38400.0 |
| 2002-08-23 | IGN | ETF | 14.0 | 14.0 | 13.55 | 13.84 | 5200.0 |
> showing 50 of 124 rows — these rows as CSV