PREVIEW / etf_daily / 2008-06-27
file: by_date/etf_daily/2008/2008-06-27.parquet size: 27 KB rows: 612
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-06-27 | SPY | ETF | 128.28 | 128.86 | 127.04 | 127.53 | 303423400.0 |
| 2008-06-27 | QQQ | ETF | 45.58 | 45.9 | 44.97 | 45.65 | 181351771.0 |
| 2008-06-27 | IWM | ETF | 69.71 | 70.25 | 69.0 | 69.73 | 118012300.0 |
| 2008-06-27 | DIA | ETF | 114.57 | 114.74 | 112.86 | 113.46 | 25276000.0 |
| 2008-06-27 | GLD | ETF | 90.98 | 91.82 | 90.65 | 91.47 | 14490300.0 |
| 2008-06-27 | TLT | ETF | 91.73 | 92.44 | 91.45 | 92.32 | 4144800.0 |
| 2008-06-27 | ACWI | ETF | 49.21 | 49.35 | 48.9 | 49.23 | 5500.0 |
| 2008-06-27 | ACWX | ETF | 50.25 | 50.46 | 50.14 | 50.3299 | 34989.0 |
| 2008-06-27 | ADRE | ETF | 50.2 | 50.92 | 50.15 | 50.64 | 509888.0 |
| 2008-06-27 | AGG | ETF | 99.99 | 100.54 | 99.99 | 100.35 | 466000.0 |
| 2008-06-27 | AIA | ETF | 41.49 | 41.49 | 40.83 | 41.07 | 4465.0 |
| 2008-06-27 | AIQ | ETF | 45.9 | 46.35 | 44.35 | 44.7 | 177355.0 |
| 2008-06-27 | AIS | ETF | 0.7 | 0.7 | 0.5 | 0.5 | 172300.0 |
| 2008-06-27 | AIVI | ETF | 60.05 | 60.4 | 59.77 | 59.85 | 48400.0 |
| 2008-06-27 | ARB | ETF | 48.35 | 48.35 | 47.11 | 48.1 | 439956.0 |
| 2008-06-27 | BAL | ETF | 50.62 | 50.62 | 50.29 | 50.568 | 10775.0 |
| 2008-06-27 | BBH | ETF | 55.01 | 55.6467 | 55.01 | 55.4133 | 138900.0 |
| 2008-06-27 | BIL | ETF | 91.64 | 91.98 | 91.64 | 91.86 | 233150.0 |
| 2008-06-27 | BITS | ETF | 25.52 | 26.4 | 25.52 | 26.0 | 2925.0 |
| 2008-06-27 | BIV | ETF | 77.0 | 77.0 | 76.31 | 76.53 | 20400.0 |
| 2008-06-27 | BJK | ETF | 32.0 | 32.0 | 32.0 | 32.0 | 200.0 |
| 2008-06-27 | BKF | ETF | 52.42 | 52.42 | 51.3101 | 51.795 | 33765.0 |
| 2008-06-27 | BLV | ETF | 74.25 | 74.83 | 74.04 | 74.6 | 2100.0 |
| 2008-06-27 | BMVP | ETF | 15.0433 | 15.5867 | 14.8833 | 15.2867 | 32559.0 |
| 2008-06-27 | BND | ETF | 76.54 | 76.54 | 75.78 | 76.0 | 123300.0 |
| 2008-06-27 | BNE | ETF | 13.82 | 13.87 | 12.89 | 13.21 | 526888.0 |
| 2008-06-27 | BOSS | ETF | 24.78 | 24.78 | 24.78 | 24.78 | 100.0 |
| 2008-06-27 | BRF | ETF | 14.7 | 14.74 | 14.7 | 14.73 | 14400.0 |
| 2008-06-27 | BSV | ETF | 77.36 | 79.25 | 76.8 | 77.2 | 247500.0 |
| 2008-06-27 | BTF | ETF | 92.6 | 92.85 | 91.54999999999998 | 91.69999999999999 | 4789.400000000001 |
| 2008-06-27 | BWX | ETF | 27.635 | 27.79 | 27.63 | 27.78 | 457548.0 |
| 2008-06-27 | CBON | ETF | 5.79 | 5.79 | 5.21 | 5.21 | 1519882.0 |
| 2008-06-27 | CDL | ETF | 1.32 | 1.35 | 1.22 | 1.22 | 2923060.0 |
| 2008-06-27 | CEF | ETF | 12.98 | 13.06 | 12.87 | 13.0 | 838200.0 |
| 2008-06-27 | CGO | ETF | 15.65 | 15.65 | 15.22 | 15.25 | 22386.0 |
| 2008-06-27 | CGW | ETF | 23.14 | 23.6 | 23.14 | 23.304 | 90179.0 |
| 2008-06-27 | CHB | ETF | 5.87 | 6.28 | 5.83 | 6.13 | 2820699.0 |
| 2008-06-27 | CHI | ETF | 13.81 | 13.84 | 13.39 | 13.61 | 265692.0 |
| 2008-06-27 | CHIC | ETF | 17.76 | 17.96 | 17.43 | 17.55 | 764779.0 |
| 2008-06-27 | CHW | ETF | 11.37 | 11.371 | 11.15 | 11.192 | 121650.0 |
| 2008-06-27 | CHY | ETF | 13.11 | 13.16 | 12.72 | 12.95 | 175312.0 |
| 2008-06-27 | CMF | ETF | 51.125 | 51.295 | 51.005 | 51.295 | 21354.0 |
| 2008-06-27 | CN | ETF | 53.2 | 53.86 | 52.88 | 53.4 | 194101.0 |
| 2008-06-27 | CNXT | ETF | 0.519 | 0.54 | 0.48 | 0.48 | 60775430.0 |
| 2008-06-27 | COW | ETF | 44.25 | 44.28 | 43.92 | 44.28 | 209055.0 |
| 2008-06-27 | CPI | ETF | 21.966 | 22.0 | 21.966 | 22.0 | 1750.0 |
| 2008-06-27 | CPST | ETF | 4.0 | 4.2 | 3.99 | 4.1 | 22353754.0 |
| 2008-06-27 | CSA | ETF | 16.94 | 16.94 | 16.21 | 16.3 | 683412.0 |
| 2008-06-27 | CSB | ETF | 18.56 | 19.5 | 18.56 | 19.0 | 23950.0 |
| 2008-06-27 | CSD | ETF | 21.64 | 21.72 | 21.62 | 21.66 | 8300.0 |
> showing 50 of 612 rows — these rows as CSV