PREVIEW / etf_daily / 2007-10-01
file: by_date/etf_daily/2007/2007-10-01.parquet size: 23 KB rows: 504
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-10-01 | SPY | ETF | 152.6 | 154.75 | 152.5 | 154.3 | 148162300.0 |
| 2007-10-01 | QQQ | ETF | 51.45 | 52.16 | 51.38 | 52.0 | 100404095.0 |
| 2007-10-01 | IWM | ETF | 80.13 | 82.24 | 80.13 | 82.03 | 98833600.0 |
| 2007-10-01 | DIA | ETF | 138.96 | 141.0 | 138.96 | 140.6 | 10164200.0 |
| 2007-10-01 | GLD | ETF | 73.49 | 73.98 | 73.29 | 73.9 | 4823700.0 |
| 2007-10-01 | TLT | ETF | 88.69 | 88.98 | 88.43 | 88.88 | 1399400.0 |
| 2007-10-01 | ADRE | ETF | 53.5 | 54.924 | 53.27 | 54.82 | 260839.0 |
| 2007-10-01 | AGG | ETF | 99.82 | 99.83 | 99.27 | 99.27 | 3538500.0 |
| 2007-10-01 | AIQ | ETF | 45.3 | 47.35 | 44.75 | 46.5 | 94260.0 |
| 2007-10-01 | AIS | ETF | 1.41 | 1.41 | 1.38 | 1.4 | 140600.0 |
| 2007-10-01 | ARB | ETF | 45.49 | 46.65 | 45.39 | 46.58 | 243500.0 |
| 2007-10-01 | BBH | ETF | 58.6 | 59.0133 | 58.4133 | 58.9833 | 297300.0 |
| 2007-10-01 | BIL | ETF | 91.52 | 91.6 | 91.5 | 91.58 | 21900.0 |
| 2007-10-01 | BITS | ETF | 26.44 | 26.84 | 26.0 | 26.4 | 15693.0 |
| 2007-10-01 | BIV | ETF | 75.33 | 75.47 | 75.26 | 75.37 | 17300.0 |
| 2007-10-01 | BLV | ETF | 74.76 | 74.76 | 74.71 | 74.76 | 1900.0 |
| 2007-10-01 | BMVP | ETF | 17.35 | 17.47 | 17.35 | 17.45 | 92200.0 |
| 2007-10-01 | BND | ETF | 75.28 | 75.47 | 75.28 | 75.36 | 246000.0 |
| 2007-10-01 | BNE | ETF | 16.59 | 17.2 | 16.59 | 17.11 | 235900.0 |
| 2007-10-01 | BRF | ETF | 14.67 | 14.69 | 14.67 | 14.69 | 300.0 |
| 2007-10-01 | BSV | ETF | 76.03 | 76.03 | 75.76 | 75.84 | 76800.0 |
| 2007-10-01 | BTF | ETF | 105.85000000000001 | 107.39999999999999 | 105.85000000000001 | 107.24999999999999 | 1780.0 |
| 2007-10-01 | CBON | ETF | 25.0 | 25.69 | 24.9 | 25.56 | 58817.0 |
| 2007-10-01 | CDL | ETF | 4.15 | 4.2 | 4.135 | 4.17 | 1236100.0 |
| 2007-10-01 | CEF | ETF | 9.89 | 9.93 | 9.82 | 9.85 | 485500.0 |
| 2007-10-01 | CGO | ETF | 17.92 | 19.08 | 17.92 | 18.05 | 31200.0 |
| 2007-10-01 | CGW | ETF | 26.1 | 26.3 | 26.01 | 26.3 | 195000.0 |
| 2007-10-01 | CHB | ETF | 11.0 | 11.41 | 10.94 | 11.39 | 1132200.0 |
| 2007-10-01 | CHI | ETF | 17.08 | 17.19 | 17.07 | 17.09 | 93900.0 |
| 2007-10-01 | CHIC | ETF | 14.63 | 15.43 | 14.6 | 15.4 | 585735.0 |
| 2007-10-01 | CHW | ETF | 13.26 | 13.37 | 13.1 | 13.31 | 192400.0 |
| 2007-10-01 | CHY | ETF | 15.4 | 15.42 | 15.3 | 15.33 | 87300.0 |
| 2007-10-01 | CN | ETF | 53.94 | 55.16 | 52.81 | 54.28 | 494000.0 |
| 2007-10-01 | CNXT | ETF | 1.2 | 1.3 | 1.2 | 1.3 | 12231108.0 |
| 2007-10-01 | CPI | ETF | 23.8499 | 23.8499 | 23.8499 | 23.8499 | 100.0 |
| 2007-10-01 | CPST | ETF | 1.2 | 1.21 | 1.17 | 1.2 | 1292326.0 |
| 2007-10-01 | CSA | ETF | 18.63 | 18.95 | 18.42 | 18.95 | 56200.0 |
| 2007-10-01 | CSD | ETF | 29.18 | 29.45 | 29.18 | 29.25 | 91000.0 |
| 2007-10-01 | CSQ | ETF | 14.93 | 14.93 | 14.78 | 14.85 | 329500.0 |
| 2007-10-01 | CVY | ETF | 26.03 | 26.33 | 26.03 | 26.31 | 17300.0 |
| 2007-10-01 | CWI | ETF | 28.4933 | 28.9333 | 28.4933 | 28.8933 | 20700.0 |
| 2007-10-01 | DBA | ETF | 29.64 | 29.64 | 29.33 | 29.35 | 329300.0 |
| 2007-10-01 | DBB | ETF | 26.39 | 26.69 | 26.31 | 26.68 | 27400.0 |
| 2007-10-01 | DBC | ETF | 28.99 | 28.99 | 27.64 | 27.82 | 196500.0 |
| 2007-10-01 | DBE | ETF | 30.21 | 30.3 | 29.78 | 30.07 | 19800.0 |
| 2007-10-01 | DBO | ETF | 28.93 | 29.05 | 28.73 | 28.98 | 9500.0 |
| 2007-10-01 | DBP | ETF | 28.62 | 28.75 | 28.5 | 28.72 | 21800.0 |
| 2007-10-01 | DBS | ETF | 26.87 | 26.98 | 26.75 | 26.87 | 30900.0 |
| 2007-10-01 | DBV | ETF | 28.51 | 28.7 | 28.51 | 28.68 | 170900.0 |
| 2007-10-01 | DDM | ETF | 8.2708 | 8.475 | 8.2608 | 8.435 | 4064400.0 |
> showing 50 of 504 rows — these rows as CSV