PREVIEW / etf_daily / 2008-10-01
file: by_date/etf_daily/2008/2008-10-01.parquet size: 27 KB rows: 606
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-10-01 | SPY | ETF | 115.27 | 116.69 | 113.95 | 116.06 | 332783000.0 |
| 2008-10-01 | QQQ | ETF | 38.83 | 38.97 | 38.03 | 38.5 | 174122954.0 |
| 2008-10-01 | IWM | ETF | 67.19 | 67.35 | 66.29 | 67.02 | 69571300.0 |
| 2008-10-01 | DIA | ETF | 107.57 | 108.79 | 106.28 | 108.7 | 22853900.0 |
| 2008-10-01 | GLD | ETF | 86.23 | 88.05 | 85.18 | 85.97 | 16785400.0 |
| 2008-10-01 | TLT | ETF | 96.04 | 96.9 | 94.95 | 95.78 | 1767800.0 |
| 2008-10-01 | AAXJ | ETF | 41.01 | 44.59 | 41.01 | 42.34 | 73700.0 |
| 2008-10-01 | ACWI | ETF | 41.21 | 41.65 | 40.71 | 41.46 | 82400.0 |
| 2008-10-01 | ACWX | ETF | 39.62 | 39.97 | 39.0 | 39.69 | 114470.0 |
| 2008-10-01 | ADRE | ETF | 36.9 | 37.6799 | 36.304 | 37.39 | 258141.0 |
| 2008-10-01 | AFK | ETF | 31.81 | 32.38 | 31.81 | 32.38 | 2170.0 |
| 2008-10-01 | AGG | ETF | 97.9 | 98.78 | 94.5 | 97.5 | 800000.0 |
| 2008-10-01 | AIA | ETF | 33.17 | 33.67 | 32.75 | 33.63 | 10828.0 |
| 2008-10-01 | AIQ | ETF | 50.8 | 51.25 | 49.4 | 49.45 | 75486.0 |
| 2008-10-01 | AIS | ETF | 0.68 | 0.72 | 0.65 | 0.6884 | 43600.0 |
| 2008-10-01 | AIVI | ETF | 50.26 | 50.92 | 49.88 | 50.72 | 42900.0 |
| 2008-10-01 | ARB | ETF | 44.33 | 44.69 | 43.22 | 43.89 | 381628.0 |
| 2008-10-01 | BAL | ETF | 36.13 | 36.13 | 36.13 | 36.13 | 100.0 |
| 2008-10-01 | BBH | ETF | 60.4833 | 60.81 | 59.4433 | 60.25 | 844500.0 |
| 2008-10-01 | BIL | ETF | 92.42 | 92.42 | 91.78 | 92.0 | 265950.0 |
| 2008-10-01 | BITS | ETF | 21.92 | 21.92 | 20.88 | 21.0 | 1025.0 |
| 2008-10-01 | BIV | ETF | 73.49 | 73.61 | 72.53 | 73.3 | 38700.0 |
| 2008-10-01 | BJK | ETF | 24.02 | 24.02 | 24.02 | 24.02 | 200.0 |
| 2008-10-01 | BKF | ETF | 35.23 | 35.41 | 34.076 | 35.39 | 103795.0 |
| 2008-10-01 | BLV | ETF | 70.9 | 72.12 | 70.57 | 71.23 | 43200.0 |
| 2008-10-01 | BMVP | ETF | 13.343 | 13.485 | 13.27 | 13.432 | 36878.0 |
| 2008-10-01 | BND | ETF | 75.26 | 76.08 | 74.71 | 74.95 | 344400.0 |
| 2008-10-01 | BNE | ETF | 11.43 | 11.53 | 10.83 | 11.08 | 95968.0 |
| 2008-10-01 | BOSS | ETF | 17.3 | 18.0 | 17.3 | 17.45 | 400.0 |
| 2008-10-01 | BRF | ETF | 14.65 | 14.6501 | 14.65 | 14.65 | 5100.0 |
| 2008-10-01 | BSV | ETF | 78.1 | 78.11 | 73.9 | 74.9 | 216200.0 |
| 2008-10-01 | BTF | ETF | 72.85 | 75.65 | 72.85 | 75.39999999999999 | 5305.6 |
| 2008-10-01 | BWX | ETF | 26.155 | 26.22 | 25.595 | 25.96 | 173940.0 |
| 2008-10-01 | CBON | ETF | 6.26 | 6.45 | 6.21 | 6.44 | 89228.0 |
| 2008-10-01 | CDL | ETF | 0.75 | 0.84 | 0.71 | 0.71 | 257635.0 |
| 2008-10-01 | CEF | ETF | 10.97 | 11.2 | 10.82 | 10.82 | 1128900.0 |
| 2008-10-01 | CGO | ETF | 11.2 | 11.55 | 11.14 | 11.43 | 22495.0 |
| 2008-10-01 | CGW | ETF | 20.2 | 20.2 | 19.39 | 19.7 | 49579.0 |
| 2008-10-01 | CHB | ETF | 5.4 | 5.95 | 5.25 | 5.93 | 996645.0 |
| 2008-10-01 | CHI | ETF | 10.99 | 10.991 | 10.65 | 10.8 | 161559.0 |
| 2008-10-01 | CHIC | ETF | 10.19 | 10.52 | 10.13 | 10.23 | 388722.0 |
| 2008-10-01 | CHW | ETF | 7.75 | 8.13 | 7.6 | 8.1 | 145936.0 |
| 2008-10-01 | CHY | ETF | 10.0 | 10.56 | 9.8 | 10.48 | 172249.0 |
| 2008-10-01 | CMF | ETF | 50.58 | 50.58 | 50.168 | 50.295 | 5312.0 |
| 2008-10-01 | CN | ETF | 45.0 | 46.0 | 43.95 | 45.59 | 197503.0 |
| 2008-10-01 | CNXT | ETF | 4.09 | 4.114 | 3.5 | 3.65 | 1028150.0 |
| 2008-10-01 | COW | ETF | 39.81 | 39.9564 | 39.24 | 39.566 | 81459.0 |
| 2008-10-01 | CPI | ETF | 22.85 | 22.85 | 22.85 | 22.85 | 200.0 |
| 2008-10-01 | CPST | ETF | 1.36 | 1.38 | 1.23 | 1.23 | 4162944.0 |
| 2008-10-01 | CSA | ETF | 16.54 | 16.9 | 15.91 | 16.17 | 96188.0 |
> showing 50 of 606 rows — these rows as CSV