PREVIEW / etf_daily / 2007-01-16
file: by_date/etf_daily/2007/2007-01-16.parquet size: 20 KB rows: 407
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-01-16 | SPY | ETF | 143.07 | 143.44 | 142.73 | 142.96 | 44871300.0 |
| 2007-01-16 | QQQ | ETF | 45.33 | 45.4 | 45.13 | 45.28 | 95948261.0 |
| 2007-01-16 | IWM | ETF | 79.21 | 79.36 | 78.3 | 78.45 | 33914700.0 |
| 2007-01-16 | DIA | ETF | 125.54 | 125.75 | 125.29 | 125.7 | 7052400.0 |
| 2007-01-16 | GLD | ETF | 62.2 | 62.3 | 61.74 | 61.97 | 3201000.0 |
| 2007-01-16 | TLT | ETF | 88.23 | 88.24 | 88.03 | 88.23 | 702800.0 |
| 2007-01-16 | AAA | ETF | 61.61 | 62.04 | 61.61 | 62.03 | 3200.0 |
| 2007-01-16 | ADRE | ETF | 38.04 | 38.22 | 37.92 | 38.028 | 288282.0 |
| 2007-01-16 | AGG | ETF | 99.82 | 99.92 | 99.67 | 99.8 | 448700.0 |
| 2007-01-16 | AIQ | ETF | 35.55 | 35.6 | 34.25 | 34.4 | 28780.0 |
| 2007-01-16 | AIS | ETF | 1.22 | 1.29 | 1.21 | 1.23 | 153600.0 |
| 2007-01-16 | ARB | ETF | 46.56 | 46.71 | 45.89 | 46.1 | 188100.0 |
| 2007-01-16 | BAB | ETF | 105.58 | 106.8 | 105.35 | 106.8 | 117700.0 |
| 2007-01-16 | BBC | ETF | 4.97 | 5.1658 | 4.97 | 5.03 | 261900.0 |
| 2007-01-16 | BBH | ETF | 64.5333 | 65.3567 | 64.5333 | 65.31 | 759300.0 |
| 2007-01-16 | BITS | ETF | 37.8 | 38.8 | 37.7808 | 38.0088 | 15561.0 |
| 2007-01-16 | BNE | ETF | 15.88 | 15.92 | 15.49 | 15.5 | 103600.0 |
| 2007-01-16 | BOSS | ETF | 43.7 | 43.7 | 43.29 | 43.29 | 100.0 |
| 2007-01-16 | BRF | ETF | 14.55 | 14.55 | 14.4 | 14.44 | 49500.0 |
| 2007-01-16 | BTF | ETF | 105.99999999999999 | 106.2495 | 105.89999999999999 | 106.05 | 740.0 |
| 2007-01-16 | CBON | ETF | 30.15 | 30.15 | 29.85 | 30.0 | 148097.0 |
| 2007-01-16 | CDL | ETF | 10.09 | 10.25 | 10.08 | 10.21 | 315200.0 |
| 2007-01-16 | CEF | ETF | 9.03 | 9.12 | 8.93 | 8.94 | 449900.0 |
| 2007-01-16 | CEW | ETF | 25.8 | 25.8887 | 25.76 | 25.77 | 2500.0 |
| 2007-01-16 | CGO | ETF | 16.68 | 16.95 | 16.55 | 16.92 | 34400.0 |
| 2007-01-16 | CHB | ETF | 8.44 | 8.56 | 8.29 | 8.44 | 1532100.0 |
| 2007-01-16 | CHI | ETF | 19.76 | 19.97 | 19.75 | 19.97 | 97300.0 |
| 2007-01-16 | CHIC | ETF | 32.78 | 33.05 | 32.0 | 32.42 | 390508.0 |
| 2007-01-16 | CHY | ETF | 17.02 | 17.1 | 16.98 | 17.01 | 121600.0 |
| 2007-01-16 | CIL | ETF | 25.31 | 25.31 | 25.31 | 25.31 | 100.0 |
| 2007-01-16 | CN | ETF | 50.0 | 50.44 | 49.22 | 50.24 | 154200.0 |
| 2007-01-16 | CNXT | ETF | 2.09 | 2.11 | 2.05 | 2.07 | 8128186.0 |
| 2007-01-16 | CPST | ETF | 1.11 | 1.16 | 1.1 | 1.12 | 2259665.0 |
| 2007-01-16 | CSA | ETF | 21.95 | 22.15 | 21.95 | 21.98 | 10000.0 |
| 2007-01-16 | CSB | ETF | 33.65 | 33.77 | 33.25 | 33.73 | 19300.0 |
| 2007-01-16 | CSD | ETF | 25.46 | 25.49 | 25.35 | 25.38 | 12900.0 |
| 2007-01-16 | CSM | ETF | 1.3125 | 1.3125 | 1.3125 | 1.3125 | 800.0 |
| 2007-01-16 | CSQ | ETF | 15.49 | 15.59 | 15.43 | 15.54 | 417000.0 |
| 2007-01-16 | CTEC | ETF | 93.75 | 94.60000000000001 | 93.0 | 93.24999999999999 | 20154.800000000003 |
| 2007-01-16 | CVY | ETF | 26.48 | 26.48 | 26.38 | 26.43 | 33200.0 |
| 2007-01-16 | DBA | ETF | 27.5 | 28.15 | 25.92 | 26.0 | 1685800.0 |
| 2007-01-16 | DBB | ETF | 24.0 | 24.0 | 23.66 | 23.67 | 5300.0 |
| 2007-01-16 | DBC | ETF | 23.05 | 23.1 | 22.35 | 22.65 | 467900.0 |
| 2007-01-16 | DBE | ETF | 22.95 | 23.11 | 22.43 | 22.66 | 19000.0 |
| 2007-01-16 | DBO | ETF | 22.4 | 22.49 | 21.75 | 22.03 | 43300.0 |
| 2007-01-16 | DBP | ETF | 25.07 | 25.07 | 24.76 | 24.78 | 6200.0 |
| 2007-01-16 | DBS | ETF | 25.4 | 25.4 | 24.81 | 24.85 | 8000.0 |
| 2007-01-16 | DBV | ETF | 26.4 | 26.4 | 26.26 | 26.32 | 186200.0 |
| 2007-01-16 | DDM | ETF | 6.9958 | 7.02 | 6.975 | 7.015 | 540000.0 |
| 2007-01-16 | DEF | ETF | 25.43 | 25.43 | 25.36 | 25.38 | 19300.0 |
> showing 50 of 407 rows — these rows as CSV