PREVIEW / etf_daily / 2007-05-03
file: by_date/etf_daily/2007/2007-05-03.parquet size: 21 KB rows: 454
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-03 | SPY | ETF | 149.97 | 150.4 | 149.73 | 150.35 | 86569700.0 |
| 2007-05-03 | QQQ | ETF | 46.53 | 46.72 | 46.43 | 46.59 | 98019903.0 |
| 2007-05-03 | IWM | ETF | 82.21 | 82.57 | 81.97 | 82.3 | 57008800.0 |
| 2007-05-03 | DIA | ETF | 132.28 | 132.43 | 131.9 | 132.39 | 9363700.0 |
| 2007-05-03 | GLD | ETF | 66.87 | 67.62 | 66.68 | 67.49 | 3936200.0 |
| 2007-05-03 | TLT | ETF | 88.37 | 88.37 | 88.01 | 88.24 | 427000.0 |
| 2007-05-03 | AAA | ETF | 70.0 | 70.7 | 64.6 | 66.1 | 271800.0 |
| 2007-05-03 | ADRE | ETF | 41.72 | 42.2 | 41.69 | 42.19 | 63576.0 |
| 2007-05-03 | AGG | ETF | 100.01 | 100.06 | 99.81 | 99.94 | 267900.0 |
| 2007-05-03 | AIQ | ETF | 45.15 | 45.5 | 43.6 | 45.25 | 83180.0 |
| 2007-05-03 | AIS | ETF | 1.52 | 1.5301 | 1.5 | 1.5 | 199800.0 |
| 2007-05-03 | ARB | ETF | 49.63 | 49.67 | 49.02 | 49.16 | 626900.0 |
| 2007-05-03 | BAB | ETF | 102.13 | 102.17 | 100.92 | 101.42 | 91800.0 |
| 2007-05-03 | BBH | ETF | 63.6167 | 63.6167 | 62.8 | 62.9 | 392100.0 |
| 2007-05-03 | BITS | ETF | 34.6 | 35.0 | 33.56 | 33.6 | 18400.0 |
| 2007-05-03 | BIV | ETF | 75.3 | 75.31 | 75.17 | 75.21 | 13600.0 |
| 2007-05-03 | BLV | ETF | 75.58 | 75.58 | 75.32 | 75.39 | 10800.0 |
| 2007-05-03 | BMVP | ETF | 17.933 | 18.005 | 17.913 | 17.973 | 26100.0 |
| 2007-05-03 | BND | ETF | 75.33 | 75.33 | 75.06 | 75.28 | 33800.0 |
| 2007-05-03 | BNE | ETF | 16.85 | 16.86 | 16.62 | 16.7 | 161300.0 |
| 2007-05-03 | BRF | ETF | 14.49 | 14.53 | 14.48 | 14.5 | 11600.0 |
| 2007-05-03 | BSV | ETF | 75.19 | 75.21 | 75.17 | 75.17 | 35700.0 |
| 2007-05-03 | BTF | ETF | 112.05 | 112.35 | 111.5 | 112.10000000000001 | 420.0 |
| 2007-05-03 | CBON | ETF | 30.95 | 31.07 | 30.55 | 30.78 | 40381.0 |
| 2007-05-03 | CDL | ETF | 9.08 | 9.12 | 9.0 | 9.06 | 333200.0 |
| 2007-05-03 | CEF | ETF | 9.48 | 9.54 | 9.38 | 9.5 | 288800.0 |
| 2007-05-03 | CGO | ETF | 17.99 | 18.01 | 17.83 | 17.91 | 20400.0 |
| 2007-05-03 | CHB | ETF | 10.5 | 10.98 | 10.42 | 10.98 | 2977000.0 |
| 2007-05-03 | CHI | ETF | 20.41 | 20.47 | 20.35 | 20.41 | 60500.0 |
| 2007-05-03 | CHIC | ETF | 27.3 | 27.32 | 26.5702 | 26.81 | 477107.0 |
| 2007-05-03 | CHY | ETF | 17.2 | 17.21 | 17.14 | 17.21 | 79300.0 |
| 2007-05-03 | CIL | ETF | 25.8401 | 25.9 | 25.84 | 25.9 | 500.0 |
| 2007-05-03 | CN | ETF | 49.75 | 50.02 | 49.66 | 49.9 | 38900.0 |
| 2007-05-03 | CNXT | ETF | 1.56 | 1.56 | 1.54 | 1.56 | 4806987.0 |
| 2007-05-03 | CPI | ETF | 22.35 | 22.8 | 22.35 | 22.8 | 1400.0 |
| 2007-05-03 | CPST | ETF | 1.04 | 1.04 | 0.99 | 0.9903 | 1567613.0 |
| 2007-05-03 | CSA | ETF | 20.7 | 20.93 | 20.47 | 20.59 | 37000.0 |
| 2007-05-03 | CSB | ETF | 32.11 | 32.28 | 31.92 | 32.13 | 30400.0 |
| 2007-05-03 | CSD | ETF | 28.73 | 28.88 | 28.71 | 28.88 | 39700.0 |
| 2007-05-03 | CSQ | ETF | 15.4 | 15.43 | 15.37 | 15.41 | 345600.0 |
| 2007-05-03 | CTEC | ETF | 90.29999999999998 | 91.85 | 90.0 | 90.35 | 8431.800000000001 |
| 2007-05-03 | CVY | ETF | 27.9 | 27.9 | 27.73 | 27.84 | 19800.0 |
| 2007-05-03 | CWI | ETF | 26.6733 | 26.7133 | 26.6267 | 26.7133 | 35550.0 |
| 2007-05-03 | CZA | ETF | 26.43 | 26.43 | 26.43 | 26.43 | 200.0 |
| 2007-05-03 | DBA | ETF | 25.15 | 25.66 | 25.15 | 25.44 | 2224700.0 |
| 2007-05-03 | DBB | ETF | 28.23 | 28.77 | 28.11 | 28.77 | 1400400.0 |
| 2007-05-03 | DBC | ETF | 25.42 | 25.54 | 25.25 | 25.54 | 213100.0 |
| 2007-05-03 | DBE | ETF | 27.61 | 27.75 | 27.51 | 27.72 | 6200.0 |
| 2007-05-03 | DBO | ETF | 26.32 | 26.32 | 26.01 | 26.29 | 14400.0 |
| 2007-05-03 | DBP | ETF | 26.47 | 26.82 | 26.47 | 26.74 | 1700.0 |
> showing 50 of 454 rows — these rows as CSV