PREVIEW / etf_daily / 2008-10-27
file: by_date/etf_daily/2008/2008-10-27.parquet size: 27 KB rows: 604
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-27 | SPY | ETF | 85.97 | 89.51 | 83.7 | 83.95 | 397288600.0 |
| 2008-10-27 | QQQ | ETF | 29.14 | 30.2 | 28.66 | 28.69 | 239493669.0 |
| 2008-10-27 | IWM | ETF | 46.12 | 47.67 | 44.7 | 44.86 | 99416400.0 |
| 2008-10-27 | DIA | ETF | 82.58 | 85.98 | 80.26 | 80.26 | 37137800.0 |
| 2008-10-27 | GLD | ETF | 71.13 | 73.61 | 70.72 | 72.18 | 12150600.0 |
| 2008-10-27 | TLT | ETF | 97.77 | 98.21 | 96.29 | 96.8 | 1534100.0 |
| 2008-10-27 | AAXJ | ETF | 27.0 | 27.76 | 26.28 | 26.41 | 109300.0 |
| 2008-10-27 | ACWI | ETF | 28.8 | 29.67 | 28.18 | 28.19 | 253000.0 |
| 2008-10-27 | ACWX | ETF | 26.1518 | 26.65 | 25.54 | 25.54 | 167107.0 |
| 2008-10-27 | ADRE | ETF | 21.5 | 22.5 | 21.25 | 21.37 | 512350.0 |
| 2008-10-27 | AFK | ETF | 22.09 | 22.1 | 21.83 | 22.0599 | 7860.0 |
| 2008-10-27 | AGG | ETF | 94.7 | 95.85 | 93.7 | 94.25 | 675400.0 |
| 2008-10-27 | AIA | ETF | 21.16 | 21.78 | 20.83 | 20.8301 | 20481.0 |
| 2008-10-27 | AIQ | ETF | 36.85 | 36.9 | 33.45 | 33.5 | 38557.0 |
| 2008-10-27 | AIS | ETF | 0.45 | 0.49 | 0.44 | 0.47 | 29100.0 |
| 2008-10-27 | AIVI | ETF | 33.19 | 33.75 | 32.46 | 33.4 | 98400.0 |
| 2008-10-27 | ARB | ETF | 28.42 | 28.42 | 26.95 | 27.02 | 466065.0 |
| 2008-10-27 | BAL | ETF | 29.0 | 29.13 | 29.0 | 29.13 | 235.0 |
| 2008-10-27 | BBH | ETF | 54.0 | 55.1733 | 53.3767 | 53.4 | 547200.0 |
| 2008-10-27 | BIL | ETF | 91.9 | 91.9 | 91.78 | 91.9 | 149750.0 |
| 2008-10-27 | BITS | ETF | 15.04 | 15.76 | 15.04 | 15.68 | 1220.0 |
| 2008-10-27 | BIV | ETF | 71.78 | 71.89 | 71.18 | 71.43 | 46000.0 |
| 2008-10-27 | BJK | ETF | 14.0 | 15.0 | 14.0 | 14.85 | 700.0 |
| 2008-10-27 | BKF | ETF | 18.69 | 19.719 | 18.19 | 19.15 | 118941.0 |
| 2008-10-27 | BLV | ETF | 67.99 | 67.99 | 67.12 | 67.12 | 33100.0 |
| 2008-10-27 | BMVP | ETF | 9.75 | 10.13 | 9.69 | 9.7 | 104508.0 |
| 2008-10-27 | BND | ETF | 74.04 | 74.34 | 73.24 | 73.7 | 242800.0 |
| 2008-10-27 | BNE | ETF | 5.74 | 6.27 | 5.74 | 5.94 | 110000.0 |
| 2008-10-27 | BRF | ETF | 14.77 | 14.98 | 14.77 | 14.78 | 16050.0 |
| 2008-10-27 | BSV | ETF | 75.01 | 75.88 | 74.97 | 75.33 | 83400.0 |
| 2008-10-27 | BTF | ETF | 62.99999999999999 | 63.4 | 57.8 | 57.8 | 35703.200000000004 |
| 2008-10-27 | BWX | ETF | 24.205 | 24.557 | 24.125 | 24.13 | 541038.0 |
| 2008-10-27 | CBON | ETF | 2.8 | 2.84 | 2.4 | 2.4 | 196758.0 |
| 2008-10-27 | CDL | ETF | 0.27 | 0.34 | 0.2598 | 0.291 | 617826.0 |
| 2008-10-27 | CEF | ETF | 8.32 | 8.7 | 8.26 | 8.46 | 890600.0 |
| 2008-10-27 | CGO | ETF | 8.44 | 8.89 | 8.44 | 8.8 | 24555.0 |
| 2008-10-27 | CGW | ETF | 12.97 | 13.804 | 12.9659 | 13.21 | 180547.0 |
| 2008-10-27 | CHB | ETF | 2.12 | 2.3 | 1.8 | 1.8 | 1083887.0 |
| 2008-10-27 | CHI | ETF | 8.9 | 8.9801 | 8.6001 | 8.76 | 148784.0 |
| 2008-10-27 | CHIC | ETF | 7.01 | 7.35 | 6.63 | 6.63 | 379373.0 |
| 2008-10-27 | CHW | ETF | 5.52 | 5.6 | 5.3 | 5.4 | 194543.0 |
| 2008-10-27 | CHY | ETF | 8.32 | 8.85 | 8.06 | 8.44 | 223610.0 |
| 2008-10-27 | CMF | ETF | 48.615 | 50.3475 | 48.615 | 49.27 | 18904.0 |
| 2008-10-27 | CNXT | ETF | 1.71 | 1.73 | 1.56 | 1.56 | 861446.0 |
| 2008-10-27 | COW | ETF | 34.97 | 35.8656 | 34.96 | 35.48 | 136279.0 |
| 2008-10-27 | CPST | ETF | 1.15 | 1.19 | 1.11 | 1.16 | 1219125.0 |
| 2008-10-27 | CSA | ETF | 9.95 | 10.23 | 9.38 | 9.43 | 121037.0 |
| 2008-10-27 | CSB | ETF | 13.96 | 14.96 | 13.55 | 14.5 | 35840.0 |
| 2008-10-27 | CSD | ETF | 11.83 | 11.9 | 11.8 | 11.9 | 2300.0 |
| 2008-10-27 | CSQ | ETF | 6.2 | 6.58 | 6.14 | 6.55 | 787472.0 |
> showing 50 of 604 rows — these rows as CSV