PREVIEW / etf_daily / 2001-11-23
file: by_date/etf_daily/2001/2001-11-23.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-23 | SPY | ETF | 114.04 | 115.75 | 114.0 | 115.68 | 6717100.0 |
| 2001-11-23 | QQQ | ETF | 38.76 | 39.43 | 38.57 | 39.28 | 27046000.0 |
| 2001-11-23 | IWM | ETF | 45.025 | 45.775 | 45.025 | 45.74 | 224600.0 |
| 2001-11-23 | DIA | ETF | 98.55 | 99.95 | 98.45 | 99.9 | 873900.0 |
| 2001-11-23 | ARB | ETF | 29.76 | 30.0 | 29.57 | 30.0 | 67800.0 |
| 2001-11-23 | BBH | ETF | 44.7333 | 45.4967 | 44.6067 | 45.4967 | 816300.0 |
| 2001-11-23 | BITS | ETF | 19.7584 | 20.12 | 19.7584 | 19.96 | 9250.0 |
| 2001-11-23 | BOSS | ETF | 21.5 | 21.5 | 21.0 | 21.3 | 200.0 |
| 2001-11-23 | CEF | ETF | 3.24 | 3.24 | 3.24 | 3.24 | 2800.0 |
| 2001-11-23 | CHB | ETF | 11.0 | 11.4 | 11.0 | 11.33 | 35900.0 |
| 2001-11-23 | CNXT | ETF | 12.77 | 14.0 | 12.77 | 13.93 | 2232580.0 |
| 2001-11-23 | DGT | ETF | 67.03 | 67.03 | 67.03 | 67.03 | 100.0 |
| 2001-11-23 | EFA | ETF | 39.8 | 39.94 | 39.8 | 39.94 | 228300.0 |
| 2001-11-23 | ELV | ETF | 24.475 | 24.675 | 24.475 | 24.59 | 143900.0 |
| 2001-11-23 | EWA | ETF | 9.35 | 9.35 | 9.34 | 9.34 | 7300.0 |
| 2001-11-23 | EWC | ETF | 10.5 | 10.6 | 10.5 | 10.6 | 1100.0 |
| 2001-11-23 | EWD | ETF | 13.49 | 13.49 | 13.31 | 13.31 | 1200.0 |
| 2001-11-23 | EWG | ETF | 14.44 | 14.57 | 14.44 | 14.5 | 16100.0 |
| 2001-11-23 | EWH | ETF | 9.05 | 9.07 | 8.87 | 9.0 | 34200.0 |
| 2001-11-23 | EWI | ETF | 31.94 | 32.34 | 31.94 | 32.34 | 5350.0 |
| 2001-11-23 | EWJ | ETF | 33.68 | 33.92 | 33.6 | 33.92 | 57100.0 |
| 2001-11-23 | EWK | ETF | 10.59 | 10.59 | 10.59 | 10.59 | 1100.0 |
| 2001-11-23 | EWL | ETF | 12.8 | 12.8 | 12.71 | 12.74 | 1000.0 |
| 2001-11-23 | EWM | ETF | 19.16 | 19.16 | 18.8 | 18.8 | 9625.0 |
| 2001-11-23 | EWN | ETF | 16.95 | 17.14 | 16.95 | 17.14 | 1200.0 |
| 2001-11-23 | EWO | ETF | 6.95 | 7.08 | 6.95 | 7.08 | 11800.0 |
| 2001-11-23 | EWP | ETF | 20.71 | 20.88 | 20.71 | 20.88 | 1400.0 |
| 2001-11-23 | EWQ | ETF | 18.08 | 18.22 | 18.08 | 18.21 | 800.0 |
| 2001-11-23 | EWS | ETF | 9.18 | 9.2 | 9.1 | 9.2 | 22150.0 |
| 2001-11-23 | EWT | ETF | 18.4 | 18.48 | 18.0 | 18.02 | 5650.0 |
| 2001-11-23 | EWU | ETF | 29.24 | 29.28 | 29.02 | 29.04 | 1950.0 |
| 2001-11-23 | EWW | ETF | 13.67 | 13.75 | 13.53 | 13.56 | 7000.0 |
| 2001-11-23 | EWY | ETF | 16.0 | 16.59 | 16.0 | 16.37 | 11000.0 |
| 2001-11-23 | EWZ | ETF | 11.3 | 11.49 | 11.3 | 11.49 | 1600.0 |
| 2001-11-23 | EZU | ETF | 27.075 | 27.3 | 27.075 | 27.3 | 2200.0 |
| 2001-11-23 | FCTR | ETF | 17.43 | 17.8 | 17.4 | 17.8 | 5700.0 |
| 2001-11-23 | FMAR | ETF | 8.1 | 8.1 | 8.0 | 8.05 | 3200.0 |
| 2001-11-23 | GLDB | ETF | 7.4113 | 7.54 | 7.4 | 7.5 | 10100.0 |
| 2001-11-23 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 1009.0 |
| 2001-11-23 | GSIG | ETF | 8.4 | 8.46 | 8.06 | 8.31 | 36600.0 |
| 2001-11-23 | IBB | ETF | 30.6167 | 31.1333 | 30.54 | 31.0067 | 185700.0 |
| 2001-11-23 | ICF | ETF | 20.9875 | 21.035 | 20.9875 | 21.035 | 14400.0 |
| 2001-11-23 | IDU | ETF | 31.7 | 32.095 | 31.615 | 31.99 | 4200.0 |
| 2001-11-23 | IEV | ETF | 29.1 | 29.36 | 29.01 | 29.36 | 21400.0 |
| 2001-11-23 | IGLD | ETF | 93.0 | 93.0 | 83.0 | 89.0 | 352.0 |
| 2001-11-23 | IGM | ETF | 8.3883 | 8.4817 | 8.3883 | 8.4817 | 15600.0 |
| 2001-11-23 | IGN | ETF | 33.85 | 34.6 | 33.85 | 34.6 | 104100.0 |
| 2001-11-23 | IGV | ETF | 8.43 | 8.514 | 8.43 | 8.514 | 10500.0 |
| 2001-11-23 | IJH | ETF | 9.575 | 9.684 | 9.557 | 9.684 | 94000.0 |
| 2001-11-23 | IJJ | ETF | 21.2 | 21.4825 | 21.2 | 21.445 | 659600.0 |
> showing 50 of 109 rows — these rows as CSV