PREVIEW / etf_daily / 2009-03-03
file: by_date/etf_daily/2009/2009-03-03.parquet size: 28 KB rows: 643
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-03 | SPY | ETF | 71.61 | 71.7 | 69.64 | 70.07 | 443761000.0 |
| 2009-03-03 | QQQ | ETF | 26.85 | 27.16 | 26.42 | 26.62 | 158739966.0 |
| 2009-03-03 | IWM | ETF | 37.43 | 37.47 | 36.02 | 36.24 | 67796200.0 |
| 2009-03-03 | DIA | ETF | 68.48 | 68.6 | 67.09 | 67.21 | 30799800.0 |
| 2009-03-03 | GLD | ETF | 90.85 | 91.04 | 88.94 | 90.04 | 28082900.0 |
| 2009-03-03 | TLT | ETF | 102.23 | 103.57 | 101.81 | 102.59 | 3084900.0 |
| 2009-03-03 | AAXJ | ETF | 27.34 | 27.61 | 26.86 | 27.18 | 61500.0 |
| 2009-03-03 | ACWI | ETF | 24.96 | 24.96 | 24.19 | 24.39 | 275100.0 |
| 2009-03-03 | ACWX | ETF | 23.09 | 23.09 | 22.352 | 22.67 | 95983.0 |
| 2009-03-03 | ADRE | ETF | 23.62 | 23.91 | 22.95 | 23.5 | 160075.0 |
| 2009-03-03 | AFK | ETF | 18.1999 | 18.1999 | 17.12 | 17.12 | 2119.0 |
| 2009-03-03 | AGG | ETF | 100.55 | 100.68 | 100.09 | 100.57 | 970700.0 |
| 2009-03-03 | AGQ | ETF | 76.92 | 78.08 | 73.1 | 78.08 | 148150.0 |
| 2009-03-03 | AGZ | ETF | 107.93 | 107.93 | 107.07 | 107.64 | 66285.0 |
| 2009-03-03 | AIA | ETF | 19.89 | 21.24 | 19.74 | 20.79 | 23088.0 |
| 2009-03-03 | AIQ | ETF | 38.85 | 39.8 | 37.75 | 39.45 | 81022.0 |
| 2009-03-03 | AIS | ETF | 0.4 | 0.41 | 0.38 | 0.39 | 37481.0 |
| 2009-03-03 | AIVI | ETF | 24.84 | 24.99 | 24.03 | 24.46 | 37100.0 |
| 2009-03-03 | AOA | ETF | 19.03 | 19.6 | 19.03 | 19.39 | 2400.0 |
| 2009-03-03 | AOK | ETF | 24.8 | 24.8 | 23.9 | 23.91 | 13673.0 |
| 2009-03-03 | AOM | ETF | 22.74 | 24.51 | 21.91 | 23.0 | 9248.0 |
| 2009-03-03 | AOR | ETF | 21.47 | 22.09 | 21.19 | 21.19 | 8135.0 |
| 2009-03-03 | ARB | ETF | 12.65 | 13.06 | 12.58 | 12.85 | 666410.0 |
| 2009-03-03 | BAL | ETF | 23.75 | 23.75 | 23.75 | 23.75 | 110.0 |
| 2009-03-03 | BBH | ETF | 52.6933 | 53.5033 | 52.16 | 52.5467 | 373200.0 |
| 2009-03-03 | BIL | ETF | 91.8 | 91.8 | 91.66 | 91.76 | 397650.0 |
| 2009-03-03 | BITS | ETF | 17.0 | 18.76 | 16.8 | 17.88 | 1362.0 |
| 2009-03-03 | BIV | ETF | 75.28 | 75.84 | 75.12 | 75.64 | 95900.0 |
| 2009-03-03 | BJK | ETF | 15.24 | 15.24 | 13.89 | 14.26 | 2900.0 |
| 2009-03-03 | BKF | ETF | 20.32 | 20.85 | 19.93 | 20.47 | 18207.0 |
| 2009-03-03 | BLV | ETF | 71.73 | 72.34 | 71.65 | 72.01 | 67000.0 |
| 2009-03-03 | BMVP | ETF | 8.9 | 8.91 | 8.67 | 8.71 | 85793.0 |
| 2009-03-03 | BND | ETF | 76.26 | 76.48 | 76.04 | 76.18 | 893600.0 |
| 2009-03-03 | BNE | ETF | 1.47 | 1.52 | 1.31 | 1.39 | 161805.0 |
| 2009-03-03 | BOSS | ETF | 9.4 | 9.4 | 9.32 | 9.32 | 300.0 |
| 2009-03-03 | BSV | ETF | 78.65 | 78.65 | 78.26 | 78.5 | 247200.0 |
| 2009-03-03 | BTF | ETF | 35.15 | 35.15 | 33.75 | 34.05 | 36451.0 |
| 2009-03-03 | BWX | ETF | 24.3 | 24.375 | 24.11 | 24.13 | 344892.0 |
| 2009-03-03 | BWZ | ETF | 31.29 | 31.29 | 31.25 | 31.25 | 6200.0 |
| 2009-03-03 | CBON | ETF | 0.61 | 0.69 | 0.61 | 0.63 | 57571.0 |
| 2009-03-03 | CDL | ETF | 0.1 | 0.11 | 0.09 | 0.1 | 1567828.0 |
| 2009-03-03 | CEF | ETF | 11.41 | 11.49 | 11.12 | 11.31 | 1763700.0 |
| 2009-03-03 | CGO | ETF | 7.68 | 7.812 | 7.55 | 7.66 | 48225.0 |
| 2009-03-03 | CGW | ETF | 10.77 | 11.0 | 10.62 | 10.74 | 84569.0 |
| 2009-03-03 | CHB | ETF | 0.29 | 0.33 | 0.25 | 0.26 | 582400.0 |
| 2009-03-03 | CHI | ETF | 7.34 | 7.34 | 6.83 | 7.08 | 374206.0 |
| 2009-03-03 | CHIC | ETF | 4.98 | 5.25 | 4.88 | 4.91 | 607767.0 |
| 2009-03-03 | CHW | ETF | 4.48 | 4.59 | 4.34 | 4.59 | 253733.0 |
| 2009-03-03 | CHY | ETF | 7.21 | 7.3 | 6.64 | 6.98 | 588923.0 |
| 2009-03-03 | CMF | ETF | 51.05 | 51.3375 | 51.05 | 51.301 | 6052.0 |
> showing 50 of 643 rows — these rows as CSV