PREVIEW / etf_daily / 2001-11-06
file: by_date/etf_daily/2001/2001-11-06.parquet size: 9 KB rows: 109
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-11-06 | SPY | ETF | 110.35 | 112.48 | 109.85 | 112.4 | 23245800.0 |
| 2001-11-06 | QQQ | ETF | 36.609 | 38.2 | 36.39 | 38.19 | 107214900.0 |
| 2001-11-06 | IWM | ETF | 43.375 | 44.25 | 43.25 | 44.25 | 1671200.0 |
| 2001-11-06 | DIA | ETF | 94.25 | 96.15 | 93.85 | 96.15 | 3113200.0 |
| 2001-11-06 | ARB | ETF | 28.34 | 28.43 | 27.75 | 27.99 | 49200.0 |
| 2001-11-06 | BBH | ETF | 43.6667 | 44.7133 | 43.2333 | 44.5167 | 3507000.0 |
| 2001-11-06 | BITS | ETF | 15.998 | 16.6 | 15.8 | 16.56 | 9800.0 |
| 2001-11-06 | CEF | ETF | 3.45 | 3.45 | 3.31 | 3.34 | 38200.0 |
| 2001-11-06 | CHB | ETF | 9.61 | 9.8 | 9.5 | 9.8 | 104100.0 |
| 2001-11-06 | CNXT | ETF | 12.02 | 13.03 | 11.85 | 12.91 | 5130770.0 |
| 2001-11-06 | CSB | ETF | 3.90000009536743 | 4.0 | 3.90000009536743 | 4.0 | 2500.0 |
| 2001-11-06 | EFA | ETF | 39.5 | 39.95 | 39.3667 | 39.8767 | 651300.0 |
| 2001-11-06 | ELV | ETF | 21.475 | 22.15 | 21.075 | 22.025 | 1624100.0 |
| 2001-11-06 | EPP | ETF | 16.9167 | 16.9167 | 16.9167 | 16.9167 | 300.0 |
| 2001-11-06 | EWA | ETF | 9.05 | 9.15 | 9.04 | 9.05 | 10900.0 |
| 2001-11-06 | EWC | ETF | 9.89 | 10.1 | 9.89 | 10.1 | 11000.0 |
| 2001-11-06 | EWD | ETF | 12.21 | 12.21 | 12.21 | 12.21 | 200.0 |
| 2001-11-06 | EWG | ETF | 13.71 | 13.85 | 13.65 | 13.82 | 190800.0 |
| 2001-11-06 | EWH | ETF | 8.17 | 8.18 | 8.05 | 8.18 | 44200.0 |
| 2001-11-06 | EWI | ETF | 31.4 | 31.4 | 31.1 | 31.1 | 2400.0 |
| 2001-11-06 | EWJ | ETF | 34.12 | 34.68 | 34.0 | 34.68 | 66150.0 |
| 2001-11-06 | EWL | ETF | 12.3 | 12.49 | 12.3 | 12.49 | 4500.0 |
| 2001-11-06 | EWM | ETF | 17.12 | 17.52 | 17.12 | 17.2 | 800.0 |
| 2001-11-06 | EWN | ETF | 16.61 | 16.61 | 16.61 | 16.61 | 200.0 |
| 2001-11-06 | EWP | ETF | 20.0 | 20.14 | 19.96 | 20.14 | 1500.0 |
| 2001-11-06 | EWQ | ETF | 18.17 | 18.33 | 18.04 | 18.28 | 72300.0 |
| 2001-11-06 | EWS | ETF | 8.58 | 8.6 | 8.46 | 8.58 | 23300.0 |
| 2001-11-06 | EWT | ETF | 16.4 | 16.48 | 16.02 | 16.48 | 6200.0 |
| 2001-11-06 | EWU | ETF | 29.48 | 29.94 | 29.42 | 29.94 | 37400.0 |
| 2001-11-06 | EWW | ETF | 13.45 | 13.7 | 13.45 | 13.7 | 5100.0 |
| 2001-11-06 | EWY | ETF | 13.66 | 13.7 | 13.66 | 13.7 | 15200.0 |
| 2001-11-06 | EWZ | ETF | 10.58 | 10.61 | 10.51 | 10.61 | 10300.0 |
| 2001-11-06 | EZU | ETF | 26.5 | 26.625 | 26.355 | 26.625 | 133400.0 |
| 2001-11-06 | FCTR | ETF | 16.99 | 18.0 | 16.99 | 18.0 | 24600.0 |
| 2001-11-06 | FMAR | ETF | 8.1 | 8.1 | 8.05 | 8.05 | 8700.0 |
| 2001-11-06 | GLDB | ETF | 7.35 | 7.59 | 7.25 | 7.58 | 61400.0 |
| 2001-11-06 | GSIG | ETF | 7.89 | 8.29 | 7.85 | 8.23 | 147900.0 |
| 2001-11-06 | IBB | ETF | 29.5 | 29.9333 | 29.15 | 29.8333 | 82200.0 |
| 2001-11-06 | ICF | ETF | 20.075 | 20.35 | 20.055 | 20.275 | 140800.0 |
| 2001-11-06 | IDU | ETF | 32.475 | 32.475 | 32.235 | 32.325 | 3200.0 |
| 2001-11-06 | IEV | ETF | 28.7 | 29.175 | 28.7 | 29.05 | 133200.0 |
| 2001-11-06 | IGLD | ETF | 75.0 | 75.0 | 73.0 | 75.0 | 102.0 |
| 2001-11-06 | IGM | ETF | 7.8667 | 8.1583 | 7.8667 | 8.1267 | 61800.0 |
| 2001-11-06 | IGN | ETF | 30.15 | 30.44 | 30.15 | 30.2 | 2500.0 |
| 2001-11-06 | IGV | ETF | 7.85 | 8.2 | 7.85 | 8.2 | 3000.0 |
| 2001-11-06 | IJH | ETF | 9.29 | 9.431 | 9.26 | 9.431 | 338000.0 |
| 2001-11-06 | IJJ | ETF | 20.6625 | 20.8775 | 20.59 | 20.8775 | 75200.0 |
| 2001-11-06 | IJK | ETF | 13.015 | 13.16 | 12.9688 | 13.16 | 120000.0 |
| 2001-11-06 | IJR | ETF | 17.1083 | 17.3383 | 17.1083 | 17.3383 | 204000.0 |
| 2001-11-06 | IJS | ETF | 18.85 | 19.1425 | 18.8375 | 19.1425 | 251600.0 |
> showing 50 of 109 rows — these rows as CSV