PREVIEW / etf_daily / 2007-11-01
file: by_date/etf_daily/2007/2007-11-01.parquet size: 24 KB rows: 531
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-01 | SPY | ETF | 153.29 | 153.41 | 150.59 | 151.03 | 333040800.0 |
| 2007-11-01 | QQQ | ETF | 54.68 | 54.77 | 53.97 | 54.0 | 181974177.0 |
| 2007-11-01 | IWM | ETF | 81.37 | 81.4 | 79.0 | 79.14 | 171158000.0 |
| 2007-11-01 | DIA | ETF | 137.86 | 137.9 | 135.38 | 135.85 | 25301400.0 |
| 2007-11-01 | GLD | ETF | 78.4 | 78.9 | 77.5 | 77.93 | 7545500.0 |
| 2007-11-01 | TLT | ETF | 89.96 | 91.01 | 89.96 | 90.75 | 2563400.0 |
| 2007-11-01 | ADRE | ETF | 58.46 | 58.98 | 57.65 | 57.79 | 515081.0 |
| 2007-11-01 | AGG | ETF | 100.3 | 100.66 | 100.26 | 100.44 | 251200.0 |
| 2007-11-01 | AIQ | ETF | 48.3 | 48.4 | 44.1 | 45.1 | 175360.0 |
| 2007-11-01 | AIS | ETF | 1.24 | 1.25 | 1.21 | 1.22 | 88200.0 |
| 2007-11-01 | AIVI | ETF | 76.37 | 76.61 | 75.51 | 75.59 | 83900.0 |
| 2007-11-01 | ARB | ETF | 50.05 | 50.05 | 48.42 | 49.17 | 501600.0 |
| 2007-11-01 | BBH | ETF | 60.5633 | 60.74 | 59.4667 | 59.49 | 400500.0 |
| 2007-11-01 | BIL | ETF | 91.56 | 91.62 | 91.54 | 91.6 | 32750.0 |
| 2007-11-01 | BITS | ETF | 26.84 | 27.32 | 26.6108 | 26.72 | 6555.0 |
| 2007-11-01 | BIV | ETF | 76.09 | 76.48 | 76.09 | 76.46 | 14800.0 |
| 2007-11-01 | BLV | ETF | 76.23 | 76.49 | 76.15 | 76.35 | 8800.0 |
| 2007-11-01 | BMVP | ETF | 17.49 | 17.57 | 17.32 | 17.33 | 87600.0 |
| 2007-11-01 | BND | ETF | 75.94 | 76.26 | 75.94 | 76.25 | 141200.0 |
| 2007-11-01 | BNE | ETF | 17.2 | 17.36 | 16.38 | 16.42 | 208200.0 |
| 2007-11-01 | BRF | ETF | 14.74 | 14.74 | 14.71 | 14.74 | 1300.0 |
| 2007-11-01 | BSV | ETF | 76.06 | 76.24 | 76.06 | 76.22 | 34200.0 |
| 2007-11-01 | BTF | ETF | 116.99999999999999 | 116.99999999999999 | 115.0 | 116.44949999999999 | 3320.0 |
| 2007-11-01 | BWX | ETF | 26.485 | 26.55 | 26.44 | 26.525 | 52200.0 |
| 2007-11-01 | CBON | ETF | 20.0 | 20.18 | 19.29 | 19.42 | 322345.0 |
| 2007-11-01 | CDL | ETF | 4.33 | 4.35 | 4.1 | 4.29 | 2117000.0 |
| 2007-11-01 | CEF | ETF | 10.35 | 10.42 | 10.23 | 10.3 | 377400.0 |
| 2007-11-01 | CGO | ETF | 19.51 | 19.5399 | 19.25 | 19.25 | 21800.0 |
| 2007-11-01 | CGW | ETF | 26.09 | 26.09 | 25.74 | 25.78 | 125000.0 |
| 2007-11-01 | CHB | ETF | 11.76 | 11.95 | 11.26 | 11.6 | 3724000.0 |
| 2007-11-01 | CHI | ETF | 16.82 | 16.83 | 16.57 | 16.58 | 126600.0 |
| 2007-11-01 | CHIC | ETF | 14.28 | 14.45 | 13.86 | 13.87 | 879570.0 |
| 2007-11-01 | CHW | ETF | 13.01 | 13.09 | 12.92 | 13.0 | 139800.0 |
| 2007-11-01 | CHY | ETF | 14.62 | 14.62 | 14.4 | 14.43 | 147800.0 |
| 2007-11-01 | CMF | ETF | 51.925 | 51.99 | 51.865 | 51.865 | 13800.0 |
| 2007-11-01 | CN | ETF | 58.74 | 59.9 | 57.82 | 58.69 | 387100.0 |
| 2007-11-01 | CNXT | ETF | 1.26 | 1.27 | 1.18 | 1.23 | 10858764.0 |
| 2007-11-01 | CPI | ETF | 24.4 | 24.5 | 24.1 | 24.1 | 1800.0 |
| 2007-11-01 | CPST | ETF | 1.14 | 1.18 | 1.1 | 1.17 | 3232812.0 |
| 2007-11-01 | CSA | ETF | 17.02 | 17.16 | 16.5 | 16.68 | 69800.0 |
| 2007-11-01 | CSD | ETF | 28.7 | 28.88 | 28.5 | 28.55 | 42000.0 |
| 2007-11-01 | CSQ | ETF | 14.65 | 14.6599 | 14.38 | 14.41 | 277400.0 |
| 2007-11-01 | CVY | ETF | 25.73 | 25.73 | 25.38 | 25.38 | 8300.0 |
| 2007-11-01 | CWI | ETF | 29.5467 | 29.6667 | 29.42 | 29.42 | 52950.0 |
| 2007-11-01 | CZA | ETF | 26.91 | 26.91 | 26.74 | 26.74 | 900.0 |
| 2007-11-01 | DBA | ETF | 29.75 | 29.76 | 28.87 | 29.0 | 693300.0 |
| 2007-11-01 | DBB | ETF | 25.47 | 25.47 | 25.15 | 25.28 | 96100.0 |
| 2007-11-01 | DBC | ETF | 30.28 | 30.28 | 29.8379 | 30.11 | 378300.0 |
| 2007-11-01 | DBE | ETF | 34.27 | 34.31 | 33.96 | 34.15 | 13300.0 |
| 2007-11-01 | DBO | ETF | 35.21 | 35.98 | 33.14 | 33.45 | 26400.0 |
> showing 50 of 531 rows — these rows as CSV