PREVIEW / etf_daily / 2006-11-01
file: by_date/etf_daily/2006/2006-11-01.parquet size: 19 KB rows: 382
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-01 | SPY | ETF | 138.22 | 138.31 | 136.72 | 136.86 | 83005600.0 |
| 2006-11-01 | QQQ | ETF | 42.73 | 42.77 | 41.82 | 42.0 | 148969434.0 |
| 2006-11-01 | IWM | ETF | 76.45 | 76.58 | 74.58 | 74.58 | 47212200.0 |
| 2006-11-01 | DIA | ETF | 121.06 | 121.11 | 119.98 | 120.26 | 7596000.0 |
| 2006-11-01 | GLD | ETF | 61.03 | 61.55 | 60.68 | 61.36 | 8172300.0 |
| 2006-11-01 | TLT | ETF | 89.61 | 90.12 | 89.45 | 89.96 | 1440100.0 |
| 2006-11-01 | AAA | ETF | 55.87 | 56.19 | 55.69 | 55.89 | 7000.0 |
| 2006-11-01 | ADRE | ETF | 34.84 | 34.84 | 34.2 | 34.24 | 279673.0 |
| 2006-11-01 | AGG | ETF | 100.05 | 100.19 | 99.8 | 100.18 | 773100.0 |
| 2006-11-01 | AIQ | ETF | 42.45 | 42.45 | 40.6 | 41.55 | 41060.0 |
| 2006-11-01 | AIS | ETF | 1.28 | 1.28 | 1.25 | 1.26 | 107200.0 |
| 2006-11-01 | ARB | ETF | 41.85 | 42.01 | 40.88 | 40.91 | 268100.0 |
| 2006-11-01 | BAB | ETF | 88.44 | 88.84 | 87.32 | 87.32 | 65500.0 |
| 2006-11-01 | BBC | ETF | 9.25 | 9.5 | 9.15 | 9.16 | 165800.0 |
| 2006-11-01 | BBH | ETF | 64.1267 | 64.1267 | 62.85 | 63.2 | 1069800.0 |
| 2006-11-01 | BITS | ETF | 34.36 | 34.36 | 32.8 | 33.4 | 91048.0 |
| 2006-11-01 | BNE | ETF | 15.67 | 15.67 | 15.2 | 15.25 | 148000.0 |
| 2006-11-01 | BRF | ETF | 14.3 | 14.36 | 14.25 | 14.36 | 7700.0 |
| 2006-11-01 | BTF | ETF | 104.0 | 105.55 | 103.0 | 103.3 | 22280.0 |
| 2006-11-01 | CBON | ETF | 29.31 | 29.37 | 28.95 | 29.35 | 110980.0 |
| 2006-11-01 | CDL | ETF | 10.24 | 10.24 | 9.84 | 9.94 | 337500.0 |
| 2006-11-01 | CEF | ETF | 8.66 | 8.71 | 8.55 | 8.71 | 459400.0 |
| 2006-11-01 | CEW | ETF | 25.5 | 25.5 | 25.5 | 25.5 | 400.0 |
| 2006-11-01 | CFO | ETF | 10.4 | 10.45 | 10.4 | 10.4 | 7500.0 |
| 2006-11-01 | CGO | ETF | 15.76 | 15.79 | 15.61 | 15.61 | 25000.0 |
| 2006-11-01 | CHB | ETF | 9.31 | 9.45 | 8.9 | 8.95 | 1319200.0 |
| 2006-11-01 | CHI | ETF | 19.68 | 19.8 | 19.68 | 19.72 | 66900.0 |
| 2006-11-01 | CHIC | ETF | 27.67 | 27.91 | 26.15 | 26.25 | 756500.0 |
| 2006-11-01 | CHY | ETF | 17.0 | 17.05 | 16.99 | 17.02 | 112400.0 |
| 2006-11-01 | CIL | ETF | 25.77 | 25.77 | 25.77 | 25.77 | 400.0 |
| 2006-11-01 | CIZ | ETF | 22.6 | 22.6 | 22.6 | 22.6 | 200.0 |
| 2006-11-01 | CN | ETF | 35.4 | 35.63 | 35.23 | 35.44 | 88100.0 |
| 2006-11-01 | CNXT | ETF | 1.93 | 1.99 | 1.93 | 1.98 | 14194905.0 |
| 2006-11-01 | COMB | ETF | 10.14 | 10.24 | 9.67 | 9.67 | 14503.0 |
| 2006-11-01 | CPST | ETF | 1.6 | 1.65 | 1.55 | 1.6 | 1359068.0 |
| 2006-11-01 | CSA | ETF | 21.88 | 22.44 | 21.38 | 21.5 | 66900.0 |
| 2006-11-01 | CSB | ETF | 30.96 | 31.06 | 30.85 | 30.87 | 9700.0 |
| 2006-11-01 | CSM | ETF | 1.2675 | 1.27 | 1.2675 | 1.27 | 11200.0 |
| 2006-11-01 | CSQ | ETF | 14.95 | 14.95 | 14.75 | 14.79 | 372900.0 |
| 2006-11-01 | CTEC | ETF | 77.3 | 79.3 | 75.7 | 79.25 | 50136.0 |
| 2006-11-01 | CVY | ETF | 26.05 | 26.05 | 25.67 | 25.67 | 43900.0 |
| 2006-11-01 | CYB | ETF | 7.4 | 7.5 | 7.3 | 7.37 | 111400.0 |
| 2006-11-01 | DBC | ETF | 24.15 | 24.55 | 24.01 | 24.5 | 160400.0 |
| 2006-11-01 | DBV | ETF | 25.51 | 25.54 | 25.45 | 25.52 | 24400.0 |
| 2006-11-01 | DDM | ETF | 7.0525 | 7.0625 | 6.9317 | 6.9592 | 1255200.0 |
| 2006-11-01 | DES | ETF | 18.7533 | 18.7533 | 18.4233 | 18.4367 | 40200.0 |
| 2006-11-01 | DEW | ETF | 58.73 | 58.73 | 58.11 | 58.11 | 18900.0 |
| 2006-11-01 | DFE | ETF | 59.3 | 59.33 | 58.75 | 58.84 | 5400.0 |
| 2006-11-01 | DFJ | ETF | 50.2 | 50.2 | 49.68 | 49.68 | 13100.0 |
| 2006-11-01 | DGT | ETF | 73.72 | 73.85 | 73.23 | 73.39 | 4000.0 |
> showing 50 of 382 rows — these rows as CSV