PREVIEW / etf_daily / 2008-07-08
file: by_date/etf_daily/2008/2008-07-08.parquet size: 27 KB rows: 609
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-07-08 | SPY | ETF | 124.99 | 127.39 | 124.2 | 127.24 | 375973700.0 |
| 2008-07-08 | QQQ | ETF | 44.95 | 46.01 | 44.77 | 45.97 | 206255301.0 |
| 2008-07-08 | IWM | ETF | 65.79 | 68.14 | 65.25 | 68.07 | 131778100.0 |
| 2008-07-08 | DIA | ETF | 112.25 | 113.9 | 111.74 | 113.74 | 31553000.0 |
| 2008-07-08 | GLD | ETF | 90.55 | 91.15 | 89.93 | 90.86 | 11215600.0 |
| 2008-07-08 | TLT | ETF | 92.5 | 93.14 | 92.42 | 93.09 | 2176600.0 |
| 2008-07-08 | ACWI | ETF | 47.75 | 48.12 | 47.25 | 48.12 | 3100.0 |
| 2008-07-08 | ACWX | ETF | 48.42 | 49.39 | 48.03 | 49.39 | 63468.0 |
| 2008-07-08 | ADRE | ETF | 47.86 | 48.38 | 47.13 | 48.33 | 948672.0 |
| 2008-07-08 | AGG | ETF | 100.0 | 100.4 | 99.83 | 100.32 | 327300.0 |
| 2008-07-08 | AIA | ETF | 39.76 | 40.22 | 39.76 | 40.22 | 7715.0 |
| 2008-07-08 | AIQ | ETF | 41.4 | 42.95 | 41.35 | 42.1 | 59047.0 |
| 2008-07-08 | AIS | ETF | 0.7001 | 0.72 | 0.69 | 0.72 | 38150.0 |
| 2008-07-08 | AIVI | ETF | 57.95 | 58.65 | 57.57 | 58.58 | 29000.0 |
| 2008-07-08 | ARB | ETF | 47.25 | 48.42 | 47.17 | 47.84 | 301223.0 |
| 2008-07-08 | BAL | ETF | 44.67 | 46.16 | 44.51 | 44.51 | 7700.0 |
| 2008-07-08 | BBH | ETF | 56.5533 | 58.7267 | 56.4867 | 58.65 | 890400.0 |
| 2008-07-08 | BIL | ETF | 91.72 | 91.76 | 91.66 | 91.66 | 47700.0 |
| 2008-07-08 | BITS | ETF | 24.08 | 24.96 | 23.6 | 24.72 | 2231.0 |
| 2008-07-08 | BIV | ETF | 76.8 | 76.83 | 76.44 | 76.76 | 75700.0 |
| 2008-07-08 | BJK | ETF | 30.74 | 30.74 | 29.75 | 30.55 | 3400.0 |
| 2008-07-08 | BKF | ETF | 48.75 | 49.36 | 45.89 | 49.242 | 109385.0 |
| 2008-07-08 | BLV | ETF | 74.23 | 74.78 | 74.23 | 74.69 | 3700.0 |
| 2008-07-08 | BMVP | ETF | 14.6767 | 14.9567 | 14.6357 | 14.9567 | 152182.0 |
| 2008-07-08 | BND | ETF | 75.87 | 76.24 | 75.79 | 76.17 | 92400.0 |
| 2008-07-08 | BNE | ETF | 11.36 | 11.76 | 11.32 | 11.75 | 408488.0 |
| 2008-07-08 | BRF | ETF | 14.7 | 14.7 | 14.7 | 14.7 | 100.0 |
| 2008-07-08 | BSV | ETF | 77.2 | 77.5 | 77.2 | 77.4 | 84400.0 |
| 2008-07-08 | BTF | ETF | 82.89999999999999 | 83.55 | 80.6 | 83.0 | 10225.0 |
| 2008-07-08 | BWX | ETF | 27.645 | 27.685 | 27.525 | 27.555 | 249984.0 |
| 2008-07-08 | CBON | ETF | 4.37 | 4.38 | 3.96 | 4.21 | 182155.0 |
| 2008-07-08 | CDL | ETF | 1.1 | 1.15 | 1.03 | 1.11 | 1202543.0 |
| 2008-07-08 | CEF | ETF | 13.2 | 13.25 | 12.93 | 13.08 | 473700.0 |
| 2008-07-08 | CGO | ETF | 15.14 | 15.4 | 15.02 | 15.34 | 15982.0 |
| 2008-07-08 | CGW | ETF | 22.32 | 22.72 | 22.16 | 22.72 | 181820.0 |
| 2008-07-08 | CHB | ETF | 5.04 | 5.43 | 4.67 | 5.39 | 2845285.0 |
| 2008-07-08 | CHI | ETF | 13.12 | 13.49 | 12.95 | 13.49 | 160361.0 |
| 2008-07-08 | CHIC | ETF | 16.61 | 17.64 | 16.54 | 17.22 | 317153.0 |
| 2008-07-08 | CHW | ETF | 10.7 | 10.9701 | 10.64 | 10.97 | 116343.0 |
| 2008-07-08 | CHY | ETF | 12.18 | 12.62 | 12.15 | 12.62 | 206792.0 |
| 2008-07-08 | CMF | ETF | 51.65 | 51.655 | 51.62 | 51.655 | 4650.0 |
| 2008-07-08 | CN | ETF | 55.02 | 56.54 | 54.66 | 56.11 | 795580.0 |
| 2008-07-08 | COW | ETF | 42.98 | 43.02 | 42.74 | 42.98 | 189967.0 |
| 2008-07-08 | CPST | ETF | 3.49 | 3.508 | 3.24 | 3.47 | 4598836.0 |
| 2008-07-08 | CSA | ETF | 16.18 | 17.07 | 15.97 | 17.07 | 80541.0 |
| 2008-07-08 | CSB | ETF | 17.97 | 18.2 | 16.5 | 17.2 | 18400.0 |
| 2008-07-08 | CSD | ETF | 20.5 | 20.76 | 20.31 | 20.76 | 24300.0 |
| 2008-07-08 | CSQ | ETF | 10.8 | 11.13 | 10.8 | 11.13 | 337373.0 |
| 2008-07-08 | CUT | ETF | 18.21 | 18.4 | 18.04 | 18.4 | 26000.0 |
| 2008-07-08 | CVY | ETF | 19.77 | 20.24 | 19.62 | 20.24 | 10700.0 |
> showing 50 of 609 rows — these rows as CSV