PREVIEW / etf_daily / 2009-11-03
file: by_date/etf_daily/2009/2009-11-03.parquet size: 30 KB rows: 680
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-11-03 | SPY | ETF | 103.74 | 104.8 | 103.54 | 104.65 | 228362600.0 |
| 2009-11-03 | QQQ | ETF | 40.97 | 41.32 | 40.84 | 41.26 | 95106973.0 |
| 2009-11-03 | IWM | ETF | 55.88 | 57.09 | 55.69 | 57.07 | 83105700.0 |
| 2009-11-03 | DIA | ETF | 97.26 | 97.93 | 97.07 | 97.8 | 13945600.0 |
| 2009-11-03 | GLD | ETF | 103.74 | 106.7 | 103.72 | 106.46 | 33610400.0 |
| 2009-11-03 | TLT | ETF | 95.28 | 95.36 | 94.0 | 94.1 | 4470700.0 |
| 2009-11-03 | AAXJ | ETF | 51.22 | 51.69 | 50.96 | 51.69 | 160500.0 |
| 2009-11-03 | ACWI | ETF | 39.77 | 40.16 | 39.56 | 40.04 | 46500.0 |
| 2009-11-03 | ACWX | ETF | 38.29 | 39.12 | 38.28 | 39.1 | 84269.0 |
| 2009-11-03 | ADRE | ETF | 40.42 | 41.52 | 40.12 | 41.4 | 207048.0 |
| 2009-11-03 | AFK | ETF | 27.8 | 28.12 | 27.8 | 27.8801 | 10500.0 |
| 2009-11-03 | AGG | ETF | 104.4 | 104.51 | 104.17 | 104.18 | 684600.0 |
| 2009-11-03 | AGQ | ETF | 108.06 | 122.02 | 107.98 | 121.16 | 561350.0 |
| 2009-11-03 | AGZ | ETF | 108.43 | 108.43 | 108.03 | 108.03 | 10769.0 |
| 2009-11-03 | AIA | ETF | 36.93 | 37.43 | 36.93 | 37.29 | 33778.0 |
| 2009-11-03 | AIQ | ETF | 26.65 | 27.01 | 26.25 | 26.5 | 27819.0 |
| 2009-11-03 | AIS | ETF | 1.07 | 1.12 | 1.01 | 1.12 | 546120.0 |
| 2009-11-03 | AIVI | ETF | 40.8 | 41.51 | 40.8 | 41.49 | 21200.0 |
| 2009-11-03 | AMJ | ETF | 25.67 | 25.71 | 25.38 | 25.71 | 414356.0 |
| 2009-11-03 | AOA | ETF | 28.19 | 28.41 | 28.09 | 28.41 | 1000.0 |
| 2009-11-03 | AOK | ETF | 26.89 | 26.95 | 26.89 | 26.931 | 7328.0 |
| 2009-11-03 | AOM | ETF | 27.56 | 27.56 | 27.39 | 27.482 | 9625.0 |
| 2009-11-03 | AOR | ETF | 27.72 | 27.9192 | 27.72 | 27.91 | 5371.0 |
| 2009-11-03 | ARB | ETF | 21.65 | 21.65 | 21.24 | 21.5 | 460332.0 |
| 2009-11-03 | BAL | ETF | 34.99 | 35.39 | 34.76 | 35.078 | 18590.0 |
| 2009-11-03 | BBH | ETF | 29.9267 | 30.6733 | 29.9233 | 30.56 | 247500.0 |
| 2009-11-03 | BIL | ETF | 91.76 | 91.76 | 91.74 | 91.76 | 143450.0 |
| 2009-11-03 | BITS | ETF | 26.08 | 27.72 | 26.08 | 26.8 | 5535.0 |
| 2009-11-03 | BIV | ETF | 79.91 | 80.16 | 79.85 | 79.87 | 91400.0 |
| 2009-11-03 | BJK | ETF | 23.32 | 24.02 | 23.31 | 23.76 | 65400.0 |
| 2009-11-03 | BKF | ETF | 42.35 | 43.19 | 41.95 | 43.01 | 307848.0 |
| 2009-11-03 | BLV | ETF | 78.38 | 78.39 | 77.58 | 77.7 | 27900.0 |
| 2009-11-03 | BMVP | ETF | 11.6733 | 11.8259 | 11.6733 | 11.8067 | 16809.0 |
| 2009-11-03 | BND | ETF | 79.17 | 79.17 | 78.95 | 79.01 | 609900.0 |
| 2009-11-03 | BNE | ETF | 6.31 | 6.71 | 6.31 | 6.56 | 162970.0 |
| 2009-11-03 | BOSS | ETF | 18.6 | 18.6 | 17.14 | 17.14 | 100.0 |
| 2009-11-03 | BRF | ETF | 41.21 | 42.92 | 40.7701 | 42.52 | 495691.0 |
| 2009-11-03 | BSV | ETF | 79.92 | 79.93 | 79.85 | 79.89 | 439600.0 |
| 2009-11-03 | BTF | ETF | 59.85 | 60.8 | 59.85 | 60.8 | 26427.2 |
| 2009-11-03 | BWX | ETF | 29.165 | 29.225 | 29.06 | 29.13 | 687382.0 |
| 2009-11-03 | BWZ | ETF | 37.0 | 37.09 | 36.76 | 36.97 | 86651.0 |
| 2009-11-03 | BZQ | ETF | 4961.6 | 4974.4 | 4464.0 | 4536.0 | 323.0 |
| 2009-11-03 | CEF | ETF | 13.21 | 14.08 | 13.21 | 14.02 | 2300100.0 |
| 2009-11-03 | CEW | ETF | 21.58 | 21.73 | 21.58 | 21.694 | 77034.0 |
| 2009-11-03 | CGO | ETF | 13.12 | 13.12 | 12.76 | 13.0846 | 22923.0 |
| 2009-11-03 | CGW | ETF | 17.0 | 17.27 | 17.0 | 17.21 | 135791.0 |
| 2009-11-03 | CHB | ETF | 0.22 | 0.24 | 0.21 | 0.215 | 1055257.0 |
| 2009-11-03 | CHI | ETF | 11.03 | 11.7349 | 11.02 | 11.64 | 133837.0 |
| 2009-11-03 | CHW | ETF | 7.36 | 7.4 | 7.16 | 7.4 | 272837.0 |
| 2009-11-03 | CHY | ETF | 11.13 | 11.33 | 11.07 | 11.28 | 127425.0 |
> showing 50 of 680 rows — these rows as CSV