PREVIEW / etf_daily / 2001-10-04
file: by_date/etf_daily/2001/2001-10-04.parquet size: 9 KB rows: 108
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-10-04 | SPY | ETF | 108.29 | 108.97 | 106.75 | 107.44 | 32674100.0 |
| 2001-10-04 | QQQ | ETF | 31.65 | 33.2 | 30.94 | 31.3 | 127398200.0 |
| 2001-10-04 | IWM | ETF | 41.25 | 41.97 | 41.025 | 41.51 | 2346200.0 |
| 2001-10-04 | DIA | ETF | 91.9 | 91.98 | 90.4 | 90.9 | 8186900.0 |
| 2001-10-04 | BBH | ETF | 39.1667 | 39.2467 | 37.3333 | 37.3333 | 5703600.0 |
| 2001-10-04 | BITS | ETF | 14.56 | 14.6 | 13.0496 | 14.0 | 5725.0 |
| 2001-10-04 | CEF | ETF | 3.5 | 3.55 | 3.5 | 3.5 | 27100.0 |
| 2001-10-04 | CHB | ETF | 8.96 | 8.96 | 8.45 | 8.46 | 147900.0 |
| 2001-10-04 | CNXT | ETF | 7.98 | 9.07 | 7.47 | 8.28 | 5290550.0 |
| 2001-10-04 | CSB | ETF | 3.20000004768372 | 3.5 | 3.0 | 3.5 | 95800.0 |
| 2001-10-04 | DGT | ETF | 63.6 | 63.7 | 63.35 | 63.4 | 3100.0 |
| 2001-10-04 | EFA | ETF | 38.2333 | 38.5 | 37.8667 | 38.3033 | 578400.0 |
| 2001-10-04 | EWA | ETF | 8.33 | 8.42 | 8.33 | 8.33 | 12300.0 |
| 2001-10-04 | EWC | ETF | 10.0 | 10.0 | 9.81 | 10.0 | 5900.0 |
| 2001-10-04 | EWD | ETF | 11.09 | 11.11 | 11.09 | 11.11 | 1200.0 |
| 2001-10-04 | EWG | ETF | 13.05 | 13.25 | 13.0 | 13.15 | 38500.0 |
| 2001-10-04 | EWH | ETF | 8.01 | 8.15 | 7.97 | 8.0 | 43300.0 |
| 2001-10-04 | EWI | ETF | 30.9 | 31.28 | 30.9 | 31.18 | 2700.0 |
| 2001-10-04 | EWJ | ETF | 34.6 | 34.64 | 34.2 | 34.4 | 216475.0 |
| 2001-10-04 | EWK | ETF | 10.96 | 11.02 | 10.96 | 11.02 | 2900.0 |
| 2001-10-04 | EWL | ETF | 12.06 | 12.15 | 12.0 | 12.15 | 5700.0 |
| 2001-10-04 | EWM | ETF | 18.12 | 18.16 | 18.0 | 18.0 | 6275.0 |
| 2001-10-04 | EWN | ETF | 16.2 | 16.2 | 16.16 | 16.16 | 600.0 |
| 2001-10-04 | EWO | ETF | 7.35 | 7.44 | 7.35 | 7.44 | 5100.0 |
| 2001-10-04 | EWP | ETF | 18.79 | 18.79 | 18.56 | 18.69 | 400.0 |
| 2001-10-04 | EWQ | ETF | 17.12 | 17.49 | 17.12 | 17.4 | 30700.0 |
| 2001-10-04 | EWS | ETF | 8.88 | 8.98 | 8.84 | 8.98 | 3850.0 |
| 2001-10-04 | EWT | ETF | 13.54 | 13.8 | 13.28 | 13.7 | 33650.0 |
| 2001-10-04 | EWU | ETF | 28.76 | 28.88 | 28.4 | 28.88 | 10050.0 |
| 2001-10-04 | EWW | ETF | 13.04 | 13.04 | 13.04 | 13.04 | 200.0 |
| 2001-10-04 | EWY | ETF | 11.5 | 11.75 | 11.43 | 11.73 | 15600.0 |
| 2001-10-04 | EWZ | ETF | 8.9 | 8.9 | 8.78 | 8.8 | 102900.0 |
| 2001-10-04 | EZU | ETF | 25.1 | 25.585 | 25.1 | 25.52 | 6800.0 |
| 2001-10-04 | FCTR | ETF | 16.35 | 17.2 | 16.3 | 16.93 | 21100.0 |
| 2001-10-04 | FMAR | ETF | 7.25 | 7.25 | 7.15 | 7.2 | 4300.0 |
| 2001-10-04 | GLDB | ETF | 7.55 | 7.55 | 7.35 | 7.5 | 50600.0 |
| 2001-10-04 | GRNB | ETF | 16.1974 | 16.1974 | 14.7249 | 16.1974 | 25838.0 |
| 2001-10-04 | GSIG | ETF | 6.95 | 7.25 | 6.95 | 7.14 | 79200.0 |
| 2001-10-04 | IBB | ETF | 26.6667 | 26.6667 | 25.6333 | 25.6667 | 269100.0 |
| 2001-10-04 | ICF | ETF | 20.375 | 20.585 | 20.375 | 20.41 | 142800.0 |
| 2001-10-04 | IDU | ETF | 35.07 | 35.07 | 34.76 | 34.87 | 7200.0 |
| 2001-10-04 | IEV | ETF | 27.775 | 28.045 | 27.5 | 27.625 | 79400.0 |
| 2001-10-04 | IGLD | ETF | 67.0 | 72.0 | 67.0 | 72.0 | 64.0 |
| 2001-10-04 | IGM | ETF | 6.8833 | 7.0567 | 6.8833 | 6.9283 | 32400.0 |
| 2001-10-04 | IGN | ETF | 25.5 | 26.39 | 25.05 | 25.2 | 7400.0 |
| 2001-10-04 | IGV | ETF | 6.77 | 7.078 | 6.77 | 6.89 | 155500.0 |
| 2001-10-04 | IJH | ETF | 8.898 | 8.991 | 8.825 | 8.867 | 1393000.0 |
| 2001-10-04 | IJJ | ETF | 20.325 | 20.4575 | 20.2075 | 20.2725 | 46800.0 |
| 2001-10-04 | IJK | ETF | 12.0062 | 12.25 | 11.965 | 12.05 | 80800.0 |
| 2001-10-04 | IJR | ETF | 16.4 | 16.5717 | 16.32 | 16.3633 | 222000.0 |
> showing 50 of 108 rows — these rows as CSV