PREVIEW / etf_daily / 2008-07-03
file: by_date/etf_daily/2008/2008-07-03.parquet size: 26 KB rows: 592
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-03 | SPY | ETF | 127.11 | 127.11 | 124.99 | 126.31 | 239352500.0 |
| 2008-07-03 | QQQ | ETF | 44.98 | 45.08 | 44.28 | 44.63 | 123118206.0 |
| 2008-07-03 | IWM | ETF | 66.9 | 66.99 | 65.8 | 66.53 | 166200.0 |
| 2008-07-03 | DIA | ETF | 112.81 | 113.32 | 111.48 | 113.05 | 20496600.0 |
| 2008-07-03 | GLD | ETF | 92.17 | 92.68 | 91.68 | 92.06 | 9609500.0 |
| 2008-07-03 | TLT | ETF | 91.71 | 92.3 | 91.54 | 92.07 | 1405100.0 |
| 2008-07-03 | ACWI | ETF | 48.4 | 48.4 | 47.95 | 48.07 | 5600.0 |
| 2008-07-03 | ACWX | ETF | 49.5 | 49.5 | 49.25 | 49.25 | 53636.0 |
| 2008-07-03 | ADRE | ETF | 49.14 | 49.16 | 48.04 | 48.592 | 398371.0 |
| 2008-07-03 | AGG | ETF | 99.87 | 99.97 | 99.56 | 99.58 | 281300.0 |
| 2008-07-03 | AIA | ETF | 39.93 | 40.08 | 39.74 | 39.88 | 4470.0 |
| 2008-07-03 | AIQ | ETF | 42.0 | 42.45 | 41.15 | 41.2 | 32243.0 |
| 2008-07-03 | AIS | ETF | 0.68 | 0.7 | 0.68 | 0.68 | 48557.0 |
| 2008-07-03 | AIVI | ETF | 59.3 | 59.49 | 58.8 | 59.21 | 11900.0 |
| 2008-07-03 | ARB | ETF | 47.04 | 47.51 | 46.6 | 46.82 | 114544.0 |
| 2008-07-03 | BAL | ETF | 46.64 | 46.64 | 46.64 | 46.64 | 2000.0 |
| 2008-07-03 | BBH | ETF | 57.7667 | 57.8033 | 57.3333 | 57.5 | 357900.0 |
| 2008-07-03 | BIL | ETF | 91.74 | 91.74 | 91.64 | 91.72 | 38300.0 |
| 2008-07-03 | BITS | ETF | 24.08 | 24.76 | 23.0 | 24.4 | 2208.0 |
| 2008-07-03 | BIV | ETF | 76.04 | 76.23 | 75.91 | 76.2 | 55500.0 |
| 2008-07-03 | BJK | ETF | 31.24 | 31.75 | 30.0 | 30.89 | 3200.0 |
| 2008-07-03 | BKF | ETF | 49.21 | 49.78 | 48.52 | 48.98 | 35380.0 |
| 2008-07-03 | BLV | ETF | 73.8 | 74.32 | 73.8 | 74.32 | 1000.0 |
| 2008-07-03 | BMVP | ETF | 15.0 | 15.0 | 14.84 | 14.89 | 27089.0 |
| 2008-07-03 | BND | ETF | 75.75 | 75.83 | 75.41 | 75.7 | 303000.0 |
| 2008-07-03 | BNE | ETF | 11.72 | 11.96 | 11.6 | 11.79 | 78756.0 |
| 2008-07-03 | BRF | ETF | 14.7 | 14.71 | 14.7 | 14.7 | 10470.0 |
| 2008-07-03 | BSV | ETF | 77.21 | 77.32 | 77.01 | 77.28 | 53700.0 |
| 2008-07-03 | BTF | ETF | 86.4 | 86.5 | 85.5 | 85.85000000000001 | 2082.0 |
| 2008-07-03 | BWX | ETF | 27.585 | 27.71 | 27.525 | 27.655 | 255522.0 |
| 2008-07-03 | CBON | ETF | 4.95 | 4.95 | 4.3 | 4.32 | 169689.0 |
| 2008-07-03 | CDL | ETF | 1.1 | 1.15 | 1.07 | 1.08 | 500446.0 |
| 2008-07-03 | CEF | ETF | 13.42 | 13.42 | 13.2 | 13.32 | 376900.0 |
| 2008-07-03 | CGO | ETF | 15.16 | 15.1999 | 15.09 | 15.141 | 8180.0 |
| 2008-07-03 | CGW | ETF | 22.57 | 22.742 | 22.27 | 22.55 | 44967.0 |
| 2008-07-03 | CHB | ETF | 5.39 | 5.44 | 5.13 | 5.32 | 612474.0 |
| 2008-07-03 | CHI | ETF | 13.9 | 13.906 | 13.52 | 13.7 | 72190.0 |
| 2008-07-03 | CHIC | ETF | 17.55 | 17.86 | 17.17 | 17.8 | 297081.0 |
| 2008-07-03 | CHW | ETF | 10.94 | 11.02 | 10.85 | 10.94 | 62289.0 |
| 2008-07-03 | CHY | ETF | 13.14 | 13.18 | 12.77 | 12.89 | 95397.0 |
| 2008-07-03 | CMF | ETF | 51.755 | 51.755 | 51.205 | 51.445 | 34662.0 |
| 2008-07-03 | CN | ETF | 55.02 | 56.05 | 54.57 | 55.67 | 184918.0 |
| 2008-07-03 | COW | ETF | 43.54 | 43.89 | 43.36 | 43.5 | 235783.0 |
| 2008-07-03 | CPST | ETF | 3.58 | 3.62 | 3.16 | 3.33 | 6068045.0 |
| 2008-07-03 | CSA | ETF | 16.37 | 16.37 | 15.99 | 16.28 | 66921.0 |
| 2008-07-03 | CSB | ETF | 19.32 | 19.32 | 18.35 | 18.5 | 4700.0 |
| 2008-07-03 | CSD | ETF | 20.75 | 20.93 | 20.44 | 20.44 | 2600.0 |
| 2008-07-03 | CSQ | ETF | 10.94 | 11.03 | 10.78 | 10.99 | 207803.0 |
| 2008-07-03 | CUT | ETF | 18.84 | 18.84 | 18.5 | 18.52 | 7400.0 |
| 2008-07-03 | CVY | ETF | 20.25 | 20.25 | 20.01 | 20.08 | 19100.0 |
> showing 50 of 592 rows — these rows as CSV