PREVIEW / etf_daily / 2006-02-17
file: by_date/etf_daily/2006/2006-02-17.parquet size: 16 KB rows: 301
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-02-17 | SPY | ETF | 129.05 | 129.16 | 128.58 | 128.81 | 40342600.0 |
| 2006-02-17 | QQQ | ETF | 41.45 | 41.46 | 41.2 | 41.21 | 81770143.0 |
| 2006-02-17 | IWM | ETF | 72.83 | 72.9 | 72.3 | 72.65 | 17558400.0 |
| 2006-02-17 | DIA | ETF | 111.03 | 111.23 | 110.68 | 111.02 | 3941800.0 |
| 2006-02-17 | GLD | ETF | 54.67 | 55.2 | 54.6 | 54.96 | 3927200.0 |
| 2006-02-17 | TLT | ETF | 90.8 | 91.07 | 90.8 | 90.95 | 731400.0 |
| 2006-02-17 | AAA | ETF | 54.17 | 54.85 | 54.17 | 54.85 | 700.0 |
| 2006-02-17 | ADRE | ETF | 129.5 | 129.5 | 128.3801 | 128.74 | 27136.0 |
| 2006-02-17 | AFK | ETF | 25.5 | 25.5 | 25.38 | 25.5 | 3100.0 |
| 2006-02-17 | AGG | ETF | 99.92 | 100.31 | 99.92 | 100.27 | 155800.0 |
| 2006-02-17 | AIQ | ETF | 20.0 | 25.95 | 20.0 | 25.75 | 66360.0 |
| 2006-02-17 | AIS | ETF | 1.45 | 1.45 | 1.37 | 1.43 | 149500.0 |
| 2006-02-17 | AOM | ETF | 5.65 | 6.0 | 5.6 | 5.91 | 49100.0 |
| 2006-02-17 | ARB | ETF | 38.75 | 38.75 | 38.2 | 38.62 | 224700.0 |
| 2006-02-17 | BAB | ETF | 57.84 | 58.49 | 57.66 | 58.25 | 19000.0 |
| 2006-02-17 | BBC | ETF | 15.62 | 15.62 | 15.0 | 15.0699 | 104200.0 |
| 2006-02-17 | BBH | ETF | 65.1667 | 65.2733 | 64.9933 | 65.2667 | 456600.0 |
| 2006-02-17 | BCM | ETF | 67.56 | 68.11 | 67.56 | 67.79 | 8700.0 |
| 2006-02-17 | BITS | ETF | 25.2 | 25.84 | 24.84 | 25.84 | 34024.0 |
| 2006-02-17 | BKF | ETF | 13.6 | 13.72 | 13.56 | 13.6 | 30800.0 |
| 2006-02-17 | BNE | ETF | 15.1 | 15.1 | 14.96 | 15.02 | 50400.0 |
| 2006-02-17 | BRF | ETF | 15.38 | 15.43 | 15.38 | 15.41 | 900.0 |
| 2006-02-17 | BTF | ETF | 87.14999999999999 | 87.24999999999999 | 86.99999999999999 | 86.99999999999999 | 6000.0 |
| 2006-02-17 | CBON | ETF | 30.0 | 30.0 | 29.8 | 29.91 | 7277.0 |
| 2006-02-17 | CDL | ETF | 11.83 | 11.84 | 11.65 | 11.67 | 342100.0 |
| 2006-02-17 | CEF | ETF | 7.47 | 7.52 | 7.39 | 7.42 | 508800.0 |
| 2006-02-17 | CEW | ETF | 26.351 | 26.351 | 26.351 | 26.351 | 200.0 |
| 2006-02-17 | CGO | ETF | 14.21 | 14.25 | 14.1 | 14.22 | 32600.0 |
| 2006-02-17 | CHB | ETF | 14.9 | 15.48 | 14.9 | 15.3 | 1243400.0 |
| 2006-02-17 | CHI | ETF | 20.52 | 20.7 | 20.5 | 20.62 | 93800.0 |
| 2006-02-17 | CHIC | ETF | 17.94 | 18.1 | 17.52 | 17.9 | 173702.0 |
| 2006-02-17 | CHIR | ETF | 45.39 | 45.6201 | 45.3099 | 45.3699 | 535494.0 |
| 2006-02-17 | CHY | ETF | 16.21 | 16.23 | 16.15 | 16.18 | 79400.0 |
| 2006-02-17 | CIL | ETF | 25.51 | 25.57 | 25.51 | 25.57 | 800.0 |
| 2006-02-17 | CIZ | ETF | 23.05 | 23.05 | 23.05 | 23.05 | 200.0 |
| 2006-02-17 | CN | ETF | 34.35 | 34.48 | 34.31 | 34.44 | 9700.0 |
| 2006-02-17 | CNXT | ETF | 3.0 | 3.03 | 2.95 | 3.0 | 11853319.0 |
| 2006-02-17 | COMB | ETF | 8.5504 | 8.5504 | 8.5 | 8.5 | 20200.0 |
| 2006-02-17 | CPST | ETF | 3.07 | 3.15 | 3.06 | 3.08 | 1614356.0 |
| 2006-02-17 | CSA | ETF | 18.55 | 18.9 | 18.52 | 18.71 | 13800.0 |
| 2006-02-17 | CSB | ETF | 31.84 | 32.15 | 31.84 | 32.11 | 5700.0 |
| 2006-02-17 | CSM | ETF | 2.475 | 2.475 | 2.475 | 2.475 | 400.0 |
| 2006-02-17 | CSQ | ETF | 14.05 | 14.15 | 14.0 | 14.07 | 354500.0 |
| 2006-02-17 | CTEC | ETF | 59.15 | 59.45 | 58.099999999999994 | 58.949999999999996 | 12277.2 |
| 2006-02-17 | CURE | ETF | 0.025 | 0.0275 | 0.025 | 0.0262 | 3154224.0 |
| 2006-02-17 | CYB | ETF | 5.72 | 5.7999 | 5.56 | 5.75 | 71100.0 |
| 2006-02-17 | DBC | ETF | 22.72 | 22.92 | 22.68 | 22.9 | 467700.0 |
| 2006-02-17 | DGT | ETF | 66.8 | 66.8 | 66.56 | 66.67 | 15200.0 |
| 2006-02-17 | DIG | ETF | 17.0375 | 17.0375 | 17.0375 | 17.0375 | 320.0 |
| 2006-02-17 | DIV | ETF | 12.33 | 12.47 | 12.33 | 12.46 | 27800.0 |
> showing 50 of 301 rows — these rows as CSV