PREVIEW / etf_daily / 2001-10-29
file: by_date/etf_daily/2001/2001-10-29.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-29 | SPY | ETF | 110.16 | 110.55 | 107.45 | 107.45 | 18727500.0 |
| 2001-10-29 | QQQ | ETF | 36.0 | 36.158 | 34.04 | 34.04 | 92146800.0 |
| 2001-10-29 | IWM | ETF | 43.505 | 43.51 | 42.7 | 42.75 | 516400.0 |
| 2001-10-29 | DIA | ETF | 95.05 | 95.51 | 92.05 | 93.06 | 3040800.0 |
| 2001-10-29 | ARB | ETF | 27.1 | 27.11 | 26.8 | 26.95 | 46300.0 |
| 2001-10-29 | BBH | ETF | 44.03 | 44.03 | 42.4667 | 42.4667 | 3274200.0 |
| 2001-10-29 | BITS | ETF | 17.56 | 17.6 | 15.8 | 16.2 | 9450.0 |
| 2001-10-29 | CEF | ETF | 3.41 | 3.47 | 3.39 | 3.47 | 14700.0 |
| 2001-10-29 | CHB | ETF | 7.75 | 8.11 | 7.75 | 8.01 | 125000.0 |
| 2001-10-29 | CNXT | ETF | 11.65 | 11.85 | 10.61 | 10.68 | 2806140.0 |
| 2001-10-29 | DGT | ETF | 65.3 | 65.3 | 65.3 | 65.3 | 400.0 |
| 2001-10-29 | EFA | ETF | 39.3333 | 39.3633 | 38.6033 | 38.6033 | 595500.0 |
| 2001-10-29 | EPP | ETF | 16.6167 | 16.6167 | 16.6167 | 16.6167 | 6000.0 |
| 2001-10-29 | EWA | ETF | 8.8 | 8.8 | 8.8 | 8.8 | 1100.0 |
| 2001-10-29 | EWC | ETF | 9.85 | 9.99 | 9.85 | 9.98 | 800.0 |
| 2001-10-29 | EWD | ETF | 12.35 | 12.35 | 11.91 | 12.0 | 8100.0 |
| 2001-10-29 | EWG | ETF | 13.73 | 13.73 | 13.44 | 13.45 | 42500.0 |
| 2001-10-29 | EWH | ETF | 8.0 | 8.03 | 7.81 | 7.81 | 15200.0 |
| 2001-10-29 | EWI | ETF | 32.4 | 32.4 | 32.0 | 32.2 | 6550.0 |
| 2001-10-29 | EWJ | ETF | 34.44 | 34.48 | 34.04 | 34.12 | 108650.0 |
| 2001-10-29 | EWK | ETF | 10.5 | 10.5 | 10.5 | 10.5 | 600.0 |
| 2001-10-29 | EWL | ETF | 12.35 | 12.39 | 12.15 | 12.34 | 2900.0 |
| 2001-10-29 | EWM | ETF | 17.6 | 17.96 | 17.6 | 17.6 | 4275.0 |
| 2001-10-29 | EWN | ETF | 16.5 | 16.5 | 16.5 | 16.5 | 100.0 |
| 2001-10-29 | EWO | ETF | 6.79 | 6.79 | 6.79 | 6.79 | 400.0 |
| 2001-10-29 | EWP | ETF | 19.7 | 19.7 | 19.55 | 19.55 | 800.0 |
| 2001-10-29 | EWQ | ETF | 18.07 | 18.07 | 17.85 | 17.85 | 31300.0 |
| 2001-10-29 | EWS | ETF | 8.94 | 8.98 | 8.72 | 8.74 | 27250.0 |
| 2001-10-29 | EWT | ETF | 15.8 | 16.18 | 15.72 | 16.14 | 2250.0 |
| 2001-10-29 | EWU | ETF | 28.86 | 28.86 | 28.48 | 28.48 | 8950.0 |
| 2001-10-29 | EWW | ETF | 13.55 | 13.55 | 13.2 | 13.2 | 2700.0 |
| 2001-10-29 | EWY | ETF | 13.33 | 13.33 | 13.1 | 13.1 | 10900.0 |
| 2001-10-29 | EWZ | ETF | 9.9 | 9.9 | 9.51 | 9.51 | 356900.0 |
| 2001-10-29 | EZU | ETF | 26.45 | 26.6 | 26.22 | 26.22 | 34400.0 |
| 2001-10-29 | FCTR | ETF | 17.23 | 17.23 | 16.5 | 16.55 | 12600.0 |
| 2001-10-29 | FMAR | ETF | 7.9 | 8.0 | 7.9 | 7.9 | 9800.0 |
| 2001-10-29 | GLDB | ETF | 7.5 | 7.6 | 7.5 | 7.5 | 41300.0 |
| 2001-10-29 | GSIG | ETF | 7.74 | 7.83 | 7.72 | 7.76 | 20400.0 |
| 2001-10-29 | IBB | ETF | 30.1667 | 30.1667 | 29.05 | 29.05 | 1879500.0 |
| 2001-10-29 | ICF | ETF | 19.625 | 19.7125 | 19.5 | 19.705 | 170400.0 |
| 2001-10-29 | IDU | ETF | 32.55 | 32.56 | 32.37 | 32.49 | 5400.0 |
| 2001-10-29 | IEV | ETF | 28.65 | 28.65 | 28.13 | 28.13 | 51400.0 |
| 2001-10-29 | IGLD | ETF | 77.0 | 77.0 | 77.0 | 77.0 | 4.0 |
| 2001-10-29 | IGM | ETF | 7.6667 | 7.6667 | 7.4417 | 7.4417 | 28200.0 |
| 2001-10-29 | IGN | ETF | 29.9 | 29.9 | 29.3 | 29.37 | 401400.0 |
| 2001-10-29 | IGV | ETF | 7.74 | 7.75 | 7.58 | 7.58 | 3000.0 |
| 2001-10-29 | IJH | ETF | 9.305 | 9.305 | 9.132 | 9.14 | 180000.0 |
| 2001-10-29 | IJJ | ETF | 20.6 | 20.6 | 20.2725 | 20.2725 | 35200.0 |
| 2001-10-29 | IJK | ETF | 13.0212 | 13.0262 | 12.8062 | 12.8538 | 98400.0 |
| 2001-10-29 | IJR | ETF | 17.2417 | 17.2417 | 16.8133 | 16.8133 | 768000.0 |
> showing 50 of 108 rows — these rows as CSV