PREVIEW / etf_daily / 2007-11-20
file: by_date/etf_daily/2007/2007-11-20.parquet size: 24 KB rows: 534
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-20 | SPY | ETF | 144.02 | 145.53 | 142.11 | 144.64 | 414767500.0 |
| 2007-11-20 | QQQ | ETF | 49.95 | 50.78 | 48.93 | 49.9 | 300763582.0 |
| 2007-11-20 | IWM | ETF | 74.7 | 75.56 | 73.35 | 75.07 | 129813600.0 |
| 2007-11-20 | DIA | ETF | 129.83 | 131.0 | 128.32 | 130.33 | 29928200.0 |
| 2007-11-20 | GLD | ETF | 78.03 | 80.04 | 77.3 | 79.47 | 12081600.0 |
| 2007-11-20 | TLT | ETF | 93.09 | 93.29 | 92.8 | 92.91 | 1367800.0 |
| 2007-11-20 | ADRE | ETF | 53.4 | 54.77 | 52.95 | 53.94 | 279083.0 |
| 2007-11-20 | AGG | ETF | 101.23 | 101.25 | 100.89 | 101.0 | 332100.0 |
| 2007-11-20 | AIA | ETF | 48.41 | 48.46 | 46.94 | 48.11 | 7500.0 |
| 2007-11-20 | AIQ | ETF | 43.3 | 44.55 | 43.1 | 44.55 | 45690.0 |
| 2007-11-20 | AIS | ETF | 1.0999 | 1.1 | 1.08 | 1.09 | 55300.0 |
| 2007-11-20 | AIVI | ETF | 71.94 | 72.69 | 71.46 | 72.32 | 47400.0 |
| 2007-11-20 | ARB | ETF | 50.94 | 51.77 | 49.74 | 51.13 | 292100.0 |
| 2007-11-20 | BBH | ETF | 58.1 | 58.7533 | 57.5733 | 58.3367 | 299700.0 |
| 2007-11-20 | BIL | ETF | 91.76 | 91.84 | 91.72 | 91.84 | 40950.0 |
| 2007-11-20 | BITS | ETF | 23.6 | 24.0 | 22.88 | 23.56 | 10440.0 |
| 2007-11-20 | BIV | ETF | 77.3 | 77.39 | 77.06 | 77.18 | 23000.0 |
| 2007-11-20 | BKF | ETF | 57.3 | 57.73 | 56.62 | 57.36 | 5900.0 |
| 2007-11-20 | BLV | ETF | 77.15 | 77.2 | 76.94 | 77.04 | 20600.0 |
| 2007-11-20 | BMVP | ETF | 16.72 | 16.8767 | 16.5267 | 16.71 | 62700.0 |
| 2007-11-20 | BND | ETF | 76.8 | 76.8 | 76.48 | 76.53 | 89500.0 |
| 2007-11-20 | BNE | ETF | 16.7 | 16.83 | 16.04 | 16.43 | 159400.0 |
| 2007-11-20 | BRF | ETF | 14.61 | 14.65 | 14.61 | 14.647 | 11300.0 |
| 2007-11-20 | BSV | ETF | 77.1 | 77.16 | 76.97 | 76.97 | 31600.0 |
| 2007-11-20 | BTF | ETF | 111.4 | 111.4 | 109.19999999999999 | 111.19999999999999 | 1280.0 |
| 2007-11-20 | BWX | ETF | 27.275 | 27.45 | 27.225 | 27.3 | 175800.0 |
| 2007-11-20 | CBON | ETF | 18.41 | 18.9799 | 18.23 | 18.42 | 56147.0 |
| 2007-11-20 | CDL | ETF | 2.25 | 2.3 | 2.08 | 2.26 | 2409040.0 |
| 2007-11-20 | CEF | ETF | 10.97 | 10.97 | 10.45 | 10.78 | 620300.0 |
| 2007-11-20 | CGO | ETF | 18.1 | 18.55 | 17.92 | 18.0 | 23600.0 |
| 2007-11-20 | CGW | ETF | 24.98 | 25.06 | 24.6 | 24.9 | 43040.0 |
| 2007-11-20 | CHB | ETF | 8.65 | 9.01 | 8.48 | 8.76 | 3308800.0 |
| 2007-11-20 | CHI | ETF | 14.94 | 15.07 | 14.89 | 14.94 | 190700.0 |
| 2007-11-20 | CHIC | ETF | 14.32 | 15.1 | 14.1 | 14.41 | 595853.0 |
| 2007-11-20 | CHW | ETF | 12.07 | 12.21 | 11.77 | 11.93 | 357500.0 |
| 2007-11-20 | CHY | ETF | 13.05 | 13.24 | 13.0 | 13.02 | 217643.0 |
| 2007-11-20 | CMF | ETF | 51.95 | 51.95 | 51.705 | 51.705 | 3200.0 |
| 2007-11-20 | CN | ETF | 58.0 | 60.33 | 57.15 | 59.09 | 1067860.0 |
| 2007-11-20 | CNXT | ETF | 1.18 | 1.2 | 1.1 | 1.13 | 9649591.0 |
| 2007-11-20 | COW | ETF | 48.68 | 49.43 | 48.68 | 49.35 | 6500.0 |
| 2007-11-20 | CPST | ETF | 1.25 | 1.26 | 1.18 | 1.25 | 2092680.0 |
| 2007-11-20 | CSA | ETF | 17.12 | 17.15 | 16.03 | 16.45 | 64800.0 |
| 2007-11-20 | CSD | ETF | 26.51 | 26.71 | 26.18 | 26.34 | 10600.0 |
| 2007-11-20 | CSQ | ETF | 13.29 | 13.56 | 12.93 | 13.24 | 384466.0 |
| 2007-11-20 | CUT | ETF | 23.74 | 23.85 | 23.65 | 23.8 | 30300.0 |
| 2007-11-20 | CVY | ETF | 23.93 | 24.14 | 23.62 | 23.94 | 10900.0 |
| 2007-11-20 | CWI | ETF | 28.0733 | 28.22 | 27.7 | 28.0533 | 334050.0 |
| 2007-11-20 | CZA | ETF | 25.3 | 25.3 | 25.3 | 25.3 | 400.0 |
| 2007-11-20 | DBA | ETF | 29.78 | 30.1 | 29.62 | 30.09 | 163900.0 |
| 2007-11-20 | DBB | ETF | 23.24 | 23.43 | 23.07 | 23.39 | 40900.0 |
> showing 50 of 534 rows — these rows as CSV