PREVIEW / etf_daily / 2009-06-25
file: by_date/etf_daily/2009/2009-06-25.parquet size: 29 KB rows: 660
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-25 | SPY | ETF | 89.67 | 92.17 | 89.57 | 92.08 | 279411000.0 |
| 2009-06-25 | QQQ | ETF | 35.38 | 36.36 | 35.28 | 36.29 | 112538111.0 |
| 2009-06-25 | IWM | ETF | 49.15 | 51.08 | 49.09 | 51.05 | 42339200.0 |
| 2009-06-25 | DIA | ETF | 82.69 | 84.9 | 82.57 | 84.72 | 13851400.0 |
| 2009-06-25 | GLD | ETF | 92.12 | 92.33 | 91.72 | 92.31 | 11444800.0 |
| 2009-06-25 | TLT | ETF | 93.22 | 94.5 | 92.67 | 94.43 | 7140000.0 |
| 2009-06-25 | AAXJ | ETF | 43.32 | 44.32 | 43.15 | 44.27 | 197400.0 |
| 2009-06-25 | ACWI | ETF | 33.69 | 34.64 | 33.62 | 34.63 | 45600.0 |
| 2009-06-25 | ACWX | ETF | 32.22 | 33.32 | 32.22 | 33.29 | 1319713.0 |
| 2009-06-25 | ADRE | ETF | 33.43 | 34.59 | 33.37 | 34.59 | 334307.0 |
| 2009-06-25 | AFK | ETF | 26.64 | 26.64 | 25.77 | 26.1 | 8766.0 |
| 2009-06-25 | AGG | ETF | 101.58 | 102.12 | 101.44 | 101.92 | 575200.0 |
| 2009-06-25 | AGQ | ETF | 86.42 | 87.06 | 85.78 | 86.7 | 59250.0 |
| 2009-06-25 | AGZ | ETF | 107.07 | 107.61 | 106.7914 | 107.61 | 51470.0 |
| 2009-06-25 | AIA | ETF | 31.43 | 32.15 | 31.37 | 32.13 | 10254.0 |
| 2009-06-25 | AIQ | ETF | 36.85 | 37.55 | 36.4 | 37.05 | 18632.0 |
| 2009-06-25 | AIS | ETF | 0.65 | 0.71 | 0.649 | 0.69 | 191337.0 |
| 2009-06-25 | AIVI | ETF | 34.36 | 35.13 | 33.86 | 34.67 | 12100.0 |
| 2009-06-25 | AMJ | ETF | 21.45 | 21.98 | 21.405 | 21.92 | 85166.0 |
| 2009-06-25 | AOA | ETF | 24.68 | 25.08 | 24.68 | 25.08 | 8000.0 |
| 2009-06-25 | AOK | ETF | 25.88 | 25.88 | 25.56 | 25.715 | 8453.0 |
| 2009-06-25 | AOM | ETF | 25.63 | 25.72 | 25.2088 | 25.54 | 5915.0 |
| 2009-06-25 | AOR | ETF | 25.06 | 25.41 | 25.06 | 25.41 | 5081.0 |
| 2009-06-25 | ARB | ETF | 16.22 | 16.28 | 15.91 | 16.15 | 382572.0 |
| 2009-06-25 | BAL | ETF | 29.58 | 29.84 | 29.44 | 29.61 | 1500.0 |
| 2009-06-25 | BBH | ETF | 30.6 | 31.4433 | 30.44 | 31.4033 | 1280700.0 |
| 2009-06-25 | BIL | ETF | 91.74 | 91.78 | 91.74 | 91.76 | 322950.0 |
| 2009-06-25 | BITS | ETF | 19.12 | 19.24 | 18.64 | 19.2 | 3338.0 |
| 2009-06-25 | BIV | ETF | 76.41 | 77.0 | 76.16 | 76.94 | 83100.0 |
| 2009-06-25 | BJK | ETF | 20.71 | 21.11 | 20.28 | 20.74 | 9200.0 |
| 2009-06-25 | BKF | ETF | 34.22 | 35.5266 | 34.0 | 35.5266 | 138196.0 |
| 2009-06-25 | BLV | ETF | 73.99 | 74.27 | 73.09 | 74.16 | 18200.0 |
| 2009-06-25 | BMVP | ETF | 10.6567 | 10.9209 | 10.6567 | 10.9167 | 16403.0 |
| 2009-06-25 | BND | ETF | 77.29 | 77.64 | 77.05 | 77.64 | 449600.0 |
| 2009-06-25 | BNE | ETF | 6.28 | 6.52 | 6.24 | 6.51 | 133934.0 |
| 2009-06-25 | BRF | ETF | 27.3 | 28.05 | 27.1001 | 28.02 | 186398.0 |
| 2009-06-25 | BSV | ETF | 78.97 | 79.11 | 78.67 | 79.07 | 272200.0 |
| 2009-06-25 | BTF | ETF | 45.3 | 47.0 | 45.3 | 46.8 | 5012.6 |
| 2009-06-25 | BWX | ETF | 27.015 | 27.15 | 26.918 | 27.15 | 271508.0 |
| 2009-06-25 | BWZ | ETF | 34.93 | 34.99 | 34.93 | 34.99 | 500.0 |
| 2009-06-25 | BZQ | ETF | 10080.0 | 10171.2 | 9510.4 | 9510.4 | 13.25 |
| 2009-06-25 | CBON | ETF | 1.15 | 1.15 | 1.11 | 1.12 | 2899.0 |
| 2009-06-25 | CEF | ETF | 11.85 | 11.94 | 11.78 | 11.92 | 476600.0 |
| 2009-06-25 | CEW | ETF | 20.65 | 20.91 | 20.6001 | 20.75 | 39625.0 |
| 2009-06-25 | CGO | ETF | 11.26 | 11.84 | 11.26 | 11.84 | 22930.0 |
| 2009-06-25 | CGW | ETF | 15.17 | 15.489 | 15.03 | 15.47 | 64104.0 |
| 2009-06-25 | CHB | ETF | 0.35 | 0.39 | 0.35 | 0.36 | 397993.0 |
| 2009-06-25 | CHI | ETF | 10.27 | 10.53 | 10.27 | 10.5 | 107533.0 |
| 2009-06-25 | CHIC | ETF | 11.9 | 12.2 | 11.82 | 12.2 | 203486.0 |
| 2009-06-25 | CHW | ETF | 6.71 | 6.88 | 6.622 | 6.83 | 177276.0 |
> showing 50 of 660 rows — these rows as CSV