PREVIEW / etf_daily / 2008-11-13
file: by_date/etf_daily/2008/2008-11-13.parquet size: 27 KB rows: 619
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-11-13 | SPY | ETF | 86.13 | 91.73 | 82.09 | 91.17 | 753141900.0 |
| 2008-11-13 | QQQ | ETF | 28.63 | 30.53 | 27.28 | 30.46 | 318269146.0 |
| 2008-11-13 | IWM | ETF | 45.7 | 49.45 | 43.24 | 49.31 | 142362300.0 |
| 2008-11-13 | DIA | ETF | 83.57 | 89.0 | 79.85 | 88.7 | 64432800.0 |
| 2008-11-13 | GLD | ETF | 70.49 | 72.36 | 68.81 | 72.15 | 16826600.0 |
| 2008-11-13 | TLT | ETF | 94.91 | 95.25 | 93.25 | 93.32 | 1631900.0 |
| 2008-11-13 | AAXJ | ETF | 30.31 | 32.45 | 28.9 | 32.45 | 2208700.0 |
| 2008-11-13 | ACWI | ETF | 30.05 | 32.0 | 28.58 | 32.0 | 388900.0 |
| 2008-11-13 | ACWX | ETF | 27.99 | 29.78 | 26.7 | 29.78 | 237810.0 |
| 2008-11-13 | ADRE | ETF | 24.55 | 26.84 | 23.15 | 26.81 | 961889.0 |
| 2008-11-13 | AFK | ETF | 21.24 | 21.95 | 21.19 | 21.95 | 10215.0 |
| 2008-11-13 | AGG | ETF | 96.68 | 97.16 | 96.16 | 96.69 | 523800.0 |
| 2008-11-13 | AGZ | ETF | 103.06 | 107.39 | 103.03 | 107.39 | 945.0 |
| 2008-11-13 | AIA | ETF | 23.47 | 25.0899 | 22.65 | 24.94 | 21717.0 |
| 2008-11-13 | AIQ | ETF | 42.45 | 43.95 | 40.95 | 43.95 | 60664.0 |
| 2008-11-13 | AIS | ETF | 0.49 | 0.49 | 0.44 | 0.49 | 46050.0 |
| 2008-11-13 | AIVI | ETF | 34.27 | 36.54 | 33.02 | 36.54 | 77700.0 |
| 2008-11-13 | AOK | ETF | 26.12 | 26.12 | 24.85 | 24.9 | 700.0 |
| 2008-11-13 | AOM | ETF | 24.09 | 25.2 | 23.83 | 24.0 | 26150.0 |
| 2008-11-13 | ARB | ETF | 26.17 | 27.71 | 24.63 | 27.55 | 368116.0 |
| 2008-11-13 | BAL | ETF | 25.73 | 25.91 | 24.71 | 24.71 | 1600.0 |
| 2008-11-13 | BBH | ETF | 55.1667 | 57.9367 | 54.6533 | 57.86 | 976800.0 |
| 2008-11-13 | BIL | ETF | 91.9 | 91.94 | 91.84 | 91.9 | 132450.0 |
| 2008-11-13 | BITS | ETF | 12.96 | 14.48 | 12.0 | 14.48 | 10266.0 |
| 2008-11-13 | BIV | ETF | 72.64 | 72.82 | 71.85 | 72.18 | 51500.0 |
| 2008-11-13 | BJK | ETF | 15.0 | 16.12 | 15.0 | 16.12 | 2400.0 |
| 2008-11-13 | BKF | ETF | 21.95 | 24.25 | 21.12 | 24.25 | 294613.0 |
| 2008-11-13 | BLV | ETF | 67.74 | 67.95 | 67.32 | 67.44 | 18700.0 |
| 2008-11-13 | BMVP | ETF | 10.007 | 10.601 | 9.543 | 10.601 | 81522.0 |
| 2008-11-13 | BND | ETF | 74.11 | 74.92 | 74.06 | 74.55 | 222600.0 |
| 2008-11-13 | BNE | ETF | 3.78 | 3.82 | 2.87 | 3.48 | 275963.0 |
| 2008-11-13 | BRF | ETF | 14.88 | 14.9 | 14.88 | 14.9 | 16435.0 |
| 2008-11-13 | BSV | ETF | 77.46 | 77.74 | 77.02 | 77.69 | 101500.0 |
| 2008-11-13 | BTF | ETF | 45.099999999999994 | 50.949999999999996 | 41.95 | 50.75 | 146104.80000000002 |
| 2008-11-13 | BWX | ETF | 24.42 | 24.725 | 24.292 | 24.725 | 152850.0 |
| 2008-11-13 | CBON | ETF | 3.47 | 3.47 | 2.81 | 2.97 | 123669.0 |
| 2008-11-13 | CDL | ETF | 0.22 | 0.22 | 0.17 | 0.19 | 1679473.0 |
| 2008-11-13 | CEF | ETF | 8.8 | 8.93 | 8.01 | 8.85 | 1090900.0 |
| 2008-11-13 | CGO | ETF | 8.81 | 8.96 | 8.15 | 8.96 | 34245.0 |
| 2008-11-13 | CGW | ETF | 13.64 | 15.36 | 13.64 | 15.146 | 60594.0 |
| 2008-11-13 | CHB | ETF | 0.96 | 1.0 | 0.44 | 0.67 | 2552128.0 |
| 2008-11-13 | CHI | ETF | 7.72 | 7.81 | 6.68 | 7.51 | 346891.0 |
| 2008-11-13 | CHIC | ETF | 8.11 | 8.14 | 6.77 | 8.05 | 1506984.0 |
| 2008-11-13 | CHW | ETF | 5.75 | 5.75 | 4.85 | 5.68 | 480202.0 |
| 2008-11-13 | CHY | ETF | 7.41 | 7.48 | 6.7 | 7.3499 | 359725.0 |
| 2008-11-13 | CMF | ETF | 51.415 | 51.415 | 51.004 | 51.01 | 5584.0 |
| 2008-11-13 | CNXT | ETF | 1.1 | 1.2 | 1.0 | 1.2 | 549769.0 |
| 2008-11-13 | COW | ETF | 35.15 | 35.62 | 35.11 | 35.62 | 24165.0 |
| 2008-11-13 | CPST | ETF | 1.14 | 1.17 | 0.91 | 1.08 | 9269500.0 |
| 2008-11-13 | CSA | ETF | 9.94 | 10.6 | 9.61 | 10.6 | 190126.0 |
> showing 50 of 619 rows — these rows as CSV