PREVIEW / etf_daily / 2001-11-13
file: by_date/etf_daily/2001/2001-11-13.parquet size: 9 KB rows: 112
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-13 | SPY | ETF | 113.44 | 114.55 | 113.18 | 114.55 | 15296200.0 |
| 2001-11-13 | QQQ | ETF | 39.03 | 39.5 | 38.63 | 39.36 | 97931800.0 |
| 2001-11-13 | IWM | ETF | 44.25 | 44.675 | 44.125 | 44.675 | 442200.0 |
| 2001-11-13 | DIA | ETF | 96.79 | 97.85 | 96.61 | 97.8 | 4026000.0 |
| 2001-11-13 | ARB | ETF | 29.15 | 29.75 | 29.14 | 29.6 | 176400.0 |
| 2001-11-13 | BBH | ETF | 42.65 | 44.3167 | 42.65 | 44.2133 | 2964600.0 |
| 2001-11-13 | BITS | ETF | 17.76 | 18.12 | 17.2 | 18.0 | 11650.0 |
| 2001-11-13 | CEF | ETF | 3.38 | 3.43 | 3.31 | 3.31 | 15600.0 |
| 2001-11-13 | CHB | ETF | 9.9 | 10.7 | 9.9 | 10.7 | 146200.0 |
| 2001-11-13 | CNXT | ETF | 13.9 | 14.79 | 13.81 | 14.42 | 6713800.0 |
| 2001-11-13 | CSB | ETF | 3.90000009536743 | 3.90000009536743 | 3.90000009536743 | 3.90000009536743 | 10000.0 |
| 2001-11-13 | DGT | ETF | 66.6 | 67.33 | 66.6 | 67.33 | 500.0 |
| 2001-11-13 | EFA | ETF | 39.4333 | 39.6067 | 39.41 | 39.56 | 298800.0 |
| 2001-11-13 | ELV | ETF | 21.7 | 21.7 | 21.26 | 21.375 | 860900.0 |
| 2001-11-13 | EPP | ETF | 17.4167 | 17.4167 | 17.4 | 17.4 | 3600.0 |
| 2001-11-13 | EWA | ETF | 9.24 | 9.3 | 9.16 | 9.3 | 35800.0 |
| 2001-11-13 | EWC | ETF | 10.45 | 10.5 | 10.2 | 10.5 | 20100.0 |
| 2001-11-13 | EWD | ETF | 12.61 | 12.8 | 12.6 | 12.66 | 17100.0 |
| 2001-11-13 | EWG | ETF | 13.95 | 14.07 | 13.91 | 14.05 | 60400.0 |
| 2001-11-13 | EWH | ETF | 8.45 | 8.65 | 8.44 | 8.64 | 82400.0 |
| 2001-11-13 | EWI | ETF | 31.02 | 31.38 | 31.0 | 31.38 | 8650.0 |
| 2001-11-13 | EWJ | ETF | 32.96 | 33.24 | 32.96 | 33.2 | 74025.0 |
| 2001-11-13 | EWL | ETF | 12.49 | 12.55 | 12.33 | 12.35 | 26700.0 |
| 2001-11-13 | EWM | ETF | 17.92 | 18.0 | 17.8 | 17.88 | 4250.0 |
| 2001-11-13 | EWN | ETF | 16.61 | 17.0 | 16.6 | 16.76 | 14000.0 |
| 2001-11-13 | EWO | ETF | 6.85 | 6.85 | 6.75 | 6.75 | 36600.0 |
| 2001-11-13 | EWP | ETF | 20.21 | 20.57 | 20.21 | 20.57 | 12100.0 |
| 2001-11-13 | EWQ | ETF | 18.02 | 18.35 | 18.02 | 18.35 | 45300.0 |
| 2001-11-13 | EWS | ETF | 8.54 | 8.82 | 8.54 | 8.74 | 25800.0 |
| 2001-11-13 | EWT | ETF | 16.88 | 17.04 | 16.4 | 16.94 | 14300.0 |
| 2001-11-13 | EWU | ETF | 29.64 | 29.94 | 29.54 | 29.82 | 19000.0 |
| 2001-11-13 | EWW | ETF | 13.5 | 13.59 | 13.34 | 13.58 | 20600.0 |
| 2001-11-13 | EWY | ETF | 14.75 | 15.16 | 14.75 | 15.03 | 54100.0 |
| 2001-11-13 | EWZ | ETF | 11.25 | 11.34 | 11.25 | 11.34 | 7600.0 |
| 2001-11-13 | EZU | ETF | 26.775 | 26.975 | 26.67 | 26.77 | 15600.0 |
| 2001-11-13 | FCTR | ETF | 17.03 | 17.46 | 16.79 | 17.05 | 18600.0 |
| 2001-11-13 | FMAR | ETF | 8.15 | 8.22 | 8.09 | 8.22 | 7200.0 |
| 2001-11-13 | GLDB | ETF | 7.54 | 7.54 | 7.42 | 7.4302 | 32400.0 |
| 2001-11-13 | GRNB | ETF | 16.6882 | 16.6882 | 16.6882 | 16.6882 | 2321.0 |
| 2001-11-13 | GSIG | ETF | 8.67 | 8.68 | 8.51 | 8.54 | 43500.0 |
| 2001-11-13 | IBB | ETF | 29.4667 | 29.75 | 29.2667 | 29.6333 | 503400.0 |
| 2001-11-13 | ICF | ETF | 20.51 | 20.6825 | 20.51 | 20.6575 | 22400.0 |
| 2001-11-13 | IDU | ETF | 33.2 | 33.335 | 32.87 | 33.335 | 103800.0 |
| 2001-11-13 | IEV | ETF | 28.975 | 29.2 | 28.84 | 29.01 | 57000.0 |
| 2001-11-13 | IGLD | ETF | 92.0 | 92.0 | 90.0 | 91.8 | 477.0 |
| 2001-11-13 | IGM | ETF | 8.4583 | 8.54 | 8.4167 | 8.5 | 426600.0 |
| 2001-11-13 | IGN | ETF | 32.4 | 32.65 | 32.05 | 32.55 | 9300.0 |
| 2001-11-13 | IGV | ETF | 8.45 | 8.516 | 8.364 | 8.364 | 6031000.0 |
| 2001-11-13 | IJH | ETF | 9.535 | 9.606 | 9.52 | 9.581 | 444000.0 |
| 2001-11-13 | IJJ | ETF | 21.0375 | 21.235 | 21.035 | 21.2325 | 90000.0 |
> showing 50 of 112 rows — these rows as CSV