PREVIEW / etf_daily / 2007-05-15
file: by_date/etf_daily/2007/2007-05-15.parquet size: 22 KB rows: 470
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-05-15 | SPY | ETF | 150.7 | 151.66 | 150.19 | 150.57 | 180673300.0 |
| 2007-05-15 | QQQ | ETF | 46.41 | 46.7 | 45.99 | 46.1 | 179489134.0 |
| 2007-05-15 | IWM | ETF | 81.62 | 82.28 | 80.78 | 80.97 | 115258700.0 |
| 2007-05-15 | DIA | ETF | 133.79 | 134.94 | 133.63 | 134.12 | 21494200.0 |
| 2007-05-15 | GLD | ETF | 65.89 | 66.73 | 65.88 | 66.54 | 2566600.0 |
| 2007-05-15 | TLT | ETF | 88.19 | 88.21 | 87.66 | 87.93 | 382400.0 |
| 2007-05-15 | AAA | ETF | 27.0 | 27.65 | 27.0 | 27.22 | 215500.0 |
| 2007-05-15 | ADRE | ETF | 42.54 | 43.02 | 42.5 | 42.69 | 119757.0 |
| 2007-05-15 | AGG | ETF | 99.99 | 100.0 | 99.75 | 99.89 | 266100.0 |
| 2007-05-15 | AIQ | ETF | 43.6 | 43.85 | 42.55 | 42.75 | 26500.0 |
| 2007-05-15 | AIS | ETF | 1.86 | 1.95 | 1.79 | 1.79 | 1239100.0 |
| 2007-05-15 | ARB | ETF | 48.31 | 48.77 | 47.94 | 48.25 | 157000.0 |
| 2007-05-15 | BAB | ETF | 96.61 | 98.23 | 96.61 | 96.91 | 85800.0 |
| 2007-05-15 | BBH | ETF | 59.5 | 60.02 | 59.2733 | 59.2967 | 990600.0 |
| 2007-05-15 | BITS | ETF | 30.4 | 31.52 | 30.4 | 30.84 | 16690.0 |
| 2007-05-15 | BIV | ETF | 75.3 | 75.3 | 75.11 | 75.18 | 6200.0 |
| 2007-05-15 | BLV | ETF | 75.43 | 75.43 | 75.1 | 75.24 | 5500.0 |
| 2007-05-15 | BMVP | ETF | 18.0333 | 18.1 | 17.94 | 17.94 | 42200.0 |
| 2007-05-15 | BND | ETF | 75.29 | 75.3 | 75.18 | 75.2 | 31600.0 |
| 2007-05-15 | BNE | ETF | 18.29 | 19.01 | 17.72 | 18.71 | 1210400.0 |
| 2007-05-15 | BRF | ETF | 14.51 | 14.54 | 14.51 | 14.54 | 2500.0 |
| 2007-05-15 | BSV | ETF | 75.24 | 75.24 | 75.14 | 75.19 | 65400.0 |
| 2007-05-15 | BTF | ETF | 112.55 | 112.55 | 110.44999999999999 | 110.5 | 1220.0 |
| 2007-05-15 | CBON | ETF | 30.0 | 30.49 | 29.66 | 29.66 | 41376.0 |
| 2007-05-15 | CDL | ETF | 8.37 | 8.55 | 8.3 | 8.3 | 554400.0 |
| 2007-05-15 | CEF | ETF | 9.11 | 9.29 | 9.11 | 9.2 | 534600.0 |
| 2007-05-15 | CGO | ETF | 17.67 | 17.72 | 17.58 | 17.63 | 21400.0 |
| 2007-05-15 | CGW | ETF | 24.82 | 25.2 | 24.62 | 25.1 | 248000.0 |
| 2007-05-15 | CHB | ETF | 11.65 | 11.8 | 11.22 | 11.5 | 3160389.0 |
| 2007-05-15 | CHI | ETF | 20.31 | 20.36 | 20.23 | 20.2401 | 95600.0 |
| 2007-05-15 | CHIC | ETF | 25.36 | 25.77 | 24.98 | 25.03 | 333337.0 |
| 2007-05-15 | CHY | ETF | 17.15 | 17.18 | 17.12 | 17.12 | 95300.0 |
| 2007-05-15 | CIL | ETF | 25.99 | 25.99 | 25.99 | 25.99 | 1000.0 |
| 2007-05-15 | CN | ETF | 48.0 | 48.4 | 47.88 | 48.05 | 69813.0 |
| 2007-05-15 | CNXT | ETF | 1.46 | 1.47 | 1.4 | 1.41 | 7888085.0 |
| 2007-05-15 | CPST | ETF | 0.94 | 0.94 | 0.9 | 0.9 | 2920975.0 |
| 2007-05-15 | CSA | ETF | 20.75 | 20.87 | 20.6801 | 20.82 | 20900.0 |
| 2007-05-15 | CSB | ETF | 31.93 | 32.36 | 31.77 | 32.12 | 11700.0 |
| 2007-05-15 | CSD | ETF | 29.5 | 29.6 | 29.26 | 29.26 | 26000.0 |
| 2007-05-15 | CSQ | ETF | 15.5 | 15.55 | 15.48 | 15.49 | 382500.0 |
| 2007-05-15 | CTEC | ETF | 87.44999999999999 | 89.85 | 86.69999999999999 | 87.10000000000001 | 8159.6 |
| 2007-05-15 | CVY | ETF | 27.88 | 28.12 | 27.88 | 27.9 | 25400.0 |
| 2007-05-15 | CWI | ETF | 26.9133 | 27.0267 | 26.8 | 26.8533 | 13500.0 |
| 2007-05-15 | CZA | ETF | 26.64 | 26.64 | 26.44 | 26.44 | 200.0 |
| 2007-05-15 | DBA | ETF | 25.0 | 25.42 | 24.88 | 25.34 | 313300.0 |
| 2007-05-15 | DBB | ETF | 27.7 | 27.93 | 27.32 | 27.91 | 73500.0 |
| 2007-05-15 | DBC | ETF | 25.08 | 25.53 | 25.04 | 25.51 | 448800.0 |
| 2007-05-15 | DBE | ETF | 27.73 | 28.04 | 27.73 | 27.93 | 19100.0 |
| 2007-05-15 | DBO | ETF | 25.94 | 26.25 | 25.92 | 26.25 | 87100.0 |
| 2007-05-15 | DBP | ETF | 26.28 | 26.5 | 26.28 | 26.38 | 10400.0 |
> showing 50 of 470 rows — these rows as CSV