PREVIEW / etf_daily / 2024-10-24
file: by_date/etf_daily/2024/2024-10-24.parquet size: 142 KB rows: 3,742
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-24 | SPY | ETF | 579.98 | 580.06 | 576.57 | 579.24 | 34878965.0 |
| 2024-10-24 | QQQ | ETF | 492.11 | 493.0 | 489.44 | 492.32 | 22024930.0 |
| 2024-10-24 | IWM | ETF | 220.43 | 221.04 | 218.525 | 219.72 | 18353033.0 |
| 2024-10-24 | DIA | ETF | 424.32 | 424.67 | 421.94 | 423.78 | 1932763.0 |
| 2024-10-24 | GLD | ETF | 253.27 | 253.32 | 251.4 | 252.8 | 5957639.0 |
| 2024-10-24 | TLT | ETF | 92.23 | 93.0 | 91.96 | 92.66 | 32209293.0 |
| 2024-10-24 | AAA | ETF | 25.13 | 25.13 | 25.1 | 25.1205 | 8111.0 |
| 2024-10-24 | AAAU | ETF | 27.12 | 27.12 | 26.915 | 27.06 | 2753200.0 |
| 2024-10-24 | AADR | ETF | 65.4921 | 65.4921 | 65.4921 | 65.4921 | 105.0 |
| 2024-10-24 | AAPB | ETF | 29.07 | 29.1866 | 28.65 | 29.16 | 111173.0 |
| 2024-10-24 | AAPD | ETF | 16.69 | 16.8 | 16.6299 | 16.65 | 159540.0 |
| 2024-10-24 | AAPR | ETF | 26.21 | 26.24 | 26.19 | 26.235 | 10020.0 |
| 2024-10-24 | AAPU | ETF | 36.73 | 36.97 | 36.21 | 36.89 | 320759.0 |
| 2024-10-24 | AAPX | ETF | 33.41 | 33.67 | 33.2 | 33.56 | 11212.0 |
| 2024-10-24 | AAPY | ETF | 27.2 | 27.3732 | 27.2 | 27.3732 | 736.0 |
| 2024-10-24 | AAXJ | ETF | 77.33 | 77.38 | 76.84 | 77.15 | 557944.0 |
| 2024-10-24 | ABCS | ETF | 28.43 | 28.46 | 28.37 | 28.38 | 2205.0 |
| 2024-10-24 | ABEQ | ETF | 33.2 | 33.2 | 32.9318 | 33.0239 | 8949.0 |
| 2024-10-24 | ABNY | ETF | 80.15 | 80.8 | 80.1 | 80.425 | 868.0 |
| 2024-10-24 | ACES | ETF | 27.67 | 27.9 | 27.42 | 27.73 | 1343541.0 |
| 2024-10-24 | ACIO | ETF | 40.07 | 40.15 | 40.0 | 40.11 | 150656.0 |
| 2024-10-24 | ACSI | ETF | 58.4475 | 58.4475 | 58.4475 | 58.4475 | 7.0 |
| 2024-10-24 | ACT | ETF | 35.68 | 35.74 | 35.295 | 35.42 | 172940.0 |
| 2024-10-24 | ACTV | ETF | 33.34 | 33.34 | 33.1 | 33.1921 | 11727.0 |
| 2024-10-24 | ACVF | ETF | 44.27 | 44.27 | 44.08 | 44.14 | 2765.0 |
| 2024-10-24 | ACWI | ETF | 119.26 | 119.28 | 118.54 | 119.03 | 2930908.0 |
| 2024-10-24 | ACWV | ETF | 113.78 | 113.84 | 113.48 | 113.59 | 55784.0 |
| 2024-10-24 | ACWX | ETF | 55.42 | 55.455 | 55.06 | 55.32 | 609782.0 |
| 2024-10-24 | ADFI | ETF | 8.555 | 8.58 | 8.55 | 8.58 | 7234.0 |
| 2024-10-24 | ADIV | ETF | 16.0 | 16.005 | 16.0 | 16.005 | 553.0 |
| 2024-10-24 | ADME | ETF | 46.55 | 46.64 | 46.48 | 46.62 | 15789.0 |
| 2024-10-24 | ADPV | ETF | 33.08 | 33.203 | 33.0339 | 33.203 | 20786.0 |
| 2024-10-24 | ADVE | ETF | 34.7616 | 34.7616 | 34.7616 | 34.7616 | 21.0 |
| 2024-10-24 | AESR | ETF | 17.13 | 17.17 | 17.09 | 17.13 | 9784.0 |
| 2024-10-24 | AETH | ETF | 32.3939 | 32.4845 | 32.165 | 32.4699 | 8119.0 |
| 2024-10-24 | AFIF | ETF | 9.13 | 9.155 | 9.13 | 9.15 | 17493.0 |
| 2024-10-24 | AFK | ETF | 17.08 | 17.08 | 16.71 | 16.94 | 10532.0 |
| 2024-10-24 | AFLG | ETF | 34.35 | 34.36 | 34.18 | 34.2878 | 5267.0 |
| 2024-10-24 | AFMC | ETF | 32.045 | 32.045 | 32.0277 | 32.0277 | 861.0 |
| 2024-10-24 | AFSM | ETF | 30.466 | 30.4999 | 30.259 | 30.3 | 4742.0 |
| 2024-10-24 | AGG | ETF | 98.68 | 98.95 | 98.6 | 98.79 | 7556937.0 |
| 2024-10-24 | AGGH | ETF | 20.89 | 20.97 | 20.86 | 20.88 | 101360.0 |
| 2024-10-24 | AGGS | ETF | 41.5004 | 41.56 | 41.4852 | 41.4852 | 4816.0 |
| 2024-10-24 | AGGY | ETF | 43.77 | 43.88 | 43.72 | 43.82 | 69619.0 |
| 2024-10-24 | AGIH | ETF | 24.74 | 24.74 | 24.74 | 24.74 | 1.0 |
| 2024-10-24 | AGIX | ETF | 26.14 | 26.16 | 26.07 | 26.16 | 816.0 |
| 2024-10-24 | AGMI | ETF | 32.2433 | 32.2433 | 32.2433 | 32.2433 | 148.0 |
| 2024-10-24 | AGNG | ETF | 32.44 | 32.53 | 32.41 | 32.45 | 4487.0 |
| 2024-10-24 | AGOX | ETF | 28.85 | 28.85 | 28.4801 | 28.54 | 8080.0 |
| 2024-10-24 | AGQ | ETF | 48.16 | 48.29 | 45.46 | 46.6 | 2084067.0 |
> showing 50 of 3,742 rows — these rows as CSV