PREVIEW / etf_daily / 2024-07-17
file: by_date/etf_daily/2024/2024-07-17.parquet size: 131 KB rows: 3,432
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-17 | SPY | ETF | 558.8 | 560.51 | 556.61 | 556.94 | 56289830.0 |
| 2024-07-17 | QQQ | ETF | 488.28 | 488.7984 | 481.7 | 481.77 | 56268768.0 |
| 2024-07-17 | IWM | ETF | 222.36 | 226.64 | 221.66 | 222.25 | 66909094.0 |
| 2024-07-17 | DIA | ETF | 408.56 | 412.34 | 408.56 | 411.93 | 4478530.0 |
| 2024-07-17 | GLD | ETF | 228.79 | 229.65 | 226.67 | 227.23 | 8649248.0 |
| 2024-07-17 | TLT | ETF | 93.92 | 94.4 | 93.69 | 94.19 | 28983180.0 |
| 2024-07-17 | AAA | ETF | 25.11 | 25.1199 | 25.06 | 25.11 | 5353.0 |
| 2024-07-17 | AAAU | ETF | 24.475 | 24.5654 | 24.25 | 24.31 | 1709591.0 |
| 2024-07-17 | AADR | ETF | 62.4 | 62.4938 | 61.99 | 62.355 | 2063.0 |
| 2024-07-17 | AAPB | ETF | 29.92 | 30.37 | 29.17 | 29.72 | 191417.0 |
| 2024-07-17 | AAPD | ETF | 16.72 | 16.9447 | 16.6201 | 16.79 | 324424.0 |
| 2024-07-17 | AAPR | ETF | 25.58 | 25.58 | 25.49 | 25.55 | 12158.0 |
| 2024-07-17 | AAPU | ETF | 38.34 | 38.96 | 37.35 | 38.11 | 1345557.0 |
| 2024-07-17 | AAPX | ETF | 34.78 | 35.339 | 33.87 | 34.52 | 40670.0 |
| 2024-07-17 | AAPY | ETF | 27.57 | 27.59 | 27.5498 | 27.5498 | 1042.0 |
| 2024-07-17 | AAXJ | ETF | 73.74 | 73.905 | 73.385 | 73.42 | 1264483.0 |
| 2024-07-17 | ABCS | ETF | 27.5427 | 27.5427 | 27.3993 | 27.3993 | 1300.0 |
| 2024-07-17 | ABEQ | ETF | 31.3537 | 31.49 | 31.3537 | 31.471 | 2716.0 |
| 2024-07-17 | ABNY | ETF | 100.25 | 102.95 | 100.25 | 101.687 | 1426.0 |
| 2024-07-17 | ACES | ETF | 31.51 | 32.01 | 30.82 | 30.98 | 61167.0 |
| 2024-07-17 | ACIO | ETF | 38.58 | 38.62 | 38.47 | 38.52 | 94207.0 |
| 2024-07-17 | ACSI | ETF | 56.5811 | 56.5811 | 56.5811 | 56.5811 | 27.0 |
| 2024-07-17 | ACT | ETF | 33.04 | 33.64 | 32.94 | 33.45 | 242738.0 |
| 2024-07-17 | ACTV | ETF | 33.71 | 34.0334 | 33.71 | 33.869 | 5580.0 |
| 2024-07-17 | ACVF | ETF | 42.55 | 42.55 | 42.1601 | 42.18 | 11250.0 |
| 2024-07-17 | ACWI | ETF | 115.63 | 115.93 | 115.155 | 115.22 | 2736846.0 |
| 2024-07-17 | ACWV | ETF | 107.46 | 108.39 | 107.46 | 108.23 | 112853.0 |
| 2024-07-17 | ACWX | ETF | 54.81 | 54.97 | 54.66 | 54.7 | 476745.0 |
| 2024-07-17 | ADFI | ETF | 8.59 | 8.59 | 8.55 | 8.59 | 8714.0 |
| 2024-07-17 | ADIV | ETF | 14.7524 | 14.7524 | 14.7524 | 14.7524 | 217.0 |
| 2024-07-17 | ADME | ETF | 44.89 | 44.92 | 44.7 | 44.738 | 8660.0 |
| 2024-07-17 | ADPV | ETF | 31.44 | 31.44 | 31.0831 | 31.0831 | 1937.0 |
| 2024-07-17 | AEMB | ETF | 38.94 | 38.94 | 38.68 | 38.8039 | 205.0 |
| 2024-07-17 | AESR | ETF | 16.61 | 16.61 | 16.45 | 16.4534 | 12277.0 |
| 2024-07-17 | AETH | ETF | 45.01 | 45.32 | 44.375 | 44.7322 | 5530.0 |
| 2024-07-17 | AFIF | ETF | 9.16 | 9.1845 | 9.14 | 9.1845 | 28038.0 |
| 2024-07-17 | AFK | ETF | 16.51 | 16.61 | 16.4 | 16.4904 | 7136.0 |
| 2024-07-17 | AFLG | ETF | 32.4999 | 32.4999 | 32.3579 | 32.3579 | 769.0 |
| 2024-07-17 | AFMC | ETF | 31.219 | 31.219 | 30.7472 | 30.7472 | 2574.0 |
| 2024-07-17 | AFSM | ETF | 31.15 | 31.15 | 30.29 | 30.4 | 37232.0 |
| 2024-07-17 | AFTY | ETF | 14.41 | 14.41 | 14.3759 | 14.3946 | 1493.0 |
| 2024-07-17 | AGG | ETF | 98.26 | 98.57 | 98.23 | 98.52 | 5595443.0 |
| 2024-07-17 | AGGH | ETF | 21.21 | 21.27 | 21.11 | 21.27 | 156543.0 |
| 2024-07-17 | AGGS | ETF | 41.48 | 41.48 | 41.455 | 41.455 | 107.0 |
| 2024-07-17 | AGGY | ETF | 43.57 | 43.72 | 43.57 | 43.69 | 61044.0 |
| 2024-07-17 | AGMI | ETF | 29.26 | 29.26 | 28.7781 | 28.7781 | 242.0 |
| 2024-07-17 | AGNG | ETF | 31.34 | 31.34 | 31.34 | 31.34 | 510.0 |
| 2024-07-17 | AGOX | ETF | 28.42 | 28.42 | 28.09 | 28.24 | 45340.0 |
| 2024-07-17 | AGQ | ETF | 41.53 | 41.8592 | 39.11 | 39.76 | 2539888.0 |
| 2024-07-17 | AGQI | ETF | 14.6401 | 14.65 | 14.62 | 14.6247 | 10308.0 |
> showing 50 of 3,432 rows — these rows as CSV