PREVIEW / etf_daily / 2008-12-22
file: by_date/etf_daily/2008/2008-12-22.parquet size: 28 KB rows: 632
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-12-22 | SPY | ETF | 88.58 | 88.67 | 85.49 | 87.06 | 243759500.0 |
| 2008-12-22 | QQQ | ETF | 29.86 | 29.92 | 28.74 | 29.21 | 95416288.0 |
| 2008-12-22 | IWM | ETF | 48.92 | 48.94 | 46.12 | 47.76 | 75338900.0 |
| 2008-12-22 | DIA | ETF | 85.8 | 85.93 | 83.59 | 84.96 | 20392200.0 |
| 2008-12-22 | GLD | ETF | 83.57 | 83.81 | 82.79 | 83.46 | 6690500.0 |
| 2008-12-22 | TLT | ETF | 122.39 | 122.39 | 120.73 | 121.32 | 2221400.0 |
| 2008-12-22 | AAXJ | ETF | 34.29 | 34.29 | 33.0 | 33.13 | 524000.0 |
| 2008-12-22 | ACWI | ETF | 31.65 | 31.65 | 30.61 | 31.14 | 466300.0 |
| 2008-12-22 | ACWX | ETF | 29.87 | 29.87 | 28.95 | 29.39 | 329857.0 |
| 2008-12-22 | ADRE | ETF | 27.26 | 27.278 | 26.05 | 26.05 | 159111.0 |
| 2008-12-22 | AFK | ETF | 20.91 | 20.91 | 20.8372 | 20.8372 | 900.0 |
| 2008-12-22 | AGG | ETF | 102.3 | 102.54 | 101.98 | 102.53 | 1490200.0 |
| 2008-12-22 | AGQ | ETF | 59.52 | 59.6 | 57.9 | 58.2 | 6300.0 |
| 2008-12-22 | AGZ | ETF | 108.8 | 108.8 | 108.35 | 108.39 | 6714.0 |
| 2008-12-22 | AIA | ETF | 26.1 | 26.1 | 25.0 | 25.0 | 18076.0 |
| 2008-12-22 | AIQ | ETF | 36.65 | 37.1 | 34.5 | 35.5 | 34338.0 |
| 2008-12-22 | AIS | ETF | 0.32 | 0.34 | 0.32 | 0.34 | 38550.0 |
| 2008-12-22 | AIVI | ETF | 33.01 | 33.86 | 32.06 | 32.39 | 82400.0 |
| 2008-12-22 | AOA | ETF | 25.93 | 25.93 | 23.25 | 23.26 | 9300.0 |
| 2008-12-22 | AOK | ETF | 25.55 | 25.55 | 25.55 | 25.55 | 300.0 |
| 2008-12-22 | AOM | ETF | 24.99 | 24.99 | 24.99 | 24.99 | 700.0 |
| 2008-12-22 | AOR | ETF | 26.0 | 26.0 | 24.05 | 24.05 | 3200.0 |
| 2008-12-22 | ARB | ETF | 12.26 | 12.61 | 11.86 | 12.15 | 320991.0 |
| 2008-12-22 | BAL | ETF | 26.41 | 26.45 | 26.41 | 26.45 | 770.0 |
| 2008-12-22 | BBH | ETF | 56.8833 | 57.8733 | 56.31 | 56.84 | 352800.0 |
| 2008-12-22 | BIL | ETF | 91.82 | 91.84 | 91.7 | 91.84 | 116100.0 |
| 2008-12-22 | BITS | ETF | 17.6004 | 17.72 | 17.6 | 17.64 | 419.0 |
| 2008-12-22 | BIV | ETF | 78.29 | 79.13 | 78.29 | 78.89 | 65200.0 |
| 2008-12-22 | BJK | ETF | 17.29 | 17.29 | 17.0 | 17.0 | 1700.0 |
| 2008-12-22 | BKF | ETF | 25.51 | 25.51 | 24.276 | 24.66 | 45568.0 |
| 2008-12-22 | BLV | ETF | 80.36 | 81.36 | 79.74 | 80.41 | 56900.0 |
| 2008-12-22 | BMVP | ETF | 10.48 | 10.54 | 10.12 | 10.31 | 42717.0 |
| 2008-12-22 | BND | ETF | 77.88 | 78.27 | 77.75 | 78.24 | 261200.0 |
| 2008-12-22 | BNE | ETF | 5.51 | 5.96 | 4.85 | 4.96 | 263111.0 |
| 2008-12-22 | BSV | ETF | 79.44 | 79.9 | 78.53 | 79.9 | 220900.0 |
| 2008-12-22 | BTF | ETF | 49.45 | 49.45 | 47.449999999999996 | 48.65 | 7939.400000000001 |
| 2008-12-22 | BWX | ETF | 27.315 | 27.3172 | 27.125 | 27.225 | 288122.0 |
| 2008-12-22 | CBON | ETF | 2.38 | 2.5 | 2.31 | 2.45 | 60151.0 |
| 2008-12-22 | CDL | ETF | 0.23 | 0.24 | 0.18 | 0.21 | 1425181.0 |
| 2008-12-22 | CEF | ETF | 10.54 | 10.63 | 10.41 | 10.45 | 519100.0 |
| 2008-12-22 | CGO | ETF | 9.29 | 9.31 | 8.95 | 9.19 | 55499.0 |
| 2008-12-22 | CGW | ETF | 14.59 | 14.84 | 14.1901 | 14.33 | 83399.0 |
| 2008-12-22 | CHB | ETF | 0.61 | 0.71 | 0.61 | 0.71 | 1777668.0 |
| 2008-12-22 | CHI | ETF | 7.87 | 8.22 | 7.87 | 8.1 | 354541.0 |
| 2008-12-22 | CHIC | ETF | 6.68 | 6.68 | 6.31 | 6.52 | 453114.0 |
| 2008-12-22 | CHW | ETF | 5.37 | 5.37 | 5.25 | 5.34 | 321424.0 |
| 2008-12-22 | CHY | ETF | 7.65 | 7.94 | 7.6365 | 7.83 | 470405.0 |
| 2008-12-22 | CMF | ETF | 50.365 | 50.365 | 49.65 | 50.17 | 13474.0 |
| 2008-12-22 | CNXT | ETF | 0.74 | 0.74 | 0.66 | 0.69 | 678780.0 |
| 2008-12-22 | COW | ETF | 33.92 | 33.92 | 33.55 | 33.57 | 14804.0 |
> showing 50 of 632 rows — these rows as CSV