PREVIEW / etf_daily / 2007-11-21
file: by_date/etf_daily/2007/2007-11-21.parquet size: 24 KB rows: 536
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-21 | SPY | ETF | 143.08 | 143.91 | 141.67 | 141.68 | 259012400.0 |
| 2007-11-21 | QQQ | ETF | 49.43 | 50.17 | 48.85 | 49.31 | 212724152.0 |
| 2007-11-21 | IWM | ETF | 74.56 | 74.7 | 73.0 | 73.5 | 94961400.0 |
| 2007-11-21 | DIA | ETF | 129.12 | 129.64 | 127.79 | 127.79 | 18182400.0 |
| 2007-11-21 | GLD | ETF | 79.3 | 79.55 | 78.56 | 79.36 | 7264100.0 |
| 2007-11-21 | TLT | ETF | 93.4 | 93.58 | 93.24 | 93.45 | 1297800.0 |
| 2007-11-21 | ADRE | ETF | 52.1 | 52.3099 | 50.85 | 51.41 | 456519.0 |
| 2007-11-21 | AGG | ETF | 101.41 | 101.77 | 101.18 | 101.77 | 789200.0 |
| 2007-11-21 | AIA | ETF | 47.1 | 47.1 | 45.61 | 45.98 | 1700.0 |
| 2007-11-21 | AIQ | ETF | 44.2 | 45.0 | 43.15 | 44.35 | 20120.0 |
| 2007-11-21 | AIS | ETF | 1.1 | 1.1 | 1.02 | 1.05 | 182700.0 |
| 2007-11-21 | AIVI | ETF | 71.27 | 71.27 | 70.33 | 70.54 | 30400.0 |
| 2007-11-21 | ARB | ETF | 50.94 | 51.66 | 50.6 | 50.92 | 221300.0 |
| 2007-11-21 | BBH | ETF | 57.82 | 58.2433 | 57.3267 | 57.3267 | 272700.0 |
| 2007-11-21 | BIL | ETF | 91.84 | 91.88 | 91.78 | 91.88 | 33550.0 |
| 2007-11-21 | BITS | ETF | 23.0404 | 23.56 | 21.88 | 22.56 | 8908.0 |
| 2007-11-21 | BIV | ETF | 77.59 | 77.67 | 77.33 | 77.62 | 14200.0 |
| 2007-11-21 | BKF | ETF | 55.66 | 55.66 | 54.84 | 55.14 | 9700.0 |
| 2007-11-21 | BLV | ETF | 77.34 | 77.34 | 76.97 | 77.2 | 4300.0 |
| 2007-11-21 | BMVP | ETF | 16.6333 | 16.68 | 16.4667 | 16.4867 | 68400.0 |
| 2007-11-21 | BND | ETF | 76.84 | 77.01 | 76.73 | 77.0 | 49300.0 |
| 2007-11-21 | BNE | ETF | 16.33 | 16.43 | 15.89 | 15.93 | 138600.0 |
| 2007-11-21 | BRF | ETF | 14.59 | 14.6 | 14.59 | 14.6 | 4500.0 |
| 2007-11-21 | BSV | ETF | 77.14 | 78.32 | 77.14 | 77.4 | 61400.0 |
| 2007-11-21 | BTF | ETF | 109.8 | 110.44999999999999 | 109.45 | 109.94999999999999 | 940.0 |
| 2007-11-21 | BWX | ETF | 27.5 | 27.5 | 27.35 | 27.445 | 278600.0 |
| 2007-11-21 | CBON | ETF | 18.35 | 18.64 | 18.18 | 18.33 | 41372.0 |
| 2007-11-21 | CDL | ETF | 2.25 | 2.25 | 2.19 | 2.23 | 1709330.0 |
| 2007-11-21 | CEF | ETF | 10.79 | 10.79 | 10.59 | 10.72 | 347600.0 |
| 2007-11-21 | CGO | ETF | 17.9 | 17.95 | 17.75 | 17.83 | 22500.0 |
| 2007-11-21 | CGW | ETF | 26.25 | 26.25 | 24.4201 | 24.63 | 51200.0 |
| 2007-11-21 | CHB | ETF | 8.73 | 8.79 | 8.26 | 8.26 | 1378900.0 |
| 2007-11-21 | CHI | ETF | 14.77 | 15.1 | 14.51 | 14.72 | 276300.0 |
| 2007-11-21 | CHIC | ETF | 14.3 | 15.07 | 14.24 | 14.78 | 488695.0 |
| 2007-11-21 | CHW | ETF | 11.88 | 12.14 | 11.8 | 12.09 | 265600.0 |
| 2007-11-21 | CHY | ETF | 13.0 | 13.02 | 12.63 | 12.88 | 279700.0 |
| 2007-11-21 | CMF | ETF | 51.77 | 51.85 | 51.7 | 51.7 | 30800.0 |
| 2007-11-21 | CN | ETF | 56.8 | 57.21 | 55.1 | 55.9 | 379966.0 |
| 2007-11-21 | CNXT | ETF | 1.11 | 1.13 | 1.08 | 1.12 | 7150447.0 |
| 2007-11-21 | COW | ETF | 49.36 | 49.36 | 49.05 | 49.25 | 900.0 |
| 2007-11-21 | CPST | ETF | 1.25 | 1.25 | 1.18 | 1.19 | 1077033.0 |
| 2007-11-21 | CSA | ETF | 16.45 | 16.45 | 16.12 | 16.35 | 44500.0 |
| 2007-11-21 | CSD | ETF | 26.11 | 26.38 | 26.02 | 26.12 | 10500.0 |
| 2007-11-21 | CSQ | ETF | 13.02 | 13.3 | 13.02 | 13.21 | 342044.0 |
| 2007-11-21 | CUT | ETF | 23.55 | 23.55 | 23.3 | 23.5 | 24800.0 |
| 2007-11-21 | CVY | ETF | 23.7 | 23.82 | 23.56 | 23.63 | 12400.0 |
| 2007-11-21 | CWI | ETF | 27.4667 | 27.5733 | 27.32 | 27.4067 | 77700.0 |
| 2007-11-21 | CZA | ETF | 24.99 | 25.12 | 24.99 | 25.12 | 1200.0 |
| 2007-11-21 | DBA | ETF | 30.08 | 30.51 | 30.0 | 30.51 | 376800.0 |
| 2007-11-21 | DBB | ETF | 23.53 | 23.53 | 22.24 | 22.35 | 167100.0 |
> showing 50 of 536 rows — these rows as CSV