PREVIEW / etf_daily / 2008-06-24
file: by_date/etf_daily/2008/2008-06-24.parquet size: 27 KB rows: 594
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-06-24 | SPY | ETF | 131.05 | 132.44 | 130.19 | 131.19 | 267300600.0 |
| 2008-06-24 | QQQ | ETF | 46.83 | 47.37 | 46.41 | 46.81 | 178293711.0 |
| 2008-06-24 | IWM | ETF | 71.45 | 71.89 | 70.61 | 70.7 | 112302100.0 |
| 2008-06-24 | DIA | ETF | 118.04 | 118.95 | 117.16 | 117.94 | 19038300.0 |
| 2008-06-24 | GLD | ETF | 87.3 | 88.24 | 87.24 | 87.47 | 7398500.0 |
| 2008-06-24 | TLT | ETF | 90.38 | 90.81 | 90.14 | 90.6 | 3118400.0 |
| 2008-06-24 | ACWI | ETF | 50.0 | 50.47 | 49.74 | 49.86 | 49500.0 |
| 2008-06-24 | ACWX | ETF | 50.7 | 51.05 | 50.65 | 50.65 | 10128.0 |
| 2008-06-24 | ADRE | ETF | 50.19 | 51.242 | 50.1 | 50.67 | 415795.0 |
| 2008-06-24 | AGG | ETF | 99.93 | 100.07 | 99.7 | 99.93 | 514300.0 |
| 2008-06-24 | AIA | ETF | 42.12 | 42.6415 | 41.9982 | 42.3299 | 3261.0 |
| 2008-06-24 | AIQ | ETF | 44.75 | 45.4 | 43.95 | 44.0 | 75733.0 |
| 2008-06-24 | AIS | ETF | 0.72 | 0.75 | 0.7 | 0.73 | 33190.0 |
| 2008-06-24 | AIVI | ETF | 59.89 | 60.76 | 59.0 | 60.3 | 65900.0 |
| 2008-06-24 | ARB | ETF | 49.26 | 49.68 | 48.54 | 48.68 | 307302.0 |
| 2008-06-24 | BBH | ETF | 55.6333 | 56.05 | 55.4733 | 55.8167 | 270000.0 |
| 2008-06-24 | BIL | ETF | 91.78 | 91.8 | 91.76 | 91.8 | 56150.0 |
| 2008-06-24 | BITS | ETF | 24.84 | 25.8 | 24.2 | 25.8 | 3920.0 |
| 2008-06-24 | BIV | ETF | 76.13 | 76.24 | 75.97 | 76.21 | 28800.0 |
| 2008-06-24 | BJK | ETF | 33.3 | 33.31 | 32.5 | 33.3 | 1800.0 |
| 2008-06-24 | BKF | ETF | 53.15 | 53.15 | 51.62 | 52.35 | 45950.0 |
| 2008-06-24 | BLV | ETF | 73.79 | 74.14 | 73.79 | 74.1 | 7000.0 |
| 2008-06-24 | BMVP | ETF | 15.59 | 15.71 | 15.5167 | 15.5633 | 19126.0 |
| 2008-06-24 | BND | ETF | 75.7 | 75.83 | 75.55 | 75.77 | 194100.0 |
| 2008-06-24 | BNE | ETF | 13.93 | 14.18 | 13.89 | 13.99 | 245174.0 |
| 2008-06-24 | BOSS | ETF | 25.57 | 25.57 | 24.25 | 24.25 | 100.0 |
| 2008-06-24 | BRF | ETF | 14.8 | 14.8 | 14.69 | 14.7 | 19700.0 |
| 2008-06-24 | BSV | ETF | 76.92 | 76.98 | 76.77 | 76.94 | 134100.0 |
| 2008-06-24 | BTF | ETF | 95.0 | 99.0 | 87.85 | 93.55 | 18929.2 |
| 2008-06-24 | BWX | ETF | 27.305 | 27.425 | 27.2875 | 27.375 | 274284.0 |
| 2008-06-24 | CBON | ETF | 5.9 | 6.25 | 5.9 | 6.01 | 100044.0 |
| 2008-06-24 | CDL | ETF | 1.36 | 1.41 | 1.28 | 1.28 | 1057634.0 |
| 2008-06-24 | CEF | ETF | 12.48 | 12.51 | 12.31 | 12.31 | 369000.0 |
| 2008-06-24 | CGO | ETF | 15.68 | 15.78 | 15.51 | 15.54 | 32964.0 |
| 2008-06-24 | CGW | ETF | 23.76 | 23.93 | 23.572 | 23.572 | 65136.0 |
| 2008-06-24 | CHB | ETF | 6.41 | 6.5 | 6.15 | 6.23 | 2207732.0 |
| 2008-06-24 | CHI | ETF | 14.31 | 14.36 | 14.18 | 14.27 | 210352.0 |
| 2008-06-24 | CHIC | ETF | 17.63 | 18.11 | 17.19 | 17.38 | 374479.0 |
| 2008-06-24 | CHW | ETF | 11.69 | 11.9 | 11.65 | 11.66 | 157778.0 |
| 2008-06-24 | CHY | ETF | 13.43 | 13.49 | 13.3 | 13.34 | 128526.0 |
| 2008-06-24 | CMF | ETF | 50.98 | 50.98 | 50.855 | 50.9625 | 3364.0 |
| 2008-06-24 | CN | ETF | 53.3 | 54.64 | 53.11 | 54.03 | 233173.0 |
| 2008-06-24 | CNXT | ETF | 0.57 | 0.6 | 0.52 | 0.53 | 6961981.0 |
| 2008-06-24 | COW | ETF | 45.32 | 45.36 | 44.8 | 45.06 | 262093.0 |
| 2008-06-24 | CPST | ETF | 4.31 | 4.31 | 4.08 | 4.17 | 5539275.0 |
| 2008-06-24 | CSA | ETF | 17.35 | 17.53 | 17.24 | 17.45 | 73536.0 |
| 2008-06-24 | CSB | ETF | 18.75 | 19.99 | 18.75 | 19.65 | 23055.0 |
| 2008-06-24 | CSD | ETF | 22.34 | 22.44 | 22.16 | 22.37 | 12500.0 |
| 2008-06-24 | CSQ | ETF | 11.99 | 12.2 | 11.59 | 12.14 | 347846.0 |
| 2008-06-24 | CUT | ETF | 20.02 | 20.02 | 19.63 | 19.83 | 29400.0 |
> showing 50 of 594 rows — these rows as CSV