PREVIEW / etf_daily / 2008-11-18
file: by_date/etf_daily/2008/2008-11-18.parquet size: 27 KB rows: 610
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-18 | SPY | ETF | 85.15 | 87.22 | 82.91 | 87.08 | 523811800.0 |
| 2008-11-18 | QQQ | ETF | 28.56 | 28.75 | 27.39 | 28.34 | 252794212.0 |
| 2008-11-18 | IWM | ETF | 45.33 | 45.99 | 43.1 | 45.03 | 98246400.0 |
| 2008-11-18 | DIA | ETF | 82.99 | 85.05 | 81.31 | 84.34 | 42201200.0 |
| 2008-11-18 | GLD | ETF | 72.38 | 73.46 | 72.13 | 72.51 | 8134900.0 |
| 2008-11-18 | TLT | ETF | 96.38 | 97.0 | 95.96 | 96.82 | 924800.0 |
| 2008-11-18 | AAXJ | ETF | 29.5 | 29.71 | 28.3 | 29.29 | 1420200.0 |
| 2008-11-18 | ACWI | ETF | 29.52 | 30.2 | 29.02 | 29.72 | 160600.0 |
| 2008-11-18 | ACWX | ETF | 27.23 | 27.66 | 26.782 | 27.55 | 203431.0 |
| 2008-11-18 | ADRE | ETF | 24.15 | 24.49 | 23.13 | 23.86 | 396396.0 |
| 2008-11-18 | AFK | ETF | 21.55 | 22.0 | 21.365 | 21.88 | 1117.0 |
| 2008-11-18 | AGG | ETF | 97.07 | 97.4 | 96.96 | 97.1 | 415000.0 |
| 2008-11-18 | AGZ | ETF | 102.77 | 102.88 | 102.7 | 102.71 | 21700.0 |
| 2008-11-18 | AIA | ETF | 22.49 | 22.735 | 21.97 | 22.09 | 21685.0 |
| 2008-11-18 | AIQ | ETF | 43.5 | 44.65 | 42.25 | 43.7 | 43503.0 |
| 2008-11-18 | AIS | ETF | 0.32 | 0.5 | 0.32 | 0.45 | 32088.0 |
| 2008-11-18 | AIVI | ETF | 33.19 | 33.89 | 32.74 | 33.15 | 24100.0 |
| 2008-11-18 | AOA | ETF | 22.64 | 22.64 | 21.83 | 21.83 | 2800.0 |
| 2008-11-18 | AOK | ETF | 24.87 | 24.87 | 24.87 | 24.87 | 200.0 |
| 2008-11-18 | AOR | ETF | 23.38 | 23.38 | 23.16 | 23.16 | 380.0 |
| 2008-11-18 | ARB | ETF | 23.8 | 23.8 | 21.04 | 21.69 | 798433.0 |
| 2008-11-18 | BAL | ETF | 24.5 | 24.5 | 24.41 | 24.41 | 3200.0 |
| 2008-11-18 | BBH | ETF | 55.6 | 56.3633 | 54.5933 | 55.8467 | 742500.0 |
| 2008-11-18 | BIL | ETF | 91.94 | 91.94 | 91.78 | 91.84 | 260650.0 |
| 2008-11-18 | BITS | ETF | 14.44 | 15.36 | 14.12 | 15.36 | 4858.0 |
| 2008-11-18 | BIV | ETF | 72.85 | 73.24 | 72.61 | 73.16 | 27800.0 |
| 2008-11-18 | BJK | ETF | 14.58 | 16.0 | 14.58 | 15.62 | 1000.0 |
| 2008-11-18 | BKF | ETF | 22.21 | 22.4079 | 21.12 | 21.75 | 38572.0 |
| 2008-11-18 | BLV | ETF | 68.43 | 69.19 | 68.37 | 68.92 | 7600.0 |
| 2008-11-18 | BMVP | ETF | 9.87 | 10.12 | 9.68 | 9.96 | 38192.0 |
| 2008-11-18 | BND | ETF | 74.45 | 74.8 | 74.45 | 74.67 | 205300.0 |
| 2008-11-18 | BNE | ETF | 2.8 | 2.82 | 2.42 | 2.51 | 177257.0 |
| 2008-11-18 | BRF | ETF | 14.91 | 14.93 | 14.9 | 14.9 | 23100.0 |
| 2008-11-18 | BSV | ETF | 77.1 | 77.23 | 76.82 | 77.0 | 55500.0 |
| 2008-11-18 | BTF | ETF | 45.75 | 45.949999999999996 | 42.24999999999999 | 43.449999999999996 | 42564.600000000006 |
| 2008-11-18 | BWX | ETF | 24.49 | 24.6 | 24.375 | 24.535 | 111980.0 |
| 2008-11-18 | CBON | ETF | 2.6 | 2.99 | 2.515 | 2.55 | 41630.0 |
| 2008-11-18 | CDL | ETF | 0.23 | 0.26 | 0.22 | 0.25 | 1153699.0 |
| 2008-11-18 | CEF | ETF | 8.72 | 8.84 | 8.38 | 8.46 | 539300.0 |
| 2008-11-18 | CGO | ETF | 8.47 | 8.52 | 8.23 | 8.5 | 38855.0 |
| 2008-11-18 | CGW | ETF | 14.32 | 14.81 | 13.97 | 14.29 | 29394.0 |
| 2008-11-18 | CHB | ETF | 0.43 | 0.63 | 0.4 | 0.4 | 2657755.0 |
| 2008-11-18 | CHI | ETF | 7.48 | 7.5 | 6.65 | 6.9 | 241121.0 |
| 2008-11-18 | CHIC | ETF | 5.99 | 6.0 | 5.27 | 5.4 | 554162.0 |
| 2008-11-18 | CHW | ETF | 6.07 | 6.07 | 4.67 | 5.04 | 244863.0 |
| 2008-11-18 | CHY | ETF | 7.49 | 7.49 | 6.51 | 6.72 | 306645.0 |
| 2008-11-18 | CMF | ETF | 49.875 | 50.625 | 49.875 | 50.175 | 4558.0 |
| 2008-11-18 | CNXT | ETF | 1.0 | 1.1 | 0.88 | 0.98 | 391888.0 |
| 2008-11-18 | COW | ETF | 34.1 | 34.74 | 34.1 | 34.41 | 52258.0 |
| 2008-11-18 | CPST | ETF | 0.98 | 1.01 | 0.74 | 0.74 | 4387657.0 |
> showing 50 of 610 rows — these rows as CSV