PREVIEW / etf_daily / 2008-11-10
file: by_date/etf_daily/2008/2008-11-10.parquet size: 27 KB rows: 606
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-10 | SPY | ETF | 95.21 | 95.53 | 90.92 | 92.63 | 301773000.0 |
| 2008-11-10 | QQQ | ETF | 31.94 | 31.97 | 30.4 | 30.77 | 142737868.0 |
| 2008-11-10 | IWM | ETF | 51.74 | 51.84 | 48.93 | 49.45 | 50459600.0 |
| 2008-11-10 | DIA | ETF | 91.67 | 91.75 | 87.71 | 88.93 | 23695900.0 |
| 2008-11-10 | GLD | ETF | 74.8 | 74.92 | 72.96 | 73.58 | 6092700.0 |
| 2008-11-10 | TLT | ETF | 93.8 | 95.1 | 93.68 | 94.72 | 1352100.0 |
| 2008-11-10 | AAXJ | ETF | 33.0 | 33.34 | 32.17 | 32.57 | 205000.0 |
| 2008-11-10 | ACWI | ETF | 33.15 | 33.31 | 31.89 | 32.47 | 64900.0 |
| 2008-11-10 | ACWX | ETF | 31.29 | 31.39 | 30.14 | 30.61 | 146624.0 |
| 2008-11-10 | ADRE | ETF | 28.24 | 28.25 | 26.72 | 27.33 | 492372.0 |
| 2008-11-10 | AFK | ETF | 22.66 | 22.66 | 22.66 | 22.66 | 3000.0 |
| 2008-11-10 | AGG | ETF | 97.29 | 97.41 | 95.91 | 96.47 | 424400.0 |
| 2008-11-10 | AIA | ETF | 26.06 | 26.32 | 24.83 | 24.83 | 18354.0 |
| 2008-11-10 | AIQ | ETF | 45.5 | 45.95 | 44.875 | 45.0 | 63676.0 |
| 2008-11-10 | AIS | ETF | 0.49 | 0.52 | 0.46 | 0.5 | 48238.0 |
| 2008-11-10 | AIVI | ETF | 38.58 | 38.75 | 36.96 | 37.32 | 26700.0 |
| 2008-11-10 | AOK | ETF | 25.09 | 25.09 | 25.0 | 25.0 | 300.0 |
| 2008-11-10 | ARB | ETF | 31.08 | 31.29 | 28.32 | 28.99 | 168767.0 |
| 2008-11-10 | BAL | ETF | 26.85 | 26.85 | 25.03 | 25.48 | 3200.0 |
| 2008-11-10 | BBH | ETF | 58.6667 | 58.7733 | 57.0967 | 57.7033 | 262800.0 |
| 2008-11-10 | BIL | ETF | 91.8 | 91.88 | 91.8 | 91.88 | 60950.0 |
| 2008-11-10 | BITS | ETF | 15.4 | 15.72 | 15.0 | 15.48 | 1600.0 |
| 2008-11-10 | BIV | ETF | 71.74 | 71.99 | 71.28 | 71.99 | 46100.0 |
| 2008-11-10 | BJK | ETF | 17.2 | 17.2 | 16.7 | 16.7 | 300.0 |
| 2008-11-10 | BKF | ETF | 26.0 | 26.8615 | 25.0 | 25.74 | 89388.0 |
| 2008-11-10 | BLV | ETF | 67.49 | 67.77 | 66.94 | 67.77 | 8300.0 |
| 2008-11-10 | BMVP | ETF | 11.25 | 11.25 | 10.54 | 10.65 | 22481.0 |
| 2008-11-10 | BND | ETF | 74.55 | 74.89 | 74.12 | 74.6 | 132800.0 |
| 2008-11-10 | BNE | ETF | 8.46 | 8.57 | 7.7912 | 7.92 | 76924.0 |
| 2008-11-10 | BRF | ETF | 14.89 | 14.94 | 14.89 | 14.9 | 1500.0 |
| 2008-11-10 | BSV | ETF | 75.93 | 76.74 | 75.9 | 76.32 | 106700.0 |
| 2008-11-10 | BTF | ETF | 62.5 | 62.5 | 57.0 | 57.55 | 20970.600000000002 |
| 2008-11-10 | BWX | ETF | 24.935 | 24.94 | 24.595 | 24.74 | 155124.0 |
| 2008-11-10 | CBON | ETF | 3.91 | 3.99 | 3.56 | 3.75 | 85408.0 |
| 2008-11-10 | CDL | ETF | 0.26 | 0.26 | 0.2 | 0.22 | 1485240.0 |
| 2008-11-10 | CEF | ETF | 9.68 | 9.71 | 9.32 | 9.45 | 505200.0 |
| 2008-11-10 | CGO | ETF | 9.54 | 9.55 | 9.15 | 9.23 | 15834.0 |
| 2008-11-10 | CGW | ETF | 15.82 | 16.32 | 15.49 | 15.79 | 74529.0 |
| 2008-11-10 | CHB | ETF | 1.78 | 1.8 | 1.47 | 1.55 | 701682.0 |
| 2008-11-10 | CHI | ETF | 9.0 | 9.0 | 8.5 | 8.56 | 114551.0 |
| 2008-11-10 | CHIC | ETF | 7.74 | 7.91 | 6.03 | 6.45 | 483217.0 |
| 2008-11-10 | CHW | ETF | 6.19 | 6.2 | 5.69 | 5.99 | 178447.0 |
| 2008-11-10 | CHY | ETF | 9.19 | 9.19 | 8.41 | 8.65 | 201854.0 |
| 2008-11-10 | CMF | ETF | 52.0 | 52.0 | 51.495 | 51.495 | 4080.0 |
| 2008-11-10 | CNXT | ETF | 1.69 | 1.69 | 1.52 | 1.52 | 229804.0 |
| 2008-11-10 | COW | ETF | 36.2 | 36.2 | 35.73 | 35.88 | 32334.0 |
| 2008-11-10 | CPST | ETF | 1.44 | 1.52 | 1.37 | 1.45 | 2662109.0 |
| 2008-11-10 | CSA | ETF | 12.0 | 12.32 | 10.64 | 10.77 | 194178.0 |
| 2008-11-10 | CSB | ETF | 16.0 | 16.75 | 15.6601 | 16.25 | 17435.0 |
| 2008-11-10 | CSD | ETF | 12.59 | 12.59 | 12.59 | 12.59 | 1000.0 |
> showing 50 of 606 rows — these rows as CSV