PREVIEW / etf_daily / 2008-11-04
file: by_date/etf_daily/2008/2008-11-04.parquet size: 27 KB rows: 605
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-04 | SPY | ETF | 99.06 | 100.86 | 96.71 | 100.41 | 346793400.0 |
| 2008-11-04 | QQQ | ETF | 33.49 | 34.01 | 32.98 | 33.75 | 182533013.0 |
| 2008-11-04 | IWM | ETF | 54.93 | 55.21 | 53.39 | 54.44 | 79680500.0 |
| 2008-11-04 | DIA | ETF | 95.16 | 96.5 | 94.32 | 96.21 | 25723700.0 |
| 2008-11-04 | GLD | ETF | 73.15 | 75.69 | 72.85 | 75.48 | 11434600.0 |
| 2008-11-04 | TLT | ETF | 92.96 | 94.71 | 92.59 | 94.45 | 1608800.0 |
| 2008-11-04 | AAXJ | ETF | 34.08 | 35.63 | 33.57 | 34.99 | 263700.0 |
| 2008-11-04 | ACWI | ETF | 34.21 | 35.4 | 34.21 | 35.31 | 84600.0 |
| 2008-11-04 | ACWX | ETF | 31.98 | 33.26 | 30.9 | 33.04 | 236350.0 |
| 2008-11-04 | ADRE | ETF | 28.45 | 29.94 | 28.44 | 29.88 | 1058561.0 |
| 2008-11-04 | AFK | ETF | 26.52 | 26.52 | 23.1701 | 24.05 | 9531.0 |
| 2008-11-04 | AGG | ETF | 95.16 | 95.78 | 94.53 | 95.55 | 531100.0 |
| 2008-11-04 | AIA | ETF | 26.79 | 27.68 | 26.79 | 27.586 | 20427.0 |
| 2008-11-04 | AIQ | ETF | 41.1 | 41.3 | 39.75 | 40.4 | 94287.0 |
| 2008-11-04 | AIS | ETF | 0.45 | 0.48 | 0.45 | 0.48 | 45537.0 |
| 2008-11-04 | AIVI | ETF | 39.78 | 40.99 | 39.43 | 40.98 | 17800.0 |
| 2008-11-04 | ARB | ETF | 32.43 | 33.09 | 31.48 | 32.7 | 245595.0 |
| 2008-11-04 | BAL | ETF | 29.0 | 29.11 | 29.0 | 29.11 | 400.0 |
| 2008-11-04 | BBH | ETF | 59.3333 | 59.7367 | 58.07 | 58.7 | 330300.0 |
| 2008-11-04 | BIL | ETF | 91.66 | 91.8 | 91.66 | 91.72 | 96450.0 |
| 2008-11-04 | BITS | ETF | 16.48 | 17.68 | 15.68 | 16.3596 | 2561.0 |
| 2008-11-04 | BIV | ETF | 70.91 | 71.12 | 70.5 | 70.98 | 75500.0 |
| 2008-11-04 | BJK | ETF | 18.9 | 19.06 | 18.4 | 19.06 | 2100.0 |
| 2008-11-04 | BKF | ETF | 27.13 | 28.27 | 26.91 | 28.2 | 119977.0 |
| 2008-11-04 | BLV | ETF | 66.09 | 67.01 | 65.83 | 66.83 | 21900.0 |
| 2008-11-04 | BMVP | ETF | 11.253 | 11.452 | 11.217 | 11.397 | 31335.0 |
| 2008-11-04 | BND | ETF | 73.3 | 74.15 | 73.0 | 74.14 | 1260600.0 |
| 2008-11-04 | BNE | ETF | 9.2 | 9.51 | 8.69 | 8.84 | 185171.0 |
| 2008-11-04 | BOSS | ETF | 14.65 | 16.45 | 14.65 | 16.45 | 100.0 |
| 2008-11-04 | BRF | ETF | 14.85 | 14.9 | 14.84 | 14.9 | 5700.0 |
| 2008-11-04 | BSV | ETF | 75.7 | 75.89 | 74.72 | 74.72 | 310900.0 |
| 2008-11-04 | BTF | ETF | 68.0 | 68.0 | 65.5 | 66.9495 | 12311.2 |
| 2008-11-04 | BWX | ETF | 24.565 | 24.93 | 24.34 | 24.705 | 109326.0 |
| 2008-11-04 | CBON | ETF | 4.05 | 4.8 | 3.69 | 4.39 | 135313.0 |
| 2008-11-04 | CDL | ETF | 0.27 | 0.27 | 0.25 | 0.25 | 1648016.0 |
| 2008-11-04 | CEF | ETF | 9.08 | 9.56 | 9.08 | 9.45 | 639400.0 |
| 2008-11-04 | CGO | ETF | 9.83 | 10.17 | 9.79 | 10.17 | 37938.0 |
| 2008-11-04 | CGW | ETF | 16.5 | 16.95 | 16.11 | 16.67 | 142321.0 |
| 2008-11-04 | CHB | ETF | 1.88 | 2.19 | 1.8 | 2.11 | 1687430.0 |
| 2008-11-04 | CHI | ETF | 9.1 | 9.39 | 8.97 | 9.09 | 236862.0 |
| 2008-11-04 | CHIC | ETF | 9.13 | 9.17 | 8.31 | 8.31 | 413749.0 |
| 2008-11-04 | CHW | ETF | 6.36 | 6.61 | 6.36 | 6.5 | 194977.0 |
| 2008-11-04 | CHY | ETF | 8.98 | 9.47 | 8.98 | 9.14 | 331709.0 |
| 2008-11-04 | CMF | ETF | 49.995 | 50.505 | 49.995 | 50.505 | 11798.0 |
| 2008-11-04 | CNXT | ETF | 1.66 | 1.66 | 1.57 | 1.62 | 747731.0 |
| 2008-11-04 | COW | ETF | 36.34 | 36.34 | 35.73 | 35.96 | 46985.0 |
| 2008-11-04 | CPI | ETF | 23.0025 | 23.25 | 23.0 | 23.25 | 400.0 |
| 2008-11-04 | CPST | ETF | 1.43 | 1.53 | 1.345 | 1.53 | 4099571.0 |
| 2008-11-04 | CSA | ETF | 12.06 | 12.41 | 11.65 | 11.97 | 60066.0 |
| 2008-11-04 | CSB | ETF | 16.98 | 16.98 | 16.28 | 16.33 | 12848.0 |
> showing 50 of 605 rows — these rows as CSV