PREVIEW / etf_daily / 2001-11-14
file: by_date/etf_daily/2001/2001-11-14.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-14 | SPY | ETF | 115.17 | 115.4 | 113.71 | 114.66 | 17571300.0 |
| 2001-11-14 | QQQ | ETF | 39.96 | 40.24 | 38.74 | 39.64 | 88660100.0 |
| 2001-11-14 | IWM | ETF | 45.0 | 45.12 | 44.21 | 45.12 | 285600.0 |
| 2001-11-14 | DIA | ETF | 98.45 | 98.89 | 97.58 | 98.55 | 2772100.0 |
| 2001-11-14 | ARB | ETF | 29.6 | 29.78 | 29.39 | 29.55 | 35000.0 |
| 2001-11-14 | BBH | ETF | 44.8333 | 44.8333 | 43.5333 | 44.0 | 4500600.0 |
| 2001-11-14 | BITS | ETF | 18.04 | 18.04 | 16.76 | 16.84 | 3575.0 |
| 2001-11-14 | BOSS | ETF | 19.0 | 20.0 | 19.0 | 20.0 | 200.0 |
| 2001-11-14 | CEF | ETF | 3.31 | 3.32 | 3.3 | 3.32 | 10000.0 |
| 2001-11-14 | CHB | ETF | 10.9 | 11.75 | 10.9 | 11.72 | 452600.0 |
| 2001-11-14 | CNXT | ETF | 14.69 | 15.06 | 14.05 | 14.31 | 5587400.0 |
| 2001-11-14 | CSB | ETF | 3.95000004768372 | 4.0 | 3.90000009536743 | 4.0 | 38800.0 |
| 2001-11-14 | DGT | ETF | 67.18 | 67.32 | 67.18 | 67.32 | 300.0 |
| 2001-11-14 | EFA | ETF | 39.7333 | 39.79 | 39.5333 | 39.6 | 152400.0 |
| 2001-11-14 | ELV | ETF | 22.0 | 23.0 | 21.775 | 22.975 | 2106500.0 |
| 2001-11-14 | EPP | ETF | 17.5667 | 17.61 | 17.5667 | 17.61 | 900.0 |
| 2001-11-14 | EWA | ETF | 9.35 | 9.45 | 9.31 | 9.31 | 6800.0 |
| 2001-11-14 | EWC | ETF | 10.6 | 10.64 | 10.31 | 10.31 | 5100.0 |
| 2001-11-14 | EWD | ETF | 13.0 | 13.0 | 12.94 | 12.94 | 1200.0 |
| 2001-11-14 | EWG | ETF | 14.19 | 14.22 | 14.02 | 14.05 | 52400.0 |
| 2001-11-14 | EWH | ETF | 8.75 | 8.75 | 8.6 | 8.68 | 50100.0 |
| 2001-11-14 | EWI | ETF | 31.4 | 31.4 | 31.0 | 31.0 | 3100.0 |
| 2001-11-14 | EWJ | ETF | 33.16 | 33.16 | 32.76 | 32.84 | 70100.0 |
| 2001-11-14 | EWL | ETF | 12.55 | 12.65 | 12.46 | 12.47 | 21900.0 |
| 2001-11-14 | EWM | ETF | 17.8 | 18.08 | 17.8 | 18.0 | 7075.0 |
| 2001-11-14 | EWN | ETF | 16.69 | 16.69 | 16.55 | 16.66 | 12000.0 |
| 2001-11-14 | EWO | ETF | 6.85 | 6.86 | 6.85 | 6.86 | 2000.0 |
| 2001-11-14 | EWP | ETF | 20.94 | 20.94 | 20.41 | 20.6 | 15500.0 |
| 2001-11-14 | EWQ | ETF | 18.45 | 18.45 | 18.16 | 18.35 | 12500.0 |
| 2001-11-14 | EWS | ETF | 8.8 | 8.82 | 8.6 | 8.74 | 18000.0 |
| 2001-11-14 | EWT | ETF | 17.4 | 17.6 | 17.32 | 17.5 | 476100.0 |
| 2001-11-14 | EWU | ETF | 29.98 | 30.0 | 29.42 | 29.54 | 40200.0 |
| 2001-11-14 | EWW | ETF | 13.95 | 13.95 | 13.69 | 13.71 | 34000.0 |
| 2001-11-14 | EWY | ETF | 15.16 | 15.45 | 15.16 | 15.42 | 476300.0 |
| 2001-11-14 | EWZ | ETF | 11.15 | 11.2 | 11.0 | 11.1 | 11900.0 |
| 2001-11-14 | EZU | ETF | 27.3 | 27.3 | 26.8 | 26.995 | 111400.0 |
| 2001-11-14 | FCTR | ETF | 17.385 | 17.64 | 17.1 | 17.5 | 26600.0 |
| 2001-11-14 | FMAR | ETF | 8.2 | 8.24 | 8.16 | 8.16 | 3500.0 |
| 2001-11-14 | GLDB | ETF | 7.45 | 7.53 | 7.41 | 7.51 | 29500.0 |
| 2001-11-14 | GRNB | ETF | 16.6882 | 16.6882 | 16.6882 | 16.6882 | 101.0 |
| 2001-11-14 | GSIG | ETF | 8.55 | 8.62 | 8.42 | 8.54 | 28200.0 |
| 2001-11-14 | IBB | ETF | 30.1 | 30.1367 | 29.2333 | 29.6 | 276600.0 |
| 2001-11-14 | ICF | ETF | 20.7125 | 20.7575 | 20.67 | 20.7575 | 6800.0 |
| 2001-11-14 | IDU | ETF | 33.0 | 33.0 | 32.69 | 32.69 | 6000.0 |
| 2001-11-14 | IEV | ETF | 29.55 | 29.675 | 28.95 | 29.225 | 198200.0 |
| 2001-11-14 | IGLD | ETF | 90.0 | 91.8 | 90.0 | 91.8 | 237.0 |
| 2001-11-14 | IGM | ETF | 8.6667 | 8.6833 | 8.475 | 8.5683 | 186600.0 |
| 2001-11-14 | IGN | ETF | 33.65 | 33.94 | 33.0 | 33.85 | 5700.0 |
| 2001-11-14 | IGV | ETF | 8.46 | 8.54 | 8.4 | 8.54 | 3000.0 |
| 2001-11-14 | IJH | ETF | 9.675 | 9.675 | 9.544 | 9.604 | 470000.0 |
> showing 50 of 112 rows — these rows as CSV