PREVIEW / etf_daily / 2008-10-29
file: by_date/etf_daily/2008/2008-10-29.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-10-29 | SPY | ETF | 93.77 | 97.17 | 92.1 | 93.08 | 531270100.0 |
| 2008-10-29 | QQQ | ETF | 31.95 | 33.08 | 31.25 | 31.78 | 341390788.0 |
| 2008-10-29 | IWM | ETF | 48.51 | 50.73 | 47.82 | 48.7 | 94984800.0 |
| 2008-10-29 | DIA | ETF | 90.49 | 93.62 | 88.7 | 89.15 | 50631600.0 |
| 2008-10-29 | GLD | ETF | 75.05 | 76.36 | 73.61 | 74.0 | 16121400.0 |
| 2008-10-29 | TLT | ETF | 95.77 | 96.01 | 94.43 | 94.91 | 1745800.0 |
| 2008-10-29 | AAXJ | ETF | 29.43 | 31.9 | 28.41 | 29.25 | 126800.0 |
| 2008-10-29 | ACWI | ETF | 31.55 | 32.88 | 31.24 | 31.71 | 342900.0 |
| 2008-10-29 | ACWX | ETF | 28.56 | 30.0201 | 28.56 | 29.26 | 84113.0 |
| 2008-10-29 | ADRE | ETF | 24.51 | 26.06 | 23.9 | 25.05 | 665195.0 |
| 2008-10-29 | AFK | ETF | 23.39 | 23.61 | 23.39 | 23.61 | 1149.0 |
| 2008-10-29 | AGG | ETF | 95.21 | 96.5 | 94.68 | 96.38 | 597800.0 |
| 2008-10-29 | AIA | ETF | 23.76 | 24.19 | 22.64 | 24.1 | 48463.0 |
| 2008-10-29 | AIQ | ETF | 34.8 | 35.75 | 33.6 | 34.3 | 45740.0 |
| 2008-10-29 | AIS | ETF | 0.45 | 0.5 | 0.44 | 0.468 | 65650.0 |
| 2008-10-29 | AIVI | ETF | 35.37 | 37.11 | 35.37 | 36.36 | 23200.0 |
| 2008-10-29 | ARB | ETF | 28.67 | 31.79 | 28.42 | 30.39 | 436748.0 |
| 2008-10-29 | BAL | ETF | 29.82 | 29.82 | 29.8 | 29.8 | 700.0 |
| 2008-10-29 | BBH | ETF | 56.95 | 57.56 | 55.7533 | 56.15 | 694200.0 |
| 2008-10-29 | BIL | ETF | 91.84 | 91.94 | 91.78 | 91.78 | 144300.0 |
| 2008-10-29 | BITS | ETF | 16.0 | 16.2 | 15.8336 | 16.2 | 1225.0 |
| 2008-10-29 | BIV | ETF | 71.08 | 71.5 | 70.77 | 71.13 | 37800.0 |
| 2008-10-29 | BJK | ETF | 15.6 | 16.7 | 15.6 | 16.7 | 4400.0 |
| 2008-10-29 | BKF | ETF | 22.42 | 23.75 | 21.72 | 23.03 | 190436.0 |
| 2008-10-29 | BLV | ETF | 66.75 | 67.33 | 66.02 | 66.44 | 15200.0 |
| 2008-10-29 | BMVP | ETF | 10.2233 | 10.9895 | 10.2233 | 10.6333 | 296455.0 |
| 2008-10-29 | BND | ETF | 73.42 | 74.4 | 73.17 | 73.66 | 732300.0 |
| 2008-10-29 | BNE | ETF | 6.91 | 7.29 | 6.79 | 6.95 | 141284.0 |
| 2008-10-29 | BRF | ETF | 14.82 | 14.8301 | 14.82 | 14.8201 | 12500.0 |
| 2008-10-29 | BSV | ETF | 75.58 | 75.88 | 75.34 | 75.6 | 82400.0 |
| 2008-10-29 | BTF | ETF | 58.75 | 64.45 | 58.75 | 63.186 | 19226.4 |
| 2008-10-29 | BWX | ETF | 24.695 | 24.8 | 24.349 | 24.49 | 214624.0 |
| 2008-10-29 | CBON | ETF | 2.5 | 3.25 | 2.26 | 3.17 | 166822.0 |
| 2008-10-29 | CDL | ETF | 0.28 | 0.31 | 0.26 | 0.27 | 454903.0 |
| 2008-10-29 | CEF | ETF | 8.99 | 9.59 | 8.96 | 9.36 | 983000.0 |
| 2008-10-29 | CGO | ETF | 9.1 | 9.5 | 9.08 | 9.47 | 51453.0 |
| 2008-10-29 | CGW | ETF | 14.39 | 15.505 | 14.39 | 15.14 | 59508.0 |
| 2008-10-29 | CHB | ETF | 1.62 | 1.96 | 1.47 | 1.65 | 2779319.0 |
| 2008-10-29 | CHI | ETF | 9.45 | 9.45 | 9.06 | 9.21 | 134828.0 |
| 2008-10-29 | CHIC | ETF | 6.94 | 7.39 | 6.51 | 7.09 | 338146.0 |
| 2008-10-29 | CHW | ETF | 5.84 | 6.0 | 5.6 | 5.79 | 189593.0 |
| 2008-10-29 | CHY | ETF | 8.82 | 8.94 | 8.47 | 8.94 | 185244.0 |
| 2008-10-29 | CMF | ETF | 49.052 | 49.1275 | 48.925 | 48.98 | 5012.0 |
| 2008-10-29 | CNXT | ETF | 1.52 | 1.64 | 1.51 | 1.55 | 849120.0 |
| 2008-10-29 | COW | ETF | 35.65 | 36.2601 | 35.65 | 35.86 | 30375.0 |
| 2008-10-29 | CPST | ETF | 1.18 | 1.18 | 1.1 | 1.11 | 1432388.0 |
| 2008-10-29 | CSA | ETF | 9.91 | 10.66 | 9.91 | 10.19 | 189901.0 |
| 2008-10-29 | CSB | ETF | 15.07 | 16.2 | 14.99 | 15.95 | 31884.0 |
| 2008-10-29 | CSD | ETF | 12.7 | 12.76 | 12.7 | 12.76 | 400.0 |
| 2008-10-29 | CSQ | ETF | 6.27 | 6.6 | 6.22 | 6.45 | 428125.0 |
> showing 50 of 605 rows — these rows as CSV