PREVIEW / etf_daily / 2008-11-25
file: by_date/etf_daily/2008/2008-11-25.parquet size: 28 KB rows: 629
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-11-25 | SPY | ETF | 87.3 | 87.51 | 83.82 | 85.66 | 454112400.0 |
| 2008-11-25 | QQQ | ETF | 28.62 | 28.64 | 27.52 | 28.17 | 203052528.0 |
| 2008-11-25 | IWM | ETF | 44.22 | 44.42 | 42.66 | 44.22 | 80072400.0 |
| 2008-11-25 | DIA | ETF | 85.43 | 86.07 | 82.79 | 84.81 | 44571400.0 |
| 2008-11-25 | GLD | ETF | 81.34 | 81.38 | 79.28 | 80.87 | 17522100.0 |
| 2008-11-25 | TLT | ETF | 103.95 | 104.47 | 102.68 | 104.29 | 2632700.0 |
| 2008-11-25 | AAXJ | ETF | 30.0 | 30.0 | 28.17 | 28.88 | 307800.0 |
| 2008-11-25 | ACWI | ETF | 30.28 | 31.37 | 29.0 | 29.9 | 623600.0 |
| 2008-11-25 | ACWX | ETF | 28.42 | 28.42 | 27.17 | 27.9 | 153172.0 |
| 2008-11-25 | ADRE | ETF | 24.7 | 24.71 | 23.47 | 23.92 | 675411.0 |
| 2008-11-25 | AGG | ETF | 97.74 | 99.12 | 97.67 | 99.02 | 1049800.0 |
| 2008-11-25 | AGZ | ETF | 103.29 | 103.968 | 103.29 | 103.968 | 22930.0 |
| 2008-11-25 | AIA | ETF | 23.52 | 23.52 | 21.69 | 22.26 | 37973.0 |
| 2008-11-25 | AIQ | ETF | 37.55 | 37.7 | 36.6 | 37.5 | 55576.0 |
| 2008-11-25 | AIS | ETF | 0.38 | 0.4 | 0.35 | 0.4 | 69830.0 |
| 2008-11-25 | AIVI | ETF | 34.85 | 34.95 | 33.25 | 34.6 | 62800.0 |
| 2008-11-25 | AOA | ETF | 25.5 | 25.5 | 21.9 | 22.46 | 9100.0 |
| 2008-11-25 | AOK | ETF | 25.2 | 25.92 | 24.34 | 25.674 | 5490.0 |
| 2008-11-25 | AOM | ETF | 25.13 | 25.13 | 23.97 | 23.97 | 6900.0 |
| 2008-11-25 | AOR | ETF | 23.63 | 23.84 | 23.496 | 23.496 | 9521.0 |
| 2008-11-25 | ARB | ETF | 14.58 | 15.07 | 14.235 | 14.44 | 571505.0 |
| 2008-11-25 | BBH | ETF | 54.66 | 54.66 | 51.3333 | 53.64 | 231300.0 |
| 2008-11-25 | BIL | ETF | 91.9 | 91.92 | 91.84 | 91.9 | 68400.0 |
| 2008-11-25 | BITS | ETF | 16.04 | 16.04 | 15.4 | 15.96 | 1150.0 |
| 2008-11-25 | BIV | ETF | 73.91 | 74.35 | 73.47 | 74.24 | 102100.0 |
| 2008-11-25 | BJK | ETF | 15.84 | 15.84 | 15.73 | 15.73 | 400.0 |
| 2008-11-25 | BKF | ETF | 23.45 | 23.45 | 21.86 | 22.4 | 93314.0 |
| 2008-11-25 | BLV | ETF | 71.54 | 72.02 | 71.45 | 71.63 | 7600.0 |
| 2008-11-25 | BMVP | ETF | 10.12 | 10.12 | 9.78 | 10.02 | 58791.0 |
| 2008-11-25 | BND | ETF | 74.35 | 75.72 | 74.3 | 75.46 | 340200.0 |
| 2008-11-25 | BNE | ETF | 2.19 | 2.7 | 2.08 | 2.7 | 219416.0 |
| 2008-11-25 | BRF | ETF | 14.92 | 14.923 | 14.91 | 14.923 | 10700.0 |
| 2008-11-25 | BSV | ETF | 77.94 | 78.34 | 77.5 | 78.33 | 109200.0 |
| 2008-11-25 | BTF | ETF | 41.65 | 42.35 | 40.99999999999999 | 42.15 | 16564.8 |
| 2008-11-25 | BWX | ETF | 25.365 | 25.4 | 25.2 | 25.3 | 281746.0 |
| 2008-11-25 | CBON | ETF | 2.33 | 2.43 | 2.1892 | 2.25 | 80294.0 |
| 2008-11-25 | CDL | ETF | 0.19 | 0.2 | 0.12 | 0.17 | 3142178.0 |
| 2008-11-25 | CEF | ETF | 10.03 | 10.19 | 9.7 | 10.01 | 852700.0 |
| 2008-11-25 | CGO | ETF | 8.8 | 8.91 | 7.77 | 8.06 | 20985.0 |
| 2008-11-25 | CGW | ETF | 14.33 | 14.55 | 14.07 | 14.5 | 32929.0 |
| 2008-11-25 | CHB | ETF | 0.79 | 0.8 | 0.53 | 0.6 | 1225319.0 |
| 2008-11-25 | CHI | ETF | 6.75 | 7.07 | 6.55 | 6.8 | 209156.0 |
| 2008-11-25 | CHIC | ETF | 4.73 | 4.93 | 4.23 | 4.47 | 228050.0 |
| 2008-11-25 | CHW | ETF | 4.72 | 4.79 | 4.58 | 4.79 | 177609.0 |
| 2008-11-25 | CHY | ETF | 6.46 | 6.54 | 5.97 | 6.32 | 330126.0 |
| 2008-11-25 | CMF | ETF | 49.355 | 49.3875 | 48.25 | 48.25 | 61472.0 |
| 2008-11-25 | CNXT | ETF | 0.7167 | 0.93 | 0.7167 | 0.92 | 666884.0 |
| 2008-11-25 | COW | ETF | 34.62 | 34.788 | 34.33 | 34.7 | 31335.0 |
| 2008-11-25 | CPST | ETF | 0.77 | 0.85 | 0.75 | 0.85 | 1481240.0 |
| 2008-11-25 | CSA | ETF | 8.46 | 8.79 | 7.63 | 8.08 | 254729.0 |
> showing 50 of 629 rows — these rows as CSV