PREVIEW / etf_daily / 2009-03-25
file: by_date/etf_daily/2009/2009-03-25.parquet size: 28 KB rows: 647
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-03-25 | SPY | ETF | 81.23 | 82.7 | 79.06 | 81.45 | 441775100.0 |
| 2009-03-25 | QQQ | ETF | 30.58 | 31.05 | 29.66 | 30.47 | 190601573.0 |
| 2009-03-25 | IWM | ETF | 41.95 | 43.28 | 40.81 | 42.73 | 95016000.0 |
| 2009-03-25 | DIA | ETF | 77.25 | 78.62 | 75.48 | 77.41 | 30263100.0 |
| 2009-03-25 | GLD | ETF | 90.87 | 92.63 | 90.34 | 91.98 | 24788700.0 |
| 2009-03-25 | TLT | ETF | 103.29 | 103.72 | 102.31 | 102.6 | 2549600.0 |
| 2009-03-25 | AAXJ | ETF | 33.79 | 34.35 | 33.3 | 33.67 | 41900.0 |
| 2009-03-25 | ACWI | ETF | 28.94 | 29.54 | 28.52 | 29.16 | 85900.0 |
| 2009-03-25 | ACWX | ETF | 27.29 | 27.74 | 26.93 | 27.38 | 791472.0 |
| 2009-03-25 | ADRE | ETF | 28.54 | 29.034 | 28.02 | 28.48 | 211056.0 |
| 2009-03-25 | AFK | ETF | 20.23 | 20.3099 | 19.78 | 19.78 | 9700.0 |
| 2009-03-25 | AGG | ETF | 100.66 | 101.0 | 100.09 | 100.2 | 1241000.0 |
| 2009-03-25 | AGQ | ETF | 81.98 | 86.3 | 80.32 | 85.0 | 137700.0 |
| 2009-03-25 | AGZ | ETF | 107.2 | 107.86 | 107.2 | 107.45 | 6020.0 |
| 2009-03-25 | AIA | ETF | 26.15 | 26.15 | 25.33 | 25.6 | 18783.0 |
| 2009-03-25 | AIQ | ETF | 34.25 | 35.35 | 33.85 | 35.05 | 28960.0 |
| 2009-03-25 | AIS | ETF | 0.4 | 0.44 | 0.39 | 0.41 | 152450.0 |
| 2009-03-25 | AIVI | ETF | 29.23 | 29.41 | 28.54 | 29.22 | 35800.0 |
| 2009-03-25 | AOA | ETF | 22.37 | 22.42 | 21.83 | 22.21 | 2900.0 |
| 2009-03-25 | AOK | ETF | 25.39 | 25.39 | 24.7844 | 24.7844 | 4214.0 |
| 2009-03-25 | AOM | ETF | 24.11 | 24.85 | 23.9099 | 23.984 | 16322.0 |
| 2009-03-25 | AOR | ETF | 23.53 | 23.53 | 23.26 | 23.29 | 3377.0 |
| 2009-03-25 | ARB | ETF | 12.26 | 13.63 | 10.57 | 13.59 | 403863.0 |
| 2009-03-25 | BAL | ETF | 25.37 | 25.59 | 25.37 | 25.57 | 5040.0 |
| 2009-03-25 | BBH | ETF | 57.2867 | 57.9233 | 56.95 | 57.5633 | 654600.0 |
| 2009-03-25 | BIL | ETF | 91.74 | 91.78 | 91.74 | 91.78 | 165200.0 |
| 2009-03-25 | BITS | ETF | 17.56 | 18.0 | 16.8 | 18.0 | 1670.0 |
| 2009-03-25 | BIV | ETF | 75.93 | 76.18 | 75.62 | 75.69 | 190900.0 |
| 2009-03-25 | BJK | ETF | 17.45 | 18.05 | 15.87 | 16.02 | 383200.0 |
| 2009-03-25 | BKF | ETF | 25.43 | 26.94 | 24.61 | 25.89 | 50758.0 |
| 2009-03-25 | BLV | ETF | 73.29 | 73.29 | 72.5 | 72.7 | 11500.0 |
| 2009-03-25 | BMVP | ETF | 9.897 | 10.033 | 9.667 | 9.949 | 22040.0 |
| 2009-03-25 | BND | ETF | 76.86 | 76.86 | 76.5 | 76.52 | 573300.0 |
| 2009-03-25 | BNE | ETF | 3.52 | 4.25 | 3.2 | 3.46 | 368215.0 |
| 2009-03-25 | BOSS | ETF | 11.23 | 11.23 | 11.1 | 11.1 | 100.0 |
| 2009-03-25 | BSV | ETF | 78.52 | 78.52 | 78.25 | 78.3 | 185900.0 |
| 2009-03-25 | BTF | ETF | 40.65 | 41.659499999999994 | 40.0 | 40.4 | 6394.200000000001 |
| 2009-03-25 | BWX | ETF | 25.75 | 26.03 | 25.689 | 25.965 | 291910.0 |
| 2009-03-25 | BWZ | ETF | 33.22 | 33.32 | 33.15 | 33.15 | 43500.0 |
| 2009-03-25 | CBON | ETF | 1.275 | 1.3199 | 1.17 | 1.25 | 13178.0 |
| 2009-03-25 | CEF | ETF | 12.14 | 12.38 | 11.97 | 12.37 | 1206100.0 |
| 2009-03-25 | CGO | ETF | 9.29 | 9.43 | 9.0 | 9.3 | 30174.0 |
| 2009-03-25 | CGW | ETF | 12.25 | 12.6014 | 12.05 | 12.37 | 85269.0 |
| 2009-03-25 | CHB | ETF | 0.4484 | 0.71 | 0.4484 | 0.71 | 4042197.0 |
| 2009-03-25 | CHI | ETF | 8.77 | 8.99 | 8.48 | 8.68 | 250386.0 |
| 2009-03-25 | CHIC | ETF | 6.96 | 7.62 | 6.86 | 7.43 | 144160.0 |
| 2009-03-25 | CHW | ETF | 5.57 | 5.61 | 5.4116 | 5.58 | 144209.0 |
| 2009-03-25 | CHY | ETF | 8.37 | 8.48 | 8.18 | 8.27 | 224643.0 |
| 2009-03-25 | CMF | ETF | 51.833 | 52.185 | 51.833 | 52.185 | 17568.0 |
| 2009-03-25 | CNXT | ETF | 0.69 | 0.71 | 0.69 | 0.71 | 84094.0 |
> showing 50 of 647 rows — these rows as CSV