PREVIEW / etf_daily / 2024-10-28
file: by_date/etf_daily/2024/2024-10-28.parquet size: 143 KB rows: 3,750
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-10-28 | SPY | ETF | 582.58 | 582.71 | 580.52 | 580.83 | 29976029.0 |
| 2024-10-28 | QQQ | ETF | 498.46 | 498.52 | 495.1 | 495.4 | 20477778.0 |
| 2024-10-28 | IWM | ETF | 220.79 | 222.97 | 220.48 | 222.46 | 19739136.0 |
| 2024-10-28 | DIA | ETF | 423.55 | 424.82 | 423.27 | 424.07 | 2788591.0 |
| 2024-10-28 | GLD | ETF | 253.01 | 253.63 | 252.95 | 253.33 | 4025576.0 |
| 2024-10-28 | TLT | ETF | 92.27 | 92.29 | 91.415 | 91.89 | 33086077.0 |
| 2024-10-28 | AAA | ETF | 25.16 | 25.1605 | 25.15 | 25.16 | 4954.0 |
| 2024-10-28 | AAAU | ETF | 27.09 | 27.1579 | 27.0836 | 27.125 | 1643485.0 |
| 2024-10-28 | AADR | ETF | 65.62 | 65.97 | 65.62 | 65.97 | 264.0 |
| 2024-10-28 | AAPB | ETF | 29.83 | 30.16 | 29.63 | 29.87 | 94812.0 |
| 2024-10-28 | AAPD | ETF | 16.445 | 16.51 | 16.352 | 16.46 | 264298.0 |
| 2024-10-28 | AAPR | ETF | 26.22 | 26.2201 | 26.21 | 26.2101 | 2394.0 |
| 2024-10-28 | AAPU | ETF | 37.75 | 38.19 | 37.49 | 37.81 | 330994.0 |
| 2024-10-28 | AAPX | ETF | 34.25 | 34.7999 | 34.25 | 34.33 | 14565.0 |
| 2024-10-28 | AAPY | ETF | 27.14 | 27.81 | 27.14 | 27.6922 | 1035.0 |
| 2024-10-28 | AAXJ | ETF | 77.18 | 77.6 | 77.05 | 77.4 | 1193802.0 |
| 2024-10-28 | ABCS | ETF | 28.4885 | 28.65 | 28.4885 | 28.5709 | 1410.0 |
| 2024-10-28 | ABEQ | ETF | 32.85 | 32.93 | 32.8301 | 32.9266 | 1797.0 |
| 2024-10-28 | ABNY | ETF | 81.9 | 82.45 | 81.75 | 82.1 | 1235.0 |
| 2024-10-28 | ACES | ETF | 28.24 | 28.64 | 28.24 | 28.27 | 67560.0 |
| 2024-10-28 | ACIO | ETF | 40.25 | 40.3614 | 40.1367 | 40.16 | 82264.0 |
| 2024-10-28 | ACSI | ETF | 58.7242 | 58.7242 | 58.7242 | 58.7242 | 6.0 |
| 2024-10-28 | ACT | ETF | 34.75 | 35.31 | 34.39 | 34.49 | 2207027.0 |
| 2024-10-28 | ACTV | ETF | 33.24 | 33.645 | 33.24 | 33.5838 | 4758.0 |
| 2024-10-28 | ACVF | ETF | 44.31 | 44.31 | 44.0987 | 44.0987 | 5827.0 |
| 2024-10-28 | ACWI | ETF | 119.5 | 119.66 | 119.36 | 119.44 | 1559306.0 |
| 2024-10-28 | ACWV | ETF | 113.32 | 113.4757 | 113.09 | 113.29 | 91557.0 |
| 2024-10-28 | ACWX | ETF | 55.33 | 55.62 | 55.28 | 55.55 | 1015443.0 |
| 2024-10-28 | ADFI | ETF | 8.55 | 8.6 | 8.52 | 8.6 | 14977.0 |
| 2024-10-28 | ADIV | ETF | 16.06 | 16.06 | 16.0205 | 16.0205 | 241.0 |
| 2024-10-28 | ADME | ETF | 46.85 | 46.85 | 46.63 | 46.66 | 9587.0 |
| 2024-10-28 | ADPV | ETF | 33.56 | 33.58 | 33.46 | 33.517 | 13697.0 |
| 2024-10-28 | ADVE | ETF | 34.9349 | 34.9349 | 34.9153 | 34.9153 | 285.0 |
| 2024-10-28 | AESR | ETF | 17.25 | 17.25 | 17.1805 | 17.1963 | 19716.0 |
| 2024-10-28 | AETH | ETF | 32.3 | 32.41 | 31.94 | 32.1099 | 33986.0 |
| 2024-10-28 | AFIF | ETF | 9.16 | 9.16 | 9.14 | 9.14 | 10713.0 |
| 2024-10-28 | AFK | ETF | 16.87 | 16.99 | 16.85 | 16.99 | 11863.0 |
| 2024-10-28 | AFLG | ETF | 34.39 | 34.39 | 34.3 | 34.33 | 27071.0 |
| 2024-10-28 | AFMC | ETF | 32.1653 | 32.1653 | 32.1116 | 32.15 | 2673.0 |
| 2024-10-28 | AFSM | ETF | 30.5831 | 30.6 | 30.56 | 30.57 | 4390.0 |
| 2024-10-28 | AGG | ETF | 98.64 | 98.65 | 98.2946 | 98.43 | 7358356.0 |
| 2024-10-28 | AGGH | ETF | 20.67 | 20.84 | 20.67 | 20.7 | 52064.0 |
| 2024-10-28 | AGGS | ETF | 41.37 | 41.37 | 41.31 | 41.3551 | 400.0 |
| 2024-10-28 | AGGY | ETF | 43.61 | 43.61 | 43.4174 | 43.525 | 67674.0 |
| 2024-10-28 | AGIH | ETF | 24.6 | 24.6 | 24.6 | 24.6 | 2.0 |
| 2024-10-28 | AGIX | ETF | 26.61 | 26.61 | 26.415 | 26.415 | 11308.0 |
| 2024-10-28 | AGMI | ETF | 31.66 | 31.95 | 31.66 | 31.8227 | 365.0 |
| 2024-10-28 | AGNG | ETF | 32.41 | 32.63 | 32.2725 | 32.59 | 10385.0 |
| 2024-10-28 | AGOX | ETF | 28.8 | 29.705 | 28.8 | 29.1 | 32290.0 |
| 2024-10-28 | AGQ | ETF | 46.59 | 47.52 | 46.39 | 46.68 | 1895420.0 |
> showing 50 of 3,750 rows — these rows as CSV