PREVIEW / etf_daily / 2007-12-03
file: by_date/etf_daily/2007/2007-12-03.parquet size: 24 KB rows: 539
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-12-03 | SPY | ETF | 148.19 | 148.45 | 147.29 | 147.68 | 146430400.0 |
| 2007-12-03 | QQQ | ETF | 51.14 | 51.53 | 50.82 | 50.88 | 108625642.0 |
| 2007-12-03 | IWM | ETF | 76.55 | 76.75 | 75.7 | 75.75 | 61964100.0 |
| 2007-12-03 | DIA | ETF | 133.69 | 134.09 | 132.98 | 133.31 | 12645700.0 |
| 2007-12-03 | GLD | ETF | 77.39 | 78.3 | 77.3 | 78.28 | 6265700.0 |
| 2007-12-03 | TLT | ETF | 94.76 | 95.1 | 94.28 | 94.75 | 1272700.0 |
| 2007-12-03 | ADRE | ETF | 55.38 | 55.39 | 54.38 | 54.71 | 598275.0 |
| 2007-12-03 | AGG | ETF | 101.9 | 102.58 | 101.74 | 102.13 | 630100.0 |
| 2007-12-03 | AIA | ETF | 50.34 | 50.34 | 49.18 | 49.18 | 5600.0 |
| 2007-12-03 | AIQ | ETF | 47.65 | 49.1 | 46.65 | 48.35 | 36160.0 |
| 2007-12-03 | AIS | ETF | 1.11 | 1.11 | 1.01 | 1.03 | 573800.0 |
| 2007-12-03 | AIVI | ETF | 73.99 | 74.04 | 72.75 | 73.74 | 11300.0 |
| 2007-12-03 | ARB | ETF | 39.5 | 40.35 | 38.73 | 40.1 | 544600.0 |
| 2007-12-03 | BBH | ETF | 60.0 | 60.0 | 59.0933 | 59.21 | 766500.0 |
| 2007-12-03 | BIL | ETF | 91.76 | 91.78 | 91.6 | 91.6 | 120050.0 |
| 2007-12-03 | BITS | ETF | 22.44 | 22.64 | 21.52 | 21.56 | 11932.0 |
| 2007-12-03 | BIV | ETF | 79.97 | 79.97 | 77.7 | 77.91 | 27100.0 |
| 2007-12-03 | BKF | ETF | 59.37 | 60.95 | 58.83 | 59.04 | 23088.0 |
| 2007-12-03 | BLV | ETF | 77.92 | 77.94 | 77.65 | 77.94 | 61600.0 |
| 2007-12-03 | BMVP | ETF | 17.137 | 17.248 | 17.103 | 17.167 | 41700.0 |
| 2007-12-03 | BND | ETF | 77.25 | 77.37 | 77.16 | 77.37 | 78700.0 |
| 2007-12-03 | BNE | ETF | 18.29 | 18.29 | 17.85 | 17.94 | 285700.0 |
| 2007-12-03 | BRF | ETF | 14.62 | 14.64 | 14.62 | 14.64 | 4000.0 |
| 2007-12-03 | BSV | ETF | 77.4 | 77.4 | 77.25 | 77.39 | 24100.0 |
| 2007-12-03 | BTF | ETF | 113.49999999999999 | 114.7495 | 113.45 | 114.60000000000001 | 2540.0 |
| 2007-12-03 | BWX | ETF | 27.73 | 27.73 | 27.0 | 27.085 | 185048.0 |
| 2007-12-03 | CBON | ETF | 18.14 | 18.79 | 18.06 | 18.6 | 46196.0 |
| 2007-12-03 | CDL | ETF | 2.37 | 2.37 | 2.1 | 2.14 | 2185120.0 |
| 2007-12-03 | CEF | ETF | 10.15 | 10.47 | 10.15 | 10.4 | 291700.0 |
| 2007-12-03 | CGO | ETF | 18.91 | 19.08 | 18.63 | 19.0 | 20200.0 |
| 2007-12-03 | CGW | ETF | 25.75 | 25.75 | 25.41 | 25.52 | 40300.0 |
| 2007-12-03 | CHB | ETF | 8.96 | 9.0 | 8.41 | 8.44 | 1375800.0 |
| 2007-12-03 | CHI | ETF | 14.56 | 15.08 | 14.56 | 15.042 | 182201.0 |
| 2007-12-03 | CHIC | ETF | 16.47 | 16.52 | 15.94 | 15.98 | 456656.0 |
| 2007-12-03 | CHW | ETF | 12.83 | 12.83 | 12.49 | 12.61 | 260800.0 |
| 2007-12-03 | CHY | ETF | 13.46 | 13.93 | 13.46 | 13.85 | 249677.0 |
| 2007-12-03 | CMF | ETF | 52.22 | 52.225 | 52.2 | 52.2 | 12200.0 |
| 2007-12-03 | CN | ETF | 62.15 | 62.1799 | 60.3 | 61.5 | 232900.0 |
| 2007-12-03 | CNXT | ETF | 1.1 | 1.11 | 1.06 | 1.07 | 6287220.0 |
| 2007-12-03 | COW | ETF | 48.33 | 48.36 | 48.33 | 48.35 | 7700.0 |
| 2007-12-03 | CPI | ETF | 25.25 | 25.25 | 24.65 | 24.8 | 400.0 |
| 2007-12-03 | CPST | ETF | 1.22 | 1.23 | 1.14 | 1.14 | 2310933.0 |
| 2007-12-03 | CSA | ETF | 15.67 | 15.67 | 15.0 | 15.46 | 73500.0 |
| 2007-12-03 | CSD | ETF | 27.33 | 27.5 | 27.23 | 27.33 | 14800.0 |
| 2007-12-03 | CSQ | ETF | 14.0 | 14.01 | 13.87 | 13.97 | 231002.0 |
| 2007-12-03 | CUT | ETF | 24.8 | 24.85 | 24.75 | 24.75 | 30500.0 |
| 2007-12-03 | CVY | ETF | 24.45 | 24.58 | 24.37 | 24.4 | 17200.0 |
| 2007-12-03 | CWI | ETF | 28.9533 | 28.9533 | 28.3333 | 28.6133 | 165600.0 |
| 2007-12-03 | CZA | ETF | 25.85 | 25.85 | 25.85 | 25.85 | 200.0 |
| 2007-12-03 | DBA | ETF | 30.86 | 30.98 | 30.65 | 30.86 | 318100.0 |
> showing 50 of 539 rows — these rows as CSV