PREVIEW / etf_daily / 2007-10-03
file: by_date/etf_daily/2007/2007-10-03.parquet size: 23 KB rows: 501
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-03 | SPY | ETF | 153.81 | 154.41 | 153.01 | 153.78 | 119055900.0 |
| 2007-10-03 | QQQ | ETF | 51.84 | 52.07 | 51.5 | 51.65 | 106784920.0 |
| 2007-10-03 | IWM | ETF | 82.32 | 82.76 | 81.96 | 82.33 | 56474400.0 |
| 2007-10-03 | DIA | ETF | 139.89 | 140.27 | 139.38 | 139.61 | 7918300.0 |
| 2007-10-03 | GLD | ETF | 72.25 | 72.65 | 71.35 | 71.9 | 8186000.0 |
| 2007-10-03 | TLT | ETF | 89.33 | 89.43 | 88.73 | 88.9 | 1164600.0 |
| 2007-10-03 | ADRE | ETF | 55.33 | 55.33 | 53.148 | 53.19 | 532882.0 |
| 2007-10-03 | AGG | ETF | 99.86 | 99.9 | 99.51 | 99.7 | 327100.0 |
| 2007-10-03 | AIQ | ETF | 46.1 | 46.65 | 45.75 | 45.9 | 22760.0 |
| 2007-10-03 | AIS | ETF | 1.4 | 1.4 | 1.36 | 1.4 | 178100.0 |
| 2007-10-03 | ARB | ETF | 45.54 | 45.98 | 44.81 | 45.71 | 281800.0 |
| 2007-10-03 | BBH | ETF | 58.2833 | 58.94 | 58.2833 | 58.6067 | 228300.0 |
| 2007-10-03 | BIL | ETF | 91.56 | 91.64 | 91.52 | 91.54 | 131200.0 |
| 2007-10-03 | BITS | ETF | 26.6 | 26.6 | 25.8 | 25.84 | 5931.0 |
| 2007-10-03 | BIV | ETF | 75.64 | 75.74 | 75.32 | 75.46 | 17500.0 |
| 2007-10-03 | BLV | ETF | 75.32 | 75.32 | 74.86 | 75.07 | 32500.0 |
| 2007-10-03 | BMVP | ETF | 17.3767 | 17.4417 | 17.3267 | 17.36 | 47500.0 |
| 2007-10-03 | BND | ETF | 75.68 | 75.69 | 75.45 | 75.59 | 99300.0 |
| 2007-10-03 | BNE | ETF | 17.1 | 17.1 | 16.97 | 17.03 | 86200.0 |
| 2007-10-03 | BSV | ETF | 75.91 | 75.94 | 75.85 | 75.9 | 18700.0 |
| 2007-10-03 | BTF | ETF | 107.6005 | 108.2 | 107.55 | 107.89999999999999 | 1080.0 |
| 2007-10-03 | CBON | ETF | 25.57 | 25.8 | 25.18 | 25.28 | 44791.0 |
| 2007-10-03 | CDL | ETF | 4.16 | 4.24 | 4.14 | 4.21 | 1163300.0 |
| 2007-10-03 | CEF | ETF | 9.7 | 9.75 | 9.65 | 9.7 | 196000.0 |
| 2007-10-03 | CGO | ETF | 17.9 | 18.12 | 17.79 | 17.8 | 21500.0 |
| 2007-10-03 | CGW | ETF | 26.09 | 26.1 | 25.76 | 25.85 | 50000.0 |
| 2007-10-03 | CHB | ETF | 12.03 | 12.58 | 11.67 | 11.94 | 1653300.0 |
| 2007-10-03 | CHI | ETF | 16.95 | 17.1 | 16.89 | 17.09 | 123000.0 |
| 2007-10-03 | CHIC | ETF | 15.6 | 16.29 | 15.6 | 15.94 | 429992.0 |
| 2007-10-03 | CHW | ETF | 13.36 | 13.63 | 13.22 | 13.59 | 203300.0 |
| 2007-10-03 | CHY | ETF | 15.45 | 15.51 | 15.3501 | 15.51 | 114600.0 |
| 2007-10-03 | CN | ETF | 55.56 | 56.2 | 54.05 | 54.7 | 322500.0 |
| 2007-10-03 | CNXT | ETF | 1.33 | 1.37 | 1.31 | 1.31 | 6692003.0 |
| 2007-10-03 | CPST | ETF | 1.25 | 1.25 | 1.16 | 1.21 | 6609736.0 |
| 2007-10-03 | CSA | ETF | 19.1 | 19.19 | 18.35 | 18.68 | 57300.0 |
| 2007-10-03 | CSD | ETF | 29.55 | 29.55 | 29.34 | 29.34 | 3900.0 |
| 2007-10-03 | CSM | ETF | 1.4725 | 1.4725 | 1.465 | 1.465 | 12400.0 |
| 2007-10-03 | CSQ | ETF | 14.81 | 14.81 | 14.59 | 14.73 | 212100.0 |
| 2007-10-03 | CVY | ETF | 26.45 | 26.5 | 26.35 | 26.37 | 13700.0 |
| 2007-10-03 | CWI | ETF | 28.7867 | 28.8333 | 28.6133 | 28.6333 | 24750.0 |
| 2007-10-03 | DBA | ETF | 28.08 | 28.37 | 27.75 | 28.37 | 724900.0 |
| 2007-10-03 | DBB | ETF | 26.87 | 26.9 | 26.64 | 26.8 | 15900.0 |
| 2007-10-03 | DBC | ETF | 27.65 | 27.65 | 27.11 | 27.29 | 159400.0 |
| 2007-10-03 | DBE | ETF | 29.99 | 30.19 | 29.91 | 30.0 | 18800.0 |
| 2007-10-03 | DBO | ETF | 28.81 | 28.92 | 28.63 | 28.65 | 24100.0 |
| 2007-10-03 | DBP | ETF | 28.08 | 28.15 | 27.9 | 27.96 | 30300.0 |
| 2007-10-03 | DBS | ETF | 26.39 | 26.43 | 26.04 | 26.14 | 3900.0 |
| 2007-10-03 | DBV | ETF | 28.69 | 28.74 | 28.5575 | 28.61 | 82500.0 |
| 2007-10-03 | DDM | ETF | 8.3542 | 8.3817 | 8.2808 | 8.3117 | 2132400.0 |
| 2007-10-03 | DEEP | ETF | 11.36 | 11.48 | 11.29 | 11.39 | 116029.0 |
> showing 50 of 501 rows — these rows as CSV