PREVIEW / etf_daily / 2001-09-26
file: by_date/etf_daily/2001/2001-09-26.parquet size: 9 KB rows: 105
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-09-26 | SPY | ETF | 102.35 | 102.4 | 100.43 | 101.39 | 18587500.0 |
| 2001-09-26 | QQQ | ETF | 29.95 | 30.0 | 28.41 | 28.67 | 59759800.0 |
| 2001-09-26 | IWM | ETF | 39.6 | 39.8 | 38.675 | 38.89 | 990600.0 |
| 2001-09-26 | DIA | ETF | 87.39 | 87.5 | 85.3 | 86.05 | 3981600.0 |
| 2001-09-26 | BBH | ETF | 35.4 | 35.75 | 35.0933 | 35.2667 | 5844600.0 |
| 2001-09-26 | BITS | ETF | 11.32 | 11.32 | 9.84 | 10.08 | 6200.0 |
| 2001-09-26 | CEF | ETF | 3.59 | 3.59 | 3.46 | 3.55 | 55300.0 |
| 2001-09-26 | CHB | ETF | 7.0 | 7.0 | 6.52 | 6.52 | 259100.0 |
| 2001-09-26 | CNXT | ETF | 9.35 | 9.47 | 8.06 | 8.19 | 3208400.0 |
| 2001-09-26 | CSB | ETF | 2.70000004768372 | 3.0 | 2.70000004768372 | 3.0 | 4200.0 |
| 2001-09-26 | EFA | ETF | 36.4833 | 36.4833 | 36.2333 | 36.35 | 138600.0 |
| 2001-09-26 | EWA | ETF | 7.75 | 7.95 | 7.72 | 7.75 | 3800.0 |
| 2001-09-26 | EWC | ETF | 9.75 | 9.75 | 9.4 | 9.4 | 7300.0 |
| 2001-09-26 | EWD | ETF | 10.75 | 10.75 | 10.35 | 10.4 | 600.0 |
| 2001-09-26 | EWG | ETF | 12.25 | 12.3 | 11.95 | 11.95 | 39900.0 |
| 2001-09-26 | EWH | ETF | 7.58 | 7.59 | 7.15 | 7.44 | 64700.0 |
| 2001-09-26 | EWI | ETF | 28.7 | 29.0 | 28.5 | 28.5 | 5450.0 |
| 2001-09-26 | EWJ | ETF | 33.36 | 33.36 | 32.52 | 32.92 | 302875.0 |
| 2001-09-26 | EWL | ETF | 11.85 | 11.85 | 11.7 | 11.76 | 3400.0 |
| 2001-09-26 | EWM | ETF | 17.0 | 17.24 | 17.0 | 17.2 | 7650.0 |
| 2001-09-26 | EWN | ETF | 15.8 | 15.8 | 15.6 | 15.7 | 2000.0 |
| 2001-09-26 | EWO | ETF | 7.15 | 7.3 | 7.15 | 7.2 | 14600.0 |
| 2001-09-26 | EWP | ETF | 17.8 | 18.1 | 17.75 | 17.75 | 6600.0 |
| 2001-09-26 | EWQ | ETF | 16.65 | 16.85 | 16.52 | 16.85 | 61800.0 |
| 2001-09-26 | EWS | ETF | 8.14 | 8.38 | 7.86 | 8.3 | 8500.0 |
| 2001-09-26 | EWT | ETF | 14.14 | 14.16 | 13.76 | 14.16 | 30250.0 |
| 2001-09-26 | EWU | ETF | 26.4 | 27.28 | 26.2 | 26.92 | 31750.0 |
| 2001-09-26 | EWW | ETF | 12.15 | 12.4 | 12.15 | 12.24 | 16600.0 |
| 2001-09-26 | EWY | ETF | 11.0 | 11.0 | 10.91 | 10.96 | 3900.0 |
| 2001-09-26 | EWZ | ETF | 9.0 | 9.0 | 8.4 | 8.4 | 9600.0 |
| 2001-09-26 | EZU | ETF | 24.3 | 24.3 | 23.95 | 24.02 | 10600.0 |
| 2001-09-26 | FCTR | ETF | 16.8 | 17.06 | 16.35 | 16.35 | 58400.0 |
| 2001-09-26 | FMAR | ETF | 7.593 | 7.597 | 6.9977 | 7.597 | 6700.0 |
| 2001-09-26 | GLDB | ETF | 7.3 | 7.45 | 7.2 | 7.44 | 55800.0 |
| 2001-09-26 | GSIG | ETF | 6.72 | 6.95 | 6.69 | 6.75 | 271800.0 |
| 2001-09-26 | IBB | ETF | 23.45 | 23.7167 | 23.2833 | 23.3333 | 200100.0 |
| 2001-09-26 | ICF | ETF | 20.3125 | 20.6875 | 20.3125 | 20.6375 | 99600.0 |
| 2001-09-26 | IDU | ETF | 32.85 | 32.85 | 32.205 | 32.31 | 50800.0 |
| 2001-09-26 | IEV | ETF | 26.575 | 26.975 | 26.275 | 26.325 | 57800.0 |
| 2001-09-26 | IGLD | ETF | 62.0 | 74.0 | 62.0 | 72.0 | 233.0 |
| 2001-09-26 | IGM | ETF | 6.2917 | 6.2917 | 6.2833 | 6.2917 | 9600.0 |
| 2001-09-26 | IGN | ETF | 25.6 | 25.6 | 24.15 | 24.15 | 7300.0 |
| 2001-09-26 | IGV | ETF | 5.85 | 5.93 | 5.85 | 5.9 | 13000.0 |
| 2001-09-26 | IJH | ETF | 8.44 | 8.44 | 8.265 | 8.32 | 327000.0 |
| 2001-09-26 | IJJ | ETF | 19.2625 | 19.35 | 19.0 | 19.0625 | 49200.0 |
| 2001-09-26 | IJK | ETF | 11.3875 | 11.3875 | 11.1375 | 11.1562 | 71200.0 |
| 2001-09-26 | IJR | ETF | 15.75 | 15.75 | 15.3717 | 15.4133 | 405600.0 |
| 2001-09-26 | IJS | ETF | 17.4375 | 17.4875 | 17.1125 | 17.2375 | 106400.0 |
| 2001-09-26 | IJT | ETF | 15.875 | 15.875 | 15.5325 | 15.6125 | 64400.0 |
| 2001-09-26 | IOO | ETF | 26.1 | 26.1 | 25.815 | 25.875 | 94800.0 |
> showing 50 of 105 rows — these rows as CSV