PREVIEW / etf_daily / 2008-07-15
file: by_date/etf_daily/2008/2008-07-15.parquet size: 27 KB rows: 607
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-15 | SPY | ETF | 121.8 | 123.49 | 120.02 | 120.99 | 502502500.0 |
| 2008-07-15 | QQQ | ETF | 44.01 | 44.93 | 43.3 | 44.24 | 283891074.0 |
| 2008-07-15 | IWM | ETF | 65.55 | 67.28 | 64.52 | 65.88 | 143442400.0 |
| 2008-07-15 | DIA | ETF | 109.76 | 111.26 | 108.32 | 109.3 | 41112400.0 |
| 2008-07-15 | GLD | ETF | 96.55 | 97.5 | 95.43 | 96.17 | 30347100.0 |
| 2008-07-15 | TLT | ETF | 93.07 | 93.43 | 92.7 | 92.94 | 4541400.0 |
| 2008-07-15 | ACWI | ETF | 47.0 | 47.02 | 46.15 | 46.82 | 22700.0 |
| 2008-07-15 | ACWX | ETF | 47.4 | 47.86 | 47.4 | 47.839 | 12963.0 |
| 2008-07-15 | ADRE | ETF | 47.25 | 48.04 | 46.45 | 47.26 | 475130.0 |
| 2008-07-15 | AFK | ETF | 41.8 | 42.16 | 41.8 | 42.11 | 899.0 |
| 2008-07-15 | AGG | ETF | 100.64 | 100.98 | 100.61 | 100.77 | 433400.0 |
| 2008-07-15 | AIA | ETF | 38.68 | 39.31 | 38.06 | 39.02 | 74658.0 |
| 2008-07-15 | AIQ | ETF | 41.85 | 43.3 | 41.7 | 42.55 | 30286.0 |
| 2008-07-15 | AIS | ETF | 0.71 | 0.72 | 0.7 | 0.72 | 62517.0 |
| 2008-07-15 | AIVI | ETF | 56.2 | 56.87 | 55.64 | 56.13 | 41900.0 |
| 2008-07-15 | ARB | ETF | 44.5 | 47.34 | 43.98 | 46.43 | 513023.0 |
| 2008-07-15 | BAL | ETF | 44.91 | 45.95 | 44.5 | 45.95 | 4418.0 |
| 2008-07-15 | BBH | ETF | 57.23 | 60.4033 | 56.85 | 60.0333 | 1981800.0 |
| 2008-07-15 | BIL | ETF | 91.84 | 91.86 | 91.78 | 91.84 | 98800.0 |
| 2008-07-15 | BITS | ETF | 23.2 | 23.4 | 22.04 | 22.68 | 8250.0 |
| 2008-07-15 | BIV | ETF | 76.62 | 77.08 | 76.62 | 76.85 | 46200.0 |
| 2008-07-15 | BJK | ETF | 28.8 | 28.8 | 27.87 | 27.9 | 1400.0 |
| 2008-07-15 | BKF | ETF | 49.51 | 49.51 | 47.22 | 48.62 | 35363.0 |
| 2008-07-15 | BLV | ETF | 74.67 | 74.78 | 74.49 | 74.5 | 13600.0 |
| 2008-07-15 | BMVP | ETF | 14.1567 | 14.74 | 14.14 | 14.52 | 38526.0 |
| 2008-07-15 | BND | ETF | 76.22 | 76.46 | 76.22 | 76.39 | 237100.0 |
| 2008-07-15 | BNE | ETF | 11.01 | 11.6 | 11.0 | 11.25 | 287480.0 |
| 2008-07-15 | BRF | ETF | 14.72 | 14.72 | 14.71 | 14.71 | 8456.0 |
| 2008-07-15 | BSV | ETF | 77.44 | 77.57 | 77.36 | 77.47 | 69700.0 |
| 2008-07-15 | BTF | ETF | 81.54999999999998 | 81.54999999999998 | 78.05 | 80.7995 | 7367.6 |
| 2008-07-15 | BWX | ETF | 28.2 | 28.35 | 28.16 | 28.225 | 301066.0 |
| 2008-07-15 | CBON | ETF | 2.95 | 3.3 | 2.9 | 2.9 | 264149.0 |
| 2008-07-15 | CDL | ETF | 0.81 | 0.8105 | 0.76 | 0.7913 | 1070045.0 |
| 2008-07-15 | CEF | ETF | 13.65 | 13.69 | 13.36 | 13.62 | 4360200.0 |
| 2008-07-15 | CGO | ETF | 14.35 | 14.54 | 13.62 | 14.27 | 69445.0 |
| 2008-07-15 | CGW | ETF | 21.9 | 21.9 | 21.35 | 21.58 | 116142.0 |
| 2008-07-15 | CHB | ETF | 4.45 | 4.5 | 4.03 | 4.39 | 2247206.0 |
| 2008-07-15 | CHI | ETF | 12.49 | 12.85 | 11.8 | 12.22 | 376815.0 |
| 2008-07-15 | CHIC | ETF | 15.32 | 16.53 | 15.23 | 16.05 | 515833.0 |
| 2008-07-15 | CHW | ETF | 10.12 | 10.16 | 9.55 | 9.97 | 392140.0 |
| 2008-07-15 | CHY | ETF | 11.41 | 11.73 | 10.89 | 11.29 | 527857.0 |
| 2008-07-15 | CMF | ETF | 52.095 | 52.095 | 51.7195 | 51.855 | 4600.0 |
| 2008-07-15 | CN | ETF | 56.82 | 58.13 | 55.74 | 56.84 | 421828.0 |
| 2008-07-15 | COW | ETF | 42.84 | 43.44 | 42.84 | 43.35 | 232084.0 |
| 2008-07-15 | CPI | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 400.0 |
| 2008-07-15 | CPST | ETF | 3.48 | 3.64 | 3.32 | 3.59 | 3868468.0 |
| 2008-07-15 | CSA | ETF | 16.07 | 17.12 | 16.07 | 16.68 | 55950.0 |
| 2008-07-15 | CSB | ETF | 10.7 | 13.4899 | 7.5 | 12.55 | 109570.0 |
| 2008-07-15 | CSD | ETF | 20.21 | 20.5 | 19.99 | 20.28 | 16300.0 |
| 2008-07-15 | CSQ | ETF | 10.13 | 10.24 | 9.69 | 10.05 | 577085.0 |
> showing 50 of 607 rows — these rows as CSV