PREVIEW / etf_daily / 2001-11-29
file: by_date/etf_daily/2001/2001-11-29.parquet size: 9 KB rows: 111
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-29 | SPY | ETF | 113.66 | 114.92 | 113.0 | 114.87 | 16354700.0 |
| 2001-11-29 | QQQ | ETF | 39.035 | 40.0 | 36.74 | 39.95 | 83824700.0 |
| 2001-11-29 | IWM | ETF | 45.175 | 46.35 | 45.1 | 46.35 | 507000.0 |
| 2001-11-29 | DIA | ETF | 97.55 | 98.81 | 97.06 | 98.8 | 2597100.0 |
| 2001-11-29 | ARB | ETF | 29.35 | 30.7 | 29.35 | 30.7 | 101000.0 |
| 2001-11-29 | BBH | ETF | 44.6833 | 45.6633 | 44.3667 | 45.6333 | 3906600.0 |
| 2001-11-29 | BITS | ETF | 18.4 | 20.4 | 18.2 | 19.8 | 18600.0 |
| 2001-11-29 | BOSS | ETF | 20.5 | 20.8 | 20.5 | 20.8 | 100.0 |
| 2001-11-29 | CEF | ETF | 3.27 | 3.32 | 3.27 | 3.29 | 9000.0 |
| 2001-11-29 | CHB | ETF | 11.25 | 11.45 | 11.21 | 11.25 | 307400.0 |
| 2001-11-29 | CNXT | ETF | 16.32 | 16.43 | 15.11 | 15.48 | 11957990.0 |
| 2001-11-29 | CSB | ETF | 3.90000009536743 | 3.95000004768372 | 3.90000009536743 | 3.95000004768372 | 1500.0 |
| 2001-11-29 | EFA | ETF | 39.4833 | 39.5333 | 39.29 | 39.4033 | 1168500.0 |
| 2001-11-29 | ELV | ETF | 24.75 | 25.05 | 24.54 | 25.005 | 568400.0 |
| 2001-11-29 | EPP | ETF | 17.5833 | 17.5933 | 17.5833 | 17.5933 | 92700.0 |
| 2001-11-29 | EWA | ETF | 9.35 | 9.35 | 9.26 | 9.32 | 5300.0 |
| 2001-11-29 | EWC | ETF | 10.51 | 10.52 | 10.5 | 10.5 | 3100.0 |
| 2001-11-29 | EWD | ETF | 13.2 | 13.2 | 13.16 | 13.17 | 600.0 |
| 2001-11-29 | EWG | ETF | 14.25 | 14.31 | 14.16 | 14.3 | 59400.0 |
| 2001-11-29 | EWH | ETF | 8.66 | 8.84 | 8.65 | 8.67 | 25100.0 |
| 2001-11-29 | EWI | ETF | 32.1 | 32.1 | 31.82 | 31.82 | 800.0 |
| 2001-11-29 | EWJ | ETF | 33.48 | 33.6 | 33.16 | 33.36 | 81875.0 |
| 2001-11-29 | EWL | ETF | 12.5 | 12.65 | 12.41 | 12.65 | 10100.0 |
| 2001-11-29 | EWM | ETF | 19.0 | 19.08 | 18.64 | 19.0 | 4600.0 |
| 2001-11-29 | EWN | ETF | 16.52 | 16.65 | 16.52 | 16.55 | 2000.0 |
| 2001-11-29 | EWO | ETF | 7.1 | 7.1 | 7.03 | 7.03 | 21200.0 |
| 2001-11-29 | EWQ | ETF | 17.95 | 18.09 | 17.81 | 17.95 | 35000.0 |
| 2001-11-29 | EWS | ETF | 9.18 | 9.24 | 9.04 | 9.24 | 9950.0 |
| 2001-11-29 | EWT | ETF | 17.8 | 18.02 | 17.62 | 18.02 | 109350.0 |
| 2001-11-29 | EWU | ETF | 29.18 | 29.18 | 28.78 | 29.04 | 19200.0 |
| 2001-11-29 | EWW | ETF | 13.81 | 13.95 | 13.71 | 13.93 | 11600.0 |
| 2001-11-29 | EWY | ETF | 15.76 | 15.96 | 15.76 | 15.9 | 4800.0 |
| 2001-11-29 | EWZ | ETF | 11.3 | 11.35 | 11.1 | 11.11 | 49400.0 |
| 2001-11-29 | EZU | ETF | 26.725 | 26.92 | 26.715 | 26.765 | 21600.0 |
| 2001-11-29 | FCTR | ETF | 17.66 | 18.0 | 17.4 | 18.0 | 20400.0 |
| 2001-11-29 | FMAR | ETF | 8.24 | 8.24 | 8.01 | 8.01 | 11200.0 |
| 2001-11-29 | GLDB | ETF | 7.4 | 7.45 | 7.235 | 7.3 | 129300.0 |
| 2001-11-29 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 2725.0 |
| 2001-11-29 | GSIG | ETF | 7.77 | 8.12 | 7.77 | 7.97 | 65400.0 |
| 2001-11-29 | IBB | ETF | 30.6667 | 31.3 | 30.6667 | 31.3 | 567900.0 |
| 2001-11-29 | ICF | ETF | 20.96 | 21.0475 | 20.9475 | 21.0475 | 6400.0 |
| 2001-11-29 | IDU | ETF | 30.85 | 31.19 | 30.735 | 31.18 | 23800.0 |
| 2001-11-29 | IEV | ETF | 28.925 | 28.925 | 28.65 | 28.875 | 101000.0 |
| 2001-11-29 | IGLD | ETF | 73.0 | 77.0 | 72.5 | 73.0 | 189.0 |
| 2001-11-29 | IGM | ETF | 8.425 | 8.5667 | 8.385 | 8.5667 | 64200.0 |
| 2001-11-29 | IGN | ETF | 33.2 | 33.4 | 32.42 | 33.4 | 582800.0 |
| 2001-11-29 | IGV | ETF | 8.62 | 8.82 | 8.62 | 8.812 | 10500.0 |
| 2001-11-29 | IJH | ETF | 9.66 | 9.774 | 9.63 | 9.765 | 239000.0 |
| 2001-11-29 | IJJ | ETF | 21.32 | 21.575 | 21.2975 | 21.575 | 60000.0 |
| 2001-11-29 | IJK | ETF | 13.575 | 13.745 | 13.575 | 13.7425 | 107200.0 |
> showing 50 of 111 rows — these rows as CSV