PREVIEW / etf_daily / 2001-08-24
file: by_date/etf_daily/2001/2001-08-24.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-24 | SPY | ETF | 117.21 | 119.13 | 116.74 | 119.02 | 11687700.0 |
| 2001-08-24 | QQQ | ETF | 37.86 | 39.39 | 37.75 | 39.3 | 58450700.0 |
| 2001-08-24 | IWM | ETF | 47.5 | 48.05 | 47.425 | 48.05 | 2401000.0 |
| 2001-08-24 | DIA | ETF | 102.75 | 104.97 | 102.38 | 104.63 | 2789300.0 |
| 2001-08-24 | BBH | ETF | 41.6633 | 42.3133 | 41.3367 | 42.19 | 5216400.0 |
| 2001-08-24 | BITS | ETF | 16.6 | 16.6 | 16.04 | 16.04 | 3150.0 |
| 2001-08-24 | CEF | ETF | 3.17 | 3.24 | 3.11 | 3.13 | 23500.0 |
| 2001-08-24 | CHB | ETF | 9.2 | 10.2 | 9.2 | 10.2 | 86600.0 |
| 2001-08-24 | CNXT | ETF | 11.2 | 12.04 | 11.16 | 11.61 | 4549500.0 |
| 2001-08-24 | CSB | ETF | 3.16000008583069 | 3.29999995231628 | 3.16000008583069 | 3.20000004768372 | 46700.0 |
| 2001-08-24 | DGT | ETF | 67.75 | 67.9 | 67.65 | 67.65 | 2800.0 |
| 2001-08-24 | EWA | ETF | 9.51 | 9.65 | 9.51 | 9.53 | 18900.0 |
| 2001-08-24 | EWC | ETF | 10.9 | 11.05 | 10.9 | 11.01 | 5500.0 |
| 2001-08-24 | EWD | ETF | 13.8 | 14.06 | 13.8 | 13.91 | 1800.0 |
| 2001-08-24 | EWG | ETF | 15.79 | 15.94 | 15.68 | 15.82 | 7700.0 |
| 2001-08-24 | EWH | ETF | 9.05 | 9.18 | 9.02 | 9.18 | 15300.0 |
| 2001-08-24 | EWI | ETF | 36.5 | 36.8 | 36.42 | 36.44 | 500.0 |
| 2001-08-24 | EWJ | ETF | 37.84 | 38.12 | 37.64 | 38.0 | 101075.0 |
| 2001-08-24 | EWK | ETF | 11.85 | 11.85 | 11.71 | 11.71 | 1800.0 |
| 2001-08-24 | EWL | ETF | 13.2 | 13.42 | 13.15 | 13.18 | 3300.0 |
| 2001-08-24 | EWM | ETF | 19.4 | 19.72 | 19.4 | 19.44 | 3000.0 |
| 2001-08-24 | EWN | ETF | 19.31 | 19.35 | 19.16 | 19.21 | 2900.0 |
| 2001-08-24 | EWO | ETF | 8.2 | 8.2 | 8.2 | 8.2 | 100.0 |
| 2001-08-24 | EWP | ETF | 22.06 | 22.17 | 22.01 | 22.05 | 1900.0 |
| 2001-08-24 | EWQ | ETF | 20.39 | 20.39 | 20.32 | 20.37 | 2700.0 |
| 2001-08-24 | EWS | ETF | 10.56 | 10.72 | 10.56 | 10.66 | 7100.0 |
| 2001-08-24 | EWT | ETF | 18.0 | 18.0 | 17.5 | 17.6 | 9850.0 |
| 2001-08-24 | EWU | ETF | 30.9 | 31.02 | 30.7 | 30.7 | 16250.0 |
| 2001-08-24 | EWW | ETF | 15.5 | 15.75 | 15.5 | 15.75 | 52700.0 |
| 2001-08-24 | EWY | ETF | 13.85 | 13.89 | 13.85 | 13.89 | 1100.0 |
| 2001-08-24 | EWZ | ETF | 11.3 | 11.63 | 11.22 | 11.63 | 22300.0 |
| 2001-08-24 | EZU | ETF | 29.55 | 29.7 | 29.505 | 29.65 | 24800.0 |
| 2001-08-24 | FCTR | ETF | 18.3 | 18.37 | 18.0 | 18.25 | 26300.0 |
| 2001-08-24 | FMAR | ETF | 9.1 | 9.46 | 9.1 | 9.4 | 3500.0 |
| 2001-08-24 | GLDB | ETF | 7.65 | 7.85 | 7.56 | 7.8 | 75700.0 |
| 2001-08-24 | GRNB | ETF | 18.6514 | 18.6514 | 18.6514 | 18.6514 | 2725.0 |
| 2001-08-24 | GSIG | ETF | 8.39 | 8.59 | 8.35 | 8.46 | 41400.0 |
| 2001-08-24 | IBB | ETF | 29.21 | 30.08 | 29.1667 | 30.0 | 548100.0 |
| 2001-08-24 | ICF | ETF | 22.4875 | 22.4875 | 22.195 | 22.26 | 214400.0 |
| 2001-08-24 | IDU | ETF | 36.6 | 36.93 | 36.6 | 36.755 | 4600.0 |
| 2001-08-24 | IEV | ETF | 31.25 | 31.345 | 31.11 | 31.31 | 9600.0 |
| 2001-08-24 | IGLD | ETF | 60.0 | 70.0 | 60.0 | 67.0 | 133.0 |
| 2001-08-24 | IGM | ETF | 8.2583 | 8.3583 | 8.2583 | 8.3583 | 15000.0 |
| 2001-08-24 | IJH | ETF | 10.02 | 10.083 | 10.02 | 10.063 | 164000.0 |
| 2001-08-24 | IJJ | ETF | 22.7 | 22.785 | 22.6375 | 22.7375 | 190800.0 |
| 2001-08-24 | IJK | ETF | 13.6812 | 13.8638 | 13.6812 | 13.8638 | 27200.0 |
| 2001-08-24 | IJR | ETF | 18.675 | 18.8567 | 18.5933 | 18.8533 | 757800.0 |
| 2001-08-24 | IJS | ETF | 21.0725 | 21.2325 | 21.055 | 21.2325 | 136800.0 |
| 2001-08-24 | IJT | ETF | 18.66 | 18.77 | 18.66 | 18.7675 | 23600.0 |
| 2001-08-24 | IOO | ETF | 29.615 | 30.09 | 29.615 | 30.045 | 22200.0 |
> showing 50 of 104 rows — these rows as CSV