PREVIEW / etf_daily / 2008-12-30
file: by_date/etf_daily/2008/2008-12-30.parquet size: 28 KB rows: 632
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-12-30 | SPY | ETF | 87.51 | 89.05 | 86.88 | 88.97 | 168256300.0 |
| 2008-12-30 | QQQ | ETF | 28.98 | 29.59 | 28.94 | 29.49 | 77131105.0 |
| 2008-12-30 | IWM | ETF | 47.08 | 48.2 | 46.77 | 48.12 | 38835200.0 |
| 2008-12-30 | DIA | ETF | 85.25 | 86.78 | 84.86 | 86.68 | 17764500.0 |
| 2008-12-30 | GLD | ETF | 85.94 | 86.15 | 85.28 | 85.9 | 7123000.0 |
| 2008-12-30 | TLT | ETF | 120.49 | 121.92 | 120.07 | 121.9 | 2590500.0 |
| 2008-12-30 | AAXJ | ETF | 33.19 | 33.55 | 32.75 | 33.2 | 169000.0 |
| 2008-12-30 | ACWI | ETF | 31.02 | 31.92 | 31.02 | 31.92 | 202500.0 |
| 2008-12-30 | ACWX | ETF | 30.02 | 30.35 | 29.785 | 30.35 | 313547.0 |
| 2008-12-30 | ADRE | ETF | 26.1 | 27.0 | 26.1 | 26.94 | 174122.0 |
| 2008-12-30 | AFK | ETF | 21.49 | 21.49 | 21.34 | 21.36 | 3900.0 |
| 2008-12-30 | AGG | ETF | 103.66 | 104.35 | 103.55 | 104.13 | 570300.0 |
| 2008-12-30 | AGQ | ETF | 58.66 | 60.82 | 58.16 | 58.86 | 33950.0 |
| 2008-12-30 | AGZ | ETF | 108.32 | 108.32 | 107.53 | 107.565 | 400.0 |
| 2008-12-30 | AIA | ETF | 25.48 | 26.3 | 24.58 | 25.265 | 12846.0 |
| 2008-12-30 | AIQ | ETF | 36.75 | 37.2 | 35.8 | 37.2 | 50982.0 |
| 2008-12-30 | AIS | ETF | 0.3 | 0.34 | 0.3 | 0.34 | 294932.0 |
| 2008-12-30 | AIVI | ETF | 33.21 | 33.68 | 32.92 | 33.68 | 46100.0 |
| 2008-12-30 | AOA | ETF | 23.73 | 23.79 | 23.68 | 23.7 | 32500.0 |
| 2008-12-30 | AOK | ETF | 26.09 | 26.09 | 25.492 | 25.5068 | 2800.0 |
| 2008-12-30 | AOM | ETF | 25.53 | 25.9 | 25.11 | 25.9 | 25756.0 |
| 2008-12-30 | AOR | ETF | 25.14 | 25.15 | 24.11 | 24.5892 | 4169.0 |
| 2008-12-30 | ARB | ETF | 11.64 | 11.91 | 11.38 | 11.88 | 222602.0 |
| 2008-12-30 | BAL | ETF | 27.65 | 28.13 | 27.47 | 28.1 | 2200.0 |
| 2008-12-30 | BBH | ETF | 56.6533 | 57.08 | 56.4767 | 57.08 | 261300.0 |
| 2008-12-30 | BIL | ETF | 91.7 | 91.78 | 91.6 | 91.78 | 125200.0 |
| 2008-12-30 | BITS | ETF | 17.6 | 18.704 | 16.52 | 18.4 | 6184.0 |
| 2008-12-30 | BIV | ETF | 79.0 | 79.72 | 78.88 | 79.71 | 91200.0 |
| 2008-12-30 | BJK | ETF | 17.14 | 17.34 | 17.14 | 17.34 | 800.0 |
| 2008-12-30 | BKF | ETF | 24.12 | 24.55 | 23.95 | 24.15 | 50143.0 |
| 2008-12-30 | BLV | ETF | 80.64 | 81.1 | 80.0 | 81.1 | 19100.0 |
| 2008-12-30 | BMVP | ETF | 10.4 | 10.66 | 10.4 | 10.65 | 440300.0 |
| 2008-12-30 | BND | ETF | 78.25 | 78.9 | 78.17 | 78.87 | 292500.0 |
| 2008-12-30 | BNE | ETF | 5.01 | 5.53 | 4.92 | 5.51 | 130744.0 |
| 2008-12-30 | BSV | ETF | 79.43 | 80.27 | 79.1 | 80.23 | 189700.0 |
| 2008-12-30 | BTF | ETF | 46.9 | 47.0 | 46.050000000000004 | 47.0 | 12062.400000000001 |
| 2008-12-30 | BWX | ETF | 27.425 | 27.46 | 27.255 | 27.4 | 404780.0 |
| 2008-12-30 | CBON | ETF | 3.1 | 3.15 | 2.7 | 3.07 | 44961.0 |
| 2008-12-30 | CDL | ETF | 0.165 | 0.19 | 0.15 | 0.16 | 803058.0 |
| 2008-12-30 | CEF | ETF | 11.08 | 11.14 | 10.82 | 10.92 | 860800.0 |
| 2008-12-30 | CGO | ETF | 9.83 | 9.83 | 9.0 | 9.32 | 57119.0 |
| 2008-12-30 | CGW | ETF | 13.4 | 14.04 | 13.4 | 14.04 | 110003.0 |
| 2008-12-30 | CHB | ETF | 0.66 | 0.6836 | 0.6004 | 0.67 | 580213.0 |
| 2008-12-30 | CHI | ETF | 8.1 | 8.1 | 7.88 | 8.0 | 321418.0 |
| 2008-12-30 | CHIC | ETF | 6.19 | 6.41 | 5.97 | 6.18 | 195713.0 |
| 2008-12-30 | CHW | ETF | 5.44 | 5.64 | 5.44 | 5.59 | 343196.0 |
| 2008-12-30 | CHY | ETF | 8.02 | 8.16 | 7.8 | 8.16 | 241036.0 |
| 2008-12-30 | CMF | ETF | 50.525 | 50.555 | 49.8 | 49.805 | 21138.0 |
| 2008-12-30 | CNXT | ETF | 0.67 | 0.67 | 0.65 | 0.65 | 440858.0 |
| 2008-12-30 | COW | ETF | 33.4 | 33.45 | 33.19 | 33.19 | 37710.0 |
> showing 50 of 632 rows — these rows as CSV