PREVIEW / etf_daily / 2008-11-12
file: by_date/etf_daily/2008/2008-11-12.parquet size: 27 KB rows: 613
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-12 | SPY | ETF | 88.23 | 88.95 | 85.12 | 85.82 | 454330600.0 |
| 2008-11-12 | QQQ | ETF | 29.65 | 29.8 | 28.65 | 28.71 | 184936240.0 |
| 2008-11-12 | IWM | ETF | 47.61 | 48.38 | 45.32 | 45.56 | 75376800.0 |
| 2008-11-12 | DIA | ETF | 85.41 | 86.0 | 82.84 | 83.09 | 35844600.0 |
| 2008-11-12 | GLD | ETF | 71.45 | 71.89 | 69.77 | 70.0 | 10033400.0 |
| 2008-11-12 | TLT | ETF | 95.58 | 96.07 | 95.16 | 95.61 | 1199400.0 |
| 2008-11-12 | AAXJ | ETF | 30.47 | 30.57 | 29.5 | 29.5 | 61400.0 |
| 2008-11-12 | ACWI | ETF | 30.61 | 31.0 | 29.69 | 29.9 | 79000.0 |
| 2008-11-12 | ACWX | ETF | 28.64 | 28.64 | 26.31 | 27.58 | 244642.0 |
| 2008-11-12 | ADRE | ETF | 25.23 | 25.48 | 24.01 | 24.13 | 471134.0 |
| 2008-11-12 | AFK | ETF | 22.24 | 22.24 | 21.51 | 22.22 | 5705.0 |
| 2008-11-12 | AGG | ETF | 97.58 | 97.61 | 96.03 | 96.36 | 823300.0 |
| 2008-11-12 | AGZ | ETF | 102.92 | 103.23 | 102.92 | 103.23 | 6100.0 |
| 2008-11-12 | AIA | ETF | 24.4 | 24.4 | 22.86 | 23.42 | 27523.0 |
| 2008-11-12 | AIQ | ETF | 43.85 | 44.55 | 42.25 | 42.35 | 35721.0 |
| 2008-11-12 | AIS | ETF | 0.5 | 0.5 | 0.44 | 0.47 | 37400.0 |
| 2008-11-12 | AIVI | ETF | 34.85 | 35.2 | 33.85 | 33.87 | 72500.0 |
| 2008-11-12 | AOA | ETF | 23.84 | 23.84 | 23.84 | 23.84 | 100.0 |
| 2008-11-12 | AOR | ETF | 25.42 | 25.42 | 25.42 | 25.42 | 100.0 |
| 2008-11-12 | ARB | ETF | 27.26 | 27.41 | 26.01 | 26.12 | 223796.0 |
| 2008-11-12 | BAL | ETF | 23.31 | 23.31 | 23.19 | 23.19 | 1600.0 |
| 2008-11-12 | BBH | ETF | 55.9333 | 56.33 | 55.29 | 55.29 | 436200.0 |
| 2008-11-12 | BIL | ETF | 91.88 | 91.92 | 91.82 | 91.9 | 109050.0 |
| 2008-11-12 | BITS | ETF | 14.64 | 14.64 | 12.8 | 13.56 | 3562.0 |
| 2008-11-12 | BIV | ETF | 72.74 | 72.74 | 71.47 | 72.59 | 54400.0 |
| 2008-11-12 | BJK | ETF | 16.47 | 16.47 | 14.65 | 15.55 | 24200.0 |
| 2008-11-12 | BKF | ETF | 23.45 | 23.45 | 21.5 | 21.75 | 45732.0 |
| 2008-11-12 | BLV | ETF | 68.3 | 68.32 | 67.8 | 68.0 | 13500.0 |
| 2008-11-12 | BMVP | ETF | 10.2267 | 10.2833 | 9.89 | 9.9221 | 33437.0 |
| 2008-11-12 | BND | ETF | 74.95 | 74.95 | 73.92 | 74.55 | 160600.0 |
| 2008-11-12 | BNE | ETF | 4.93 | 5.08 | 3.76 | 3.76 | 246362.0 |
| 2008-11-12 | BRF | ETF | 14.88 | 14.89 | 14.88 | 14.88 | 11700.0 |
| 2008-11-12 | BSV | ETF | 77.0 | 77.48 | 76.22 | 77.32 | 104700.0 |
| 2008-11-12 | BTF | ETF | 45.099999999999994 | 46.699999999999996 | 44.05 | 45.59949999999999 | 88059.0 |
| 2008-11-12 | BWX | ETF | 24.2 | 24.57 | 24.2 | 24.5 | 151888.0 |
| 2008-11-12 | CBON | ETF | 3.48 | 3.5 | 3.0 | 3.07 | 138841.0 |
| 2008-11-12 | CDL | ETF | 0.21 | 0.247 | 0.2 | 0.2 | 1073144.0 |
| 2008-11-12 | CEF | ETF | 8.87 | 8.95 | 8.51 | 8.57 | 649600.0 |
| 2008-11-12 | CGO | ETF | 8.9 | 8.96 | 8.65 | 8.86 | 21789.0 |
| 2008-11-12 | CGW | ETF | 14.88 | 15.075 | 14.28 | 14.3 | 48580.0 |
| 2008-11-12 | CHB | ETF | 1.31 | 1.36 | 0.83 | 0.95 | 1634794.0 |
| 2008-11-12 | CHI | ETF | 8.01 | 8.28 | 7.48 | 7.7199 | 239718.0 |
| 2008-11-12 | CHIC | ETF | 6.69 | 8.6 | 6.3 | 8.15 | 2136781.0 |
| 2008-11-12 | CHW | ETF | 5.55 | 5.8 | 5.09 | 5.8 | 191776.0 |
| 2008-11-12 | CHY | ETF | 8.36 | 8.36 | 7.46 | 7.48 | 277683.0 |
| 2008-11-12 | CMF | ETF | 51.485 | 52.415 | 51.025 | 51.405 | 30758.0 |
| 2008-11-12 | CNXT | ETF | 1.37 | 1.37 | 1.2 | 1.22 | 361040.0 |
| 2008-11-12 | COW | ETF | 35.72 | 35.83 | 35.17 | 35.26 | 11120.0 |
| 2008-11-12 | CPST | ETF | 1.19 | 1.2 | 1.12 | 1.13 | 1594321.0 |
| 2008-11-12 | CSA | ETF | 10.24 | 10.34 | 9.79 | 9.8 | 184782.0 |
> showing 50 of 613 rows — these rows as CSV