PREVIEW / etf_daily / 2001-11-15
file: by_date/etf_daily/2001/2001-11-15.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-15 | SPY | ETF | 114.37 | 115.18 | 113.93 | 114.87 | 19470200.0 |
| 2001-11-15 | QQQ | ETF | 39.162 | 40.11 | 38.95 | 39.48 | 86349700.0 |
| 2001-11-15 | IWM | ETF | 44.9 | 45.2 | 44.7 | 44.95 | 363400.0 |
| 2001-11-15 | DIA | ETF | 98.3 | 99.25 | 98.21 | 99.14 | 3540500.0 |
| 2001-11-15 | ARB | ETF | 29.44 | 29.5 | 29.3 | 29.3 | 88300.0 |
| 2001-11-15 | BBH | ETF | 43.8833 | 44.58 | 43.55 | 43.99 | 1582200.0 |
| 2001-11-15 | BITS | ETF | 17.04 | 18.0 | 17.0 | 17.84 | 5875.0 |
| 2001-11-15 | CEF | ETF | 3.33 | 3.33 | 3.3 | 3.3 | 15800.0 |
| 2001-11-15 | CHB | ETF | 11.5 | 11.74 | 11.38 | 11.71 | 180200.0 |
| 2001-11-15 | CNXT | ETF | 14.0 | 14.75 | 13.96 | 14.31 | 3504600.0 |
| 2001-11-15 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 8700.0 |
| 2001-11-15 | DGT | ETF | 67.13 | 67.19 | 66.93 | 66.93 | 2200.0 |
| 2001-11-15 | EFA | ETF | 39.5833 | 39.7933 | 39.5633 | 39.77 | 4697400.0 |
| 2001-11-15 | ELV | ETF | 22.85 | 23.375 | 22.725 | 23.375 | 1155200.0 |
| 2001-11-15 | EPP | ETF | 17.7567 | 17.7667 | 17.75 | 17.75 | 28800.0 |
| 2001-11-15 | EWA | ETF | 9.34 | 9.41 | 9.31 | 9.31 | 1800.0 |
| 2001-11-15 | EWD | ETF | 13.15 | 13.25 | 13.0 | 13.11 | 4900.0 |
| 2001-11-15 | EWG | ETF | 14.26 | 14.3 | 14.2 | 14.2 | 71400.0 |
| 2001-11-15 | EWH | ETF | 8.85 | 8.95 | 8.83 | 8.84 | 31900.0 |
| 2001-11-15 | EWI | ETF | 31.1 | 31.32 | 31.1 | 31.24 | 400.0 |
| 2001-11-15 | EWJ | ETF | 33.48 | 33.6 | 33.24 | 33.44 | 272275.0 |
| 2001-11-15 | EWK | ETF | 10.65 | 10.65 | 10.51 | 10.51 | 2800.0 |
| 2001-11-15 | EWL | ETF | 12.8 | 12.89 | 12.72 | 12.72 | 3700.0 |
| 2001-11-15 | EWM | ETF | 18.16 | 18.6 | 18.16 | 18.6 | 5450.0 |
| 2001-11-15 | EWN | ETF | 16.48 | 16.48 | 16.36 | 16.41 | 2600.0 |
| 2001-11-15 | EWO | ETF | 6.99 | 7.08 | 6.93 | 6.93 | 3300.0 |
| 2001-11-15 | EWQ | ETF | 18.27 | 18.3 | 18.09 | 18.13 | 16100.0 |
| 2001-11-15 | EWS | ETF | 9.0 | 9.1 | 8.86 | 8.98 | 12650.0 |
| 2001-11-15 | EWT | ETF | 17.74 | 18.0 | 17.72 | 17.72 | 306600.0 |
| 2001-11-15 | EWU | ETF | 29.2 | 29.5 | 29.18 | 29.3 | 9950.0 |
| 2001-11-15 | EWW | ETF | 13.8 | 13.94 | 13.7 | 13.71 | 40300.0 |
| 2001-11-15 | EWY | ETF | 15.31 | 15.38 | 15.2 | 15.34 | 417400.0 |
| 2001-11-15 | EWZ | ETF | 10.75 | 11.1 | 10.75 | 11.1 | 4300.0 |
| 2001-11-15 | EZU | ETF | 27.0 | 27.115 | 26.815 | 27.02 | 11200.0 |
| 2001-11-15 | FCTR | ETF | 17.49 | 17.5 | 17.0 | 17.27 | 10500.0 |
| 2001-11-15 | FMAR | ETF | 8.25 | 8.35 | 8.25 | 8.25 | 24700.0 |
| 2001-11-15 | GLDB | ETF | 7.41 | 7.55 | 7.41 | 7.54 | 15300.0 |
| 2001-11-15 | GRNB | ETF | 17.6698 | 17.6698 | 16.6882 | 17.6698 | 606.0 |
| 2001-11-15 | GSIG | ETF | 8.44 | 8.55 | 8.34 | 8.35 | 34200.0 |
| 2001-11-15 | IBB | ETF | 29.6 | 30.1333 | 29.45 | 29.45 | 141300.0 |
| 2001-11-15 | ICF | ETF | 20.795 | 20.935 | 20.7875 | 20.88 | 30800.0 |
| 2001-11-15 | IDU | ETF | 32.675 | 32.675 | 32.23 | 32.41 | 11800.0 |
| 2001-11-15 | IEV | ETF | 29.1 | 29.26 | 28.87 | 29.025 | 39400.0 |
| 2001-11-15 | IGLD | ETF | 93.0 | 93.0 | 89.0 | 89.0 | 189.0 |
| 2001-11-15 | IGM | ETF | 8.525 | 8.65 | 8.5 | 8.5417 | 85800.0 |
| 2001-11-15 | IGN | ETF | 33.5 | 34.15 | 33.5 | 33.8 | 9200.0 |
| 2001-11-15 | IGV | ETF | 8.47 | 8.55 | 8.43 | 8.48 | 16000.0 |
| 2001-11-15 | IJH | ETF | 9.564 | 9.61 | 9.515 | 9.541 | 210000.0 |
| 2001-11-15 | IJJ | ETF | 21.275 | 21.3225 | 21.105 | 21.1125 | 125200.0 |
| 2001-11-15 | IJK | ETF | 13.4275 | 13.4625 | 13.31 | 13.345 | 137600.0 |
> showing 50 of 112 rows — these rows as CSV