PREVIEW / etf_daily / 2005-12-01
file: by_date/etf_daily/2005/2005-12-01.parquet size: 16 KB rows: 292
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-01 | SPY | ETF | 126.02 | 127.03 | 125.98 | 126.69 | 65468200.0 |
| 2005-12-01 | QQQ | ETF | 41.51 | 42.05 | 41.5 | 42.007 | 91914037.0 |
| 2005-12-01 | IWM | ETF | 67.79 | 68.85 | 67.43 | 68.55 | 37384100.0 |
| 2005-12-01 | DIA | ETF | 108.74 | 109.39 | 108.64 | 109.06 | 5844300.0 |
| 2005-12-01 | GLD | ETF | 49.63 | 50.29 | 49.58 | 50.17 | 2557900.0 |
| 2005-12-01 | TLT | ETF | 90.0 | 90.01 | 89.18 | 89.47 | 1214800.0 |
| 2005-12-01 | AAA | ETF | 52.88 | 52.88 | 52.42 | 52.6 | 2500.0 |
| 2005-12-01 | ADRE | ETF | 112.79 | 113.93 | 112.47 | 113.93 | 19632.0 |
| 2005-12-01 | AFK | ETF | 25.42 | 25.53 | 25.42 | 25.52 | 31300.0 |
| 2005-12-01 | AGG | ETF | 99.9 | 100.11 | 99.52 | 99.7 | 520700.0 |
| 2005-12-01 | AIQ | ETF | 27.65 | 28.1 | 27.0 | 27.8 | 9780.0 |
| 2005-12-01 | AIS | ETF | 1.21 | 1.24 | 1.1899 | 1.22 | 276500.0 |
| 2005-12-01 | AOM | ETF | 3.5 | 3.5 | 3.45 | 3.49 | 7700.0 |
| 2005-12-01 | ARB | ETF | 38.95 | 39.9 | 38.95 | 39.71 | 131400.0 |
| 2005-12-01 | BAB | ETF | 54.77 | 55.36 | 54.68 | 55.05 | 22500.0 |
| 2005-12-01 | BBC | ETF | 10.0 | 10.36 | 9.85 | 10.039 | 136700.0 |
| 2005-12-01 | BBH | ETF | 68.2833 | 69.6667 | 68.1933 | 69.2967 | 1683000.0 |
| 2005-12-01 | BCM | ETF | 64.82 | 65.08 | 63.48 | 64.54 | 28100.0 |
| 2005-12-01 | BITS | ETF | 13.6 | 13.93 | 13.24 | 13.93 | 2322.0 |
| 2005-12-01 | BKF | ETF | 20.66 | 21.82 | 20.66 | 21.33 | 82100.0 |
| 2005-12-01 | BNE | ETF | 14.79 | 15.24 | 14.79 | 15.16 | 142200.0 |
| 2005-12-01 | BRF | ETF | 15.08 | 15.13 | 15.06 | 15.08 | 9000.0 |
| 2005-12-01 | BTF | ETF | 87.89999999999999 | 88.24999999999999 | 87.85 | 87.89999999999999 | 28060.0 |
| 2005-12-01 | CBON | ETF | 32.75 | 32.75 | 31.4 | 31.67 | 34653.0 |
| 2005-12-01 | CDL | ETF | 13.48 | 13.8 | 13.47 | 13.78 | 311900.0 |
| 2005-12-01 | CEF | ETF | 6.2 | 6.32 | 6.13 | 6.31 | 742400.0 |
| 2005-12-01 | CEW | ETF | 26.0 | 26.03 | 26.0 | 26.03 | 500.0 |
| 2005-12-01 | CGO | ETF | 13.32 | 13.6 | 13.22 | 13.22 | 58500.0 |
| 2005-12-01 | CHB | ETF | 14.57 | 15.13 | 14.55 | 15.13 | 441800.0 |
| 2005-12-01 | CHI | ETF | 20.16 | 20.38 | 20.12 | 20.3 | 101700.0 |
| 2005-12-01 | CHIC | ETF | 18.78 | 19.04 | 18.32 | 19.01 | 363955.0 |
| 2005-12-01 | CHIR | ETF | 44.3001 | 44.43 | 44.2599 | 44.31 | 1147935.0 |
| 2005-12-01 | CHY | ETF | 15.73 | 15.83 | 15.6609 | 15.81 | 132000.0 |
| 2005-12-01 | CIL | ETF | 25.22 | 25.3 | 25.15 | 25.17 | 1600.0 |
| 2005-12-01 | CN | ETF | 32.15 | 32.55 | 32.15 | 32.55 | 6800.0 |
| 2005-12-01 | CNXT | ETF | 2.49 | 2.55 | 2.46 | 2.53 | 18532043.0 |
| 2005-12-01 | COMB | ETF | 8.5 | 8.6 | 8.5 | 8.6 | 5500.0 |
| 2005-12-01 | CPI | ETF | 27.0 | 27.0 | 27.0 | 27.0 | 200.0 |
| 2005-12-01 | CPST | ETF | 3.45 | 3.5501 | 3.4 | 3.48 | 4269506.0 |
| 2005-12-01 | CSA | ETF | 16.75 | 16.75 | 16.7 | 16.73 | 21400.0 |
| 2005-12-01 | CSB | ETF | 29.36 | 29.73 | 29.29 | 29.69 | 32300.0 |
| 2005-12-01 | CSM | ETF | 2.4425 | 2.4425 | 2.4425 | 2.4425 | 400.0 |
| 2005-12-01 | CSQ | ETF | 13.18 | 13.26 | 13.16 | 13.26 | 527500.0 |
| 2005-12-01 | CTEC | ETF | 47.24999999999999 | 48.89999999999999 | 47.24999999999999 | 48.550000000000004 | 16414.4 |
| 2005-12-01 | CURE | ETF | 0.0725 | 0.0887 | 0.0653 | 0.0875 | 1484480.0 |
| 2005-12-01 | CYB | ETF | 3.62 | 3.65 | 3.62 | 3.65 | 7100.0 |
| 2005-12-01 | DGT | ETF | 65.41 | 65.72 | 65.36 | 65.69 | 2100.0 |
| 2005-12-01 | DIG | ETF | 14.9875 | 15.0 | 14.9875 | 15.0 | 2720.0 |
| 2005-12-01 | DIV | ETF | 12.04 | 12.13 | 12.01 | 12.03 | 24700.0 |
| 2005-12-01 | DRIV | ETF | 26.16 | 26.8 | 25.85 | 26.72 | 1433509.0 |
> showing 50 of 292 rows — these rows as CSV