PREVIEW / etf_daily / 2008-11-05
file: by_date/etf_daily/2008/2008-11-05.parquet size: 27 KB rows: 602
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-05 | SPY | ETF | 99.2 | 100.71 | 95.0 | 96.19 | 387844100.0 |
| 2008-11-05 | QQQ | ETF | 33.49 | 33.6 | 31.92 | 31.99 | 184147880.0 |
| 2008-11-05 | IWM | ETF | 53.93 | 54.44 | 51.31 | 51.59 | 73881200.0 |
| 2008-11-05 | DIA | ETF | 94.99 | 95.59 | 91.15 | 91.85 | 28970800.0 |
| 2008-11-05 | GLD | ETF | 74.32 | 75.18 | 72.38 | 72.8 | 10316500.0 |
| 2008-11-05 | TLT | ETF | 94.89 | 95.67 | 94.4 | 95.57 | 1931700.0 |
| 2008-11-05 | AAXJ | ETF | 34.15 | 34.15 | 32.53 | 32.9 | 105000.0 |
| 2008-11-05 | ACWI | ETF | 35.17 | 35.17 | 33.44 | 33.45 | 299600.0 |
| 2008-11-05 | ACWX | ETF | 32.65 | 32.94 | 31.49 | 31.54 | 107312.0 |
| 2008-11-05 | ADRE | ETF | 29.1 | 29.1 | 26.81 | 26.95 | 1194751.0 |
| 2008-11-05 | AFK | ETF | 23.25 | 23.27 | 23.2 | 23.2 | 5430.0 |
| 2008-11-05 | AGG | ETF | 96.83 | 97.0 | 96.19 | 97.0 | 612600.0 |
| 2008-11-05 | AIA | ETF | 28.0 | 28.0 | 25.594 | 25.594 | 47390.0 |
| 2008-11-05 | AIQ | ETF | 40.0 | 42.55 | 39.85 | 41.35 | 89225.0 |
| 2008-11-05 | AIS | ETF | 0.48 | 0.57 | 0.48 | 0.51 | 46825.0 |
| 2008-11-05 | AIVI | ETF | 39.9 | 40.69 | 38.7 | 38.86 | 44000.0 |
| 2008-11-05 | ARB | ETF | 32.46 | 32.69 | 31.22 | 31.39 | 156197.0 |
| 2008-11-05 | BAL | ETF | 29.04 | 29.04 | 29.04 | 29.04 | 100.0 |
| 2008-11-05 | BBH | ETF | 58.0467 | 58.7767 | 57.59 | 57.8067 | 519900.0 |
| 2008-11-05 | BIL | ETF | 91.74 | 91.86 | 91.72 | 91.76 | 133750.0 |
| 2008-11-05 | BITS | ETF | 16.32 | 16.6 | 15.52 | 15.92 | 3727.0 |
| 2008-11-05 | BIV | ETF | 71.37 | 72.08 | 71.35 | 71.87 | 33000.0 |
| 2008-11-05 | BJK | ETF | 20.45 | 20.46 | 18.46 | 18.5 | 4700.0 |
| 2008-11-05 | BKF | ETF | 27.5 | 27.53 | 25.01 | 25.01 | 147441.0 |
| 2008-11-05 | BLV | ETF | 67.05 | 67.94 | 67.05 | 67.83 | 31900.0 |
| 2008-11-05 | BMVP | ETF | 11.24 | 11.383 | 10.877 | 10.882 | 92060.0 |
| 2008-11-05 | BND | ETF | 74.24 | 74.93 | 74.1 | 74.7 | 332200.0 |
| 2008-11-05 | BNE | ETF | 8.74 | 9.24 | 8.46 | 8.5 | 77896.0 |
| 2008-11-05 | BOSS | ETF | 16.45 | 16.45 | 16.45 | 16.45 | 100.0 |
| 2008-11-05 | BRF | ETF | 14.87 | 14.91 | 14.87 | 14.91 | 800.0 |
| 2008-11-05 | BSV | ETF | 75.48 | 76.0 | 75.21 | 76.0 | 128400.0 |
| 2008-11-05 | BTF | ETF | 68.0 | 68.05 | 64.25 | 65.0 | 13601.400000000001 |
| 2008-11-05 | BWX | ETF | 24.97 | 25.15 | 24.575 | 24.765 | 107196.0 |
| 2008-11-05 | CBON | ETF | 4.27 | 4.63 | 4.11 | 4.14 | 56635.0 |
| 2008-11-05 | CDL | ETF | 0.2701 | 0.2701 | 0.23 | 0.23 | 1220276.0 |
| 2008-11-05 | CEF | ETF | 9.44 | 9.6 | 9.22 | 9.36 | 480100.0 |
| 2008-11-05 | CGO | ETF | 10.07 | 10.08 | 9.5 | 9.64 | 14280.0 |
| 2008-11-05 | CGW | ETF | 16.16 | 16.764 | 16.09 | 16.1 | 49884.0 |
| 2008-11-05 | CHB | ETF | 2.09 | 2.485 | 1.8 | 1.81 | 1548396.0 |
| 2008-11-05 | CHI | ETF | 8.99 | 9.06 | 8.7 | 8.71 | 184469.0 |
| 2008-11-05 | CHIC | ETF | 8.2 | 8.99 | 7.85 | 7.96 | 406922.0 |
| 2008-11-05 | CHW | ETF | 6.41 | 6.55 | 6.15 | 6.44 | 109636.0 |
| 2008-11-05 | CHY | ETF | 9.38 | 9.38 | 8.8 | 8.89 | 302312.0 |
| 2008-11-05 | CMF | ETF | 50.005 | 51.765 | 50.005 | 51.765 | 7330.0 |
| 2008-11-05 | CNXT | ETF | 1.63 | 1.72 | 1.6 | 1.62 | 489429.0 |
| 2008-11-05 | COW | ETF | 35.58 | 36.07 | 35.58 | 36.07 | 17098.0 |
| 2008-11-05 | CPI | ETF | 23.0 | 23.0 | 23.0 | 23.0 | 400.0 |
| 2008-11-05 | CPST | ETF | 1.52 | 1.67 | 1.43 | 1.55 | 4591632.0 |
| 2008-11-05 | CSA | ETF | 11.78 | 11.84 | 11.14 | 11.31 | 115546.0 |
| 2008-11-05 | CSB | ETF | 16.31 | 16.45 | 16.0 | 16.0 | 28780.0 |
> showing 50 of 602 rows — these rows as CSV