PREVIEW / etf_daily / 2007-04-16
file: by_date/etf_daily/2007/2007-04-16.parquet size: 21 KB rows: 452
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-16 | SPY | ETF | 145.83 | 146.86 | 145.82 | 146.7 | 83064600.0 |
| 2007-04-16 | QQQ | ETF | 44.83 | 45.15 | 44.83 | 45.06 | 73028087.0 |
| 2007-04-16 | IWM | ETF | 81.81 | 82.57 | 81.8 | 82.48 | 43967100.0 |
| 2007-04-16 | DIA | ETF | 126.47 | 127.29 | 126.45 | 127.04 | 7969000.0 |
| 2007-04-16 | GLD | ETF | 68.14 | 68.5 | 67.68 | 68.4 | 7912300.0 |
| 2007-04-16 | TLT | ETF | 87.4 | 87.68 | 87.4 | 87.6 | 833600.0 |
| 2007-04-16 | AAA | ETF | 67.92 | 68.15 | 67.9 | 68.01 | 15500.0 |
| 2007-04-16 | ADRE | ETF | 41.6 | 42.05 | 41.55 | 42.05 | 187412.0 |
| 2007-04-16 | AGG | ETF | 99.65 | 99.8 | 99.57 | 99.79 | 396400.0 |
| 2007-04-16 | AIQ | ETF | 45.8 | 46.5 | 45.15 | 46.2 | 49920.0 |
| 2007-04-16 | AIS | ETF | 1.44 | 1.5 | 1.42 | 1.44 | 285900.0 |
| 2007-04-16 | ARB | ETF | 48.65 | 49.15 | 48.48 | 49.15 | 127800.0 |
| 2007-04-16 | BAB | ETF | 102.48 | 103.15 | 102.23 | 102.6 | 20200.0 |
| 2007-04-16 | BBH | ETF | 60.45 | 60.8467 | 60.45 | 60.58 | 481200.0 |
| 2007-04-16 | BITS | ETF | 30.92 | 32.4 | 30.88 | 32.0 | 11956.0 |
| 2007-04-16 | BIV | ETF | 74.96 | 75.0 | 74.93 | 75.0 | 38300.0 |
| 2007-04-16 | BLV | ETF | 75.03 | 75.03 | 75.03 | 75.03 | 300.0 |
| 2007-04-16 | BND | ETF | 74.99 | 74.99 | 74.94 | 74.98 | 52700.0 |
| 2007-04-16 | BNE | ETF | 16.97 | 17.23 | 16.91 | 17.18 | 273400.0 |
| 2007-04-16 | BOSS | ETF | 49.0 | 49.81 | 49.0 | 49.81 | 200.0 |
| 2007-04-16 | BRF | ETF | 14.5 | 14.51 | 14.49 | 14.5 | 7300.0 |
| 2007-04-16 | BSV | ETF | 74.96 | 75.0 | 74.95 | 75.0 | 52900.0 |
| 2007-04-16 | BTF | ETF | 110.25 | 110.85000000000001 | 110.25 | 110.85000000000001 | 2240.0 |
| 2007-04-16 | CBON | ETF | 29.75 | 29.996 | 29.69 | 29.9 | 67662.0 |
| 2007-04-16 | CDL | ETF | 9.7 | 9.73 | 9.64 | 9.73 | 189400.0 |
| 2007-04-16 | CEF | ETF | 9.88 | 9.9 | 9.77 | 9.81 | 547300.0 |
| 2007-04-16 | CGO | ETF | 17.43 | 17.48 | 17.42 | 17.47 | 13500.0 |
| 2007-04-16 | CHB | ETF | 10.15 | 10.32 | 9.93 | 10.3 | 2673939.0 |
| 2007-04-16 | CHI | ETF | 20.34 | 20.35 | 20.21 | 20.24 | 96900.0 |
| 2007-04-16 | CHIC | ETF | 29.93 | 30.15 | 29.11 | 29.23 | 596481.0 |
| 2007-04-16 | CHY | ETF | 17.05 | 17.08 | 16.97 | 16.97 | 84200.0 |
| 2007-04-16 | CIL | ETF | 25.75 | 25.75 | 25.73 | 25.73 | 2100.0 |
| 2007-04-16 | CN | ETF | 53.6 | 53.95 | 53.4 | 53.87 | 58300.0 |
| 2007-04-16 | CNXT | ETF | 1.5 | 1.51 | 1.47 | 1.47 | 7563507.0 |
| 2007-04-16 | CPI | ETF | 21.25 | 21.4 | 21.1 | 21.38 | 1900.0 |
| 2007-04-16 | CPST | ETF | 1.13 | 1.19 | 1.12 | 1.1899 | 3525390.0 |
| 2007-04-16 | CSA | ETF | 21.15 | 21.15 | 21.08 | 21.15 | 6400.0 |
| 2007-04-16 | CSB | ETF | 33.66 | 33.91 | 33.66 | 33.71 | 7100.0 |
| 2007-04-16 | CSD | ETF | 28.38 | 28.6 | 28.26 | 28.6 | 27500.0 |
| 2007-04-16 | CSM | ETF | 1.3725 | 1.375 | 1.3725 | 1.375 | 27200.0 |
| 2007-04-16 | CSQ | ETF | 15.35 | 15.4 | 15.3 | 15.34 | 353100.0 |
| 2007-04-16 | CTEC | ETF | 88.39999999999999 | 89.61 | 88.0 | 88.05 | 13356.2 |
| 2007-04-16 | CVY | ETF | 27.26 | 27.37 | 27.26 | 27.37 | 11900.0 |
| 2007-04-16 | CWI | ETF | 26.4733 | 26.6467 | 26.4733 | 26.6067 | 64800.0 |
| 2007-04-16 | DBA | ETF | 25.71 | 25.85 | 25.5 | 25.61 | 221800.0 |
| 2007-04-16 | DBB | ETF | 27.0 | 27.08 | 26.63 | 26.97 | 30300.0 |
| 2007-04-16 | DBC | ETF | 25.73 | 25.74 | 25.4 | 25.5 | 161100.0 |
| 2007-04-16 | DBE | ETF | 28.12 | 28.12 | 27.52 | 27.52 | 16800.0 |
| 2007-04-16 | DBO | ETF | 26.56 | 26.7 | 26.3 | 26.43 | 16300.0 |
| 2007-04-16 | DBP | ETF | 27.2 | 27.37 | 27.03 | 27.29 | 39400.0 |
> showing 50 of 452 rows — these rows as CSV