PREVIEW / etf_daily / 2008-10-22
file: by_date/etf_daily/2008/2008-10-22.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-10-22 | SPY | ETF | 93.2 | 95.86 | 87.53 | 90.64 | 516168000.0 |
| 2008-10-22 | QQQ | ETF | 31.39 | 31.6 | 29.71 | 30.61 | 289993539.0 |
| 2008-10-22 | IWM | ETF | 51.76 | 52.46 | 49.31 | 50.49 | 91861700.0 |
| 2008-10-22 | DIA | ETF | 88.06 | 88.42 | 83.33 | 85.5 | 37459500.0 |
| 2008-10-22 | GLD | ETF | 74.44 | 74.45 | 66.0 | 71.71 | 23283700.0 |
| 2008-10-22 | TLT | ETF | 96.12 | 97.49 | 95.85 | 97.05 | 1069800.0 |
| 2008-10-22 | AAXJ | ETF | 31.56 | 31.56 | 29.46 | 29.9 | 144500.0 |
| 2008-10-22 | ACWI | ETF | 32.28 | 32.28 | 30.0 | 30.77 | 75100.0 |
| 2008-10-22 | ACWX | ETF | 29.81 | 29.81 | 27.931 | 28.5 | 80222.0 |
| 2008-10-22 | ADRE | ETF | 26.7 | 26.7 | 23.52 | 24.19 | 502275.0 |
| 2008-10-22 | AFK | ETF | 24.0 | 24.0 | 22.956 | 23.45 | 1530.0 |
| 2008-10-22 | AGG | ETF | 97.27 | 98.0 | 96.75 | 97.73 | 666800.0 |
| 2008-10-22 | AIA | ETF | 24.99 | 25.62 | 23.0 | 23.41 | 36857.0 |
| 2008-10-22 | AIQ | ETF | 41.25 | 41.25 | 38.65 | 38.8 | 113309.0 |
| 2008-10-22 | AIS | ETF | 0.4505 | 0.49 | 0.45 | 0.49 | 12015.0 |
| 2008-10-22 | AIVI | ETF | 38.07 | 38.09 | 35.84 | 35.93 | 22000.0 |
| 2008-10-22 | ARB | ETF | 33.11 | 33.11 | 31.13 | 31.92 | 789726.0 |
| 2008-10-22 | BAL | ETF | 31.04 | 31.04 | 31.04 | 31.04 | 500.0 |
| 2008-10-22 | BBH | ETF | 55.77 | 56.5067 | 54.4767 | 55.1133 | 757800.0 |
| 2008-10-22 | BIL | ETF | 91.84 | 91.94 | 91.7 | 91.74 | 180900.0 |
| 2008-10-22 | BITS | ETF | 14.0404 | 16.92 | 14.0404 | 16.92 | 1475.0 |
| 2008-10-22 | BIV | ETF | 72.1 | 72.33 | 71.68 | 72.33 | 69400.0 |
| 2008-10-22 | BJK | ETF | 17.53 | 17.6 | 16.53 | 17.6 | 1500.0 |
| 2008-10-22 | BKF | ETF | 23.63 | 23.63 | 21.53 | 22.02 | 109160.0 |
| 2008-10-22 | BLV | ETF | 67.19 | 68.67 | 66.82 | 68.04 | 21100.0 |
| 2008-10-22 | BMVP | ETF | 10.5967 | 10.6467 | 10.0735 | 10.3098 | 36187.0 |
| 2008-10-22 | BND | ETF | 74.78 | 75.43 | 74.56 | 75.31 | 416900.0 |
| 2008-10-22 | BNE | ETF | 6.21 | 6.45 | 5.97 | 6.17 | 102482.0 |
| 2008-10-22 | BRF | ETF | 14.87 | 14.87 | 14.82 | 14.82 | 4440.0 |
| 2008-10-22 | BSV | ETF | 75.98 | 76.0 | 75.23 | 75.97 | 97200.0 |
| 2008-10-22 | BTF | ETF | 68.2 | 68.20049999999999 | 65.14999999999999 | 66.5 | 30212.800000000003 |
| 2008-10-22 | BWX | ETF | 24.67 | 24.7 | 24.445 | 24.4975 | 162882.0 |
| 2008-10-22 | CBON | ETF | 4.25 | 4.25 | 3.86 | 3.96 | 21795.0 |
| 2008-10-22 | CDL | ETF | 0.24 | 0.35 | 0.2116 | 0.27 | 6846806.0 |
| 2008-10-22 | CEF | ETF | 8.88 | 9.12 | 8.27 | 8.6 | 2068600.0 |
| 2008-10-22 | CGO | ETF | 9.9 | 9.99 | 9.45 | 9.45 | 25372.0 |
| 2008-10-22 | CGW | ETF | 15.53 | 15.55 | 14.26 | 14.56 | 52034.0 |
| 2008-10-22 | CHB | ETF | 3.37 | 3.42 | 2.95 | 3.13 | 1336766.0 |
| 2008-10-22 | CHI | ETF | 8.87 | 9.22 | 8.51 | 8.76 | 189373.0 |
| 2008-10-22 | CHIC | ETF | 7.47 | 7.67 | 7.06 | 7.53 | 555316.0 |
| 2008-10-22 | CHW | ETF | 6.35 | 6.35 | 6.0 | 6.11 | 208336.0 |
| 2008-10-22 | CHY | ETF | 8.69 | 8.8 | 8.31 | 8.58 | 180935.0 |
| 2008-10-22 | CMF | ETF | 47.58 | 48.475 | 47.5275 | 48.445 | 25544.0 |
| 2008-10-22 | CNXT | ETF | 2.42 | 2.55 | 2.21 | 2.26 | 294295.0 |
| 2008-10-22 | COW | ETF | 36.03 | 36.32 | 35.85 | 36.01 | 93129.0 |
| 2008-10-22 | CPST | ETF | 1.33 | 1.35 | 1.26 | 1.26 | 2514474.0 |
| 2008-10-22 | CSA | ETF | 12.0 | 12.2 | 11.1 | 11.29 | 109572.0 |
| 2008-10-22 | CSB | ETF | 15.45 | 15.49 | 14.61 | 15.16 | 32800.0 |
| 2008-10-22 | CSD | ETF | 12.64 | 12.66 | 12.42 | 12.66 | 400.0 |
| 2008-10-22 | CSQ | ETF | 7.0 | 7.0 | 6.41 | 6.62 | 517174.0 |
> showing 50 of 606 rows — these rows as CSV