PREVIEW / etf_daily / 2009-03-10
file: by_date/etf_daily/2009/2009-03-10.parquet size: 28 KB rows: 632
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-10 | SPY | ETF | 69.51 | 72.37 | 69.37 | 72.17 | 406227900.0 |
| 2009-03-10 | QQQ | ETF | 26.26 | 27.39 | 26.16 | 27.33 | 175068132.0 |
| 2009-03-10 | IWM | ETF | 35.25 | 36.81 | 35.1 | 36.63 | 76181500.0 |
| 2009-03-10 | DIA | ETF | 66.62 | 69.23 | 66.54 | 69.14 | 31008100.0 |
| 2009-03-10 | GLD | ETF | 89.54 | 89.61 | 87.47 | 88.14 | 25924900.0 |
| 2009-03-10 | TLT | ETF | 102.43 | 102.75 | 101.51 | 101.66 | 2602600.0 |
| 2009-03-10 | AAXJ | ETF | 28.81 | 29.66 | 28.39 | 29.59 | 92500.0 |
| 2009-03-10 | ACWI | ETF | 24.71 | 25.45 | 24.65 | 25.44 | 86600.0 |
| 2009-03-10 | ACWX | ETF | 23.02 | 23.78 | 22.99 | 23.64 | 128755.0 |
| 2009-03-10 | ADRE | ETF | 24.35 | 25.42 | 24.35 | 25.39 | 225687.0 |
| 2009-03-10 | AFK | ETF | 18.18 | 18.18 | 17.99 | 17.99 | 300.0 |
| 2009-03-10 | AGG | ETF | 99.9 | 100.25 | 99.82 | 100.24 | 507500.0 |
| 2009-03-10 | AGQ | ETF | 76.36 | 76.82 | 73.0 | 74.62 | 92550.0 |
| 2009-03-10 | AGZ | ETF | 107.57 | 107.57 | 106.976 | 107.47 | 19295.0 |
| 2009-03-10 | AIA | ETF | 21.936 | 22.79 | 21.936 | 22.72 | 22406.0 |
| 2009-03-10 | AIQ | ETF | 35.45 | 36.1 | 34.5 | 35.1 | 58352.0 |
| 2009-03-10 | AIS | ETF | 0.39 | 0.41 | 0.37 | 0.39 | 159503.0 |
| 2009-03-10 | AIVI | ETF | 24.06 | 24.87 | 24.06 | 24.77 | 42700.0 |
| 2009-03-10 | AOA | ETF | 19.65 | 19.82 | 19.65 | 19.82 | 4700.0 |
| 2009-03-10 | AOK | ETF | 23.96 | 23.962 | 23.948 | 23.962 | 1240.0 |
| 2009-03-10 | AOM | ETF | 22.47 | 22.81 | 22.47 | 22.81 | 1730.0 |
| 2009-03-10 | AOR | ETF | 21.44 | 21.44 | 21.4346 | 21.4346 | 1175.0 |
| 2009-03-10 | ARB | ETF | 12.1 | 12.98 | 11.94 | 12.67 | 269100.0 |
| 2009-03-10 | BAL | ETF | 23.94 | 24.1299 | 23.9399 | 24.1299 | 530.0 |
| 2009-03-10 | BBH | ETF | 55.28 | 55.6333 | 55.0067 | 55.5533 | 502200.0 |
| 2009-03-10 | BIL | ETF | 91.78 | 91.78 | 91.7 | 91.76 | 136850.0 |
| 2009-03-10 | BITS | ETF | 17.56 | 17.56 | 16.4 | 17.48 | 5821.0 |
| 2009-03-10 | BIV | ETF | 74.88 | 75.0 | 74.56 | 74.85 | 121600.0 |
| 2009-03-10 | BJK | ETF | 13.39 | 14.35 | 13.15 | 13.7 | 68400.0 |
| 2009-03-10 | BKF | ETF | 21.37 | 22.83 | 21.37 | 22.7 | 51393.0 |
| 2009-03-10 | BLV | ETF | 71.96 | 73.05 | 71.35 | 71.35 | 15800.0 |
| 2009-03-10 | BMVP | ETF | 8.61 | 8.98 | 8.61 | 8.98 | 54310.0 |
| 2009-03-10 | BND | ETF | 75.83 | 76.19 | 75.72 | 76.0 | 635400.0 |
| 2009-03-10 | BNE | ETF | 1.32 | 1.37 | 1.1 | 1.21 | 346616.0 |
| 2009-03-10 | BSV | ETF | 77.95 | 78.32 | 77.93 | 77.94 | 267400.0 |
| 2009-03-10 | BTF | ETF | 32.949999999999996 | 35.0 | 32.9 | 35.0 | 23716.600000000002 |
| 2009-03-10 | BWX | ETF | 24.43 | 24.59 | 24.26 | 24.35 | 185374.0 |
| 2009-03-10 | BWZ | ETF | 31.4 | 31.41 | 31.275 | 31.275 | 1850.0 |
| 2009-03-10 | CBON | ETF | 0.75 | 1.21 | 0.75 | 0.99 | 70102.0 |
| 2009-03-10 | CEF | ETF | 11.65 | 11.65 | 11.26 | 11.39 | 1206500.0 |
| 2009-03-10 | CGO | ETF | 7.2 | 8.05 | 7.2 | 7.66 | 61404.0 |
| 2009-03-10 | CGW | ETF | 10.37 | 10.981 | 10.37 | 10.9252 | 56775.0 |
| 2009-03-10 | CHB | ETF | 0.19 | 0.22 | 0.178 | 0.22 | 869283.0 |
| 2009-03-10 | CHI | ETF | 6.6 | 7.21 | 6.6 | 7.11 | 288761.0 |
| 2009-03-10 | CHIC | ETF | 5.69 | 6.9 | 5.38 | 6.47 | 654668.0 |
| 2009-03-10 | CHW | ETF | 4.13 | 4.46 | 4.13 | 4.41 | 276686.0 |
| 2009-03-10 | CHY | ETF | 6.41 | 7.22 | 6.41 | 7.22 | 666217.0 |
| 2009-03-10 | CMF | ETF | 50.52 | 51.0725 | 50.52 | 50.545 | 22890.0 |
| 2009-03-10 | CNXT | ETF | 0.365 | 0.39 | 0.36 | 0.39 | 318514.0 |
| 2009-03-10 | COW | ETF | 31.11 | 31.132 | 30.7 | 30.7 | 27722.0 |
> showing 50 of 632 rows — these rows as CSV