PREVIEW / etf_daily / 2008-10-30
file: by_date/etf_daily/2008/2008-10-30.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-30 | SPY | ETF | 95.78 | 96.54 | 92.9 | 96.3 | 414582100.0 |
| 2008-10-30 | QQQ | ETF | 32.67 | 33.06 | 31.98 | 32.84 | 255292076.0 |
| 2008-10-30 | IWM | ETF | 50.41 | 51.48 | 49.52 | 51.43 | 77436600.0 |
| 2008-10-30 | DIA | ETF | 92.04 | 92.66 | 89.72 | 92.5 | 42806500.0 |
| 2008-10-30 | GLD | ETF | 74.89 | 75.25 | 72.13 | 72.71 | 10891900.0 |
| 2008-10-30 | TLT | ETF | 94.5 | 94.8 | 93.8 | 94.05 | 1326000.0 |
| 2008-10-30 | AAXJ | ETF | 29.4 | 37.4 | 29.4 | 31.9 | 154200.0 |
| 2008-10-30 | ACWI | ETF | 32.45 | 33.3 | 32.29 | 33.21 | 62600.0 |
| 2008-10-30 | ACWX | ETF | 30.65 | 30.9794 | 30.21 | 30.49 | 37622.0 |
| 2008-10-30 | ADRE | ETF | 26.3 | 27.6 | 26.3 | 27.59 | 926627.0 |
| 2008-10-30 | AFK | ETF | 24.15 | 24.15 | 24.15 | 24.15 | 1000.0 |
| 2008-10-30 | AGG | ETF | 96.35 | 96.35 | 95.37 | 96.26 | 386400.0 |
| 2008-10-30 | AIA | ETF | 25.8701 | 26.35 | 25.35 | 26.03 | 16782.0 |
| 2008-10-30 | AIQ | ETF | 36.2 | 41.25 | 35.7 | 38.05 | 154768.0 |
| 2008-10-30 | AIS | ETF | 0.44 | 0.47 | 0.43 | 0.47 | 56135.0 |
| 2008-10-30 | AIVI | ETF | 37.77 | 38.1 | 36.24 | 36.6 | 75100.0 |
| 2008-10-30 | ARB | ETF | 30.96 | 31.64 | 30.73 | 31.27 | 173067.0 |
| 2008-10-30 | BAL | ETF | 29.01 | 29.09 | 28.1301 | 28.45 | 1500.0 |
| 2008-10-30 | BBH | ETF | 56.7667 | 58.0367 | 56.71 | 57.5567 | 570300.0 |
| 2008-10-30 | BIL | ETF | 91.76 | 91.9 | 91.76 | 91.9 | 110550.0 |
| 2008-10-30 | BITS | ETF | 16.24 | 16.48 | 15.36 | 16.24 | 1581.0 |
| 2008-10-30 | BIV | ETF | 71.03 | 71.25 | 70.64 | 70.8 | 55000.0 |
| 2008-10-30 | BJK | ETF | 17.5 | 18.96 | 17.0 | 18.22 | 11400.0 |
| 2008-10-30 | BKF | ETF | 24.41 | 25.5 | 24.41 | 25.5 | 73837.0 |
| 2008-10-30 | BLV | ETF | 66.66 | 66.76 | 66.4 | 66.45 | 22400.0 |
| 2008-10-30 | BMVP | ETF | 10.67 | 10.931 | 10.573 | 10.91 | 40306.0 |
| 2008-10-30 | BND | ETF | 73.74 | 73.74 | 72.73 | 73.17 | 181100.0 |
| 2008-10-30 | BNE | ETF | 7.11 | 7.36 | 6.49 | 6.82 | 122566.0 |
| 2008-10-30 | BRF | ETF | 14.81 | 14.83 | 14.81 | 14.82 | 4600.0 |
| 2008-10-30 | BSV | ETF | 76.0 | 76.0 | 75.42 | 75.74 | 64000.0 |
| 2008-10-30 | BTF | ETF | 63.949999999999996 | 63.949999999999996 | 60.49999999999999 | 60.75 | 12604.400000000001 |
| 2008-10-30 | BWX | ETF | 24.87 | 24.97 | 24.54 | 24.725 | 145998.0 |
| 2008-10-30 | CBON | ETF | 3.22 | 3.39 | 2.86 | 3.35 | 88502.0 |
| 2008-10-30 | CDL | ETF | 0.31 | 0.31 | 0.2416 | 0.28 | 1394191.0 |
| 2008-10-30 | CEF | ETF | 9.68 | 9.68 | 9.05 | 9.05 | 618900.0 |
| 2008-10-30 | CGO | ETF | 9.37 | 9.59 | 9.31 | 9.38 | 38931.0 |
| 2008-10-30 | CGW | ETF | 15.08 | 16.0 | 15.0 | 15.3 | 35715.0 |
| 2008-10-30 | CHB | ETF | 1.69 | 1.84 | 1.6 | 1.77 | 1999313.0 |
| 2008-10-30 | CHI | ETF | 9.5 | 9.6 | 9.17 | 9.35 | 116236.0 |
| 2008-10-30 | CHIC | ETF | 7.3 | 7.43 | 7.09 | 7.41 | 278044.0 |
| 2008-10-30 | CHW | ETF | 5.87 | 6.1 | 5.87 | 6.02 | 161525.0 |
| 2008-10-30 | CHY | ETF | 9.0 | 9.1422 | 8.9 | 8.98 | 205654.0 |
| 2008-10-30 | CMF | ETF | 48.685 | 49.31 | 48.495 | 48.625 | 2438.0 |
| 2008-10-30 | CNXT | ETF | 1.77 | 2.2 | 1.6 | 2.1 | 1279135.0 |
| 2008-10-30 | COW | ETF | 36.09 | 36.17 | 35.65 | 35.75 | 58845.0 |
| 2008-10-30 | CPST | ETF | 1.14 | 1.34 | 1.14 | 1.28 | 2234216.0 |
| 2008-10-30 | CSA | ETF | 10.45 | 10.7 | 10.03 | 10.41 | 70530.0 |
| 2008-10-30 | CSB | ETF | 16.5 | 16.6 | 15.66 | 16.0 | 18103.0 |
| 2008-10-30 | CSD | ETF | 13.97 | 13.97 | 13.03 | 13.21 | 12600.0 |
| 2008-10-30 | CSQ | ETF | 6.46 | 6.74 | 6.45 | 6.74 | 370267.0 |
> showing 50 of 606 rows — these rows as CSV