PREVIEW / etf_daily / 2007-10-11
file: by_date/etf_daily/2007/2007-10-11.parquet size: 23 KB rows: 516
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-10-11 | SPY | ETF | 156.93 | 157.52 | 154.54 | 155.47 | 233529100.0 |
| 2007-10-11 | QQQ | ETF | 53.79 | 53.94 | 52.28 | 52.66 | 239786623.0 |
| 2007-10-11 | IWM | ETF | 84.59 | 84.89 | 82.66 | 83.16 | 93750000.0 |
| 2007-10-11 | DIA | ETF | 141.36 | 141.95 | 139.46 | 140.21 | 21857700.0 |
| 2007-10-11 | GLD | ETF | 73.98 | 74.59 | 73.28 | 73.91 | 10291400.0 |
| 2007-10-11 | TLT | ETF | 87.52 | 88.09 | 87.45 | 88.06 | 1533400.0 |
| 2007-10-11 | ADRE | ETF | 57.7 | 57.7 | 54.53 | 55.54 | 388069.0 |
| 2007-10-11 | AGG | ETF | 99.39 | 99.64 | 99.24 | 99.64 | 258000.0 |
| 2007-10-11 | AIQ | ETF | 46.6 | 47.6 | 45.95 | 46.3 | 30640.0 |
| 2007-10-11 | AIS | ETF | 1.29 | 1.4 | 1.29 | 1.37 | 428600.0 |
| 2007-10-11 | AIVI | ETF | 75.37 | 76.06 | 74.78 | 74.99 | 29900.0 |
| 2007-10-11 | ARB | ETF | 47.2 | 47.23 | 45.83 | 45.98 | 297200.0 |
| 2007-10-11 | BBH | ETF | 59.7467 | 59.7467 | 58.8767 | 59.1967 | 745500.0 |
| 2007-10-11 | BIL | ETF | 91.72 | 91.72 | 91.66 | 91.68 | 10200.0 |
| 2007-10-11 | BITS | ETF | 25.88 | 27.76 | 25.56 | 26.8 | 13401.0 |
| 2007-10-11 | BIV | ETF | 75.12 | 75.33 | 75.1 | 75.33 | 9700.0 |
| 2007-10-11 | BLV | ETF | 74.31 | 74.74 | 74.31 | 74.74 | 12200.0 |
| 2007-10-11 | BMVP | ETF | 17.8 | 17.85 | 17.5 | 17.58 | 148600.0 |
| 2007-10-11 | BND | ETF | 75.25 | 75.48 | 75.21 | 75.47 | 125100.0 |
| 2007-10-11 | BNE | ETF | 17.94 | 18.0 | 17.51 | 17.68 | 212900.0 |
| 2007-10-11 | BRF | ETF | 14.6 | 14.61 | 14.6 | 14.61 | 1400.0 |
| 2007-10-11 | BSV | ETF | 75.54 | 75.77 | 75.54 | 75.76 | 58100.0 |
| 2007-10-11 | BTF | ETF | 110.0 | 110.99999999999999 | 110.0 | 110.25 | 720.0 |
| 2007-10-11 | BWX | ETF | 26.055 | 26.1 | 26.005 | 26.025 | 53200.0 |
| 2007-10-11 | CBON | ETF | 25.43 | 25.5 | 25.3 | 25.46 | 71751.0 |
| 2007-10-11 | CDL | ETF | 4.52 | 4.8 | 4.5 | 4.73 | 3140800.0 |
| 2007-10-11 | CEF | ETF | 9.92 | 10.0 | 9.9 | 10.0 | 589200.0 |
| 2007-10-11 | CGO | ETF | 18.48 | 18.53 | 18.29 | 18.29 | 29600.0 |
| 2007-10-11 | CGW | ETF | 26.45 | 26.56 | 26.0 | 26.15 | 94000.0 |
| 2007-10-11 | CHB | ETF | 12.16 | 12.32 | 11.77 | 12.01 | 1924606.0 |
| 2007-10-11 | CHI | ETF | 17.09 | 17.15 | 17.04 | 17.06 | 115200.0 |
| 2007-10-11 | CHIC | ETF | 14.65 | 15.07 | 14.46 | 14.6 | 1239219.0 |
| 2007-10-11 | CHW | ETF | 13.7 | 13.76 | 13.26 | 13.38 | 188300.0 |
| 2007-10-11 | CHY | ETF | 15.45 | 15.48 | 15.33 | 15.33 | 106400.0 |
| 2007-10-11 | CMF | ETF | 51.675 | 51.7 | 51.65 | 51.7 | 10600.0 |
| 2007-10-11 | CN | ETF | 60.2 | 60.71 | 57.76 | 58.21 | 485300.0 |
| 2007-10-11 | CNXT | ETF | 1.41 | 1.42 | 1.35 | 1.39 | 9856725.0 |
| 2007-10-11 | CPST | ETF | 1.15 | 1.17 | 1.11 | 1.11 | 2638392.0 |
| 2007-10-11 | CSA | ETF | 18.7 | 18.72 | 18.42 | 18.51 | 33500.0 |
| 2007-10-11 | CSD | ETF | 30.1 | 30.15 | 29.59 | 29.75 | 14700.0 |
| 2007-10-11 | CSQ | ETF | 14.58 | 14.98 | 14.46 | 14.85 | 301000.0 |
| 2007-10-11 | CVY | ETF | 26.76 | 26.86 | 26.46 | 26.6 | 54400.0 |
| 2007-10-11 | CWI | ETF | 29.44 | 29.6133 | 29.1667 | 29.2467 | 187350.0 |
| 2007-10-11 | CZA | ETF | 27.4501 | 27.4501 | 27.45 | 27.45 | 800.0 |
| 2007-10-11 | DBA | ETF | 28.52 | 28.66 | 28.29 | 28.6 | 294800.0 |
| 2007-10-11 | DBB | ETF | 26.59 | 26.7 | 26.25 | 26.49 | 20900.0 |
| 2007-10-11 | DBC | ETF | 28.67 | 28.67 | 27.54 | 27.99 | 204300.0 |
| 2007-10-11 | DBE | ETF | 30.74 | 31.15 | 30.66 | 30.89 | 17000.0 |
| 2007-10-11 | DBO | ETF | 29.77 | 30.22 | 29.74 | 30.05 | 6800.0 |
| 2007-10-11 | DBP | ETF | 28.69 | 28.98 | 28.63 | 28.75 | 28800.0 |
> showing 50 of 516 rows — these rows as CSV