PREVIEW / etf_daily / 2008-12-18
file: by_date/etf_daily/2008/2008-12-18.parquet size: 28 KB rows: 633
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-18 | SPY | ETF | 91.4 | 91.67 | 88.21 | 89.29 | 374673300.0 |
| 2008-12-18 | QQQ | ETF | 30.19 | 30.4 | 29.36 | 29.66 | 142773809.0 |
| 2008-12-18 | IWM | ETF | 48.8 | 49.66 | 47.32 | 48.46 | 87888400.0 |
| 2008-12-18 | DIA | ETF | 88.84 | 89.04 | 85.42 | 86.36 | 26041600.0 |
| 2008-12-18 | GLD | ETF | 84.85 | 85.12 | 83.46 | 83.87 | 17234500.0 |
| 2008-12-18 | TLT | ETF | 120.74 | 123.15 | 120.45 | 122.13 | 4442000.0 |
| 2008-12-18 | AAXJ | ETF | 35.66 | 35.66 | 33.5 | 34.44 | 306500.0 |
| 2008-12-18 | ACWI | ETF | 32.28 | 32.66 | 31.52 | 31.58 | 502600.0 |
| 2008-12-18 | ACWX | ETF | 31.38 | 31.38 | 29.76 | 30.03 | 324470.0 |
| 2008-12-18 | ADRE | ETF | 28.86 | 28.86 | 27.48 | 27.67 | 173133.0 |
| 2008-12-18 | AFK | ETF | 21.49 | 21.49 | 21.2901 | 21.2901 | 10500.0 |
| 2008-12-18 | AGG | ETF | 101.91 | 102.46 | 101.12 | 102.31 | 931100.0 |
| 2008-12-18 | AGQ | ETF | 62.84 | 63.24 | 59.5 | 60.36 | 37600.0 |
| 2008-12-18 | AGZ | ETF | 108.91 | 108.98 | 108.54 | 108.928 | 12892.0 |
| 2008-12-18 | AIA | ETF | 27.99 | 27.99 | 26.4101 | 26.4101 | 14299.0 |
| 2008-12-18 | AIQ | ETF | 37.3 | 38.9 | 36.5 | 36.9 | 70225.0 |
| 2008-12-18 | AIS | ETF | 0.38 | 0.38 | 0.32 | 0.34 | 30351.0 |
| 2008-12-18 | AIVI | ETF | 37.7 | 38.04 | 36.33 | 36.63 | 61000.0 |
| 2008-12-18 | AOA | ETF | 24.39 | 24.62 | 23.9 | 24.18 | 93900.0 |
| 2008-12-18 | AOK | ETF | 25.91 | 25.98 | 25.884 | 25.98 | 850.0 |
| 2008-12-18 | AOM | ETF | 25.61 | 25.77 | 25.23 | 25.77 | 3522.0 |
| 2008-12-18 | AOR | ETF | 25.9 | 26.1 | 24.59 | 25.0 | 20560.0 |
| 2008-12-18 | ARB | ETF | 10.85 | 12.22 | 10.52 | 11.74 | 629487.0 |
| 2008-12-18 | BAL | ETF | 27.35 | 27.35 | 26.5901 | 26.703 | 915.0 |
| 2008-12-18 | BBH | ETF | 55.7633 | 56.95 | 55.5967 | 56.0533 | 476400.0 |
| 2008-12-18 | BIL | ETF | 91.78 | 91.82 | 91.5 | 91.66 | 774150.0 |
| 2008-12-18 | BITS | ETF | 17.9996 | 18.04 | 17.64 | 18.0 | 1025.0 |
| 2008-12-18 | BIV | ETF | 78.7 | 79.82 | 78.7 | 79.75 | 90000.0 |
| 2008-12-18 | BJK | ETF | 18.02 | 18.11 | 17.73 | 17.73 | 1300.0 |
| 2008-12-18 | BKF | ETF | 26.96 | 27.02 | 25.3 | 25.62 | 93175.0 |
| 2008-12-18 | BLV | ETF | 80.3 | 81.31 | 79.95 | 81.03 | 19200.0 |
| 2008-12-18 | BMVP | ETF | 10.6333 | 10.7765 | 10.42 | 10.4733 | 60393.0 |
| 2008-12-18 | BND | ETF | 77.75 | 78.17 | 77.72 | 78.07 | 201100.0 |
| 2008-12-18 | BNE | ETF | 4.63 | 4.87 | 4.3685 | 4.58 | 157032.0 |
| 2008-12-18 | BSV | ETF | 79.47 | 79.64 | 79.22 | 79.59 | 114700.0 |
| 2008-12-18 | BTF | ETF | 47.8 | 49.85 | 47.8 | 49.349999999999994 | 13120.400000000001 |
| 2008-12-18 | BWX | ETF | 27.925 | 27.925 | 27.425 | 27.46 | 436546.0 |
| 2008-12-18 | CBON | ETF | 2.33 | 2.39 | 2.26 | 2.39 | 30919.0 |
| 2008-12-18 | CDL | ETF | 0.2 | 0.24 | 0.19 | 0.19 | 1076411.0 |
| 2008-12-18 | CEF | ETF | 10.93 | 10.98 | 10.5 | 10.75 | 1088900.0 |
| 2008-12-18 | CGO | ETF | 8.48 | 8.7 | 8.48 | 8.69 | 27768.0 |
| 2008-12-18 | CGW | ETF | 15.23 | 15.52 | 14.83 | 14.94 | 66161.0 |
| 2008-12-18 | CHB | ETF | 1.04 | 1.1 | 0.88 | 0.94 | 1652098.0 |
| 2008-12-18 | CHI | ETF | 7.79 | 8.01 | 7.7494 | 8.01 | 563349.0 |
| 2008-12-18 | CHIC | ETF | 6.04 | 6.54 | 5.95 | 6.11 | 350481.0 |
| 2008-12-18 | CHW | ETF | 5.25 | 5.45 | 5.22 | 5.45 | 275612.0 |
| 2008-12-18 | CHY | ETF | 7.2 | 7.55 | 7.2 | 7.43 | 362602.0 |
| 2008-12-18 | CMF | ETF | 50.17 | 50.635 | 49.41 | 49.972 | 47950.0 |
| 2008-12-18 | CNXT | ETF | 0.8462 | 0.85 | 0.75 | 0.76 | 976398.0 |
| 2008-12-18 | COW | ETF | 34.08 | 34.1146 | 33.62 | 33.62 | 13766.0 |
> showing 50 of 633 rows — these rows as CSV