PREVIEW / etf_daily / 2007-04-24
file: by_date/etf_daily/2007/2007-04-24.parquet size: 21 KB rows: 449
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-24 | SPY | ETF | 148.23 | 148.4 | 147.32 | 148.12 | 114471000.0 |
| 2007-04-24 | QQQ | ETF | 45.63 | 45.83 | 45.33 | 45.7 | 108196954.0 |
| 2007-04-24 | IWM | ETF | 82.27 | 82.35 | 81.37 | 82.18 | 56640600.0 |
| 2007-04-24 | DIA | ETF | 129.33 | 129.77 | 128.9 | 129.48 | 10591300.0 |
| 2007-04-24 | GLD | ETF | 68.45 | 68.5 | 67.43 | 67.73 | 5073700.0 |
| 2007-04-24 | TLT | ETF | 88.45 | 88.82 | 88.45 | 88.8 | 881300.0 |
| 2007-04-24 | AAA | ETF | 70.95 | 71.12 | 70.56 | 71.03 | 28200.0 |
| 2007-04-24 | ADRE | ETF | 41.34 | 41.4646 | 41.11 | 41.38 | 82938.0 |
| 2007-04-24 | AGG | ETF | 100.31 | 100.45 | 100.26 | 100.29 | 227500.0 |
| 2007-04-24 | AIQ | ETF | 44.5 | 45.45 | 43.75 | 45.0 | 40620.0 |
| 2007-04-24 | AIS | ETF | 1.48 | 1.6 | 1.47 | 1.58 | 302100.0 |
| 2007-04-24 | ARB | ETF | 49.44 | 49.55 | 48.9 | 49.5 | 108600.0 |
| 2007-04-24 | BAB | ETF | 102.1 | 102.34 | 101.4 | 101.5 | 66600.0 |
| 2007-04-24 | BBH | ETF | 62.8333 | 62.8333 | 62.1233 | 62.33 | 981000.0 |
| 2007-04-24 | BITS | ETF | 33.0 | 33.32 | 31.68 | 31.84 | 14386.0 |
| 2007-04-24 | BIV | ETF | 75.47 | 75.63 | 75.44 | 75.56 | 8300.0 |
| 2007-04-24 | BLV | ETF | 75.81 | 75.99 | 75.81 | 75.97 | 25300.0 |
| 2007-04-24 | BND | ETF | 75.39 | 75.5 | 75.14 | 75.48 | 77500.0 |
| 2007-04-24 | BNE | ETF | 16.87 | 17.31 | 16.87 | 17.25 | 131000.0 |
| 2007-04-24 | BRF | ETF | 14.52 | 14.54 | 14.51 | 14.54 | 8600.0 |
| 2007-04-24 | BSV | ETF | 75.32 | 75.38 | 75.24 | 75.33 | 90400.0 |
| 2007-04-24 | BTF | ETF | 111.5 | 111.69999999999999 | 111.3175 | 111.69999999999999 | 180.0 |
| 2007-04-24 | CBON | ETF | 30.54 | 30.68 | 30.15 | 30.55 | 115073.0 |
| 2007-04-24 | CDL | ETF | 9.73 | 9.77 | 9.6 | 9.71 | 111100.0 |
| 2007-04-24 | CEF | ETF | 9.74 | 9.75 | 9.57 | 9.63 | 334100.0 |
| 2007-04-24 | CGO | ETF | 17.76 | 17.76 | 17.6 | 17.607 | 27400.0 |
| 2007-04-24 | CHB | ETF | 10.47 | 10.56 | 9.94 | 10.39 | 1489969.0 |
| 2007-04-24 | CHI | ETF | 20.19 | 20.27 | 20.13 | 20.26 | 86000.0 |
| 2007-04-24 | CHIC | ETF | 30.34 | 30.5 | 29.53 | 29.62 | 435891.0 |
| 2007-04-24 | CHY | ETF | 16.91 | 16.97 | 16.86 | 16.97 | 106000.0 |
| 2007-04-24 | CIL | ETF | 25.81 | 25.84 | 25.81 | 25.84 | 500.0 |
| 2007-04-24 | CN | ETF | 51.0 | 51.0 | 50.19 | 50.59 | 67600.0 |
| 2007-04-24 | CNXT | ETF | 1.45 | 1.59 | 1.45 | 1.55 | 22386802.0 |
| 2007-04-24 | CPI | ETF | 21.3 | 21.3 | 21.21 | 21.21 | 1700.0 |
| 2007-04-24 | CPST | ETF | 1.16 | 1.19 | 1.16 | 1.18 | 1833062.0 |
| 2007-04-24 | CSA | ETF | 20.87 | 20.99 | 20.67 | 20.96 | 12900.0 |
| 2007-04-24 | CSB | ETF | 33.56 | 33.85 | 33.35 | 33.51 | 22100.0 |
| 2007-04-24 | CSD | ETF | 28.6 | 28.66 | 28.5 | 28.52 | 14100.0 |
| 2007-04-24 | CSQ | ETF | 15.49 | 15.5 | 15.4 | 15.5 | 310500.0 |
| 2007-04-24 | CTEC | ETF | 90.0 | 90.0 | 88.75 | 88.75 | 5645.200000000001 |
| 2007-04-24 | CVY | ETF | 27.65 | 27.65 | 27.48 | 27.51 | 17900.0 |
| 2007-04-24 | CWI | ETF | 26.5 | 26.5533 | 26.4 | 26.52 | 14400.0 |
| 2007-04-24 | CZA | ETF | 26.15 | 26.15 | 26.15 | 26.15 | 200.0 |
| 2007-04-24 | DBA | ETF | 24.87 | 25.03 | 24.83 | 24.95 | 130800.0 |
| 2007-04-24 | DBB | ETF | 27.77 | 27.77 | 27.17 | 27.47 | 23100.0 |
| 2007-04-24 | DBC | ETF | 25.59 | 25.65 | 25.2 | 25.35 | 204700.0 |
| 2007-04-24 | DBE | ETF | 28.08 | 28.08 | 27.45 | 27.64 | 82200.0 |
| 2007-04-24 | DBO | ETF | 26.3 | 26.6 | 26.0 | 26.01 | 10400.0 |
| 2007-04-24 | DBP | ETF | 27.3 | 27.3 | 27.01 | 27.04 | 8600.0 |
| 2007-04-24 | DBS | ETF | 27.56 | 27.56 | 27.1 | 27.12 | 29000.0 |
> showing 50 of 449 rows — these rows as CSV