PREVIEW / etf_daily / 2007-03-06
file: by_date/etf_daily/2007/2007-03-06.parquet size: 21 KB rows: 434
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-03-06 | SPY | ETF | 138.78 | 140.12 | 137.72 | 139.7 | 143333300.0 |
| 2007-03-06 | QQQ | ETF | 42.56 | 42.99 | 42.5 | 42.85 | 155742094.0 |
| 2007-03-06 | IWM | ETF | 76.26 | 77.71 | 76.19 | 77.22 | 94041400.0 |
| 2007-03-06 | DIA | ETF | 121.28 | 122.29 | 120.98 | 122.06 | 9048100.0 |
| 2007-03-06 | GLD | ETF | 63.66 | 64.37 | 63.46 | 64.15 | 6992700.0 |
| 2007-03-06 | TLT | ETF | 90.06 | 90.36 | 89.99 | 90.08 | 837400.0 |
| 2007-03-06 | AAA | ETF | 59.89 | 60.2 | 59.75 | 60.2 | 22100.0 |
| 2007-03-06 | ADRE | ETF | 36.33 | 37.54 | 36.33 | 37.4 | 252618.0 |
| 2007-03-06 | AGG | ETF | 100.41 | 100.6 | 100.41 | 100.52 | 221300.0 |
| 2007-03-06 | AIQ | ETF | 35.1 | 36.65 | 35.0 | 36.6 | 31720.0 |
| 2007-03-06 | AIS | ETF | 1.11 | 1.17 | 1.11 | 1.13 | 148100.0 |
| 2007-03-06 | ARB | ETF | 45.0 | 45.66 | 45.0 | 45.36 | 516800.0 |
| 2007-03-06 | BAB | ETF | 97.44 | 98.8 | 97.44 | 98.41 | 50800.0 |
| 2007-03-06 | BBC | ETF | 3.99 | 3.99 | 3.73 | 3.913 | 156400.0 |
| 2007-03-06 | BBH | ETF | 59.2667 | 59.89 | 58.88 | 59.3167 | 1690200.0 |
| 2007-03-06 | BITS | ETF | 28.0 | 28.8 | 27.92 | 28.12 | 70541.0 |
| 2007-03-06 | BNE | ETF | 15.04 | 15.13 | 14.88 | 15.04 | 139600.0 |
| 2007-03-06 | BOSS | ETF | 42.1 | 42.1 | 42.1 | 42.1 | 100.0 |
| 2007-03-06 | BRF | ETF | 14.52 | 14.59 | 14.5 | 14.54 | 2900.0 |
| 2007-03-06 | BTF | ETF | 106.5 | 108.1995 | 106.5 | 107.5 | 4960.0 |
| 2007-03-06 | CBON | ETF | 30.11 | 31.61 | 30.05 | 31.42 | 27838.0 |
| 2007-03-06 | CDL | ETF | 9.73 | 9.81 | 9.61 | 9.76 | 352700.0 |
| 2007-03-06 | CEF | ETF | 9.18 | 9.25 | 9.05 | 9.18 | 286800.0 |
| 2007-03-06 | CGO | ETF | 16.06 | 16.3399 | 16.02 | 16.3399 | 16000.0 |
| 2007-03-06 | CHB | ETF | 7.25 | 7.5 | 7.18 | 7.39 | 2442200.0 |
| 2007-03-06 | CHI | ETF | 19.85 | 19.94 | 19.79 | 19.87 | 179800.0 |
| 2007-03-06 | CHIC | ETF | 28.35 | 28.6 | 28.26 | 28.4 | 459591.0 |
| 2007-03-06 | CHY | ETF | 16.53 | 16.6 | 16.48 | 16.52 | 156500.0 |
| 2007-03-06 | CIL | ETF | 25.49 | 25.49 | 25.49 | 25.49 | 100.0 |
| 2007-03-06 | CN | ETF | 43.46 | 44.72 | 43.46 | 44.41 | 84000.0 |
| 2007-03-06 | CNXT | ETF | 1.89 | 1.902 | 1.86 | 1.89 | 6501616.0 |
| 2007-03-06 | CPI | ETF | 22.85 | 22.85 | 22.85 | 22.85 | 200.0 |
| 2007-03-06 | CPST | ETF | 0.79 | 0.8101 | 0.78 | 0.7975 | 2637983.0 |
| 2007-03-06 | CSA | ETF | 21.1 | 21.34 | 21.1 | 21.33 | 3600.0 |
| 2007-03-06 | CSB | ETF | 31.79 | 32.08 | 31.78 | 31.97 | 17400.0 |
| 2007-03-06 | CSD | ETF | 25.47 | 25.71 | 25.4 | 25.66 | 4800.0 |
| 2007-03-06 | CSM | ETF | 1.265 | 1.3 | 1.2 | 1.3 | 42400.0 |
| 2007-03-06 | CSQ | ETF | 14.69 | 14.78 | 14.63 | 14.78 | 345200.0 |
| 2007-03-06 | CTEC | ETF | 80.8 | 80.8 | 78.39999999999999 | 79.95 | 15128.2 |
| 2007-03-06 | CVY | ETF | 26.23 | 26.27 | 26.01 | 26.24 | 27200.0 |
| 2007-03-06 | CWI | ETF | 24.12 | 24.3333 | 24.12 | 24.3267 | 126000.0 |
| 2007-03-06 | DBA | ETF | 26.5 | 26.53 | 26.16 | 26.2 | 127400.0 |
| 2007-03-06 | DBB | ETF | 23.85 | 23.85 | 23.65 | 23.8 | 3700.0 |
| 2007-03-06 | DBC | ETF | 24.66 | 24.75 | 24.47 | 24.66 | 143300.0 |
| 2007-03-06 | DBE | ETF | 25.97 | 26.18 | 25.82 | 26.16 | 37500.0 |
| 2007-03-06 | DBO | ETF | 25.31 | 25.63 | 25.31 | 25.43 | 4300.0 |
| 2007-03-06 | DBP | ETF | 25.42 | 25.56 | 25.33 | 25.56 | 13200.0 |
| 2007-03-06 | DBS | ETF | 25.12 | 25.48 | 25.08 | 25.43 | 13400.0 |
| 2007-03-06 | DBV | ETF | 25.82 | 25.99 | 25.7901 | 25.95 | 130900.0 |
| 2007-03-06 | DDM | ETF | 6.5208 | 6.5983 | 6.4625 | 6.585 | 2060400.0 |
> showing 50 of 434 rows — these rows as CSV