PREVIEW / etf_daily / 2007-10-24
file: by_date/etf_daily/2007/2007-10-24.parquet size: 24 KB rows: 524
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-24 | SPY | ETF | 151.21 | 151.74 | 148.84 | 151.48 | 326694200.0 |
| 2007-10-24 | QQQ | ETF | 53.74 | 53.94 | 52.0 | 53.77 | 298345044.0 |
| 2007-10-24 | IWM | ETF | 80.87 | 81.17 | 79.11 | 80.86 | 126810300.0 |
| 2007-10-24 | DIA | ETF | 136.1 | 136.79 | 134.56 | 136.5 | 22583800.0 |
| 2007-10-24 | GLD | ETF | 74.84 | 75.59 | 74.79 | 75.52 | 5660600.0 |
| 2007-10-24 | TLT | ETF | 90.71 | 91.39 | 90.56 | 91.02 | 2829300.0 |
| 2007-10-24 | ADRE | ETF | 56.72 | 56.76 | 54.88 | 56.23 | 258935.0 |
| 2007-10-24 | AGG | ETF | 100.87 | 101.2 | 100.7 | 101.11 | 1018400.0 |
| 2007-10-24 | AIQ | ETF | 45.25 | 45.5 | 44.5 | 45.25 | 78800.0 |
| 2007-10-24 | AIS | ETF | 1.22 | 1.23 | 1.181 | 1.22 | 210600.0 |
| 2007-10-24 | AIVI | ETF | 74.04 | 74.85 | 73.23 | 74.42 | 19300.0 |
| 2007-10-24 | ARB | ETF | 49.8 | 51.04 | 49.49 | 50.25 | 391500.0 |
| 2007-10-24 | BBH | ETF | 59.9 | 60.2533 | 59.4967 | 60.0667 | 179400.0 |
| 2007-10-24 | BIL | ETF | 91.84 | 91.84 | 91.76 | 91.84 | 27500.0 |
| 2007-10-24 | BITS | ETF | 25.56 | 25.72 | 24.96 | 25.0 | 5240.0 |
| 2007-10-24 | BIV | ETF | 76.62 | 76.83 | 76.48 | 76.74 | 20200.0 |
| 2007-10-24 | BLV | ETF | 76.42 | 76.88 | 76.42 | 76.71 | 10600.0 |
| 2007-10-24 | BMVP | ETF | 17.23 | 17.2867 | 16.95 | 17.2467 | 123400.0 |
| 2007-10-24 | BND | ETF | 76.43 | 76.61 | 76.38 | 76.52 | 207300.0 |
| 2007-10-24 | BNE | ETF | 17.16 | 17.26 | 16.85 | 17.19 | 129900.0 |
| 2007-10-24 | BRF | ETF | 14.65 | 14.65 | 14.65 | 14.65 | 2100.0 |
| 2007-10-24 | BSV | ETF | 76.48 | 76.65 | 76.43 | 76.54 | 61200.0 |
| 2007-10-24 | BTF | ETF | 115.0 | 115.05 | 113.14999999999999 | 114.49999999999999 | 2920.0 |
| 2007-10-24 | BWX | ETF | 26.35 | 26.39 | 26.265 | 26.375 | 146200.0 |
| 2007-10-24 | CBON | ETF | 20.13 | 20.23 | 19.69 | 19.92 | 65830.0 |
| 2007-10-24 | CDL | ETF | 4.4 | 4.42 | 4.27 | 4.3 | 2111400.0 |
| 2007-10-24 | CEF | ETF | 9.9 | 9.99 | 9.86 | 9.96 | 172400.0 |
| 2007-10-24 | CGO | ETF | 18.67 | 18.78 | 18.5 | 18.74 | 19900.0 |
| 2007-10-24 | CGW | ETF | 26.05 | 26.07 | 25.57 | 25.99 | 55800.0 |
| 2007-10-24 | CHB | ETF | 12.78 | 13.12 | 12.37 | 13.0 | 2118300.0 |
| 2007-10-24 | CHI | ETF | 16.85 | 16.85 | 16.65 | 16.85 | 103600.0 |
| 2007-10-24 | CHIC | ETF | 13.99 | 14.69 | 13.84 | 14.48 | 610414.0 |
| 2007-10-24 | CHW | ETF | 13.25 | 13.28 | 13.03 | 13.25 | 144500.0 |
| 2007-10-24 | CHY | ETF | 14.8 | 14.85 | 14.61 | 14.79 | 140500.0 |
| 2007-10-24 | CMF | ETF | 52.175 | 52.25 | 52.175 | 52.25 | 4200.0 |
| 2007-10-24 | CN | ETF | 59.35 | 60.36 | 57.68 | 59.75 | 503400.0 |
| 2007-10-24 | CNXT | ETF | 1.35 | 1.35 | 1.28 | 1.3 | 9460658.0 |
| 2007-10-24 | COW | ETF | 50.02 | 50.02 | 50.02 | 50.02 | 2500.0 |
| 2007-10-24 | CPST | ETF | 1.08 | 1.11 | 1.07 | 1.08 | 2262535.0 |
| 2007-10-24 | CSA | ETF | 17.61 | 17.73 | 16.94 | 17.4 | 45500.0 |
| 2007-10-24 | CSD | ETF | 28.75 | 28.82 | 28.23 | 28.82 | 25100.0 |
| 2007-10-24 | CSQ | ETF | 14.77 | 14.77 | 14.47 | 14.76 | 234600.0 |
| 2007-10-24 | CVY | ETF | 25.58 | 25.58 | 25.25 | 25.54 | 26000.0 |
| 2007-10-24 | CWI | ETF | 28.7667 | 28.8267 | 28.3867 | 28.8267 | 56100.0 |
| 2007-10-24 | CZA | ETF | 26.63 | 26.63 | 26.42 | 26.43 | 1100.0 |
| 2007-10-24 | DBA | ETF | 28.86 | 28.9 | 28.56 | 28.59 | 312400.0 |
| 2007-10-24 | DBB | ETF | 25.53 | 25.63 | 25.33 | 25.57 | 37300.0 |
| 2007-10-24 | DBC | ETF | 28.5 | 28.86 | 28.5 | 28.73 | 212900.0 |
| 2007-10-24 | DBE | ETF | 31.9 | 32.55 | 31.9 | 32.55 | 14300.0 |
| 2007-10-24 | DBO | ETF | 30.97 | 31.67 | 30.97 | 31.35 | 11200.0 |
> showing 50 of 524 rows — these rows as CSV