PREVIEW / etf_daily / 2007-04-03
file: by_date/etf_daily/2007/2007-04-03.parquet size: 21 KB rows: 436
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-04-03 | SPY | ETF | 142.97 | 143.98 | 142.91 | 143.69 | 82417800.0 |
| 2007-04-03 | QQQ | ETF | 43.82 | 44.31 | 43.79 | 44.16 | 105891342.0 |
| 2007-04-03 | IWM | ETF | 80.07 | 80.77 | 80.0 | 80.5 | 44410200.0 |
| 2007-04-03 | DIA | ETF | 124.21 | 125.26 | 124.21 | 124.99 | 7328400.0 |
| 2007-04-03 | GLD | ETF | 65.67 | 66.22 | 65.65 | 65.83 | 4141700.0 |
| 2007-04-03 | TLT | ETF | 88.02 | 88.17 | 87.98 | 87.99 | 617000.0 |
| 2007-04-03 | AAA | ETF | 65.76 | 66.16 | 65.6 | 66.16 | 9700.0 |
| 2007-04-03 | ADRE | ETF | 40.14 | 40.5 | 40.06 | 40.42 | 162164.0 |
| 2007-04-03 | AGG | ETF | 99.98 | 100.02 | 99.78 | 99.9 | 390600.0 |
| 2007-04-03 | AIQ | ETF | 43.45 | 43.45 | 41.45 | 41.8 | 55460.0 |
| 2007-04-03 | AIS | ETF | 1.47 | 1.52 | 1.46 | 1.5 | 672900.0 |
| 2007-04-03 | ARB | ETF | 47.28 | 48.11 | 47.17 | 48.11 | 136900.0 |
| 2007-04-03 | BAB | ETF | 100.14 | 100.77 | 99.99 | 100.5 | 78000.0 |
| 2007-04-03 | BBH | ETF | 59.0167 | 59.45 | 58.8367 | 59.13 | 217200.0 |
| 2007-04-03 | BITS | ETF | 31.6 | 31.72 | 30.4 | 31.28 | 11416.0 |
| 2007-04-03 | BNE | ETF | 15.73 | 15.88 | 15.63 | 15.86 | 164100.0 |
| 2007-04-03 | BRF | ETF | 14.53 | 14.53 | 14.5 | 14.5 | 21600.0 |
| 2007-04-03 | BTF | ETF | 108.75 | 109.39999999999999 | 108.75 | 109.39999999999999 | 1260.0 |
| 2007-04-03 | CBON | ETF | 30.92 | 31.57 | 30.85 | 31.25 | 49716.0 |
| 2007-04-03 | CDL | ETF | 9.53 | 9.67 | 9.52 | 9.6 | 323000.0 |
| 2007-04-03 | CEF | ETF | 9.38 | 9.47 | 9.35 | 9.37 | 139800.0 |
| 2007-04-03 | CGO | ETF | 17.23 | 17.3 | 17.1 | 17.2 | 19000.0 |
| 2007-04-03 | CHB | ETF | 8.7 | 9.11 | 8.63 | 8.91 | 2195500.0 |
| 2007-04-03 | CHI | ETF | 20.2 | 20.29 | 20.2 | 20.27 | 71700.0 |
| 2007-04-03 | CHIC | ETF | 29.81 | 30.07 | 29.54 | 29.85 | 438510.0 |
| 2007-04-03 | CHY | ETF | 16.98 | 17.01 | 16.92 | 16.94 | 83100.0 |
| 2007-04-03 | CN | ETF | 51.4 | 51.64 | 50.86 | 51.25 | 167800.0 |
| 2007-04-03 | CNXT | ETF | 1.67 | 1.67 | 1.62 | 1.62 | 10973272.0 |
| 2007-04-03 | CPST | ETF | 1.01 | 1.03 | 1.01 | 1.02 | 1042827.0 |
| 2007-04-03 | CSA | ETF | 21.04 | 21.16 | 20.16 | 21.13 | 26600.0 |
| 2007-04-03 | CSB | ETF | 33.24 | 33.4 | 33.2 | 33.25 | 6900.0 |
| 2007-04-03 | CSD | ETF | 27.53 | 27.68 | 27.53 | 27.6 | 12300.0 |
| 2007-04-03 | CSM | ETF | 1.3575 | 1.3575 | 1.3575 | 1.3575 | 18400.0 |
| 2007-04-03 | CSQ | ETF | 15.13 | 15.21 | 15.11 | 15.21 | 289000.0 |
| 2007-04-03 | CTEC | ETF | 89.3 | 89.39999999999999 | 85.6 | 88.1 | 19902.4 |
| 2007-04-03 | CVY | ETF | 26.76 | 26.8 | 26.67 | 26.76 | 15800.0 |
| 2007-04-03 | CWI | ETF | 25.6667 | 25.8667 | 25.6667 | 25.8133 | 39450.0 |
| 2007-04-03 | CZA | ETF | 25.43 | 25.43 | 25.43 | 25.43 | 300.0 |
| 2007-04-03 | DBA | ETF | 25.17 | 25.22 | 24.72 | 24.88 | 506800.0 |
| 2007-04-03 | DBB | ETF | 25.26 | 25.65 | 25.26 | 25.63 | 4600.0 |
| 2007-04-03 | DBC | ETF | 25.17 | 25.17 | 24.85 | 25.03 | 370600.0 |
| 2007-04-03 | DBE | ETF | 27.5 | 27.5 | 27.18 | 27.38 | 6700.0 |
| 2007-04-03 | DBO | ETF | 26.85 | 26.88 | 26.24 | 26.72 | 15500.0 |
| 2007-04-03 | DBP | ETF | 26.2 | 26.36 | 26.2 | 26.23 | 15600.0 |
| 2007-04-03 | DBS | ETF | 26.18 | 26.47 | 26.1 | 26.35 | 50800.0 |
| 2007-04-03 | DBV | ETF | 27.24 | 27.29 | 27.2 | 27.28 | 68500.0 |
| 2007-04-03 | DDM | ETF | 6.7842 | 6.88 | 6.7842 | 6.85 | 1033200.0 |
| 2007-04-03 | DEF | ETF | 26.2 | 26.33 | 26.2 | 26.2968 | 2800.0 |
| 2007-04-03 | DES | ETF | 19.2 | 19.4 | 19.2 | 19.37 | 62400.0 |
| 2007-04-03 | DEW | ETF | 64.07 | 64.45 | 64.01 | 64.27 | 14700.0 |
> showing 50 of 436 rows — these rows as CSV