PREVIEW / etf_daily / 2008-10-08
file: by_date/etf_daily/2008/2008-10-08.parquet size: 27 KB rows: 616
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-10-08 | SPY | ETF | 97.52 | 102.18 | 96.81 | 97.51 | 725414800.0 |
| 2008-10-08 | QQQ | ETF | 31.95 | 34.12 | 31.84 | 32.39 | 452568314.0 |
| 2008-10-08 | IWM | ETF | 53.81 | 56.95 | 53.51 | 54.46 | 173741000.0 |
| 2008-10-08 | DIA | ETF | 93.25 | 96.39 | 91.4 | 91.4 | 53470900.0 |
| 2008-10-08 | GLD | ETF | 90.69 | 90.84 | 88.05 | 89.42 | 31204900.0 |
| 2008-10-08 | TLT | ETF | 99.68 | 99.94 | 96.68 | 97.45 | 3386300.0 |
| 2008-10-08 | AAXJ | ETF | 36.5 | 36.5 | 34.01 | 35.77 | 39500.0 |
| 2008-10-08 | ACWI | ETF | 34.57 | 35.63 | 33.36 | 34.59 | 24900.0 |
| 2008-10-08 | ACWX | ETF | 32.74 | 33.54 | 32.15 | 32.65 | 166136.0 |
| 2008-10-08 | ADRE | ETF | 26.99 | 29.54 | 26.02 | 28.54 | 530031.0 |
| 2008-10-08 | AFK | ETF | 27.6504 | 27.6504 | 26.69 | 27.37 | 615.0 |
| 2008-10-08 | AGG | ETF | 96.17 | 96.96 | 93.05 | 94.67 | 835000.0 |
| 2008-10-08 | AIA | ETF | 27.3 | 29.0 | 27.3 | 27.958 | 81768.0 |
| 2008-10-08 | AIQ | ETF | 41.8 | 44.35 | 41.15 | 42.65 | 80002.0 |
| 2008-10-08 | AIS | ETF | 0.51 | 0.65 | 0.47 | 0.56 | 149466.0 |
| 2008-10-08 | AIVI | ETF | 42.11 | 44.09 | 39.72 | 42.61 | 182000.0 |
| 2008-10-08 | ARB | ETF | 39.83 | 41.47 | 39.04 | 40.17 | 301032.0 |
| 2008-10-08 | BAL | ETF | 33.0 | 33.2 | 33.0 | 33.2 | 2290.0 |
| 2008-10-08 | BBH | ETF | 53.1367 | 56.2167 | 52.58 | 54.5 | 1010100.0 |
| 2008-10-08 | BIL | ETF | 91.94 | 91.94 | 91.72 | 91.84 | 222150.0 |
| 2008-10-08 | BITS | ETF | 18.4 | 18.96 | 16.8 | 18.32 | 6392.0 |
| 2008-10-08 | BIV | ETF | 73.52 | 73.93 | 70.88 | 72.18 | 60300.0 |
| 2008-10-08 | BJK | ETF | 19.54 | 20.18 | 19.54 | 19.7 | 500.0 |
| 2008-10-08 | BKF | ETF | 25.0 | 26.97 | 23.91 | 25.92 | 114069.0 |
| 2008-10-08 | BLV | ETF | 73.12 | 73.12 | 70.0 | 70.3 | 43500.0 |
| 2008-10-08 | BMVP | ETF | 10.96 | 11.628 | 10.957 | 11.17 | 115982.0 |
| 2008-10-08 | BND | ETF | 75.65 | 75.93 | 74.42 | 74.48 | 321800.0 |
| 2008-10-08 | BNE | ETF | 7.9 | 8.32 | 7.68 | 7.72 | 185350.0 |
| 2008-10-08 | BOSS | ETF | 15.35 | 15.35 | 15.35 | 15.35 | 100.0 |
| 2008-10-08 | BRF | ETF | 14.58 | 14.63 | 14.58 | 14.62 | 10300.0 |
| 2008-10-08 | BSV | ETF | 77.77 | 77.97 | 75.22 | 76.2 | 156600.0 |
| 2008-10-08 | BTF | ETF | 65.25 | 66.85 | 55.199999999999996 | 64.85 | 29118.4 |
| 2008-10-08 | BWX | ETF | 25.47 | 26.15 | 24.595 | 24.595 | 403482.0 |
| 2008-10-08 | CBON | ETF | 5.06 | 6.0 | 5.0 | 5.49 | 29170.0 |
| 2008-10-08 | CDL | ETF | 0.5 | 0.53 | 0.3322 | 0.36 | 1774140.0 |
| 2008-10-08 | CEF | ETF | 12.29 | 12.29 | 11.05 | 11.3 | 2708600.0 |
| 2008-10-08 | CGO | ETF | 7.58 | 8.69 | 7.1 | 8.56 | 168220.0 |
| 2008-10-08 | CGW | ETF | 16.01 | 16.74 | 15.51 | 16.2738 | 159030.0 |
| 2008-10-08 | CHB | ETF | 3.66 | 5.6 | 3.33 | 4.07 | 2498523.0 |
| 2008-10-08 | CHI | ETF | 7.0 | 7.9 | 6.82 | 7.8 | 800630.0 |
| 2008-10-08 | CHIC | ETF | 9.44 | 10.14 | 9.3 | 9.77 | 679351.0 |
| 2008-10-08 | CHW | ETF | 5.7 | 5.85 | 5.01 | 5.7 | 727162.0 |
| 2008-10-08 | CHY | ETF | 8.49 | 8.9 | 7.26 | 8.9 | 716177.0 |
| 2008-10-08 | CMF | ETF | 48.85 | 50.474 | 46.4 | 49.085 | 9006.0 |
| 2008-10-08 | CNXT | ETF | 2.79 | 2.986 | 2.45 | 2.46 | 1000882.0 |
| 2008-10-08 | COW | ETF | 37.63 | 38.08 | 37.12 | 37.84 | 60232.0 |
| 2008-10-08 | CPI | ETF | 23.0 | 23.0 | 22.6 | 22.6 | 2742.0 |
| 2008-10-08 | CPST | ETF | 1.11 | 1.21 | 1.0 | 1.07 | 5301519.0 |
| 2008-10-08 | CSA | ETF | 13.88 | 14.45 | 13.63 | 13.9 | 229319.0 |
| 2008-10-08 | CSB | ETF | 12.45 | 12.5 | 11.01 | 12.0 | 52427.0 |
> showing 50 of 616 rows — these rows as CSV