PREVIEW / etf_daily / 2008-11-03
file: by_date/etf_daily/2008/2008-11-03.parquet size: 27 KB rows: 607
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-03 | SPY | ETF | 96.78 | 97.69 | 95.95 | 97.11 | 205419400.0 |
| 2008-11-03 | QQQ | ETF | 32.81 | 33.2941 | 32.51 | 32.82 | 128502428.0 |
| 2008-11-03 | IWM | ETF | 53.48 | 54.6 | 53.38 | 53.82 | 54872700.0 |
| 2008-11-03 | DIA | ETF | 93.14 | 94.08 | 92.52 | 93.43 | 17957000.0 |
| 2008-11-03 | GLD | ETF | 71.55 | 72.17 | 71.06 | 71.1 | 6799400.0 |
| 2008-11-03 | TLT | ETF | 92.72 | 93.11 | 92.35 | 92.71 | 1111600.0 |
| 2008-11-03 | AAXJ | ETF | 32.85 | 33.25 | 32.76 | 33.03 | 70500.0 |
| 2008-11-03 | ACWI | ETF | 33.36 | 33.8 | 33.1 | 33.5 | 143100.0 |
| 2008-11-03 | ACWX | ETF | 30.63 | 32.4 | 30.63 | 31.07 | 74143.0 |
| 2008-11-03 | ADRE | ETF | 27.61 | 27.76 | 27.26 | 27.67 | 632022.0 |
| 2008-11-03 | AFK | ETF | 24.3 | 24.3 | 22.91 | 23.85 | 3321.0 |
| 2008-11-03 | AGG | ETF | 95.99 | 95.99 | 93.51 | 94.04 | 613700.0 |
| 2008-11-03 | AIA | ETF | 26.36 | 26.609 | 26.11 | 26.212 | 10291.0 |
| 2008-11-03 | AIQ | ETF | 40.75 | 42.25 | 40.75 | 40.9 | 57981.0 |
| 2008-11-03 | AIS | ETF | 0.48 | 0.48 | 0.45 | 0.46 | 16500.0 |
| 2008-11-03 | AIVI | ETF | 37.47 | 38.34 | 37.34 | 37.94 | 38800.0 |
| 2008-11-03 | ARB | ETF | 32.5 | 32.73 | 31.79 | 31.93 | 232327.0 |
| 2008-11-03 | BAL | ETF | 28.3 | 28.3 | 28.3 | 28.3 | 100.0 |
| 2008-11-03 | BBH | ETF | 58.4367 | 59.2433 | 58.14 | 59.07 | 687300.0 |
| 2008-11-03 | BIL | ETF | 91.82 | 91.82 | 91.68 | 91.68 | 158550.0 |
| 2008-11-03 | BITS | ETF | 17.0 | 17.0 | 16.0 | 16.48 | 925.0 |
| 2008-11-03 | BIV | ETF | 70.3 | 70.96 | 70.13 | 70.79 | 64300.0 |
| 2008-11-03 | BJK | ETF | 18.83 | 18.85 | 18.47 | 18.7 | 12500.0 |
| 2008-11-03 | BKF | ETF | 26.0 | 26.3 | 25.54 | 26.13 | 62191.0 |
| 2008-11-03 | BLV | ETF | 65.97 | 65.97 | 65.5 | 65.78 | 12500.0 |
| 2008-11-03 | BMVP | ETF | 11.21 | 11.21 | 11.05 | 11.08 | 32738.0 |
| 2008-11-03 | BND | ETF | 73.16 | 73.41 | 73.0 | 73.4 | 308800.0 |
| 2008-11-03 | BNE | ETF | 7.8 | 10.0 | 7.8 | 9.26 | 338531.0 |
| 2008-11-03 | BRF | ETF | 14.82 | 14.834 | 14.82 | 14.834 | 7448.0 |
| 2008-11-03 | BSV | ETF | 75.84 | 75.85 | 74.93 | 75.0 | 190400.0 |
| 2008-11-03 | BTF | ETF | 65.75 | 65.75 | 63.8 | 64.55 | 20517.800000000003 |
| 2008-11-03 | BWX | ETF | 24.59 | 24.5931 | 24.2 | 24.45 | 129138.0 |
| 2008-11-03 | CBON | ETF | 3.19 | 3.9 | 3.0 | 3.84 | 83659.0 |
| 2008-11-03 | CDL | ETF | 0.3 | 0.3 | 0.25 | 0.26 | 2259829.0 |
| 2008-11-03 | CEF | ETF | 8.75 | 9.09 | 8.75 | 8.85 | 355900.0 |
| 2008-11-03 | CGO | ETF | 9.54 | 9.74 | 9.5 | 9.6799 | 24575.0 |
| 2008-11-03 | CGW | ETF | 15.93 | 16.44 | 15.73 | 16.01 | 41026.0 |
| 2008-11-03 | CHB | ETF | 1.83 | 2.27 | 1.77 | 1.83 | 1434198.0 |
| 2008-11-03 | CHI | ETF | 8.92 | 9.28 | 8.92 | 9.16 | 234863.0 |
| 2008-11-03 | CHIC | ETF | 8.41 | 9.09 | 8.06 | 9.04 | 428710.0 |
| 2008-11-03 | CHW | ETF | 6.25 | 6.5 | 6.23 | 6.42 | 167831.0 |
| 2008-11-03 | CHY | ETF | 9.02 | 9.1 | 8.85 | 9.09 | 400923.0 |
| 2008-11-03 | CMF | ETF | 49.425 | 50.0 | 49.4175 | 50.0 | 8800.0 |
| 2008-11-03 | CNXT | ETF | 1.62 | 1.62 | 1.57 | 1.57 | 582070.0 |
| 2008-11-03 | COW | ETF | 35.81 | 36.0 | 35.66 | 35.76 | 25063.0 |
| 2008-11-03 | CPI | ETF | 22.8 | 23.1 | 22.8 | 23.1 | 200.0 |
| 2008-11-03 | CPST | ETF | 1.36 | 1.54 | 1.28 | 1.34 | 5671680.0 |
| 2008-11-03 | CSA | ETF | 11.82 | 12.15 | 11.62 | 11.71 | 58530.0 |
| 2008-11-03 | CSB | ETF | 17.19 | 17.4 | 15.96 | 16.25 | 24450.0 |
| 2008-11-03 | CSD | ETF | 13.8 | 13.8 | 13.8 | 13.8 | 1000.0 |
> showing 50 of 607 rows — these rows as CSV