PREVIEW / etf_daily / 2009-06-24
file: by_date/etf_daily/2009/2009-06-24.parquet size: 29 KB rows: 659
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-06-24 | SPY | ETF | 90.16 | 91.08 | 89.6 | 90.12 | 211577700.0 |
| 2009-06-24 | QQQ | ETF | 35.3 | 35.87 | 35.28 | 35.59 | 103314561.0 |
| 2009-06-24 | IWM | ETF | 49.57 | 50.25 | 49.33 | 49.62 | 39962500.0 |
| 2009-06-24 | DIA | ETF | 83.74 | 84.28 | 82.58 | 83.03 | 15355500.0 |
| 2009-06-24 | GLD | ETF | 92.09 | 92.33 | 91.04 | 91.45 | 12113800.0 |
| 2009-06-24 | TLT | ETF | 93.65 | 94.07 | 92.66 | 92.73 | 6550400.0 |
| 2009-06-24 | AAXJ | ETF | 43.1 | 43.69 | 42.91 | 43.25 | 222400.0 |
| 2009-06-24 | ACWI | ETF | 33.87 | 34.23 | 33.67 | 33.74 | 60200.0 |
| 2009-06-24 | ACWX | ETF | 32.79 | 33.06 | 32.34 | 32.41 | 1441828.0 |
| 2009-06-24 | ADRE | ETF | 33.68 | 34.07 | 33.34 | 33.56 | 117167.0 |
| 2009-06-24 | AFK | ETF | 26.83 | 26.832 | 25.83 | 26.3499 | 3836.0 |
| 2009-06-24 | AGG | ETF | 101.65 | 101.99 | 101.45 | 101.45 | 525700.0 |
| 2009-06-24 | AGQ | ETF | 86.66 | 87.7 | 83.82 | 85.0 | 131150.0 |
| 2009-06-24 | AGZ | ETF | 107.03 | 107.1 | 106.4321 | 106.96 | 9110.0 |
| 2009-06-24 | AIA | ETF | 31.73 | 31.86 | 31.4 | 31.4399 | 9571.0 |
| 2009-06-24 | AIQ | ETF | 37.2 | 38.25 | 36.95 | 37.05 | 44258.0 |
| 2009-06-24 | AIS | ETF | 0.67 | 0.71 | 0.65 | 0.67 | 87790.0 |
| 2009-06-24 | AIVI | ETF | 33.66 | 34.89 | 33.66 | 34.37 | 6600.0 |
| 2009-06-24 | AMJ | ETF | 21.04 | 21.58 | 21.04 | 21.4 | 88556.0 |
| 2009-06-24 | AOA | ETF | 25.02 | 25.08 | 24.77 | 24.82 | 8600.0 |
| 2009-06-24 | AOK | ETF | 25.74 | 25.925 | 25.58 | 25.58 | 10120.0 |
| 2009-06-24 | AOM | ETF | 25.87 | 25.87 | 25.26 | 25.4988 | 5333.0 |
| 2009-06-24 | AOR | ETF | 25.4695 | 25.4695 | 25.22 | 25.27 | 10125.0 |
| 2009-06-24 | ARB | ETF | 15.85 | 16.26 | 15.73 | 16.13 | 331997.0 |
| 2009-06-24 | BAL | ETF | 29.6099 | 29.6099 | 29.3 | 29.508 | 11242.0 |
| 2009-06-24 | BBH | ETF | 30.6567 | 30.7767 | 30.4667 | 30.72 | 198600.0 |
| 2009-06-24 | BIL | ETF | 91.76 | 91.76 | 91.74 | 91.76 | 173300.0 |
| 2009-06-24 | BITS | ETF | 19.3548 | 19.36 | 18.64 | 18.64 | 1250.0 |
| 2009-06-24 | BIV | ETF | 76.68 | 77.0 | 76.25 | 76.41 | 85000.0 |
| 2009-06-24 | BJK | ETF | 19.23 | 20.99 | 18.73 | 20.41 | 13800.0 |
| 2009-06-24 | BKF | ETF | 34.47 | 34.95 | 33.992 | 34.29 | 201772.0 |
| 2009-06-24 | BLV | ETF | 74.31 | 74.31 | 73.46 | 73.7 | 21500.0 |
| 2009-06-24 | BMVP | ETF | 10.7 | 10.8041 | 10.4667 | 10.6833 | 36585.0 |
| 2009-06-24 | BND | ETF | 77.25 | 77.49 | 77.03 | 77.11 | 364400.0 |
| 2009-06-24 | BNE | ETF | 6.35 | 6.81 | 6.2 | 6.29 | 110753.0 |
| 2009-06-24 | BOSS | ETF | 14.85 | 14.88 | 14.85 | 14.88 | 300.0 |
| 2009-06-24 | BRF | ETF | 27.27 | 27.61 | 26.7901 | 27.18 | 212496.0 |
| 2009-06-24 | BSV | ETF | 78.87 | 79.02 | 78.75 | 78.92 | 171200.0 |
| 2009-06-24 | BTF | ETF | 45.9 | 46.5 | 45.655 | 45.949999999999996 | 3591.4 |
| 2009-06-24 | BWX | ETF | 27.21 | 27.3775 | 26.9155 | 26.97 | 233396.0 |
| 2009-06-24 | BWZ | ETF | 35.24 | 35.24 | 34.952 | 34.952 | 1768.0 |
| 2009-06-24 | BZQ | ETF | 9878.4 | 10246.4 | 9702.4 | 10152.0 | 23.25 |
| 2009-06-24 | CBON | ETF | 1.2 | 1.22 | 1.13 | 1.18 | 16332.0 |
| 2009-06-24 | CEF | ETF | 11.86 | 12.03 | 11.69 | 11.78 | 548700.0 |
| 2009-06-24 | CEW | ETF | 20.72 | 20.78 | 20.65 | 20.65 | 33600.0 |
| 2009-06-24 | CGO | ETF | 11.05 | 11.45 | 11.05 | 11.38 | 21606.0 |
| 2009-06-24 | CGW | ETF | 15.18 | 15.42 | 15.0 | 15.02 | 121598.0 |
| 2009-06-24 | CHB | ETF | 0.38 | 0.38 | 0.35 | 0.35 | 830834.0 |
| 2009-06-24 | CHI | ETF | 10.23 | 10.39 | 10.2 | 10.39 | 113825.0 |
| 2009-06-24 | CHIC | ETF | 11.88 | 12.19 | 11.671 | 11.95 | 138923.0 |
> showing 50 of 659 rows — these rows as CSV