PREVIEW / etf_daily / 2007-03-28
file: by_date/etf_daily/2007/2007-03-28.parquet size: 21 KB rows: 439
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-28 | SPY | ETF | 142.14 | 142.47 | 141.26 | 141.82 | 152907900.0 |
| 2007-03-28 | QQQ | ETF | 43.785 | 44.03 | 43.51 | 43.52 | 144921586.0 |
| 2007-03-28 | IWM | ETF | 79.22 | 79.5 | 78.61 | 79.15 | 67939400.0 |
| 2007-03-28 | DIA | ETF | 123.52 | 123.61 | 122.45 | 123.0 | 13868800.0 |
| 2007-03-28 | GLD | ETF | 66.14 | 66.48 | 65.77 | 66.05 | 6310000.0 |
| 2007-03-28 | TLT | ETF | 88.91 | 89.11 | 88.41 | 88.57 | 816900.0 |
| 2007-03-28 | AAA | ETF | 64.51 | 64.69 | 64.34 | 64.34 | 5900.0 |
| 2007-03-28 | ADRE | ETF | 39.06 | 39.18 | 38.65 | 38.83 | 114093.0 |
| 2007-03-28 | AGG | ETF | 100.55 | 100.65 | 100.34 | 100.42 | 217600.0 |
| 2007-03-28 | AIQ | ETF | 41.15 | 41.95 | 41.0 | 41.4 | 33660.0 |
| 2007-03-28 | AIS | ETF | 1.2 | 1.21 | 1.16 | 1.17 | 47800.0 |
| 2007-03-28 | ARB | ETF | 47.0 | 47.14 | 46.42 | 46.88 | 285600.0 |
| 2007-03-28 | BAB | ETF | 97.18 | 98.92 | 97.0 | 98.32 | 121600.0 |
| 2007-03-28 | BBH | ETF | 58.7467 | 59.18 | 58.3367 | 58.4667 | 708600.0 |
| 2007-03-28 | BITS | ETF | 33.2 | 33.2 | 32.2 | 32.68 | 13168.0 |
| 2007-03-28 | BNE | ETF | 15.52 | 15.52 | 15.23 | 15.25 | 414800.0 |
| 2007-03-28 | BRF | ETF | 14.5 | 14.58 | 14.46 | 14.53 | 29300.0 |
| 2007-03-28 | BTF | ETF | 107.79999999999998 | 108.20499999999998 | 107.79999999999998 | 108.20499999999998 | 620.0 |
| 2007-03-28 | CBON | ETF | 30.62 | 30.69 | 30.33 | 30.43 | 80031.0 |
| 2007-03-28 | CDL | ETF | 9.57 | 9.58 | 9.46 | 9.49 | 372600.0 |
| 2007-03-28 | CEF | ETF | 9.45 | 9.5 | 9.44 | 9.5 | 176300.0 |
| 2007-03-28 | CGO | ETF | 17.07 | 17.19 | 17.07 | 17.17 | 6000.0 |
| 2007-03-28 | CHB | ETF | 9.24 | 9.29 | 8.86 | 9.06 | 2690700.0 |
| 2007-03-28 | CHI | ETF | 20.21 | 20.25 | 20.12 | 20.2 | 70600.0 |
| 2007-03-28 | CHIC | ETF | 28.52 | 28.7 | 28.02 | 28.47 | 425429.0 |
| 2007-03-28 | CHY | ETF | 16.88 | 17.0 | 16.88 | 16.96 | 81900.0 |
| 2007-03-28 | CIL | ETF | 25.78 | 25.78 | 25.78 | 25.78 | 100.0 |
| 2007-03-28 | CN | ETF | 49.25 | 49.74 | 48.9 | 49.49 | 130500.0 |
| 2007-03-28 | CNXT | ETF | 1.67 | 1.7 | 1.65 | 1.66 | 4494624.0 |
| 2007-03-28 | CPI | ETF | 22.25 | 22.38 | 22.25 | 22.353 | 2100.0 |
| 2007-03-28 | CPST | ETF | 0.99 | 1.08 | 0.98 | 1.01 | 4296449.0 |
| 2007-03-28 | CSA | ETF | 20.82 | 20.99 | 20.22 | 20.62 | 33700.0 |
| 2007-03-28 | CSB | ETF | 32.84 | 32.93 | 32.54 | 32.7 | 17400.0 |
| 2007-03-28 | CSD | ETF | 27.02 | 27.13 | 26.98 | 27.05 | 85200.0 |
| 2007-03-28 | CSQ | ETF | 15.09 | 15.13 | 15.03 | 15.09 | 285100.0 |
| 2007-03-28 | CTEC | ETF | 89.3 | 89.3 | 87.24999999999999 | 87.24999999999999 | 6626.6 |
| 2007-03-28 | CVY | ETF | 26.55 | 26.61 | 26.47 | 26.5 | 21800.0 |
| 2007-03-28 | CWI | ETF | 25.2467 | 25.2467 | 25.1133 | 25.14 | 6450.0 |
| 2007-03-28 | DBA | ETF | 26.04 | 26.11 | 25.8 | 26.07 | 149600.0 |
| 2007-03-28 | DBB | ETF | 24.43 | 24.51 | 24.35 | 24.51 | 2100.0 |
| 2007-03-28 | DBC | ETF | 25.35 | 25.4 | 25.16 | 25.27 | 261300.0 |
| 2007-03-28 | DBE | ETF | 27.4 | 27.66 | 27.28 | 27.3 | 75300.0 |
| 2007-03-28 | DBO | ETF | 26.56 | 26.81 | 26.37 | 26.49 | 44700.0 |
| 2007-03-28 | DBP | ETF | 26.37 | 26.4 | 26.22 | 26.33 | 15900.0 |
| 2007-03-28 | DBS | ETF | 26.44 | 26.47 | 26.28 | 26.3 | 1900.0 |
| 2007-03-28 | DBV | ETF | 26.66 | 26.83 | 26.66 | 26.79 | 87700.0 |
| 2007-03-28 | DDM | ETF | 6.7075 | 6.7075 | 6.59 | 6.6617 | 1155600.0 |
| 2007-03-28 | DEF | ETF | 25.86 | 25.91 | 25.73 | 25.7944 | 59100.0 |
| 2007-03-28 | DES | ETF | 19.06 | 19.1367 | 18.9967 | 19.0433 | 89400.0 |
| 2007-03-28 | DEW | ETF | 62.79 | 62.93 | 62.63 | 62.65 | 10200.0 |
> showing 50 of 439 rows — these rows as CSV