PREVIEW / etf_daily / 2009-03-18
file: by_date/etf_daily/2009/2009-03-18.parquet size: 28 KB rows: 640
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-18 | SPY | ETF | 77.81 | 80.9 | 77.07 | 79.93 | 473273200.0 |
| 2009-03-18 | QQQ | ETF | 29.23 | 30.2 | 29.08 | 29.7 | 208146881.0 |
| 2009-03-18 | IWM | ETF | 40.26 | 42.18 | 39.91 | 41.85 | 111491000.0 |
| 2009-03-18 | DIA | ETF | 73.49 | 75.89 | 72.72 | 74.97 | 35906600.0 |
| 2009-03-18 | GLD | ETF | 88.75 | 93.39 | 86.83 | 93.09 | 59424700.0 |
| 2009-03-18 | TLT | ETF | 101.12 | 108.07 | 100.9 | 104.37 | 8578800.0 |
| 2009-03-18 | AAXJ | ETF | 31.82 | 32.57 | 31.11 | 32.25 | 87000.0 |
| 2009-03-18 | ACWI | ETF | 28.71 | 28.71 | 26.33 | 28.11 | 87200.0 |
| 2009-03-18 | ACWX | ETF | 25.1 | 26.36 | 25.05 | 26.26 | 67167.0 |
| 2009-03-18 | ADRE | ETF | 27.08 | 27.824 | 26.39 | 27.1 | 245649.0 |
| 2009-03-18 | AFK | ETF | 18.96 | 20.1 | 18.86 | 20.1 | 1300.0 |
| 2009-03-18 | AGG | ETF | 100.2 | 101.88 | 100.12 | 101.65 | 493700.0 |
| 2009-03-18 | AGQ | ETF | 73.88 | 79.48 | 66.24 | 78.7 | 257700.0 |
| 2009-03-18 | AGZ | ETF | 106.62 | 115.625 | 106.62 | 108.49 | 8118.0 |
| 2009-03-18 | AIA | ETF | 24.22 | 25.28 | 24.0221 | 25.02 | 17097.0 |
| 2009-03-18 | AIQ | ETF | 34.15 | 36.3 | 34.0 | 35.15 | 93275.0 |
| 2009-03-18 | AIS | ETF | 0.38 | 0.4 | 0.37 | 0.4 | 33700.0 |
| 2009-03-18 | AIVI | ETF | 26.95 | 28.09 | 26.66 | 27.79 | 104400.0 |
| 2009-03-18 | AOA | ETF | 21.03 | 21.72 | 20.63 | 21.69 | 33400.0 |
| 2009-03-18 | AOK | ETF | 24.41 | 24.864 | 24.41 | 24.61 | 602.0 |
| 2009-03-18 | AOM | ETF | 23.4501 | 23.9268 | 23.3995 | 23.8268 | 4919.0 |
| 2009-03-18 | AOR | ETF | 22.388 | 23.01 | 21.79 | 22.95 | 14903.0 |
| 2009-03-18 | ARB | ETF | 13.02 | 13.53 | 12.57 | 13.46 | 323038.0 |
| 2009-03-18 | BAL | ETF | 24.4 | 24.4 | 24.1 | 24.25 | 1850.0 |
| 2009-03-18 | BBH | ETF | 57.8033 | 57.9767 | 57.1967 | 57.3467 | 489600.0 |
| 2009-03-18 | BIL | ETF | 91.72 | 91.82 | 91.68 | 91.76 | 421100.0 |
| 2009-03-18 | BITS | ETF | 17.8 | 18.4 | 16.12 | 18.12 | 2668.0 |
| 2009-03-18 | BIV | ETF | 75.17 | 77.76 | 75.0 | 77.3 | 92200.0 |
| 2009-03-18 | BJK | ETF | 14.63 | 16.45 | 14.63 | 14.99 | 3900.0 |
| 2009-03-18 | BKF | ETF | 23.8 | 24.74 | 23.41 | 24.31 | 69659.0 |
| 2009-03-18 | BLV | ETF | 70.76 | 73.98 | 70.76 | 72.46 | 29100.0 |
| 2009-03-18 | BMVP | ETF | 9.5767 | 9.8767 | 9.5055 | 9.76 | 26754.0 |
| 2009-03-18 | BND | ETF | 76.26 | 78.0 | 76.13 | 77.4 | 401300.0 |
| 2009-03-18 | BNE | ETF | 1.4 | 1.92 | 1.4 | 1.92 | 485656.0 |
| 2009-03-18 | BOSS | ETF | 10.73 | 10.9 | 10.55 | 10.66 | 100.0 |
| 2009-03-18 | BSV | ETF | 78.02 | 79.66 | 77.83 | 78.92 | 166500.0 |
| 2009-03-18 | BTF | ETF | 37.55 | 39.0 | 37.5 | 38.699999999999996 | 5430.0 |
| 2009-03-18 | BWX | ETF | 25.03 | 25.8 | 25.025 | 25.7925 | 233780.0 |
| 2009-03-18 | BWZ | ETF | 33.17 | 33.17 | 33.17 | 33.17 | 130.0 |
| 2009-03-18 | CBON | ETF | 1.16 | 1.2 | 1.05 | 1.05 | 14549.0 |
| 2009-03-18 | CEF | ETF | 11.4 | 12.17 | 11.13 | 12.09 | 2131900.0 |
| 2009-03-18 | CGO | ETF | 8.8 | 8.88 | 8.57 | 8.76 | 34987.0 |
| 2009-03-18 | CGW | ETF | 11.51 | 12.0364 | 11.51 | 12.0 | 42464.0 |
| 2009-03-18 | CHB | ETF | 0.17 | 0.2 | 0.15 | 0.17 | 2300318.0 |
| 2009-03-18 | CHI | ETF | 8.24 | 8.38 | 8.03 | 8.2699 | 168515.0 |
| 2009-03-18 | CHIC | ETF | 6.55 | 6.66 | 6.2 | 6.44 | 210597.0 |
| 2009-03-18 | CHW | ETF | 5.15 | 5.34 | 4.95 | 5.27 | 313622.0 |
| 2009-03-18 | CHY | ETF | 8.09 | 8.1 | 7.9414 | 8.03 | 238339.0 |
| 2009-03-18 | CMF | ETF | 50.75 | 50.85 | 50.66 | 50.824 | 6454.0 |
| 2009-03-18 | CNXT | ETF | 0.59 | 0.72 | 0.56 | 0.72 | 566065.0 |
> showing 50 of 640 rows — these rows as CSV